Table Detail Report

SI_ERROR_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: System Integration Error Relation
Definition: Interfaces are sending out multiple error responses form a single request. This table breaks out the errors into individual errors.
Table Type: ACTIVITY





Column Detail - SI_ERROR_RELTN


Column Name Type Null? Definition
ERROR_CODE VARCHAR(50) N Textual representation of the error returned.
ERROR_LONG_TEXT_ID DOUBLE N If the error is longer than 255 characters in length the totality of the error is stored on the Long Text table and the ID is placed here.
ERROR_TEXT VARCHAR(255) Y The first 255 characters of the error text that was returned.
INTERNAL_MESSAGE_IDENT VARCHAR(60) N ** OBSOLETE - This field is no longer used - replaced by additon of new column SI_MESSAGE_LOG_ID
MESSAGE_SEQUENCE DOUBLE N ** OBSOLETE - This field is no longer used - replaced by additon of new column SI_MESSAGE_LOG_ID
PARENT_ENTITY_ID DOUBLE N The parent ID of this record. This refers to the primary identifier from the parent record.
PARENT_ENTITY_NAME VARCHAR(32) N The parent of this record. This refers to the table that holds the parent record.
SI_ERROR_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the SI_ERROR_RELTN table.
SI_MESSAGE_LOG_ID DOUBLE N Related record on the SI_Message_Log table that generated the error.
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_ERROR_RELTN


Child Column in SI_ERROR_RELTN(FK) Parent Table Name Parent Column Name
Parents: ERROR_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
SI_MESSAGE_LOG_ID SI_MESSAGE_LOG SI_MESSAGE_LOG_ID


SI_ERX_DIGITAL_SIG_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: SI ePrescribe Digital Signature Log
Definition: Log of information around the digital signature of ePrescribed Controlled Substance messages
Table Type: ACTIVITY





Column Detail - SI_ERX_DIGITAL_SIG_LOG


Column Name Type Null? Definition
DEA_NUMBER VARCHAR(35) Y The DEA Number of the prescriber.
DIGITAL_SIGNATURE LONGBLOB Y The digital signature in binary form.
DRUG_DESCRIPTION VARCHAR(225) Y The description of the order's drug.
DRUG_DIRECTIONS VARCHAR(1000) Y The order's SIG instructions.
DRUG_EFFECTIVE_DATE_TEXT VARCHAR(25) Y The earliest fill date of the order's drug.
DRUG_QUANTITY VARCHAR(10) Y The quantity of the order's drug.
DRUG_WRITTEN_DATE_TEXT VARCHAR(25) Y The date the prescription for the drug was written.
ENCNTR_ID DOUBLE N The encounter ID for the prescription order.
MESSAGE_IDENT VARCHAR(30) N The message id for the prescription message.
MESSAGE_TYPE VARCHAR(15) N The message type that was digitally signed
NOTE VARCHAR(225) Y The note to/from the pharmacy pertaining to this prescription.
ORDER_ID DOUBLE N The order_id for the prescription order.
PAT_ADDR_CITY VARCHAR(100) Y The text name of the city associated with the patient's address.
PAT_ADDR_LINE_1 VARCHAR(100) Y The first line of the patient's address.
PAT_ADDR_LINE_2 VARCHAR(100) Y The second line of the patient's address.
PAT_ADDR_STATE VARCHAR(100) Y The text name of the state associated with the patient's address.
PAT_ADDR_ZIPCODE VARCHAR(25) Y The postal code associated with the patient's address.
PAT_BIRTH_DATE_TEXT VARCHAR(25) Y The text representation of the patient's date of birth in the form - YYYY-MM-DD
PAT_NAME_FIRST VARCHAR(200) Y The first name of the patient.
PAT_NAME_LAST VARCHAR(200) Y The last name of the patient.
PERSON_ID DOUBLE N The person_id of the prescribed to person.
PRESC_ADDR_CITY VARCHAR(100) Y The text name of the city associated with the prescriber's address.
PRESC_ADDR_LINE_1 VARCHAR(100) Y The first line of the prescriber's address.
PRESC_ADDR_LINE_2 VARCHAR(100) Y The second line of the prescriber's address
PRESC_ADDR_STATE VARCHAR(100) Y The text name of the state associated with the prescriber's address.
PRESC_ADDR_ZIPCODE VARCHAR(25) Y The postal code associated with the prescriber's address.
PRESC_NAME_FIRST VARCHAR(200) Y The first name of the prescriber.
PRESC_NAME_LAST VARCHAR(200) Y The last name of the prescriber.
PRSNL_ID DOUBLE N The ID of the personnel prescribing the medication.
REFILL_NBR_TXT VARCHAR(10) Y The number of refills
REFILL_QUALIFIER VARCHAR(5) Y The qualifier associated to the refills
SIGNED_FIELDS VARCHAR(2000) N The concatenated string comprised of the various fields that were signed.
SIGN_DT_TM DATETIME N The date and time that the digital signature was produced.
SI_ERX_DIGITAL_SIG_LOG_ID DOUBLE N Unique generated numbekr that identifies a single row on 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.



