Barts Health NHS Cerner Millenium Electronic Patient Record.

MDW Discover  > Barts Health NHS Cerner Millenium Electronic Patient Record @ 992

MDW Discover

Browse All

London SDE

West Midlands SDE

Kent, Medway & Sussex SDE

MDW - Discover

Barts Health NHS Trust Cerner Millenium Electronic Patient Record.

Total number of distinct PERSON_ID in the Millenium Encounter table

HDR UK

Barts Health

The unique identifier for the event schedule.  The schedules are used to track rescheduling of an event.

SCHEDULE_ID

Clinic Id assoiciated to the location and schedule.

SCH_CLINIC_ID

ADC_UPDT

The date and time for which this table row becomes effective.  Normally, this will be the date and time the row is added, but could be a past or future date and time.

BEG_EFFECTIVE_DT_TM

The version date and time marks the date the record became historical.

VERSION_DT_TM

INST_ID

The free text description corresponding to the location.

LOCATION_FREETEXT

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_ID

LAST_UTC_TS

contains 31-DEC-2100 00:00:00.00.  This field is used to maintain foreign keys to tables that contain a VERSION_DT_TM in the primary key.

NULL_DT_TM

The field identifies the current permanent location of the patient.

LOCATION_CD

Defines the locations meaning to scheduling.

LOCATION_TYPE_CD

The person who caused the active_status_cd to be set or change.

ACTIVE_STATUS_PRSNL_ID

The date and time the row was last inserted or updated.

UPDT_DT_TM

A sequence-generated number to uniquely identify the specific row in the database.

CANDIDATE_ID

The application context number from the record info block.

UPDT_APPLCTX

The date and time that the active_status_cd was set.

ACTIVE_STATUS_DT_TM

A 12-char description of the location association type.

LOCATION_TYPE_MEANING

The date/time after which the row is no longer valid as active current data.  This may be valued with the date that the row became inactive.

END_EFFECTIVE_DT_TM

Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.

ACTIVE_STATUS_CD

TXN_ID_TEXT

The registered (assigned) task number for the process that inserted or updated the row.

UPDT_TASK

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_IND

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_CNT

Schedule Location: 
Defined the location associated with a scheduled appointment

mill_sch_location

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.

The type of procedure function. An example would be anesthesia.

PROC_FUNC_TYPE_CD

The priority of the procedure compared to other procedures in the same encounter.

PROC_PRIORITY

&quot;A code value that is the selected for the &quot;&quot;Generic Field&quot;&quot; in himChartCoding.&quot;

GENERIC_VAL_CD

Codified ranking description.  The available codes are Primary and Secondary.

RANKING_CD

A value representing the units of service for a procedure. (e.g. units of blood)

UNITS_OF_SERVICE

This is the code_value associated with the location of the procedure.

PROC_LOC_CD

This is free textlocation of the procedure.

PROC_FT_LOC

Indicator used to hide items from the historic procedure view.  By default all of the existing data qualifies for history display.

SUPPRESS_NARRATIVE_IND

This is used to indicate if the location is a free text value.

PROC_LOC_FT_IND

ANESTHESIA_CD

PARENT_ENTITY_NAME

PROC_FTDESC

HL7 segment PR1-13 added on-the-fly.Definition: This field contains the type of consent that was obtained for permission to treat the patient. NOTE: This column is currently not being used but it may be used in the future. The Code Set for it does not exist either.

CONSENT_CD

This field contains a unique identifier for one of the multiple repetitions of the HL7 segment.

SEG_UNIQUE_KEY

Contributor system identifies the source feed of data from which a row was populated.  This is mainly used to determine how to update a set of data that may have originated from more than one source feed.

CONTRIBUTOR_SYSTEM_CD

This is the unique identifier to the long text table.

LONG_TEXT_ID

This is the value of the unique primary identifier of the encounter table.  It is an internal system assigned number.

ENCNTR_ID

The number of minutes the patient was under anesthesia

ANESTHESIA_MINUTES

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.

It associates a procedure to a particular setting of care within an encounter.  The unifying clinical trait of the notion of a clinical service is that it correlates to the physician&#039;s fiduciary responsibility for the patient as manifested by a formal hand-off / acceptance of care process that involves a declaration of diagnostic information that corresponds to the clinical service as the transition points.

CLINICAL_SERVICE_CD

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.

The combination of the reference nbr and the contributor system code provides a unique identifier to the origin of the data.

REFERENCE_NBR

Identifies the code value associated with the laterality of the procedure.  Code set 4002375

LATERALITY_CD

Used to indicate the precision selected by the end user when entering the procedure date &amp; time (Before, After, About, Unknown, etc.)

PROC_DT_TM_PREC_CD

The service category history Id, or unique identifier, from the service category history table.  It is an internal system assigned number.

SVC_CAT_HIST_ID

The data and time the procedure was ended.

PROC_END_DT_TM

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.

NOMENCLATURE_ID

