Table Detail Report
RX_WS_FAC_RELTN_HX
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Pharmacy Worksheet Facility Relation History |
Definition: | Contains historical reference data about Worksheets at a location. A worksheet is created in the RX_WS table. When it is approved there, a row is written to this RX_WS_FAC_RELTN_HX table. A row in this table signifies that a worksheet is available for use. |
Table Type: | REFERENCE |
Column Detail - RX_WS_FAC_RELTN_HX
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. |
APPROVED_DT_TM | DATETIME | Y | Date/time the worksheet was approved for actual use. |
APPROVED_PRSNL_ID | DOUBLE | N | The person who approved the worksheet for actual use. |
APPROVED_TZ | DOUBLE | N | Time zone associated with APPROVED_DT_TM. |
FAC_CD | DOUBLE | N | The facility that the Pharmacy Worksheet is valid for. |
LABEL_FORMAT_CD | DOUBLE | N | The label associated to the Pharmacy Worksheet. |
LABOR_COST_AMT | DOUBLE | N | The total cost of the labor required to create the parent item. |
LABOR_NBR | DOUBLE | N | The amount of time that is required to create the parent item. |
LABOR_RATIO_IND | DOUBLE | N | Indicates whether the labor and labor costs are directly associated to the number of items created. |
LABOR_UNIT_CD | DOUBLE | N | The unit for the amount of time that is required to create the parent item. |
MAINTAIN_RATIO_IND | DOUBLE | N | Indicates whether or not the quantity created by the worksheet is directly related to the child item quantities for the parent item. |
MIXING_INSTR_TEXT_ID | DOUBLE | N | The mixing instructions required to create the parent item. |
PARENT_ITEM_ID | DOUBLE | N | The item that is created by the worksheet. |
PHARMACY_TYPE_CD | DOUBLE | N | Indicates the pharmacy type that the worksheet will be created for. |
REPORT_FORMAT_CD | DOUBLE | N | The report associated to the Pharmacy Worksheet. |
RX_WS_FAC_RELTN_HX_ID | DOUBLE | N | Unique, generated number that identifies a unique row on the RX_WS_FAC_RELTN_HX table. |
RX_WS_ID | DOUBLE | N | Identifies the worksheet that is valid at a specific location. |
SHELF_LIFE_NBR | DOUBLE | N | The amount of time that the parent item is good for. (Expiration Date) |
SHELF_LIFE_UNIT_CD | DOUBLE | N | The unit for the amount of time that the parent item is good for. |
TOTAL_QTY | DOUBLE | N | Indicates the amount of the parent item that will be created by the Pharmacy Worksheet. |
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. |
WS_BEGIN_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. |
WS_BEGIN_EFFECTIVE_TZ | DOUBLE | N | Time zone associated with WS_BEGIN_EFFECTIVE_DT_TM. |
WS_CD | DOUBLE | N | The code value for the Pharmacy Worksheet. |
WS_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. |
WS_END_EFFECTIVE_TZ | DOUBLE | N | Time zone associated with WS_END_EFFECTIVE_DT_TM. |
Relationship Detail - RX_WS_FAC_RELTN_HX
Child Column in RX_WS_FAC_RELTN_HX(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | FAC_CD | LOCATION | LOCATION_CD |
APPROVED_PRSNL_ID | PRSNL | PERSON_ID | |
RX_WS_ID | RX_WS | RX_WS_ID |
Parent Column in RX_WS_FAC_RELTN_HX (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | RX_WS_FAC_RELTN_HX_ID | RX_WF_WS | RX_WS_FAC_RELTN_HX_ID |
RX_WS_FAC_ITEM_HX | RX_WS_FAC_RELTN_HX_ID |
SCHEDULED_DAY_OF_WEEK
Column Section | Top of Page |
Table-level Detail
Description: | Days of weeks for frequencies |
Definition: | Scheduled day of week |
Table Type: | REFERENCE |
Column Detail - SCHEDULED_DAY_OF_WEEK
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVITY_TYPE_CD | DOUBLE | N | Used for flexing frequencies by department/activity. Default is activity_type_cd of 0, A given frequency will have 1 or more associated activity type codes it is valid for, each schedule will be specific to 1 activity_type |
DAY_OF_WEEK | DOUBLE | N | The day of the week that is attached to the frequency schedule. (1 = Sunday) |
EFFECTIVE_DT_TM | DATETIME | Y | Each instance for an ad hoc frequency will have an effective date for that instance. |
FACILITY_CD | DOUBLE | N | This column is used for flexing schedules by facility. |
FREQUENCY_CD | DOUBLE | N | Primary key. |
FREQ_QUALIFIER | DOUBLE | N | Primary KeyDefines the domain of ordering attributes which define the schedule for a specific order. |
INSTANCE | DOUBLE | N | Each time an ad hoc frequency is modified a new instance is generated and stored as an order deta |
PARENT_ENTITY | CHAR(32) | Y | Parent Entity name |
PARENT_ENTITY_ID | DOUBLE | N | Parent Entity ID for merge |
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. |
SCHEDULED_TIME_OF_DAY
Column Section | Top of Page |
Table-level Detail
Description: | Frequency times |
Definition: | Times of administration for frequencies |
Table Type: | REFERENCE |
Column Detail - SCHEDULED_TIME_OF_DAY
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVITY_TYPE_CD | DOUBLE | N | Used for flexing frequencies by department/activity. Default is activity_type_cd of 0, A given frequency will have 1 or more associated activity type codes it is valid for, each schedule will be specific to 1 activity_type |
EFFECTIVE_DT_TM | DATETIME | Y | Each instance for an ad hoc frequency will have an effective date for that instance. |
FACILITY_CD | DOUBLE | N | This column is used for flexing schedules by facility. |
FREQUENCY_CD | DOUBLE | N | Frequency code value |
FREQ_QUALIFIER | DOUBLE | N | Primary Key. Defines the domain of ordering attributes which define the schedule for a specific order. |
INSTANCE | DOUBLE | N | Each time an ad hoc frequency is modified a new instance is generated and stored as an order detail. |
PARENT_ENTITY | CHAR(32) | Y | Parent entity for merge |
PARENT_ENTITY_ID | DOUBLE | N | Parent Entity ID for merge |
TIME_OF_DAY | DOUBLE | N | The time of day that is attached to/ defines the frequency schedule. Value is stored in minutes since the time has no date component. |
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. |
SET_ITEM_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | SET ITEM R |
Definition: | IV and Order Set relationship table. |
Table Type: | REFERENCE |
Column Detail - SET_ITEM_R
Column Name | Type | Null? | Definition |
---|---|---|---|
COMMENT1_ID | DOUBLE | N | Long text id for IV set s Comment 1. |
COMMENT1_TYPE | DOUBLE | Y | Type for IV set's Comment 1. |
COMMENT2_ID | DOUBLE | N | Long text id for IV set's Comment 2. |
COMMENT2_TYPE | DOUBLE | Y | Type for IV set's Comment 2. |
COMMENT_ID | DOUBLE | N | Not in use. |
COMPONENT_ITEM_ID | DOUBLE | N | Key to medication_definition item for this component. |
COMPONENT_SEQUENCE | DOUBLE | N | Order this item should appear in the orderor set. |
DEFAULT_ACTION_CD | DOUBLE | N | Default action for this order (only applies to Order sets.) |
OE_FORMAT_FLAG | DOUBLE | Y | Default screen format that indicates if order is med, continuous, intermittent, or no default specified. |
ORDER_SENTENCE_ID | DOUBLE | N | order sentence for this IV set component |
SET_ITEM_ID | DOUBLE | N | Item ID that identifies the set. |
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 - SET_ITEM_R
Child Column in SET_ITEM_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DEFAULT_ACTION_CD | CODE_VALUE | CODE_VALUE |
STANDARDIZED_ORDER_DOSE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Standardized Order Dose |
Definition: | Standardized dose ranges for ordering pharmaceuticals. |
Table Type: | REFERENCE |
Column Detail - STANDARDIZED_ORDER_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 |
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_ORDER_DOSE_ID | DOUBLE | N | Identifies the standardized dose range for the ordering pharmaceutical |
STD_DOSE_UNIT_CD | DOUBLE | N | Unit of measure for standard dose |
STD_DOSE_VALUE | DOUBLE | N | The standard dose value |
SYNONYM_ID | DOUBLE | N | Identifies the order catalog synonym for the standardized order dose |
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_ORDER_DOSE
Child Column in STANDARDIZED_ORDER_DOSE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SYNONYM_ID | ORDER_CATALOG_SYNONYM | SYNONYM_ID |