Transaction Work Area Attributes

Contents
casm173
Contents
The Transaction Work Area (twa) tables are:
  • ci_twa_ci
    A single table that includes all attributes across all CA CMDB families. Table data is stored in denormalized form to enable customers and services to understand and manipulate the content more easily.
  • ci_twa_relation
    Complements the ci_twa_ci table. Contains relationship information.
  • ci_twa_statusnames
    Descriptive labels for row status.
External processes update these tables and GRLoader reads them during transaction processing. When processing is complete, GRLoader updates the row_status and tran_message columns to indicate whether the transaction has completed successfully.
If multiple errors or warnings occur, the messages are concatenated.
ci_twa_ci Attributes
The ci_twa_ci table contains attributes for CI transactions.
Column Name
Notes
id
Transaction identifier
last_mod_dt
Sets the current date every time the row is added or updated.
tran_dt
Sets the current date and time if no value is supplied when row is added.
creation_date
Sets the current date and time when row is added.
delete_flag
Sets to zero (0) if no other value is supplied when row is added.
tran_status
Sets to zero (0) if no other value is supplied when row is added.
ci_twa_relation Attributes
The ci_twa_relation table contains attributes for relationship transactions.
Column Name
Notes
id
Transaction identifier
last_mod_dt
Sets the current date every time the row is added or updated.
tran_dt
Sets the current date and time if no value is supplied when row is added.
creation_date
Sets the current date and time when row is added.
delete_flag
Sets to zero (0) if no other value is supplied when row is added.
tran_status
Set to zero (0) if no other value is supplied when row is added.