DISPENSE_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Dispense Detail
Definition: Table to store additional dispensing details when the fill process is done externally; via a mail order pharmacy.
Table Type: ACTIVITY





Column Detail - DISPENSE_DETAIL


Column Name Type Null? Definition
DETAIL_GROUP_SEQ DOUBLE N The sequence used to group related dispense detail.
DETAIL_TYPE_CD DOUBLE N The type of dispense detail recorded in this row.
DETAIL_VALUE_CD DOUBLE N The value of the dispense detail if a numerif or coded value.
DETAIL_VALUE_DT_TM DATETIME Y The date and time value of the dispense detail if of type date/time.
DETAIL_VALUE_NBR DOUBLE Y The value of the dispense detail if a numerif or coded value.
DETAIL_VALUE_TM_ZN DOUBLE Y The time zone associated with the corresponding DT_TM column.
DETAIL_VALUE_TXT VARCHAR(500) Y The display value of the dispense detail.
DISPENSE_DETAIL_ID DOUBLE N Unique generated number that identifies a single row on the DISPENSE_DETAIL table.
DISPENSE_HX_ID DOUBLE N Unique identifier for a dispense event.
DISPENSE_STATUS_CD DOUBLE N The dispense status code which represents the dispense tracking step during which the dispense detail was obtained.
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 - DISPENSE_DETAIL


Child Column in DISPENSE_DETAIL(FK) Parent Table Name Parent Column Name
Parents: DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID


DISPENSE_STATUS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Dispense Status
Definition: Dispense_Status
Table Type: ACTIVITY





Column Detail - DISPENSE_STATUS


Column Name Type Null? Definition
DISPENSE_HX_ID DOUBLE N DISPENSE_HX_ID
DISPENSE_STATUS_CD DOUBLE N dispense status code
DISPENSE_STATUS_ID DOUBLE N dispense_status_id
LEVEL5_CD DOUBLE N LEVEL5 CD
SUBSECTION_CD DOUBLE N subsection_cd
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 - DISPENSE_STATUS


Child Column in DISPENSE_STATUS(FK) Parent Table Name Parent Column Name
Parents: DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID


DISPENSE_STATUS_ERR



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table contains the error information for the Inbound Interface.
Definition: This Table contains the error information for any prescription that does not make it through the Inbound Baker Interface process. (non-reference, purgable)
Table Type: ACTIVITY





Column Detail - DISPENSE_STATUS_ERR


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.
COMPLETED_DT_TM DATETIME N This is the date and time the Dispense actually completes (i.e. recovery is completed).
COMPLETED_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
COMPLETED_USER_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that corrected the error(s) and completed the dispense.
DISPENSE_ERR_CD DOUBLE N Identifies the type of Error that has occurred.
DISPENSE_HX_ID DOUBLE N Identifies related dispense transaction that the error occurred on. From the Dispense_Hx table.
DISPENSE_QTY DOUBLE N This represents the number of a particular drug to dispense.
DISPENSE_STATUS_CD DOUBLE N This reflects the status of the Dispense Event.
DISPENSE_STATUS_ERR_ID DOUBLE N Unique Identifier to identify a particular dispense_status_err record.
POSTED_DT_TM DATETIME N This is the date and time the user first corrected the error.
POSTED_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
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 - DISPENSE_STATUS_ERR


Child Column in DISPENSE_STATUS_ERR(FK) Parent Table Name Parent Column Name
Parents: DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID


DISPENSE_STATUS_HX



Column Section Relationship Section Top of Page


Table-level Detail

Description: Dispense_status_hx
Definition: Dispense status hx
Table Type: ACTIVITY





Column Detail - DISPENSE_STATUS_HX


Column Name Type Null? Definition
COMPLETED_DT_TM DATETIME Y Completed date and time
COMPLETED_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
COMPLETED_USER_ID DOUBLE N completed_user id
DISPENSE_HX_ID DOUBLE N dispense_hx_id
DISPENSE_STATUS_CD DOUBLE N dispense status d
DISPENSE_STATUS_HX_ID DOUBLE N DISPENSE-STATUS_HX_ID
LEVEL5_CD DOUBLE N LEVEL5_CD
SUBSECTION_CD DOUBLE N subsection cd
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 - DISPENSE_STATUS_HX


Child Column in DISPENSE_STATUS_HX(FK) Parent Table Name Parent Column Name
Parents: DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID




Parent Column in DISPENSE_STATUS_HX (PK) Child Table Name Child Column Name
Children: DISPENSE_STATUS_HX_ID FILL_PRINT_ORD_HX DISPENSE_STATUS_HX_ID
RXA_WORK_LOAD_OBS_ST DISPENSE_STATUS_HX_ID


DISP_PRIORITY



Column Section Top of Page


Table-level Detail

Description: DISPENSE PRIORITY
Definition: Disp_priority - Stores Dispensing priorities used for Prescriptions.
Table Type: REFERENCE





Column Detail - DISP_PRIORITY


Column Name Type Null? Definition
ALLOW_TIME_CHG_IND DOUBLE Y INDICATOR (0 OR 1). Indicates whether or not to allow the dispense time to be changed during order entry / refill process.
DISP_PRIORITY_CD DOUBLE N CODE VALUE FROM CODE SET 4513 - Dispense Priority.
DISP_SEQ_CD DOUBLE N CODE VALUE FROM CODE SET 4507 - Indicates sequence of dispense events.
FIXED_TIME DOUBLE Y TIME (0000 TO 2359). Time which will default in the dispense time field during order entry / refill process. If Use_time_ind = 0, then the fixed time will default in for this Dispense Priority. The more specific default value from Dispense Priority / Service Resource will override this default value.
HIGH_PRIORITY_IND DOUBLE Y INDICATOR (0 OR 1). Indicates whether or not the highest consideration should be given orders with this dispense priority
NEXT_DAY_IND DOUBLE Y INDICATOR (0 OR 1). If using Fixed_time option, and current time is after fixed time in Order Entry / Refill process, this indicates whether or not to automatically switch the dispense priority date to the next day.
ONFILE_IND DOUBLE Y INDICATOR (0 OR 1). Indicates that prescription is considered "On File". No dispense events will occur.
ONHOLD_IND DOUBLE Y INDICATOR (0 OR 1). Indicates that prescription is "On Hold". No dispense events will occur, and order does not have to be complete to be saved.
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.
USE_TIME_IND DOUBLE Y INDICATOR (0 OR 1). Indicates if Dispense Priority Date/Time should default to current time (Use_time_ind = 1), or default to fixed time (Use_time_ind = 0).
WARN_USER_IND DOUBLE Y INDICATOR (0 OR 1). Indicates whether or not to warn user when dispense date automatically changes because of Next_day_ind options.