Managing Configuration Items › Stage CI Transactions Before Loading into CMDB › Populating the TWA › How to Use SQL to Update Data into the TWA › CI Identifiers in the TWA

CI Identifiers in the TWA

In the ci_twa_ci table, three identifiers are associated with a CI transaction: ID, tgt_id, and superseded_by, These attributes are:

• ID is the transaction sequence number. Do not modify this field. IDs 1-2,000,000,000 are reserved for use by systems that modify the TWA outside the CA SDM server. IDs from 2,000,000,001 to approximately 4 billion are reserved for use by CA SDM. When the system runs out of IDs, reinitialize the table.
• tgt_id, provider_id, or dependent_id are the UUID of the target CI. Set this field whenever you perform manual reconciliation.
• superseded_by is the UUID of the superseding CI. Set this field whenever you manually designate the superseding CI for the transaction.