WikiSysop: Created page with "{{ArticleSimplifiedWikiEdit |DisplayName=Table CTL_AUDIT_LOG |Context=This table allows facts and dimensions to be described by data lineage attributes. }} {{PDMTable |table..."

2022-06-29T04:30:37Z

Created page with "{{ArticleSimplifiedWikiEdit |DisplayName=Table CTL_AUDIT_LOG |Context=This table allows facts and dimensions to be described by data lineage attributes. }} {{PDMTable |table..."

New page

{{ArticleSimplifiedWikiEdit
|DisplayName=Table CTL_AUDIT_LOG
|Context=This table allows facts and dimensions to be described by data lineage attributes.
}}
{{PDMTable
|tableName = CTL_AUDIT_LOG
|shortDesc = This table allows facts and dimensions to be described by data lineage attributes.
|tableDesc = 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).
|subjectAreas =
|introduced =
|modified = 8.5.116.12 (PRODUCER_INFO_KEY added); 8.5.003 (in Oracle, fields with <tt>VARCHAR</tt> data types use explicit <tt>CHAR</tt> character-length semantics)
|discontinued =
|group =
|partitioned = yes
}}

{{PDMColumn
|colName = AUDIT_KEY
|dataType_Ora = NUMBER(19)
|dataType_MSSQL = numeric(19)
|dataType_Postgre = numeric(19)
|primaryKey = yes
|mandatory = yes
|foreignKey =
|default =
|colDesc = 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.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = JOB_ID
|dataType_Ora = VARCHAR2(64 CHAR)
|dataType_MSSQL = varchar(64)
|dataType_Postgre = varchar(64)
|primaryKey =
|mandatory = yes
|foreignKey =
|default =
|colDesc = ID that uniquely identifies the execution instance of the job.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = CREATED
|dataType_Ora = TIMESTAMP(3)
|dataType_MSSQL = datetime
|dataType_Postgre = timestamp(3)
|primaryKey =
|mandatory = yes
|foreignKey =
|default =
|colDesc = The date and time of row creation.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = INSERTED
|dataType_Ora = TIMESTAMP(3)
|dataType_MSSQL = datetime
|dataType_Postgre = timestamp(3)
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = 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.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = PROCESSING_STATUS_KEY
|dataType_Ora = NUMBER(10)
|dataType_MSSQL = int
|dataType_Postgre = integer
|primaryKey =
|mandatory = yes
|foreignKey =
|default =
|colDesc = Reference to the CTL_PROCESSING_STATUS dimension. This field is reserved.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = MIN_START_DATE_TIME_KEY
|dataType_Ora = NUMBER(10)
|dataType_MSSQL = int
|dataType_Postgre = integer
|primaryKey =
|mandatory =
|foreignKey = yes
|default =
|colDesc = 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.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = MAX_START_DATE_TIME_KEY
|dataType_Ora = NUMBER(10)
|dataType_MSSQL = int
|dataType_Postgre = integer
|primaryKey =
|mandatory =
|foreignKey = yes
|default =
|colDesc = 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.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = MAX_CHUNK_TS
|dataType_Ora = NUMBER(10)
|dataType_MSSQL = int
|dataType_Postgre = integer
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = The maximum value out of all timestamps that are stored for a particular chunk of data that is marked with the corresponding audit key.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = DATA_SOURCE_KEY
|dataType_Ora = NUMBER(10)
|dataType_MSSQL = int
|dataType_Postgre = integer
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = 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 =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = ROW_COUNT
|dataType_Ora = NUMBER(10)
|dataType_MSSQL = int
|dataType_Postgre = integer
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = The number of records that are marked with this audit key.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = CREATED_TS
|dataType_Ora = NUMBER(10)
|dataType_MSSQL = int
|dataType_Postgre = integer
|primaryKey =
|mandatory = yes
|foreignKey =
|default =
|colDesc = The UTC-equivalent value of the date and time of row creation.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = PRODUCER_INFO_KEY
|dataType_Ora = NUMBER(19)
|dataType_MSSQL = numeric(19)
|dataType_Postgre = numeric(19)
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = Reference to the CTL_PRODUCER_INFO dimension, to identify the version of the upstream application or service that produced Kafka data.
|introduced = 8.5.116.12
|modified =
|discontinued =
}}

{{PDMIndex}}
{{PDMIndexItem
|indexName = IDX_CTL_AL_CTS
|indexDesc = Improves purge performance.
|indexPresentInPartitioned = yes
|indexKey = CREATED_TS
|keyPresentInNonpartitioned = yes
|sort = Ascending
|unique =
|cluster =
}}

{{PDMRef
|parentTable = DATE_TIME
|parentColumn = DATE_TIME_KEY
|foreignKey = MIN_START_DATE_TIME_KEY
}}

{{PDMRef
|parentTable = DATE_TIME
|parentColumn = DATE_TIME_KEY
|foreignKey = MAX_START_DATE_TIME_KEY
}}

Documentation:PEC-REP/Library/PDMLibraryGIM/Table-CTL AUDIT LOG - Revision history

WikiSysop: Created page with "{{ArticleSimplifiedWikiEdit |DisplayName=Table CTL_AUDIT_LOG |Context=This table allows facts and dimensions to be described by data lineage attributes. }} {{PDMTable |table..."