Jump to: navigation, search
m (1 revision imported: Some parameters changed for consistent camelCase usage)
Line 1: Line 1:
 
= Table RESOURCE_STATE =
 
= Table RESOURCE_STATE =
  
 +
{{PDMColumn
 +
|colName=RESOURCE_STATE_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=STATE_TYPE
 +
|colDesc=The media-neutral resource state. This field is set to one of the following values:
 +
 +
- Unknown
 +
- Ready
 +
- WorkingReady
 +
- NotReady
 +
- WorkingNotReady
 +
 +
This value can change with localization.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=STATE_TYPE_CODE
 +
|colDesc=The code for the media-neutral resource state. This field is set to one of the following values:
 +
 +
- UNKNOWN
 +
- READY
 +
- WORKINGREADY
 +
- NOTREADY
 +
- WORKINGNOTREADY
 +
 +
This value does not change with localization.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=STATE_NAME
 +
|colDesc=The media-specific or detailed resource state. This value can change with localization.
 +
 +
The possible voice and multimedia values (sourced from IDB) are the following: 
 +
 +
- Unknown
 +
- Busy
 +
- Ready
 +
- NotReady
 +
- AfterCallWork (voice only) 
 +
- LoggedOnOnly
 +
 +
The following media-specific values are part of this dimension for voice media, but they are not used in Genesys Info Mart 8.x:
 +
 +
- WaitForNextCall
 +
- OffHook
 +
- CallDialing
 +
- CallRinging
 +
- NotReadyForNextCall
 +
- AfterCallWork
 +
- CallOnHold
 +
- CallUnknown
 +
- CallConsult
 +
- CallInternal
 +
- CallOutbound
 +
- CallInbound
 +
}}
 +
 +
{{PDMColumn
 +
|colName=STATE_NAME_CODE
 +
|colDesc=The media-specific or detailed resource state code. This value does not change with localization.
 +
 +
The possible voice and multimedia values (sourced from IDB) are the following: 
 +
 +
- UNKNOWN
 +
- BUSY
 +
- READY
 +
- NOTREADY
 +
- AFTERCALLWORK (voice only) 
 +
- LOGGEDONONLY
 +
 +
The following media-specific values are part of this dimension for voice media, but they are not used in Genesys Info Mart 8.x:
 +
 +
- WAITFORNEXTCALL
 +
- OFFHOOK
 +
- CALLDIALING
 +
- CALLRINGING
 +
- NOTREADYFORNEXTCALL
 +
- AFTERCALLWORK
 +
- CALLONHOLD
 +
- CALLUNKNOWN
 +
- CALLCONSULT
 +
- CALLINTERNAL
 +
- CALLOUTBOUND
 +
- CALLINBOUND
 +
}}
 +
 +
{{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 22:02, May 5, 2016

Table RESOURCE_STATE

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