CargoTables/PDMColumn
Table structure:
- colName - String
- dataType_Ora - String
- dataType_MSSQL - String
- dataType_Postgre - String
- dataType_DB2 - String
- primaryKey - String
- mandatoryKey - String
- foreignKey - String
- defaultValue - String
- colDesc - Wikitext
- introduced - Wikitext
- modified - List of Wikitext
- discontinued - Wikitext
- KVP - String
- xpath - String
- mandatoryForGIM - String
- transformDefault - String
This table has 15,515 rows altogether.
| Page | colName | dataType Ora | dataType MSSQL | dataType Postgre | dataType DB2 | primaryKey | mandatoryKey | foreignKey | defaultValue | colDesc | introduced | modified | discontinued | KVP | xpath | mandatoryForGIM | transformDefault |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Documentation:GIM:Library:Table-AGENT LOCATION:DRAFT | AGENT_LOCATION_KEY | NUMBER(10) | int | integer | yes | yes | The primary key of this table and the surrogate key that is used to join this dimension to the fact tables. | ||||||||||
| Documentation:GIM:Library:Table-AGENT LOCATION:DRAFT | AGENT_LOCATION_STRING | VARCHAR2(255 CHAR) | nvarchar(255) | varchar(255) | yes | The value reported by SIP Server or Interaction Server for the voice or multimedia login session, respectively. | 8.5.014.34 (in Microsoft SQL Server, data type changed from varchar to nvarchar in single-language databases) | ||||||||||
| Documentation:GIM:Library:Table-AGENT LOCATION:DRAFT | CREATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | 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. | ||||||||||
| Documentation:GIM:Library:Table-AGENT LOCATION:DRAFT | TENANT_KEY | NUMBER(10) | int | integer | yes | yes | The surrogate key that is used to join the TENANT dimension to the fact tables. | ||||||||||
| Documentation:GIM:Library:Table-AGENT LOCATION:PDMSource | AGENT_LOCATION_KEY | NUMBER(10) | int | integer | yes | yes | The primary key of this table and the surrogate key that is used to join this dimension to the fact tables. | ||||||||||
| Documentation:GIM:Library:Table-AGENT LOCATION:PDMSource | AGENT_LOCATION_STRING | VARCHAR2(255 CHAR) | nvarchar(255) | varchar(255) | yes | The value reported by SIP Server or Interaction Server for the voice or multimedia login session, respectively. | 8.5.014.34 (in Microsoft SQL Server, data type changed from varchar to nvarchar in single-language databases) | ||||||||||
| Documentation:GIM:Library:Table-AGENT LOCATION:PDMSource | CREATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | 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. | ||||||||||
| Documentation:GIM:Library:Table-AGENT LOCATION:PDMSource | TENANT_KEY | NUMBER(10) | int | integer | yes | yes | The surrogate key that is used to join the TENANT dimension to the fact tables. | ||||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5DRAFT | ANCHOR_FLAGS_KEY | NUMBER(10) | int | integer | yes | yes | The surrogate key that is used to join this dimension to the fact tables. | ||||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5DRAFT | CREATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | 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. | ||||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5DRAFT | CUSTOMER_LEFT_FIRST | NUMBER(1) | numeric(1) | numeric(1) | yes | 0 | [Show] | 8.5.004 | |||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5DRAFT | FIRST_ENGAGE_FOR_AGENT_IXN | NUMBER(1) | numeric(1) | numeric(1) | yes | [Show] | |||||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5DRAFT | FIRST_ENGAGE_FOR_AGENT_THRD | NUMBER(1) | numeric(1) | numeric(1) | yes | [Show] | |||||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5DRAFT | FIRST_ENGAGE_THRD | NUMBER(1) | numeric(1) | numeric(1) | yes | [Show] | |||||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5DRAFT | FIRST_REPLY_FOR_AGENT_IXN | NUMBER(1) | numeric(1) | numeric(1) | yes | [Show] | |||||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5DRAFT | FIRST_REPLY_FOR_AGENT_THRD | NUMBER(1) | numeric(1) | numeric(1) | yes | [Show] | |||||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5DRAFT | UPDATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | 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. | ||||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5PDMSource | ANCHOR_FLAGS_KEY | NUMBER(10) | int | integer | yes | yes | The surrogate key that is used to join this dimension to the fact tables. | ||||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5PDMSource | CREATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | 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. | ||||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5PDMSource | CUSTOMER_LEFT_FIRST | NUMBER(1) | numeric(1) | numeric(1) | yes | 0 | [Show] | 8.5.004 | |||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5PDMSource | FIRST_ENGAGE_FOR_AGENT_IXN | NUMBER(1) | numeric(1) | numeric(1) | yes | [Show] | |||||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5PDMSource | FIRST_ENGAGE_FOR_AGENT_THRD | NUMBER(1) | numeric(1) | numeric(1) | yes | [Show] | |||||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5PDMSource | FIRST_ENGAGE_THRD | NUMBER(1) | numeric(1) | numeric(1) | yes | [Show] | |||||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5PDMSource | FIRST_REPLY_FOR_AGENT_IXN | NUMBER(1) | numeric(1) | numeric(1) | yes | [Show] | |||||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5PDMSource | FIRST_REPLY_FOR_AGENT_THRD | NUMBER(1) | numeric(1) | numeric(1) | yes | [Show] | |||||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5PDMSource | UPDATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | 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. | ||||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:DRAFT | ANCHOR_FLAGS_KEY | NUMBER(10) | int | integer | yes | yes | The surrogate key that is used to join this dimension to the fact tables. | ||||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:DRAFT | CREATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | 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. | ||||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:DRAFT | CUSTOMER_LEFT_FIRST | NUMBER(1) | numeric(1) | numeric(1) | yes | 0 | [Show] | 8.5.004 | |||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:DRAFT | FIRST_ENGAGE_FOR_AGENT_IXN | NUMBER(1) | numeric(1) | numeric(1) | yes | [Show] | |||||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:DRAFT | FIRST_ENGAGE_FOR_AGENT_THRD | NUMBER(1) | numeric(1) | numeric(1) | yes | [Show] | |||||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:DRAFT | FIRST_ENGAGE_THRD | NUMBER(1) | numeric(1) | numeric(1) | yes | [Show] | |||||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:DRAFT | FIRST_REPLY_FOR_AGENT_IXN | NUMBER(1) | numeric(1) | numeric(1) | yes | [Show] | |||||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:DRAFT | FIRST_REPLY_FOR_AGENT_THRD | NUMBER(1) | numeric(1) | numeric(1) | yes | [Show] | |||||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:DRAFT | UPDATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | 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. | ||||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:PDMSource | ANCHOR_FLAGS_KEY | NUMBER(10) | int | integer | yes | yes | The surrogate key that is used to join this dimension to the fact tables. | ||||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:PDMSource | CREATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | 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. | ||||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:PDMSource | CUSTOMER_LEFT_FIRST | NUMBER(1) | numeric(1) | numeric(1) | yes | 0 | [Show] | 8.5.004 | |||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:PDMSource | FIRST_ENGAGE_FOR_AGENT_IXN | NUMBER(1) | numeric(1) | numeric(1) | yes | [Show] | |||||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:PDMSource | FIRST_ENGAGE_FOR_AGENT_THRD | NUMBER(1) | numeric(1) | numeric(1) | yes | [Show] | |||||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:PDMSource | FIRST_ENGAGE_THRD | NUMBER(1) | numeric(1) | numeric(1) | yes | [Show] | |||||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:PDMSource | FIRST_REPLY_FOR_AGENT_IXN | NUMBER(1) | numeric(1) | numeric(1) | yes | [Show] | |||||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:PDMSource | FIRST_REPLY_FOR_AGENT_THRD | NUMBER(1) | numeric(1) | numeric(1) | yes | [Show] | |||||||||||
| Documentation:GIM:Library:Table-ANCHOR FLAGS:PDMSource | UPDATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | 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. | ||||||||||
| Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:8.5DRAFT | ATTEMPT_DISPOSITION_KEY | NUMBER(10) | int | integer | yes | yes | [Show] | ||||||||||
| Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:8.5DRAFT | CAUSE | VARCHAR2(255 CHAR) | varchar(255)/nvarchar(255) | varchar(255) | The cause as specified in the OCS model. This value can change with localization. | ||||||||||||
| Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:8.5DRAFT | CAUSE_CODE | VARCHAR2(255 CHAR) | varchar(255)/nvarchar(255) | varchar(255) | The cause code that is equivalent to the OCS model cause. This value does not change with localization. | ||||||||||||
| Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:8.5DRAFT | CAUSE_ID | NUMBER(10) | int | integer | An integer that equals the value that is supplied by Outbound Contact Server to specify the cause. | ||||||||||||
| Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:8.5DRAFT | CREATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | 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. | ||||||||||
| Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:8.5DRAFT | DESCRIPTOR | VARCHAR2(255 CHAR) | varchar(255)/nvarchar(255) | varchar(255) | Specifies whether the final transition was caused by an agent or by the system, or whether this is unknown. Because not all outbound dispositions support descriptor, most dispositions have only an 'Unknown' value. This is a string value that can be localized or changed, based on reporting needs. | ||||||||||||
| Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:8.5DRAFT | DESCRIPTOR_CODE | VARCHAR2(255 CHAR) | varchar(255)/nvarchar(255) | varchar(255) | The code of the descriptor. This field is set to one of the following values:
This value is not localizable and should not be changed. |
||||||||||||
| Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:8.5DRAFT | UPDATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | 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. | ||||||||||
| Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:8.5PDMSource | ATTEMPT_DISPOSITION_KEY | NUMBER(10) | int | integer | yes | yes | [Show] | ||||||||||
| Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:8.5PDMSource | CAUSE | VARCHAR2(255 CHAR) | varchar(255)/nvarchar(255) | varchar(255) | The cause as specified in the OCS model. This value can change with localization. | ||||||||||||
| Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:8.5PDMSource | CAUSE_CODE | VARCHAR2(255 CHAR) | varchar(255)/nvarchar(255) | varchar(255) | The cause code that is equivalent to the OCS model cause. This value does not change with localization. | ||||||||||||
| Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:8.5PDMSource | CAUSE_ID | NUMBER(10) | int | integer | An integer that equals the value that is supplied by Outbound Contact Server to specify the cause. | ||||||||||||
| Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:8.5PDMSource | CREATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | 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. | ||||||||||
| Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:8.5PDMSource | DESCRIPTOR | VARCHAR2(255 CHAR) | varchar(255)/nvarchar(255) | varchar(255) | Specifies whether the final transition was caused by an agent or by the system, or whether this is unknown. Because not all outbound dispositions support descriptor, most dispositions have only an 'Unknown' value. This is a string value that can be localized or changed, based on reporting needs. | ||||||||||||
| Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:8.5PDMSource | DESCRIPTOR_CODE | VARCHAR2(255 CHAR) | varchar(255)/nvarchar(255) | varchar(255) | The code of the descriptor. This field is set to one of the following values:
This value is not localizable and should not be changed. |
||||||||||||
| Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:8.5PDMSource | UPDATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | 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. | ||||||||||
| Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:DRAFT | ATTEMPT_DISPOSITION_KEY | NUMBER(10) | int | integer | yes | yes | [Show] | ||||||||||
| Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:DRAFT | CAUSE | VARCHAR2(255 CHAR) | nvarchar(255) | varchar(255) | The cause as specified in the OCS model. This value can change with localization. | 8.5.014.34 (in Microsoft SQL Server, data type changed from varchar to nvarchar in single-language databases) | |||||||||||
| Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:DRAFT | CAUSE_CODE | VARCHAR2(255 CHAR) | nvarchar(255) | varchar(255) | The cause code that is equivalent to the OCS model cause. This value does not change with localization. | 8.5.014.34 (in Microsoft SQL Server, data type changed from varchar to nvarchar in single-language databases) | |||||||||||
| Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:DRAFT | CAUSE_ID | NUMBER(10) | int | integer | An integer that equals the value that is supplied by Outbound Contact Server to specify the cause. | ||||||||||||
| Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:DRAFT | CREATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | 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. | ||||||||||
| Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:DRAFT | DESCRIPTOR | VARCHAR2(255 CHAR) | nvarchar(255) | varchar(255) | Specifies whether the final transition was caused by an agent or by the system, or whether this is unknown. Because not all outbound dispositions support descriptor, most dispositions have only an 'Unknown' value. This is a string value that can be localized or changed, based on reporting needs. | 8.5.014.34 (in Microsoft SQL Server, data type changed from varchar to nvarchar in single-language databases) | |||||||||||
| Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:DRAFT | DESCRIPTOR_CODE | VARCHAR2(255 CHAR) | nvarchar(255) | varchar(255) | The code of the descriptor. This field is set to one of the following values:
This value is not localizable and should not be changed. |
8.5.014.34 (in Microsoft SQL Server, data type changed from varchar to nvarchar in single-language databases) | |||||||||||
| Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:DRAFT | UPDATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | 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. | ||||||||||
| Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:PDMSource | ATTEMPT_DISPOSITION_KEY | NUMBER(10) | int | integer | yes | yes | [Show] | ||||||||||
| Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:PDMSource | CAUSE | VARCHAR2(255 CHAR) | nvarchar(255) | varchar(255) | The cause as specified in the OCS model. This value can change with localization. | 8.5.014.34 (in Microsoft SQL Server, data type changed from varchar to nvarchar in single-language databases) | |||||||||||
| Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:PDMSource | CAUSE_CODE | VARCHAR2(255 CHAR) | nvarchar(255) | varchar(255) | The cause code that is equivalent to the OCS model cause. This value does not change with localization. | 8.5.014.34 (in Microsoft SQL Server, data type changed from varchar to nvarchar in single-language databases) | |||||||||||
| Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:PDMSource | CAUSE_ID | NUMBER(10) | int | integer | An integer that equals the value that is supplied by Outbound Contact Server to specify the cause. | ||||||||||||
| Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:PDMSource | CREATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | 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. | ||||||||||
| Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:PDMSource | DESCRIPTOR | VARCHAR2(255 CHAR) | nvarchar(255) | varchar(255) | Specifies whether the final transition was caused by an agent or by the system, or whether this is unknown. Because not all outbound dispositions support descriptor, most dispositions have only an 'Unknown' value. This is a string value that can be localized or changed, based on reporting needs. | 8.5.014.34 (in Microsoft SQL Server, data type changed from varchar to nvarchar in single-language databases) | |||||||||||
| Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:PDMSource | DESCRIPTOR_CODE | VARCHAR2(255 CHAR) | nvarchar(255) | varchar(255) | The code of the descriptor. This field is set to one of the following values:
This value is not localizable and should not be changed. |
8.5.014.34 (in Microsoft SQL Server, data type changed from varchar to nvarchar in single-language databases) | |||||||||||
| Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:PDMSource | UPDATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | 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. | ||||||||||
| Documentation:GIM:Library:Table-BGS BOT DIM:8.5DRAFT | BOT_CATEGORY | VARCHAR2(50 CHAR) | nvarchar(50) | varchar(50) | yes | NO_VALUE | The generic category describing the type of function performed by the bot, such as Monitoring, Dialog, Notification, or Service. For information about how you can define and set bot categories, see Integrating BGS with Genesys Historical Reporting in the Bot Gateway Server Quick Start Guide. | /chatBot_info/chatBot_category | |||||||||
| Documentation:GIM:Library:Table-BGS BOT DIM:8.5DRAFT | BOT_FUNCTION | VARCHAR2(50 CHAR) | nvarchar(50) | varchar(50) | yes | NO_VALUE | The specific bot functionality, such as Translator, Advisor, Escalation, Recording, AI, or Questioner. For information about how you can define and set bot functions, see Integrating BGS with Genesys Historical Reporting in the Bot Gateway Server Quick Start Guide. | /chatBot_info/chatBot_function | |||||||||
| Documentation:GIM:Library:Table-BGS BOT DIM:8.5DRAFT | CREATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | 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. | ||||||||||
| Documentation:GIM:Library:Table-BGS BOT DIM:8.5DRAFT | ID | NUMBER(10) | int | integer | yes | yes | The primary key of this table. This ID is referenced from other tables as BGS_BOT_DIM_KEY. | ||||||||||
| Documentation:GIM:Library:Table-BGS BOT DIM:8.5PDMSource | BOT_CATEGORY | VARCHAR2(50 CHAR) | nvarchar(50) | varchar(50) | yes | NO_VALUE | The generic category describing the type of function performed by the bot, such as Monitoring, Dialog, Notification, or Service. For information about how you can define and set bot categories, see Integrating BGS with Genesys Historical Reporting in the Bot Gateway Server Quick Start Guide. | /chatBot_info/chatBot_category | |||||||||
| Documentation:GIM:Library:Table-BGS BOT DIM:8.5PDMSource | BOT_FUNCTION | VARCHAR2(50 CHAR) | nvarchar(50) | varchar(50) | yes | NO_VALUE | The specific bot functionality, such as Translator, Advisor, Escalation, Recording, AI, or Questioner. For information about how you can define and set bot functions, see Integrating BGS with Genesys Historical Reporting in the Bot Gateway Server Quick Start Guide. | /chatBot_info/chatBot_function | |||||||||
| Documentation:GIM:Library:Table-BGS BOT DIM:8.5PDMSource | CREATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | 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. | ||||||||||
| Documentation:GIM:Library:Table-BGS BOT DIM:8.5PDMSource | ID | NUMBER(10) | int | integer | yes | yes | The primary key of this table. This ID is referenced from other tables as BGS_BOT_DIM_KEY. | ||||||||||
| Documentation:GIM:Library:Table-BGS BOT DIM:DRAFT | BOT_CATEGORY | VARCHAR2(50 CHAR) | nvarchar(50) | varchar(50) | yes | NO_VALUE | The generic category describing the type of function performed by the bot, such as Monitoring, Dialog, Notification, or Service. For information about how you can define and set bot categories, see Integrating BGS with Genesys Historical Reporting in the Bot Gateway Server Quick Start Guide. | /chatBot_info/chatBot_category | |||||||||
| Documentation:GIM:Library:Table-BGS BOT DIM:DRAFT | BOT_FUNCTION | VARCHAR2(50 CHAR) | nvarchar(50) | varchar(50) | yes | NO_VALUE | The specific bot functionality, such as Translator, Advisor, Escalation, Recording, AI, or Questioner. For information about how you can define and set bot functions, see Integrating BGS with Genesys Historical Reporting in the Bot Gateway Server Quick Start Guide. | /chatBot_info/chatBot_function | |||||||||
| Documentation:GIM:Library:Table-BGS BOT DIM:DRAFT | CREATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | 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. | ||||||||||
| Documentation:GIM:Library:Table-BGS BOT DIM:DRAFT | ID | NUMBER(10) | int | integer | yes | yes | The primary key of this table. This ID is referenced from other tables as BGS_BOT_DIM_KEY. | ||||||||||
| Documentation:GIM:Library:Table-BGS BOT DIM:PDMSource | BOT_CATEGORY | VARCHAR2(50 CHAR) | nvarchar(50) | varchar(50) | yes | NO_VALUE | The generic category describing the type of function performed by the bot, such as Monitoring, Dialog, Notification, or Service. For information about how you can define and set bot categories, see Integrating BGS with Genesys Historical Reporting in the Bot Gateway Server Quick Start Guide. | /chatBot_info/chatBot_category | |||||||||
| Documentation:GIM:Library:Table-BGS BOT DIM:PDMSource | BOT_FUNCTION | VARCHAR2(50 CHAR) | nvarchar(50) | varchar(50) | yes | NO_VALUE | The specific bot functionality, such as Translator, Advisor, Escalation, Recording, AI, or Questioner. For information about how you can define and set bot functions, see Integrating BGS with Genesys Historical Reporting in the Bot Gateway Server Quick Start Guide. | /chatBot_info/chatBot_function | |||||||||
| Documentation:GIM:Library:Table-BGS BOT DIM:PDMSource | CREATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | 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. | ||||||||||
| Documentation:GIM:Library:Table-BGS BOT DIM:PDMSource | ID | NUMBER(10) | int | integer | yes | yes | The primary key of this table. This ID is referenced from other tables as BGS_BOT_DIM_KEY. | ||||||||||
| Documentation:GIM:Library:Table-BGS BOT NAME DIM:8.5DRAFT | BOT_NAME | VARCHAR2(50 CHAR) | nvarchar(50) | varchar(50) | yes | NO_VALUE | [Show] | /chatBot_info/chatBot_name | |||||||||
| Documentation:GIM:Library:Table-BGS BOT NAME DIM:8.5DRAFT | CREATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | 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. | ||||||||||
| Documentation:GIM:Library:Table-BGS BOT NAME DIM:8.5DRAFT | ID | NUMBER(10) | int | integer | yes | yes | The primary key of this table. This ID is referenced from other tables as BGS_BOT_NAME_DIM_KEY. | ||||||||||
| Documentation:GIM:Library:Table-BGS BOT NAME DIM:8.5PDMSource | BOT_NAME | VARCHAR2(50 CHAR) | nvarchar(50) | varchar(50) | yes | NO_VALUE | [Show] | /chatBot_info/chatBot_name | |||||||||
| Documentation:GIM:Library:Table-BGS BOT NAME DIM:8.5PDMSource | CREATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | 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. | ||||||||||
| Documentation:GIM:Library:Table-BGS BOT NAME DIM:8.5PDMSource | ID | NUMBER(10) | int | integer | yes | yes | The primary key of this table. This ID is referenced from other tables as BGS_BOT_NAME_DIM_KEY. | ||||||||||
| Documentation:GIM:Library:Table-BGS BOT NAME DIM:DRAFT | BOT_NAME | VARCHAR2(50 CHAR) | nvarchar(50) | varchar(50) | yes | NO_VALUE | [Show] | /chatBot_info/chatBot_name | |||||||||
| Documentation:GIM:Library:Table-BGS BOT NAME DIM:DRAFT | CREATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | 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. |
Comments or questions about this documentation? Contact us for support!