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 |