Table Detail Report

DISPENSE_REPLACE_AUDIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Dispense Replace Audit
Definition: Contains auditing information for when a dispense is replaced by a new dispense, or if a dispense failed to be replaced. This table only contains information about mismatching/incorrect item information that was found during redispensing workflows.
Table Type: ACTIVITY





Column Detail - DISPENSE_REPLACE_AUDIT


Column Name Type Null? Definition
CREATE_DT_TM DATETIME Y The date and time this record was created.
DISPENSE_REPLACE_AUDIT_CD DOUBLE N Code value containing user-facing messages related to which aspects of replacing a dispense caused a failure or a warning.
DISPENSE_REPLACE_AUDIT_ID DOUBLE N Unique generated number that identifies a single row on the DISPENSE_REPLACE_AUDIT table.
INIT_DISPENSE_HX_ID DOUBLE N Identifies the dispense that initiated the redispensing logic.
REPLACE_ITEM_ID DOUBLE N The item that was intended to replace an item on the dispense.
REPLACE_MANF_ITEM_ID DOUBLE N The manufacturer item that was intended to replace a manufacturer item on the dispense.
STATUS_FLAG DOUBLE N Denotes whether or not an audit event on this table represents a warning or a failure. When a failure exists on this table, the dispense related to the failure prevented a redispense to occur. When warnings exist, a redispense was allowed to occur.
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_REPLACE_AUDIT


Child Column in DISPENSE_REPLACE_AUDIT(FK) Parent Table Name Parent Column Name
Parents: INIT_DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID
REPLACE_MANF_ITEM_ID MANUFACTURER_ITEM ITEM_ID
REPLACE_ITEM_ID MEDICATION_DEFINITION ITEM_ID


DOSE_CALCULATOR_UOM



Column Section Top of Page


Table-level Detail

Description: Dose Calculator Unit of Measure
Definition: Contains the units of measure, conversion factors, and numerator/denominator units used by the dose calculator.
Table Type: REFERENCE





Column Detail - DOSE_CALCULATOR_UOM


Column Name Type Null? Definition
UOM_BASE_NBR DOUBLE N Identifier of base unit.
UOM_BRANCH_NBR DOUBLE N Identifier of branch unit. All base units have a branch unit ID equal to one.
UOM_CD DOUBLE N Unit of Measure
UOM_DENOMINATOR_CD DOUBLE N The denominator code value of a previously defined base unit.
UOM_MULTIPLY_FACTOR DOUBLE N Value to multiply measurement by to convert a branch unit of measure to a base unit of measure. Base units of measure have a conversion factor of one.
UOM_NUMERATOR_CD DOUBLE N The numerator code value of a previously defined base unit.
UOM_TYPE_FLAG DOUBLE N Flag to indicate type of Unit. Current valid types are Patient Weight and Administered Volume
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.


FILL_BATCH



Column Section Relationship Section Top of Page


Table-level Detail

Description: Fill Batch
Definition: This table groups fill cycles together as a single job.
Table Type: REFERENCE





Column Detail - FILL_BATCH


