Table Detail Report

DM_CMB_METADATA



Column Section Top of Page


Table-level Detail

Description: DM_CMB_METADATA
Definition: Host additional metadata for the combine framework
Table Type: REFERENCE





Column Detail - DM_CMB_METADATA


Column Name Type Null? Definition
ACTIVE_ONLY_FLAG DOUBLE N Flag to indicate whether this combine should only apply to active rows. 0 = This combine should process active and inactive rows, which is the default behavior. 1 = This combine should only combine active rows.;
CHILD_COLUMN VARCHAR(32) N The column that will participate in combines on this table
CHILD_CONS_NAME VARCHAR(32) Y The optional name of the FK constraint for the child_column.
CHILD_PE_NAME1_TXT VARCHAR(32) Y The first optional value used to identify combinable data in the child_pe_name_column.
CHILD_PE_NAME2_TXT VARCHAR(32) Y The second optional value used to identify combinable data in the child_pe_name_column.
CHILD_PE_NAME3_TXT VARCHAR(32) Y The third optional value used to identify combinable data in the child_pe_name_column.
CHILD_PE_NAME_COLUMN VARCHAR(32) Y The optional parent_entity_name type column that relates to the child_column.
CHILD_PK VARCHAR(32) N The primary key column name for this table, which must be a single column primary key.
CHILD_TABLE VARCHAR(32) N The name of the combinable table
COMBINE_ACTION_TYPE_CD DOUBLE N Optional special action code for this combine, driven from CS 327.
CREATE_DT_TM DATETIME Y The date and time the row was inserted
DM_CMB_METADATA_ID DOUBLE N PRIMARY KEY
PARENT_TABLE VARCHAR(32) N Type of COMBINE this row relates to (i.e. PERSON, ENCOUNTER, PRSNL¿);
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.


DM_CMB_TAB_COLUMNS



Column Section Top of Page


Table-level Detail

Description: DM CMB TAB COLUMNS
Definition: Mirror table of user_tab_columns used for improved combine performance.
Table Type: REFERENCE





Column Detail - DM_CMB_TAB_COLUMNS


Column Name Type Null? Definition
COLUMN_NAME VARCHAR(30) N Name of columns in the table.
TABLE_NAME VARCHAR(30) N Name of table in the database.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.


DM_CMB_WARNING



Column Section Top of Page


Table-level Detail

Description: Combine Warning
Definition: Holds the most recent warnings from combine scripts performing questionable combnies/uncombines.
Table Type: ACTIVITY





Column Detail - DM_CMB_WARNING


Column Name Type Null? Definition
COMBINE_ENTITY_ID DOUBLE N ID of Combine which generated the warning.
COMBINE_ENTITY_NAME VARCHAR(30) N Table which the combine_id comes from - e.g. 'PERSON_COMBINE','ENCNTR_COMBINE','COMBINE'.
DM_CMB_WARNING_ID DOUBLE N Sequence generated primary key
PARENT_ENTITY_ID DOUBLE N Id of entity being uncombined.
PARENT_ENTITY_NAME VARCHAR(30) Y Table name of entity being uncombined.
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.
WARNING_TYPE_CD DOUBLE N Type of warning noted when a questionable combine/uncombine is performed. For example, FUTUREORDER


DM_COMBINE_AUDIT



Column Section Top of Page


Table-level Detail

Description: Database Management Combine Audit
Definition: Stores a history of all combine types for auditing purposes
Table Type: ACTIVITY





Column Detail - DM_COMBINE_AUDIT


