Table Detail Report
ORDER_CATALOG_SYNONYM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Order catalog synonym |
Definition: | Used to store all valid synonyms and their associated information for a given order catalog item |
Table Type: | REFERENCE |
Column Detail - ORDER_CATALOG_SYNONYM
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. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | Y | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
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 |
AUTHORIZATION_REVIEW_FLAG | DOUBLE | N | Used to store the flag that indicates what kind of stop type is assigned to the orderable.0 - None.1 - Indicator Only - No Status Updates. 2 - Indicator Only - With Status Updates (Current: No Alerts, Indicator Only). 3 - Alert - No Override Required. 4 - Alert - Override required. 5 - Authorization Required Prior to Start. |
AUTOPROG_SYN_IND | DOUBLE | N | Indicator if set symbolized that auto programming will happen at synonym level. If not set auto programming will happen at Catalog code level. |
CATALOG_CD | DOUBLE | N | Order catalog number |
CATALOG_TYPE_CD | DOUBLE | N | Used to store the internal code for the catalog type. Used as a filtering mechanism for rows on the order catalog table |
CKI | VARCHAR(255) | Y | For meds process |
CONCENTRATION_STRENGTH | DOUBLE | Y | The strength value of the concentration ratio. |
CONCENTRATION_STRENGTH_UNIT_CD | DOUBLE | N | The code value that represents the unit of measure for the concentration strength attribute. |
CONCENTRATION_VOLUME | DOUBLE | Y | The volume value of the concentration ratio. |
CONCENTRATION_VOLUME_UNIT_CD | DOUBLE | N | The code value that represents the unit of measure for the concentration volume attribute. |
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. |
CS_INDEX_CD | DOUBLE | N | CareSet Index code |
DCP_CLIN_CAT_CD | DOUBLE | N | The clinical category of this orderable. |
DISPLAY_ADDITIVES_FIRST_IND | DOUBLE | N | Indicates whether or not this synonym (additive) should be displayed prior to the diluents in an IV. |
FILTERED_OD_IND | DOUBLE | Y | Indicates if any filtered order details have been set up against this synonym. |
HEALTH_PLAN_VIEW | VARCHAR(255) | Y | Each character in the field represent one health plan. The offset of the health plans is defined in dcp_entity_reltn table. The possible values for each char are: G (Green), W (White), Yellow (Y), R (Red). |
HIDE_FLAG | DOUBLE | Y | Flag indicating whether or not to hide this synonym |
HIGH_ALERT_IND | DOUBLE | N | A customized message that alerts the user when the order is being added to scratchpad. |
HIGH_ALERT_LONG_TEXT_ID | DOUBLE | N | A pointer to the text displayed if this is a High Alert orderable. |
HIGH_ALERT_REQUIRED_NTFY_IND | DOUBLE | Y | Indicates if the high alert text should be presented to the user automatically. |
IGNORE_HIDE_CONVERT_IND | DOUBLE | N | Indicates if the hide flag can be ignored for convert to inpatient. |
INGREDIENT_RATE_CONVERSION_IND | DOUBLE | N | If the ingredient is eligible to have ingredient rate to total bag rate conversions and vice versa. If the indicator is set to 1, then orders that have this ingredient will be shown on the interactive view with an additive rate row and a total bag rate row. Similarly, the IV Charting window will require the user to validate the concentration, ingredient dose rate unit, and possibly weight in order to perform the conversions. |
INTERMITTENT_IND | DOUBLE | N | Indicates whether or not a synonym can be placed as an intermittent order. |
ITEM_ID | DOUBLE | N | The associated id of the item for this synonym. |
LAST_ADMIN_DISP_BASIS_FLAG | DOUBLE | N | Specifies at what level the med interval warnings should be performed at. 0 - Use System Default, 1 - Order Level, 2 - Event Code Level. |
LOCK_TARGET_DOSE_IND | DOUBLE | N | Lock target dose indicator. An indicator to lock the target dose in the dose calculator. |
MAX_DOSE_CALC_BSA_VALUE | DOUBLE | N | Contains the reference (upper-limit) for the BSA value for the synonym and is always measured in meter-squared. Has a (default) value of 0.0 denoting the absence of a reference. |
MAX_FINAL_DOSE | DOUBLE | N | Contains the reference (upper-limit) on the final-dose for the synonym. Has a (default) value of 0.0 denoting the absence of a reference. |
MAX_FINAL_DOSE_UNIT_CD | DOUBLE | N | Contains the unit of measurement for the reference (upper-limit) defined in MAX_FINAL_DOSE. Has a value of 0.0 if MAX_FINAL_DOSE contains 0.0. |
MED_INTERVAL_WARN_FLAG | DOUBLE | N | Specifies if med interval warnings should be displayed when a result is within the defined time range. 0 - Use System Default, 1 - Order Level, 2 - Event Code Level. |
MNEMONIC | VARCHAR(200) | Y | The display mnemonic of this orderable. |
MNEMONIC_KEY_CAP | VARCHAR(200) | Y | The key version of the mnemonic for this orderable. |
MNEMONIC_KEY_CAP_A_NLS | VARCHAR(400) | Y | MNEMONIC_KEY_CAP_A_NLS column |
MNEMONIC_KEY_CAP_NLS | VARCHAR(405) | Y | NLS Sort column for internationalization. |
MNEMONIC_TYPE_CD | DOUBLE | N | The type of mnemonic this is. |
MULTIPLE_ORD_SENT_IND | DOUBLE | Y | Indicator on whether or not this synonym has multiple order sentences associated with it. |
OE_FORMAT_ID | DOUBLE | N | Used to store the internal identifier for the order entry format to be used by order entry applications |
ORDERABLE_TYPE_FLAG | DOUBLE | Y | Used to store the flag that indicates what type of orderable procedure the item has been assigned |
ORDER_SENTENCE_ID | DOUBLE | N | The id for the order sentence associate with this synonym |
PREFERRED_DOSE_FLAG | DOUBLE | N | This defines whether strength or volume dose is preferred when both doses are available for an order. 0 - None, 1 - Strength. |
REF_TEXT_MASK | DOUBLE | Y | Value that shows what parts of the online reference manual have been associated with the synonym |
ROUNDING_RULE_CD | DOUBLE | Y | This field contains the rounding rule that will default into the dose calculator for this synonym. This field is only applicable to medication synonyms. |
RX_MASK | DOUBLE | Y | Stores the different sub-lists the synonym belongs in, i.e. should it display with diluents, with additives, with medications, or any combination of the above. |
SYNONYM_ID | DOUBLE | N | The id of this synonym. |
TEMPLATE_MNEMONIC_FLAG | DOUBLE | N | NOT USED |
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. |
VIRTUAL_VIEW | VARCHAR(100) | Y | The offset used to determine whether to show the orderable or not for a facility. |
WITNESS_FLAG | DOUBLE | N | Witness_flag indicates if the witness field is required when Medication Administration events are Charted. 0 indicates that a witness is not required. 1 indicates that a witness is required. |
Relationship Detail - ORDER_CATALOG_SYNONYM
Child Column in ORDER_CATALOG_SYNONYM(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | HIGH_ALERT_LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID |
CATALOG_CD | ORDER_CATALOG | CATALOG_CD |
ORDER_CATALOG_TEXT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | |
Definition: | |
Table Type: | REFERENCE |
Column Detail - ORDER_CATALOG_TEXT
Column Name | Type | Null? | Definition |
---|---|---|---|
CATALOG_CD | DOUBLE | N | Order Catalog Code |
LONG_TEXT_ID | DOUBLE | N | the long text id for the long text table |
TEXT_LEVEL_FLAG | DOUBLE | Y | |
TEXT_TYPE_CD | DOUBLE | N | |
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_TEXT
Child Column in ORDER_CATALOG_TEXT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CATALOG_CD | ORDER_CATALOG | CATALOG_CD |
ORDER_DIAG_CONFIG
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Order Diagnosis Configuration |
Definition: | Stores client defined settings on how orders should behave with regards to dignoses. The client can define whether or not a diagnosis is required for an order |
Table Type: | REFERENCE |
Column Detail - ORDER_DIAG_CONFIG
Column Name | Type | Null? | Definition |
---|---|---|---|
CATALOG_CD | DOUBLE | N | Stores the order catalog that the configuration applies to. |
CATALOG_TYPE_CD | DOUBLE | N | Stores the catalog type that the configuration applies to. |
CONFIG_MEANING | VARCHAR(12) | N | Stores a key for the diagnosis configuration being defined. |
CONFIG_VALUE | DOUBLE | N | Stores the value for the diagnosis configuration |
HEALTH_PLAN_ID | DOUBLE | N | Foreign key to the Health_Plan table |
ORDER_DIAG_CONFIG_ID | DOUBLE | N | The primary key of this 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. |
VENUE_TYPE_FLAG | DOUBLE | N | Stores a flag indicating the type of venue that the configuration applies to. |
Relationship Detail - ORDER_DIAG_CONFIG
Child Column in ORDER_DIAG_CONFIG(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CATALOG_TYPE_CD | CODE_VALUE | CODE_VALUE |
HEALTH_PLAN_ID | HEALTH_PLAN | HEALTH_PLAN_ID | |
CATALOG_CD | ORDER_CATALOG | CATALOG_CD |
ORDER_ENTRY_FIELDS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | ORDER ENTRY FIELDS |
Definition: | The table containing all the fields that may be used to capture information about an order. |
Table Type: | REFERENCE |
Column Detail - ORDER_ENTRY_FIELDS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCEPT_SIZE | DOUBLE | Y | The size of the field. |
ALLOW_MULTIPLE_IND | DOUBLE | Y | An indicator on whether the field can appear multiple times on a format. |
CATALOG_TYPE_CD | DOUBLE | N | The catalog type this field may be associated with, optional. |
CKI | VARCHAR(30) | Y | Cerner Knowledge Index for this order entry field |
CODESET | DOUBLE | Y | If the field is verified against a codeset, this is the codeset to use. |
COMMON_FLAG | DOUBLE | Y | Flag on whether or not to show the field in common order details. |
DESCRIPTION | VARCHAR(100) | Y | The description of the field |
EVENT_CD | DOUBLE | N | If 'smart defaulting' is being used, the event code for the last result to retrieve as a default. |
FIELD_TYPE_FLAG | DOUBLE | Y | Flag used to identify the type of field it it. |
FSI_MAP_TO_OBX_IND | DOUBLE | Y | Indicates that this order_entry_field should be considered for outbound interface |
HELP_CONTEXT_ID | DOUBLE | N | Future. |
HIDE_FEMALE_IND | DOUBLE | Y | Indicates whether this field should be hidden for female patients. |
HIDE_MALE_IND | DOUBLE | Y | Indicates whether this field should be hidden for male patients. |
HIDE_MAX_AGE | DOUBLE | Y | The age to be older than to hide this field. |
HIDE_MAX_AGE_IND | DOUBLE | Y | whether this field should be hidden for patients older than a specified age. |
HIDE_MAX_AGE_UNITS_FLAG | DOUBLE | Y | The unit type for the max age. |
HIDE_MIN_AGE | DOUBLE | Y | The age to be younger than to hide this field. |
HIDE_MIN_AGE_IND | DOUBLE | Y | Indicates whether this field should be hidden for patients under a specified age. |
HIDE_MIN_AGE_UNITS_FLAG | DOUBLE | Y | The unit type for the minimum age. |
MAX_VAL | DOUBLE | Y | The maximum value possible for a field if it is a numeric type. |
MIN_VAL | DOUBLE | Y | The minimum value of the field if it is a numeric type. |
OE_FIELD_ID | DOUBLE | N | The id of the order entry field. |
OE_FIELD_MEANING_ID | DOUBLE | N | The Cerner defined id that identifies what the field is being used for. |
PROMPT_ENTITY_ID | DOUBLE | N | The identifier for the prompt test that is located on another table. This could be a task_assay_cd. |
PROMPT_ENTITY_NAME | VARCHAR(32) | Y | The table name where the prompt test field is located, for example DISCRETE_TASK_ASSAY. This field is empty for non-prompt fields. |
REQUEST | DOUBLE | Y | Future |
SMART_DEFAULTING_FLAG | DOUBLE | Y | Flag to identify the type of defaulting this field - update or non-update ocf. |
SPIN_INCREMENT_CNT | DOUBLE | Y | For a numeric field the amount a spin control should increment by. |
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. |
VALIDATION_TYPE_FLAG | DOUBLE | Y | The type of validation to verify the field. |
Relationship Detail - ORDER_ENTRY_FIELDS
Parent Column in ORDER_ENTRY_FIELDS (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | OE_FIELD_ID | AP_PROMPT_FIELD | OE_FIELD_ID |
ORDER_DETAIL_HISTORY | OE_FIELD_ID | ||
ORDER_PROPOSAL_DETAIL | OE_FIELD_ID | ||
ORDER_SENTENCE_DETAIL | OE_FIELD_ID | ||
SCH_DETAIL | OE_FIELD_ID | ||
SCH_FLEX_LIST | OE_FIELD_ID | ||
SCH_PEND_EVENT_DETAIL | OE_FIELD_ID | ||
SCH_PEND_ORDER_DETAIL | OE_FIELD_ID | ||
SCH_REF_DETAIL | OE_FIELD_ID |
ORDER_ENTRY_FORMAT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | ORDER ENTRY FORMAT |
Definition: | 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
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_TYPE_CD | DOUBLE | N | The action this format is built for. |
CATALOG_TYPE_CD | DOUBLE | N | The catalog type this format is built for. |
OE_FORMAT_ID | DOUBLE | N | The id for the format. |
OE_FORMAT_NAME | VARCHAR(200) | Y | The name of the 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 Column in ORDER_ENTRY_FORMAT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | ACTION_TYPE_CD | OE_FORMAT_FIELDS | ACTION_TYPE_CD |
OE_FORMAT_ID | OE_FORMAT_FIELDS | OE_FORMAT_ID | |
ACTION_TYPE_CD | RLN_SPECIMEN_OEF | ACTION_TYPE_CD | |
OE_FORMAT_ID | RLN_SPECIMEN_OEF | OEF_ID |