Table Detail Report

PHA_FLEX



Column Section Relationship Section Top of Page


Table-level Detail

Description: PHA_FLEX
Definition: The PHA_FLEX table stores the relationships of various flexed entities by location (ie Facility, Nurse Unit, etc.).
Table Type: REFERENCE





Column Detail - PHA_FLEX


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.
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.
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.
FINANCIAL_CLASS_CD DOUBLE N How the reference entity is further flexed to the financial class of the patient.
FLEX_ENTITY_ID DOUBLE N Identifies how ref_entity_id is flexed. (i.e. Facility, Nurse Unit, etc.)
FLEX_ENTITY_NAME VARCHAR(32) N Flex_entity_id filename.
FUNDING_SOURCE_CD DOUBLE N Describes the entity providing funding to purchase a pharmaceutical product.
NEW_ENTITY_ID DOUBLE N Identifies new code value or field id that is the result of flexing the ref_entity_id by the flex field identified in flex_entity_id.
NEW_ENTITY_NAME VARCHAR(32) N New_entity_id filename.
PHARM_TYPE_CD DOUBLE N Pharmacy Type Cd
PHA_FLEX_ID DOUBLE N This is the value of the unique primary identifier of the pha_flex table. It is an internal system assigned number.
REF_ENTITY_ID DOUBLE N Identifies reference code value or field id that will be changed.
REF_ENTITY_NAME VARCHAR(32) N Ref_entity_id filename.
SUB_FLEX_ENTITY_ID DOUBLE N Identifies how the REFERENCE ENTITY is further flexed, i.e., ENCOUNTER_TYPE_CD.
SUB_FLEX_ENTITY_NAME VARCHAR(30) N Identifies how the REFERENCE ENTITY is further flexed, i.e., ENCOUNTER_TYPE_CD.
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 - PHA_FLEX


Child Column in PHA_FLEX(FK) Parent Table Name Parent Column Name
Parents: FINANCIAL_CLASS_CD CODE_VALUE CODE_VALUE


PHA_ORD_ACT_OBS_ST



Column Section Relationship Section Top of Page


Table-level Detail

Description: pha_ord_act_obs_st
Definition: Observation set of PharmNet's activity data at the order dispense level. Used to generate workload reports.
Table Type: ACTIVITY





Column Detail - PHA_ORD_ACT_OBS_ST


