Table Detail Report

FILL_CYCLE_BATCH



Column Section Top of Page


Table-level Detail

Description: fill_cycle_batch
Definition: Relationship table between fill_batch and fill_cycle
Table Type: REFERENCE





Column Detail - FILL_CYCLE_BATCH


Column Name Type Null? Definition
DISPENSE_CATEGORY_CD DOUBLE N Code value for the dispense category
FILL_BATCH_CD DOUBLE N Code value for the batch
LOCATION_CD DOUBLE N Code value of the nursing unit where meaning = "NURSEUNIT"
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_CYCLE_HX



Column Section Top of Page


Table-level Detail

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





Column Detail - FILL_CYCLE_HX


Column Name Type Null? Definition
AUDIT_ID DOUBLE N In case of error, set this value to the order_id of order being processed when failure occurred
DISPENSE_CATEGORY_CD DOUBLE N code value of the dispense category
END_DT_TM DATETIME Y date and time processing of this cycle ended
FILL_CYCLE_ID DOUBLE N unique identifier for a fill cycle
FILL_HX_ID DOUBLE N The unique identifier for the parameters defined in this fill run.
FROM_DT_TM DATETIME Y The beginning date and time of the filled cycle range.
FROM_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
LAST_OPERATION_FLAG DOUBLE Y The operation requested for this cycle.
LOCATION_CD DOUBLE N Code value of the location where meaning = "NURSEUNIT"
ORDER_COUNT DOUBLE Y Numberof orders qualifyingfor this cycle
START_DT_TM DATETIME Y Date and time processing began for this fill cycle
TO_DT_TM DATETIME Y The ending date and time of the filled cycle range
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.


FILL_PRINT_HX



Column Section Relationship Section Top of Page


Table-level Detail

Description: fill_print_hx
Definition: Header information for pharmacy ouput prior to printing
Table Type: ACTIVITY





Column Detail - FILL_PRINT_HX


Column Name Type Null? Definition
BATCH_DESCRIPTION VARCHAR(50) Y The user-viewed description identifying the parameters defined in this batch.
BATCH_REPORT_CD DOUBLE N Batch Report Cd
BAT_FILL_TIME DOUBLE Y The length of time for which a supply of medication orders must be calculated and dispensed.
CYC_FROM_DT_TM DATETIME Y The beginning date and time of the fill cycle.
CYC_FROM_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
CYC_TO_DT_TM DATETIME Y The ending date and time of the fill cycle.
CYC_TO_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
FILL_BATCH_CD DOUBLE N Unique identifier for a fill batch
FILL_HX_ID DOUBLE N The unique identifier for the parameters defined in a batch run.
OUTPUT_DEVICE_CD DOUBLE N Print device code batch was sent to.
OUTPUT_DEVICE_S CHAR(50) Y Print device name batch was sent to.
OUTPUT_FORMAT_CD DOUBLE N The setting for desired output type
RERUN_FLAG DOUBLE Y Indicates whether this operation was a rerun or not
RUN_ID DOUBLE N The unique identifier for the parameters defined in this print run.
RUN_TYPE_CD DOUBLE N Program run code (label, cartfill, MAR, ASO?)
RUN_USER_ID DOUBLE N User ID of person running this.
S_BAT_FILL_TIME_UNIT CHAR(10) Y The time measurement unit used to specify the fill_time.
S_OPERATION CHAR(12) Y The operation requested for the cycles in this batch.
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_PRINT_HX




Parent Column in FILL_PRINT_HX (PK) Child Table Name Child Column Name
Children: RUN_ID FILL_PRINT_ORD_HX RUN_ID


FILL_PRINT_ORD_HX



Column Section Relationship Section Top of Page


Table-level Detail

Description: fill_print_ord_hx
Definition: Order information for pharmacy ouput prior to printing
Table Type: ACTIVITY





Column Detail - FILL_PRINT_ORD_HX