Column Name Type Null? Definition
CALENDAR_DAY_NBR DOUBLE N Indicates the specific calendar day which a Fill Batch is to start.
CYCLE_TIME DOUBLE N The length of time of the fill cycle for which orders will qualify to be dispensed.
CYCLE_UNIT_FLAG DOUBLE N This flag indicates what time measurement was used to specify the cycle_time.
DEFAULT_PRINTER_CD DOUBLE N Optional default printer code
DEF_OPERATION_FLAG DOUBLE Y Defines whether the batch run is to be defaulted to a particular operation. This is NOT a state but rathera default value for the building of batches.
DISCONTINUE_TIME DOUBLE Y The length of time for which discontinued orders should continue to be shown on the fill after they havebeen discontinued.
DISCONTINUE_UNIT_FLAG DOUBLE Y This flag indicates what time measurement was used to specify the discontinue_time.
FILL_BATCH_CD DOUBLE N The unique identifier for the parameters defined in this batch.
FILL_TIME DOUBLE N The length of time for which a supply of medication orders must be calculated and dispensed.
FILL_UNIT_FLAG DOUBLE N This flag indicates what time measurement was used to specify the fill_time.
INCOMPLETE_ORDER_IND DOUBLE Y Indicates whether incomplete orders are to be shown (supply calculated) on the fill.
LOCATION_CD DOUBLE N Location of the alternate dispense from location.
LOC_FACILITY_CD DOUBLE N Identifies the single facility location to which the Batch Report is related.
MAX_CYCLE_TIME DOUBLE Y The length of time that is the maximum for qualifying orders to be dispensed for this batch.
MAX_CYCLE_UNIT_FLAG DOUBLE Y This flag indicates what time measurement was used to specify the max_cycle.
MAX_FILL_TIME DOUBLE Y The length of time that is the maximum for dispensing meds (calculating doses to be dispensed) for this batch.
MAX_FILL_UNIT_FLAG DOUBLE Y This flag indicates what time measurement was used to specify the max_fill_time.
MIN_ELAPSED_TIME DOUBLE Y The length of time which must elapse before this batch is requested again.
MIN_ELAPSED_UNIT_FLAG DOUBLE Y This flag indicates what time measurement was used to specify the min_elapsed_time.
MONTHLY_DOW_FLAG DOUBLE N Indicates specific Day of Week (Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday) a Fill Batch is to start. 0 = Sunday, 1, = Monday, etc.
MONTHLY_WEEK_FLAG DOUBLE N Indicates which week (1st, 2nd, 3rd, 4th) a Fill Batch is to start.
ORDER_TYPE_FLAG DOUBLE Y Determines whether orders in this batch are of type MED, LVP, IVPB etc.
OUTPUT_FORMAT_CD DOUBLE N Format_cd for the type of desired output (report, labels, etc.)
PRN_FILL_TIME DOUBLE Y The length of time for which PRN orders are to have a supply calculated. A value of 0 indicates that PRN orders should not be filled with this batch.
PRN_FILL_UNIT_FLAG DOUBLE Y This flag indicates what time measurement was used to specify the prn_fill_time.
SUSPEND_TIME DOUBLE Y The length of time for which suspended orders should continue to be shown (supply calculated) on the fill after they have been suspended.
SUSPEND_UNIT_FLAG DOUBLE Y This flag indicates what time measurement was used to specify the suspend_time
UNVERIFIED_ORDER_IND DOUBLE Y Indicates whether unverified new orders are to be shown (supply calculated) on the fill.
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 - FILL_BATCH


Child Column in FILL_BATCH(FK) Parent Table Name Parent Column Name
Parents: FILL_BATCH_CD CODE_VALUE CODE_VALUE
DEFAULT_PRINTER_CD DEVICE DEVICE_CD
LOC_FACILITY_CD LOCATION LOCATION_CD


FILL_BATCH_HX



Column Section Relationship Section Top of Page


Table-level Detail

Description: fill_batch_hx
Definition: Table to store the history of each fill batch processing and the batch parameters.
Table Type: ACTIVITY





Column Detail - FILL_BATCH_HX


