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