Table Detail Report

ORDER_ENTRY_FORMAT_PARENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order entry format parent.
Definition: Stores the format that will be associated to an orderable to identify the information to be captured at order time.
Table Type: REFERENCE





Column Detail - ORDER_ENTRY_FORMAT_PARENT


Column Name Type Null? Definition
CATALOG_TYPE_CD DOUBLE N Codified value for order catalog type.
OE_FORMAT_ID DOUBLE N The unique identifier for the order entry format.
OE_FORMAT_NAME VARCHAR(200) N The name of the order entry format.
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_ENTRY_FORMAT_PARENT




Parent Column in ORDER_ENTRY_FORMAT_PARENT (PK) Child Table Name Child Column Name
Children: OE_FORMAT_ID ORDERS OE_FORMAT_ID
ORDER_CATALOG OE_FORMAT_ID
ORDER_PROPOSAL OE_FORMAT_ID
ORDER_SENTENCE OE_FORMAT_ID
SCH_APPT_TYPE OE_FORMAT_ID
SCH_REPORT OE_FORMAT_ID


ORDER_PRIORITY_FLEXING



Column Section Top of Page


Table-level Detail

Description: Controls how the priority order entry field behaves in Powerchart.
Definition: Controls how the priority order entry field behaves in Powerchart. Includes list filtering, default start date/time, and the ability to disable frequency and duration order entry fields based on which priority is selected.
Table Type: REFERENCE





Column Detail - ORDER_PRIORITY_FLEXING


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
DEFAULT_START_DT_TM VARCHAR(20) Y The string defining what the requested start date/time should be defaulted to when the user chooses this priority. Empty mean don't change it. ";" means empty out the date field. "T;N" means default it to the current date/time.
DISABLE_FREQ_IND DOUBLE Y This field defines whether the frequency and duration order entry fields are automatically disabled when the user chooses this priority.
OE_FORMAT_ID DOUBLE N The order entry format that this flexing record applies to.
ORDER_PRIORITY_FLEXING_ID DOUBLE N The system-assigned unique identifier for this record.
PRIORITY_CD DOUBLE N Priority code value that this flexing record applies to.
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.


ORDER_RESULTS_HOLD_CONFIG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Results Hold Configuration
Definition: Contains orders for which results should be put on hold.
Table Type: REFERENCE





Column Detail - ORDER_RESULTS_HOLD_CONFIG


Column Name Type Null? Definition
CATALOG_CD DOUBLE N The unique identifier for the order catalog from order_catalog_synonym table.
ENCOUNTER_TYPE_CLASS_CD DOUBLE N Categorizes the encounter into a logical group or type. Examples may include inpatient, outpatient, etc. Code Set: 69.
HOLD_FLAG DOUBLE N The indicator is set if the results should be put on hold. 0 - Do not hold; 1 - Hold
LOCATION_CD DOUBLE N The unique identifier for the location from location table. Location_cd could be either facility code or nurse unit code. It will be the location code at which the order catalog should be put on hold .
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
ORDER_RESULTS_HOLD_CONFIG_ID DOUBLE N Unique generated number that identifies a single row on the ORDER_RESULTS_HOLD_CONFIG 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_RESULTS_HOLD_CONFIG


Child Column in ORDER_RESULTS_HOLD_CONFIG(FK) Parent Table Name Parent Column Name
Parents: LOCATION_CD LOCATION LOCATION_CD
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
CATALOG_CD ORDER_CATALOG CATALOG_CD


ORDER_SENTENCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Sentence
Definition: Order sentence is used to default order detail values when user places order. Order_sentence table stores order sentences and their detail display lines.
Table Type: REFERENCE





Column Detail - ORDER_SENTENCE


