Table Detail Report

DM_COMBINE_QUEUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: DM COMBINE QUEUE
Definition: Queue for performing combines in batch mode.
Table Type: ACTIVITY





Column Detail - DM_COMBINE_QUEUE


Column Name Type Null? Definition
BATCH_ERR_MSG VARCHAR(100) Y Error message
COMBINED_FLAG DOUBLE Y Shows status of combine. 0-not attempted, 1-successful, 2-attempted but not successful, 4-marked as "do combine"
CREATE_DT_TM DATETIME Y Date and time the row was created.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
FROM_ID DOUBLE N Value of the id for the from person/encounter of the combine.
PARENT_TABLE VARCHAR(30) N Parent table of the combine (person or encounter).
QUEUE_ID DOUBLE N Primary key of the table - a sequence generated number.
TO_ID DOUBLE N Value of the id for the to person/encounter of the combine.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.



Relationship Detail - DM_COMBINE_QUEUE


Child Column in DM_COMBINE_QUEUE(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID


DM_COMBINE_REVIEW



Column Section Top of Page


Table-level Detail

Description: Stores additional information about combines.
Definition: Stores additional information about combines, such as if a combine detail row was added when combine ran in "REVIEW" mode.
Table Type: ACTIVITY





Column Detail - DM_COMBINE_REVIEW


Column Name Type Null? Definition
PARENT_ENTITY_ID DOUBLE N The value of the primary key of the parent entity this row is related to.
PARENT_ENTITY_NAME VARCHAR(30) N Name of the parent table for this row.
REVIEW_FLAG DOUBLE Y Reason the row is in dm_combine_review.


ENTITY_DETAIL



Column Section Top of Page


Table-level Detail

Description: Entity Detail
Definition: Contains the primary key attributes information of all the child entities rows that were combined.
Table Type: ACTIVITY





Column Detail - ENTITY_DETAIL


Column Name Type Null? Definition
COLUMN_NAME VARCHAR(30) N Contains the primary key attribute name.
DATA_CHAR VARCHAR(100) Y Contains the value of the character data type primary key attribute stored in COLUMN_NAME.
DATA_DATE DATETIME Y Contains the value of the date data type primary key attribute stored in COLUMN_NAME.
DATA_NUMBER DOUBLE Y Contains the value of the number or float data type primary key attribute stored in COLUMN_NAME.
DATA_TYPE VARCHAR(30) N The data type of the primary key attribute stored in COLUMN_NAME.
ENTITY_ID DOUBLE N This is the value of entity_id of COMBINE_DETAIL table. It is an internal system assigned number.