Column Name Type Null? Definition
ACTION_SEQUENCE DOUBLE Y which action sequence the comment goes with
ADMIN_COUNT DOUBLE Y counter for number of administrations for this order
ADMIN_DT_TM DATETIME Y administration date and time
ADMIN_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
ADMIT_DT_TM DATETIME Y admission date and time
ADMIT_PHYS_ID DOUBLE N Admitting physician ID number
ADMIT_PHYS_NAME VARCHAR(50) Y Name of the admitting physician.
ADMIT_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
ATTEND_PHYS_ID DOUBLE N Attending Physicians ID number.
ATTEND_PHYS_NAME VARCHAR(50) Y Name of the attending physician.
AUTHORIZATION_NBR VARCHAR(50) Y Alpha numeric string returned by Claims Processor for Accepted Claims.
BAG_NBR DOUBLE Y Bag number in IV set.
BASAL_RATE_UNIT_CD DOUBLE Y Code value from code set 54 representing the Basal Rate Unit
BASAL_RATE_UNIT_S VARCHAR(40) Y Display value for the Basal Rate Unit.
BASAL_RATE_VALUE DOUBLE Y The amount of drug given as a continuous infusion.
BED_CD DOUBLE N Patients bed code value
BED_S CHAR(40) Y Patients bed description
BIRTH_DT_TM DATETIME Y Patient"s Birth Date
BIRTH_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
BRAND_NAME VARCHAR(50) Y Brand name of product
BSA DOUBLE Y Body Surface Area
BSA_UNIT_CD DOUBLE N Unit of measure for body surface area
BSA_UNIT_S VARCHAR(40) Y Display value for BSA unit code
CDM VARCHAR(25) Y A unique number that can be tied to a drug (or other things that may be billed to a patient) in order to associate a charge with it
CHARGE_QTY DOUBLE Y Quantity charged.
CLINICIAN_DOSE_UNIT_CD DOUBLE Y Code value from code set 54 representing the Clinician Dose Unit.
CLINICIAN_DOSE_UNIT_S VARCHAR(40) Y Display value for the Clinician Dose Unit.
CLINICIAN_DOSE_VALUE DOUBLE Y Prescribed dose that can be given at the discretion of the patient care provider.
COMMENT1_WHERE_TO_PRINT DOUBLE Y Specifies whether comment 1 will print on label, MAR, and/or fill.
COMMENT2_WHERE_TO_PRINT DOUBLE Y Specifies whether comment 2 will print on label, MAR, and/or fill.
COMMUNICATION_TYPE_CD DOUBLE N Code value representing the communication type for an order.
COMMUNICATION_TYPE_S VARCHAR(60) Y Description of orders communication type.
COMPOUND_IND DOUBLE Y Indicates that the Order is a compound order (Compounded with multiple ingredients.)
COMPOUND_TEXT_ID DOUBLE N Instructions for compounding
COMPOUND_TOTAL DOUBLE Y Compound Total
CONCENTRATION DOUBLE N For continuous infusions, the amount of a component in a given volume.
CONCENTRATION_UNIT_CD DOUBLE N Concentration unit of measure code value.
CONCENTRATION_UNIT_S VARCHAR(40) Y Display value for concentration unit of measure.
CONTAINER_SEQ DOUBLE Y The sequence of the container this row is associated to. Will only be greater than 0 for rows denoting products of split container dispense events.
CONTROL_NUMBER VARCHAR(25) Y A number Pharmacy uses when dispensing controlled substances.
COPAY DOUBLE Y Co pay amount
CRCL DOUBLE Y Most recent result for serum creatinine
CRCL_UNIT_CD DOUBLE N Unit of measure for creatinine clearance.
CRCL_UNIT_S VARCHAR(40) Y Display value for Creatinine Clearance unit code
CREDIT_INV_IND DOUBLE Y Identifies an Order that was credited during Net Cart event, but wasn't returned in Inventory.
CREDIT_QTY DOUBLE Y Quantity credited.
CUR_DISP_LOC_CD DOUBLE N Dispense from location code for the current event.
CUR_DISP_LOC_S VARCHAR(40) Y Display Value of the location code for the current event.
DAW_CD DOUBLE N Dispense as written code
DAYS_SUPPLY DOUBLE Y Number of days the quantity dispensed (given to the patient) will last.
DISPENSE_CATEGORY_CD DOUBLE N Dispense category code.
DISPENSE_CATEGORY_S CHAR(40) Y Dispense category.
DISPENSE_COMMENT_TEXT_ID DOUBLE Y Long_text_id of the dispense comment. Originally written to the order_comment table with comment_type_cd of "RXADISPNOTE".
DISPENSE_DEVICE_IND DOUBLE Y Dispense device indicator. 0 = this dispense event was not passed to a dispense device; 1 = this dispense event was passed to a dispense device.
DISPENSE_DT_TM DATETIME Y Dispense date and time
DISPENSE_FROM_CD DOUBLE N Code value representing the location that an order is dispensed from.
DISPENSE_FROM_S VARCHAR(60) Y Display value for the location code from which an order is dispensed.
DISPENSE_ID DOUBLE N Dispense Id for this order and dispense
DISPENSE_LOC_CD DOUBLE N Location where the last initial dose came from
DISPENSE_SR_CD DOUBLE N Dispense Service Resource code
DISPENSE_STATUS_HX_ID DOUBLE N Dispense Status Hx id
DISPENSE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column. For inpatient rows, this is the time zone of the encounter. For Retail Pharmacy, it is the time zone of the pharmacy's facility.
DISP_PRIORITY_CD DOUBLE N dispense Priority Cd
DISP_PRIORITY_DT_TM DATETIME Y Dispense Priority Date and tiem
DISP_PRIORITY_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
DISP_QTY DOUBLE Y Dispense Quantity
DISP_QTY_UNIT_CD DOUBLE N dispense quantityunit cd
DOSES_OMITTED_IND DOUBLE N Indicates if there were doses possibly omitted in this print for this order.
DOSE_FORM_CD DOUBLE N Code value representing the type of dose for an order.
DOSE_FORM_S VARCHAR(60) Y Display value for the dose form (e.g.: tab, ea...) of an order.
DOSE_LIMIT_TIME_UNIT_CD DOUBLE Y Code value from code set 54 representing the Dose Limit Time Unit.
DOSE_LIMIT_TIME_UNIT_S VARCHAR(40) Y Display value for the Dose Limit Time Unit.
DOSE_LIMIT_TIME_VALUE DOUBLE Y Time period related to the Dose Limit value.
DOSE_LIMIT_UNIT_CD DOUBLE Y Code value from code set 54 representing the Dose Limit Unit.
DOSE_LIMIT_UNIT_S VARCHAR(40) Y Display value for the Dose Limit Unit.
DOSE_LIMIT_VALUE DOUBLE Y Maximum amount of medication that can be delivered over a specified time period.
DOSE_QUANTITY DOUBLE Y Dose quantity.
DOSE_QUANTITY_TXT VARCHAR(150) Y Textual representation of the dose quantity as received from the device. For use with orders that utilize variable dosing.
DOSE_QUANTITY_UNIT_CD DOUBLE N Dose quantity unit of measure code.
DOSE_QUANTITY_UNIT_S CHAR(40) Y Dose quantity unit of measure.
DOSING_METHOD_FLAG DOUBLE N Indicates the type of dosing that is applied to the order.
DUR_CONFLICT_CD DOUBLE N DUR Conflict Cd
DUR_INTER_CD DOUBLE N Drug Utilization Review Interaction Code
DUR_OUTCOME_CD DOUBLE N DUR Outcome Cd
EARLY_REASON_CD DOUBLE N Early reason cd
ELIGIBILITY_CLARIFY_CD DOUBLE N Clarification Code indicating patient's eligibility for the benefit.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
ENTERED_DT_TM DATETIME Y Date and time order was entered into the system
ENTERED_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
ENTER_USER_ID DOUBLE N User ID of the person who entered the order
ENTRY_ID DOUBLE N ID of the person entering the order.
ENTRY_NAME VARCHAR(50) Y Name of the person who entered the order.
ERROR_LOG VARCHAR(100) Y Error information, if any.
EXTRA_REASON_CD DOUBLE N extra reason cd
EXT_COPAY_IND DOUBLE Y Used to notify external systems that a patient will be charged a copay for a prescription.
EXT_DISP_QTY DOUBLE Y Dispense quantity used to send to external systems.
EXT_DISP_QTY_CONV_FACTOR_AMT DOUBLE Y Client configurable dispense conversion factor within the Product Tool which is used to maintain the package size to dispense factor ratio by converting the NCPDP quantity to a quantity recognized by external systems.
EXT_DISP_QTY_UNIT_S VARCHAR(60) Y Dispense quantity unit used to send to external systems.
EXT_DRUG_DESC VARCHAR(200) Y Drug description used to send to external systems.
EXT_DRUG_IDENT VARCHAR(200) Y Client configurable drug identifier defined in the Product Tool to be sent outbound to an external system.
FACILITY_CD DOUBLE N Facility code.
FACILITY_S CHAR(40) Y Facility description.
FILL_ANCHOR_DT_TM DATETIME Y Fill date used to calculate the next dispense date/time.
FILL_NBR DOUBLE Y A sequential number indicating the number of times a prescription got filled.
FILL_NOTE_ID DOUBLE N Identifier for fill note.
FILL_QUANTITY DOUBLE Y fill quantity
FINNBR VARCHAR(100) Y Financial number
FINNBR_ID DOUBLE N financial number ID
FLOORSTOCK_IND DOUBLE Y Floorstock indicator - 1 = true, 0 = false.
FORMULARY_STATUS_CD DOUBLE N Formulary status code
FORMULARY_STATUS_S CHAR(40) Y Formulary status description
FORM_CD DOUBLE N Dosage form code.
FORM_S CHAR(40) Y Dosage form description
FREETEXT_DOSE VARCHAR(50) Y Free-text dose information.
FREETEXT_RATE VARCHAR(255) Y Text representing the rate for an order entered by user.
FREQUENCY_CD DOUBLE N Frequency code.
FREQUENCY_S CHAR(40) Y Frequency description
FUTURE_ORDER_IND DOUBLE N Indication of whether or not the order is in a future status at the time the dispense occurred.
GEN_NAME VARCHAR(200) Y Generic name of the product
HEALTH_PLAN_ID DOUBLE N Display name of the health plan.
HEALTH_PLAN_S VARCHAR(40) Y Display (Name) of the Health Plan
HEIGHT DOUBLE Y Patient"s height
HEIGHT_UNIT_CD DOUBLE N Unit of measure patients height is measured in.
HEIGHT_UNIT_S CHAR(40) Y Unit of measure patients height is measured in.
IBW DOUBLE Y Ideal Body Weight
IBW_UNIT_CD DOUBLE N Unit of measure for Ideal Body Weight.
IBW_UNIT_S VARCHAR(40) Y Display value for Ideal Body Weight unit code.
ICD9_ID DOUBLE N Nomenclature ID for the ICD9 code.
ICD9_S VARCHAR(100) Y ICD9_s
IGNORE_IND DOUBLE Y No longer in use.
INFUSE_OVER DOUBLE Y Time the IV will be infused over.
INFUSE_UNIT_CD DOUBLE N Unit of measure code IV infusion time is measured in.
INFUSE_UNIT_S CHAR(40) Y Unit of measure description IV infusion time is measured in.
INGRED_CNT DOUBLE Y Number of ingredients in order.
INGRED_DESC VARCHAR(200) Y Description of ingredient.
INGRED_SEQ DOUBLE Y The identifier for the ingredient
INS_CD DOUBLE N Insurance Code
INS_POLICY CHAR(40) Y Insurance Policy
ITEM_ID DOUBLE N The unique identifier for the product.
IV_IN_SEQ DOUBLE Y IV set rotation, Alternate IV.
IV_SET_SIZE DOUBLE Y Number of bags in IV set.
LABEL1_ID DOUBLE N Identifier for label 1 text
LABEL2_ID DOUBLE N Identifier for label 2 text
LABEL_DESC VARCHAR(200) Y Description for label
LABEL_REASON_CD DOUBLE N Reason for printing label code (fill, reprint, printer jam, etc.).
LABEL_REASON_S CHAR(40) Y Reason for printing label description (fill, reprint, printer jam, etc.).
LABEL_TYPE_CD DOUBLE N Label type that will be created when the row is printed.
LANGUAGE_CD DOUBLE N Patient's Language
LAST_REFILL_DT_TM DATETIME Y Last Refill date and time
LAST_REFILL_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
LATE_REASON_CD DOUBLE N late reason cd
LBL_ID DOUBLE N Column Not Used
LEGAL_STATUS_CD DOUBLE N DEA schedule code, etc.
LEGAL_STATUS_S CHAR(40) Y DEA schedule description, etc.
LOADING_DOSE_UNIT_CD DOUBLE Y Code value from code set 54 representing the Loading Dose Unit.
LOADING_DOSE_UNIT_S VARCHAR(40) Y Display value for the Loading Dose Unit.
LOADING_DOSE_VALUE DOUBLE Y Dose ordered to initiate medication treatment. This dose is typically larger than PCA dose
LOCATION_CD DOUBLE N Patient"s location code (nursing station).
LOCATION_S CHAR(40) Y Patient"s location (nursing station).
LOCKOUT_INT_UNIT_CD DOUBLE Y Code value from code set 54 representing the Lockout Interval Unit.
LOCKOUT_INT_UNIT_S VARCHAR(40) Y Display value for the Lockout Interval Unit.
LOCKOUT_INT_VALUE DOUBLE Y The time interval before the pump can provide the next PCA dose.
LOT_TRACKING_IND DOUBLE N Indicates whether or not lot tracking should be required for this item.
MANF_CD DOUBLE N manufacturer code
MEDREC_NBR VARCHAR(100) Y Med rec number
MEDREC_NBR_ID DOUBLE N Med rec number ID
MED_FIN_IND DOUBLE Y Indicator to display med rec number or financial number
MED_PRODUCT_ID DOUBLE N med Product Id
ML_HR DOUBLE Y IV rate
MULTUM_PIL_IDENT VARCHAR(20) Y Identifies the multum DNUM or MMDC identifier based on whether the prescribed drug has patient information leaflet data defined in the multum drug database. If MMDC has PIL information available, MMDC will be written. Otherwise, if DNUM has PIL information available, DNUM will be written.
NBR_OF_REFILLS DOUBLE Y Number of refills allowed
NDC VARCHAR(30) Y NDC Number
NET_CART_IND DOUBLE Y Indication to indicate that a change has occurred to the quantity on the cart.
NET_CART_QTY DOUBLE Y If order is changed, this field will contain the difference the human will need to change the quantity on the cart by.
NEXT_DISPENSE_DT_TM DATETIME Y next dispense date/time
NEXT_DISPENSE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column. For inpatient rows, this is the time zone of the encounter. For Retail Pharmacy, it is the time zone of the pharmacy's facility.
NORMALIZED_RATE DOUBLE N In the context of a continuous infusion, the amount of a medication to be administered per time unit (e.g., mg/hour), or the amount of a medication to be administered per patient weight unit per time unit (e.g., mcg/kg/minute).
NORMALIZED_RATE_UNIT_CD DOUBLE N Normalized rate unit of measure code value.
NORMALIZED_RATE_UNIT_S VARCHAR(40) Y Display value for normalized rate unit of measure.
ORDERED_AS_MNEMONIC VARCHAR(100) Y Text representing the name by which an ingredient was ordered.
ORDER_COMMENT_ID DOUBLE N Identifier representing the order comment.
ORDER_ENTRY_LOC_CD DOUBLE N not in use
ORDER_ID DOUBLE N Order identifier
ORDER_PRIORITY_CD DOUBLE N Code value representing the order priority.
ORDER_PRIORITY_S VARCHAR(60) Y Display value for the order priority.
ORDER_ROW_SEQ DOUBLE N Sequence counter for the rows included with this order
ORDER_START_DT_TM DATETIME Y Order start date and time.
ORDER_START_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
ORDER_STATUS_DT_TM DATETIME Y Order status date/time
ORDER_STATUS_ENUM DOUBLE Y Order status enumerated type
ORDER_STATUS_S CHAR(40) Y Order status
ORDER_STATUS_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
ORDER_STOP_DT_TM DATETIME Y Order stop date and time.
ORDER_STOP_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
ORDER_TYPE_FLAG DOUBLE Y Type of this order
ORD_COST DOUBLE Y Cost of the order
ORD_DESC VARCHAR(100) Y Order description.
ORD_PEND_STATUS CHAR(20) Y pending order status
ORD_PHYS_ID DOUBLE N Identifier for ordering physician
ORD_PHYS_NAME VARCHAR(50) Y Name of ordering physician
ORD_PRICE DOUBLE Y Price of the order
ORD_TYPE DOUBLE Y Type of order (med, IV)
OTHER_COVERAGE_CD DOUBLE N other coverage code
OUTPUT_FORMAT_CD DOUBLE N Code for desired output format
OVERFILL_AMT DOUBLE Y Overfill Amount
PATIENT_MED_IND DOUBLE N Indicates whether the order is a patient's own medication.
PATIENT_TEXT_ID DOUBLE N Long text id of patient note.
PAT_TEXT_ID DOUBLE N Not in use.
PAYMENT_METHOD_CD DOUBLE N Payment Method
PA_BEG_DT_TM DATETIME Y PA Beginning Date and time
PA_BEG_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
PA_END_DT_TM DATETIME Y PA End Date and Time
PA_END_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
PA_NUMBER VARCHAR(25) Y Prior Authorization Number
PCA_DOSE_UNIT_CD DOUBLE Y Code value from code set 54 representing the PCA Dose Unit.
PCA_DOSE_UNIT_S VARCHAR(40) Y Display value for the PCA Dose Unit.
PCA_DOSE_VALUE DOUBLE Y On-demand dose delivered by pump upon patient pressing dose delivery button
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PERSON_NAME_S VARCHAR(50) Y Patients name.
PERSON_OWE_QTY DOUBLE Y Amount of quantity owed to the patient on this dispense.
PHARM_COMMENT_TEXT_ID DOUBLE Y Long text id of the pharmacy comment. Originally from order_comment table with comment_type_cd of "PHARM COMMEN".
PHARM_TYPE_CD DOUBLE N Pharm type cd
PHYSICIAN_DEA_TXT VARCHAR(50) Y The doctor's Drug Enforcement Administration number
PKG_COUNT DOUBLE Y Indicates the number of packages involved in the dispense event.
PKG_NBR DOUBLE Y Indicates the relative package within the dispense if multiple packages are dispensed. (i.e., 1 of 2, 2 of 2)
PKG_QUANTITY DOUBLE Y Indicates the quantity in each package
PRICE_CODE_CD DOUBLE N Price code code
PRN_IND DOUBLE Y Indicates whether this is a prn order
PRN_REASON_CD DOUBLE N Code Value representing PRN reason.
PRN_REASON_S VARCHAR(60) Y String representation of the PRN reason for the order.
PRODUCT_NOTE_ID DOUBLE N Identifier representing the product note.
PRODUCT_STRENGTH_UNIT_CD DOUBLE Y Strength unit code value of an individual product within an order.
PRODUCT_STRENGTH_VALUE DOUBLE Y Strength value of an individual product within an order.
PRODUCT_VOLUME_UNIT_CD DOUBLE Y Volume unit code value of an individual product within an order.
PRODUCT_VOLUME_VALUE DOUBLE Y Volume value of an individual product within an order.
PROD_CNT DOUBLE Y Total number of products in the ingredient
PROD_DESC VARCHAR(200) Y Description of product.
PROXY_PRESCRIBER_ID DOUBLE N The proxy prescriber identifier of the prescription.
PROXY_PRESCRIBER_NAME VARCHAR(50) Y The proxy prescriber name of the prescription.
QTY_REMAINING DOUBLE Y Quantity remaining
RACE_CD DOUBLE N code value for race
RACE_S CHAR(40) Y race
RATE DOUBLE Y IV rate
REASON_FOR_USE VARCHAR(100) Y reason for use
REFILLS_REMAINING DOUBLE Y refills remaining
REFILL_QTY DOUBLE Y refill quantity
REIMBURSEMENT DOUBLE Y Amount reimbursed by the health plan
REPLACE_EVERY DOUBLE Y Length of time after which an IV bag should be replaced
REPLACE_EVERY_UNIT_CD DOUBLE N Unit of Measure for replace_every interval
REPLACE_EVERY_UNIT_S VARCHAR(40) Y Denormalized display value for replace_every_unit_cd
REPORT_ID DOUBLE N Column Not Used
ROOM_CD DOUBLE N Code value for room
ROOM_S CHAR(40) Y room description
ROUTE_CD DOUBLE N Route code.
ROUTE_S CHAR(40) Y Route description
RPH_ID DOUBLE N ID for pharmacist
RPH_INITIALS CHAR(8) Y Pharmacist initials
RPH_NAME VARCHAR(50) Y Pharmacist name
RUN_ID DOUBLE N Print run identifier
RX_EXPIRE_DT_TM DATETIME Y rx expire date and time
RX_EXPIRE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
RX_NBR DOUBLE Y Retail number
RX_NBR_CD DOUBLE N Prescription number
RX_NBR_IN_SET DOUBLE Y retail number in set
RX_NBR_S VARCHAR(40) Y Formatted Prescription Number
RX_PERSON_OWE_DOSES_CNT DOUBLE Y This field will populate with person owe doses associated to the order.
RX_QTY DOUBLE Y rx quantity
RX_SET_SIZE DOUBLE Y rx_set_size
RX_WORKSTATION_CD DOUBLE N Service Resource Level 5 code (Code Set 221, CDF Meaning 'LEVEL5'). Identifies the pharmacy workstation that administered the order; entered, dispensed, etc.
SAFETY_CAP_CD DOUBLE N Indicates whether or not the patient has requested a Safety Cap for their prescription
SAFETY_CAP_S VARCHAR(1) Y safety_cap_s
SCH_PRN_IND DOUBLE Y Indicator for prn order with scheduled times
SCRIPT_CLARIFY_CD DOUBLE N Script (prescription) clarification code
SCRIPT_ORIGIN_CD DOUBLE N Code indicating the origin of the prescription.
SEX_CD DOUBLE N Sex code
SEX_S CHAR(40) Y Sex description
SIDE_EFFECT_CODE VARCHAR(10) Y Not in use at present time.
SIG_ALT_LANG_TEXT_ID DOUBLE N Long Text ID for the alternate language signature instructions.
SIG_CODES VARCHAR(100) Y Pharmacy signature codes (such as PO BID)
SIG_TEXT_ID DOUBLE N Long Text ID for the primary or default language signature instructions.
SKIP_DISPENSE_FLAG DOUBLE N A flag that indicates if the product was dispensed or skipped
SORT_CLASS VARCHAR(20) Y Not in use.
SPLIT_CONTAINER_FLAG DOUBLE Y Indicates whether the dispense event was associated to a split container dispense.
STATUS_DT_TM DATETIME Y Status date and time
STRENGTH DOUBLE Y Strength value
STRENGTH_UNIT_CD DOUBLE N Code value for strength unit
STRENGTH_UNIT_S CHAR(40) Y Strength unit description
STRENGTH_WITH_OVERFILL_UNIT_CD DOUBLE N The strength dose unit on the product's ingredient including the overfill added during TPN balancing.
STRENGTH_WITH_OVERFILL_UNIT_S VARCHAR(40) Y Display value of the strength_with_overfill unit of measure.
STRENGTH_WITH_OVERFILL_VALUE DOUBLE N The strength dose on the product's ingredient including the overfill added during TPN balancing.
SUSPEND_ROUTING_TYPE_CD DOUBLE Y Routing type for a suspended order.
TECH_ID DOUBLE N Pharmacy tech prsnl_id that was responsible for this print.
TECH_INITIALS VARCHAR(8) Y Pharmacy Tech username that was responsible for this print.
TECH_NAME VARCHAR(50) Y Pharmacy tech name (full formatted) that was responsible for this print.
TEMP_STOCK_IND DOUBLE N If set to 1, this was a temporary stock event.
THER_CLASS_CODE VARCHAR(20) Y AHFS Code Number (e.g. 080000)
THER_CLASS_DESC VARCHAR(100) Y AHFS class description (e.g. Anti-Infectives)
THER_CLASS_ID DOUBLE N Key to alt_sel_cat table
THER_CLASS_SORT_CODE VARCHAR(20) Y Therapeutic class of first ingredient, used for sorting.
TITRATE_IND DOUBLE Y Titrate indicator; 1 = titrate, 0 = not titrate.
TNF_ID DOUBLE N Key to template_non-formulary table
TOTAL_REFILLS DOUBLE Y Number of times a prescription can be re-filled (does NOT include the initial fill)
TOTAL_RX_QTY DOUBLE Y total rx quantity
TOT_VOLUME DOUBLE Y Total volume
TRACK_NBR DOUBLE Y A number to track the prescription
TRACK_NBR_CD DOUBLE N TRACK nbr cd
TRACK_NBR_S VARCHAR(40) Y track number s
TRANSFER_TO_LOC_CD DOUBLE N Location code where stock is transferred to.
TRANSFER_TO_LOC_S VARCHAR(40) Y Display value for location code where stock is transferred to.
UC_PRICE DOUBLE Y Usual and Customary Price
UNIQUE_BAG_ID DOUBLE N Column Not Used
UNROUNDED_DOSE_QTY DOUBLE Y Product's quantity per dose prior to rounding for the product dispense.
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.
VERIFY_PRSNL_ID DOUBLE Y Personnel who created or verified the order.
VOLUME DOUBLE Y Volume
VOLUME_UNIT_CD DOUBLE N Volume unit of measure code.
VOLUME_UNIT_S CHAR(40) Y Volume unit of measure.
VOLUME_WITH_OVERFILL_UNIT_CD DOUBLE N The volume dose unit on the product's ingredient including the overfill added during TPN balancing.
VOLUME_WITH_OVERFILL_UNIT_S VARCHAR(40) Y Display value of the volume_with_overfill unit of measure.
VOLUME_WITH_OVERFILL_VALUE DOUBLE N The volume dose on the product's ingredient including the overfill added during TPN balancing.
WASTE_FLAG DOUBLE Y Indicates this dispense event can have waste applied.
WEIGHT DOUBLE Y Patient"s weight.
WEIGHT_UNIT_CD DOUBLE N Unit of measure patients weight is measured in.
WEIGHT_UNIT_S CHAR(40) Y Unit of measure patients weight is measured in.



