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 |