Column Name Type Null? Definition
CALENDAR_DAY_NBR DOUBLE N Indicates the specific calendar day which a Fill Batch is to start.
CYCLE_TIME DOUBLE Y The length of time of the fill cycle for which orders qualified to be dispensed.
CYCLE_UNIT_FLAG DOUBLE Y This flag indicates what time measurement was used to specify the cycle_time.
DEF_OPERATION_FLAG DOUBLE Y Defines whether the batch run is to be defaulted to a particular operation. This is NOT a state but rathera default value for the building of batches.
DISCONTINUE_TIME DOUBLE Y The length of time for which discontinued orders should continue to be shown on the fill after they havebeen discontinued.
DISCONTINUE_UNIT_FLAG DOUBLE Y This flag indicates what time measurement was used to specify the discontinue_time.
DIS_DT_TM DATETIME Y Date/time that dispensingtables were updated
END_DT_TM DATETIME Y Date/time processing completed
FILL_AUDIT_FLAG DOUBLE Y Set when the batch is completely processed, since the record is created at the beginning of the batch run.
FILL_BATCH_CD DOUBLE N code value for the fill batch
FILL_DT_TM DATETIME Y Date/time data was written to fill_print_Ord_hx table
FILL_HX_ID DOUBLE N The unique identifier for the parameters defined in this fill run.
FILL_TIME DOUBLE Y The length of time for which a supply of medication orders must be calculated and dispensed.
FILL_UNIT_FLAG DOUBLE Y This flag indicates what time measurement was used to specify the fill_time
FROM_DT_TM DATETIME Y Starting date/time used to qualify meds. Doses must be due after/equal to from _dt_tm
FROM_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
INCOMPLETE_ORDER_IND DOUBLE Y Indicates whether incomplete orders were shown (supply calculated) on the fill.
LOCATION_CD DOUBLE N Location of the alternate dispense from location.
MAX_CYCLE_TIME DOUBLE Y The length of time that is the maximum for qualifying orders to be dispensed for this batch.
MAX_CYCLE_UNIT_FLAG DOUBLE Y This flag indicates what time measurement was used to specify the max_cycle.
MAX_FILL_TIME DOUBLE Y The length of time that is the maximum for dispensing meds (calculating doses to be dispensed) for this batch.
MAX_FILL_UNIT_FLAG DOUBLE Y This flag indicates what time measurement was used to specify the max_fill_time.
MIN_ELAPSED_TIME DOUBLE Y The length of time which must elapse before this batch is requested again.
MIN_ELAPSED_UNIT_FLAG DOUBLE Y This flag indicates what time measurement was used to specify the min_elapsed_time.
MONTHLY_DOW_FLAG DOUBLE N Indicates specific Day of Week (Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday) a Fill Batch is to start.
MONTHLY_WEEK_FLAG DOUBLE N Indicates which week (1st, 2nd, 3rd, 4th) a Fill Batch is to start.
ORDER_COUNT DOUBLE Y Number of orders identifiedas qualifying for fill list
OUTPUT_DEVICE_CD DOUBLE N code value for desired output device
OUTPUT_DEVICE_S CHAR(50) Y text description for output device
OUTPUT_FORMAT_CD DOUBLE N code value for desired outputformat
PRINT_DT_TM DATETIME Y Date/time script to print data was called
PRN_FILL_TIME DOUBLE Y The length of time for which PRN orders are to have a supply calculated. A value of 0 indicates that PRN orders should not be filled with this batch.
PRN_FILL_UNIT_FLAG DOUBLE Y This flag indicates what time measurement was used to specify the prn_fill_time.
RUN_USER_ID DOUBLE N identifier for user who performed this operation
RUN_USER_S CHAR(50) Y Name of the run user
START_DT_TM DATETIME Y Date/time processing of fill list started. Used for audit purposes
START_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
SUSPEND_TIME DOUBLE Y The length of time for which suspended orders should continue to be shown (supply calculated) on the fill after they have been suspended.
SUSPEND_UNIT_FLAG DOUBLE Y This flag indicates what time measurement was used to specify the suspend_time
TO_DT_TM DATETIME Y Ending time to qualify meds. Orders must have doses due prior/equal to this date/time
TO_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
UNVERIFIED_ORDER_IND DOUBLE Y Indicates whether unverified new orders were shown (supply calculated) on the fill.
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 - FILL_BATCH_HX




Parent Column in FILL_BATCH_HX (PK) Child Table Name Child Column Name
Children: FILL_HX_ID DISPENSE_HX FILL_HX_ID
ORDER_DISPENSE LAST_FILL_HX_ID


FILL_CYCLE



Column Section Top of Page


Table-level Detail

Description: Fill Cycle
Definition: Table to store combination of location and dispense category and dispensing parameters
Table Type: REFERENCE





Column Detail - FILL_CYCLE


Column Name Type Null? Definition
AUDIT_FLAG DOUBLE Y Indicator set as the result of cycle processing
DISPENSE_CATEGORY_CD DOUBLE N Code value for the dispense category
FILL_CYCLE_ID DOUBLE N Primary Key
FROM_DT_TM DATETIME Y The beginning date and time of the current fill cycle range being filled in the pharmacy
FROM_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
IGNORE_IND DOUBLE Y NOT IN USE
LAST_OPERATION_FLAG DOUBLE Y The last operation (might be called the "current state") requested for this cycle.
LOCATION_CD DOUBLE N Code value of the nursing unit where meaning is "NURSEUNIT"
TO_DT_TM DATETIME Y The ending date and time of the current fill cycle range being filled in the pharmacy
TO_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.