Relationship Detail - FILL_PRINT_ORD_HX


Child Column in FILL_PRINT_ORD_HX(FK) Parent Table Name Parent Column Name
Parents: THER_CLASS_ID ALT_SEL_CAT ALT_SEL_CATEGORY_ID
DISPENSE_ID DISPENSE_HX DISPENSE_HX_ID
DISPENSE_STATUS_HX_ID DISPENSE_STATUS_HX DISPENSE_STATUS_HX_ID
FINNBR_ID ENCNTR_ALIAS ENCNTR_ALIAS_ID
MEDREC_NBR_ID ENCNTR_ALIAS ENCNTR_ALIAS_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
RUN_ID FILL_PRINT_HX RUN_ID
HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
ITEM_ID ITEM_DEFINITION ITEM_ID
COMPOUND_TEXT_ID LONG_TEXT LONG_TEXT_ID
DISPENSE_COMMENT_TEXT_ID LONG_TEXT LONG_TEXT_ID
FILL_NOTE_ID LONG_TEXT LONG_TEXT_ID
LABEL1_ID LONG_TEXT LONG_TEXT_ID
LABEL2_ID LONG_TEXT LONG_TEXT_ID
ORDER_COMMENT_ID LONG_TEXT LONG_TEXT_ID
PATIENT_TEXT_ID LONG_TEXT LONG_TEXT_ID
PAT_TEXT_ID LONG_TEXT LONG_TEXT_ID
PHARM_COMMENT_TEXT_ID LONG_TEXT LONG_TEXT_ID
PRODUCT_NOTE_ID LONG_TEXT LONG_TEXT_ID
SIG_ALT_LANG_TEXT_ID LONG_TEXT LONG_TEXT_ID
SIG_TEXT_ID LONG_TEXT LONG_TEXT_ID
MED_PRODUCT_ID MED_PRODUCT MED_PRODUCT_ID
ICD9_ID NOMENCLATURE NOMENCLATURE_ID
ORDER_ID ORDERS ORDER_ID
PERSON_ID PERSON PERSON_ID
VERIFY_PRSNL_ID PRSNL PERSON_ID


