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