Table Detail Report

PEX_STD_DOSE_UP_TMP_GTTD



Column Section Top of Page


Table-level Detail

Description: Standardized Dose Upload Temporary Global Temp Table
Definition: Used to efficiently transform data from a CSV file (joining with information from the Order_catalog_synonym, standardized_order_dose, and other tables) to facilitate populatin of the standardized_order_dose table.
Table Type: ACTIVITY





Column Detail - PEX_STD_DOSE_UP_TMP_GTTD


Column Name Type Null? Definition
BOTH_UNIT_CD DOUBLE Y The unit CD if found or -1 if not found. Used to populate two fields in standardized_order_dose (compare_unit_cd and std_dose_unit_cd)
BOTH_UNIT_DISP VARCHAR(40) Y The CSV value which the script will attempt to match with a unit_cd
COMPARE_VALUE1 DOUBLE Y The CSV entry which will go into the corresponding field in standardized_order_dose if the row meets business logic requirements.
COMPARE_VALUE2 DOUBLE Y The CSV entry which will go into the corresponding field in standardized_order_dose if the row meets business logic requirements.
COMPARE_VALUE2_SKIPPED_IND DOUBLE Y Indicates that COMPARE_VALUE2 will be ignored because the relational operator was not "BETWEEN".
CSV_ROW_NBR DOUBLE Y Identifies which row of the CSV file the row came from.
OCS_CKI VARCHAR(255) Y The CSV entry which the script will attempt to match with order_catalog_synonym.CKI
OCS_MNEMONIC VARCHAR(100) Y The CSV entry which the script will attempt to match with order_catalog_synonym.mnemonic.
RANGE_OPERATOR_DISP VARCHAR(80) Y Capture what the user actually entered as Range Operator to be able to log wrong values later.
RELATIONAL_OPERATOR_FLAG DOUBLE Y Matches a subset of values in DM_FLAGS or -1 if not found; uses 1,4,6 as hard-coded in the Order Catalog Tool. 1=Less Than, 4=Greater than or equal to, 6=Between
ROUTE_CD DOUBLE Y The route CD if found or -1 if not found
ROUTE_DISP VARCHAR(40) Y The CSV entry which the script will attempt to match with a route_cd.
STD_DOSE_VALUE DOUBLE Y The CSV entry which will go into the corresponding field in standardized_order_dose if the row meets business logic requirements.


PHARMACY_NOTES



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Order Notes desc
Definition: Pharmacy Order Notes
Table Type: ACTIVITY





Column Detail - PHARMACY_NOTES


