This page was last edited on June 23, 2022, at 03:49.
Comments or questions about this documentation? Contact us for support!
In the Column List:
Modified: 8.5.116.12 (PRODUCER_INFO_KEY added); 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
In partitioned databases, this table is partitioned.
This table allows facts and dimensions to be described by data lineage attributes. Each row represents a logical transaction that is committed by Genesys Info Mart, identifying the ETL job that is involved in the transaction, including the minimum and maximum DATE_TIME values (which give a date-time range for the data that is committed in the transaction), and providing the processing status (an internal indicator of the kind of data that is processed).
Column | Data Type | P | M | F | DV |
---|---|---|---|---|---|
AUDIT_KEY | numeric(19) | X | X | ||
JOB_ID | varchar(64) | X | |||
CREATED | timestamp(3) | X | |||
INSERTED | timestamp(3) | ||||
PROCESSING_STATUS_KEY | integer | X | |||
MIN_START_DATE_TIME_KEY | integer | X | |||
MAX_START_DATE_TIME_KEY | integer | X | |||
MAX_CHUNK_TS | integer | ||||
DATA_SOURCE_KEY | integer | ||||
ROW_COUNT | integer | ||||
CREATED_TS | integer | X | |||
PRODUCER_INFO_KEY | numeric(19) |
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.
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.
Reference to the CTL_PROCESSING_STATUS dimension. This field is reserved.
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.
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.
The maximum value out of all timestamps that are stored for a particular chunk of data that is marked with the corresponding audit 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.
Introduced: Release 8.5.116.12
Reference to the CTL_PRODUCER_INFO dimension, to identify the version of the upstream application or service that produced Kafka data.
CODE | U | C | Description |
---|---|---|---|
IDX_CTL_AL_CTS | Improves purge performance. |
Field | Sort | Comment |
---|---|---|
CREATED_TS | Ascending |
No subject area information available.