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 |