Table Detail Report

RXS_LOC_SR_EVENT_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: RxStation Location Service Resource Event Relation
Definition: Stores information of a service resource serving a location for a given outbound event.
Table Type: REFERENCE





Column Detail - RXS_LOC_SR_EVENT_RELTN


Column Name Type Null? Definition
LOCATION_CD DOUBLE N The location being served by this service resource.
OUTBOUND_EVENT_TYPE_CD DOUBLE N The outbound event type that this service resource and location are related to.
RXS_LOC_SR_EVENT_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the RXS_LOC_SR_EVENT_RELTN table.
SEND_OUTBOUND_IND DOUBLE N Identifies if an outbound event defined for a location can be sent to a service resource.
SERVICE_RESOURCE_CD DOUBLE N The service resource that serves this location for this outbound event type.
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 - RXS_LOC_SR_EVENT_RELTN


Child Column in RXS_LOC_SR_EVENT_RELTN(FK) Parent Table Name Parent Column Name
Parents: LOCATION_CD LOCATION LOCATION_CD
SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD


RXS_MED_REQUEST



Column Section Relationship Section Top of Page


Table-level Detail

Description: RxStation Medication Request
Definition: Stores missing ordered medications (e.g. not stocked, out of stock, low in quantity, etc.) that are requested from a fill location (e.g. pharmacy)
Table Type: ACTIVITY





Column Detail - RXS_MED_REQUEST


Column Name Type Null? Definition
CREATE_DT_TM DATETIME N The time the medication was requested.
ORDER_ID DOUBLE N The order which requested the medication
PARENT_ENTITY_ID DOUBLE N Identifies the alert that was created for the medication request.
PARENT_ENTITY_NAME VARCHAR(32) N Identifies if the alert that was created for the medication request was from RXS_ALERT or RXS_FOREIGN_DEVICE_ALERT.
PRIORITY_CD DOUBLE N The priority of the med request
REASON_CD DOUBLE N Describes why the med request was initiated.
REASON_LONG_TEXT_ID DOUBLE N Refers to an entry in long_text table which can additionally be provided by the user when a medication is requested. Can be 0.0, if user does not provide additional free text reason.
REQUEST_PRSNL_ID DOUBLE N The personnel who requested the medication.
RXS_MED_REQUEST_ID DOUBLE N Unique, generated number that identifies a single row on the RXS_MED_REQUEST table.
RX_ACTION_CD DOUBLE N Code to represent how the pharmacist acted on a med request (accept/decline/mark as duplicate)
RX_ACTION_DT_TM DATETIME Y Date and time when a pharmacist acted on a med request (accept/decline)
RX_ACTION_PRSNL_ID DOUBLE N Personnel ID of the user who acted on a med request (accept/decline).
RX_ACTION_TZ DOUBLE Y Time zone for the pharmacist acting on a med request (accept/decline)
RX_REASON_CD DOUBLE N Codified reason selected by the pharmacist after acting on a med request (accepting/declining)
RX_REASON_LONG_TEXT_ID DOUBLE N Free-text comment entered by the pharmacist after acting on a med request (accepting/declining)
RX_STATUS_CD DOUBLE N Code for the status the med request is in.
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 - RXS_MED_REQUEST


Child Column in RXS_MED_REQUEST(FK) Parent Table Name Parent Column Name
Parents: REASON_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
RX_REASON_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
ORDER_ID ORDERS ORDER_ID
REQUEST_PRSNL_ID PRSNL PERSON_ID
RX_ACTION_PRSNL_ID PRSNL PERSON_ID


RXS_ORDER_TASK_QUEUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: RxStation Order Task Queue
Definition: Temporarily stores remotely queued order tasks of a patient to be dispensed later from an RxStation
Table Type: ACTIVITY





Column Detail - RXS_ORDER_TASK_QUEUE


Column Name Type Null? Definition
ASSIGNED_PRSNL_ID DOUBLE N Identifier that refers to the person whom the order is assigned to
BEGIN_EFFECTIVE_DT_TM DATETIME N The date that the row becomes or became effective.
ENCNTR_ID DOUBLE N The encounter for the order.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
ORDER_ID DOUBLE N Identifier that refers to the queued order
PERSON_ID DOUBLE N Identifier that refers to the patient whom the order is queued for
RXS_ORDER_TASK_QUEUE_ID DOUBLE N Unique generated number that identifies a single row on the rxs_order_task_queue table.
STATE_CD DOUBLE N Current state of the queued order task.
STATE_DT_TM DATETIME N Date when the state of the queued order task was changed.
TASK_ID DOUBLE N Identifier that refers to the queued order task
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 - RXS_ORDER_TASK_QUEUE


Child Column in RXS_ORDER_TASK_QUEUE(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
ORDER_ID ORDERS ORDER_ID
PERSON_ID PERSON PERSON_ID
ASSIGNED_PRSNL_ID PRSNL PERSON_ID
TASK_ID TASK_ACTIVITY TASK_ID


RXS_PHA_REPORT_FILTER_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: RxStation Pharmacy Report Filter History
Definition: History of filters used while executing a reports
Table Type: ACTIVITY





Column Detail - RXS_PHA_REPORT_FILTER_HIST


Column Name Type Null? Definition
FILTER_VALUE VARCHAR(100) N Actual value set for the filter
PARENT_ENTITY_ID DOUBLE Y identifier for the filter in the report like item_id, code_value,person_id, personnel id, work-list id etc.
PARENT_ENTITY_NAME VARCHAR(32) Y Table name that the value in column parent_entity_id originates.
PHA_BATCH_REPORT_ACT_ID DOUBLE N The report run activity identifier this filter is associated with.
REPORT_FILTER_CD DOUBLE N The type of report filter.
RXS_PHA_REPORT_FILTER_HIST_ID DOUBLE N Unique, generated number that identifies a single row on the RXS_PHA_REPORT_FILTER_HIST table.
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 - RXS_PHA_REPORT_FILTER_HIST


Child Column in RXS_PHA_REPORT_FILTER_HIST(FK) Parent Table Name Parent Column Name
Parents: PHA_BATCH_REPORT_ACT_ID PHA_BATCH_REPORT_ACT PHA_BATCH_REPORT_ACT_ID


RXS_RECEIVING_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: RxStation Receiving Detail
Definition: Stores details captured by the user during the Controlled Substance Vault (CSV) Receiving workflow.
Table Type: ACTIVITY





Column Detail - RXS_RECEIVING_DETAIL


Column Name Type Null? Definition
CSOS_IDENT VARCHAR(255) Y CSOS Identifier
DEA_CS_FORM_222_IDENT VARCHAR(255) N The identifier for the control substance received.
INVOICE_NBR_TXT VARCHAR(255) N Textual representation of the invoice number for the drug being received.
MISC_IDENT_TXT VARCHAR(255) Y Allows non-defined identifiers to be added.
PO_NBR_TXT VARCHAR(255) N Textual representation of the purchase order number for the drug being received.
RXS_RECEIVING_DETAIL_ID DOUBLE N Unique, generated number that identifies a single row on the RXS_RECEIVING_DETAIL 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.
VENDOR_NAME_TXT VARCHAR(255) Y A short description of the vendor name.



Relationship Detail - RXS_RECEIVING_DETAIL




Parent Column in RXS_RECEIVING_DETAIL (PK) Child Table Name Child Column Name
Children: RXS_RECEIVING_DETAIL_ID RXS_LOCATION_TASK RXS_RECEIVING_DETAIL_ID