Table Detail Report

DM_PARENT_CHILD



Column Section Top of Page


Table-level Detail

Description: Environment Merge Parent Child Relationship Table
Definition: Parent to Child and Child to Parent relationship table
Table Type: ACTIVITY





Column Detail - DM_PARENT_CHILD


Column Name Type Null? Definition
CHILD_COL_NAME VARCHAR(30) N CHILD TABLE COLUMN NAME
CHILD_TABLE VARCHAR(30) N CHILD TABLE NAME
PARENT_COL_NAME VARCHAR(30) N PARENT TABLE COLUMN NAME
PARENT_TABLE VARCHAR(30) N PARENT TABLE NAME


DM_PC_TEMP



Column Section Top of Page


Table-level Detail

Description: TEMPORARY WORK TABLE FOR DM_PARENT_CHILD TABLE AND ENVIRONMENT MERGE
Definition: TEMPORARY WORK TABLE
Table Type: ACTIVITY





Column Detail - DM_PC_TEMP


Column Name Type Null? Definition
CHILD_TABLE VARCHAR(30) Y CHILD TABLE NAME
LEVEL_IND DOUBLE N LEVEL INDICATORColumn
MAJOR_PARENT_TABLE VARCHAR(30) Y MAJOR PARENT TABLE NAME
MINOR_TABLE VARCHAR(30) Y MINOR TABLE NAME
SEQUENCE DOUBLE N SEQUENCE


DM_TABLE_TREE



Column Section Top of Page


Table-level Detail

Description: ENVIRONMENT MERGE TREE TABLE
Definition: CONTAINS USER SCHEMA TREE LIST FOR ALL TABLES
Table Type: ACTIVITY





Column Detail - DM_TABLE_TREE


Column Name Type Null? Definition
CHILD_TABLE VARCHAR(30) N CHILD TABLE NAME
MAJOR_PARENT_TABLE VARCHAR(30) N MAJOR PARENT TABLE NAME
SEQUENCE DOUBLE N SEQUENCE
TABLE_NAME VARCHAR(30) N TABLE NAMEColumn


VIRTUAL_VIEW



Column Section Top of Page


Table-level Detail

Description: VIRTUAL VIEW
Definition: One row per virtual view
Table Type: REFERENCE





Column Detail - VIRTUAL_VIEW


Column Name Type Null? Definition
DESCRIPTION VARCHAR(60) Y description of the virtual viewColumn
DISPLAY VARCHAR(40) Y display of the virtual viewColumn
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.
VIRTUAL_VIEW_ID DOUBLE N unique identifier for each virtual viewColumn