Table Detail Report

DM_REFCHG_TRG_COL



Column Section Top of Page


Table-level Detail

Description: Data Management Reference Trigger Columns
Definition: List of columns to not log changes for in DM_CHG_LOG
Table Type: REFERENCE





Column Detail - DM_REFCHG_TRG_COL


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
COLUMN_NAME VARCHAR(30) N Name of the column
DM_REFCHG_TRG_COL_ID DOUBLE N The primary key of the table
TABLE_NAME VARCHAR(30) N Name of the table
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.


DM_REFCHG_VERSION_R



Column Section Top of Page


Table-level Detail

Description: Data management reference version table relationship
Definition: Holds the list of child tables that have a VERSION_NBR type of column and the parent tables where the ultimate VERSION_NBR exists.
Table Type: REFERENCE





Column Detail - DM_REFCHG_VERSION_R


Column Name Type Null? Definition
CHILD_ID_COL VARCHAR(30) Y The column name on the child table that is a foreign key to the parent_id_col
CHILD_TABLE VARCHAR(30) Y The table name that the child_vers_col exists on
CHILD_VERS_COL VARCHAR(30) Y The column name on the child table that contains the same version data as parent_vers_col.
DM_REFCHG_VERSION_R_ID DOUBLE N Sequence generated primary key
PARENT_ID_COL VARCHAR(30) Y The column name on the parent table that the child_id_col points to.
PARENT_TABLE VARCHAR(30) Y The table name where the ultimate version_nbr column exists
PARENT_VERS_COL VARCHAR(30) Y The column name on the parent table that the child_vers_col points to.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.


DM_REFCHG_WARNING



Column Section Top of Page


Table-level Detail

Description: Data management reference change warnings
Definition: Warnings issued during RDDS data moves
Table Type: ACTIVITY





Column Detail - DM_REFCHG_WARNING


Column Name Type Null? Definition
DML_TXT VARCHAR(4000) Y Statement that was run that caused the error to occur.
DM_REFCHG_WARNING_ID DOUBLE N Unique identifier
ERROR_MSG VARCHAR(2000) Y CCL/RDBMS error message
MESSAGE VARCHAR(2000) N Warning message
ROW_SELECT_TXT VARCHAR(2000) Y Statement which will retrieve the rows on the $R table that caused the error to occur.
SOURCE_ENV_ID DOUBLE N Environment id being moved in when the error occurred. This value comes from DM_ENVIRONMENT table in the Admin DB.
TABLE_NAME VARCHAR(30) Y Name of the table that the warning is related to.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
WARNING_TYPE VARCHAR(50) N Type of warning - e.g. DUP_BEFORE_CUTOVER


DM_REFCHG_XLAT_CTXT_R



Column Section Top of Page


Table-level Detail

Description: Database Management Reference Change Translation Context Relationship
Definition: A table to store the relationship of new translations and what context the translation was created under.
Table Type: REFERENCE





Column Detail - DM_REFCHG_XLAT_CTXT_R


Column Name Type Null? Definition
CONTEXT_NAME VARCHAR(30) N Holds the context name that created the translation
DM_REFCHG_XLAT_CTXT_R_ID DOUBLE N Top level PK column for table
FROM_VALUE DOUBLE N Holds the Source from value of the translation
TABLE_NAME VARCHAR(30) N Holds the table name of the translation
TO_VALUE DOUBLE N Holds the Target To Value of the translation
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.


DM_REF_CONS_COLS



Column Section Top of Page


Table-level Detail

Description: Contains referential constraints, indexed by parent table, for Recursive Merge
Definition: Work table for recursive merge.
Table Type: ACTIVITY





Column Detail - DM_REF_CONS_COLS


Column Name Type Null? Definition
CHILD_COLUMN VARCHAR(30) N Column name in the referential constraint.
CHILD_CONSTRAINT VARCHAR(30) N Referential Constraint Name
CHILD_POSITION DOUBLE N Position of the constraint column in the constraint.
CHILD_TABLE VARCHAR(30) N Table name that the constraint is on.
PARENT_COLUMN VARCHAR(30) N Column name in the table that the referential constraint refers to.
PARENT_TABLE VARCHAR(30) N Table name that the referential constraint refers to.