DISPENSE_CATEGORY



Column Section Relationship Section Top of Page


Table-level Detail

Description: DISPENSE CATEGORY
Definition: Child table for codeset 4008. Contains information for dispense categories
Table Type: REFERENCE





Column Detail - DISPENSE_CATEGORY


Column Name Type Null? Definition
AUTO_CREDIT_IND DOUBLE N Indicates if auto crediting should be performed on scheduled administration charge doses.
CHARGE_ON_SCHED_ADMIN_IND DOUBLE N Indicates if charges for a dispense should be based on the scheduled administration date for a particular dose.
CHARGE_PT_PRN_IND DOUBLE Y PRN orders' charge creation point.0 = Manual, 1 = charge on dispense, 2 = charge on administration
CHARGE_PT_SCH_IND DOUBLE Y Scheduled orders' charge creation point.0 = Manual, 1 = charge on dispense, 2 = charge on administration
DENIAL_REPORT_FORMAT_CD DOUBLE N The report format for the Patient Denial Report
DISPENSE_CATEGORY_CD DOUBLE N Dispense Category Code
DISP_FILL_DAYS_SUPPLY_AMT DOUBLE N Indicates Fill Batch dispensing Days Supply amount.
DISP_FILL_DAYS_SUPPLY_IND DOUBLE N Indicates that the Fill Batch dispensing method is 'Days Supply'.
DISP_FILL_DAYS_SUP_PKG_IND DOUBLE N Indicates if days supply with full package dispensing is being used for fill lists.
DISP_FILL_LBL_PRINTING_FLAG DOUBLE N Indicates how the system generates label and fill list printing data during continuing dose processing and is being added to address potential database and performance issues for sites running long fills. 0 = per dose; 1 = per dispense; 2 = per package.
DISP_FILL_PROD_PKG_IND DOUBLE N Indicates that the Fill Batch dispensing method is 'Package Supply'.
DISP_FILL_QTY_IND DOUBLE Y Indicator for how fill-processing should determine number of doses to dispense. e.g.: for bulk orders, fill quantity would likely be 1 or 0. -1 = Calculate the number of fill doses to dispense by frequency schedule or PAR value. 0-9 = Default as the number of fill doses to dispense.
DISP_FROM_PHLOCN_IND DOUBLE Y Always dispense an order with this dispense category from a pharmacy location if true.
DISP_QTY_RATIO_IND DOUBLE Y Indicates whether the ratio between the dose and the units to be dispensed should be automatically maintained by the system. NOTE: when maintaining the ratio, the round_disp_qty_ind may cause the units to be dispensed to round up to the next whole unit, i.e. cause the ratio to be different for fractional doses. 0 - Don't maintain the str/vol/dose ratio 1 - Maintain the str/vol/dose ratio
FILL_LIST_FORMAT_CD DOUBLE N Format cd associated with batch dispensing. Initial labels will use a separate format as well.
INDIVIDUAL_DOSE_DISPENSING_IND DOUBLE N Indicates whether or not the dispense event will generate separate events for each dose. 0 - do not do individual dispensing, 1 - do individual dispensing.
INTERIM_DAYS_SUPPLY_AMT DOUBLE N Indicates Interim Dose dispensing Days Supply amount.
INTERIM_DAYS_SUPPLY_IND DOUBLE N Indicates that the Interim Dose dispensing method is 'Days Supply'.
INTERIM_DAYS_SUP_PKG_IND DOUBLE N Indicates if days supply with full package dispensing is being used
INTERIM_DISP_QTY_IND DOUBLE Y Indicator for how order-entry processing should determine number of doses to dispense initially (interim doses). e.g.: for Bulk orders, initial doses might always be 1. -1 = Calculate the number of interim doses to dispense.0-9 = Default as the number of interim doses to dispense. Note: "0" means "do not calculate interim doses."
INTERIM_LBL_PRINTING_FLAG DOUBLE N Indicates how the system generates label printing data during initial dose processing and is being added to address potential database and performance issues for sites running long fills.
INTERIM_PROD_PKG_IND DOUBLE N Indicates that the Interim Dose dispensing method is 'Package Supply'.
LABEL_FORMAT_CD DOUBLE N This column contains the code value for the label format associated with the dispense category
LAST_RESORT_FILL_HRS DOUBLE Y Number of hours for which to calculate initial doses needing to be sent, if this type is NOT on a fill list for the nursing unit ordering the medication order. Non-negative integer.
LAST_RESORT_FILL_TIME DOUBLE Y The time of day used for calculating initial doses needing to be sent, if this type is NOT on a fill list for the nursing unit ordering the medication order. Non-negative integers expressed in minutes that must be converted to the time of day.
LBL_PER_DOSE DOUBLE Y Indicates whether a label should be printed for each dose time or only 1 label per order - NOT IN USE
LEAFLET_FORMAT_CD DOUBLE N Leaflet format cd
ORDER_TYPE_FLAG DOUBLE Y Determines the type of order entry format used with this dispense category
PHARM_TYPE_CD DOUBLE N Pharmacy type cd
PREVIEW_FORMAT_CD DOUBLE Y The custom label program used to generate the Postscript output for the Pharmacy Print Preview functionality.
PRICE_SCHED_ID DOUBLE N Price Schedule Id associated with the category
REFILL_NOTIFY_FORMAT_CD DOUBLE N Contains the format code for the refill notification.
REPLACE_EVERY DOUBLE Y Defines a default replace every for an IV order. This field is only used if the interval is > than this field.
REPORT_FORMAT_CD DOUBLE N This column contains the code value for the report format associated with the dispense category.
ROUND_DISP_QTY_IND DOUBLE Y Indicates if the quantity to be dispensed can be fractional or if the system should force it to be rounded to the nearest whole number. 0 = Allow partial units to be dispensed e.g. default 100MG 1EA, ordered as 150MG yields 1.5EA.1 = Round up units to be dispensed to the nearest whole number when the strength/volume entered does not yield a whole dispense unit, e.g. default 100MG 1EA, ordered as 150MG yields 2EA.
SKIP_DISPENSE_FLAG DOUBLE N Indicates whether this dispense category supports skipping of certain products, from dispensing, in a multi-ingredient IV/Continuous order.
TEMP_STOCK_IND DOUBLE N Indicator that the dispense category is defined as a temporary stock dispense category.
TPN_IND DOUBLE Y Indicator that dispense category is defined as a TPN dispense category
UNSUPPORTED_DAYS_SUPPLY_AMT DOUBLE N Indicates the Days Supply amount when the dispensing method for a patient's location that is unsupported by a Fill Batch process is 'Days Supply'.
UNSUPPORTED_DAYS_SUPPLY_IND DOUBLE N Indicates that the dispensing method for a patient's location that is unsupported by a Fill Batch process, will be 'Days Supply'.
UNSUPPORTED_DAYS_SUP_PKG_IND DOUBLE N Indicates if days supply with full package dispensing is being used for continuing dispensing when not on a fill.
UNSUPPORTED_DOSES_AMT DOUBLE N Indicates the Doses to be dispensed when the dispensing method for a patient's location that is unsupported by a Fill Batch process is "Specified Doses'.
UNSUPPORTED_DOSES_IND DOUBLE N Indicates that the dispensing method for a patient's location that is unsupported by a Fill Batch process, will be a 'Specified Doses.
UNSUPPORTED_LBL_PRINTING_FLAG DOUBLE N Indicates how the system generates label printing data during on-demand dose processing and is being added to address potential database and performance issues for sites filling large quantities at a time.012
UNSUPPORTED_PROD_PKG_IND DOUBLE N Indicates that the dispensing method for a patient's location that is unsupported by a Fill Batch process, will be 'Package Supply'.
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.
VALIDATION_FORMAT_CD DOUBLE N Validation format cd
WORKFLOW_CD DOUBLE N The dispense sequence associated to the product which is used to route orders to the dispense monitor.



