Table Detail Report

ORDER_PROPOSAL_COMMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Proposal Comment
Definition: Stores comments associated with an order proposal
Table Type: ACTIVITY





Column Detail - ORDER_PROPOSAL_COMMENT


Column Name Type Null? Definition
COMMENT_TYPE_CD DOUBLE N Codified value indicating the type of comment associated with a proposal.
LONG_TEXT_ID DOUBLE N The long text id from the Long Text table.
ORDER_PROPOSAL_COMMENT_ID DOUBLE N Primary key of this table. It is internally assigned by the system.
ORDER_PROPOSAL_ID DOUBLE N The order proposal ID associated with this comment
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_COMMENT


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


ORDER_PROPOSAL_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Proposal Detail
Definition: This table stores all order details captured about an order proposal.
Table Type: ACTIVITY





Column Detail - ORDER_PROPOSAL_DETAIL


Column Name Type Null? Definition
DETAIL_ALTER_FLAG DOUBLE N For a proposal to create an order, this field is set to 2, which indicates this is a new detail. For a proposal to alter an order, the flag identifies how this detail relates to the order's detail that this proposal is for. 0 - Unchanged, 1 - Modify, 2 - Add, 3 - Delete.
DETAIL_DEFAULT_VALUE VARCHAR(255) Y The default value of the detail. This value represents a codified meaning which indicates the value that should be applied to the detail at the point of acceptance (ex. "T;N" represents current date/time when under consideration of being accepted) . If this field is valued, oe_field_display_value, oe_field_dt_tm_value, and oe_field_value will not be valued.
DETAIL_SEQUENCE DOUBLE N Signifies the order of the detail within the proposal. This is assigned by the system.
OE_FIELD_DISPLAY_VALUE VARCHAR(255) Y The display value of the order proposal detail.
OE_FIELD_DISPLAY_VALUE_EXTEND VARCHAR(4000) Y The extended display value of the order proposal detail.
OE_FIELD_DT_TM_VALUE DATETIME Y Date and time value captured by this detail. This is only filled out for date/time details
OE_FIELD_ID DOUBLE N This number uniquely identifies the order entry field. It is defined on the order_entry_fields table
OE_FIELD_MEANING VARCHAR(25) Y This is the meaning associated to the OE_Field_ID attribute. It is the text that describes the type of information that the detail captures.
OE_FIELD_MEANING_ID DOUBLE N This is the Cerner defined meaning ID associated to the OE_Field_ID. It identifies the type of information that the detail captures.
OE_FIELD_TZ DOUBLE Y The time zone associated to this date/time detail. This is only filled out for date/time details. For the order detail tables, it can either represent the user's or the patients (facility location) timezone, depending on the type of concept that detail is meant to store.
OE_FIELD_VALUE DOUBLE Y Numeric value captured by this detail. This could be a codified value or a simple numeric value.
ORDER_PROPOSAL_DETAIL_ID DOUBLE N The primary key of this table. It is internally generated by the system.
ORDER_PROPOSAL_ID DOUBLE N The order proposal ID associated with this detail.
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_DETAIL


Child Column in ORDER_PROPOSAL_DETAIL(FK) Parent Table Name Parent Column Name
Parents: OE_FIELD_MEANING_ID OE_FIELD_MEANING OE_FIELD_MEANING_ID
OE_FIELD_ID ORDER_ENTRY_FIELDS OE_FIELD_ID
ORDER_PROPOSAL_ID ORDER_PROPOSAL ORDER_PROPOSAL_ID




Parent Column in ORDER_PROPOSAL_DETAIL (PK) Child Table Name Child Column Name
Children: ORDER_PROPOSAL_DETAIL_ID ORDER_PROPOSAL_DETAIL_HST ORDER_PROPOSAL_DETAIL_ID


ORDER_PROPOSAL_DETAIL_HST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Proposal Detail History
Definition: The table will store order proposal details that are altered by the system from what the user entered.
Table Type: ACTIVITY





Column Detail - ORDER_PROPOSAL_DETAIL_HST


Column Name Type Null? Definition
DETAIL_ALTER_TRIGGER_CD DOUBLE N Codified value that indicates the trigger that altered details. e.g. Therapeutic Substitution.
OE_FIELD_DISPLAY_VALUE VARCHAR(255) Y The display value of the order proposal detail.
OE_FIELD_DT_TM_VALUE DATETIME Y Date and time value captured by this detail. This is only filled out for date/time details
OE_FIELD_TZ DOUBLE Y The time zone associated to this date/time detail. This is only filled out for date/time details
OE_FIELD_VALUE DOUBLE Y Numeric value captured by this detail. this could be a codified value or a simple numeric value.
ORDER_PROPOSAL_DETAIL_HST_ID DOUBLE N Unique generated number that identifies a single row on the ORDER_PROPOSAL_DETAIL_HST table.
ORDER_PROPOSAL_DETAIL_ID DOUBLE N The ID of the order proposal detail associated with this alteration.
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_DETAIL_HST


Child Column in ORDER_PROPOSAL_DETAIL_HST(FK) Parent Table Name Parent Column Name
Parents: ORDER_PROPOSAL_DETAIL_ID ORDER_PROPOSAL_DETAIL ORDER_PROPOSAL_DETAIL_ID


ORDER_PROPOSAL_DIAG_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Proposal Diagnosis Relation
Definition: This table stores attributes that are a part of the relationship between the Order _Proposal and Diagnosis tables.
Table Type: ACTIVITY





Column Detail - ORDER_PROPOSAL_DIAG_RELTN


Column Name Type Null? Definition
DIAGNOSIS_ALTER_FLAG DOUBLE N Identifies what type of diagnosis change it is. For a proposal to create an order this field is set to 1, which indicates it is a new diagnosis. 0 - Unchanged, 1 - Add, 2 - Modify, 3 - Delete
DIAGNOSIS_ID DOUBLE N This is the diagnosis ID from the Diagnosis table of the diagnosis associated with the order proposal.
ORDER_PROPOSAL_DIAG_RELTN_ID DOUBLE N This is the primary key of this table. It is assigned internally by the system.
ORDER_PROPOSAL_ID DOUBLE N This is the ID of the order proposal associated to this diagnosis.
RANK_SEQUENCE DOUBLE N This field captures how the diagnosis is ranked in relationship to the order proposal.
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_DIAG_RELTN


Child Column in ORDER_PROPOSAL_DIAG_RELTN(FK) Parent Table Name Parent Column Name
Parents: DIAGNOSIS_ID DIAGNOSIS DIAGNOSIS_ID
ORDER_PROPOSAL_ID ORDER_PROPOSAL ORDER_PROPOSAL_ID


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