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