Relationship Detail - DISPENSE_CATEGORY


Child Column in DISPENSE_CATEGORY(FK) Parent Table Name Parent Column Name
Parents: DISPENSE_CATEGORY_CD CODE_VALUE CODE_VALUE
LABEL_FORMAT_CD CODE_VALUE CODE_VALUE
PRICE_SCHED_ID PRICE_SCHED PRICE_SCHED_ID




Parent Column in DISPENSE_CATEGORY (PK) Child Table Name Child Column Name
Children: DISPENSE_CATEGORY_CD DISPENSE_CATEGORY_FORM_R DISPENSE_CATEGORY_CD
RXS_WORKLIST_DISP_CAT_R DISPENSE_CATEGORY_CD


DISPENSE_CATEGORY_FORM_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Relation table between dispense categories and dosage forms
Definition: Dispense category dosage form relationship table
Table Type: REFERENCE





Column Detail - DISPENSE_CATEGORY_FORM_R


Column Name Type Null? Definition
DISPENSE_CATEGORY_CD DOUBLE N dispense category code value
FORM_CD DOUBLE N Dosage form code value
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.
USAGE_FLAG DOUBLE N Indicates which type of dispensing situation would warrant this dispense category for a product of this dosage form being dispensed.



Relationship Detail - DISPENSE_CATEGORY_FORM_R


