EXT_DOC_TEMPLATE_CONFIG



Column Section Relationship Section Top of Page


Table-level Detail

Description: External Document Template Configuration
Definition: Stores reference data defining which Document Template to use based on various criteria.
Table Type: REFERENCE





Column Detail - EXT_DOC_TEMPLATE_CONFIG


Column Name Type Null? Definition
EXT_DOC_TEMPLATE_CONFIG_ID DOUBLE N PRIMARY KEY
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
PERSONA_CD DOUBLE N The type of person viewing the document (e.g. PATIENT, PROVIDER).
TEMPLATE_ID DOUBLE N The ID of the template to be used for this configuration. Foreign key from CR_REPORT_TEMPLATE.
TYPE_CD DOUBLE N The type of document being viewed (e.g. PATHOLOGY, RADIOLOGY).
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.



Relationship Detail - EXT_DOC_TEMPLATE_CONFIG


Child Column in EXT_DOC_TEMPLATE_CONFIG(FK) Parent Table Name Parent Column Name
Parents: TEMPLATE_ID CR_REPORT_TEMPLATE REPORT_TEMPLATE_ID
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID


VITALS_EXT_DATA



Column Section Relationship Section Top of Page


Table-level Detail

Description: Vitals External Data
Definition: Staging table to hold untrusted data sent to be written from an external source (eg. FHIR).
Table Type: ACTIVITY





Column Detail - VITALS_EXT_DATA


Column Name Type Null? Definition
ACTION_DT_TM DATETIME Y The date and time of the action
ACTION_PRSNL_ID DOUBLE N The personnel who performed the action.
ACTIVE_IND DOUBLE N 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 N 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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CORRELATION_IDENT VARCHAR(80) Y UUID that identifies the transaction that updated this row.
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data.
ENCNTR_ID DOUBLE N
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
ISSUED_DT_TM DATETIME Y The date and time this external data was made available to providers, typically after the results have been reviewed and verified.
PERSON_ID DOUBLE N
REQUEST_ACTION_CD DOUBLE N Action requested for the data.
RESULT_IDENT VARCHAR(80) Y the identifier of the result that came through FHIR. The identifier could be a clinical_event_id if the request came from another Millennium domain or an identifier from another system.
SUBMITTED_DT_TM DATETIME Y The date and time this external data was added to the staging table.
TENANT_IDENT VARCHAR(80) Y The identifier of the source of this external data.
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.
VERSION_NBR DOUBLE Y
VITALS_BLOB LONGBLOB Y The data that has come from an external source.
VITALS_EXT_DATA_ID DOUBLE N PRIMARY KEY
VITALS_STAGE_ID DOUBLE N



Relationship Detail - VITALS_EXT_DATA


Child Column in VITALS_EXT_DATA(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
VITALS_STAGE_ID VITALS_EXT_DATA VITALS_EXT_DATA_ID




Parent Column in VITALS_EXT_DATA (PK) Child Table Name Child Column Name
Children: VITALS_EXT_DATA_ID VITALS_EXT_DATA VITALS_STAGE_ID
VITALS_EXT_IDENTIFIER VITALS_EXT_DATA_ID
VITALS_EXT_STANDARD_CODE VITALS_EXT_DATA_ID


VITALS_EXT_IDENTIFIER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Vitals external identifier
Definition: This staging table holds the universally unique identifer of a vital result and whether it was written to the staging table or to the clinical event table. ;
Table Type: ACTIVITY





Column Detail - VITALS_EXT_IDENTIFIER


Column Name Type Null? Definition
EVENT_ID DOUBLE N The EVENT id of the clinical event associated with this data if the data was written to clinical event.
SYSTEM_URI VARCHAR(80) Y The URI of the coding system.
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.
VALUE_STR VARCHAR(80) Y The codified value.
VITALS_EXT_DATA_ID DOUBLE N The primary key of the vitals external data staging table if the data was staged.
VITALS_EXT_IDENTIFIER_ID DOUBLE N PRIMARY KEY



Relationship Detail - VITALS_EXT_IDENTIFIER


Child Column in VITALS_EXT_IDENTIFIER(FK) Parent Table Name Parent Column Name
Parents: VITALS_EXT_DATA_ID VITALS_EXT_DATA VITALS_EXT_DATA_ID


VITALS_EXT_STANDARD_CODE



Column Section Relationship Section Top of Page


Table-level Detail

Description: External standard codes staging table
Definition: Contains codified values from an external source like FHIR and association to the vitals staged data.
Table Type: ACTIVITY





Column Detail - VITALS_EXT_STANDARD_CODE


Column Name Type Null? Definition
CODE_STR VARCHAR(40) Y The codified value.
DISPLAY_STR VARCHAR(255) Y The display string of the codified value.
SYSTEM_URI VARCHAR(80) Y The URI of the coding system.
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.
VERSION_STR VARCHAR(10) Y The version of the coding system.
VITALS_EXT_DATA_ID DOUBLE N The primary key of the external data associated with this codified value.
VITALS_EXT_STANDARD_CODE_ID DOUBLE N PRIMARY KEY



Relationship Detail - VITALS_EXT_STANDARD_CODE


Child Column in VITALS_EXT_STANDARD_CODE(FK) Parent Table Name Parent Column Name
Parents: VITALS_EXT_DATA_ID VITALS_EXT_DATA VITALS_EXT_DATA_ID