Table Detail Report
ORDER_PROPOSAL_INGREDIENT
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Order Proposal Ingredient |
| Definition: | The table is used to store ingredients associated with an order proposal. For new order proposals, all ingredients are being added. For proposals that end-state an order, no ingredients will be written. For proposals that alter an order (but do not end state it), ingredients can be added, removed, or modified. |
| Table Type: | ACTIVITY |
Column Detail - ORDER_PROPOSAL_INGREDIENT
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| BAG_FREQUENCY_CD | DOUBLE | N | Codified value to identify the bag frequency of this ingredient's occurrence. |
| CATALOG_CD | DOUBLE | N | The catalog code from the Order_Catalog table that is associated with this ingredient |
| CLINICALLY_SIGNIFICANT_FLAG | DOUBLE | N | Determines if the ingredient will be clinically significant to the order. 0 - Does not apply or not set, 1 - Not clinically significant, 2 - Clinically significant |
| COMP_SEQUENCE | DOUBLE | N | A system assigned number, identifying the order of the ingredient within the proposal. |
| CONCENTRATION | DOUBLE | N | The amount of the ingredient in a given volume. This will only be valued if there is a normalized rate supplied. |
| CONCENTRATION_UNIT_CD | DOUBLE | N | The unit of measure on the ingredient's concentration. |
| DAYS_OF_ADMINISTRATION_DISPLAY | VARCHAR(100) | Y | The textual display of the days of administration for an order proposal ingredient which had variable dosage amounts. This represents the abbreviated formatting of the days of week which is based on the locale of the user creating the order proposal. |
| DOSE_ADJUSTMENT_DISPLAY | VARCHAR(255) | Y | The textual display of the dose adjustment for an order proposal ingredient. This includes the adjustment percentage and reason for adjustment. The dose calculator text is paired with this field and needs to be considered usage of this field. |
| DOSE_CALCULATOR_LONG_TEXT_ID | DOUBLE | N | The associated LONG_TEXT information (in XML) captured by the dose calculator that contributes to the dosage calculation |
| DOSING_CAPACITY | DOUBLE | Y | Represents the total number of potential doses for a given day for variable dosing. For variable dosing, this will always be positive, otherwise it will be 0. |
| FREETEXT_DOSE | VARCHAR(255) | Y | Free text that can be input concerning a dose. It allows the user to write comments about the dose. |
| INCLUDE_IN_TOTAL_VOLUME_FLAG | DOUBLE | N | Determines if the ingredient is included in the total volume of an order. Valid flag values are: 0 - Not Set or Not Apply, 1 - Not contribute to total volume, 2 - Contribute to total volume. |
| INGREDIENT_ALTER_FLAG | DOUBLE | N | For proposals to create an order, this field is set to 1, which indicates this is a new ingredient. For a proposal to alter an order, the flag identifies how this ingredient relates to the order's ingredient that this proposal is for. 0 - Unchanged, 1 - Add, 2 - Modified, 3 - Delete. |
| INGREDIENT_DISPLAY_LINE | VARCHAR(255) | Y | This is the short description of the ingredient containing information such as dose. |
| INGREDIENT_SOURCE_FLAG | DOUBLE | N | Indicates whether the ingredient was added to the order proposal by a user or by the system. 0 - User, 1 - System Balanced, 2 - System auto product assign |
| INGREDIENT_TYPE_FLAG | DOUBLE | Y | Identifies the type of ingredient. 0 - Not set, 1 - Medication, 2 - Base, 3 - Additive, 4 - Compound parent, 5 - Compound child |
| NORMALIZED_RATE | DOUBLE | N | The amount of the ingredient to be administered per time unit or the amount of a medication to be administered per patient weight unit per time unit. |
| NORMALIZED_RATE_UNIT_CD | DOUBLE | N | The unit of measure of the normalized rate. |
| ORDERED_AS_MNEMONIC | VARCHAR(255) | Y | Text representing a name by which an ingredient was ordered. |
| ORDERED_DOSE | DOUBLE | N | The amount of dose that was ordered. |
| ORDERED_DOSE_UNIT_CD | DOUBLE | N | The unit of measure for the ordered dose. |
| ORDER_MNEMONIC | VARCHAR(255) | Y | The mnemonic of the order for the ingredients. |
| ORDER_PROPOSAL_ID | DOUBLE | N | The order proposal ID associated with this ingredient. |
| ORDER_PROPOSAL_INGREDIENT_ID | DOUBLE | N | The primary key of this table. It is internally assigned by the system. |
| STRENGTH | DOUBLE | Y | The strength of this ingredient |
| STRENGTH_UNIT_CD | DOUBLE | N | Codified unit of measure on strength of this ingredient. |
| 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. 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 | DOUBLE | Y | The volume of this ingredient. |
| VOLUME_UNIT_CD | DOUBLE | N | Codified unit of measure on strength for this ingredient. |
Relationship Detail - ORDER_PROPOSAL_INGREDIENT
| Child Column in ORDER_PROPOSAL_INGREDIENT(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | DOSE_CALCULATOR_LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID |
| CATALOG_CD | ORDER_CATALOG | CATALOG_CD | |
| SYNONYM_ID | ORDER_CATALOG_SYNONYM | SYNONYM_ID | |
| ORDER_PROPOSAL_ID | ORDER_PROPOSAL | ORDER_PROPOSAL_ID |
| Parent Column in ORDER_PROPOSAL_INGREDIENT (PK) | Child Table Name | Child Column Name | |
|---|---|---|---|
| Children: | ORDER_PROPOSAL_INGREDIENT_ID | ORDER_PROPOSAL_INGRED_DOSE | ORDER_PROPOSAL_INGREDIENT_ID |
| ORDER_PROPOSAL_INGRED_HST | ORDER_PROPOSAL_INGREDIENT_ID |
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 |