Jump to: navigation, search
m (1 revision imported: Some parameters changed for consistent camelCase usage)
Line 1: Line 1:
 
= Table RECORD_STATUS =
 
= Table RECORD_STATUS =
  
 +
{{PDMColumn
 +
|colName=RECORD_STATUS_KEY
 +
|colDesc=The surrogate key that is used to join this dimension table to the fact tables.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=RECORD_STATUS
 +
|colDesc=The description of the record status. This field is set to one of the following values:
 +
 +
- No Record Status
 +
- Ready
 +
- Retrieved
 +
- Updated
 +
- Stale
 +
- Cancelled
 +
- Agent Error
 +
- Chain Updated
 +
- Missed Callback
 +
- Chain Ready
 +
 +
This value can change with localization.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=RECORD_STATUS_CODE
 +
|colDesc=The code of the record status description that is stored in the RECORD_STATUS column. This field is set to one of the following values:
 +
 +
- NO_RECORD_STATUS
 +
- READY
 +
- RETRIEVED
 +
- UPDATED
 +
- STALE
 +
- CANCELLED
 +
- AGENT_ERROR
 +
- CHAIN_UPDATED
 +
- MISSED_CALLBACK
 +
- CHAIN_READY
 +
 +
This value does not change with localization.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=CREATE_AUDIT_KEY
 +
|colDesc=The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data creation. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools--that is, applications that need to identify newly added data.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=UPDATE_AUDIT_KEY
 +
|colDesc=The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data update. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools--that is, applications that need to identify recently modified data.
 +
}}
  
 
[[Category:V:GIM:8.5DRAFT]]
 
[[Category:V:GIM:8.5DRAFT]]

Revision as of 14:37, May 5, 2016

Table RECORD_STATUS

Comments or questions about this documentation? Contact us for support!