Table Detail Report

CHART_REQUEST_ARCHIVE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Chart Request Archive
Definition: The chart request archive table is used to store the LONG BLOB IDs referenced to the LONG_BLOB table that contain the XML representation of the archived charts.
Table Type: ACTIVITY





Column Detail - CHART_REQUEST_ARCHIVE


Column Name Type Null? Definition
ARCHIVE_CHART_NBR DOUBLE Y The total number of charts archived for all XML files stored in the zip file
ARCHIVE_DT_TM DATETIME Y The date and time of the last archive
CHART_REQUEST_ARCHIVE_ID DOUBLE N The primary Key for rows in this table
LONG_BLOB_ID DOUBLE N The ID of the Long Blob that contains the zip file of the archived charts
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 - CHART_REQUEST_ARCHIVE


Child Column in CHART_REQUEST_ARCHIVE(FK) Parent Table Name Parent Column Name
Parents: LONG_BLOB_ID LONG_BLOB LONG_BLOB_ID


CHART_REQUEST_AUDIT



Column Section Top of Page


Table-level Detail

Description: This is an audit table for MRP requests.
Definition: chart_request_audit
Table Type: ACTIVITY





Column Detail - CHART_REQUEST_AUDIT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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 Y 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.
CHART_REQUEST_ID DOUBLE N Primary key to the chart_request table
COMMENTS VARCHAR(255) Y It stores the comments entered through MRP.dll.
DEST_PE_ID DOUBLE N Id of the dest. Can be "PERSON", "ORGANIZATION", "FREETEXT", or "LOCATION".
DEST_PE_NAME VARCHAR(32) Y Parent entity name of the dest_pe_id. Can be "PERSON", "ORGANIZATION", "FREETEXT", or "LOCATION".
DEST_TXT VARCHAR(32) Y The free text for destination. If dest_pe_name is "FREETEXT", the field will be populated.
INPUT_DEVICE VARCHAR(16) Y The IP address for input device.
PATCONOBT_IND DOUBLE Y Patient consent obtained Indicator
REASON_CD DOUBLE N code value for reason
REQUESTOR_PE_ID DOUBLE N Id of the requestor. Can be "PERSON", "ORGANIZATION", "FREETEXT", or "LOCATION".
REQUESTOR_PE_NAME VARCHAR(32) Y Parent entity name of the requestor_pe_id. Can be "PERSON", "ORGANIZATION", "FREETEXT", or "LOCATION".
REQUESTOR_TXT VARCHAR(32) Y free text for requestor. If requestor_pe_name is "FREETEXT", the field will be populated.
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.


CHART_REQUEST_ENCNTR



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contains a set of encounters for a cross-encounter chart request.
Definition: chart_request_encntr
Table Type: ACTIVITY





Column Detail - CHART_REQUEST_ENCNTR


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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 Y 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.
CHART_REQUEST_ENCNTR_ID DOUBLE N primary key for the table
CHART_REQUEST_ID DOUBLE N Primary key to the chart_request table
CR_ENCNTR_SEQ DOUBLE N sequence of encounters
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
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 - CHART_REQUEST_ENCNTR


Child Column in CHART_REQUEST_ENCNTR(FK) Parent Table Name Parent Column Name
Parents: CHART_REQUEST_ID CHART_REQUEST CHART_REQUEST_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID


CHART_REQUEST_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contains a sub set of event_ids for a given chart_request
Definition: chart_request_events
Table Type: ACTIVITY





Column Detail - CHART_REQUEST_EVENT


Column Name Type Null? Definition
CHART_REQUEST_ID DOUBLE N Primary key to the chart_request table
CR_EVENT_ID DOUBLE N Primary Key for the table
CR_EVENT_SEQ DOUBLE Y sequence of the event_id
EVENT_ID DOUBLE N Unique identifier for an event. Uniquely identifies a logical clinical event row. There may be more than one row with the same event_id, but only one of those rows will be current as indicated by the valid_until_dt_tm field.
RESULT_STATUS_CD DOUBLE N result status
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 - CHART_REQUEST_EVENT


Child Column in CHART_REQUEST_EVENT(FK) Parent Table Name Parent Column Name
Parents: CHART_REQUEST_ID CHART_REQUEST CHART_REQUEST_ID


CHART_REQUEST_ORDER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Chart Request Order
Definition: Contains a set of encounters for an order-level chart request
Table Type: ACTIVITY





Column Detail - CHART_REQUEST_ORDER


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.
CHART_REQUEST_ID DOUBLE N Primary key value from the chart_request table
CHART_REQUEST_ORDER_ID DOUBLE N Primary key for this table.
ORDER_ID DOUBLE N This is the value of the unique primary identifier of the orders 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 - CHART_REQUEST_ORDER


Child Column in CHART_REQUEST_ORDER(FK) Parent Table Name Parent Column Name
Parents: CHART_REQUEST_ID CHART_REQUEST CHART_REQUEST_ID
ORDER_ID ORDERS ORDER_ID