Column Name Type Null? Definition
ACTION_SEQUENCE DOUBLE N Link back to order_action table. Action this comment applies to.
COMMENT_TYPE_CD DOUBLE N Type of comment (label note 1, label note 2, preparation note, nursing note, pharmacy note
LONG_TEXT_ID DOUBLE N Key to Long text table
ORDER_ID DOUBLE N key to order table. Identifies the order the comment is tied to.
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.
WHERE_TO_PRINT DOUBLE Y Specifies where this comment should print if the comment is a label comment



Relationship Detail - PHARMACY_NOTES


Child Column in PHARMACY_NOTES(FK) Parent Table Name Parent Column Name
Parents: COMMENT_TYPE_CD CODE_VALUE CODE_VALUE
ACTION_SEQUENCE ORDER_ACTION ACTION_SEQUENCE
ORDER_ID ORDER_ACTION ORDER_ID


PHA_BATCH_PARAMETERS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Batch Parameters
Definition: Pharmacy Batch Qualification and Update fields and tables for Pharmacy batch update tool.
Table Type: REFERENCE





Column Detail - PHA_BATCH_PARAMETERS


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
EXT_CODE_SET DOUBLE Y Content will vary by field type flag. If flag = 6, will contain a code set number, If 8, will contain the request number needed to extract additional information to process therapeutic classes using COLEGeneric Class.
FIELD_MEAN DOUBLE Y The OE FIELD ID of the order sentence detail to be modified. Only valued if field_type_flag = 7
FIELD_NAME VARCHAR(30) Y The CCL column name of the field to be modified. Must precisely match CCL definition.
FIELD_TYPE_FLAG DOUBLE Y Identifies the type of data field being passed to the update script. This field also determines the content of other columns in this table. The update script will execute different routines based on the various flags.
FUNCTION_IND DOUBLE Y This column identifies whether the field can be used to filter only, update only, or filter and update. Valid values are: 0 - Filter Only 1 - Update and Filter 2 - Update only
PARAMETER_CD DOUBLE N Oracle code identifying the parameter. Relates back to CODE_VALUE table.
TABLE_NAME VARCHAR(30) Y Parent table of the field to be modified or qualified by.
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_BATCH_PARAMETERS


Child Column in PHA_BATCH_PARAMETERS(FK) Parent Table Name Parent Column Name
Parents: PARAMETER_CD CODE_VALUE CODE_VALUE


PHA_BATCH_REPORT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Parameters for PharmNet PMP, MAR, Fill List reports
Definition: Parameters for PharmNet reports
Table Type: REFERENCE





Column Detail - PHA_BATCH_REPORT


Column Name Type Null? Definition
BATCH_REPORT_CD DOUBLE N Primary key
BATCH_TYPE_CD DOUBLE N Identifies the type of report to be run (fill list, pmp, mar etc.)
CLIN_REVIEW_IND DOUBLE N Indicator that determines if orders not needing clinical review should qualify on reports.
CREATE_PRSNL_ID DOUBLE N The creator of the report.
DC_DISPLAY DOUBLE Y Indicates whether discontinued orders should display on the report. 1 = true, 0 = false
DC_DISPLAY_UNITS_CD DOUBLE N Unit of measure for dc_display
LOC_FACILITY_CD DOUBLE N Identifies the single facility location to which the Batch Report is related.
ORD_TYPE_CONT_IND DOUBLE Y Display/print continuous orders on this report
ORD_TYPE_DC_IND DOUBLE Y Display discontinued orders on the report
ORD_TYPE_INT_IND DOUBLE Y Display intermittent IV orders on the report
ORD_TYPE_MED_IND DOUBLE Y Display medication orders on the report
ORD_TYPE_SUSP_IND DOUBLE Y Display suspended orders on the report
ORD_TYPE_UNVER_IND DOUBLE Y Display unverified orders on the report
OUTPUT_DEVICE_CD DOUBLE N Output Deivce (printer) report should be printed to.
OUTPUT_FORMAT_CD DOUBLE N Output format associated with this report
PHARM_TYPE_CD DOUBLE N Pharmacy type code (Inpat vs. Retail vs Longterm etc.)
POP_SELECT_FLAG DOUBLE Y Flag to determine if report is run for single patient or nursing station
PREQUAL_SCRIPT_CD DOUBLE N Script to extract data specific to type of report. This script is NOT customizable by client or project personnel, and calls the script defined by the output_format_cd
REPORT_TYPE_FLAG DOUBLE N The type of report this record represents.
START_DAY DOUBLE Y Flag to determine when report should start. Value is applied to curdate to determine start date. Valid values are (-1, 0, 1).
START_TIME DOUBLE Y Start time of the report. Stored as a number of minutes i.e. 720 = 12 noon.
STOP_TYPE_HARD_IND DOUBLE Y Display orders with hard stops
STOP_TYPE_PHYS_IND DOUBLE Y Display orders with physician defined stop dates
STOP_TYPE_SOFT_IND DOUBLE Y Display orders with soft (undefined) stops
TIME_PERIOD DOUBLE Y Time interval to qualify data for. i.e. 24 hours, 30 minutes, 3 days etc.
TIME_PERIOD_UNIT_CD DOUBLE N Unit of measure to apply to time_period. Ie1439 minutes, 24 hours etc.
TIME_RANGE_CD DOUBLE N Identifies what type of time range to qualify data on i.e. Stop Dates, administration dates, Start Dates, DC dates
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_BATCH_REPORT


Child Column in PHA_BATCH_REPORT(FK) Parent Table Name Parent Column Name
Parents: LOC_FACILITY_CD LOCATION LOCATION_CD
CREATE_PRSNL_ID PRSNL PERSON_ID




Parent Column in PHA_BATCH_REPORT (PK) Child Table Name Child Column Name
Children: BATCH_REPORT_CD PHA_BATCH_REPORT_ACT BATCH_REPORT_CD


PHA_DISP_OBS_ST



Column Section Relationship Section Top of Page


Table-level Detail

Description: pha_disp_obs_st
Definition: Observation set of PharmNet's activity data at the order dispense level. Used to generate Drug Utilization Evaluation (DUE) reports.
Table Type: ACTIVITY





Column Detail - PHA_DISP_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
ACTION_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
CANCEL_REASON_CD DOUBLE N reason that an action was cancelled
CHARGE_IND DOUBLE Y indicates if the order has been or is to be charged
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.
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 Total cost for the dispense
CUR_DEPT_STATUS_CD DOUBLE N current departmental status 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 date of an order's start date
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
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
DISPENSE_HX_ID DOUBLE N the id from dispense_hx for an order's dispense event
DISP_CATEGORY_CD DOUBLE N Code set 4008: Indicates the method to calculate dispense doses and charging method
DISP_DT_NBR DOUBLE Y the Julian date of an order's dispense date
DISP_DT_TM DATETIME Y the dispense dt/tm of an order's dispense
DISP_EVENT_TYPE_CD DOUBLE N the dispense type of an order's event
DISP_FROM_LOC_CD DOUBLE N the dispense location of an order's dispense
DISP_FROM_SR_CD DOUBLE N the service resource code value associated to the dispense from location
DISP_MIN_NBR DOUBLE Y the time value in minutes of a dispense
DISP_PERS_BED_CD DOUBLE N the bed code value of the patient's location
DISP_PERS_BLD_CD DOUBLE N the building code value of the patient's location
DISP_PERS_FAC_CD DOUBLE N the facility code value of the patient's location
DISP_PERS_NU2_GRP_CD DOUBLE N The nurse unit grouping code
DISP_PERS_NU_CD DOUBLE N the nurse unit code value of the patient's location
DISP_PERS_NU_GRP_CD DOUBLE N The nurse unit grouping code
DISP_PERS_ROOM_CD DOUBLE N the room code value of the patient's location
DISP_PRIORITY_CD DOUBLE N the priority code of an order
DISP_QTY DOUBLE Y the amount to dispense for an order
DISP_QTY_UNIT_CD DOUBLE N the unit of the amount to dispense
DISP_SHIFT2_GRP_CD DOUBLE N Pharmacy shifts
DISP_SHIFT_GRP_CD DOUBLE N The shift grouping code
DISP_SR_CD DOUBLE N the service resource code value associated to the dispense from location
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 number of doses dispensed
EARLY_REASON_CD DOUBLE N Reason for an early refill
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 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.
EXTRA_REASON_CD DOUBLE N the reason for an extra dose event
FILL_NBR DOUBLE Y Retail Fill number for dispense transaction
FIRST_DOSE_DT_NBR DOUBLE Y the Julian date of a first dose event
FIRST_DOSE_DT_TM DATETIME Y the date/time of a first dose event
FIRST_DOSE_MIN_NBR DOUBLE Y the time value in minutes of a first dose event
FIRST_DOSE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
FLOORSTOCK_IND DOUBLE Y indicates if the order is dispensed from the floor
FLOORSTOCK_OVERRIDE_IND DOUBLE Y indicates if the user changed the dispense location to a floorstock (1) or non-floorstock (2)
FREQ_CD DOUBLE N the frequency code value associated to an order
HEALTH_PLAN_ID DOUBLE N health_plan_id
ICD9_NOMEN_ID DOUBLE N Diagnosis Nomenclature Identifier
IGNORE_IND DOUBLE Y indicates if the order is to not qualify on the fill list; 1 = ignore, 0 = fill as instructed
INACTIVE_FLAG DOUBLE Y Identifies if the order is inactive
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 The code for the last fill batch status.
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
LATE_REASON_CD DOUBLE N later_reason_cd
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
NEXT_DISP_DT_NBR DOUBLE Y The next dispense date in number of days
NEXT_DISP_DT_TM DATETIME Y The next dispense date and time in calendar format
NEXT_DISP_MIN_NBR DOUBLE Y The next dispense time in minutes
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 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 catalog code associated to the order
ORDER_CATALOG_TYPE_CD DOUBLE N Internal code for catalog type.
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 Location code of an order
ORDER_PRIOIRTY_CD DOUBLE N order_priority_cd
ORDER_PRIORITY_CD DOUBLE N ORDER_PRIORITY_CD
ORDER_STATUS_CD DOUBLE N status code value of an order
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 The nurse unit grouping code
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 a 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_OWE_QTY DOUBLE N Amount owed for a person for a product of an order.
PHARM_ORDER_TYPE_FLAG DOUBLE Y The order type of an order
PHARM_TYPE_CD DOUBLE N The pharm_type_cd
PHYSICIAN_DEA_TXT VARCHAR(200) Y DEA number of the prescribing physician
PREV_DISP_DT_NBR DOUBLE Y The previous dispense date in number of days
PREV_DISP_DT_TM DATETIME Y The previous dispense date/time in calendar format
PREV_DISP_MIN_NBR DOUBLE Y The previous dispense time in minutes
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 Total price for the dispense
PRICE_CODE_CD DOUBLE N The price schedule code value of an order
PRN_IND DOUBLE Y Indicates that the order is PRN
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 The projected stop date in number of days
PROJECTED_STOP_DT_TM DATETIME Y The projected stop date and time in calendar format
PROJECTED_STOP_MIN_NBR DOUBLE Y The projected stop time in number of minutes
PROJECTED_STOP_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
QTY_REMAINING DOUBLE Y The remaining quantity of an order
REASON_CD DOUBLE N reason_cd
REFILLS_REMAINING DOUBLE Y number of refills remaining
REFILL_QTY DOUBLE Y the amount to refill for a retail order
REIMBURSEMENT_AMT DOUBLE Y Reimbursement Amount for this dispense transaction
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.
RUN_USER_ID DOUBLE N ID of the user generating the dispense event
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_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_LEVEL5_CD DOUBLE Y work station that requested the event
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_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_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_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 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 Formatted Prescription Number
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
TRACK_NBR DOUBLE Y A number to track a dispensed prescription
TRACK_NBR_CD DOUBLE N CODE VALUE FROM CODE SET 4502
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_DISP_OBS_ST


Child Column in PHA_DISP_OBS_ST(FK) Parent Table Name Parent Column Name
Parents: DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
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
PROD_VLDTN_PRSNL_ID PRSNL PERSON_ID