Table Detail Report

RXS_LOCATION_TASK_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: RxStation Location Task Relation
Definition: Some tasks cannot be completed until other related tasks are done first. This table links those prerequisites tasks to the dependent task
Table Type: ACTIVITY





Column Detail - RXS_LOCATION_TASK_RELTN


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.
CHILD_TASK_ID DOUBLE N A task that needs to be completed before the associated parent task can be performed.
PARENT_TASK_ID DOUBLE N The task that cannot be performed until the prerequisite tasks in CHILD_TASK_ID have been completed.
RELTN_TYPE_CD DOUBLE N The type of relation. Currently just has 2 values: SWAP and CSV (dispense from a narc vault).
RXS_LOCATION_TASK_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the RXS_LOCATION_TASK_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_LOCATION_TASK_RELTN


Child Column in RXS_LOCATION_TASK_RELTN(FK) Parent Table Name Parent Column Name
Parents: CHILD_TASK_ID RXS_LOCATION_TASK RXS_LOCATION_TASK_ID
PARENT_TASK_ID RXS_LOCATION_TASK RXS_LOCATION_TASK_ID


RXS_LOCATOR_ENCNTR



Column Section Relationship Section Top of Page


Table-level Detail

Description: RxStation Locator Encounter
Definition: Stores a locator's relation to a patient's encounter.
Table Type: ACTIVITY





Column Detail - RXS_LOCATOR_ENCNTR


Column Name Type Null? Definition
CLUSTER_CD DOUBLE N The cluster that this locator is part of.
ENCNTR_ID DOUBLE N The patient's encounter that is supplied through this locator.
LOCATION_CD DOUBLE N Identifies an RxStation device.
LOCATOR_CD DOUBLE N The bin location which is tied to this encounter.
PERSON_ID DOUBLE N The person whose encounter information is linked to this location.
RXS_LOCATOR_ENCNTR_ID DOUBLE N Unique generated number that identifies a single row on the RXS_LOCATOR_ENCNTR 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_LOCATOR_ENCNTR


Child Column in RXS_LOCATOR_ENCNTR(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
CLUSTER_CD LOCATION LOCATION_CD
LOCATION_CD LOCATION LOCATION_CD
LOCATOR_CD LOCATION LOCATION_CD
PERSON_ID PERSON PERSON_ID




Parent Column in RXS_LOCATOR_ENCNTR (PK) Child Table Name Child Column Name
Children: RXS_LOCATOR_ENCNTR_ID RXS_LOC_ENCNTR_INVENTORY RXS_LOCATOR_ENCNTR_ID


RXS_LOC_ACCESS_CONFIG



Column Section Relationship Section Top of Page


Table-level Detail

Description: RxStation Location Access Configuration
Definition: Holds information regarding which users in the system have access to certain locations.
Table Type: REFERENCE





Column Detail - RXS_LOC_ACCESS_CONFIG


Column Name Type Null? Definition
ACCESS_TYPE_FLAG DOUBLE N Defines the type of access the user has to the location.
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_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEGIN_EFFECTIVE_DT_TM DATETIME N The date that the access to the location becomes or became effective for use.
CREATE_DT_TM DATETIME Y The date that the record was created in the table.
CREATE_PRSNL_ID DOUBLE N The user who added this row to the table.
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.
LAST_UPDT_DT_TM DATETIME Y Date and time of the Last Update for this row.
LAST_UPDT_PRSNL_ID DOUBLE N The person that last updated this row.
LOC_CD DOUBLE N Location of the user access.
PRSNL_ID DOUBLE N The ID of the personnel for access.
RXS_LOC_ACCESS_CONFIG_ID DOUBLE N Unique genrerated number that identifies a single row on the RXS_LOC_ACCESS_CONFIG 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_LOC_ACCESS_CONFIG


Child Column in RXS_LOC_ACCESS_CONFIG(FK) Parent Table Name Parent Column Name
Parents: LOC_CD LOCATION LOCATION_CD
CREATE_PRSNL_ID PRSNL PERSON_ID
LAST_UPDT_PRSNL_ID PRSNL PERSON_ID
PRSNL_ID PRSNL PERSON_ID


RXS_LOC_ATTR



Column Section Relationship Section Top of Page


Table-level Detail

Description: RxStation Location Attribute
Definition: Stores the attributes to fully describe a RxStation location's type, behavior and configuration.
Table Type: REFERENCE





Column Detail - RXS_LOC_ATTR


Column Name Type Null? Definition
ATTR_CD DOUBLE N The attribute of the RxStation being defined. Examples are: humidity control (for a device level location) , mobility (for a tray level - whether the tray is fixed like a shelf or can be pulled out)
ATTR_VALUE_TXT VARCHAR(1000) N The value appropriate for a particular attribute of a particular RxStation device.
LOC_CD DOUBLE N The representation of the RxStation device or components in the Location model.
RXS_LOC_ATTR_ID DOUBLE N Unique, generated number that identifies a row in the RXS_LOC_ATTR 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_LOC_ATTR


Child Column in RXS_LOC_ATTR(FK) Parent Table Name Parent Column Name
Parents: LOC_CD LOCATION LOCATION_CD


RXS_LOC_ENCNTR_INVENTORY



Column Section Relationship Section Top of Page


Table-level Detail

Description: RxStation Location Encounter Inventory
Definition: Stores the inventory for a patient's encounter-specific bin.
Table Type: ACTIVITY





Column Detail - RXS_LOC_ENCNTR_INVENTORY


Column Name Type Null? Definition
ITEM_ID DOUBLE N The item on this encounter that is in this location.
ITEM_QTY DOUBLE N The quantity of the item in this location.
ORDER_ID DOUBLE N The order this item is associated with.
PACKAGE_TYPE_ID DOUBLE N The package type for this item.
RXS_LOCATOR_ENCNTR_ID DOUBLE N Indicates the location and encounter that this item is supplied for.
RXS_LOC_ENCNTR_INVENTORY_ID DOUBLE N Unique, generated number that identifies a single row on the RXS_LOC_ENCNTR_INVENTORY table.
TNF_ID DOUBLE N The template non-formulary key that is associated with this location and encounter. A type of product that does not relate to a real medication.
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_ENCNTR_INVENTORY


Child Column in RXS_LOC_ENCNTR_INVENTORY(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID MEDICATION_DEFINITION ITEM_ID
ORDER_ID ORDERS ORDER_ID
PACKAGE_TYPE_ID PACKAGE_TYPE PACKAGE_TYPE_ID
RXS_LOCATOR_ENCNTR_ID RXS_LOCATOR_ENCNTR RXS_LOCATOR_ENCNTR_ID