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 |