Child Column in DISPENSE_CATEGORY_FORM_R(FK) Parent Table Name Parent Column Name
Parents: FORM_CD CODE_VALUE CODE_VALUE
DISPENSE_CATEGORY_CD DISPENSE_CATEGORY DISPENSE_CATEGORY_CD


DISPENSE_HX



Column Section Relationship Section Top of Page


Table-level Detail

Description: Dispense History
Definition: Table to store historical pharmacy dispensing information
Table Type: ACTIVITY





Column Detail - DISPENSE_HX


Column Name Type Null? Definition
ACTION_SEQUENCE DOUBLE N Identifier to reference the action taken from order action
ADJUSTMENT_DT_TM DATETIME Y The data time this record was adjusted.
AUTHORIZATION_NBR VARCHAR(50) Y Authorization number for claims
AUTO_CREDIT_IND DOUBLE N Indicates if auto crediting should be performed on scheduled administration charge doses.
BATCH_IDENT_TXT VARCHAR(40) Y This is a unique identification assigned to each batch of dispensing data to be transferred outbound by FSI
BILL_QTY DOUBLE Y THE Bill Quantity
CHARGE_DT_TM DATETIME Y Date and time charge transaction sent
CHARGE_IND DOUBLE Y Flag to indicate whether charges were dropped
CHARGE_ON_SCHED_ADMIN_IND DOUBLE N Indicates if charges for a dispense should be based on the scheduled administration date for a particular dose.
CHARGE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
CHRG_DISPENSE_HX_ID DOUBLE N The DISPENSE_HX_ID of the parent row (the parent charge related to this credit event row).
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
CONTROL_IDENT_TXT VARCHAR(40) Y This is a unique identification assigned by FSI to distinctly identify each individual dispense that is sent in a batch
COPAY DOUBLE Y Copay amount of dispense transaction
COPAY_TIER_CD DOUBLE Y Medications are assigned to one of several categories, knows as copay tiers, based on drug usage, cost and clinical effectiveness. This will be used to determine the charges while dispensing a drug. Examples are Generics, and Brand-name drugs.
COST DOUBLE Y the Cost
CRDT_DISPENSE_HX_ID DOUBLE N The DISPENSE_HX_ID of the parent row (the parent credit related to this charge event row).
DISCOUNT_AMOUNT DOUBLE Y Discount amount of dispense transcation.
DISPENSE_CATEGORY_CD DOUBLE Y The dispense category that was applied to this dispense.
DISPENSE_DT_TM DATETIME Y date and time of dispense transaction
DISPENSE_FEE DOUBLE Y the dispense fee
DISPENSE_HX_ID DOUBLE N The unique identifier for a dispensing event
DISPENSE_PRSNL_ID DOUBLE N Identifier for personnel performing dispense event
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_EVENT_TYPE_CD DOUBLE N Identifier for the kind of dispense activity which occurred (extra dose, fill list, cart dose)
DISP_LOC_CD DOUBLE N Identifies the Pharmacy Location where a dispense event occurred.
DISP_PRIORITY_CD DOUBLE N Dispense Priority of dispense transaction
DISP_PRIORITY_DT_TM DATETIME Y the Dispense Priority Date and Time
DISP_PRIORITY_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
DISP_QTY DOUBLE Y Dispense Quantity for this dispense transaction
DISP_QTY_UNIT_CD DOUBLE N dispense quantity unit code
DISP_SR_CD DOUBLE N Service Resource Code of the Dispensing Location
DOSES DOUBLE Y The quantity of administrations dispensed
EARLY_REASON_CD DOUBLE N early reason code
EVENT_ID DOUBLE N Clinical Even ID
EVENT_TOTAL_PRICE DOUBLE Y Total Price associated with a dispense event
EXTRA_REASON_CD DOUBLE N extra reason code
FILL_ANCHOR_DT_TM DATETIME Y It is the Fill Date used to calculate the next dispense date/time.
FILL_HX_ID DOUBLE N Unique identifier from fill_batch_hx pointing to which batch this dispense event is from
FILL_NBR DOUBLE Y Fill number for dispense transaction
FIRST_DOSE_TIME DATETIME Y Date and time of the first dose
FIRST_DOSE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
FIRST_IV_SEQ DOUBLE Y Sequence number of the first bag within an alternating IV
FIRST_SCHEDULE_SEQ DOUBLE N A single DISPENSE_HX row may contain multiple dispensed doses that span multiple schedule_sequences. This is the first schedule sequence dispensed for calculating which schedule_sequences were dispensed.
FUTURE_CHARGE_IND DOUBLE N Value will indicate whether or not charges should occur for a future order.
GROUPER_DISPENSE_HX_ID DOUBLE Y The dispense history id of the first dispense of the group this dispense is a part of. Used to link dispense histories that are a part of the same dispense event. For example, this might link IDD (Individual Dose Dispenses) together.;
HEALTH_PLAN_ID DOUBLE N health plan id
INCENTIVE_AMT DOUBLE Y the Incentive amount
IVR_REFILL_IND DOUBLE Y Indicates that this dispense was initiated via a refill request coming from an interactive voice response system.
LAST_ADMIN_DT_TM DATETIME Y The last administration date and time for a dispense.
LAST_ADMIN_TZ DOUBLE Y The timezone for the last_admin_dt_tm field.
LATE_REASON_CD DOUBLE N the late reason code
LEVEL5_CD DOUBLE N the Work station that started the event
NEXT_DISPENSE_DT_TM DATETIME Y Date/time next dose should be dispensed
NEXT_DISPENSE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
OFFSET_DISPENSE_HX_ID DOUBLE Y Identifier for the waste dispense event which caused the current row's offset charge or credit to occur.
ORDER_ID DOUBLE N Identifier to reference the order dispensed
ORG_ACTION_SEQUENCE DOUBLE Y the Org action sequence
PBS_DISPENSING_INCENTIVE_AMT DOUBLE N Dispensing incentive amount paid by PBS.
PBS_DRUG_UUID VARCHAR(255) Y The unique identifier for the drug that appears in the PBS_DRUG table.
PBS_ELECTRONIC_RX_FEE_AMT DOUBLE N The fee paid for electronic prescriptions by PBS.
PBS_ITEM_CODE VARCHAR(10) Y The PBS item code for the drug that appears in the PBS_LISTING table.
PBS_ONLINE_INCENTIVE_AMT DOUBLE N Amount paid by PBS for online incentives.
PBS_PRF_AMT DOUBLE N Amount recorded on the Prescription Record Form for PBS dispenses. Fee paid by patients when they charge a prescription.
PF_DISPENSE_HX_ID DOUBLE N the pf dispense hx id
PF_REASON_CD DOUBLE N the pf reason cd
PHARM_TYPE_CD DOUBLE N Pharmacy Type associated with the Dispense transaction
PREV_DISPENSE_DT_TM DATETIME Y Date and time of previous dose
PREV_DISPENSE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
QTY_REMAINING DOUBLE Y the quantity remaining
REASON_CD DOUBLE N Identifier for cause of associated event type.
REBILL_DISPENSE_HX_ID DOUBLE N Stores the dispense_hx_id of the originally billed order.
REBILL_FLAG DOUBLE N Stores the type of rebill action.
REFILLS_REMAINING DOUBLE Y number of refills remaining
REFR_DISPENSE_HX_ID DOUBLE N This field will be populated with a dispense_hx_id that refers to a previous dispense associated to the original order.
REIMBURSEMENT DOUBLE Y Reimbursement Amount for this dispense transaction
RESIDUAL_COPAY_AMT DOUBLE Y Copay for the residual dispense quantity.
RESIDUAL_COST_AMT DOUBLE Y Total cost for the Residual Dispense Quantity.
RESIDUAL_DISCOUNT_AMT DOUBLE Y Discount amount for the residual dispense quantity.
RESIDUAL_DISPENSE_FEE_AMT DOUBLE Y Dispense fee for the residual dispense quantity.
RESIDUAL_DISP_QTY DOUBLE Y Amount of quantity that needs to be charged, after reversing the original charge, as a result of Cancel Owe event.
RESIDUAL_DOSES DOUBLE N The number of doses needing to be charged after the reverse transaction was placed.
RESIDUAL_INCENTIVE_FEE_AMT DOUBLE Y Incentive fee for the residual dispense quantity.
RESIDUAL_PRICE DOUBLE N The price needing to be charged after the reverse transaction was placed.
RESIDUAL_REIMBURSEMENT_AMT DOUBLE Y Reimbursement for the residual dispense quantity.
RESIDUAL_SALES_TAX_AMT DOUBLE Y Sales tax for the residual dispense quantity.
RESIDUAL_UC_PRICE DOUBLE Y Usual and Customary price for the residual dispense quantity.
REVERSE_IND DOUBLE N Indicates whether or not a reverse has been performed on the dispense.
REV_DISPENSE_HX_ID DOUBLE N The Dispense History ID that was reversed to allow for the credit transaction to be successful.
RUN_USER_ID DOUBLE N ID of the user generating the dispense event
RXA_ORDERING_UNIT_CD DOUBLE N The unit of the ordering quantity for the dispense.
SALES_TAX DOUBLE Y sales tax amount
SKIPPED_SCHEDULE_SEQ DOUBLE N The schedule sequence of a skipped dose.
SPLIT_CONTAINER_FLAG DOUBLE Y Indicates whether the dispense event was associated to a split container dispense.
SUPPRESS_CHARGE_FLAG DOUBLE Y Indicates whether the charges have been suppressed for the inpatient dispense
SYSTEM_GENERATED_IND DOUBLE Y Indicates the dispense event was generated by the system.
TRACK_NBR DOUBLE Y Tracking number of dispense transaction
TRACK_NBR_CD DOUBLE N the Tracking Number Prefix Code
TRANSFER_TO_LOC_CD DOUBLE N Location code where stock is transferred to.
UC_PRICE DOUBLE Y the Usual and Customary Price
UNIQUE_SCHEDULE_SEQ_NBR DOUBLE N The number of unique schedule sequences dispensed for this dispense event.
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.
WASTE_DISPENSE_HX_ID DOUBLE Y Identifier for the parent dispense event which this waste or waste offset was applied to.
WASTE_FLAG DOUBLE Y Indicates this dispense event can have waste applied.
WITNS_PRSNL_ID DOUBLE N Identifier for witness overseeing dispense event