Relationship Detail - SI_ERX_DIGITAL_SIG_LOG


Child Column in SI_ERX_DIGITAL_SIG_LOG(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
ORDER_ID ORDERS ORDER_ID
PERSON_ID PERSON PERSON_ID
PRSNL_ID PRSNL PERSON_ID


SI_ESI_ALIAS_TRANS_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: System Integration ESI Alias Trans History
Definition: This table stores historical information for the ESI_Alias_Trans table.
Table Type: REFERENCE





Column Detail - SI_ESI_ALIAS_TRANS_HIST


Column Name Type Null? Definition
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.
ALIAS_ENSURE_PARMS_FLAG DOUBLE N Copy of the Alias_Ensure_Parms_Flag field from the esi_alias_trans table.
ALIAS_ENTITY_ALIAS_TYPE_CD DOUBLE N Copy of the Alias_Entity_Alias_Type_Cd field from the esi_alias_trans table. Code can flex - depends on alias entity name.
ALIAS_ENTITY_NAME VARCHAR(32) Y Copy of the Alias_Entity_Name field from the esi_alias_trans table.
ALIAS_FILTER_CD DOUBLE N Copy of the Alias_Filter_Cd field from the esi_alias_trans table.
ALIAS_POOL_CD DOUBLE N Copy of the Alias_Pool_Cd field from the esi_alias_trans table.
ASSIGN_AUTHORITY_SYS_CD DOUBLE N Copy of the Assign_Authority_Sys_Cd field from the esi_alias_trans table.
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.
ELIGIBLE_FOR_QUERY_IND DOUBLE N Indicates that this alias is eligible to be sent out for MPI queries.
ESI_ALIAS_FIELD_CD DOUBLE N Copy of the Esi_Alias_Field_Cd field from the esi_alias_trans table.
ESI_ALIAS_TRANS_ID DOUBLE N Copy of the Esi_Alias_Trans_ID field from the esi_alias_trans table.
ESI_ALIAS_TYPE VARCHAR(50) Y Copy of the Esi_Alias_Type field from the esi_alias_trans table.
ESI_ASSIGN_AUTH VARCHAR(50) Y Copy of the Esi_Assign_Auth field from the esi_alias_trans table.
ESI_ASSIGN_FAC VARCHAR(50) Y Copy of the Esi_Assign_Fac field from the esi_alias_trans table.
ESI_SOURCE VARCHAR(50) N Copy of the ESI_Source field from the esi_alias_trans table.
MODIFY_PRSNL_ID DOUBLE N Prsnl ID of the user who made new modification on the Contributor_System table
ORG_PRSNL_ID DOUBLE N Prsnl ID of the user who made original modification on the Contributor_System table
PERSON_PROC_OPT_CD DOUBLE N Options for processing person information via ESI.
PRSNL_FT_STRING VARCHAR(50) Y Copy of the Prsnl_ft_string field from the esi_alias_trans table.
PRSNL_PROC_OPT_CD DOUBLE N Copy of the Prsnl_proc_opt_cd field from the esi_alias_trans table.
REC_BEG_EFF_DT_TM DATETIME Y Copy of the Beg_Eff_Dt_TM field from the esi_alias_trans table.
SI_ESI_ALIAS_TRANS_HIST_ID DOUBLE N SI_ESI_Alias_Trans_Hist_id Primary ID
SKIP_STRING VARCHAR(100) Y Copy of the Skip_String field from the esi_alias_trans table.
TRUNC_SIZE DOUBLE Y Copy of the Trunc_Size field from the esi_alias_trans 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.



Relationship Detail - SI_ESI_ALIAS_TRANS_HIST


Child Column in SI_ESI_ALIAS_TRANS_HIST(FK) Parent Table Name Parent Column Name
Parents: MODIFY_PRSNL_ID PRSNL PERSON_ID
ORG_PRSNL_ID PRSNL PERSON_ID


SI_ESI_ENSURE_PARMS_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: System Integration ESI Ensure Parms History
Definition: This table stores historical information for the ESI_Ensure_Parms table
Table Type: REFERENCE





Column Detail - SI_ESI_ENSURE_PARMS_HIST


Column Name Type Null? Definition
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.
ALLERGY_SEGMENT_ENS_TYPE_CD DOUBLE N Copy of the Allergy_segment_ens_type_cd field from the esi_ensure_parms table
CODING_SEGMENT_ENS_TYPE_CD DOUBLE N Copy of the Coding_Segment_Ens_Type_Cd field from the esi_ensure_parms table.
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.
ENCNTR_ALIAS_ENSURE_TYPE_CD DOUBLE N Copy of the Encntr_alias_ensure_type_cd field from the esi_ensure_parms table.
ENCNTR_ENSURE_TYPE_CD DOUBLE N Copy of the Encntr_ensure_type_cd field from the esi_ensure_parms table.
ESI_ENSURE_PARMS_ID DOUBLE N Copy of the Esi_ensure_parms_id field from the esi_ensure_parms table.
ESI_TASK_CD DOUBLE N Copy of the Esi_task_cd field from the esi_ensure_parms table.
EVENT_ENSURE_TYPE_CD DOUBLE N Copy of the Event_ensure_type_cd field from the esi_ensure_parms table.
MODIFY_PRSNL_ID DOUBLE N Prsnl ID of the user who made new modification on the esi_ensure_parms table
NK1_SEGMENT_ENS_TYPE_CD DOUBLE N This ENSURE option provides the ability to override the normal ensure configuration for authenticated persons. For a given transaction, with the Person or Encounter Ensure set to add or update, the processing of authenticated persons do not update the person data in the database. With this option set, if there is an authenticated match found, then the authenticated person will be ensured from the NK1 segment information. The only valid values are UPDATE and 0.
ORDER_ENSURE_TYPE_CD DOUBLE N Copy of the Order_ensure_type_cd field from the esi_ensure_parms table.
ORIG_PRSNL_ID DOUBLE N Prsnl ID of the user who made original modification on the esi_ensure_parms table
PERSON_ALIAS_ENSURE_TYPE_CD DOUBLE N Copy of the Person_alias_ensure_type_cd field from the esi_ensure_parms table.
PERSON_ENSURE_TYPE_CD DOUBLE N Copy of the Person_ensure_type_cd field from the esi_ensure_parms table.
PROBLEM_SEGMENT_ENS_TYPE_CD DOUBLE N Copy of the Problem_segment_ens_type_cd field from the esi_ensure_parms table
REC_BEG_EFF_DT_TM DATETIME Y Copy of the Rec_Beg_Eff_Dt_TM field from the esi_ensure_parms table.
SI_ESI_ENSURE_PARMS_HIST_ID DOUBLE N Primary KeyColumn
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 - SI_ESI_ENSURE_PARMS_HIST


Child Column in SI_ESI_ENSURE_PARMS_HIST(FK) Parent Table Name Parent Column Name
Parents: MODIFY_PRSNL_ID PRSNL PERSON_ID
ORIG_PRSNL_ID PRSNL PERSON_ID


SI_EXT_REGISTRY_RESPONSE



Column Section Relationship Section Top of Page


Table-level Detail

Description: System Integration External Registry Response
Definition: This table stores a response received from a external registry, needed for future processing
Table Type: ACTIVITY





Column Detail - SI_EXT_REGISTRY_RESPONSE


Column Name Type Null? Definition
CONSOLIDATION_STATUS_CD DOUBLE N CODE SET:4002659 Status of the document in terms of the relationship with the database. Values include New, Reviewed, or Imported
CONTENT_TYPE VARCHAR(32) Y The content type of the document as it is stored in CAMM
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.
IMPORTED_DT_TM DATETIME Y The date and time the consolidated data from the response was imported into a patient's chart.
MEDIA_OBJECT_IDENTIFIER VARCHAR(64) N Identifier of the response message object if stored in the multimedia storage.
MEDIA_OBJECT_VERSION_NBR DOUBLE N The version of the identified response message object in the multimedia storage.
MIME_TYPE VARCHAR(100) Y The MIME type of the response message.
PERSON_ID DOUBLE N The person related to the queried registry response.
RESPONSE_DT_TM DATETIME N The date and time when the row was added, correlating to the actual response date and time.
SI_EXT_REGISTRY_RESPONSE_ID DOUBLE N PRIMARY KEY
SI_XDOC_QUERY_PERSON_RELTN_ID DOUBLE N SEQUENCE NAME:SI_DOCUMENT_SEQ Foreign key to query relationship to track which query was responsible for this registry response.
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_EXT_REGISTRY_RESPONSE


Child Column in SI_EXT_REGISTRY_RESPONSE(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID
SI_XDOC_QUERY_PERSON_RELTN_ID SI_XDOC_QUERY_PERSON_RELTN SI_XDOC_QUERY_PERSON_RELTN_ID