Jump to: navigation, search
m (1 revision imported: Some parameters changed for consistent camelCase usage)
Line 1: Line 1:
 
= Table WORKBIN =
 
= Table WORKBIN =
  
 +
{{PDMColumn
 +
|colName=WORKBIN_KEY
 +
|colDesc=The primary key of this table and the surrogate key that is used to join this dimension to the MSF table.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=WORKBIN_TYPE
 +
|colDesc=The type of workbin. This field is set to one of the following values:
 +
 +
- 1 (Agent)
 +
- 2 (Place)
 +
- 3 (AgentGroup)
 +
- 4 (PlaceGroup)
 +
}}
 +
 +
{{PDMColumn
 +
|colName=WORKBIN_TYPE_CODE
 +
|colDesc=The code of the workbin type. This field is set to one of the following values:
 +
 +
- AGENT
 +
- PLACE
 +
- AGENTGROUP
 +
- PLACEGROUP
 +
}}
 +
 +
{{PDMColumn
 +
|colName=WORKBIN_RESOURCE_KEY
 +
|colDesc=The surrogate key that is used to reference a workbin record in the RESOURCE_ table, to identify the specific Interaction Workbin of which this workbin is an instance.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=OWNER_KEY
 +
|colDesc=The surrogate key that is used to reference one of the following, to identify the owner of the workbin instance:
 +
 +
o If the type of workbin is Agent, an agent record in the RESOURCE_ table
 +
o If the type of workbin is Place, a place record in the PLACE_ view
 +
o If the type of workbin is AgentGroup or PlaceGroup, a group record in the GROUP_ view
 +
}}
 +
 +
{{PDMColumn
 +
|colName=CREATE_AUDIT_KEY
 +
|colDesc=The surrogate key used to join to the CTL_AUDIT_LOG dimension. 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 22:14, May 5, 2016

Table WORKBIN

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