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. |