Column Name Type Null? Definition
DISCERN_AUTO_VERIFY_FLAG DOUBLE N Flag representing current order catalog's auto verification settings for Discern Alerts. '0' = No Setting '1' = "No" - No auto verification performed. '2' = "No w/Clinical Checking" - If alerts exist, auto verification is not performed. '3' = "Yes w/Reason" - Only auto verify if a reason was provided with the alert(s).'4' = "Yes" - Auto verify regardless of alerts.
EXTERNAL_IDENTIFIER VARCHAR(50) Y External identifier defined by source creating order sentence (i.e., Multum). This value uniquely identifies a record when compared against the source.
IC_AUTO_VERIFY_FLAG DOUBLE N Flag representing current order catalog's auto verification settings for Interaction Checking. '0' = No Setting '1' = "No" - No auto verification performed. '2' = "No w/Clinical Checking" - If alerts exist, auto verification is not performed. '3' = "Yes w/Reason" - Only auto verify if a reason was provided with the alert(s).'4' = "Yes" - Auto verify regardless of alerts.
OE_FORMAT_ID DOUBLE N Used to trace which order entry format was used to build the order sentence
ORDER_ENCNTR_GROUP_CD DOUBLE N Used to associate order sentence with specific order encounter group.
ORDER_SENTENCE_DISPLAY_LINE VARCHAR(255) Y Order detail display line for the order sentence
ORDER_SENTENCE_ID DOUBLE N Primary identifier column
ORD_COMMENT_LONG_TEXT_ID DOUBLE N The order sentence comment of the order sentence.
PARENT_ENTITY2_ID DOUBLE N The unique identifier from the corresponding table name referenced in PARENT_ENTITY2_NAME for whichhe order sentence is stored.
PARENT_ENTITY2_NAME VARCHAR(30) Y The name of the reference table this order sentence is associated with. For example, ord_cat_sent_r, cs_component, etc.
PARENT_ENTITY_ID DOUBLE N The unique identifier from the corresponding table name referenced in PARENT_ENTITY_NAME for which the order sentence is stored.
PARENT_ENTITY_NAME VARCHAR(30) N The name of the reference table this order sentence is associated with. For example, ord_cat_sent_r, cs_component, etc.
RX_TYPE_MEAN VARCHAR(12) Y Pharmacy type of the order sentence. Values include: MED, DILUENT, ADDITIVE, SLIDINGSCALE
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.
USAGE_FLAG DOUBLE N Usage Flag



Relationship Detail - ORDER_SENTENCE


Child Column in ORDER_SENTENCE(FK) Parent Table Name Parent Column Name
Parents: OE_FORMAT_ID ORDER_ENTRY_FORMAT_PARENT OE_FORMAT_ID




Parent Column in ORDER_SENTENCE (PK) Child Table Name Child Column Name
Children: ORDER_SENTENCE_ID ACT_PW_COMP ORDER_SENTENCE_ID
ALT_SEL_LIST ORDER_SENTENCE_ID
CS_COMPONENT ORDER_SENTENCE_ID
MRU_LOOKUP_ORDER ORDER_SENTENCE_ID
ORDER_SENTENCE_DETAIL ORDER_SENTENCE_ID
ORDER_SENTENCE_FILTER ORDER_SENTENCE_ID
PATHWAY_COMP ORDER_SENTENCE_ID
PW_COMP_OS_RELTN ORDER_SENTENCE_ID
RX_AUTO_VERIFY_ING_AUDIT ORDER_SENTENCE_ID
RX_THERAP_SBSTTN_TO TO_ORDER_SENTENCE_ID
SCH_APPT_SYN ORDER_SENTENCE_ID
SCH_EVENT ORDER_SENTENCE_ID


ORDER_SENTENCE_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: The individual fields that make up the order sentence.
Definition: Order Sentence Detail
Table Type: REFERENCE





Column Detail - ORDER_SENTENCE_DETAIL


Column Name Type Null? Definition
DEFAULT_PARENT_ENTITY_ID DOUBLE Y The ID of the data to be used for the default value. If valued, this field should be the same as the oe_field_value for the record.
DEFAULT_PARENT_ENTITY_NAME VARCHAR(32) Y The table name where the default (for codesets and lists) is located, for example CODE_VALUE. This field is empty for oe fields with defaults that are not codes or IDs.
FIELD_TYPE_FLAG DOUBLE Y The data type for this field.
OE_FIELD_DISPLAY_VALUE VARCHAR(255) Y The displayable value for the order detail.
OE_FIELD_ID DOUBLE N The identifier of which order entry field this detail record is for.
OE_FIELD_MEANING_ID DOUBLE N Identifies what the order entry field is for (e.g. frequency, start date/time).
OE_FIELD_VALUE DOUBLE Y The numeric default value for the record. If this record is for a non-numeric or non-coded default value, this field will be zero.
ORDER_SENTENCE_ID DOUBLE N The identifier of the order sentence this detail record belongs to.
SEQUENCE DOUBLE N Sequence value
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_SENTENCE_DETAIL


Child Column in ORDER_SENTENCE_DETAIL(FK) Parent Table Name Parent Column Name
Parents: OE_FIELD_ID ORDER_ENTRY_FIELDS OE_FIELD_ID
ORDER_SENTENCE_ID ORDER_SENTENCE ORDER_SENTENCE_ID