Column Name Type Null? Definition
ACTION_DT_NBR DOUBLE Y the Julian value of the action date of an order
ACTION_DT_TM DATETIME Y the action date/time of an order
ACTION_MIN_NBR DOUBLE Y the time value in minutes of the action time of an order
ACTION_PRSNL_ID DOUBLE N the personnel identifier of the user performing the action
ACTION_QUAL_CD DOUBLE Y A codified value that helps describe the action that occurred.
ACTION_REJECTED_IND DOUBLE Y indicates whether the action performed is a reject
ACTION_SEQ DOUBLE N sequence of the action
ACTION_TYPE_CD DOUBLE N Action that is requested
ACT_SHIFT_GRP2_CD DOUBLE N Shifts for Pharmacy
ACT_SHIFT_GRP_CD DOUBLE N Shifts for Pharmacy
CANCEL_REASON_CD DOUBLE N reason that an action was cancelled
CKI VARCHAR(255) Y CKI value
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.
COSIGN_OVERRIDE_OPTION_CD DOUBLE N Determines if Physician Cosign is required for external order entry systems.
COSIGN_OVERRIDE_REASON_CD DOUBLE N The reason Physician Cosign has been overridden from the system determined value.
COST DOUBLE Y Order Cost
CUR_DEPT_STATUS_CD DOUBLE N current departmental status code of an order
CUR_ORDER_STATUS_CD DOUBLE N ** OBSOLETE - NO LONGER USED **cur_order_status_cd
CUR_START_DT_NBR DOUBLE Y the Julian value of the start date of an order
CUR_START_DT_TM DATETIME Y The start dt/tm of this order
CUR_START_MIN_NBR DOUBLE Y the time value in minutes of the start time of an order
CUR_START_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
DAW_CD DOUBLE N dispense as written code
DAY_OF_TREATMENT_IND DOUBLE N Indicates if this order is a day of treatment order.
DC_REASON_CD DOUBLE N reason that an order was discontinued
DEPT_MISC_LINE VARCHAR(255) Y text filled by department
DEPT_STATUS_CD DOUBLE N departmental status of the order
DISCONTINUE_EFF_DT_NBR DOUBLE Y the Julian value of the discontinue date of an order
DISCONTINUE_EFF_DT_TM DATETIME Y date and time the discontinue action should become effective for the order
DISCONTINUE_EFF_MIN_NBR DOUBLE Y the time value in minutes of the discontinue time
DISCONTINUE_EFF_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
DISCONTINUE_IND DOUBLE Y indicator on whether this order has been discontinued
DISCONTINUE_TYPE_CD DOUBLE N Code set 4038: Indicates what method the order was discontinued
DISP_CATEGORY_CD DOUBLE N Code set 4008: Indicates the method to calculate dispense doses and charging method
DISP_FROM_LOC_CD DOUBLE N Code set 220: the location the order is to dispense from
DISP_FROM_SR_CD DOUBLE N Code set 221: the service resource code value that is associated to the dispense from location
DISP_PRIORITY_CD DOUBLE N Code set 4513: the dispense priority of an order
EFFECTIVE_DT_NBR DOUBLE Y Effective Date Number value
EFFECTIVE_DT_TM DATETIME Y Effective Date and Time value
EFFECTIVE_MIN_NBR DOUBLE Y Effective Minute number value
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
EXPIRE_DT_NBR DOUBLE Y the Julian value of the expire date of the order
EXPIRE_DT_TM DATETIME Y expire date and time value
EXPIRE_MIN_NBR DOUBLE Y the time value in minutes of the expire time of an order
EXPIRE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
FILL_NBR DOUBLE Y Indicates the Fill Number that is being filled out of the total available fills.
FLOORSTOCK_IND DOUBLE Y indicates if the order is dispensed from the floor
FLOORSTOCK_OVERRIDE_IND DOUBLE Y indicates if the user has changed the dispense from location to a floorstock (1) or non-floorstock location (2)
FREQ_CD DOUBLE N code value of the frequency associated to order
FUTURE_LOC_FACILITY_CD DOUBLE N Pharmacy future facility
FUTURE_LOC_NURSE_UNIT_CD DOUBLE N Pharmacy future nurse unit
HEALTH_PLAN_ID DOUBLE N health_plan_id
ICD9_NOMEN_ID DOUBLE N Diagnosis Nomenclature Identifier
IGNORE_IND DOUBLE Y used to temporarily mark an order to not qualify on the fill list; 1 = ignore, 0 = fill as instructed
INACTIVE_FLAG DOUBLE Y inactive_flag
INCOMPLETE_ORDER_IND DOUBLE Y indicates the order is missing required details
INGREDIENT_IND DOUBLE N an indicator on whether this order has multiple ingredients.
LAST_FILL_STATUS_CD DOUBLE N Order status when the last fill was run. From the Order_dispense table.
LAST_REFILL_DT_NBR DOUBLE Y the Julian date of when the order was last refilled
LAST_REFILL_DT_TM DATETIME Y the date and time of when the order was last refilled
LAST_REFILL_MIN_NBR DOUBLE Y the time in minutes of when the order was last refilled
LAST_REFILL_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
LAST_UPDT_PROVIDER_ID DOUBLE N the personnel identifier of the provider that last updated the order
LEGAL_STATUS_CD DOUBLE N Legal Status Code value
MED_ORDER_TYPE_CD DOUBLE N the medication order type code value of the order
MED_SERVICE_CD DOUBLE N The type or category of medical service that the patient is receiving in relation to their encounter. The category may be of treatment type, surgery, general resources, or others.
NEED_RX_CLIN_REVIEW_FLAG DOUBLE Y Flag for identifying whether the order's clinical review has been completed or not.
NEED_RX_PROD_ASSIGN_FLAG DOUBLE Y Flag for identifying whether the order's product assignment has been completed or not.
NEED_RX_VERIFY_IND DOUBLE Y indicates if the order needs verification from pharmacist
NEED_VERIFY_IND DOUBLE Y indicates if the order has been verified
ORDERABLE_TYPE_FLAG DOUBLE Y indicates what type of orderable procedure the item has been assigned
ORDERING_PROVIDER_ID DOUBLE N the personnel id of the provider of the order
ORDER_CATALOG_CD DOUBLE N The order catalog code value for this medication
ORDER_CATALOG_TYPE_CD DOUBLE N A grouping mechanism to bring order catalogs together.
ORDER_ID DOUBLE N Order Id from the orders table
ORDER_INCOMP_ORDER_IND DOUBLE Y indicates if a required detail is missing on an order
ORDER_LOC_CD DOUBLE N The order location of this action.
ORDER_PRIORITY_CD DOUBLE N Taken from order_detail. Values from code set 4010.
ORDER_STATUS_CD DOUBLE N Order status code value such as 'CANCELED' and 'COMPLETED'.
ORDER_TYPE_FLAG DOUBLE Y The medication order type of the order.
ORD_PERS_AGE_DAYS DOUBLE Y number of days a person's age is
ORD_PERS_AGE_YEARS DOUBLE Y number of years a person's age is
ORD_PERS_BED_CD DOUBLE N The bed code value of the patient's location.
ORD_PERS_BLD_CD DOUBLE N The building code value of the patient's location.
ORD_PERS_FAC_CD DOUBLE N The facility Code value of the patient's location.
ORD_PERS_NU_CD DOUBLE N The Nurse Unit code value of the patient's location.
ORD_PERS_NU_GRP2_CD DOUBLE N The nurse unit grouping code
ORD_PERS_NU_GRP_CD DOUBLE N Grouping of nurse unit the person was located at the time of the order
ORD_PERS_ROOM_CD DOUBLE N The room code value of the patient's location.
ORD_PERS_ZIP VARCHAR(25) Y the zip code of the patient's address
ORGANIZATION_ID DOUBLE N organization_id
ORIG_ORDER_DT_NBR DOUBLE Y The Julian value of the order date.
ORIG_ORDER_DT_TM DATETIME Y the date time the order was created
ORIG_ORDER_MIN_NBR DOUBLE Y the time value of the order time in minutes
ORIG_ORDER_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
ORIG_ORD_AS_FLAG DOUBLE N the flag show how this order was originally placed.
PAR_DOSES DOUBLE Y the PRN or PAR doses of an order
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PERSON_OWN_MEDS_IND DOUBLE N Indicates that the patient brought in their own supply of the medication.
PHARM_ORDER_TYPE_FLAG DOUBLE Y Identifies the type of order that is placed in phamedmgr (medication, continuous, intermittent)
PHARM_TYPE_CD DOUBLE N The pharmacy type cd
PHYSICIAN_DEA_TXT VARCHAR(200) Y DEA number of the prescribing physician
PRICE DOUBLE Y Order Price
PRICE_CODE_CD DOUBLE N the price schedule associated to an order
PRN_IND DOUBLE Y indicates if the order is PRN
PROJECTED_STOP_DT_NBR DOUBLE Y the Julian date of the order's stop date
PROJECTED_STOP_DT_TM DATETIME Y the stop date/time of an order
PROJECTED_STOP_MIN_NBR DOUBLE Y the time value of the order's stop time in minutes
PROJECTED_STOP_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
QTY_REMAINING DOUBLE Y Contains the remaining quantity of the order.
REFILLS_REMAINING DOUBLE Y refills_remaining
REFILL_QTY DOUBLE Y the amount to refill for a retail order
RENEW_REASON_CD DOUBLE N the reason a renew action occurred
REPLACE_EVERY DOUBLE Y the replace every value of an order
REPLACE_EVERY_CD DOUBLE N the unit of measure for the replace every value of an order
REQ_START_DT_NBR DOUBLE Y the Julian date of an order's requested start
REQ_START_DT_TM DATETIME Y the requested start date/time of an order
REQ_START_MIN_NBR DOUBLE Y the time value in minutes for an order's start time
REQ_START_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
RESUME_DT_NBR DOUBLE Y the Julian date of an order's resume action
RESUME_DT_TM DATETIME Y the date/time of an order's resume action
RESUME_EFF_DT_NBR DOUBLE Y the Julian date of an order's effective resume action date
RESUME_EFF_DT_TM DATETIME Y the date/time of an order's effective resume action date/time
RESUME_EFF_MIN_NBR DOUBLE Y the time value in minutes of an order's effective resume action time
RESUME_EFF_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
RESUME_MIN_NBR DOUBLE Y the time value in minutes of an order's resume action
RESUME_REASON_CD DOUBLE N the reason a resume action occurs
RESUME_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
RXA_BACKWARD_ORDER_ID DOUBLE Y Indicates the order based on which the current order was placed
RXA_COB_FLAG DOUBLE Y Indicates whether co-ordination of benefits was used in claiming this fill 0, "None", 1,"Non-COB", 2,"COB"
RXA_CONTROL_NBR_TXT VARCHAR(250) Y Control number for the script
RXA_DAYS_SUPPLY DOUBLE Y Indicates the days for which the current fill will last
RXA_DISP_PRIORITY_DT_TM DATETIME Y Priority Date/Time for the dispense
RXA_DISP_PRIORITY_DT_TZ DOUBLE Y Priority Date/Time Zone for the dispense
RXA_DISP_QTY_UNIT_CD DOUBLE Y Quantity Unit dispensed for the fill
RXA_EXPANDED_SIG_ID DOUBLE Y Order comment of type PHARMSIG. Long Text ID from the LONG_TEXT table.
RXA_FILL_DEVICE_SR_CD DOUBLE Y To store the pharmacy filling device value.
RXA_FILL_LOCATION_SR_CD DOUBLE Y To store the pharmacy filling location value
RXA_FORWARD_ORDER_ID DOUBLE Y Indicates the order that was placed based off of the current order
RXA_HEALTH_PLAN_SEQ DOUBLE Y The sequence of the last health plan in the list of health plans used for this prescription
RXA_PARENT_ORDER_ID DOUBLE Y This field contains the order_id of the prescription placed in easy script that was used to create the current order.
RXA_PARENT_ORIG_ORD_AS_FLAG DOUBLE N To store the parent order orig_ord_as_flag value
RXA_PF_TYPE_CD DOUBLE Y Indicates if a health plan supports NCPDP 51 partial fill submission process.
RXA_PRICE_SCHED_ID DOUBLE Y Indicates the price schedule used for the fill
RXA_PROXY_PRESCRIBER_ID DOUBLE Y Indicates the proxy prescriber of the order
RXA_REVIEWED_PARENT_ACTION_SEQ DOUBLE Y This field contains the action sequence of the parent order that was reviewed by the user that performed the latest fill on the current order.
RXA_SCRIPT_ORIGIN_CD DOUBLE Y Indicates how the script originated
RXA_SOURCE_PARENT_ACTION_SEQ DOUBLE Y This field contains the action sequence of the parent order that was used as the source to create the current order.
RXA_TOTAL_REFILLS DOUBLE Y Total refills authorized for the prescription
RXA_TRANSFER_FLAG DOUBLE Y Indicates the type of transfer performed on the order. 0, "None",1, "Internal Transfer-in", 2,"External Transfer-in",3,"External Transfer-out"
RX_DISP_QTY DOUBLE Y The retail quantity dispensed
RX_EXPIRE_DT_NBR DOUBLE Y the Julian date of an order's expire date
RX_EXPIRE_DT_TM DATETIME Y the date/time of an order's expire date/time
RX_EXPIRE_MIN_NBR DOUBLE Y the time value in minutes of an order's expire time
RX_EXPIRE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
RX_MASK DOUBLE Y pharmacy mask showing how this order was placed
RX_NBR DOUBLE Y retail number
RX_NBR_CD DOUBLE N Prescription number
RX_NBR_STR VARCHAR(100) Y rx_nbr_st
RX_PAY_METHOD_CD DOUBLE N The retail payment method.
RX_QTY DOUBLE Y Intial Quantity Prescribed
RX_ROUTE_CD DOUBLE N the pharmacy route associated to an order
SERVICE_CATEGORY_CD DOUBLE N Codified field, which identifies the current category of service the patient is receiving for this encounter.
SIG VARCHAR(255) Y dosing and administering instructions
SOFT_STOP_DT_NBR DOUBLE Y the Julian date of an order's soft stop date
SOFT_STOP_DT_TM DATETIME Y the stop date/time of an order's soft stop
SOFT_STOP_MIN_NBR DOUBLE Y the time value in minutes for an order's soft stop time
SOFT_STOP_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
STATUS_PRSNL_ID DOUBLE N Id of the prsnl row that updated the status.
STOP_DT_NBR DOUBLE Y the Julian date of an order's stop date
STOP_DT_TM DATETIME Y the stop date/time of an order
STOP_MIN_NBR DOUBLE Y the time value in minutes of an order's stop time
STOP_TYPE_CD DOUBLE N the stop type policy of an order
STOP_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
STRENGTH_DOSE DOUBLE Y the strength of an order
STRENGTH_DOSE_UNIT_CD DOUBLE N the strength unit of measure of an order
SUSPEND_DT_NBR DOUBLE Y the Julian date of an order's suspend
SUSPEND_DT_TM DATETIME Y the date/time of an order's suspend action
SUSPEND_EFF_DT_NBR DOUBLE Y the Julian date of an order's effective suspend action
SUSPEND_EFF_DT_TM DATETIME Y the date/time of an order's effective suspend action
SUSPEND_EFF_MIN_NBR DOUBLE Y the time value in minutes of an order's effective suspend time
SUSPEND_EFF_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
SUSPEND_IND DOUBLE Y indicates if the order is suspended
SUSPEND_MIN_NBR DOUBLE Y the time value in minutes of an order's suspend time
SUSPEND_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
SYNONYM_ID DOUBLE N The synonym_id from the order_catalog_synonym table.
TOTAL_RX_QTY DOUBLE Y Total Quantity Prescribed
TRANSFER_CNT DOUBLE Y The number of times a prescription got transferred
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 - PHA_ORD_ACT_OBS_ST


