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 |