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. |