Table Detail Report

RX_IMAGE_QUEUE_PRSNL_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Image Queue Personnel Relation
Definition: Stores the relationship between RX_IMAGE_QUEUE and PRSNL.
Table Type: REFERENCE





Column Detail - RX_IMAGE_QUEUE_PRSNL_RELTN


Column Name Type Null? Definition
IMAGE_QUEUE_ID DOUBLE N Identifies the specific Image Queue that is involved in this Queue to Personnel relationship.
IMAGE_QUEUE_PRSNL_RELTN_ID DOUBLE N The unique identifier for the Image Queue to User (prsnl) relationship.
PERSON_ID DOUBLE N The Personnel that uses the Image Queue.
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 - RX_IMAGE_QUEUE_PRSNL_RELTN


Child Column in RX_IMAGE_QUEUE_PRSNL_RELTN(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PRSNL PERSON_ID
IMAGE_QUEUE_ID RX_IMAGE_QUEUE IMAGE_QUEUE_ID


RX_IMAGE_QUEUE_TIME



Column Section Relationship Section Top of Page


Table-level Detail

Description: Image Queue Time
Definition: Stores the day of week and open/close times for a specific RX_IMAGE_QUEUE at a specific LOCATION.
Table Type: REFERENCE





Column Detail - RX_IMAGE_QUEUE_TIME


Column Name Type Null? Definition
CLOSE_TM_NBR DOUBLE N The time that a specific queue at a specific location is closed for a given day_of_week.
DAY_OF_WEEK_FLAG DOUBLE N The day of week that a specific Queue is open at a specific location.
IMAGE_QUEUE_LOC_RELTN_ID DOUBLE N Identifies the specific Queue and Location relationship.
IMAGE_QUEUE_TIME_ID DOUBLE N The unique identifier for the Day of Week and Times related to a RX_IMAGE_QUEUE and LOCATION.
OPEN_TM_NBR DOUBLE N The time that a specific Queue at a specific Location on a specific Day is open.
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 - RX_IMAGE_QUEUE_TIME


Child Column in RX_IMAGE_QUEUE_TIME(FK) Parent Table Name Parent Column Name
Parents: IMAGE_QUEUE_LOC_RELTN_ID RX_IMAGE_QUEUE_LOC_RELTN IMAGE_QUEUE_LOC_RELTN_ID


RX_IMG_IMGQUE_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Order Image Queue Relation
Definition: Stored the relationship between an image and a queue.
Table Type: ACTIVITY





Column Detail - RX_IMG_IMGQUE_RELTN


Column Name Type Null? Definition
IMAGE_ID DOUBLE N The unique, generated identifier for images within the Pharmacy Order Imaging data model.
IMAGE_QUEUE_ID DOUBLE N The generated, unique key for RX_IMAGE_QUEUE.
IMG_IMGQUE_RELTN_ID DOUBLE N Unique, generated key for RX_IMG_IMGQUE_RELTN.
ROUTE_BY_PRSNL_ID DOUBLE N Indicates if the image was system or manually routed and who routed the image if manual.
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 - RX_IMG_IMGQUE_RELTN


Child Column in RX_IMG_IMGQUE_RELTN(FK) Parent Table Name Parent Column Name
Parents: ROUTE_BY_PRSNL_ID PRSNL PERSON_ID
IMAGE_ID RX_IMAGE IMAGE_ID
IMAGE_QUEUE_ID RX_IMAGE_QUEUE IMAGE_QUEUE_ID


RX_IMG_IMGQUE_RELTN_HX



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Order Image Image Queue Relation History
Definition: Stored the historical relationship between an image and a queue.
Table Type: ACTIVITY





Column Detail - RX_IMG_IMGQUE_RELTN_HX


Column Name Type Null? Definition
COMPLETED_DT_TM DATETIME Y The time the image was either cancelled or completed.
COMPLETED_TZ DOUBLE N Time zone associated with COMPLETED_DT_TM.
IMAGE_ID DOUBLE N The unique, generated identifier for images within the Pharmacy Order Imaging data model.
IMAGE_QUEUE_ID DOUBLE N The generated, primary key for RX_IMAGE_QUEUE.
IMG_IMGQUE_RELTN_HX_ID DOUBLE N Unique, generated identifier for RX_IMG_IMGQUE_RELTN_HX.
ROUTE_BY_PRSNL_ID DOUBLE N Indicates if the image was system or manually routed and who routed the image if manual.
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 - RX_IMG_IMGQUE_RELTN_HX


Child Column in RX_IMG_IMGQUE_RELTN_HX(FK) Parent Table Name Parent Column Name
Parents: ROUTE_BY_PRSNL_ID PRSNL PERSON_ID
IMAGE_ID RX_IMAGE IMAGE_ID
IMAGE_QUEUE_ID RX_IMAGE_QUEUE IMAGE_QUEUE_ID


RX_LOC_RESOURCE_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Location Resource Relation
Definition: Location to pharmacy service resource relation.
Table Type: REFERENCE





Column Detail - RX_LOC_RESOURCE_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.
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.
DEFAULT_IND DOUBLE N DEFAULT_IND
DISP_EVENT_TYPE_CD DOUBLE N Dispense event type codes (e.g. Fill list, initial dose, extra dose)
LOCATION_CD DOUBLE N Location codes (e.g. nurse units, facilities, rooms)
PHARM_TYPE_CD DOUBLE N Pharmacy type codes (e.g. INPATIENT, AMBULATORY)
PRN_IND DOUBLE N Default value is 0, value of 1 indicates the routing is for use with PRN orders. PRN(latin) - pro re nata (as the situation demands; as needed).
RX_LOC_RESOURCE_RELTN_ID DOUBLE N Unique identifier for rows on the table. (primary key)
SEQUENCE_NBR DOUBLE N Priority sequence for evaluating the resource list for a given location.
SERVICE_RESOURCE_CD DOUBLE N Service resource codes (e.g. Main Pharmacy, Dispensing robot, Pyxis machine)
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 - RX_LOC_RESOURCE_RELTN


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