Table Detail Report

ORDER_PROPOSAL_INGRED_DOSE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Proposal Ingredient Dose
Definition: Stores the dosing information for an order proposal ingredient when the dose may vary per administration.
Table Type: ACTIVITY





Column Detail - ORDER_PROPOSAL_INGRED_DOSE


Column Name Type Null? Definition
DOSE_SEQUENCE DOUBLE N The sequence of the dose of the related order proposal ingredient component. For variable dose ingredients, this dose sequence will resemble a dose's position in regards of a static capacity (i.e. third dose of four doses).
ORDERED_DOSE_TYPE_FLAG DOUBLE N Flag that indicates the type of dosing the ordered dose represents. Valid values: 1 - Ordered dose was entered as a strength dose, 2 - Ordered dose was entered as a volume dose.
ORDERED_DOSE_UNIT_CD DOUBLE N The codified value of the unit of measure associated to the ordered dose. This value will exist if the ordered dose value exists.
ORDERED_DOSE_VALUE DOUBLE N The value of the ordered dose for the given order ingredient dose instance.
ORDERED_DOSE_VALUE_DISPLAY VARCHAR(100) N The textual display of the ordered dose value for the given order proposal ingredient dose instance. This represents the numeric display formatting which relates to the locale of the user performing the order proposal action. If the ordered dose exists, this display value will exist and should be used for any display purposes.
ORDER_PROPOSAL_INGREDIENT_ID DOUBLE N The ID of the related order_proposal_ingredient.
ORDER_PROPOSAL_INGRED_DOSE_ID DOUBLE N Unique generated number that identifies a single row on the ORDER_PROPOSAL_INGRED_DOSE table.
SCHEDULE_SEQUENCE DOUBLE N The sequence of the related frequency schedule which this order proposal ingredient dose instance represents. This sequence will always be populated for variable dosing (determined by dosing_method_flag of ORDER_PROPOSAL table).
STRENGTH_DOSE_UNIT_CD DOUBLE Y The codified value of the unit of measure associated to the strength dose for the given order proposal ingredient dose instance. This value will exist if the strength dose value exists.
STRENGTH_DOSE_VALUE DOUBLE Y The value of the strength dose for the given order proposal ingredient dose instance.
STRENGTH_DOSE_VALUE_DISPLAY VARCHAR(100) Y The textual display of the strength dose value for the given order proposal ingredient dose instance. This represents the numeric display formatting which relates to the locale of the user performing the order proposal action. If the strength dose exists, this display value will exist and should be used for any display purposes.
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.
VOLUME_DOSE_UNIT_CD DOUBLE Y The codified value of the unit of measure associated to the volume dose for the order proposal ingredient dose instance. This value will exist if the volume dose value exists.
VOLUME_DOSE_VALUE DOUBLE Y The value of the volume dose for the given order proposal ingredient dose instance.
VOLUME_DOSE_VALUE_DISPLAY VARCHAR(100) Y The textual display of the volume dose value for the given order proposal ingredient dose instance. This represents the numeric display formatting which relates to the locale of the user performing the order proposal action. If the volume dose exists, this display value will exist and should be used for any display purposes.



Relationship Detail - ORDER_PROPOSAL_INGRED_DOSE


Child Column in ORDER_PROPOSAL_INGRED_DOSE(FK) Parent Table Name Parent Column Name
Parents: ORDER_PROPOSAL_INGREDIENT_ID ORDER_PROPOSAL_INGREDIENT ORDER_PROPOSAL_INGREDIENT_ID


ORDER_PROPOSAL_INGRED_HST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Proposal Ingredient History
Definition: This table will store a history of the ingredients for an order proposal when they are replaced with a different ingredient by the system.
Table Type: ACTIVITY





Column Detail - ORDER_PROPOSAL_INGRED_HST


Column Name Type Null? Definition
FREETEXT_DOSE VARCHAR(255) Y Free text that can be input concerning a dose. allows the user to write comments about the dose.
INGREDIENT_ALTER_TRIGGER_CD DOUBLE N This is a codified value that indicates what triggered the system to alter the ingredient. for example, therapeutic interchange - therapintrch.
ORDER_PROPOSAL_INGREDIENT_ID DOUBLE N The ID of the order proposal ingredient associated with this alteration.
ORDER_PROPOSAL_INGRED_HST_ID DOUBLE N Unique generated number that identifies a single row on the ORDER_PROPOSAL_INGRED_HST table.
STRENGTH DOUBLE Y The strength of this ingredient. If specified, a Strength Unit Cd must be supplied.
STRENGTH_UNIT_CD DOUBLE N Codified unit of measure on strength for this ingredient. If specified, a Strength must be supplied.
SYNONYM_ID DOUBLE N The ID of the order catalog synonym for this ingredient.
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.
VOLUME DOUBLE Y Volume of this ingredient. If specified, a Volume Unit Cd must be supplied.
VOLUME_UNIT_CD DOUBLE N Codified unit of measure on volume for this ingredient. If specified, a Volume must be supplied.



