Table Detail Report

PI_LEAFLET



Column Section Relationship Section Top of Page


Table-level Detail

Description: Patient information leaflet
Definition: patient information leaflet
Table Type: REFERENCE





Column Detail - PI_LEAFLET


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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
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.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
LANGUAGE_CD DOUBLE N Language code (i.e. English, spanish, etc.)
LONG_TEXT_ID DOUBLE N the long text id for the long text table
NOMENCLATURE_ID DOUBLE N nomenclature id
PI_LEAFLET_ID DOUBLE N pi leaflet id
PRINT_TYPE_FLAG DOUBLE Y print type flag
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 - PI_LEAFLET


Child Column in PI_LEAFLET(FK) Parent Table Name Parent Column Name
Parents: NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID


PRICE_CODE_EXCEPTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: PRICE CODE EXCEPTION
Definition: Price Code Exception - Stores Price schedule exceptions for default price code.
Table Type: REFERENCE





Column Detail - PRICE_CODE_EXCEPTION


Column Name Type Null? Definition
COPAY_PRICE_SCHED_ID DOUBLE N Indicates default Price schedule for copay. Key of Price Schedule table.
EXCEPTION_TYPE_CD DOUBLE N Indicates type of exception (such as Generic, Brand, Ther. Class, Drug Id)
FLEXED_TO_PRICE_CODE_CD DOUBLE N Allows flexing the price code. Currently it can be flexed by location.
PARENT_ENTITY VARCHAR(32) Y Data source for each exception type. Related to column parent_entity_id.
PARENT_ENTITY_ID DOUBLE N Value of key field for the table named in column parent_entity.
PRICE_CODE_CD DOUBLE N This is the price code that is being flexed. A price code is a pointer to a group of price schedules, which are the formula used to calculate the price charged for a product when it is ordered.
PRICE_CODE_EXCEPTION_ID DOUBLE N Unique, generated key for the PRICE_CODE_EXCEPTION table.
PRICE_SCHED_ID DOUBLE N Indicates Price schedule for exception type. Key of Price Schedule table.
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.
VALUE VARCHAR(200) Y Used when parent_entity is a free text value (not from a table). Currently, only exception type of "DRUGID" uses this field and will contain the NDC identifier of the Drug.
VALUE_KEY VARCHAR(200) Y Same as Value without special characters and is converted to upper case.



Relationship Detail - PRICE_CODE_EXCEPTION


Child Column in PRICE_CODE_EXCEPTION(FK) Parent Table Name Parent Column Name
Parents: COPAY_PRICE_SCHED_ID PRICE_SCHED PRICE_SCHED_ID
PRICE_SCHED_ID PRICE_SCHED PRICE_SCHED_ID


PROD_DISPENSE_HX



Column Section Relationship Section Top of Page


Table-level Detail

Description: prod_dispense_hx
Definition: For the pharmacy orders dispensed, store the products associated with the dispensing event
Table Type: ACTIVITY





Column Detail - PROD_DISPENSE_HX