Relationship Detail - DISPENSE_HX


Child Column in DISPENSE_HX(FK) Parent Table Name Parent Column Name
Parents: CONTRIBUTOR_SYSTEM_CD CONTRIBUTOR_SYSTEM CONTRIBUTOR_SYSTEM_CD
CHRG_DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID
CRDT_DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID
GROUPER_DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID
OFFSET_DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID
PF_DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID
REBILL_DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID
REFR_DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID
REV_DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID
WASTE_DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID
FILL_HX_ID FILL_BATCH_HX FILL_HX_ID
HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
DISP_LOC_CD LOCATION LOCATION_CD
ORDER_ID ORDERS ORDER_ID
DISPENSE_PRSNL_ID PRSNL PERSON_ID
RUN_USER_ID PRSNL PERSON_ID
WITNS_PRSNL_ID PRSNL PERSON_ID




Parent Column in DISPENSE_HX (PK) Child Table Name Child Column Name
Children: DISPENSE_HX_ID CE_MED_ADMIN_IDENT DISPENSE_HX_ID
DISPENSE_DETAIL DISPENSE_HX_ID
DISPENSE_HX CHRG_DISPENSE_HX_ID
DISPENSE_HX CRDT_DISPENSE_HX_ID
DISPENSE_HX GROUPER_DISPENSE_HX_ID
DISPENSE_HX OFFSET_DISPENSE_HX_ID
DISPENSE_HX PF_DISPENSE_HX_ID
DISPENSE_HX REBILL_DISPENSE_HX_ID
DISPENSE_HX REFR_DISPENSE_HX_ID
DISPENSE_HX REV_DISPENSE_HX_ID
DISPENSE_HX WASTE_DISPENSE_HX_ID
DISPENSE_HX_ALIAS DISPENSE_HX_ID
DISPENSE_REPLACE INIT_DISPENSE_HX_ID
DISPENSE_REPLACE ORIG_DISPENSE_HX_ID
DISPENSE_REPLACE REPLACE_DISPENSE_HX_ID
DISPENSE_REPLACE_AUDIT INIT_DISPENSE_HX_ID
DISPENSE_STATUS DISPENSE_HX_ID
DISPENSE_STATUS_ERR DISPENSE_HX_ID
DISPENSE_STATUS_HX DISPENSE_HX_ID
FILL_PRINT_ORD_HX DISPENSE_ID
ORDER_DISPENSE LAST_FILL_DISPENSE_HX_ID
ORDER_DISPENSE LAST_RX_DISPENSE_HX_ID
PHA_BATCH_REPORT_ACT_DTL DISPENSE_HX_ID
PHA_DISP_OBS_ST DISPENSE_HX_ID
PHA_PROD_DISP_OBS_ST DISPENSE_HX_ID
PROD_DISPENSE_HX DISPENSE_HX_ID
RXA_ORD_DISP_HP_OBS_ST DISPENSE_HX_ID
RXA_SUSPEND_ACT_LOG DISPENSE_HX_ID
RXA_WORK_LOAD_OBS_ST DISPENSE_HX_ID
RXS_ACTIVITY_INDEX DISPENSE_HX_ID
RXS_ALERT DISPENSE_HX_ID
RX_ADMIN_DISPENSE_HX DISPENSE_HX_ID
RX_CLAIM DISPENSE_HX_ID
RX_CLAIM_OVERRIDE DISPENSE_HX_ID
RX_CLAIM_PENDING DISPENSE_HX_ID
RX_DISPENSE_GENERATOR_AUDIT INITIATING_DISPENSE_HX_ID
RX_DISPENSE_ORDERS_RELTN DISPENSE_HX_ID
RX_INPT_CLAIM_HX DISPENSE_HX_ID
RX_INPT_CLAIM_HX OP_DISPENSE_HX_ID
RX_PENDING_REFILL DISPENSE_HX_ID
RX_PERSON_OWE DISPENSE_HX_ID
RX_PERSON_OWE RESOLVED_DHX_ID
RX_REFILL_HX DISPENSE_HX_ID
RX_WORKFLOW_STS DISPENSE_HX_ID


