m (1 revision imported: Some parameters changed for consistent camelCase usage) |
|||
Line 1: | Line 1: | ||
= Table REQUESTED_SKILL_COMBINATION = | = Table REQUESTED_SKILL_COMBINATION = | ||
+ | {{PDMColumn | ||
+ | |colName=SKILL_COMBINATION_KEY | ||
+ | |colDesc=This is the primary key of this table and the surrogate key that is used to join the REQUESTED_SKILL dimension table to the fact tables. | ||
+ | }} | ||
+ | |||
+ | {{PDMColumn | ||
+ | |colName=TENANT_KEY | ||
+ | |colDesc=The surrogate key that is used to join the TENANT dimension to the fact tables. | ||
+ | }} | ||
+ | |||
+ | {{PDMColumn | ||
+ | |colName=SKILL_COMBINATION_STRING | ||
+ | |colDesc=A single string representation of all skills and proficiencies that are requested by the interaction. | ||
+ | }} | ||
+ | |||
+ | {{PDMColumn | ||
+ | |colName=SKILL_COMBINATION_AUX_KEY | ||
+ | |colDesc=This field is internal. | ||
+ | }} | ||
+ | |||
+ | {{PDMColumn | ||
+ | |colName=SKILL_COUNT | ||
+ | |colDesc=The count of the number of requested skills. | ||
+ | }} | ||
+ | |||
+ | {{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. | ||
+ | }} | ||
+ | |||
+ | {{PDMColumn | ||
+ | |colName=PURGE_FLAG | ||
+ | |colDesc=This field is reserved. | ||
+ | }} | ||
[[Category:V:GIM:8.5DRAFT]] | [[Category:V:GIM:8.5DRAFT]] |
Revision as of 20:18, May 5, 2016
Table REQUESTED_SKILL_COMBINATION
Comments or questions about this documentation? Contact us for support!