Relationship Detail - ORDER_PROPOSAL_INGRED_HST


Child Column in ORDER_PROPOSAL_INGRED_HST(FK) Parent Table Name Parent Column Name
Parents: SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID
ORDER_PROPOSAL_INGREDIENT_ID ORDER_PROPOSAL_INGREDIENT ORDER_PROPOSAL_INGREDIENT_ID


ORDER_PROPOSAL_NOTIF



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Proposal Notification
Definition: This table stores notifications to inform users of proposed actions on orders.
Table Type: ACTIVITY





Column Detail - ORDER_PROPOSAL_NOTIF


Column Name Type Null? Definition
ASSIGNED_PRSNL_ID DOUBLE N The identifier of the personnel who is assigned to the notification from within the personnel group context.
FROM_PRSNL_GROUP_ID DOUBLE N The identifier of the personnel group which a personnel acted from when forwarding an order proposal notification.
FROM_PRSNL_ID DOUBLE N The identifier of the personnel which created the notification by acting on an order proposal or forwarding an existing notification.
NOTIFICATION_COMMENT VARCHAR(1000) Y The free text comment that is supplied by the user to communicate details of the notification.
NOTIFICATION_CREATED_DT_TM DATETIME N The date/time when the notification was created.
NOTIFICATION_CREATED_TZ DOUBLE Y Time zone associated with the notification creation date/time.
NOTIFICATION_ORIGIN_FLAG DOUBLE N Illustrates the origin of the notification creation. Value flag values are: 1 - Newly created based on an action on an order proposal, 2 - Forwarded from an existing notification
NOTIFICATION_RESOLVED_DT_TM DATETIME Y The date/time when the notification was resolved (accepted, rejected, forwarded, or is no longer needed).
NOTIFICATION_RESOLVED_TZ DOUBLE Y Time zone associated with the notification resolved date/time.
NOTIFICATION_STATUS_FLAG DOUBLE N Illustrates the current status of the order proposal notification. Valid flag values are: 1 - Pending, 2 - Accepted, 3 - Rejected, 4 - Forwarded, 5 - No Longer Needed, 6 - No Longer Needed due to Withdraw.
NOTIFICATION_TYPE_FLAG DOUBLE N Illustrates the type of notification. Valid flag values are: 1 - Order Proposal Creation Notification.
ORDER_PROPOSAL_ID DOUBLE N The identifier of the order proposal which is associated to the notification.
ORDER_PROPOSAL_NOTIF_ID DOUBLE N The primary key of this table. It is internally assigned by the system.
PARENT_OP_NOTIFICATION_ID DOUBLE N The identifier of the parent order proposal notification if the notification originated from a forward action.
TO_PRSNL_GROUP_ID DOUBLE N The identifier of the personnel group which the notification is intended for.
TO_PRSNL_ID DOUBLE N The identifier of the personnel which the notification is intended for.
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 - ORDER_PROPOSAL_NOTIF


Child Column in ORDER_PROPOSAL_NOTIF(FK) Parent Table Name Parent Column Name
Parents: ORDER_PROPOSAL_ID ORDER_PROPOSAL ORDER_PROPOSAL_ID
PARENT_OP_NOTIFICATION_ID ORDER_PROPOSAL_NOTIF ORDER_PROPOSAL_NOTIF_ID
ASSIGNED_PRSNL_ID PRSNL PERSON_ID
FROM_PRSNL_ID PRSNL PERSON_ID
TO_PRSNL_ID PRSNL PERSON_ID
FROM_PRSNL_GROUP_ID PRSNL_GROUP PRSNL_GROUP_ID
TO_PRSNL_GROUP_ID PRSNL_GROUP PRSNL_GROUP_ID




Parent Column in ORDER_PROPOSAL_NOTIF (PK) Child Table Name Child Column Name
Children: ORDER_PROPOSAL_NOTIF_ID ORDER_PROPOSAL_NOTIF PARENT_OP_NOTIFICATION_ID


ORDER_PROPOSAL_THER_SBSTTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Proposal Therapeutic Substitution
Definition: This table stores the therapeutic substitution information for an order proposal at the ingredient level. When a therapeutic substitution rule is accepted, overridden, or an alternate regimen is applied to an order proposal, a row will be added to this table.
Table Type: ACTIVITY





