Table Detail Report

DM_CMB_CHILDREN_PK



Column Section Top of Page


Table-level Detail

Description: data management combine children primary key
Definition: Stores primary key information for child tables of LOCATION, ORGANIZATION, HEALTH_PLAN and PRSNL
Table Type: REFERENCE





Column Detail - DM_CMB_CHILDREN_PK


Column Name Type Null? Definition
CHILD_TABLE VARCHAR(30) N Name of child table that will be updated by the combine process
CREATE_DT_TM DATETIME Y The date and time when the child table was added to the list
PK_COLUMN_NAME VARCHAR(30) N Name of column on the child table that is part of the primary key
PK_COLUMN_POS DOUBLE N Position of child table's column that is part of primary key
PK_COLUMN_TYPE VARCHAR(20) N Data type of child table's primary key column
PK_IND DOUBLE N Indicates if index is primary key.
PK_INDEX_NAME VARCHAR(30) N Name of primary key index on the child 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_CMB_CONSTRAINTS



Column Section Relationship Section Top of Page


Table-level Detail

Description: DM CMB CONSTRAINTS
Definition: Mirror table of user_constraints used for improved combine performance
Table Type: REFERENCE





Column Detail - DM_CMB_CONSTRAINTS


Column Name Type Null? Definition
CONSTRAINT_NAME VARCHAR(30) N Name of ORACLE constraints
CONSTRAINT_TYPE CHAR(1) N Type of constraints. P for primary keys, R for foreign keys.
R_CONSTRAINT_NAME VARCHAR(30) Y Primary key constraint referenced by the foreign key. Only valid for constraint_type ="R"
TABLE_NAME VARCHAR(30) N Name of table the constraint is on.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.



Relationship Detail - DM_CMB_CONSTRAINTS




Parent Column in DM_CMB_CONSTRAINTS (PK) Child Table Name Child Column Name
Children: CONSTRAINT_NAME DM_CMB_CONS_COLUMNS CONSTRAINT_NAME


DM_CMB_CONS_COLUMNS



Column Section Relationship Section Top of Page


Table-level Detail

Description: DM CMB CONS COLUMNS
Definition: Mirror table of user_cons_columns. Used for improved combine performance.
Table Type: REFERENCE





Column Detail - DM_CMB_CONS_COLUMNS


Column Name Type Null? Definition
COLUMN_NAME VARCHAR(30) N Name of the column in the constraint.
CONSTRAINT_NAME VARCHAR(30) N Name of the ORACLE constraints.
POSITION DOUBLE N Position the column holds in the constraint.
TABLE_NAME VARCHAR(30) N Name of the table the constraint is on.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.



Relationship Detail - DM_CMB_CONS_COLUMNS


Child Column in DM_CMB_CONS_COLUMNS(FK) Parent Table Name Parent Column Name
Parents: CONSTRAINT_NAME DM_CMB_CONSTRAINTS CONSTRAINT_NAME


DM_CMB_EM_CHILDREN



Column Section Top of Page


Table-level Detail

Description: DM_CMB_EM_CHILDREN
Definition: List of child tables that reference PERSON and also are indirectly related to ENCOUNTER
Table Type: REFERENCE





Column Detail - DM_CMB_EM_CHILDREN


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.
CHILD_CMB_COLUMN VARCHAR(30) N Name of PERSON foreign key column on child table that takes part in person combines; this column needs to be correctly updated after encounter move operation
CHILD_PK_COLUMN VARCHAR(30) N Name of primary key column on child table
CHILD_TABLE VARCHAR(30) N Name of child table that takes part in person combines and is indirectly related to ENCOUNTER
DM_CMB_EM_CHILDREN_ID DOUBLE N Unique generated number that identifies a single row on the DM_CMB_EM_CHILDREN table.
FROM_CLAUSE VARCHAR(1000) Y List of table names to join, including child_table and parent_table above
PARENT_CMB_COLUMN VARCHAR(30) N Name of PERSON foreign key column on parent table that takes part in person combines; this column has the correct value after encounter move operation
PARENT_TABLE VARCHAR(30) N Name of parent table that takes part in person combines and direct child of ENCOUNTER
RUN_ORDER DOUBLE N Run Order Sequence
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.
WHERE_CLAUSE VARCHAR(2000) Y Join predicates for the table names listed above in the from clause


DM_CMB_EXCEPTION



Column Section Top of Page


Table-level Detail

Description: COMBINE EXCEPTION
Definition: THIS TABLE IS USED DURING THE COMBINE AND UNCOMBINE PROCESSES TO IDENTIFY TABLES THAT WILL NOT BE COMBINED/UNCOMBINED USING THE GENERIC LOGIC. INSTEAD, THESE TABLES WILL BE COMBINED/UNCOMBINED USING CUSTOM SCRIPTS NAMED IN THIS TABLE.
Table Type: REFERENCE





Column Detail - DM_CMB_EXCEPTION


Column Name Type Null? Definition
CHILD_ENTITY VARCHAR(32) N Name of the child table that needs to be combined using custom logic.
DEL_CHG_ID_IND DOUBLE N A 1 indicates that the custom script will change the person or encounter id on the child table to the 'to' value during a 'delete.' A 0 indicates that the custom script will not change the value of person or encounter id on the child table during a 'delete.'
OPERATION_TYPE VARCHAR(20) N Valid values are 'COMBINE' and 'UNCOMBINE.' This allows a child table to have a custom script for combines and a custom script for uncombines.
PARENT_ENTITY VARCHAR(32) N Parent table for the combine, e.g. person or encounter.
SCRIPT_NAME VARCHAR(50) Y Name of the custom script to be executed for the child table. A value of 'NONE' indicates that nothing should be done to the table during the operation (combine or uncombine). Scripts are named according to a naming convention: person_cmb_, encntr_cmb_, person_ucb_, or encntr_ucb_.
SCRIPT_RUN_ORDER DOUBLE N Some custom scripts need to be run before others in order for the logic to work correctly. The value here indicates the precedence for the script to be run. All the 1's are run first, then all the 2's, etc.
SINGLE_ENCNTR_IND DOUBLE Y Indicates whether the script should be called during a single-encounter person combine. A '1' means yes, and a '0' means no. If the child table has foreign key relationships to both person and encounter and custom logic is needed for person combines, the custom script should handle single-encounter person combines, and the value here should be '1'. Otherwise, the value should be '0.'
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.