Table Detail Report
DISP_PRIORITY_SR_R
Column Section | Top of Page |
Table-level Detail
Description: | DISPENSE PRIORITY SERVICE RESOURCE RELATION |
Definition: | Disp_priority_sr_r - Relates Dispense Priority to Service Resource. |
Table Type: | REFERENCE |
Column Detail - DISP_PRIORITY_SR_R
Column Name | Type | Null? | Definition |
---|---|---|---|
DEFAULT_IND | DOUBLE | Y | NOT IN USE |
DISP_PRIORITY_CD | DOUBLE | N | CODE VALUE FROM CODE SET 4513 - Dispense Priority |
FIXED_TIME | DOUBLE | Y | TIME (0000 TO 2359). indicates the default fixed time to display during order entry for the priority/service resource combination |
SERV_RES_CD | DOUBLE | N | CODE VALUE FROM CODE SET 221 - Service Resource |
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. |
MED_COST_HX
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | med cost hx |
Definition: | med cost history |
Table Type: | REFERENCE |
Column Detail - MED_COST_HX
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. |
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. |
COST | DOUBLE | Y | cost |
COST_TYPE_CD | DOUBLE | N | cost type cd |
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. |
MED_COST_HX_ID | DOUBLE | N | med cost hx id |
MED_PRODUCT_ID | DOUBLE | N | med_product_id |
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 - MED_COST_HX
Child Column in MED_COST_HX(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | MED_PRODUCT_ID | MED_PRODUCT | MED_PRODUCT_ID |
MED_DEF_FLEX
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Med_Def_Flex |
Definition: | The Med_def_flex file stores the various methods of flexing a Med_def, including Pharmacy type, Location (Facility, Nursing Unit, Ambulatory, Pharmacy), Package Type. These records are 1 to many to the Med_def. |
Table Type: | REFERENCE |
Column Detail - MED_DEF_FLEX
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. |
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 | Y | 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. |
FLEX_SORT_FLAG | DOUBLE | Y | Flex Sort Flag |
FLEX_TYPE_CD | DOUBLE | N | flex_type_cd |
ITEM_ID | DOUBLE | N | Item_id |
MED_DEF_FLEX_ID | DOUBLE | N | med_def_flex_id |
MED_PACKAGE_TYPE_ID | DOUBLE | N | med package type id |
PARENT_ENTITY_ID | DOUBLE | N | parent entity id |
PARENT_ENTITY_NAME | VARCHAR(32) | Y | Parent entity name |
PARENT_MED_DEF_FLEX_ID | DOUBLE | N | parent med def flex id |
PHARMACY_TYPE_CD | DOUBLE | N | pharmacy type cd |
SEQUENCE | DOUBLE | N | Sequence |
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 - MED_DEF_FLEX
Child Column in MED_DEF_FLEX(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ITEM_ID | MEDICATION_DEFINITION | ITEM_ID |
PARENT_MED_DEF_FLEX_ID | MED_DEF_FLEX | MED_DEF_FLEX_ID | |
MED_PACKAGE_TYPE_ID | MED_PACKAGE_TYPE | MED_PACKAGE_TYPE_ID |
Parent Column in MED_DEF_FLEX (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | MED_DEF_FLEX_ID | MED_DEF_FLEX | PARENT_MED_DEF_FLEX_ID |
MED_FLEX_OBJECT_IDX | MED_DEF_FLEX_ID | ||
MED_IDENTIFIER | MED_DEF_FLEX_ID |
MED_DISPENSE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | med_dispense |
Definition: | The Med_dispense file stores all dispense related fields for a Med_def_flex. |
Table Type: | REFERENCE |
Column Detail - MED_DISPENSE
Column Name | Type | Null? | Definition |
---|---|---|---|
ALWAYS_DISPENSE_FROM_FLAG | DOUBLE | Y | always_dispense_from_flag |
BASE_ISSUE_FACTOR | DOUBLE | N | The smallest amount that a product can be divided by. |
BILLING_FACTOR_NBR | DOUBLE | N | Used to calculate a Charge Services billing amount, by applying the billing factor to the normal Charge Quantity. |
BILLING_UOM_CD | DOUBLE | N | Passed to Charge Services with the billing factor to identify the correct unit of measure for the Charge Services bill amount. |
CMS_WASTE_BILLING_UNIT_AMT | DOUBLE | N | Minimum waste quantity value(positive real number) based on which clinician documents waste charge. |
CMS_WASTE_BILLING_UNIT_UOM_CD | DOUBLE | N | Unit on which medication waste charges are appropriately calculated. |
CONTINUOUS_FILTER_IND | DOUBLE | Y | To continuously filter or not to continuously filter |
DISPENSE_FACTOR | DOUBLE | Y | The relationship between the dispense quantity and the base package of the primary manufacturer |
DISPENSE_QTY | DOUBLE | Y | The quantity amount of the dispensed product |
DIVISIBLE_IND | DOUBLE | Y | Defines whether this product can be split, broken, etc. to create a dose. |
FLEX_SORT_FLAG | DOUBLE | Y | used to appropriately sort the flex records |
FLEX_TYPE_CD | DOUBLE | N | This indicates the type of flex. |
FORMULARY_STATUS_CD | DOUBLE | N | Defines the acceptance of this product by the institution. Possible values are (as of 7/2006) Formulary, Investigational, Non-Formulary, TNF |
INFINITE_DIV_IND | DOUBLE | Y | The infinite_div_ind is set by the Pharmacy Inpatient Product Tool. If it's value is 1, the base_issue_factor is set to 0.001 to indicate infinite divisibility. |
INTERMITTENT_FILTER_IND | DOUBLE | Y | Indicates whether the drug should appear in the search results when filtered for intermittently administered drugs. |
INV_FACTOR_NBR | DOUBLE | N | Indicates the relationship of package information between the Pharmacy and Inventory systems. |
ITEM_ID | DOUBLE | N | Points to the Medication_definition. Can't be 0. |
LABEL_RATIO | DOUBLE | Y | Indicates the number of labels per unit dispense quantity. |
LEGAL_STATUS_CD | DOUBLE | N | The legal status of the dispensed product. |
LOT_TRACKING_IND | DOUBLE | N | Indicates whether or not lot tracking should be required for this item. |
MAIL_ORDER_PROD_CD | DOUBLE | N | The value of the mail order type supported for the item. Consolidated Mail Order Pharmacy (CMOP) for item level. |
MAX_DOSE_QTY | DOUBLE | Y | The maximum quantity per dose for this item. |
MED_DISPENSE_ID | DOUBLE | N | Unique key of file. |
MED_FILTER_IND | DOUBLE | Y | Indicates whether this item is selectable when building a medication order. |
MED_PACKAGE_TYPE_ID | DOUBLE | N | The foreign key to the MED_PACKAGE_TYPE table. |
OE_FORMAT_FLAG | DOUBLE | Y | Preferred order format for this item |
OVERRIDE_CLSFCTN_CD | DOUBLE | N | The Code Value which determines the ability to override the classification that a medication is assigned to. |
PACKAGE_TYPE_ID | DOUBLE | N | Relates to the package_type of the Med_def_flex. Must be greater than 0. |
PARENT_ENTITY_ID | DOUBLE | N | Unique Identifier from table names in Parent_Entity_Name Field. |
PARENT_ENTITY_NAME | VARCHAR(32) | Y | Name of the parent entity table that relates to this component |
PAT_ORDERABLE_IND | DOUBLE | Y | Defines whether or not the product is available for ordering at order entry |
PHARMACY_TYPE_CD | DOUBLE | N | Indicates the pharmacy type that the information belongs to. |
PKG_DISP_MORE_IND | DOUBLE | N | Indicates whether or not to dispense more than needed, when using Package Supply dispensing method. |
PKG_QTY_PER_PKG | DOUBLE | N | Indicates qty of the product within a single package |
POC_CHARGE_FLAG | DOUBLE | N | Indicates how a scanned Point of Care charge on administration event should be charged. |
PROD_ASSIGN_FLAG | DOUBLE | N | Indicates if the item is allowed to be automatically assigned.0 = Allow item to be automatically assigned; 1 = Do NOT allow item to be automatically assigned |
REUSABLE_IND | DOUBLE | N | This field indicates if the product is reusable, and will function for inventory incrementing purposes when products are returned to the pharmacy. Upon return to pharmacy, this product is reusable. |
RX_STATION_NOTES_ID | DOUBLE | N | The unique identifier on the long text table used to return the text entered in the RX Station Comment textbox. |
SKIP_DISPENSE_FLAG | DOUBLE | N | Indicates whether this product supports being skipped, from dispensing, when it is part of a multi-ingredient IV/Continuous order. |
STRENGTH | DOUBLE | Y | Strength of the product per unit dispense quantity. |
STRENGTH_UNIT_CD | DOUBLE | N | Strength unit of the dispensed product per unit dispense quantity. |
TPN_BALANCE_METHOD_CD | DOUBLE | N | The method used to determine which process is used for computing the mixture of electrolyte ingredients needed to deliver the ion quantities specified. |
TPN_CHLORIDE_PCT | DOUBLE | Y | If Percent Chloride balance method is chosen, this field indicates the default percent of chloride to be added in the TPN order. Integer values greater than 0 and less than or equal to 100. |
TPN_DEFAULT_INGRED_ITEM_ID | DOUBLE | N | The item_id for the default fill ingredient used when balancing the TPN order. |
TPN_FILL_METHOD_CD | DOUBLE | N | Indicates the method used for calculating volume in a TPN order. |
TPN_FILTER_IND | DOUBLE | Y | Indicator that product is built as a TPN type product |
TPN_INCLUDE_IONS_FLAG | DOUBLE | Y | Indicates whether ions contributed by ordered products should be included in the TPN balance. |
TPN_OVERFILL_AMT | DOUBLE | Y | Amount of overfill to be added to the TPN order. |
TPN_OVERFILL_UNIT_CD | DOUBLE | N | The unit of measure for the volume to be added to the TPN order. Associated with column tpn_overfill_amt. |
TPN_PREFERRED_CATION_CD | DOUBLE | N | Indicates which cation is preferred during the balancing of the TPN order. |
TPN_PRODUCT_TYPE_FLAG | DOUBLE | Y | This flag indicates the product type for TPN products. |
TPN_SCALE_FLAG | DOUBLE | Y | This flag indicates whether the TPN product's volume is included in the order's overfill volume. |
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. |
USED_AS_BASE_IND | DOUBLE | Y | Indicates whether this product can be ordered as a base solution. |
VOLUME | DOUBLE | Y | Volume of the product per unit dispense quantity. |
VOLUME_UNIT_CD | DOUBLE | N | Volume unit of the dispensed product per unit dispense quantity. |
WASTE_CHARGE_IND | DOUBLE | N | Tells whether waste charge is enabled at Product/Facility level. |
WITNESS_ADHOC_IND | DOUBLE | N | Value of 1 indicates this medication requires a witness to perform an Ad Hoc Transaction. |
WITNESS_ADHOC_REFILL_IND | DOUBLE | N | Indicates if this medication requires a witness when performing an ad hoc refill. |
WITNESS_DISPENSE_IND | DOUBLE | N | Value of 1 indicates this medication requires a witness to perform a Dispense transaction. |
WITNESS_EMPTY_RETURN_IND | DOUBLE | N | Indicates if this medication requires a witness when performing an Empty return. |
WITNESS_EXPIRE_MGMT_IND | DOUBLE | N | Indicates whether this medication requires a witness to perform expiration management. |
WITNESS_INV_COUNT_IND | DOUBLE | N | Indicates whether this medication requires a witness to perform an inventory count. |
WITNESS_OVERRIDE_IND | DOUBLE | N | Value of 1 indicates this medication requires a witness to perform an Override transaction. |
WITNESS_RETURN_IND | DOUBLE | N | Value of 1 indicates this medication requires a witness to perform a Return transaction. |
WITNESS_SCHED_TASK_IND | DOUBLE | N | Indicates if this medication requires a witness when performing a scheduled task. |
WITNESS_WASTE_IND | DOUBLE | N | Value of 1 indicates this medication requires a witness to perform a Waste transaction. |
WORKFLOW_CD | DOUBLE | N | The dispense sequence associated to the product which is used to route orders to the dispense monitor. |
Relationship Detail - MED_DISPENSE
Child Column in MED_DISPENSE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ITEM_ID | ITEM_DEFINITION | ITEM_ID |
RX_STATION_NOTES_ID | LONG_TEXT_REFERENCE | LONG_TEXT_ID | |
MED_PACKAGE_TYPE_ID | MED_PACKAGE_TYPE | MED_PACKAGE_TYPE_ID | |
PACKAGE_TYPE_ID | PACKAGE_TYPE | PACKAGE_TYPE_ID |
MED_FLEX_OBJECT_IDX
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Med_flex_object_idx |
Definition: | The Med_flex_object_idx file stores the relationships of various flexed entities and their components. |
Table Type: | REFERENCE |
Column Detail - MED_FLEX_OBJECT_IDX
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. |
FLEX_OBJECT_TYPE_CD | DOUBLE | N | flexobjecttypecd |
MED_DEF_FLEX_ID | DOUBLE | N | med defin flex id |
MED_FLEX_OBJECT_ID | DOUBLE | N | med_flex_object_id |
PARENT_ENTITY_ID | DOUBLE | N | parent entity id |
PARENT_ENTITY_NAME | VARCHAR(32) | Y | parent entity name |
SEQUENCE | DOUBLE | N | sequence |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
VALUE | DOUBLE | Y | If the item on med_flex_object_idx has a value it is stored here. An example would be the amount of an attribute supplied by a product. |
VALUE_UNIT | DOUBLE | Y | If the item on med_flex_object_idx has a value it is stored here in units. An example would be the amount of an attribute supplied by a product. |
Relationship Detail - MED_FLEX_OBJECT_IDX
Child Column in MED_FLEX_OBJECT_IDX(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | MED_DEF_FLEX_ID | MED_DEF_FLEX | MED_DEF_FLEX_ID |