COMBINE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Combine |
Definition: | Contains the audit trail for all entities that were combined as a result of determining that the two rows in the parent entity table represent the same entities. |
Table Type: | ACTIVITY |
Column Detail - COMBINE
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | 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. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | Y | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
APPLICATION_FLAG | DOUBLE | Y | Application Flag |
CMB_DT_TM | DATETIME | Y | Date when combine finished |
CMB_UPDT_ID | DOUBLE | Y | Person who performed the combine |
COMBINE_ID | DOUBLE | N | This is the value of the unique primary identifier of the person combine table. It is an internal system assigned number. |
COMMENT_TXT | VARCHAR(250) | Y | Free Text Comment entered by the user describing the reason for the combine. |
CONTRIBUTOR_SYSTEM_CD | DOUBLE | N | Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed. |
FROM_ID | DOUBLE | N | This is the value of the unique primary identifier from the PARENT_ENTITY table of the 'from' parent entity that was combined. It is an internal system assigned number. |
PARENT_ENTITY | VARCHAR(30) | N | Contains the name of the parent entity that got combined,e.g.:LOCATION, PRSNL, etc. |
TO_ID | DOUBLE | N | This is the value of the unique primary identifier from the PARENT_ENTITY table of the 'to' parent entity that was combined into. It is an internal system assigned number. |
TRANSACTION_TYPE | VARCHAR(8) | Y | Transaction Type |
UCB_DT_TM | DATETIME | Y | Date when uncombine finished |
UCB_UPDT_ID | DOUBLE | Y | Person who performed the uncombine |
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. |
Relationship Detail - COMBINE
Parent Column in COMBINE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | COMBINE_ID | COMBINE_DETAIL | COMBINE_ID |
COMBINE_DETAIL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Combine Detail |
Definition: | Contains an audit trail for every row in every table where the field of the foreign key to the parent entity was changed to a new value as a result of combining two rows in the parent entity table. |
Table Type: | ACTIVITY |
Column Detail - COMBINE_DETAIL
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | 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. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | Y | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
ATTRIBUTE_NAME | VARCHAR(30) | Y | Name of the attribute on the child table that is related to the parent entity's primary key attribute. |
COMBINE_ACTION_CD | DOUBLE | N | The action that was taken on the child row during the combine, e.g. DEL, UPT, etc. |
COMBINE_DETAIL_ID | DOUBLE | N | This is the value of the unique primary identifier of the combine detail table. It is an internal system assigned number. |
COMBINE_ID | DOUBLE | N | This is the value of the unique primary identifier of the combine table. It is an internal system assigned number. |
ENTITY_ID | DOUBLE | N | This is the value of the unique primary identifier of the ENTITY_DETAIL table. It is an internal system assigned number. |
ENTITY_NAME | VARCHAR(30) | N | The upper case name of the table to which this row is related. |
PREV_ACTIVE_IND | DOUBLE | N | Reference Data Domain Sync (RDDS) use for determining historical occurrences. |
PREV_ACTIVE_STATUS_CD | DOUBLE | N | The value of the active_status_cd prior to the row being combined. Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
PREV_CONFID_LEVEL_CD | DOUBLE | N | The value of contributor_system_cd prior to the row being combined. Contributor system identifies the source feed of data from which a row was populated. |
PREV_END_EFF_DT_TM | DATETIME | Y | If a row is made 'not effective' during a combine, the value of its end_effective_dt_tm column before combine is stored here. |
TO_RECORD_IND | DOUBLE | Y | If set to 1, this record was originally a child of the 'to' parent record. |
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. |
Relationship Detail - COMBINE_DETAIL
Child Column in COMBINE_DETAIL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | COMBINE_ID | COMBINE | COMBINE_ID |
COMBINE_DET_VALUE
Column Section | Top of Page |
Table-level Detail
Description: | Combine Detail Values |
Definition: | Stores values of columns that have been modified as part of the combine process. |
Table Type: | ACTIVITY |
Column Detail - COMBINE_DET_VALUE
Column Name | Type | Null? | Definition |
---|---|---|---|
COLUMN_NAME | VARCHAR(30) | N | Name of the column that is being saved in this table during combine |
COLUMN_TYPE | VARCHAR(5) | Y | Type of the column that is being saved in this table during combine |
COMBINE_DET_VALUE_ID | DOUBLE | N | Primary key. |
COMBINE_ID | DOUBLE | N | Identifier for row referenced from one of the three parent combine tables. |
COMBINE_PARENT | VARCHAR(30) | N | Parent table for the kind of combine. |
ENTITY_ID | DOUBLE | N | This is the value of the unique primary identifier of the ENTITY_NAME table. |
ENTITY_NAME | VARCHAR(30) | N | This is the name of the table that contains data to be combined. |
FROM_VALUE | VARCHAR(2000) | Y | Old value of the column that is being saved in this table during combine |
PARENT_ENTITY | VARCHAR(30) | N | Parent table for the kind of combine. |
TO_VALUE | VARCHAR(2000) | Y | New value of the column that is being saved in this table during combine |
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_CHILDREN
Column Section | Top of Page |
Table-level Detail
Description: | DM CMB CHILDREN |
Definition: | Stores Person and Encounter child tables |
Table Type: | REFERENCE |
Column Detail - DM_CMB_CHILDREN
Column Name | Type | Null? | Definition |
---|---|---|---|
CHILD_COLUMN | VARCHAR(32) | N | Name of foreign key attribute of child table |
CHILD_CONS_NAME | VARCHAR(30) | N | Name of the FK constraint on the child_table that references the parent_table. |
CHILD_PK | VARCHAR(32) | Y | Name of primary key attribute |
CHILD_TABLE | VARCHAR(32) | N | Name of child table that will be updated in the combine |
CREATE_DT_TM | DATETIME | Y | The date and time the row was inserted. |
PARENT_TABLE | VARCHAR(32) | N | Name of combine parent table, such as PERSON, etc. |
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_CHILDREN2
Column Section | Top of Page |
Table-level Detail
Description: | Data management Combine Children table 2 |
Definition: | Stores list of child tables to facilitate the combine process for LOCATION, ORGANIZATION, HEALTH_PLAN and PRSNL |
Table Type: | REFERENCE |
Column Detail - DM_CMB_CHILDREN2
Column Name | Type | Null? | Definition |
---|---|---|---|
CHILD_COLUMN | VARCHAR(30) | N | Name of column on the child table that will be updated by the combine process. Usually this column references the parent table. |
CHILD_CONS_NAME | VARCHAR(30) | N | Name of foreign key constraint on the child table that references the parent table |
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 |
PARENT_TABLE | VARCHAR(30) | N | Name of combine parent table, such as LOCATION etc. |
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. |