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