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 |