Table Detail Report
OC_MULTI_PHARMACY_REVIEW
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Order Catalog Multi Pharmacy Review |
Definition: | Table used to store the multiple pharmacy review required indicator of Order Catalog. |
Table Type: | REFERENCE |
Column Detail - OC_MULTI_PHARMACY_REVIEW
Column Name | Type | Null? | Definition |
---|---|---|---|
CATALOG_CD | DOUBLE | N | Identifies the orderable item. Foreign Key from ORDER_CATALOG table. |
MULTIPLE_PHARMACY_REVIEW_IND | DOUBLE | N | Stores the multiple pharmacy review indicator. 0 indicates that catalog is not eligible for Multiple pharmacy review, 1 indicates that catalog is eligible for Multiple pharmacy review. |
OC_MULTI_PHARMACY_REVIEW_ID | DOUBLE | N | Unique generated number that identifies a single row on the OC_MULTI_PHARMACY_REVIEW 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 - OC_MULTI_PHARMACY_REVIEW
Child Column in OC_MULTI_PHARMACY_REVIEW(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CATALOG_CD | ORDER_CATALOG | CATALOG_CD |
OE_FIELD_MEANING
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | OE Field Meaning |
Definition: | OE Field Meaning |
Table Type: | REFERENCE |
Column Detail - OE_FIELD_MEANING
Column Name | Type | Null? | Definition |
---|---|---|---|
DESCRIPTION | VARCHAR(200) | Y | textual description |
OE_FIELD_MEANING | VARCHAR(25) | N | OE Field Meaning |
OE_FIELD_MEANING_ID | DOUBLE | N | OE Field Meaning Identifier. The value for this column does not come from an Oracle sequence. It is loaded via a CSV. |
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 - OE_FIELD_MEANING
Parent Column in OE_FIELD_MEANING (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | OE_FIELD_MEANING_ID | ORDER_DETAIL_HISTORY | OE_FIELD_MEANING_ID |
ORDER_PROPOSAL_DETAIL | OE_FIELD_MEANING_ID | ||
PM_PSO_LINK | OE_FIELD_MEANING_ID | ||
RX_MED_ORD_DETAIL | OE_FIELD_MEANING_ID | ||
SCH_DETAIL | OE_FIELD_MEANING_ID | ||
SCH_PEND_EVENT_DETAIL | OE_FIELD_MEANING_ID | ||
SCH_PEND_ORDER_DETAIL | OE_FIELD_MEANING_ID | ||
SCH_REF_DETAIL | OE_FIELD_MEANING_ID |
OE_FORMAT_FIELDS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Order Entry Format Fields |
Definition: | Table stores all the fields that will be placed on an order entry format. |
Table Type: | REFERENCE |
Column Detail - OE_FORMAT_FIELDS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCEPT_FLAG | DOUBLE | Y | Flag describes whether the field is accepted or not and how. 0 - Required, 1 - Optional, 2 - No Display, 3 - Display Only |
ACTION_TYPE_CD | DOUBLE | N | The type of action to associate this field to the format with. |
CARRY_FWD_PLAN_IND | DOUBLE | N | Indicates whether to bring forward the value of this field from one order to the next for PowerPlans. The "field" is the front end format field which in relation to this table is the entire row of this table. A good example would be a Dose field. 1 - Carry Forward, 0- Do not Carry Forward |
CLIN_LINE_IND | DOUBLE | Y | An indicator on whether to show this field on the clinical display line. |
CLIN_LINE_LABEL | VARCHAR(25) | Y | The label to be shown with the field value on the clinical line. |
CLIN_SUFFIX_IND | DOUBLE | Y | An indicator on whether to show the clinical line label as a suffix to the field value. |
CORE_IND | DOUBLE | Y | A core field will require the eco server to re-explode orders |
DEFAULT_PARENT_ENTITY_ID | DOUBLE | N | The identifier for the default value, if the default value is coded. This field will be empty (zero) for non-coded defaults. |
DEFAULT_PARENT_ENTITY_NAME | VARCHAR(32) | Y | The name of the table that the coded default value is from. This field will be empty for non-coded defaults. |
DEFAULT_VALUE | VARCHAR(100) | Y | The default value to be used for this field. |
DEF_PREV_ORDER_IND | DOUBLE | Y | An indicator on whether to bring forward the value of this field from one order to the next. |
DEPT_LINE_IND | DOUBLE | Y | An indicator on whether to show this field on the department display line. |
DEPT_LINE_LABEL | VARCHAR(25) | Y | The label to show with the field value on the department display line. |
DEPT_SUFFIX_IND | DOUBLE | Y | An indicator on whether to show the department line label as a suffix to the field value. |
DISP_DEPT_YES_NO_FLAG | DOUBLE | Y | A flag on whether to show all positive and negative responses to a YES/NO field on the dept displayline. 0 - Display Yes/No, 1 - Display Yes, 2 - Display No |
DISP_YES_NO_FLAG | DOUBLE | Y | A flag on whether to show the positive/negative responses to a YES/NO field on the clinical displayline. 0 - Display Yes/No, 1 - Display Yes, 2 - Display No. |
EPILOG_METHOD | DOUBLE | Y | For future use. |
FIELD_SEQ | DOUBLE | Y | A sequence number identifying the order of all the fields that have been grouped together using thegroup sequence. |
FILTER_PARAMS | VARCHAR(255) | Y | Filter parameters order detail list boxes. |
GROUP_SEQ | DOUBLE | Y | A sequence number used to identify the ordering of fields on the format. |
INPUT_MASK | VARCHAR(50) | Y | For future use |
LABEL_TEXT | VARCHAR(200) | Y | The label that should be displayed for this field. |
LOCK_ON_MODIFY_FLAG | DOUBLE | N | Indicates if a detail is to be locked for a modify action. A 0 indicates that the detail is not locked and the accept_flag will be honored. 0 - Not locked, 1 - Locked. |
MAX_NBR_OCCUR | DOUBLE | Y | The maximum number of times this field can appear on the format. |
OE_FIELD_ID | DOUBLE | N | The id of the field. |
OE_FORMAT_ID | DOUBLE | N | The id of the format. |
PROLOG_METHOD | DOUBLE | Y | For future use. |
REQUIRE_COSIGN_IND | DOUBLE | Y | An indicator on whether this field, if changed, should cause the cosign logic to be checked. |
REQUIRE_REVIEW_IND | DOUBLE | Y | Requires a nurse to review an order placed. Keeps an order in a Pending Review status. |
REQUIRE_VERIFY_IND | DOUBLE | Y | Requires Pharmacist to verify an order. In On Hold status until it is verified. |
STATUS_LINE | VARCHAR(200) | Y | A display line of information about the field. |
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. |
VALUE_REQUIRED_IND | DOUBLE | Y | An indicator on whether the field has to have a value entered. |
Relationship Detail - OE_FORMAT_FIELDS
Child Column in OE_FORMAT_FIELDS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ACTION_TYPE_CD | ORDER_ENTRY_FORMAT | ACTION_TYPE_CD |
OE_FORMAT_ID | ORDER_ENTRY_FORMAT | OE_FORMAT_ID |
ORDER_CATALOG
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | ORDER CATALOG |
Definition: | Stores the orderables for a site |
Table Type: | REFERENCE |
Column Detail - ORDER_CATALOG
Column Name | Type | Null? | Definition |
---|---|---|---|
ABN_REVIEW_IND | DOUBLE | Y | Indicator for PathNet |
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. |
ACTIVITY_SUBTYPE_CD | DOUBLE | N | Stores the code value for the activity sub-type that is used to filter order catalog items within activity type |
ACTIVITY_TYPE_CD | DOUBLE | N | Stores the code value for the activity type that is used to filter order catalog items within catalog type |
AUTO_CANCEL_IND | DOUBLE | Y | If auto_cancel_ind is 1, it can be automatically cancelled when a patient is discharged. |
BILL_ONLY_IND | DOUBLE | Y | Indicator on whether this is a bill only orderable. |
CATALOG_CD | DOUBLE | N | Used to store the internal code for the order catalog item |
CATALOG_TYPE_CD | DOUBLE | N | Used to store the internal code for the catalog type. Used as a filtering mechanism for rows on theorder catalog table |
CKI | VARCHAR(255) | Y | For Meds Processing |
COMMENT_TEMPLATE_FLAG | DOUBLE | Y | Flag to indicate that a comment template exists for the orderable. |
COMPLETE_UPON_ORDER_IND | DOUBLE | Y | Indicator on whether to complete this orderable automatically when it is ordered. |
CONCEPT_CKI | VARCHAR(255) | Y | Concept CKI is the functional Concept Identifier; it is the codified means within Millennium to identify key medical concepts to support information processing, clinical decision support, executable knowledge and knowledge presentation. |
CONSENT_FORM_FORMAT_CD | DOUBLE | N | The code value identifying the CONSENT FORM FORMAT |
CONSENT_FORM_IND | DOUBLE | Y | Indicator on whether to print a consent form for this orderable. |
CONSENT_FORM_ROUTING_CD | DOUBLE | N | The consent form routing id to use for this orderable. It comes from dcp_output_route_id in dcp_output_route table. |
CONT_ORDER_METHOD_FLAG | DOUBLE | Y | Flag to define what type of continuing order this orderable should be. |
CS_INDEX_CD | DOUBLE | N | The type of indexing to use for this orderable if it is a careset |
DCP_CLIN_CAT_CD | DOUBLE | N | The clinical category for this orderable. |
DC_DISPLAY_DAYS | DOUBLE | Y | How long to display after it has been discontinued |
DC_INTERACTION_DAYS | DOUBLE | Y | How many days it will have an interaction after it has been discontinued |
DEPT_DISPLAY_NAME | VARCHAR(100) | Y | Used to store the preferred display name used by departmental applications using the order catalog table |
DEPT_DUP_CHECK_IND | DOUBLE | Y | Used to indicate if departmental dup checking information has been specified for the order catalog item in the dept_dup_check table |
DESCRIPTION | VARCHAR(100) | Y | The description of the Orderable |
DISABLE_ORDER_COMMENT_IND | DOUBLE | Y | Used to disable order comment. |
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. |
DOSING_ACT_INGRED_CODE | DOUBLE | Y | User selected active ingredient code from the MLTM_NDC_ACT_INGRED_LIST table. |
DOSING_ALL_INGRED_IND | DOUBLE | N | Indicate strength dose is calculated based on all ingredients. If this field is set to 1, the dosing_act_ingred_code field will be cleared. |
DUP_CHECKING_IND | DOUBLE | Y | Indicator on whether or not to do duplicate checking. |
EVENT_CD | DOUBLE | N | Code for the type of event related to the order catalog. |
FORM_ID | DOUBLE | N | Holds the ID of the form to be displayed for this orderable. |
FORM_LEVEL | DOUBLE | Y | A preference will be used to control what level of forms to display for a posit. Arbitrary "importance" level. |
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. |
INST_RESTRICTION_IND | DOUBLE | Y | Future Function |
MODIFIABLE_FLAG | DOUBLE | Y | Used for multi-ingredient orderables to indicate whether ingredients can be added to or subtracted from the order. |
OE_FORMAT_ID | DOUBLE | N | Used to store the internal identifier for the order entry format to be used by order entry applications |
OP_DC_DISPLAY_DAYS | DOUBLE | N | DC Display Days to be used when the catalog is ordered in an outpatient setting (i.e. Orig_Ord_As_Flag of 1 or 2). A -1 value indicates that the value is NOT SET and that DC_Display_Days will be used instead. |
OP_DC_INTERACTION_DAYS | DOUBLE | N | DC Interaction Days to be used when the catalog is ordered in an outpatient setting (i.e. Orig_Ord_As_Flag of 1 or 2). A -1 value indicates that the value is NOT SET and that DC_Interaction_Days will be used instead. |
ORDERABLE_TYPE_FLAG | DOUBLE | Y | Used to store the flag that indicates what type of orderable procedure the item has been assigned |
ORDER_REVIEW_IND | DOUBLE | Y | Indicator on whether to do review for this orderable |
ORD_COM_TEMPLATE_LONG_TEXT_ID | DOUBLE | N | Used to pont to the long text record to show the order comment template. |
PREP_INFO_FLAG | DOUBLE | Y | Flag on whether the orderable has a prep associated with it. |
PRIMARY_MNEMONIC | VARCHAR(100) | N | Used to store the abbreviated description for the synonym flagged as the primary synonym on the order_catalog_synonym table |
PRINT_REQ_IND | DOUBLE | Y | Indicator on whether this orderable should generate a requisition. |
PROMPT_IND | DOUBLE | Y | Used to indicate that one or more of the rows on the profile_task_r table have been flagged as having prompts |
QUICK_CHART_IND | DOUBLE | Y | Indicator on whether to do quick charting for this orderable. |
REF_TEXT_MASK | DOUBLE | Y | Value to define what online reference manual information has been built. |
REQUISITION_FORMAT_CD | DOUBLE | N | The requisition format to be used for this orderable. |
REQUISITION_ROUTING_CD | DOUBLE | N | The requisition routing is to use for this orderable. It comes from dcp_output_route_id in dcp_output_route table. |
RESOURCE_ROUTE_CD | DOUBLE | N | Future |
RESOURCE_ROUTE_LVL | DOUBLE | Y | Used to indicate at which level routing information exists. Valid values are 1- Routing information is appended to the order catalog, 2- Routing information is appended to the task/assays associated ith the order catalog on profile_task_r. 3- Routing information is appended to the rows on profile_task_r. 4- Routing information is appended to the route_code_resource_list table |
REVIEW_HIERARCHY_ID | DOUBLE | N | Future |
SCHEDULE_IND | DOUBLE | Y | Indicator on whether to this orderable is available for scheduling |
SOURCE_VOCAB_IDENT | VARCHAR(50) | Y | The common name identifier for this order catalog. |
SOURCE_VOCAB_MEAN | VARCHAR(12) | Y | The meaning of the source vocabulary for the common name. |
STOP_DURATION | DOUBLE | Y | NEW |
STOP_DURATION_UNIT_CD | DOUBLE | N | NEW |
STOP_TYPE_CD | DOUBLE | N | new code |
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. |
VETTING_APPROVAL_FLAG | DOUBLE | N | This field indicates whether an order is a vetting order or not and whether or not it requires approval. This field will only apply to radiology procedures. 0 - not a vetting order 1 - vetting order, does not require approval 2 - vetting order, requires approval |
Relationship Detail - ORDER_CATALOG
Child Column in ORDER_CATALOG(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CATALOG_CD | CODE_VALUE | CODE_VALUE |
FORM_ID | DCP_FORMS_REF | DCP_FORM_INSTANCE_ID | |
CONSENT_FORM_ROUTING_CD | DCP_OUTPUT_ROUTE | DCP_OUTPUT_ROUTE_ID | |
REQUISITION_ROUTING_CD | DCP_OUTPUT_ROUTE | DCP_OUTPUT_ROUTE_ID | |
OE_FORMAT_ID | ORDER_ENTRY_FORMAT_PARENT | OE_FORMAT_ID | |
REVIEW_HIERARCHY_ID | RES_REVIEW_HIERARCHY | REVIEW_HIERARCHY_ID |
ORDER_CATALOG_REVIEW
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | ORDER CATALOG REVIEW |
Definition: | Controls routing of nurse review, doctor cosign and pharmacy verify. |
Table Type: | REFERENCE |
Column Detail - ORDER_CATALOG_REVIEW
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_TYPE_CD | DOUBLE | N | Order Action Type: Order, Modify, Cancel, Discontinue |
CATALOG_CD | DOUBLE | N | Unique identifier for orderable items. |
COSIGN_REQUIRED_IND | DOUBLE | Y | On hold until doctor cosigns it. |
DOCTOR_COSIGN_FLAG | DOUBLE | Y | 0 - No Cosign Needed 1 - Ordering Physician Provider_id 2 - Attending Physician Provider_id 3 - Order detail Provider_id |
NURSE_REVIEW_FLAG | DOUBLE | Y | 0 - No verify needed 1 - Location_cd = ordering location 2 - Location _cd = patient location 3 - Order detail defines provider_id 4 - Order detail defines location_cd |
REVIEW_REQUIRED_IND | DOUBLE | Y | On Hold until a nurse reviews it |
RX_VERIFY_FLAG | DOUBLE | Y | 0 - No verify needed. 2 - Required in On Hold status. |
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_CATALOG_REVIEW
Child Column in ORDER_CATALOG_REVIEW(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CATALOG_CD | ORDER_CATALOG | CATALOG_CD |