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 |