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 |