Table Detail Report

STANDARDIZED_PHA_DOSE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Standardized Pharmacy Dose
Definition: Standardized dose ranges for ordering pharmaceuticals
Table Type: REFERENCE





Column Detail - STANDARDIZED_PHA_DOSE


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.
COMPARE_UNIT_CD DOUBLE N Unit of measure for comparison.
COMPARE_VALUE1 DOUBLE N First value to use in comparison
COMPARE_VALUE2 DOUBLE N Second value to use in comparison
ITEM_ID DOUBLE N Identifies the corresponding item definition for the standardized dose range
RELATIONAL_OPERATOR_FLAG DOUBLE N Identifies the relational operator for comparison with compare_value1 and compare_value2.
ROUTE_CD DOUBLE N Identifies a specific route of administration for medication.
STANDARDIZED_PHA_DOSE_ID DOUBLE N Standardized dose ranges for ordering pharmaceuticals
STD_DOSE_UNIT_CD DOUBLE N Unit of measure for standard dose
STD_DOSE_VALUE DOUBLE N The standard dose value
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 - STANDARDIZED_PHA_DOSE


Child Column in STANDARDIZED_PHA_DOSE(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_DEFINITION ITEM_ID


SUBSTANCE_PROPERTY



Column Section Top of Page


Table-level Detail

Description: SUBSTANCE_PROPERTY
Definition: Stores substance properties, such as attributes (ions) and intrinsics. Also stores atomic weights and valences.
Table Type: REFERENCE





Column Detail - SUBSTANCE_PROPERTY


Column Name Type Null? Definition
PROPERTY_CD DOUBLE N Code value for the property from code set 4700
PROPERTY_SOURCE_FLAG DOUBLE Y 0 = System defined; 1 = User defined
PROPERTY_TYPE_FLAG DOUBLE Y An attribute is a property of an ingredient that can be used in an order. An intrinsic is a feature of an ingredient that can be reported based on the amount of the ingredient ordered, but cannot be used to order the ingredient.
PROPERTY_WEIGHT DOUBLE N Molar mass weight of the property. This weight is the sum of neutrons and protons in the nucleus of the atom
SUBSTANCE_PROPERTY_ID DOUBLE N Unique identifier of the property
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.
VALENCE DOUBLE N Valence of the property. In chemistry, valence is a number representing the capacity of a single atom or radical to combine with other atoms or radicals.


SYNONYM_ITEM_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Synonym Item Relation
Definition: Creates a relationship between a synonym item and an item definition.
Table Type: REFERENCE





Column Detail - SYNONYM_ITEM_R


Column Name Type Null? Definition
ITEM_ID DOUBLE N Item id inherited from ITEM_MASTER.
SYNONYM_ID DOUBLE N The id of this synonym inherited from ORDER_CATALOG_SYNONYM.
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 - SYNONYM_ITEM_R


Child Column in SYNONYM_ITEM_R(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID MEDICATION_DEFINITION ITEM_ID
SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID


TEMPLATE_NONFORMULARY



Column Section Relationship Section Top of Page


Table-level Detail

Description: TEMPLATE NONFORMULARY
Definition: Order model tables for storing off adhoc orderables.
Table Type: ACTIVITY





Column Detail - TEMPLATE_NONFORMULARY


Column Name Type Null? Definition
ACTION_SEQUENCE DOUBLE N Action sequence of order.
COST DOUBLE Y Cost associated with a given formulary item
DESCRIPTION VARCHAR(100) Y Free-text description of the non-formulary item
LEGAL_STATUS_CD DOUBLE N Legal Status Code value
NDC VARCHAR(50) Y National Drug Code (US FDA) number assigned to this product
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 quantity of the product within a single package.
SHELL_ITEM_ID DOUBLE N Item_id of the non-formulary template.
TNF_ID DOUBLE N Unique identifier for this non-formulary item
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 - TEMPLATE_NONFORMULARY


Child Column in TEMPLATE_NONFORMULARY(FK) Parent Table Name Parent Column Name
Parents: SHELL_ITEM_ID ITEM_DEFINITION ITEM_ID