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 |