Table Detail Report
RXS_ALERT_LOC_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | RxStation Alert Location Relation |
Definition: | Captures the service locations tied to an alert. |
Table Type: | ACTIVITY |
Column Detail - RXS_ALERT_LOC_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
RXS_ALERT_ID | DOUBLE | N | The alert associated to this service location. |
RXS_ALERT_LOC_RELTN_ID | DOUBLE | N | Unique, generated number that identifies a single row on the RXS_ALERT_LOC_RELTN table. |
SVC_LOC_CD | DOUBLE | N | The service location (Nurse Unit, Ambulatory, Pharmacy, Surgery, etc.) for which the medication is requested. |
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_ALERT_LOC_RELTN
Child Column in RXS_ALERT_LOC_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SVC_LOC_CD | LOCATION | LOCATION_CD |
RXS_ALERT_ID | RXS_ALERT | RXS_ALERT_ID |
RXS_EXTENDED_COUNT_PROP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | RxStation Extended Count Property |
Definition: | Contains additional information on when a count should be performed for a given location/item. |
Table Type: | REFERENCE |
Column Detail - RXS_EXTENDED_COUNT_PROP
Column Name | Type | Null? | Definition |
---|---|---|---|
COUNTBACK_FLAG | DOUBLE | N | Flag used to determine if this item/location requires a physical count once the icurrent quantity level reached dynamic count level. |
COUNT_CONTROL_NBR | DOUBLE | N | A number indicating how often or when to start counting. |
COUNT_RULE_CD | DOUBLE | N | The count rule that is defined for this location/item. |
ITEM_ID | DOUBLE | N | The item this count relates to. |
LOCATION_CD | DOUBLE | N | The location this count relates to. |
RXS_EXTENDED_COUNT_PROP_ID | DOUBLE | N | Unique, generated number that identifies a single row on the RXS_EXTENDED_COUNT_PROP 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_EXTENDED_COUNT_PROP
Child Column in RXS_EXTENDED_COUNT_PROP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ITEM_ID | ITEM_DEFINITION | ITEM_ID |
LOCATION_CD | LOCATION | LOCATION_CD |
RXS_FOREIGN_DEVICE_ALERT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | RxStation Foreign Device Alert |
Definition: | The purpose of this table is to house alerts generated by foreign systems e.g. CF Pyxis to achieve interoperability. |
Table Type: | ACTIVITY |
Column Detail - RXS_FOREIGN_DEVICE_ALERT
Column Name | Type | Null? | Definition |
---|---|---|---|
ALERT_UNIT | VARCHAR(255) | N | This is an optional field that provides the type of units appropriate for the ALERT_VALUE. |
ALERT_VALUE | VARCHAR(1000) | N | This is an optional field that provides a value associated with the alert. |
CREATE_PRSNL_ID | DOUBLE | N | This item contains the identifier of the personnel associated with the alert . |
CREATE_PRSNL_NAME | VARCHAR(255) | N | This field contains the name of the personnel associated with the alert . |
DEVICE_DRAWER_NAME | VARCHAR(255) | N | The name of a drawer in a device. |
DEVICE_LOCATOR_NAME | VARCHAR(255) | N | This field contains the exact location on the device that is associated with the alert. |
DEVICE_LOC_CD | DOUBLE | N | This field contains the location code of the device location that caused the alert. |
DEVICE_NAME | VARCHAR(255) | N | This field contains the name of the foreign device that originated the alert. |
DEVICE_SUB_DRAWER_NAME | VARCHAR(255) | N | Name of a sub drawer in a device. |
ENS_MESSAGE_DT_TM | DATETIME | N | This field contains the timestamp associated with the ENS message. |
ENS_MESSAGE_IDENT | VARCHAR(255) | N | This field contains the unique message ID from the ENS toolkit. |
FACILITY_CD | DOUBLE | N | The field contains the code value of the facility. |
FACILITY_NAME | VARCHAR(255) | N | This field provides the name of the facility that originated the alert. |
FOREIGN_ITEM_IDENTIFIER | VARCHAR(255) | N | Identifier sent by a foreign device through HL7 message. |
INV_ITEM_ID | DOUBLE | N | This field provides an identification number for the item associated with the alert. |
INV_ITEM_NAME | VARCHAR(255) | N | This field contains the name of the item associated with the alert per INV_ITEM _ID. |
MSG_BODY_LONG_TEXT_ID | DOUBLE | N | Reference to LONG_TEXT table. Contains the original message sent with the alert as received from the foreign system. |
NURSE_UNIT_CD | DOUBLE | N | This fields contains the nurse unit location code of the patient. |
NURSE_UNIT_NAME | VARCHAR(255) | N | The name of the nursing unit associated with the alert. |
PATIENT_ID | DOUBLE | N | This is the patient's primary identification number. This field is optional depending on the type of alert. |
PATIENT_NAME_FORMATTED | VARCHAR(255) | N | The formatted name of the patient associated to this alert. It is a combination of the patient's first name, middle initial, and last name. |
REFERENCE_RANGE_TXT | VARCHAR(255) | N | This field provides what is considered a normal range of values for the alert. It is an optional field based on the type of alert (TYPE_CD). |
RXS_FOREIGN_DEVICE_ALERT_ID | DOUBLE | N | Unique generated number that identifies a single row on the RXS_FOREIGN_DEVICE_ALERT table. |
STATE_CD | DOUBLE | N | This field indicates the status for the alert. |
STATE_DT_TM | DATETIME | N | The date/time of the last state change. |
SVRTY_CD | DOUBLE | N | Indicates the severity of this alert. |
TRANSACTION_DT_TM | DATETIME | N | This field is a timestamp for the transaction that created the alert on the foreign device. |
TRANSACTION_IDENT | VARCHAR(255) | N | The transaction ID is the foreign system's identifier assigned to the transaction that generated the alert. It is required. |
TYPE_CD | DOUBLE | N | This field indicates the type of the alert. |
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_FOREIGN_DEVICE_ALERT
Child Column in RXS_FOREIGN_DEVICE_ALERT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | INV_ITEM_ID | ITEM_DEFINITION | ITEM_ID |
DEVICE_LOC_CD | LOCATION | LOCATION_CD | |
FACILITY_CD | LOCATION | LOCATION_CD | |
NURSE_UNIT_CD | LOCATION | LOCATION_CD | |
MSG_BODY_LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID | |
PATIENT_ID | PERSON | PERSON_ID | |
CREATE_PRSNL_ID | PRSNL | PERSON_ID |
Parent Column in RXS_FOREIGN_DEVICE_ALERT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | RXS_FOREIGN_DEVICE_ALERT_ID | RXS_ALERT_AUDIT_HX | RXS_FOREIGN_DEVICE_ALERT_ID |
RXS_GROUP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | RxStation Group |
Definition: | Contains items on an order set. For example: all the medications that are bee sting medicines. |
Table Type: | REFERENCE |
Column Detail - RXS_GROUP
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. |
CREATE_DT_TM | DATETIME | Y | The date and time the group was created |
CREATE_PRSNL_ID | DOUBLE | N | The personnel ID of the person who created the group. |
GROUP_DESCRIPTION | VARCHAR(100) | N | The description or name of the group that is defined. |
RXS_GROUP_ID | DOUBLE | N | Unique, generated number that identifies a single row on the RXS_GROUP table. |
RXS_GROUP_TYPE_CD | DOUBLE | N | Identifies the type of group. Initially, the only type will be for an order set. |
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_GROUP
Child Column in RXS_GROUP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CREATE_PRSNL_ID | PRSNL | PERSON_ID |
Parent Column in RXS_GROUP (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | RXS_GROUP_ID | RXS_GROUP_ITEM_RELTN | RXS_GROUP_ID |
RXS_GROUP_LOCATION_RELTN | RXS_GROUP_ID |
RXS_GROUP_ITEM_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | RxStation Group Item Relation |
Definition: | The items that are part of a defined group. |
Table Type: | REFERENCE |
Column Detail - RXS_GROUP_ITEM_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_TYPE_CD | DOUBLE | N | Indicates if this item is to be included or not included in the dispense. |
DEFAULT_REASON_CD | DOUBLE | N | The reason an override was performed. |
DEFAULT_ROUTE_CD | DOUBLE | N | The default route for this item in this group. |
ITEM_ID | DOUBLE | N | The item that is in the defined group. |
ITEM_QTY | DOUBLE | N | The default dose of the item in this group. |
RXS_GROUP_ID | DOUBLE | N | The group that this item belongs to. |
RXS_GROUP_ITEM_RELTN_ID | DOUBLE | N | Unique, generated number that identifies a single row on the RXS_GROUP_ITEM_RELTN 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 - RXS_GROUP_ITEM_RELTN
Child Column in RXS_GROUP_ITEM_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ITEM_ID | ITEM_DEFINITION | ITEM_ID |
RXS_GROUP_ID | RXS_GROUP | RXS_GROUP_ID |