View table: PDMViewColumn
Table structure:
- colName - String
- colDesc - Wikitext
This table has 282 rows altogether.
Page | colName | colDesc |
---|---|---|
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN AUDIT LOG | AUDIT_KEY | The primary key of this table and the surrogate key that is used to join this table to GIDB, merge tables, and dimensional model tables. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN AUDIT LOG | CREATED | The date and time of row creation. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN AUDIT LOG | CREATED_TS | The UTC-equivalent value of the date and time of row creation. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN AUDIT LOG | DATA_SOURCE_KEY | The surrogate key that is used to join to the CTL_DS dimension. It specifies the data source server, such as T-Server, Interaction Server, Configuration Server, Outbound Contact Server (OCS), and Genesys Info Mart Server itself. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN AUDIT LOG | INSERTED | The UTC-equivalent date and time when the processing of the logical transaction described by this row was completed and the record was inserted into the database. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN AUDIT LOG | JOB_ID | ID that uniquely identifies the execution instance of the job. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN AUDIT LOG | MAX_CHUNK_TS | The maximum value out of all timestamps that are stored for a particular chunk of data that is marked with the corresponding audit key. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN AUDIT LOG | MAX_START_DATE_TIME_KEY | The maximum value of START_DATE_TIME_KEY that is committed in a transaction. If partitioning is enabled, this value helps to identify fact-table partition(s) in which data was inserted or updated. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN AUDIT LOG | MIN_START_DATE_TIME_KEY | The minimum value of START_DATE_TIME_KEY that is committed in a transaction. If partitioning is enabled, this value helps to identify fact-table partition(s) in which data was inserted or updated. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN AUDIT LOG | PROCESSING_STATUS_KEY | Reference to the CTL_PROCESSING_STATUS dimension. This field is reserved. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN AUDIT LOG | ROW_COUNT | The number of records that are marked with this audit key. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN ETL JOB HISTORY | DURATION | The duration of the job, in seconds. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN ETL JOB HISTORY | END_TIME | The date and time at which the last step ended (UTC time zone). |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN ETL JOB HISTORY | JOB_ID | ID that uniquely identifies the execution instance of the job. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN ETL JOB HISTORY | JOB_NAME | The name of the job, such as Job_ExtractICON. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN ETL JOB HISTORY | JOB_VERSION | The version of the job, such as 8.1.000.10. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN ETL JOB HISTORY | START_TIME | The date and time at which the first step started (UTC time zone). |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN ETL JOB HISTORY | STATUS | The status of the step, such as COMPLETE or FAILED. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN ETL JOB STATUS | DURATION | The duration of the job, in seconds. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN ETL JOB STATUS | END_TIME | The date and time at which the last step ended (UTC time zone). |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN ETL JOB STATUS | JOB_ID | ID that uniquely identifies the execution instance of the job. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN ETL JOB STATUS | JOB_NAME | The name of the job, such as Job_ExtractICON. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN ETL JOB STATUS | JOB_VERSION | The version of the job, such as 8.1.000.10. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN ETL JOB STATUS | START_TIME | The date and time at which the first step started (UTC time zone). |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN ETL JOB STATUS | STATUS | The status of the step, such as COMPLETE or FAILED. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN ETL STEP HISTORY | DURATION | The duration of the job, in seconds. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN ETL STEP HISTORY | END_TIME | The date and time at which the last step ended (UTC time zone). |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN ETL STEP HISTORY | JOB_ID | ID that uniquely identifies the execution instance of the job. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN ETL STEP HISTORY | JOB_NAME | The name of the job, such as Job_ExtractICON. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN ETL STEP HISTORY | JOB_VERSION | The version of the job, such as 8.1.000.10. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN ETL STEP HISTORY | START_TIME | The date and time at which the first step started (UTC time zone). |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN ETL STEP HISTORY | STATUS | The status of the step, such as COMPLETE or FAILED. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN ETL STEP HISTORY | WORKFLOW_TYPE | The name of the ETL job step, such as Outbound. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN EXTRACT HISTORY | DBCONNECTION | The name of the Database Access Point (DAP) through which data was extracted. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN EXTRACT HISTORY | DURATION | The duration of the job, in seconds. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN EXTRACT HISTORY | END_TIME | The date and time at which the last step ended (UTC time zone). |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN EXTRACT HISTORY | ICON_DBID | ID that uniquely identifies the ICON application instance. Applies only to tables extracted by Job_ExtractICON. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN EXTRACT HISTORY | JOB_ID | ID that uniquely identifies the execution instance of the job. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN EXTRACT HISTORY | JOB_NAME | The name of the job, such as Job_ExtractICON. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN EXTRACT HISTORY | JOB_VERSION | The version of the job, such as 8.1.000.10. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN EXTRACT HISTORY | LATEST_DATA_TIME | Provides the highest timestamp value for the records that are extracted in a given extraction cycle. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN EXTRACT HISTORY | ROW_COUNT | Provides the number of records that are extracted in a given extraction cycle. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN EXTRACT HISTORY | START_TIME | The date and time at which the first step started (UTC time zone). |
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN EXTRACT HISTORY | TABLE_NAME | The name of the table from which data is extracted. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST | CALLING_LIST_CFG_DBID | The calling list object identifier in the contact center configuration. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST | CALLING_LIST_KEY | The primary key of this view and the surrogate key that is used to join the CALLING_LIST dimension to the fact tables. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST | CALLING_LIST_NAME | The name of the calling list. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST | 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. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST | DESCRIPTION | The description of the calling list. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST | END_TS | The UTC-equivalent value of the date and time when the calling list was removed from contact center configuration. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST | START_TS | The UTC-equivalent value of the date and time when the calling list was added to IDB, which may differ from when the calling list was actually added to contact center configuration. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST | TENANT_KEY | The surrogate key that is used to join the TENANT dimension to the fact tables. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST | UPDATE_AUDIT_KEY | The surrogate key used to join to the CTL_AUDIT_LOG dimension. 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. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST TO CAMP FACT | ACTIVE_FLAG | Indicates whether the association between the calling list and the campaign is still active: 0 = No, 1 = Yes. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST TO CAMP FACT | CALLING_LIST_KEY | The surrogate key that is used to join the CALLING_LIST dimension to the fact tables. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST TO CAMP FACT | CALLING_LIST_TO_CAMP_FACT_KEY | The primary key of this view. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST TO CAMP FACT | CAMPAIGN_KEY | The surrogate key that is used to join the CAMPAIGN dimension to the fact tables. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST TO CAMP FACT | 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. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST TO CAMP FACT | END_DATE_TIME_KEY | Identifies the start of a 15-minute interval in which the calling list was removed from the campaign. Use this value as a key to join the fact tables to any configured DATE_TIME dimension, in order to group the facts that are related to the same interval and/or convert the END_TS timestamp to an appropriate time zone. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST TO CAMP FACT | END_TS | The meaning depends on the value of ACTIVE_FLAG. For an inactive row, the UTC-equivalent value of the date and time when the calling list was removed from the campaign in the contact center configuration. For an active row, this value represents a UTC-equivalent value of the date and time far in the future, so that applications do not have to test for null. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST TO CAMP FACT | PURGE_FLAG | This field is reserved. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST TO CAMP FACT | START_DATE_TIME_KEY | Identifies the start of a 15-minute interval in which the calling list was added to the campaign. Use this value as a key to join the fact tables to any configured DATE_TIME dimension, in order to group the facts that are related to the same interval and/or convert the START_TS timestamp to an appropriate time zone. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST TO CAMP FACT | START_TS | The UTC-equivalent value of the date and time when the calling list was added to the campaign in the contact center configuration. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST TO CAMP FACT | TENANT_KEY | The surrogate key that is used to join the TENANT dimension to the fact tables. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST TO CAMP FACT | TOTAL_DURATION | The meaning depends on the value of ACTIVE_FLAG. For an inactive row, this value represents the total duration, in seconds, that the calling list was associated with the campaign. For an active row, this value represents the duration, in seconds, that the calling list was associated with the campaign, from start time to the time that the ETL last executed. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST TO CAMP FACT | UPDATE_AUDIT_KEY | The surrogate key used to join to the CTL_AUDIT_LOG dimension. 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. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-CAMPAIGN | CAMPAIGN_CFG_DBID | The campaign object identifier in contact center configuration. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-CAMPAIGN | CAMPAIGN_KEY | The surrogate key that is used to join the CAMPAIGN dimension to the fact tables. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-CAMPAIGN | CAMPAIGN_NAME | The name of the campaign object in Configuration Server. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-CAMPAIGN | 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. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-CAMPAIGN | DESCRIPTION | The description of the campaign. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-CAMPAIGN | END_TS | The UTC-equivalent value of the date and time when the campaign object was removed from contact center configuration. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-CAMPAIGN | START_TS | The UTC-equivalent value of the date and time when the campaign was added to IDB, which may differ from when the campaign was actually added to contact center configuration. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-CAMPAIGN | TENANT_KEY | The surrogate key that is used to join the TENANT dimension to the fact tables. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-CAMPAIGN | UPDATE_AUDIT_KEY | The surrogate key used to join to the CTL_AUDIT_LOG dimension. 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. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-CTL ETL HWM | LAST_TS | Provides a UTC equivalent of the date and time up to which the data has been processed. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-CTL ETL HWM | NAME | A combination of the job name and an abbreviated data type for the processed data. Either of the following values:
|
Draft:PEC-REP/Library/PDMLibraryGIM/View-GROUP | 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. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-GROUP | END_TS | The UTC-equivalent value of the date and time when the group was removed from contact center configuration. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-GROUP | GROUP_CFG_DBID | The group object identifier in the contact center configuration. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-GROUP | GROUP_CFG_TYPE_ID | The contact center configuration integer type that is associated with the DN or agent group object. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-GROUP | GROUP_KEY | The primary key of this view that is used to join the GROUP_ dimension to the fact tables. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-GROUP | GROUP_NAME | The group name. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-GROUP | GROUP_TYPE | The group type. This field is set to one of the following values:
This value can change with localization. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-GROUP | GROUP_TYPE_CODE | The group type code. This field is set to one of the following values:
This value does not change with localization. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-GROUP | START_TS | The UTC-equivalent value of the date and time when the group was added to IDB, which may differ from when the group was actually added to contact center configuration. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-GROUP | TENANT_KEY | The surrogate key that is used to join the TENANT dimension to the fact tables. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-GROUP | UPDATE_AUDIT_KEY | The surrogate key used to join to the CTL_AUDIT_LOG dimension. 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. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-GROUP TO CAMPAIGN FACT | ACTIVE_FLAG | Indicates whether the association between the agent group or place group and the campaign is still active: 0 = No, 1 = Yes. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-GROUP TO CAMPAIGN FACT | CAMPAIGN_KEY | The surrogate key that is used to join the CAMPAIGN dimension to the fact tables. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-GROUP TO CAMPAIGN FACT | 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. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-GROUP TO CAMPAIGN FACT | END_DATE_TIME_KEY | Identifies the start of a 15-minute interval in which the agent group or place group was removed from the campaign in the contact center configuration. Use this value as a key to join the fact tables to any configured DATE_TIME dimension, in order to group the facts that are related to the same interval and/or convert the END_TS timestamp to an appropriate time zone. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-GROUP TO CAMPAIGN FACT | END_TS | The meaning depends on the value of ACTIVE_FLAG. For an inactive row, the UTC-equivalent value of the date and time when the agent group or place group was removed from the campaign in the contact center configuration. For an active row, this value represents a UTC-equivalent value of the date and time far in the future, so that applications do not have to test for null. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-GROUP TO CAMPAIGN FACT | GROUP_KEY | The surrogate key that is used to join the GROUP_ dimension to the fact tables. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-GROUP TO CAMPAIGN FACT | GROUP_TO_CAMPAIGN_FACT_KEY | The primary key of this view. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-GROUP TO CAMPAIGN FACT | PURGE_FLAG | This field is reserved. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-GROUP TO CAMPAIGN FACT | START_DATE_TIME_KEY | Identifies the start of a 15-minute interval in which the agent group or place group was added to the campaign in the contact center configuration. Use this value as a key to join the fact tables to any configured DATE_TIME dimension, in order to group the facts that are related to the same interval and/or convert the START_TS timestamp to an appropriate time zone. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-GROUP TO CAMPAIGN FACT | START_TS | The UTC-equivalent value of the date and time when the agent group or place group was added to the campaign in the contact center configuration. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-GROUP TO CAMPAIGN FACT | TENANT_KEY | The surrogate key that is used to join the TENANT dimension to the fact tables. |
Draft:PEC-REP/Library/PDMLibraryGIM/View-GROUP TO CAMPAIGN FACT | TOTAL_DURATION | The meaning depends on the value of ACTIVE_FLAG. For an inactive row, this value represents the total duration, in seconds, that the agent group or place group was associated with the campaign. For an active row, this value represents the duration, in seconds, that the agent group or place group was associated with the campaign, from start time to the time that the ETL last executed. |