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




Parent Column in ORDER_CATALOG_SYNONYM (PK) Child Table Name Child Column Name
Children: SYNONYM_ID ALT_SEL_CAT IV_SET_SYNONYM_ID
ALT_SEL_LIST ORDERED_AS_SYNONYM_ID
ALT_SEL_LIST SYNONYM_ID
AUTHORIZATION_ITEM ORDER_SYNONYM_ID
AUTHORIZATION_ITEM_HIST ORDER_SYNONYM_ID
BB_MOD_NEW_PRODUCT SYNONYM_ID
BR_ADO_ORD_LIST SYNONYM_ID
CHART_GRP_EVNT_SET SYNONYM_ID
CONVERT_AUDIT_BEST_MATCH SYNONYM_ID
CONVERT_AUDIT_SYNONYM SYNONYM_ID
CS_COMPONENT COMP_ID
ENCNTR_PROCEDURE SYNONYM_ID
EXPEDITE_TRIGGER SYNONYM_ID
GS_MED_CLAIM PRODUCT_SYNONYM_ID
IB_RX_REQ_DRUG SYNONYM_ID
MED_ADMIN_MED_EVENT_INGRDNT SYNONYM_ID
MED_OE_DEFAULTS ORD_AS_SYNONYM_ID
MRU_LOOKUP_ORDER SYNONYM_ID
OCS_ATTR_XCPTN SYNONYM_ID
OCS_CONFIDENTIAL_DEFAULTS SYNONYM_ID
OCS_DEF_DOSE_CALC_METHOD SYNONYM_ID
OCS_FACILITY_FORMULARY_R SYNONYM_ID
OCS_FACILITY_R SYNONYM_ID
OCS_HANDLING_PRECAUTIONS SYNONYM_ID
ORDERS IV_SET_SYNONYM_ID
ORDERS SYNONYM_ID
ORDER_ACTION SYNONYM_ID
ORDER_CATALOG_ITEM_R SYNONYM_ID
ORDER_INGREDIENT ORDERED_AS_SYNONYM_ID
ORDER_INGREDIENT SYNONYM_ID
ORDER_INGREDIENT_HISTORY SYNONYM_ID
ORDER_PROPOSAL IV_SET_SYNONYM_ID
ORDER_PROPOSAL SYNONYM_ID
ORDER_PROPOSAL_INGREDIENT SYNONYM_ID
ORDER_PROPOSAL_INGRED_HST SYNONYM_ID
ORDER_RX_SCRATCHPAD SYNONYM_ID
ORM_ERROR_LOG SYNONYM_ID
PBS_OCS_MAPPING SYNONYM_ID
PHA_DISP_OBS_ST SYNONYM_ID
PHA_ORD_ACT_OBS_ST SYNONYM_ID
PHA_PROD_DISP_OBS_ST ING_SYNONYM_ID
PHA_PROD_DISP_OBS_ST SYNONYM_ID
PL_PC_ORG_TAB_XREF SYNONYM_ID
PRODUCT_INDEX SYNONYM_ID
PROP_ORDER SYNONYM_ID
RAD_MEDS SYNONYM_ID
RAD_MED_CAT_LIST SYNONYM_ID
RC_SLA_RULE ORDER_SYNONYM_ID
RX_AUTO_VERIFY_ING_AUDIT SYNONYM_ID
RX_PRODUCT_ASSIGN_ITEM_AUDIT SYNONYM_ID
RX_THERAP_SBSTTN_FROM FROM_SYNONYM_ID
RX_THERAP_SBSTTN_TO TO_SYNONYM_ID
SCH_APPT_ORD SYNONYM_ID
SCH_BOOKING_ORD SYNONYM_ID
SCH_EVENT_ATTACH SYNONYM_ID
SCH_EVENT_RECUR_ORDER ORDER_SYNONYM_ID
SCH_PEND_ORDER SYNONYM_ID
STANDARDIZED_ORDER_DOSE SYNONYM_ID
SURG_CASE_PROCEDURE SYNONYM_ID
SURG_REQ_PROC PROC_SYNONYM_ID
SYNONYM_ITEM_R SYNONYM_ID
THERAPEUTIC_CAT_ITEM SYNONYM_ID


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