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 |