Column Name Type Null? Definition
AVAILABLE_WASTE_CHARGE_QTY DOUBLE Y Amount of product remaining which is available to waste and will be charged for.
AVAILABLE_WASTE_QTY DOUBLE Y Amount of product remaining which is available to waste.
CHARGE_IND DOUBLE Y the charge indicator
CHARGE_QTY DOUBLE Y Amounts based on product unit (i.e. mg) to charge for. Rounded to 4 digits.
COMPOUND_FLAG DOUBLE Y Compound flag0 - normal; 1 -premix; 2 - compound
COST DOUBLE Y Cost associated with the dispense event
CREDIT_QTY DOUBLE Y Amounts based on product unit (i.e. mg) to credit
DISPENSE_HX_ID DOUBLE N Identifier for the dispense history
DISPENSE_QTY DOUBLE Y the dispense quantity
DOSE_QTY DOUBLE Y Product's quantity per dose after rounding for the product dispense.
INGRED_SEQUENCE DOUBLE N Identifier for the ingredient
ITEM_ID DOUBLE N Reference to the medication definition pharmacy product
MANF_ITEM_ID DOUBLE N Manufacturer item_id dispensed
MAX_WASTE_CHARGE_QTY DOUBLE Y Maximum amount of product that could have been charged for.
MAX_WASTE_QTY DOUBLE Y Maximum amount of product that could have been entered as waste.
MED_PRODUCT_ID DOUBLE N Stores unique field for NDC
PACKAGE_TYPE_ID DOUBLE N the Package type id
PARENT_PRODUCT_SEQ DOUBLE Y For child products of a compound, this points to the parent order_product.
PRICE DOUBLE Y Calculated price associated with the dispense event
PRICE_SCHED_ID DOUBLE N This is the price schedule Id used to determine charge/credit amounts
PRODUCT_SEQ DOUBLE Y Unique sequence for each order_product row.
PROD_DISPENSE_HX_ID DOUBLE N Unique, generated identifier for a product on a dispense event.
RESIDUAL_COST_AMT DOUBLE Y Cost for the Per Unit Residual Quantity
RESIDUAL_PRICE DOUBLE N The price needing to be charged after the reverse transaction was placed.
RESIDUAL_QTY DOUBLE N The quantity needing to be charged after the reverse transaction was placed.
RESIDUAL_TAX_AMT DOUBLE N The tax amount needing to be charged after the reverse transaction was placed.
SCAN_FLAG DOUBLE N Used to determine whether the product was scanned in during charge on administration. (0 = not scanned, 1 = scanned)
TAX_AMT DOUBLE N Identifies the tax amount.
TNF_ID DOUBLE N Key to template_non-formulary table
UNROUNDED_CHARGE_QTY DOUBLE Y Amounts based on product unit (i.e. mg) to charge for
UNROUNDED_CREDIT_QTY DOUBLE Y Amount based on product unit (i.e. mg) to credit.
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.
WASTE_FLAG DOUBLE Y Indicates this dispense event can have waste applied.
WASTE_OFFSET_IND DOUBLE Y Indicates this dispense will require offset financial credits/charges whenever waste charges and waste credits happen.
WASTE_QTY DOUBLE Y Amount wasted for this dipsense.
ZERO_WASTE_FLAG DOUBLE Y Used to determine if a product is waste bill eligible but has zero amount wasted as part of the dispense.



Relationship Detail - PROD_DISPENSE_HX


Child Column in PROD_DISPENSE_HX(FK) Parent Table Name Parent Column Name
Parents: DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID
ITEM_ID ITEM_DEFINITION ITEM_ID
MANF_ITEM_ID ITEM_DEFINITION ITEM_ID
MED_PRODUCT_ID MED_PRODUCT MED_PRODUCT_ID
PACKAGE_TYPE_ID PACKAGE_TYPE PACKAGE_TYPE_ID
PRICE_SCHED_ID PRICE_SCHED PRICE_SCHED_ID


RXA_HP_CLAIM_EXCEPTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: PharmNet Ambulatory Health Plan Claim Exception
Definition: Stores the list of items excluded from claiming for a particular health plan.
Table Type: REFERENCE





Column Detail - RXA_HP_CLAIM_EXCEPTION


Column Name Type Null? Definition
EXCEPTION_TYPE_CD DOUBLE N A generalization of the type of exception. DRUG is one value.
HEALTH_PLAN_ID DOUBLE N The health plan that this exclusion applies to.
PARENT_ENTITY_ID DOUBLE N The item that needs to be excluded while considering the health plan.
PARENT_ENTITY_NAME VARCHAR(30) N Data source for each exception type. Related to column parent_entity_id.
RXA_HP_CLAIM_EXCEPTION_ID DOUBLE N Unique generated number that identifies a single row on the RXA_HP_CLAIM_EXCEPTION table.
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 - RXA_HP_CLAIM_EXCEPTION


Child Column in RXA_HP_CLAIM_EXCEPTION(FK) Parent Table Name Parent Column Name
Parents: HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID


RXA_MED_COPAY_TIER_HX



Column Section Relationship Section Top of Page


Table-level Detail

Description: PharmNet Ambulatory Medication Copay Tier History
Definition: To add and track copay tier value(s) for a product
Table Type: REFERENCE





Column Detail - RXA_MED_COPAY_TIER_HX


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.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
COPAY_TIER_CD DOUBLE N The copay tier that is applicable for the item_id.
COPAY_TIER_TZ DOUBLE N Stores the time zone of copay tier information
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
ITEM_ID DOUBLE N The item that participates in this copay tier.
RXA_MED_COPAY_TIER_HX_ID DOUBLE N Unique generated number that identifies a single row on the RXA_MED_COPAY_TIER_HX table.
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 - RXA_MED_COPAY_TIER_HX


Child Column in RXA_MED_COPAY_TIER_HX(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID MEDICATION_DEFINITION ITEM_ID