FREQUENCY_SCHEDULE



Column Section Relationship Section Top of Page


Table-level Detail

Description: FREQUENCY SCHEDULE
Definition: The schedule details for the frequency (i.e. TOD, DOW, Interval, etc.)
Table Type: REFERENCE





Column Detail - FREQUENCY_SCHEDULE


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
ACTIVITY_TYPE_CD DOUBLE N Used for flexing frequencies by department/activity. Default is activity_type_cd of 0, A given frequency will have 1 or more associated activity type codes it is valid for, each schedule will be specific to 1 activity_type
CRITICAL_UPDT_DT_TM DATETIME Y The date and time when the critical modify action was performed.
CRITICAL_UPD_ID DOUBLE N The user id of the person who performed the critical modify action.
DEFAULT_PAR_VAL DOUBLE Y A par value to be defaulted during Order Entry when this frequency is ordered and the order has been specified as PRN. Order catalog-level par values will override this.
DESCRIPTION VARCHAR(100) Y Provides a user-defined description for the frequency schedule.
EFFECTIVE_DT_TM DATETIME Y Applies to ad hoc frequencies only. Used to maintain a record of when a given schedule was in effect for an order.
FACILITY_CD DOUBLE N This column is used for flexing schedules by facility.
FIRST_DOSE_METHOD DOUBLE Y Defines the method used to calculate the start date/time for the order.
FIRST_DOSE_RANGE DOUBLE Y Defines the range to calculate the start date/time when the first_dose_method of 3 is selected. The range is expressed as defined by the first_dose_range_unit.
FIRST_DOSE_RANGE_UNITS DOUBLE Y Defines the time unit of the first_dose_range, applicable only if first_dose_method of 3.
FREQUENCY_CD DOUBLE N The parent frequency code value
FREQUENCY_ID DOUBLE N A specific schedule for the parent frequency
FREQUENCY_TYPE DOUBLE Y Defines what kind of schedule this frequency is using. 1 = time of day, 2 = day of week, 3 = interval, 4 = onetime only, 5 = no specific time
FREQ_QUALIFIER DOUBLE N Primary Key. Defines the domain of ordering attributes which point to the appropriate schedule for a specific order. Frequency_qualifier = 16 represents custom frequencies.
INSTANCE DOUBLE N Will be stored as an order detail for a given order. Only applies to ad hoc frequencies, and is incremented every time the schedule for the ad hoc is modified. Will allow a record of changes to the scheduled to be maintained
INTERVAL DOUBLE Y Defines the interval of the frequency scheduled defined as interval_units. Only applicable to frequency_type of 3.
INTERVAL_UNITS DOUBLE Y Defines the time unit of the interval. Only applicable to frequency_type of 3.
MAX_EVENT_PER_DAY DOUBLE Y Maximum number of events to be given in one day. NOTE: PharmNet will use this field only with Type 5 frequencies for purposes of Dosage Range Management rules or other rules based on doses per day
MIN_EVENT_PER_DAY DOUBLE Y Minimum number of events (e.g. Dispenses, administrations, etc.) to be counted, charted, etc. per day. NOTE: PharmNet will use this field only with Type 5 frequencies for purposes of Dosage Range Management rules or other rules based on doses per day.
MIN_INTERVAL_NBR DOUBLE N The suggested minimum elapsed time between administrations.
MIN_INTERVAL_UNIT_CD DOUBLE N The unit value for the minimum interval number (i.e. day(s), minute(s), second(s), etc.)
PARENT_ENTITY CHAR(32) Y These act as pointers to the flexing agent. Frequencies are flexed by the following: Physician, Location, Location Group, Orderable, Therapeutic Class. In the case of an Ad-hoc frequency, this will be ORDERS.
PARENT_ENTITY_ID DOUBLE N Parent entity id for merge. Root entity will vary depending on type of frequencies. Qualifiers 10 & 8 will refer to the code_value table qualifier 4 to the order_catalog Qualifier 6 to the alt_sel_cat table Qualifier 12 to prsnl table Qualifier 16 to the orders table
PRN_DEFAULT_IND DOUBLE Y PRN Indicator
ROUND_TO DOUBLE Y Defines the rounding in minutes when the first_dose_ method of 0 is selected.
RX_TOD_DOW_ID DOUBLE N Time of Day and Day of Week combination that this frequency occurs.
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 - FREQUENCY_SCHEDULE


Child Column in FREQUENCY_SCHEDULE(FK) Parent Table Name Parent Column Name
Parents: ACTIVITY_TYPE_CD CODE_VALUE CODE_VALUE
CRITICAL_UPD_ID PRSNL PERSON_ID
RX_TOD_DOW_ID RX_TOD_DOW RX_TOD_DOW_ID




Parent Column in FREQUENCY_SCHEDULE (PK) Child Table Name Child Column Name
Children: FREQUENCY_ID ORDERS FREQUENCY_ID
ORDER_ACTION FREQUENCY_ID
ORDER_DISPENSE FREQUENCY_ID