Managing Configuration Items › Manage Staged Transactions › 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.