DISPENSE_HX_ALIAS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Dispense History Alias
Definition: Stores Dispense history alias from foreign dispensing system
Table Type: ACTIVITY





Column Detail - DISPENSE_HX_ALIAS


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.
ALIAS VARCHAR(200) N The system identifier for the record which originates from a foreign dispensing system.
ALIAS_POOL_CD DOUBLE N The alias pool code identifies a unique set or list of order identifiers.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
DISPENSE_HX_ALIAS_ID DOUBLE N Uniquely identifies the Dispense_Hx_Alias record that originated from a foreign system.
DISPENSE_HX_ALIAS_TYPE_CD DOUBLE N Type code which identifies the type of alias originating from the foreign system, e.g., dispense, order, etc.
DISPENSE_HX_ID DOUBLE N This field links the DISPENSE_HX_ALIAS record to the Dispensing event record. This will enable users to track each Inbound Alias to the appropriate Charge / Credit transaction.
QUEUE_ID DOUBLE N This field links the DISPENSE_HX_ALIAS record to the Pharmacy Queue Error record. This will enable users to track each Inbound Alias to the appropriate error record.
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_HX_ALIAS


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


DISPENSE_REPLACE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Dispense Replace
Definition: Tracks when a dispense was replaced by a new dispense, and which dispense replaced it.
Table Type: ACTIVITY





Column Detail - DISPENSE_REPLACE


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.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
CREATE_DT_TM DATETIME Y The date and time the replacement dispense was created.
DISPENSE_REPLACE_ID DOUBLE N Unique generated number that identifies a single row on the DISPENSE_REPLACE table.
INIT_DISPENSE_HX_ID DOUBLE N The DISPENSE_HX_ID of the dispense from the DISPENSE_HX table that was replaced by a new dispense. The initiating dispense that caused the replacement.
ORIG_DISPENSE_HX_ID DOUBLE N The very first dispense that got replaced in a chain of replaced dispenses.
PRSNL_ID DOUBLE N The personnel who prompted the dispense to be replaced.
REPLACE_DISPENSE_HX_ID DOUBLE N The DISPENSE_HX_ID of the dispense from the DISPENSE_HX table that was created to replace the previous 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.



Relationship Detail - DISPENSE_REPLACE


Child Column in DISPENSE_REPLACE(FK) Parent Table Name Parent Column Name
Parents: INIT_DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID
ORIG_DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID
REPLACE_DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID
PRSNL_ID PRSNL PERSON_ID