Column Detail - ORDER_PROPOSAL_THER_SBSTTN


Column Name Type Null? Definition
COMP_SEQUENCE DOUBLE N System assigned number, identifying the order of the ingredient within the proposal where substitution occurred.
ORDER_PROPOSAL_ID DOUBLE N The ID of the order proposal associated with this substitution.
ORDER_PROPOSAL_THER_SBSTTN_ID DOUBLE N Unique generated number that identifies a single row on the ORDER_PROPOSAL_THER_SBSTTN table.
OVERRIDE_REASON_CD DOUBLE N Codified value for the reason the therapeutic substitution was overridden. When a therapeutic substitution is accepted or an alternate regiment is applied, this field will be 0. If the therapeutic substitution is overridden, this field must contain the reason code value.
SUBSTITUTION_ACCEPT_FLAG DOUBLE N The flag to indicate whether the therapeutic substitution was accepted or overridden. The possible values are 1 = accept, 2 = override, and 3 = alternate regimen.
THERAP_SBSTTN_ID DOUBLE N The ID of the therapeutic substitution rule applied to the order proposal. The field will be 0 if the substitution rule is overridden. If the substitution rule is accepted or an alternate regimen is applied, this field should contain a unique identifier from the rx_therap_sbsttn table.
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 - ORDER_PROPOSAL_THER_SBSTTN


Child Column in ORDER_PROPOSAL_THER_SBSTTN(FK) Parent Table Name Parent Column Name
Parents: ORDER_PROPOSAL_ID ORDER_PROPOSAL ORDER_PROPOSAL_ID


ORDER_REVIEW



Column Section Relationship Section Top of Page


Table-level Detail

Description: ORDER REVIEW
Definition: Contains records of all orders needing a review, cosign, verify
Table Type: ACTIVITY





Column Detail - ORDER_REVIEW


Column Name Type Null? Definition
ACTION_SEQUENCE DOUBLE N Which action sequence the comment goes with
DEPT_CD DOUBLE N The department order status. This column is not used.
DIGITAL_SIGNATURE_IDENT VARCHAR(64) Y Generated by the DMS interface, this identifier uniquely associates the order action taken by a caregiver with the recorded digitally-signed data.
LOCATION_CD DOUBLE N Location code is needed for nurse-review
ORDER_ID DOUBLE N The order number being reviewed.
ORIGINATING_ACTION_SEQUENCE DOUBLE Y The action to which the review is associated; may be different than the action that created it (action sequence).
PROVIDER_ID DOUBLE N ID of provider that needs to review order
PROXY_PERSONNEL_ID DOUBLE N Who has proxy for review
PROXY_REASON_CD DOUBLE N Why they have proxy
REJECT_REASON_CD DOUBLE N Why they are rejecting
REVIEWED_STATUS_FLAG DOUBLE Y Flag to tell the status of the review. 0 - Not reviewed, 1 - Accepted, 2 - Rejected, 3 - No longer needing review., 4 - Superseded, 5 - Reviewed, 6 - Admin Closed Review
REVIEW_DT_TM DATETIME Y Date it was reviewed
REVIEW_GRP_VALUE DOUBLE Y Groups multiple reviews of the same type across multiple orders that are representative of a single action causing all of the reviews. Review groups are currently only applicable for grouped reviews of protocol and day of treatment orders. If the review is not part of a group, this field will be null.
REVIEW_PERSONNEL_ID DOUBLE N Personnel Id that reviews row
REVIEW_REQD_IND DOUBLE Y Used to indicate whether a review is required or not.
REVIEW_SEQUENCE DOUBLE N Used to sequence the reviews.
REVIEW_TYPE_FLAG DOUBLE Y The type of review. 0 - None, 1 - Nurse, 2 - Doctor, 3 - Rx, 4 - Physician Activate, 5 - Clinical Review
REVIEW_TZ DOUBLE Y Time zone associated with the corresponding Review_DT_TM column.
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 - ORDER_REVIEW


Child Column in ORDER_REVIEW(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID
PROVIDER_ID PRSNL PERSON_ID
REVIEW_PERSONNEL_ID PRSNL PERSON_ID




Parent Column in ORDER_REVIEW (PK) Child Table Name Child Column Name
Children: ACTION_SEQUENCE ORDER_REVIEW_ATTRIBUTE ACTION_SEQUENCE
ORDER_ID ORDER_REVIEW_ATTRIBUTE ORDER_ID
REVIEW_SEQUENCE ORDER_REVIEW_ATTRIBUTE REVIEW_SEQUENCE