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 |