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 |