Table Detail Report
SI_DOCUMENT_TRANSACTION_LOG
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | System Integration Document Transaction Logging |
Definition: | Log information or Error Information for transactions that request or generate clinical documents. |
Table Type: | ACTIVITY |
Column Detail - SI_DOCUMENT_TRANSACTION_LOG
Column Name | Type | Null? | Definition |
---|---|---|---|
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. |
DOCUMENT_IDENT | VARCHAR(200) | Y | The alpha-numeric identifier of the document the transaction processed. |
DOCUMENT_TRANSACTION_IDENT | VARCHAR(40) | N | The alpha-numeric unique identifier for the document transaction. |
ENCNTR_ID | DOUBLE | N | Unique identifier of the Encounter the document transaction is for. This column will only be populated if the document transaction corresponds to an encounter. |
ERROR_NAME | VARCHAR(15) | Y | Mnemonic describing the most specific classification of the error available. Will be NULL if no error occurred. |
ERROR_TEXT | VARCHAR(500) | Y | Free text describing the error(s) encountered during the processing of the document transaction. Will be NULL if no error occurred. |
ESO_TRIGGER_ID | DOUBLE | N | Unique identifier to the CQM_FSIESO_TR_1 table. This field will only be populated if the document transaction corresponds to an External Systems Outbound transaction with a row on the CQM_FSIESO_TR_1 table. |
OEN_QUEUE_ID | DOUBLE | N | Unique identifier to the CQM_OENINTERFACE_QUE table. This field will only be populated if the document transaction corresponds to an Open Engine transaction with a row on the CQM_OENINTERFACE_QUE table. |
PERSON_ID | DOUBLE | N | Unique identifier of the person the document transaction is for. |
SI_DOCUMENT_INFO_ID | DOUBLE | N | Unique identifier to the SI_DOCUMENT_INFO table. This field will only be populated if the document transaction corresponds to a row on the SI_DOCUMENT_INFO table. |
SI_DOCUMENT_TRANSACTION_LOG_ID | DOUBLE | N | Primary Key to the DOCUMENT_TRANSACTION_LOG table. |
STATUS_CD | DOUBLE | N | Code describing the overall status of the document transaction. |
TRANSACTION_DT_TM | DATETIME | N | The date and time the document transaction was processed at. |
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 - SI_DOCUMENT_TRANSACTION_LOG
Child Column in SI_DOCUMENT_TRANSACTION_LOG(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ESO_TRIGGER_ID | CQM_FSIESO_TR_1 | TRIGGER_ID |
OEN_QUEUE_ID | CQM_OENINTERFACE_QUE | QUEUE_ID | |
ENCNTR_ID | ENCOUNTER | ENCNTR_ID | |
PERSON_ID | PERSON | PERSON_ID | |
SI_DOCUMENT_INFO_ID | SI_DOCUMENT_INFO | SI_DOCUMENT_INFO_ID |
SI_ENTITY_PROFILE_R
Column Section | Top of Page |
Table-level Detail
Description: | SI Entiry Profile Relation |
Definition: | This table contains relations between entities and V3 profiles. |
Table Type: | REFERENCE |
Column Detail - SI_ENTITY_PROFILE_R
Column Name | Type | Null? | Definition |
---|---|---|---|
PARENT_ENTITY_ID | DOUBLE | N | The identifier associated with the entity, e.g. organization_id. |
PARENT_ENTITY_NAME | VARCHAR(32) | N | The type of entity identified by entity_id, e.g. ORGANIZATION. |
PROFILE_EXTENSION | VARCHAR(50) | Y | The extension attribute of the profile Id |
PROFILE_ROOT | VARCHAR(250) | Y | The root attribute of the profile Id |
PROFILE_SEQ | DOUBLE | Y | Used to define the ordering of related profiles |
SI_ENTITY_PROFILE_R_ID | DOUBLE | N | Unique ID associated with the row. Primary key. |
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. |
SI_ENTITY_UUID
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | System Integration Entity Universally Unique Identifier |
Definition: | Stores related UUID as they relate to different entities in the system, like Allergies, Problems, and other related items. |
Table Type: | ACTIVITY |
Column Detail - SI_ENTITY_UUID
Column Name | Type | Null? | Definition |
---|---|---|---|
ENTITY_UUID | VARCHAR(100) | N | Universally unique identifier for a given entity across all client domains. |
PARENT_ENTITY_ID | DOUBLE | N | The Primary Identifier of the Entity. |
PARENT_ENTITY_NAME | VARCHAR(30) | N | The Name of the Entity ( PROBLEM, ALLERGY, ORDER, DIAGNOSIS, PROCEDURE and others... ) |
PERSON_ID | DOUBLE | N | The person related to the given entity |
SI_ENTITY_UUID_ID | DOUBLE | N | PRIMARY KEY |
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 - SI_ENTITY_UUID
Child Column in SI_ENTITY_UUID(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PERSON_ID | PERSON | PERSON_ID |
SI_EXTERNAL_SERVICE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | SI External Service |
Definition: | Table containing defined external services |
Table Type: | REFERENCE |
Column Detail - SI_EXTERNAL_SERVICE
Column Name | Type | Null? | Definition |
---|---|---|---|
AUTHORIZATION_TYPE_CD | DOUBLE | N | Defines the type of authorization this service uses. |
CERTIFICATE_TXT | VARCHAR(255) | Y | The certificate text or password used to sign in the user provided in the username column. |
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. |
EXTERNAL_SERVICE_TYPE_CD | DOUBLE | N | The type of service utilized for this system. |
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. |
SERVICE_NAME | VARCHAR(255) | N | Name of the service defiend by the row. Should be unique within a given external service type. |
SERVICE_URI | VARCHAR(512) | Y | The Universal Service Identifier where the service is located |
SI_EXTERNAL_SERVICE_ID | DOUBLE | N | Unique generated number - identifies a single row in the table |
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. |
USERNAME_TXT | VARCHAR(100) | Y | The user name to use for authorizating with the service if the service uses a username and password authorization model |
Relationship Detail - SI_EXTERNAL_SERVICE
Child Column in SI_EXTERNAL_SERVICE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID |
Parent Column in SI_EXTERNAL_SERVICE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SI_EXTERNAL_SERVICE_ID | SI_EXTERNAL_SERVICE_VOCAB | SI_EXTERNAL_SERVICE_ID |
SI_SERVICE_RELTN | SI_EXTERNAL_SERVICE_ID |
SI_EXTERNAL_SERVICE_VOCAB
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | SI External Service Vocabulary |
Definition: | Contains the vocabularies supported by an external service, grouped by a content category (clinical concept). |
Table Type: | REFERENCE |
Column Detail - SI_EXTERNAL_SERVICE_VOCAB
Column Name | Type | Null? | Definition |
---|---|---|---|
CONTENT_CATEGORY_CD | DOUBLE | N | The content category (clinical concept) that the associated vocabulary should be used for |
SI_EXTERNAL_SERVICE_ID | DOUBLE | N | Number that uniquely identifies a single row on the SI_EXTERNAL_SERVICE table. |
SI_EXTERNAL_SERVICE_VOCAB_ID | DOUBLE | N | Unique generated number that identifies a single row in the table. |
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. |
VOCABULARY_CD | DOUBLE | N | One of the vocabularies that the service understands for the associated content category (clinical concept). |
Relationship Detail - SI_EXTERNAL_SERVICE_VOCAB
Child Column in SI_EXTERNAL_SERVICE_VOCAB(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SI_EXTERNAL_SERVICE_ID | SI_EXTERNAL_SERVICE | SI_EXTERNAL_SERVICE_ID |