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.