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 |