m (1 revision imported: Some parameters changed for consistent camelCase usage) |
|||
Line 1: | Line 1: | ||
= Table RESOURCE_STATE_REASON = | = Table RESOURCE_STATE_REASON = | ||
+ | {{PDMColumn | ||
+ | |colName=RESOURCE_STATE_REASON_KEY | ||
+ | |colDesc=The primary key of this table and the surrogate key that is used to join this dimension 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=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=REASON_TYPE | ||
+ | |colDesc=The type of the reason--either Hardware or Software. This value can change with localization. | ||
+ | }} | ||
+ | |||
+ | {{PDMColumn | ||
+ | |colName=REASON_TYPE_CODE | ||
+ | |colDesc=The reason type code--either HARDWARE or SOFTWARE. This value does not change with localization. | ||
+ | }} | ||
+ | |||
+ | {{PDMColumn | ||
+ | |colName=HARDWARE_REASON | ||
+ | |colDesc=The hardware reason. | ||
+ | }} | ||
+ | |||
+ | {{PDMColumn | ||
+ | |colName=SOFTWARE_REASON_KEY | ||
+ | |colDesc=The key name with which the software reason was attached. | ||
+ | }} | ||
+ | |||
+ | {{PDMColumn | ||
+ | |colName=SOFTWARE_REASON_VALUE | ||
+ | |colDesc=The value with which the software reason was attached. | ||
+ | }} | ||
+ | |||
+ | {{PDMColumn | ||
+ | |colName=WORKMODE | ||
+ | |colDesc=The work mode. This field is set to one of the following values: | ||
+ | |||
+ | - AgentWorkModeUnknown | ||
+ | - AgentManualIn | ||
+ | - AgentAutoIn | ||
+ | - AgentLegalGuard | ||
+ | - AgentAfterCallWork | ||
+ | - AgentAuxWork | ||
+ | - AgentWalkAway | ||
+ | - AgentReturnBack | ||
+ | |||
+ | This value can change with localization. | ||
+ | }} | ||
+ | |||
+ | {{PDMColumn | ||
+ | |colName=WORKMODE_CODE | ||
+ | |colDesc=The work mode code. This field is set to one of the following values: | ||
+ | |||
+ | - AGENT_WORK_MODE_UNKNOWN | ||
+ | - AGENT_MANUAL_IN | ||
+ | - AGENT_AUTO_IN | ||
+ | - AGENT_LEGAL_GUARD | ||
+ | - AGENT_AFTER_CALL_WORK | ||
+ | - AGENT_AUX_WORK | ||
+ | - AGENT_WALK_AWAY | ||
+ | - AGENT_RETURN_BACK | ||
+ | |||
+ | This value does not change with localization. | ||
+ | }} | ||
+ | |||
+ | {{PDMColumn | ||
+ | |colName=PURGE_FLAG | ||
+ | |colDesc=This field is reserved. | ||
+ | }} | ||
[[Category:V:GIM:8.5DRAFT]] | [[Category:V:GIM:8.5DRAFT]] |
Revision as of 22:03, May 5, 2016
Table RESOURCE_STATE_REASON
Comments or questions about this documentation? Contact us for support!