Child Column in PHA_ORD_ACT_OBS_ST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
FUTURE_LOC_FACILITY_CD LOCATION LOCATION_CD
FUTURE_LOC_NURSE_UNIT_CD LOCATION LOCATION_CD
ICD9_NOMEN_ID NOMENCLATURE NOMENCLATURE_ID
ORDER_ID ORDERS ORDER_ID
SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID


PHA_PRODUCT



Column Section Top of Page


Table-level Detail

Description: Pharmacy Product
Definition: Table is created by batch update process and formulary listing process to allow selection by dynamic criteria. Also used to generate formulary export spreadsheet.
Table Type: REFERENCE





Column Detail - PHA_PRODUCT


Column Name Type Null? Definition
AHFS_CODE VARCHAR(6) Y Therapeutic Class string
ALTERNATE_DISPENSE_CATEGORY_CD DOUBLE N Alternate Dispense Category for this product
ALT_SEL_CATEGORY_ID DOUBLE N alt_sel_category id associated with ahfs_code
AWP DOUBLE Y Average Wholesale price
AWP_FACTOR DOUBLE Y Same as dispense factor, this is greater than 0 if there's a different unit of measure specified for dispense quantity than specified for base unit of measure.
BASE_ISSUE_FACTOR DOUBLE Y Ratio identifying smallest unit of issue for pharmacy product
BASE_PACKAGE_SIZE DOUBLE Y Size of smallest dispensible unit
BASE_PACKAGE_UNIT_CD DOUBLE N Unit of measure code_value for smallest dispensible unit
BRAND_NAME VARCHAR(100) Y Manufacturer brand/trade name for the product
BRAND_NAME2 VARCHAR(100) Y Second manufacturer brand/trade name for the product
BRAND_NAME2_PRIMARY DOUBLE Y Identifies if Brand Name 2 is primary. 0 = not primary, 1 = primary.
BRAND_NAME3 VARCHAR(100) Y Third manufacturer brand/trade name for the product
BRAND_NAME3_PRIMARY DOUBLE Y Identifies if Brand Name 3 is primary. 0 = not primary, 1 = primary.
BRAND_NAME_KEY VARCHAR(100) Y Uppercase manufacturer brand/trade name - used for sorting on the report
BRAND_NAME_PRIMARY DOUBLE Y Identifies if Brand Name is primary. 0 = not primary, 1 = primary.
CATALOG_CD DOUBLE N Order Catalog code associated with product
CDM VARCHAR(30) Y Charge Description Master Identifier String
COMMENT1_ID DOUBLE N ID for dispenseing Comment 1
COMMENT1_TEXT VARCHAR(255) Y Text of Comment1
COMMENT1_TYPE DOUBLE Y Determines whether note appears of label, MAR of Fill List
COMMENT2_ID DOUBLE N ID For 2nd Dispensing comment
COMMENT2_TEXT VARCHAR(255) Y Text of Comment2
COMMENT2_TYPE DOUBLE Y Identifies whether comment should appear on label, mar or fill
COMPOUND_TEXT VARCHAR(255) Y Text of compounding instructions
COMPOUND_TEXT_ID DOUBLE N ID for compounding Instructions
CONTINUOUS_FILTER_IND DOUBLE Y Used to indicate product should appear on product selection lists including continuous order products
COST1 DOUBLE Y Primary cost associated with product
COST2 DOUBLE Y Secondary cost associated with product
DC_DISPLAY_DAYS DOUBLE Y number of days to display the product in the patients profile after the product has been discontinued.
DC_INTERACTION_DAYS DOUBLE Y Number of days drug stays active in patients body for interaction checking
DEFAULT_PAR_DOSES DOUBLE Y Number of doses to default for PRN orders
DEF_DURUNIT_ID DOUBLE N Order Entry Field containing the Default Duration Units
DEF_DURUNIT_MEAN DOUBLE Y Order Entry Field meaning for default duration units
DEF_DURUNIT_NEW DOUBLE Y New value for default duration units - only valued during batch update process
DEF_DURUNIT_VAL DOUBLE Y Present code_value for default duration units.
DEF_DUR_ID DOUBLE N Order entry field id for default duration
DEF_DUR_MEAN DOUBLE Y Order Entry Field meaning for default duration
DEF_DUR_NEW DOUBLE Y New value for default duration - only valued during batch update process
DEF_DUR_VAL DOUBLE Y Present value for default duration.
DEF_FREQ_ID DOUBLE N order entry field containing default frequency
DEF_FREQ_MEAN DOUBLE Y Order entry field meaning for default frequency
DEF_FREQ_NEW DOUBLE Y New value for default frequency - only valued during batch update process
DEF_FREQ_VAL DOUBLE Y Present code value for default frequency
DEF_FTDOSE_ID DOUBLE N Order Entry default for free text dose
DEF_FTDOSE_MEAN DOUBLE Y Order entry field meaning for free text dose
DEF_FTDOSE_NEW VARCHAR(100) Y New Value for free text dose - used in bactch update mode
DEF_FTDOSE_VAL VARCHAR(100) Y Value for free text dose
DEF_PRN_ID DOUBLE N Order entry default for SCH/PRN indicator
DEF_PRN_MEAN DOUBLE Y OE field meaning ID for sch/PRN incidicator
DEF_PRN_VAL DOUBLE Y Value of sch/prn indicator
DEF_ROUTE_ID DOUBLE N order entry field containing default route_cd
DEF_ROUTE_MEAN DOUBLE Y Order entry field meaning for default route
DEF_ROUTE_NEW DOUBLE Y New code value for default route - only valued during batch update process
DEF_ROUTE_VAL DOUBLE Y Present code_value for default route.
DEF_STOP_ID DOUBLE N order entry field containing default stop type code_value
DEF_STOP_MEAN DOUBLE Y Order entry field meaning for default stop type
DEF_STOP_NEW DOUBLE Y New code value for default stop type- only valued during batch update process
DEF_STOP_VAL DOUBLE Y Present code_value for default stop type
DEF_STRUNIT_ID DOUBLE N order entry field containing default strength units code_value
DEF_STRUNIT_MEAN DOUBLE Y Order entry field meaning for default strength units
DEF_STRUNIT_NEW DOUBLE Y New code value for default strength units - only valued during batch update process
DEF_STRUNIT_VAL DOUBLE Y Present code_value for default strength units
DEF_STR_ID DOUBLE N order entry field containing default strength
DEF_STR_MEAN DOUBLE Y Order entry field meaning for default strength
DEF_STR_NEW DOUBLE Y New value for default strength - only valued during batch update process
DEF_STR_VAL DOUBLE Y Present value for default strength
DEF_VOLUNIT_ID DOUBLE N order entry field containing default volume units
DEF_VOLUNIT_MEAN DOUBLE Y Order entry field meaning for default volume units
DEF_VOLUNIT_NEW DOUBLE Y New code value for default volume units - only valued during batch update process
DEF_VOLUNIT_VAL DOUBLE Y Present code_value for default volume units
DEF_VOL_ID DOUBLE N order entry field containing default volume
DEF_VOL_MEAN DOUBLE Y Order entry field meaning for default volume
DEF_VOL_NEW DOUBLE Y New value for default volume - only valued during batch update process
DEF_VOL_VAL DOUBLE Y Present value for default volume
DILUENT_ID DOUBLE N Item Id for default diluent - presently not used
DILUENT_VOLUME DOUBLE Y Volume for default diluent - presently not used
DISPENSE_CATEGORY_CD DOUBLE N Primary dispense category cd for product
DISPENSE_FROM_FLAG DOUBLE Y Identify where a medication is dispensed from
DISPENSE_QTY DOUBLE Y Amount to be dispensed
DISPENSE_QTY_UNIT_CD DOUBLE N Unit of measure for dispense amount
DIVISIBLE_IND DOUBLE Y Indicates the product can be divided into smaller units
FAC_ALL DOUBLE Y Indicates whether product is for all facilities or not. 0 = not, 1 = all facilities.
FAC_CERN1 DOUBLE Y multi facitliy logic
FAC_CERN10 DOUBLE Y multi facitliy logic
FAC_CERN11 DOUBLE Y multi facitliy logic
FAC_CERN12 DOUBLE Y multi facitliy logic
FAC_CERN13 DOUBLE Y multi facitliy logic
FAC_CERN14 DOUBLE Y multi facitliy logic
FAC_CERN15 DOUBLE Y multi facitliy logic
FAC_CERN16 DOUBLE Y multi facitliy logic
FAC_CERN17 DOUBLE Y multi facitliy logic
FAC_CERN18 DOUBLE Y multi facitliy logic
FAC_CERN19 DOUBLE Y multi facitliy logic
FAC_CERN2 DOUBLE Y multi facitliy logic
FAC_CERN20 DOUBLE Y multi facitliy logic
FAC_CERN21 DOUBLE Y multi facitliy logic
FAC_CERN22 DOUBLE Y multi facitliy logic
FAC_CERN23 DOUBLE Y multi facitliy logic
FAC_CERN24 DOUBLE Y multi facitliy logic
FAC_CERN25 DOUBLE Y multi facitliy logic
FAC_CERN26 DOUBLE Y multi facitliy logic
FAC_CERN27 DOUBLE Y multi facitliy logic
FAC_CERN28 DOUBLE Y multi facitliy logic
FAC_CERN29 DOUBLE Y multi facitliy logic
FAC_CERN3 DOUBLE Y multi facitliy logic
FAC_CERN30 DOUBLE Y multi facitliy logic
FAC_CERN4 DOUBLE Y multi facitliy logic
FAC_CERN5 DOUBLE Y multi facitliy logic
FAC_CERN6 DOUBLE Y multi facitliy logic
FAC_CERN7 DOUBLE Y multi facitliy logic
FAC_CERN8 DOUBLE Y multi facitliy logic
FAC_CERN9 DOUBLE Y multi facitliy logic
FORMULARY_STATUS_CD DOUBLE N Indicates whether a product is approved for ordering, dispensing and adminstering to a patient by the organization or benefits manager
FORM_CD DOUBLE N The dosage form the product is supplied in .
GCR_CKI VARCHAR(100) Y Cerner knowledge index value for generic cross reference. CKI is MUL.DRUG!
GCR_CODE VARCHAR(6) Y Generic Cross Reference code as defined by Medical economics (Redbook/Micromedex) - NO LONGER IN ACTIVE USE
GCR_DESC VARCHAR(255) Y Generic Cross reference description
GENERIC_NAME VARCHAR(100) Y Generic name for the product
GENERIC_NAME_KEY VARCHAR(100) Y All uppercase generic name for the product. Used for sorting the reports
GEN_LEDGER_ACCT_CODE VARCHAR(50) Y General Ledger Account Code
GFC_CKI VARCHAR(100) Y Cerner Knoweldge Index for generic formulation as defined by Multum. CKI is MUL.FRMLTN!
GFC_CODE VARCHAR(6) Y Generic Formulation Code as defined by Medical Economics (Redbook/Micromedex) - NO LONGER IN ACTIVE USE
GFC_DESC VARCHAR(255) Y Description for Generic Formulation
INFUSE_OVER DOUBLE Y Determines how long to infuse an IV
INFUSE_OVER_UNIT_CD DOUBLE N Unit of measure for Infuse over
ING_SENT_ID DOUBLE N Not in use.
INTERMITTENT_FILTER_IND DOUBLE Y Used to indicate product should appear on product selection lists including intermittent order products
ITEM_ID DOUBLE N Primary Key - Item id for the product
J_CODE VARCHAR(25) Y Not in use.
LABEL_DESC VARCHAR(100) Y Label description for the product.
LABEL_DESC_KEY VARCHAR(100) Y All upper case label description.
LEGAL_STATUS_CD DOUBLE N Legal status assigned by national drug regulatory agencies. (DEA, etc.)
LOC_CD1 DOUBLE Y Location_cd from code set 220.
LOC_CD10 DOUBLE Y Location_cd from code set 220.
LOC_CD11 DOUBLE Y Location_cd from code set 220.
LOC_CD12 DOUBLE Y Location_cd from code set 220.
LOC_CD13 DOUBLE Y Location_cd from code set 220.
LOC_CD14 DOUBLE Y Location_cd from code set 220.
LOC_CD15 DOUBLE Y Location_cd from code set 220.
LOC_CD16 DOUBLE Y Location_cd from code set 220.
LOC_CD17 DOUBLE Y Location_cd from code set 220.
LOC_CD18 DOUBLE Y Location_cd from code set 220.
LOC_CD19 DOUBLE Y Location_cd from code set 220.
LOC_CD2 DOUBLE Y Location_cd from code set 220.
LOC_CD20 DOUBLE Y Location_cd from code set 220.
LOC_CD21 DOUBLE Y Location_cd from code set 220.
LOC_CD22 DOUBLE Y Location_cd from code set 220.
LOC_CD23 DOUBLE Y Location_cd from code set 220.
LOC_CD24 DOUBLE Y Location_cd from code set 220.
LOC_CD25 DOUBLE Y Location_cd from code set 220.
LOC_CD26 DOUBLE Y Location_cd from code set 220.
LOC_CD27 DOUBLE Y Location_cd from code set 220.
LOC_CD28 DOUBLE Y Location_cd from code set 220.
LOC_CD29 DOUBLE Y Location_cd from code set 220.
LOC_CD3 DOUBLE Y Location_cd from code set 220.
LOC_CD30 DOUBLE Y Location_cd from code set 220.
LOC_CD4 DOUBLE Y Location_cd from code set 220.
LOC_CD5 DOUBLE Y Location_cd from code set 220.
LOC_CD6 DOUBLE Y Location_cd from code set 220.
LOC_CD7 DOUBLE Y Location_cd from code set 220.
LOC_CD8 DOUBLE Y Location_cd from code set 220.
LOC_CD9 DOUBLE Y Location_cd from code set 220.
MANF_IDENTIFIER_BRAND VARCHAR(100) Y Brand Name identifier for manufacturer item
MANF_IDENTIFIER_DESC VARCHAR(100) Y Label description for manufacturer item for this product
MANF_IDENTIFIER_GENERIC VARCHAR(100) Y Generic Name for manufacturer item associated with this product
MANF_IDENTIFIER_MNEMONIC VARCHAR(100) Y Order entry mnemonic for manufacturer_item associated with this product
MANF_IDENTIFIER_PYXIS VARCHAR(100) Y PYXIS interface ID for manufacturer_item associated with this product
MANF_IDENTIFIER_UB92 VARCHAR(100) Y UB92 classification code for manufacturer_item associated with this item
MANF_ITEM_ID DOUBLE N Item_ID for manufacturer_item associated with this product
MANF_STATUS DOUBLE Y Is manufacturer_item active
MANUFACTURER_CD DOUBLE N Manufacturer for given product/NDC
MAX_PAR_SUPPLY DOUBLE Y Maximum number of doses to be dispensed in a 24hr period for PRN orders
MDX_GFC_NOMEN_ID DOUBLE N Nomenclature id assigned to the Micromedex generic formulation code for this product.
MED_FILTER_IND DOUBLE Y Used to indicate product should appear on product selection lists including medication order products
MED_TYPE_FLAG DOUBLE Y Flag to indicate the type of order
MEQ_FACTOR DOUBLE Y Factor for determininig ratio for ml equivalents
MMOL_FACTOR DOUBLE Y Factor for ratio to milliimoles
MNEMONIC VARCHAR(50) Y Order entry mnemonic for product
NDC VARCHAR(13) N National Drug Code (US FDA) identifier
NDC_ACTIVE_IND DOUBLE Y Is NDC active for product
NON_RB_IND DOUBLE Y IS item in reference database
OE_FORMAT_FLAG DOUBLE Y Default order Entry Format to display for this product
OE_FORMAT_ID DOUBLE N Order Entry Format for this type of order
ORDER_ALERT1_CD DOUBLE N First order alert for the product
ORDER_ALERT2_CD DOUBLE N Second order alert for the product
ORD_SENT_ID DOUBLE N Order Sentence associated with the product
OS_DISPLAY_LINE VARCHAR(255) Y Denormalized order_sentence display line.
OUTER_QTY DOUBLE Y Outer package quantity from package_type.
OUTER_UOM DOUBLE Y Unit of measure for outer package quantity from code set 54
PRICE_SCHEDULE_ID DOUBLE N Price schedule ID used for billing
PRICE_SCHED_SHORT_DESC VARCHAR(50) Y Text description for price_scjhedule
PRIMARY_IND DOUBLE Y Indicates whether this item_id/ndc combination is the primary choice for dispensing
PRIMARY_MNEMONIC VARCHAR(100) Y Primary Mnemonic used for PowerChart order entry
PRN_IND DOUBLE Y Scheduled/PRN indicator - derived from def_prn_val
PROD_ACTIVE_IND DOUBLE Y IS product acvtive in formulary
PYXIS VARCHAR(30) Y PYXIS interface ID for product.
QTY DOUBLE Y Dispense Quantity
REF_DOSE VARCHAR(25) Y Reference dose, a string value, combination of strength/strength unit and volume/volume unit. Shows up in Given Strength field.
REUSABLE_IND DOUBLE Y Indicates whether this product can be re-used when returned to the pharmacy for credit.
RX_DEVICE1 VARCHAR(100) Y Device code from code set 11000.
RX_DEVICE2 VARCHAR(100) Y Device code from code set 11000.
RX_DEVICE3 VARCHAR(100) Y Device code from code set 11000.
RX_DEVICE4 VARCHAR(100) Y Device code from code set 11000.
RX_DEVICE5 VARCHAR(100) Y Device code value from code set 11000.
RX_MISC1 VARCHAR(100) Y CDF meaning for rx_device1, from code set 11000
RX_MISC2 VARCHAR(100) Y CDF meaning for rx_device2, from code set 11000
RX_MISC3 VARCHAR(100) Y CDF meaning for rx_device3, from code set 11000
RX_MISC4 VARCHAR(100) Y CDF meaning for rx_device4, from code set 11000
RX_MISC5 VARCHAR(100) Y CDF meaning for rx_device5, from code set 11000
RX_MNEMONIC VARCHAR(255) Y Pharmacy mnemonic for this product
SEQUENCE DOUBLE N Internal indicator for set items.
SIDE_EFFECT_CODE VARCHAR(10) Y SIde effect code for adverse reaction charting
STRENGTH DOUBLE Y Given Strength for the product
STRENGTH_UNIT_CD DOUBLE N Given strength units for the product
SYNONYM_ID DOUBLE N The synonym_id for the rx_mnemonic
TEST DOUBLE Y Not in use.
UB92 VARCHAR(30) Y UB92 classification for product
UOM_CD DOUBLE N The unit of measure for the dispense qty
USED_AS_BASE_IND DOUBLE Y Indicates that this product can be used as a base solution for a multi ingredient order
VALID_IV_IND DOUBLE Y Indicates that this item can be used in an IV order
VOLUME DOUBLE Y Given Volume for the product
VOLUME_UNIT_CD DOUBLE N Units of measure for the given volume


