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