Column Name Type Null? Definition
APPLICATION_FLAG DOUBLE Y Tells which type of application sends the transaction.
CALLING_SCRIPT VARCHAR(30) Y The script that was initially called for the combine event listed.
CHILD_ENTITY_COL VARCHAR(32) Y Name of foreign key attribute of child table
CHILD_ENTITY_NAME VARCHAR(32) Y The name of the table to which this combine row is related.
CHILD_ENTITY_SCRIPT_NAME VARCHAR(50) Y Name of the custom script to be executed for the child table
COMBINE_ERROR_ID DOUBLE N A unique identifier for a row in the dm_combine_error table.
COMBINE_GROUP_ID DOUBLE N This is a group identifier which will be unique per combine event.
COMBINE_MODE VARCHAR(20) Y Mode that the combine was run in.
DM_COMBINE_AUDIT_ID DOUBLE N Primary Key for table
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table.
END_DT_TM DATETIME Y The end date/time of the combine event listed.
FROM_ENTITY_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.
INST_ID DOUBLE N Instance identifier
LOG_LEVEL DOUBLE N The level of logging associated with the combine event. (1=per combine event, 2=per table)
OPERATION_TYPE VARCHAR(20) N The operation being performed for the combine event listed. (Combine, Uncombine)
OSUSER VARCHAR(30) N Operating system client user name
PARENT_ENTITY_ID DOUBLE N This is the value of the unique primary identifier of the parent_entity¿s combine table.
PARENT_ENTITY_NAME VARCHAR(32) N Parent entity for the combine/uncombine (i.e. person, encounter).
PROCESS_IDENT VARCHAR(12) Y Operating system client process ID
PROGRAM_NAME VARCHAR(48) Y Operating system program name
REVERSE_CMB_IND DOUBLE Y Indicates whether or not reverse combines were used in this particular combine event.
SESSION_ID DOUBLE N Session identifier
START_DT_TM DATETIME Y The start date/time of the combine event listed.
TO_ENTITY_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.
TRANSACTION_TYPE VARCHAR(8) Y The type of transaction that triggers the combine.
UPDT_APPLCTX DOUBLE N The application 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_COMBINE_ERROR



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table logs errors from the combine and uncombine processes.
Definition: This table logs errors from the combine and uncombine processes. The error log will wrap after it reaches the max_value of combine_error_seq.
Table Type: ACTIVITY





Column Detail - DM_COMBINE_ERROR


Column Name Type Null? Definition
APPLICATION_FLAG DOUBLE Y Tells which type of application sends the transaction.
CALLING_SCRIPT VARCHAR(30) Y The script that was initially called. Dm_combine can either be called directly, or it can be called by dm_uncombine. If dm_combine was called by dm_uncombine, dm_uncombine is the calling_script - if it's called directly, dm_call_combine is the calling_script.
COMBINE_ERROR_ID DOUBLE N A unique identifier for a row in the dm_combine_error table. It is a sequence generated number. Note: once the max_value of combine_error_seq is used, the sequence will start over with a value of 1, and the log will wrap.
COMBINE_ID DOUBLE N If calling_script='dm_uncombine,' this field will be filled out with the value of the combine_id that dm_uncombine attempted to uncombine. If parent_entity='person,' combine_id is a person_combine_id - if parent_entity='encounter', combine_id is an encntr_combine_id.
COMBINE_MODE VARCHAR(20) Y Mode that the combine was run in. Examples: blank means normal; "review" means combine was run again to clean up rows that may have been added after the original combine.
CREATE_DT_TM DATETIME Y Date and time the record 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.
ERROR_MSG VARCHAR(132) Y If a ccl error is encountered, the error message is stored in this field.
ERROR_TABLE VARCHAR(32) Y The table that was being processed when an error was encountered. This cannot always be captured, so it will not always be filled out.
ERROR_TYPE VARCHAR(50) Y The type of error that was encountered. This type corresponds to an error type within the combine or uncombine code, and is useful for debugging.
FROM_ID DOUBLE N This is the value of the 'from_id' (i.e. from person_id or from encntr_id) during the combine/uncombine.
OPERATION_TYPE VARCHAR(20) N The operation that was being performed when the error was encountered. Useful for errors with 'calling_script' = dm_uncombine. If calling_script='dm_uncombine' and operation_type='combine', dm_uncombine called dm_combine, and an error occurred while dm_combine was executing.
PARENT_ENTITY VARCHAR(32) N Parent entity for the combine/uncombine (i.e. person, encounter).
RESOLVED_IND DOUBLE Y Set to 0 if the error has not been resolved, and 1 if it has been resolved.
TO_ID DOUBLE N This is the value of the 'to_id' (i.e. from person_id or from encntr_id) during the combine/uncombine.
TRANSACTION_TYPE VARCHAR(8) Y The type of transaction that triggers the combine. For ESI transactions, the transaction_type will be the MSH event, e.g., A01, A02, ... For the combine tool, the transaction_type will be blank.
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 - DM_COMBINE_ERROR


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