This is the free texttime frame for the procedure

PROC_FT_TIME_FRAME

The amount of time in minutes the procedure took to complete.

PROC_MINUTES

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.

The data and time the procedure was started.

PROC_START_DT_TM

Indicator to determine whether or not a specific procedure was the Dominant Group variable Procedure for a given encounter or service category. 0 = not DVGP, 1 = DGVP

DGVP_IND

Precision flag for date and time.0 - Date or Date and Time, 1- Week, 2 - Month, 3 - Year.

PROC_DT_TM_PREC_FLAG

This is the value of the unique primary identifier of the Organization table. It is an internal system assigned number. The organization associated with this procedure.

ORGANIZATION_ID

This indicator is set when a free textdata and time is entered

PROC_FT_DT_TM_IND

Indicator that a comment was added about the procedure

COMMENT_IND

The date and time when the procedure was performed.

PROC_DT_TM

Free-text note for an individual procedure

PROCEDURE_NOTE

Procedure id is the primary unique identification number of the procedure table.  It is an internal system assigned sequence number.

PROCEDURE_ID

Identifies an Encounter as it relates to a time slice.

ENCNTR_SLICE_ID

DIAG_NOMENCLATURE_ID

The nomenclature Id of the nomenclature row used as a modifier

MOD_NOMENCLATURE_ID

Indicated to type of procedure.  0 - Unknown  1 - encounter Procedure  2 - narrated procedure

PROC_TYPE_FLAG

PARENT_ENTITY_ID

The code value for the tissue type.  This is an optional field. An example would be moist or supple.

TISSUE_TYPE_CD

Procedure Table: 
Stores the coded information for procedures from the patient&#039;s chart.

mill_procedure

CODE_VALUES_CNT

DEFINITION_DUP_IND

DOMAIN_QUALIFIER_IND

Controls whether code values can be deleted in CRMCODE

DEL_ACCESS_IND

determines whether this code set can be viewed in crmcode

INQ_ACCESS_IND

TABLE_NAME

use display_key as the duplicate check for this code set

DISPLAY_KEY_DUP_IND

The alias, alias_type_meaning, code_set, and contributor_system_cd on the code_value_alias table will be used for duplicate checking.

ALIAS_DUP_IND

CODE_SET_HITS

Indicates whether this code set will be cached by the decoder

CACHE_IND

DESCRIPTION

Indicates whether the ACTIVE_IND field is being used for duplicate checking when adding/updating code values.

ACTIVE_IND_DUP_IND

OWNER_MODULE

The number of the code set header record (determined by following the procedure for creating a new code set).

CODE_SET

Indicates whether the user can change code values in CRMCode.

CHG_ACCESS_IND

Indicates whether DISPLAY field on the code value table will be used for duplicate checking when inserting/updating code values.

DISPLAY_DUP_IND

DOMAIN_CODE_SET

DISPLAY

Defines how the code set should be handled during merge.

DEF_DUP_RULE_FLAG

DEFINITION

Similar to DISPLAY but contains only upper case and alphanumeric characters without any special characters or embedded spaces;  Typically used in index to improve query performanced

DISPLAY_KEY

Indicates whether code_set_extension rows exist

EXTENSION_IND

Indicates whether the CDF Meaning field on the code value table will be used for duplicate checking when adding/updating code values.

CDF_MEANING_DUP_IND

Indicates whether the user may add code values to this code set.

ADD_ACCESS_IND

CONTRIBUTOR

Used to store the list of code_sets.: 
Used to store the list of code_sets and their descriptions as well as other attributes about a code_set.

mill_code_value_set

Free text severity of a condition identified by clinical diagnosis

SEVERITY_FTDESC

Associates the clinical diagnosis to a particular setting of care within an encounter.

DIAG_TYPE_CD

Contains the nomenclature ID from the nomenclature table for the nomenclature modifier.

Indicates the confidentiality of the diagnosis data.

CONFID_LEVEL_CD

CLINICAL_DIAG_PRIORITY

Date/time for which the Diagnosis was saved

DIAG_DT_TM

Numeric percentage to reflect probability of validity of clinical diagnosis.

PROBABILITY

This is the value of the unique primary identifier of the person table.  It is an internal system assigned number.

PERSON_ID

The unique identifier for the clinical diagnosis.  The diagnosis_group can be associated with multiple diagnosis instances.  When a new diagnosis is added to the diagnosis table the diagnosis group is assigned to the diagnosis_id

DIAGNOSIS_GROUP

Severity classification system by which the severity code is based on.

SEVERITY_CLASS_CD

Diagnosis: 
The diagnoses table stores medical diagnosis information for a patient encounter.  This information describes symptoms the patient was experiencing at the time of the encounter.

Barts Health NHS Cerner Millenium Electronic Patient Record

Documentation

Coverage

Provenance

Origin

Temporal

Accessibility

Access

Usage

Format and Standards

Observations

Origin