CargoTables/PDMViewColumn
Table structure:
- colName - String
- colDesc - Wikitext
This table has 2,407 rows altogether.
| Page | colName | colDesc |
|---|---|---|
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:8.5DRAFT | 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. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:8.5DRAFT | CREATED | The date and time of row creation. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:8.5DRAFT | CREATED_TS | The UTC-equivalent value of the date and time of row creation. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:8.5DRAFT | 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. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:8.5DRAFT | 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. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:8.5DRAFT | JOB_ID | ID that uniquely identifies the execution instance of the job. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:8.5DRAFT | 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. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:8.5DRAFT | 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. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:8.5DRAFT | 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. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:8.5DRAFT | PROCESSING_STATUS_KEY | Reference to the CTL_PROCESSING_STATUS dimension. This field is reserved. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:8.5DRAFT | ROW_COUNT | The number of records that are marked with this audit key. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:8.5PDMSource | 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. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:8.5PDMSource | CREATED | The date and time of row creation. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:8.5PDMSource | CREATED_TS | The UTC-equivalent value of the date and time of row creation. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:8.5PDMSource | 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. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:8.5PDMSource | 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. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:8.5PDMSource | JOB_ID | ID that uniquely identifies the execution instance of the job. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:8.5PDMSource | 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. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:8.5PDMSource | 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. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:8.5PDMSource | 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. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:8.5PDMSource | PROCESSING_STATUS_KEY | Reference to the CTL_PROCESSING_STATUS dimension. This field is reserved. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:8.5PDMSource | ROW_COUNT | The number of records that are marked with this audit key. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:DRAFT | 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. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:DRAFT | CREATED | The date and time of row creation. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:DRAFT | CREATED_TS | The UTC-equivalent value of the date and time of row creation. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:DRAFT | 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. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:DRAFT | 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. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:DRAFT | JOB_ID | ID that uniquely identifies the execution instance of the job. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:DRAFT | 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. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:DRAFT | 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. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:DRAFT | 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. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:DRAFT | PROCESSING_STATUS_KEY | Reference to the CTL_PROCESSING_STATUS dimension. This field is reserved. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:DRAFT | ROW_COUNT | The number of records that are marked with this audit key. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:PDMSource | 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. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:PDMSource | CREATED | The date and time of row creation. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:PDMSource | CREATED_TS | The UTC-equivalent value of the date and time of row creation. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:PDMSource | 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. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:PDMSource | 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. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:PDMSource | JOB_ID | ID that uniquely identifies the execution instance of the job. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:PDMSource | 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. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:PDMSource | 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. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:PDMSource | 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. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:PDMSource | PROCESSING_STATUS_KEY | Reference to the CTL_PROCESSING_STATUS dimension. This field is reserved. |
| Documentation:GIM:Library:View-ADMIN AUDIT LOG:PDMSource | ROW_COUNT | The number of records that are marked with this audit key. |
| Documentation:GIM:Library:View-ADMIN ETL JOB HISTORY:8.5DRAFT | DURATION | The duration of the job, in seconds. |
| Documentation:GIM:Library:View-ADMIN ETL JOB HISTORY:8.5DRAFT | END_TIME | The date and time at which the last step ended (UTC time zone). |
| Documentation:GIM:Library:View-ADMIN ETL JOB HISTORY:8.5DRAFT | JOB_ID | ID that uniquely identifies the execution instance of the job. |
| Documentation:GIM:Library:View-ADMIN ETL JOB HISTORY:8.5DRAFT | JOB_NAME | The name of the job, such as Job_ExtractICON. |
| Documentation:GIM:Library:View-ADMIN ETL JOB HISTORY:8.5DRAFT | JOB_VERSION | The version of the job, such as 8.1.000.10. |
| Documentation:GIM:Library:View-ADMIN ETL JOB HISTORY:8.5DRAFT | START_TIME | The date and time at which the first step started (UTC time zone). |
| Documentation:GIM:Library:View-ADMIN ETL JOB HISTORY:8.5DRAFT | STATUS | The status of the step, such as COMPLETE or FAILED. |
| Documentation:GIM:Library:View-ADMIN ETL JOB HISTORY:8.5PDMSource | DURATION | The duration of the job, in seconds. |
| Documentation:GIM:Library:View-ADMIN ETL JOB HISTORY:8.5PDMSource | END_TIME | The date and time at which the last step ended (UTC time zone). |
| Documentation:GIM:Library:View-ADMIN ETL JOB HISTORY:8.5PDMSource | JOB_ID | ID that uniquely identifies the execution instance of the job. |
| Documentation:GIM:Library:View-ADMIN ETL JOB HISTORY:8.5PDMSource | JOB_NAME | The name of the job, such as Job_ExtractICON. |
| Documentation:GIM:Library:View-ADMIN ETL JOB HISTORY:8.5PDMSource | JOB_VERSION | The version of the job, such as 8.1.000.10. |
| Documentation:GIM:Library:View-ADMIN ETL JOB HISTORY:8.5PDMSource | START_TIME | The date and time at which the first step started (UTC time zone). |
| Documentation:GIM:Library:View-ADMIN ETL JOB HISTORY:8.5PDMSource | STATUS | The status of the step, such as COMPLETE or FAILED. |
| Documentation:GIM:Library:View-ADMIN ETL JOB HISTORY:DRAFT | DURATION | The duration of the job, in seconds. |
| Documentation:GIM:Library:View-ADMIN ETL JOB HISTORY:DRAFT | END_TIME | The date and time at which the last step ended (UTC time zone). |
| Documentation:GIM:Library:View-ADMIN ETL JOB HISTORY:DRAFT | JOB_ID | ID that uniquely identifies the execution instance of the job. |
| Documentation:GIM:Library:View-ADMIN ETL JOB HISTORY:DRAFT | JOB_NAME | The name of the job, such as Job_ExtractICON. |
| Documentation:GIM:Library:View-ADMIN ETL JOB HISTORY:DRAFT | JOB_VERSION | The version of the job, such as 8.1.000.10. |
| Documentation:GIM:Library:View-ADMIN ETL JOB HISTORY:DRAFT | START_TIME | The date and time at which the first step started (UTC time zone). |
| Documentation:GIM:Library:View-ADMIN ETL JOB HISTORY:DRAFT | STATUS | The status of the step, such as COMPLETE or FAILED. |
| Documentation:GIM:Library:View-ADMIN ETL JOB HISTORY:PDMSource | DURATION | The duration of the job, in seconds. |
| Documentation:GIM:Library:View-ADMIN ETL JOB HISTORY:PDMSource | END_TIME | The date and time at which the last step ended (UTC time zone). |
| Documentation:GIM:Library:View-ADMIN ETL JOB HISTORY:PDMSource | JOB_ID | ID that uniquely identifies the execution instance of the job. |
| Documentation:GIM:Library:View-ADMIN ETL JOB HISTORY:PDMSource | JOB_NAME | The name of the job, such as Job_ExtractICON. |
| Documentation:GIM:Library:View-ADMIN ETL JOB HISTORY:PDMSource | JOB_VERSION | The version of the job, such as 8.1.000.10. |
| Documentation:GIM:Library:View-ADMIN ETL JOB HISTORY:PDMSource | START_TIME | The date and time at which the first step started (UTC time zone). |
| Documentation:GIM:Library:View-ADMIN ETL JOB HISTORY:PDMSource | STATUS | The status of the step, such as COMPLETE or FAILED. |
| Documentation:GIM:Library:View-ADMIN ETL JOB STATUS:8.5DRAFT | DURATION | The duration of the job, in seconds. |
| Documentation:GIM:Library:View-ADMIN ETL JOB STATUS:8.5DRAFT | END_TIME | The date and time at which the last step ended (UTC time zone). |
| Documentation:GIM:Library:View-ADMIN ETL JOB STATUS:8.5DRAFT | JOB_ID | ID that uniquely identifies the execution instance of the job. |
| Documentation:GIM:Library:View-ADMIN ETL JOB STATUS:8.5DRAFT | JOB_NAME | The name of the job, such as Job_ExtractICON. |
| Documentation:GIM:Library:View-ADMIN ETL JOB STATUS:8.5DRAFT | JOB_VERSION | The version of the job, such as 8.1.000.10. |
| Documentation:GIM:Library:View-ADMIN ETL JOB STATUS:8.5DRAFT | START_TIME | The date and time at which the first step started (UTC time zone). |
| Documentation:GIM:Library:View-ADMIN ETL JOB STATUS:8.5DRAFT | STATUS | The status of the step, such as COMPLETE or FAILED. |
| Documentation:GIM:Library:View-ADMIN ETL JOB STATUS:8.5PDMSource | DURATION | The duration of the job, in seconds. |
| Documentation:GIM:Library:View-ADMIN ETL JOB STATUS:8.5PDMSource | END_TIME | The date and time at which the last step ended (UTC time zone). |
| Documentation:GIM:Library:View-ADMIN ETL JOB STATUS:8.5PDMSource | JOB_ID | ID that uniquely identifies the execution instance of the job. |
| Documentation:GIM:Library:View-ADMIN ETL JOB STATUS:8.5PDMSource | JOB_NAME | The name of the job, such as Job_ExtractICON. |
| Documentation:GIM:Library:View-ADMIN ETL JOB STATUS:8.5PDMSource | JOB_VERSION | The version of the job, such as 8.1.000.10. |
| Documentation:GIM:Library:View-ADMIN ETL JOB STATUS:8.5PDMSource | START_TIME | The date and time at which the first step started (UTC time zone). |
| Documentation:GIM:Library:View-ADMIN ETL JOB STATUS:8.5PDMSource | STATUS | The status of the step, such as COMPLETE or FAILED. |
| Documentation:GIM:Library:View-ADMIN ETL JOB STATUS:DRAFT | DURATION | The duration of the job, in seconds. |
| Documentation:GIM:Library:View-ADMIN ETL JOB STATUS:DRAFT | END_TIME | The date and time at which the last step ended (UTC time zone). |
| Documentation:GIM:Library:View-ADMIN ETL JOB STATUS:DRAFT | JOB_ID | ID that uniquely identifies the execution instance of the job. |
| Documentation:GIM:Library:View-ADMIN ETL JOB STATUS:DRAFT | JOB_NAME | The name of the job, such as Job_ExtractICON. |
| Documentation:GIM:Library:View-ADMIN ETL JOB STATUS:DRAFT | JOB_VERSION | The version of the job, such as 8.1.000.10. |
| Documentation:GIM:Library:View-ADMIN ETL JOB STATUS:DRAFT | START_TIME | The date and time at which the first step started (UTC time zone). |
| Documentation:GIM:Library:View-ADMIN ETL JOB STATUS:DRAFT | STATUS | The status of the step, such as COMPLETE or FAILED. |
| Documentation:GIM:Library:View-ADMIN ETL JOB STATUS:PDMSource | DURATION | The duration of the job, in seconds. |
| Documentation:GIM:Library:View-ADMIN ETL JOB STATUS:PDMSource | END_TIME | The date and time at which the last step ended (UTC time zone). |
| Documentation:GIM:Library:View-ADMIN ETL JOB STATUS:PDMSource | JOB_ID | ID that uniquely identifies the execution instance of the job. |
| Documentation:GIM:Library:View-ADMIN ETL JOB STATUS:PDMSource | JOB_NAME | The name of the job, such as Job_ExtractICON. |
| Documentation:GIM:Library:View-ADMIN ETL JOB STATUS:PDMSource | JOB_VERSION | The version of the job, such as 8.1.000.10. |
| Documentation:GIM:Library:View-ADMIN ETL JOB STATUS:PDMSource | START_TIME | The date and time at which the first step started (UTC time zone). |
| Documentation:GIM:Library:View-ADMIN ETL JOB STATUS:PDMSource | STATUS | The status of the step, such as COMPLETE or FAILED. |
Comments or questions about this documentation? Contact us for support!