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. |