PHA_PROD_DISP_OBS_ST



Column Section Relationship Section Top of Page


Table-level Detail

Description: pha_prod_disp_obs_st
Definition: Observation set of PharmNet's activity data at the product dispense level. Used to generate a summary of doses for patients.
Table Type: ACTIVITY





Column Detail - PHA_PROD_DISP_OBS_ST


Column Name Type Null? Definition
ACTION_DT_NBR DOUBLE Y action_dt_nbr column
ACTION_DT_TM DATETIME Y action_dt_tm column
ACTION_MIN_NBR DOUBLE Y action_min_nbr column
ACTION_PRSNL_ID DOUBLE N action_prsnl_id
ACTION_QUAL_CD DOUBLE Y A codified value that helps describe the action that occurred.
ACTION_REJECTED_IND DOUBLE Y action_rejected_ind column
ACTION_SEQ DOUBLE N action_seq column
ACTION_TYPE_CD DOUBLE N Action that is requested
ACTION_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
CANCEL_REASON_CD DOUBLE N cancel_reason_cd column
CHARGE_IND DOUBLE Y charge_ind column
CHARGE_QTY DOUBLE Y charge_qty column
CKI VARCHAR(255) Y CKI value
CONTRIBUTOR_SYSTEM_CD DOUBLE Y 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.
COPAY DOUBLE Y copay value
COSIGN_OVERRIDE_OPTION_CD DOUBLE N Determines if Physician Cosign is required for external order entry systems.
COSIGN_OVERRIDE_REASON_CD DOUBLE N The reason Physician Cosign has been overridden from the system determined value.
COST DOUBLE Y cost column
CREDIT_QTY DOUBLE Y credit_qty column
CUR_DEPT_STATUS_CD DOUBLE N cur_dept_status_cd column
CUR_ORDER_STATUS_CD DOUBLE N ** OBSOLETE - NO LONGER USED **cur_order_status_cd column
CUR_START_DT_NBR DOUBLE Y cur_start_dt_nbr column
CUR_START_DT_TM DATETIME Y cur_start_dt_tm column
CUR_START_MIN_NBR DOUBLE Y cur_start_min_nbr column
CUR_START_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
DAW_CD DOUBLE N daw_cd column
DC_REASON_CD DOUBLE N dc_reason_cd column
DEPT_MISC_LINE VARCHAR(255) Y dept_misc_line
DEPT_STATUS_CD DOUBLE N dept_status_cd column
DISCONTINUE_EFF_DT_NBR DOUBLE Y discontinue_eff_dt_nbr column
DISCONTINUE_EFF_DT_TM DATETIME Y discontinue_eff_dt_tm column
DISCONTINUE_EFF_MIN_NBR DOUBLE Y discontinue_eff_min_nbr column
DISCONTINUE_EFF_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
DISCONTINUE_IND DOUBLE Y discontinue_ind column
DISCONTINUE_TYPE_CD DOUBLE N discontinue_type_cd column
DISPENSE_HX_ID DOUBLE N dispense_hx_id column
DISP_CATEGORY_CD DOUBLE N disp_category_cd column
DISP_DT_NBR DOUBLE Y disp_dt_nbr column
DISP_DT_TM DATETIME Y disp_dt_tm column
DISP_EVENT_TYPE_CD DOUBLE N disp_event_type_cd column
DISP_FROM_LOC_CD DOUBLE N disp_from_loc_cd column
DISP_FROM_SR_CD DOUBLE N disp_from_sr_cd column
DISP_MIN_NBR DOUBLE Y disp_min_nbr column
DISP_PERS_BED_CD DOUBLE N disp_pers_bed_cd
DISP_PERS_BLD_CD DOUBLE N disp_pers_bld_cd
DISP_PERS_FAC_CD DOUBLE N disp_pers_fac_cd
DISP_PERS_NU2_GRP_CD DOUBLE N disp_pers_nu2_grp_cd
DISP_PERS_NU_CD DOUBLE N disp_pers_nu_cd
DISP_PERS_NU_GRP_CD DOUBLE N disp_pers_nu_grp_cd
DISP_PERS_ROOM_CD DOUBLE N disp_pers_room_cd column
DISP_PRIORITY_CD DOUBLE N disp_priority_cd column
DISP_QTY DOUBLE Y disp_qty column
DISP_QTY_UNIT_CD DOUBLE N disp_qty_unit_cd column
DISP_SHIFT2_GRP_CD DOUBLE N For pharmacy shifts
DISP_SHIFT_GRP_CD DOUBLE N For Pharmacy Shifts
DISP_SR_CD DOUBLE N disp_sr_cd column
DISP_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.
DOSES DOUBLE Y doses column
DOSE_QUANTITY DOUBLE Y dose_quantity column
DOSE_QUANTITY_UNIT_CD DOUBLE N dose_quantity_unit_cd column
EARLY_REASON_CD DOUBLE N early_reason_cd column
EFFECTIVE_DT_NBR DOUBLE Y Effective Date Number value
EFFECTIVE_DT_TM DATETIME Y Effective Date and Time value
EFFECTIVE_MIN_NBR DOUBLE Y Effective Minute number value
EFFECTIVE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
EXPIRE_DT_NBR DOUBLE Y expire_dt_nbr column
EXPIRE_DT_TM DATETIME Y expire date and time value
EXPIRE_MIN_NBR DOUBLE Y expire_min_nbr column
EXPIRE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
EXTRA_REASON_CD DOUBLE N extra_reason_cd column
FILL_NBR DOUBLE Y fill_nbr column
FIRST_DOSE_DT_NBR DOUBLE Y first_dose_dt_nbr column
FIRST_DOSE_DT_TM DATETIME Y first_dose_dt_tm column
FIRST_DOSE_MIN_NBR DOUBLE Y first_dose_min_nbr column
FLOORSTOCK_IND DOUBLE Y floorstock_ind column
FLOORSTOCK_OVERRIDE_IND DOUBLE Y floorstock_override_ind column
FREQ_CD DOUBLE N freq_cd column
HEALTH_PLAN_ID DOUBLE N health_plan_id
ICD9_NOMEN_ID DOUBLE N icd9_nomen_id column
IGNORE_IND DOUBLE Y ignore_ind column
INACTIVE_FLAG DOUBLE Y inactive_flag (future use)
INCOMPLETE_ORDER_IND DOUBLE Y incomplete_order_ind column
INGREDIENT_IND DOUBLE Y an indicator on whether this order has multiple ingredients.
ING_CATALOG_CD DOUBLE N ing_catalog_cd column
ING_CATALOG_TYPE_CD DOUBLE N ing_catalog_type_cd column
ING_FREETEXT_DOSE VARCHAR(255) Y ing_free-text_dose column
ING_MNEMONIC VARCHAR(100) Y ing_mnemonic column
ING_SEQ DOUBLE N ing_seq column
ING_STRENGTH DOUBLE Y ing_strength column
ING_STRENGTH_UNIT_CD DOUBLE N ing_strength_unit_cd column
ING_SYNONYM_ID DOUBLE N ing_synonym_id column
ING_TYPE_FLAG DOUBLE Y ing_type_flag column
ING_VOLUME DOUBLE Y ing_volume column
ING_VOLUME_UNIT_CD DOUBLE N ing_volume_unit_cd column
ITEM_ID DOUBLE N ID value of the Item
LAST_FILL_STATUS_CD DOUBLE N last_fill_status column
LAST_REFILL_DT_NBR DOUBLE Y last_refill_dt_nbr column
LAST_REFILL_DT_TM DATETIME Y last_refill_dt_tm column
LAST_REFILL_MIN_NBR DOUBLE Y last_refill_min_nbr column
LAST_REFILL_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
LAST_UPDT_PROVIDER_ID DOUBLE N last_updt_provider_id column
LATE_REASON_CD DOUBLE N late_reason_cd column
LEGAL_STATUS_CD DOUBLE N Legal Status Code value
MANF_ITEM_ID DOUBLE N manf_item_id column
MANF_NDC_STR VARCHAR(200) Y manf_ndc_str column
MANUFACTURER_CD DOUBLE N The Manufacturer Code
MED_ORDER_TYPE_CD DOUBLE N med_order_type_cd column
MED_SERVICE_CD DOUBLE N The type or category of medical service that the patient is receiving in relation to their encounter. The category may be of treatment type, surgery, general resources, or others.
NDC_STR VARCHAR(200) Y ndc_str column
NEED_RX_CLIN_REVIEW_FLAG DOUBLE Y Flag for identifying whether the order's clinical review has be completed or not.
NEED_RX_PROD_ASSIGN_FLAG DOUBLE Y Flag for identifying whether the order's product assignment has been completed or not.
NEED_RX_VERIFY_IND DOUBLE Y need_rx_verify_ind column
NEED_VERIFY_IND DOUBLE Y need_verify_ind column
NEXT_DISP_DT_NBR DOUBLE Y next_disp_dt_nbr column
NEXT_DISP_DT_TM DATETIME Y next_disp_dt_tm column
NEXT_DISP_MIN_NBR DOUBLE Y next_disp_min_nbr column
NEXT_DISP_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.
ORDERABLE_TYPE_FLAG DOUBLE Y orderable_type_flag column
ORDERING_PROVIDER_ID DOUBLE N ordering_provider_id column
ORDER_CATALOG_CD DOUBLE N order_catalog_cd column
ORDER_CATALOG_TYPE_CD DOUBLE N order_catalog_type_cd column
ORDER_ID DOUBLE N Order Id from the orders table
ORDER_INCOMP_ORDER_IND DOUBLE Y order_incomp_order_ind column
ORDER_LOC_CD DOUBLE N order_loc_cd column
ORDER_PRIORITY_CD DOUBLE N ORDER_PRIORITY_CD
ORDER_STATUS_CD DOUBLE N order_status_cd column
ORDER_TYPE_FLAG DOUBLE Y order_type_flag column
ORD_PERS_AGE_DAYS DOUBLE Y ord_pers_age_days
ORD_PERS_AGE_YEARS DOUBLE Y ord_pers_age_years
ORD_PERS_BED_CD DOUBLE N ord_pers_bed_cd
ORD_PERS_BLD_CD DOUBLE N ord_pers_bld_cd
ORD_PERS_FAC_CD DOUBLE N ord_pers_fac_cd
ORD_PERS_NU_CD DOUBLE N ord_pers_nu_cd
ORD_PERS_NU_GRP2_CD DOUBLE N ord_pers_nu_grp2_cd
ORD_PERS_NU_GRP_CD DOUBLE N ord_pers_nu_grp_cd
ORD_PERS_ROOM_CD DOUBLE N ord_pers_room_cd
ORD_PERS_ZIP VARCHAR(25) Y ord_pers_zip
ORGANIZATION_ID DOUBLE N organization_id
ORIG_ORDER_DT_NBR DOUBLE Y orig_order_dt_nbr column
ORIG_ORDER_DT_TM DATETIME Y orig_order_dt_tm column
ORIG_ORDER_MIN_NBR DOUBLE Y orig_order_min_nbr column
ORIG_ORDER_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
ORIG_ORD_AS_FLAG DOUBLE N the flag show how this order was originally placed.
PARENT_THERAP_CLASS VARCHAR(1000) Y parent_therap_class column
PARENT_THERAP_CLASS_ID DOUBLE N parent_therap_class_id column
PAR_DOSES DOUBLE Y par_doses column
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PERSON_OWE_QTY DOUBLE N Amount owed for a person for a product of an order.
PHARM_ORDER_TYPE_FLAG DOUBLE Y pharm_order_type_flag column
PHARM_TYPE_CD DOUBLE N pharm_type_cd column
PHYSICIAN_DEA_TXT VARCHAR(200) Y DEA number of the prescribing physician
PREV_DISP_DT_NBR DOUBLE Y prev_disp_dt_nbr column
PREV_DISP_DT_TM DATETIME Y prev_disp_dt_tm column
PREV_DISP_MIN_NBR DOUBLE Y prev_disp_min_nbr column
PREV_DISP_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.
PRICE DOUBLE Y price column
PRICE_CODE_CD DOUBLE N price_code_cd column
PRN_IND DOUBLE Y prn_ind column
PROD_DISPENSE_HX_ID DOUBLE N Unique, generated identifier for a product on a dispense event.
PROD_VLDTN_DT_TM DATETIME Y Identifies the most recent validation date/time.
PROD_VLDTN_ERROR_IND DOUBLE N Indicates if an error occurred during scanning.
PROD_VLDTN_IND DOUBLE N Indicator to determine if product validation occurred on a dispense.
PROD_VLDTN_OVERRIDE_IND DOUBLE N Indicator to determine if the user overrides a scan failure.
PROD_VLDTN_OVERRIDE_REASON_CD DOUBLE N Identifies the reason a user selects to override a validation event.
PROD_VLDTN_PRSNL_ID DOUBLE N The user who last performed a validation event.
PROD_VLDTN_RPH_IND DOUBLE N Indicates if any events were performed by a pharmacist.
PROD_VLDTN_TECH_IND DOUBLE N Indicates if any events were performed by a pharmacy technician.
PROD_VLDTN_TZ DOUBLE N The time zone associated with PROD_VLDTN_DT_TM.
PROJECTED_STOP_DT_NBR DOUBLE Y projected_stop_dt_nbr column
PROJECTED_STOP_DT_TM DATETIME Y projected_stop_dt_tm column
PROJECTED_STOP_MIN_NBR DOUBLE Y projected_stop_min_nbr column
PROJECTED_STOP_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
QTY_REMAINING DOUBLE Y qty_remaining column
REASON_CD DOUBLE N reason_cd
REFILLS_REMAINING DOUBLE Y refills_remaining column
REFILL_QTY DOUBLE Y refill_qty column
REIMBURSEMENT_AMT DOUBLE Y reimbursement_amt column
RENEW_REASON_CD DOUBLE N renew_reason_cd column
REPLACE_EVERY DOUBLE Y replace_every column
REPLACE_EVERY_CD DOUBLE N replace_every_cd column
REQ_START_DT_NBR DOUBLE Y req_start_dt_nbr column
REQ_START_DT_TM DATETIME Y req_start_dt_tm column
REQ_START_MIN_NBR DOUBLE Y req_start_min_nbr column
REQ_START_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
RESUME_DT_NBR DOUBLE Y resume_dt_nbr column
RESUME_DT_TM DATETIME Y resume_dt_tm column
RESUME_EFF_DT_NBR DOUBLE Y resume_eff_dt_nbr column
RESUME_EFF_DT_TM DATETIME Y resume_eff_dt_tm column
RESUME_EFF_MIN_NBR DOUBLE Y resume_eff_min_nbr column
RESUME_EFF_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
RESUME_MIN_NBR DOUBLE Y resume_min_nbr column
RESUME_REASON_CD DOUBLE N resume_reason_cd column
RESUME_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
ROOT_THERAP_CLASS VARCHAR(1000) Y root_therap_class column
ROOT_THERAP_CLASS_ID DOUBLE N root_therap_class_id column
RUN_USER_ID DOUBLE N run_user_id column
RXA_AUTH_NBR_TXT VARCHAR(250) Y Last Authorization number received from health plan
RXA_BACKWARD_ORDER_ID DOUBLE Y Indicates the order based on which the current order was placed
RXA_BILL_QTY DOUBLE Y Indicates the quantity billed for the current fill
RXA_CHECK_RPH_ID DOUBLE Y Person_id, of the pharmacist that checked the dispense, from prsnl table
RXA_CHRG_CDM VARCHAR(250) Y CDM number used in charging the dispense
RXA_CHRG_DISPENSE_HX_ID DOUBLE Y The dispense record that is being cancelled by the current dispense
RXA_CLAIM_FLAG DOUBLE Y Indicates whether the current fill has been claimed 0,"None",1,"Non-Adjudicated",2,"Adjudicated"
RXA_CLAIM_STATUS_CD DOUBLE Y Indicates the status of the claim transaction for last health plan
RXA_COB_FLAG DOUBLE Y Indicates whether co-ordination of benefits was used in claiming this fill 0, "None", 1,"Non-COB", 2,"COB"
RXA_COMPLETED_USER_ID DOUBLE Y Person_id, of the user that completed the dispense, from prsnl table
RXA_COMPOUND_BASE_IND DOUBLE Y Indicates if the current drug is a base
RXA_COMPOUND_FLAG DOUBLE Y Indicates if the current drug is a compound parent or child
RXA_CONTROL_NBR_TXT VARCHAR(250) Y Control number for the script
RXA_CRDT_DISPENSE_HX_ID DOUBLE Y The dispense record that credited the current dispense.PHA_PRODUCT_DISPENSE_HX_ST
RXA_DAYS_SUPPLY DOUBLE Y Indicates the days for which the current fill will last
RXA_DISCOUNT_AMT DOUBLE Y RXA Discount Amount
RXA_DISPENSE_FEE DOUBLE Y RXA Dispense Fee
RXA_DISP_COMPLETE_FLAG DOUBLE Y Indicates whether a dispense is complete. 0, "In-Complete",1, "Complete"
RXA_DISP_PRIORITY_DT_TM DATETIME Y Priority Date/Time for the dispense
RXA_DISP_PRIORITY_DT_TZ DOUBLE Y Priority Date/Time for the dispense
RXA_DISP_STAT_CD DOUBLE Y Latest dispense status of the dispense.
RXA_DUR_FLAG DOUBLE Y Indicates whether last health plan performed drug utilization review 0,"None",1, "NO DUR Performed", 2, "DUR Performed"
RXA_EXPANDED_SIG_ID DOUBLE Y Order comment of type "PHARMSIG". Long_text_id from long_text table
RXA_FILL_DEVICE_SR_CD DOUBLE Y To store the pharmacy filling device value.
RXA_FILL_LOCATION_SR_CD DOUBLE Y To store the pharmacy filling location value
RXA_FILL_RPH_ID DOUBLE Y Person_id. of the pharmacist that filled the dispense, from prsnl table
RXA_FORWARD_ORDER_ID DOUBLE Y Indicates the order that was placed based off of the current order
RXA_HEALTH_PLAN_SEQ DOUBLE Y The sequence of the last health plan in the list of health plans used for this prescription
RXA_INCENTIVE_AMT DOUBLE Y RXA Incentive Amount
RXA_INNER_PKG_QTY DOUBLE Y Indicates the inner package quantity of the current manufacturer
RXA_INNER_PKG_UNIT_CD DOUBLE Y Indicates code for the inner package quantity of the current manufacturer
RXA_LEVEL5_CD DOUBLE Y work station that requested the event
RXA_MED_PRODUCT_ID DOUBLE Y Med product used for the current drug (MED_PRODUCT)
RXA_ORG_ACTION_SEQ DOUBLE Y The action sequence based on which the dispense was originally created
RXA_OWE_QTY DOUBLE Y Indicates the quantity owed on the current fill
RXA_PACKAGE_TYPE_ID DOUBLE Y Indicates the package type of the current drug
RXA_PARENT_ORDER_ID DOUBLE Y This field contains the order_id of the prescription placed in easy script that was used to create the current order.
RXA_PARENT_ORIG_ORD_AS_FLAG DOUBLE N To store the parent order orig_ord_as_flag value
RXA_PARENT_PRODUCT_SEQ DOUBLE Y For child products of a compound, this points to the parent order_product.
RXA_PARTIAL_FILL_FLAG DOUBLE Y Indicates the type of partial fill 0,"Complete Fills",1, "Partial Fills"
RXA_PF_REASON_CD DOUBLE Y Indicates the reason for partial fill
RXA_PF_TYPE_CD DOUBLE Y Indicates if a health plan supports NCPDP 51 partial fill submission process.
RXA_PRICE_SCHED_ID DOUBLE Y Indicates the price schedule used for the fill
RXA_PRIOR_AUTH_NBR_TXT VARCHAR(250) Y Last health plan's prior authorization number
RXA_PRIOR_AUTH_TYPE_CD DOUBLE Y Last health plan's prior authorization type code
RXA_PRODUCT_SEQ DOUBLE Y Unique sequence for each product.
RXA_PROXY_PRESCRIBER_ID DOUBLE Y Indicates the proxy prescriber of the order
RXA_REVIEWED_PARENT_ACTION_SEQ DOUBLE Y This field contains the action sequence of the parent order that was reviewed by the user that performed the latest fill on the current order.
RXA_SALES_TAX DOUBLE Y RXA Sales Tax
RXA_SCRIPT_ORIGIN_CD DOUBLE Y Indicates how the script originated
RXA_SOURCE_PARENT_ACTION_SEQ DOUBLE Y This field contains the action sequence of the parent order that was used as the source to create the current order.
RXA_TOTAL_REFILLS DOUBLE Y Total refills authorized for the prescription
RXA_TRANSFER_FLAG DOUBLE Y Indicates the type of transfer performed on the order. 0, "None",1, "Internal Transfer-in", 2,"External Transfer-in",3,"External Transfer-out"
RXA_UC_PRICE DOUBLE Y Usual and Customary price
RXA_VERIFY_RPH_ID DOUBLE Y Person_id, of the pharmacist that verified the dispense, from prsnl table
RXA_XFER_ORDER_ID DOUBLE Y Indicates the order that the current order was transferred from/to
RXA_XFER_SERVICE_RESOURCE_CD DOUBLE Y Indicates the service-resource that the current order was transferred from/to
RXA_XFER_TRANSFER_CD DOUBLE Y Indicates the transfer-location that the current order was transferred from/to
RX_DISP_QTY DOUBLE Y rx_disp_qty column
RX_EXPIRE_DT_NBR DOUBLE Y rx_expire_dt_nbr column
RX_EXPIRE_DT_TM DATETIME Y rx_expire_dt_tm column
RX_EXPIRE_MIN_NBR DOUBLE Y rx_expire_min_nbr column
RX_EXPIRE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
RX_MASK DOUBLE Y rx_mask column
RX_NBR DOUBLE Y rx_nbr column
RX_NBR_CD DOUBLE N rx_nbr_cd column
RX_NBR_STR VARCHAR(100) Y rx_nbr_st
RX_PAY_METHOD_CD DOUBLE N rx_pay_method_cd column
RX_QTY DOUBLE Y rx_qty column
RX_ROUTE_CD DOUBLE N rx_route_cd column
SERVICE_CATEGORY_CD DOUBLE N Codified field, which identifies the current category of service the patient is receiving for this encounter.
SIG VARCHAR(255) Y sig column
SOFT_STOP_DT_NBR DOUBLE Y soft_stop_dt_nbr column
SOFT_STOP_DT_TM DATETIME Y soft_stop_dt_tm column
SOFT_STOP_MIN_NBR DOUBLE Y soft_stop_min_nbr column
SOFT_STOP_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
STATUS_PRSNL_ID DOUBLE N status_prsnl_id column
STOP_DT_NBR DOUBLE Y stop_dt_nbr column
STOP_DT_TM DATETIME Y stop_dt_tm column
STOP_MIN_NBR DOUBLE Y stop_min_nbr column
STOP_TYPE_CD DOUBLE N stop_type_cd column
STOP_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
STRENGTH_DOSE DOUBLE Y strength_dose column
STRENGTH_DOSE_UNIT_CD DOUBLE N strenght_dose_unit_cd
SUSPEND_DT_NBR DOUBLE Y suspend_dt_nbr column
SUSPEND_DT_TM DATETIME Y suspend_dt_tm column
SUSPEND_EFF_DT_NBR DOUBLE Y suspend_eff_dt_nbr column
SUSPEND_EFF_DT_TM DATETIME Y suspend_eff_dt_tm column
SUSPEND_EFF_MIN_NBR DOUBLE Y suspend_eff_min_nbr column
SUSPEND_EFF_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
SUSPEND_IND DOUBLE Y suspend_ind column
SUSPEND_MIN_NBR DOUBLE Y suspend_min_nbr column
SUSPEND_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
SYNONYM_ID DOUBLE N The synonym_id from the order_catalog_synonym table.
THERAP_CLASS VARCHAR(1000) Y therap_class column
THERAP_CLASS_ID DOUBLE N therap_class_id column
THERAP_SUB_ALT_REGIMEN_IND DOUBLE N Indicates that the substitution to the new medication was accepted but the specific ordering details were not (dose, route, frequency).
THERAP_SUB_DOSE_FREE_TXT VARCHAR(100) Y Free text of the medication originally ordered.
THERAP_SUB_DT_TM DATETIME Y The date of the substitution.
THERAP_SUB_FREQ_CD DOUBLE N Dosing frequency of the original medication.
THERAP_SUB_ITEM_ID DOUBLE N The item ID of the medication originally ordered.
THERAP_SUB_OVERRIDE_IND DOUBLE N Indicates that the suggested therapeutic substitution was not taken.
THERAP_SUB_OVERRIDE_RSN_CD DOUBLE N The reason that the suggested therapeutic substitution was not taken.
THERAP_SUB_PERSON_OWN_MEDS_IND DOUBLE N Indicates that the substitution was not taken since the patient brought in their own supply of the medication.
THERAP_SUB_ROUTE_CD DOUBLE N Route of administration of the medication originally ordered.
THERAP_SUB_STRENGTH_UNIT_CD DOUBLE N The unit of measure associated with the strength of this medication.
THERAP_SUB_STRENGTH_VALUE DOUBLE N The strength of the medication originally ordered.
THERAP_SUB_VOLUME_UNIT_CD DOUBLE N The unit of measure for the volume of the medication originally ordered.
THERAP_SUB_VOLUME_VALUE DOUBLE N The volume of the medication originally ordered.
TNF_ID DOUBLE N Key to template_non-formulary table
TOTAL_RX_QTY DOUBLE Y total_rx_qty column
TRACK_NBR DOUBLE Y track_nbr column
TRACK_NBR_CD DOUBLE N CODE VALUE FROM CODE SET 4503
TRANSFER_CNT DOUBLE Y transfer_cnt column
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 - PHA_PROD_DISP_OBS_ST


Child Column in PHA_PROD_DISP_OBS_ST(FK) Parent Table Name Parent Column Name
Parents: PARENT_THERAP_CLASS_ID ALT_SEL_CAT ALT_SEL_CATEGORY_ID
ROOT_THERAP_CLASS_ID ALT_SEL_CAT ALT_SEL_CATEGORY_ID
THERAP_CLASS_ID ALT_SEL_CAT ALT_SEL_CATEGORY_ID
DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
ITEM_ID ITEM_DEFINITION ITEM_ID
MANF_ITEM_ID MANUFACTURER_ITEM ITEM_ID
ICD9_NOMEN_ID NOMENCLATURE NOMENCLATURE_ID
ORDER_ID ORDERS ORDER_ID
ING_SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID
SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID
PROD_VLDTN_PRSNL_ID PRSNL PERSON_ID


PHA_QUEUELOG



Column Section Top of Page


Table-level Detail

Description: Table for storing log files from queue server
Definition: queue server log table
Table Type: ACTIVITY





Column Detail - PHA_QUEUELOG


Column Name Type Null? Definition
QUEUE_COUNT DOUBLE Y Number of items in queue
QUEUE_ID DOUBLE N Unique ID of queue 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.