In the Column List:
- P = Primary key
- M = Mandatory field
- F = Foreign key (where the term is used loosely to indicate a surrogate key reference to a field in another table, not a formal constraint)
- DV = Default value
- In the Data Type column, varchar/nvarchar means that the data type is varchar except in multi-language databases that use Unicode, in which case the data type is nvarchar. (The Info Mart database in Cloud deployments is not multi-language.) THIS BULLET DISPLAYS ONLY IN THE MSSQL AND CLOUD PDMs.
m (1 revision imported: Baseline content populated by import from Mykola) |
(Modified comment string {{PONYDOCSVERSION}} with {{#explode:{{FULLPAGENAME}}|:|4}}) |
||
(43 intermediate revisions by 2 users not shown) | |||
Line 2: | Line 2: | ||
<onlyinclude> | <onlyinclude> | ||
− | |||
{{PDMTable | {{PDMTable | ||
|tableName = TECHNICAL_DESCRIPTOR | |tableName = TECHNICAL_DESCRIPTOR | ||
− | |shortDesc = | + | |shortDesc = Allows facts to be described by the role of the associated contact center resource and the technical result of the association. |
− | |tableDesc = | + | |tableDesc = This table allows interaction-based facts to be described by the role of the associated resource and the technical result of the interaction or the interaction-based fact. For example, a queue resource received an interaction and diverted to another resource. Each row describes one distinct combination of attributes. |
− | |subjectAreas = | + | |
+ | For detailed information about the available technical descriptor combinations, see {{SwitchForCloud|PSAAS=[[Documentation:PSAAS:RPRT:GIMTechDescr:Public|Technical Descriptors]].|GIM=[[Documentation:GIM:User:GIMTechDescr:{{#explode:{{FULLPAGENAME}}|:|4}}|Technical Descriptors]] in the ''Genesys Info Mart User's Guide.''}} | ||
+ | |subjectAreas = Interaction_Resource,Mediation_Segment | ||
|introduced = | |introduced = | ||
− | |modified = | + | |modified = 8.5.003 (in Oracle, fields with <tt>VARCHAR</tt> data types use explicit <tt>CHAR</tt> character-length semantics) |
|discontinued = | |discontinued = | ||
|group = | |group = | ||
+ | |dataExport = yes | ||
|partitioned = | |partitioned = | ||
}} | }} | ||
Line 22: | Line 24: | ||
|primaryKey = yes | |primaryKey = yes | ||
|mandatory = yes | |mandatory = yes | ||
− | |foreignKey = | + | |foreignKey = |
|default = | |default = | ||
|colDesc = The surrogate key that is used to join this dimension table to the fact tables. | |colDesc = The surrogate key that is used to join this dimension table to the fact tables. | ||
Line 33: | Line 35: | ||
|colName = TECHNICAL_RESULT | |colName = TECHNICAL_RESULT | ||
|dataType_Ora = VARCHAR2(255 CHAR) | |dataType_Ora = VARCHAR2(255 CHAR) | ||
− | |dataType_MSSQL = varchar(255) | + | |dataType_MSSQL = varchar(255)/nvarchar(255) |
|dataType_Postgre = varchar(255) | |dataType_Postgre = varchar(255) | ||
|primaryKey = | |primaryKey = | ||
Line 39: | Line 41: | ||
|foreignKey = | |foreignKey = | ||
|default = | |default = | ||
− | |colDesc = The technical result of the handling | + | |colDesc = The technical result of the handling attempt—that is, how the attempt ended. This field is set to one of the following values: |
− | + | {{ColumnFormat|cols=3|content= | |
− | + | * Abandoned | |
− | + | * AbnormalStop | |
− | + | * Cleared | |
− | + | * Completed | |
− | + | * Conferenced | |
− | + | * CustomerAbandoned | |
− | + | * Deferred | |
− | + | * DestinationBusy | |
− | + | * Diverted | |
− | + | * Incomplete | |
− | + | * None | |
− | + | * OutboundStopped | |
− | + | * Pulled | |
− | + | * Redirected | |
− | + | * Routed | |
+ | * Transferred | ||
+ | * Unspecified}} | ||
This value can change with localization. | This value can change with localization. | ||
Line 66: | Line 70: | ||
|colName = TECHNICAL_RESULT_CODE | |colName = TECHNICAL_RESULT_CODE | ||
|dataType_Ora = VARCHAR2(32 CHAR) | |dataType_Ora = VARCHAR2(32 CHAR) | ||
− | |dataType_MSSQL = varchar(32) | + | |dataType_MSSQL = varchar(32)/nvarchar(32) |
|dataType_Postgre = varchar(32) | |dataType_Postgre = varchar(32) | ||
|primaryKey = | |primaryKey = | ||
Line 72: | Line 76: | ||
|foreignKey = | |foreignKey = | ||
|default = | |default = | ||
− | |colDesc = The technical result code of the handling | + | |colDesc = The technical result code of the handling attempt—that is, how the attempt ended. This field is set to one of the following values: |
− | + | {{ColumnFormat|cols=3|content= | |
− | + | * ABANDONED | |
− | + | * ABNORMALSTOP | |
− | + | * CLEARED | |
− | + | * COMPLETED | |
− | + | * CONFERENCED | |
− | + | * CUSTOMERABANDONED | |
− | + | * DEFERRED | |
− | + | * DESTINATIONBUSY | |
− | + | * DIVERTED | |
− | + | * INCOMPLETE | |
− | + | * NONE | |
− | + | * OUTBOUNDSTOPPED | |
− | + | * PULLED | |
− | + | * REDIRECTED | |
− | + | * ROUTED | |
+ | * TRANSFERRED | ||
+ | * UNSPECIFIED}} | ||
This value does not change with localization. | This value does not change with localization. | ||
Line 99: | Line 105: | ||
|colName = RESULT_REASON | |colName = RESULT_REASON | ||
|dataType_Ora = VARCHAR2(255 CHAR) | |dataType_Ora = VARCHAR2(255 CHAR) | ||
− | |dataType_MSSQL = varchar(255) | + | |dataType_MSSQL = varchar(255)/nvarchar(255) |
|dataType_Postgre = varchar(255) | |dataType_Postgre = varchar(255) | ||
|primaryKey = | |primaryKey = | ||
Line 106: | Line 112: | ||
|default = | |default = | ||
|colDesc = The reason for the technical result. This field is set to one of the following values: | |colDesc = The reason for the technical result. This field is set to one of the following values: | ||
− | + | {{ColumnFormat|cols=3|content= | |
− | + | * AbandonedFromHold | |
− | + | * AbandonedWhileQueued | |
− | + | * AbandonedWhileRinging | |
− | + | * AbnormalStopWhileQueued | |
− | + | * AbnormalStopWhileRinging | |
− | + | * AnsweredByAgent | |
− | + | * AnsweredByOther | |
− | + | * Archived | |
− | + | * CallbackAccepted | |
− | + | * Canceled | |
− | + | * DefaultRoutedByStrategy | |
− | + | * DefaultRoutedBySwitch | |
− | + | * IntroducedTransfer | |
− | + | * PulledBack (starting with release 8.1.4) or PulledBackTimeout (in releases earlier than 8.1.4) | |
− | + | * Redirected | |
− | + | * Rejected | |
− | + | * Revoked | |
− | + | * RoutedFromAnotherVQ | |
− | + | * RoutedToOther | |
− | + | * RouteOnNoAnswer | |
− | + | * Stopped | |
− | + | * StuckCall | |
+ | * TargetsCleared | ||
+ | * Unspecified}} | ||
This value can change with localization. | This value can change with localization. | ||
Line 139: | Line 147: | ||
|colName = RESULT_REASON_CODE | |colName = RESULT_REASON_CODE | ||
|dataType_Ora = VARCHAR2(32 CHAR) | |dataType_Ora = VARCHAR2(32 CHAR) | ||
− | |dataType_MSSQL = varchar(32) | + | |dataType_MSSQL = varchar(32)/nvarchar(32) |
|dataType_Postgre = varchar(32) | |dataType_Postgre = varchar(32) | ||
|primaryKey = | |primaryKey = | ||
Line 146: | Line 154: | ||
|default = | |default = | ||
|colDesc = The reason code for the technical result. This field is set to one of the following values: | |colDesc = The reason code for the technical result. This field is set to one of the following values: | ||
− | + | {{ColumnFormat|cols=3|content= | |
− | + | * ABANDONEDFROMHOLD | |
− | + | * ABANDONEDWHILEQUEUED | |
− | + | * ABANDONEDWHILERINGING | |
− | + | * ABNORMALSTOPWHILEQUEUED | |
− | + | * ABNORMALSTOPWHILERINGING | |
− | + | * ANSWEREDBYAGENT | |
− | + | * ANSWEREDBYOTHER | |
− | + | * ARCHIVED | |
− | + | * CALLBACKACCEPTED | |
− | + | * CANCELED | |
− | + | * DEFAULTROUTEDBYSTRATEGY | |
− | + | * DEFAULTROUTEDBYSWITCH | |
− | + | * INTRODUCEDTRANSFER | |
− | + | * PULLEDBACK (starting with release 8.1.4) or PULLEDBACKTIMEOUT (in releases earlier than 8.1.4) | |
− | + | * REDIRECTED | |
− | + | * REJECTED | |
− | + | * REVOKED | |
− | + | * ROUTEDFROMANOTHERVQ | |
− | + | * ROUTEDTOOTHER | |
− | + | * ROUTEONNOANSWER | |
− | + | * STOPPED | |
− | + | * STUCKCALL | |
+ | * TARGETSCLEARED | ||
+ | * UNSPECIFIED}} | ||
This value does not change with localization. | This value does not change with localization. | ||
Line 179: | Line 189: | ||
|colName = RESOURCE_ROLE | |colName = RESOURCE_ROLE | ||
|dataType_Ora = VARCHAR2(255 CHAR) | |dataType_Ora = VARCHAR2(255 CHAR) | ||
− | |dataType_MSSQL = varchar(255) | + | |dataType_MSSQL = varchar(255)/nvarchar(255) |
|dataType_Postgre = varchar(255) | |dataType_Postgre = varchar(255) | ||
|primaryKey = | |primaryKey = | ||
Line 186: | Line 196: | ||
|default = | |default = | ||
|colDesc = The role that is played by the resource that is associated with the handling attempt. This field is set to one of the following values: | |colDesc = The role that is played by the resource that is associated with the handling attempt. This field is set to one of the following values: | ||
− | + | * DivertedTo | |
− | + | * InConference | |
− | + | * Initiated | |
− | + | * InitiatedConsult | |
− | + | * Puller | |
− | + | * Received | |
− | + | * ReceivedConsult | |
− | + | * ReceivedRequest | |
− | + | * ReceivedTransfer | |
− | + | * RedirectedTo | |
− | + | * RoutedTo | |
− | + | * Unknown | |
− | |||
This value can change with localization. | This value can change with localization. | ||
Line 209: | Line 218: | ||
|colName = RESOURCE_ROLE_CODE | |colName = RESOURCE_ROLE_CODE | ||
|dataType_Ora = VARCHAR2(32 CHAR) | |dataType_Ora = VARCHAR2(32 CHAR) | ||
− | |dataType_MSSQL = varchar(32) | + | |dataType_MSSQL = varchar(32)/nvarchar(32) |
|dataType_Postgre = varchar(32) | |dataType_Postgre = varchar(32) | ||
|primaryKey = | |primaryKey = | ||
Line 216: | Line 225: | ||
|default = | |default = | ||
|colDesc = The code of the role that is played by the resource that is associated with the handling attempt. This field is set to one of the following values: | |colDesc = The code of the role that is played by the resource that is associated with the handling attempt. This field is set to one of the following values: | ||
− | + | * DIVERTEDTO | |
− | + | * INCONFERENCE | |
− | + | * INITIATED | |
− | + | * INITIATEDCONSULT | |
− | + | * PULLER | |
− | + | * RECEIVED | |
− | + | * RECEIVEDCONSULT | |
− | + | * RECEIVEDREQUEST | |
− | + | * RECEIVEDTRANSFER | |
− | + | * REDIRECTEDTO | |
− | + | * ROUTEDTO | |
− | + | * UNKNOWN | |
− | |||
This value does not change with localization. | This value does not change with localization. | ||
Line 239: | Line 247: | ||
|colName = ROLE_REASON | |colName = ROLE_REASON | ||
|dataType_Ora = VARCHAR2(255 CHAR) | |dataType_Ora = VARCHAR2(255 CHAR) | ||
− | |dataType_MSSQL = varchar(255) | + | |dataType_MSSQL = varchar(255)/nvarchar(255) |
|dataType_Postgre = varchar(255) | |dataType_Postgre = varchar(255) | ||
|primaryKey = | |primaryKey = | ||
Line 246: | Line 254: | ||
|default = | |default = | ||
|colDesc = The reason for the resource role. This field is set to one of the following values: | |colDesc = The reason for the resource role. This field is set to one of the following values: | ||
− | + | * Unspecified | |
− | + | * ConferenceInitiator | |
− | + | * ConferenceJoined | |
− | + | * IntroducedTransfer | |
− | + | * PulledBack (starting with release 8.1.4) or PulledBackTimeout (in releases earlier than 8.1.4) | |
This value can change with localization. | This value can change with localization. | ||
Line 261: | Line 269: | ||
|colName = ROLE_REASON_CODE | |colName = ROLE_REASON_CODE | ||
|dataType_Ora = VARCHAR2(32 CHAR) | |dataType_Ora = VARCHAR2(32 CHAR) | ||
− | |dataType_MSSQL = varchar(32) | + | |dataType_MSSQL = varchar(32)/nvarchar(32) |
|dataType_Postgre = varchar(32) | |dataType_Postgre = varchar(32) | ||
|primaryKey = | |primaryKey = | ||
Line 268: | Line 276: | ||
|default = | |default = | ||
|colDesc = The code of the reason for the resource role. This field is set to one of the following values: | |colDesc = The code of the reason for the resource role. This field is set to one of the following values: | ||
− | + | * UNSPECIFIED | |
− | + | * CONFERENCE_INITIATOR | |
− | + | * CONFERENCE_JOINED | |
− | + | * INTRODUCEDTRANSFER | |
− | + | * PULLEDBACK (starting with release 8.1.4) or PULLEDBACKTIMEOUT (in releases earlier than 8.1.4) | |
This value does not change with localization. | This value does not change with localization. | ||
Line 287: | Line 295: | ||
|primaryKey = | |primaryKey = | ||
|mandatory = yes | |mandatory = yes | ||
− | |foreignKey = | + | |foreignKey = yes |
|default = | |default = | ||
− | |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 | + | |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. |
|introduced = | |introduced = | ||
|modified = | |modified = | ||
Line 302: | Line 310: | ||
|primaryKey = | |primaryKey = | ||
|mandatory = yes | |mandatory = yes | ||
− | |foreignKey = | + | |foreignKey = yes |
|default = | |default = | ||
− | |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 | + | |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. |
|introduced = | |introduced = | ||
|modified = | |modified = | ||
Line 312: | Line 320: | ||
{{PDMRef | {{PDMRef | ||
|parentTable = CTL_AUDIT_LOG | |parentTable = CTL_AUDIT_LOG | ||
+ | |parentColumn = AUDIT_KEY | ||
|foreignKey = CREATE_AUDIT_KEY | |foreignKey = CREATE_AUDIT_KEY | ||
}} | }} | ||
Line 317: | Line 326: | ||
{{PDMRef | {{PDMRef | ||
|parentTable = CTL_AUDIT_LOG | |parentTable = CTL_AUDIT_LOG | ||
+ | |parentColumn = AUDIT_KEY | ||
|foreignKey = UPDATE_AUDIT_KEY | |foreignKey = UPDATE_AUDIT_KEY | ||
}} | }} | ||
− | |||
</onlyinclude> | </onlyinclude> | ||
[[Category:V:GIM:8.5DRAFT]] | [[Category:V:GIM:8.5DRAFT]] |
Latest revision as of 21:39, January 10, 2020
Table TECHNICAL_DESCRIPTOR
Description
This table allows interaction-based facts to be described by the role of the associated resource and the technical result of the interaction or the interaction-based fact. For example, a queue resource received an interaction and diverted to another resource. Each row describes one distinct combination of attributes.
For detailed information about the available technical descriptor combinations, see Technical Descriptors in the Genesys Info Mart User's Guide.
Hint: For easiest viewing, open the downloaded CSV file in Excel and adjust settings for column widths, text wrapping, and so on as desired. Depending on your browser and other system settings, you might need to save the file to your desktop first.
Column List
Column | Data Type | P | M | F | DV |
---|---|---|---|---|---|
TECHNICAL_DESCRIPTOR_KEY | Oracle: NUMBER(10) MSSQL: int PostgreSQL: integer |
X | X | ||
TECHNICAL_RESULT | Oracle: VARCHAR2(255 CHAR) MSSQL: varchar(255)/nvarchar(255) PostgreSQL: varchar(255) |
||||
TECHNICAL_RESULT_CODE | Oracle: VARCHAR2(32 CHAR) MSSQL: varchar(32)/nvarchar(32) PostgreSQL: varchar(32) |
||||
RESULT_REASON | Oracle: VARCHAR2(255 CHAR) MSSQL: varchar(255)/nvarchar(255) PostgreSQL: varchar(255) |
||||
RESULT_REASON_CODE | Oracle: VARCHAR2(32 CHAR) MSSQL: varchar(32)/nvarchar(32) PostgreSQL: varchar(32) |
||||
RESOURCE_ROLE | Oracle: VARCHAR2(255 CHAR) MSSQL: varchar(255)/nvarchar(255) PostgreSQL: varchar(255) |
||||
RESOURCE_ROLE_CODE | Oracle: VARCHAR2(32 CHAR) MSSQL: varchar(32)/nvarchar(32) PostgreSQL: varchar(32) |
||||
ROLE_REASON | Oracle: VARCHAR2(255 CHAR) MSSQL: varchar(255)/nvarchar(255) PostgreSQL: varchar(255) |
||||
ROLE_REASON_CODE | Oracle: VARCHAR2(32 CHAR) MSSQL: varchar(32)/nvarchar(32) PostgreSQL: varchar(32) |
||||
CREATE_AUDIT_KEY | Oracle: NUMBER(19) MSSQL: numeric(19) PostgreSQL: numeric(19) |
X | X | ||
UPDATE_AUDIT_KEY | Oracle: NUMBER(19) MSSQL: numeric(19) PostgreSQL: numeric(19) |
X | X |
TECHNICAL_DESCRIPTOR_KEY
The surrogate key that is used to join this dimension table to the fact tables.
TECHNICAL_RESULT
The technical result of the handling attempt—that is, how the attempt ended. This field is set to one of the following values:
- Abandoned
- AbnormalStop
- Cleared
- Completed
- Conferenced
- CustomerAbandoned
- Deferred
- DestinationBusy
- Diverted
- Incomplete
- None
- OutboundStopped
- Pulled
- Redirected
- Routed
- Transferred
- Unspecified
This value can change with localization.
TECHNICAL_RESULT_CODE
The technical result code of the handling attempt—that is, how the attempt ended. This field is set to one of the following values:
- ABANDONED
- ABNORMALSTOP
- CLEARED
- COMPLETED
- CONFERENCED
- CUSTOMERABANDONED
- DEFERRED
- DESTINATIONBUSY
- DIVERTED
- INCOMPLETE
- NONE
- OUTBOUNDSTOPPED
- PULLED
- REDIRECTED
- ROUTED
- TRANSFERRED
- UNSPECIFIED
This value does not change with localization.
RESULT_REASON
The reason for the technical result. This field is set to one of the following values:
- AbandonedFromHold
- AbandonedWhileQueued
- AbandonedWhileRinging
- AbnormalStopWhileQueued
- AbnormalStopWhileRinging
- AnsweredByAgent
- AnsweredByOther
- Archived
- CallbackAccepted
- Canceled
- DefaultRoutedByStrategy
- DefaultRoutedBySwitch
- IntroducedTransfer
- PulledBack (starting with release 8.1.4) or PulledBackTimeout (in releases earlier than 8.1.4)
- Redirected
- Rejected
- Revoked
- RoutedFromAnotherVQ
- RoutedToOther
- RouteOnNoAnswer
- Stopped
- StuckCall
- TargetsCleared
- Unspecified
This value can change with localization.
RESULT_REASON_CODE
The reason code for the technical result. This field is set to one of the following values:
- ABANDONEDFROMHOLD
- ABANDONEDWHILEQUEUED
- ABANDONEDWHILERINGING
- ABNORMALSTOPWHILEQUEUED
- ABNORMALSTOPWHILERINGING
- ANSWEREDBYAGENT
- ANSWEREDBYOTHER
- ARCHIVED
- CALLBACKACCEPTED
- CANCELED
- DEFAULTROUTEDBYSTRATEGY
- DEFAULTROUTEDBYSWITCH
- INTRODUCEDTRANSFER
- PULLEDBACK (starting with release 8.1.4) or PULLEDBACKTIMEOUT (in releases earlier than 8.1.4)
- REDIRECTED
- REJECTED
- REVOKED
- ROUTEDFROMANOTHERVQ
- ROUTEDTOOTHER
- ROUTEONNOANSWER
- STOPPED
- STUCKCALL
- TARGETSCLEARED
- UNSPECIFIED
This value does not change with localization.
RESOURCE_ROLE
The role that is played by the resource that is associated with the handling attempt. This field is set to one of the following values:
- DivertedTo
- InConference
- Initiated
- InitiatedConsult
- Puller
- Received
- ReceivedConsult
- ReceivedRequest
- ReceivedTransfer
- RedirectedTo
- RoutedTo
- Unknown
This value can change with localization.
RESOURCE_ROLE_CODE
The code of the role that is played by the resource that is associated with the handling attempt. This field is set to one of the following values:
- DIVERTEDTO
- INCONFERENCE
- INITIATED
- INITIATEDCONSULT
- PULLER
- RECEIVED
- RECEIVEDCONSULT
- RECEIVEDREQUEST
- RECEIVEDTRANSFER
- REDIRECTEDTO
- ROUTEDTO
- UNKNOWN
This value does not change with localization.
ROLE_REASON
The reason for the resource role. This field is set to one of the following values:
- Unspecified
- ConferenceInitiator
- ConferenceJoined
- IntroducedTransfer
- PulledBack (starting with release 8.1.4) or PulledBackTimeout (in releases earlier than 8.1.4)
This value can change with localization.
ROLE_REASON_CODE
The code of the reason for the resource role. This field is set to one of the following values:
- UNSPECIFIED
- CONFERENCE_INITIATOR
- CONFERENCE_JOINED
- INTRODUCEDTRANSFER
- PULLEDBACK (starting with release 8.1.4) or PULLEDBACKTIMEOUT (in releases earlier than 8.1.4)
This value does not change with localization.
CREATE_AUDIT_KEY
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.
UPDATE_AUDIT_KEY
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.
Index List
No indexes are defined.
Subject Areas
- Interaction_Resource — Represents a summary of each attempt to handle an interaction. It encompasses the mediation process that is required to offer the interaction to a target handling resource, as well as the activities of that target handling resource.
- Mediation_Segment — Represents interaction activity from the perspective of contact center ACD queues, virtual queues, interaction queues, and interaction workbins, as well as groups thereof.
References
The summary List of References will include the following entries for this table or view:
Child Table/View | Child Table/View Column | Parent Table/View | Parent Table/View Column |
---|---|---|---|
TECHNICAL_DESCRIPTOR | CREATE_AUDIT_KEY | CTL_AUDIT_LOG | AUDIT_KEY |
TECHNICAL_DESCRIPTOR | UPDATE_AUDIT_KEY | CTL_AUDIT_LOG | AUDIT_KEY |