MDW - Discover Metadata Catalogue

MDW Discover  > Barts Health NHS Trust 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 field identifies the current permanent location of the patient.

LOCATION_CD

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

UPDT_DT_TM

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

VERSION_DT_TM

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

UPDT_TASK

The date and time that the active_status_cd was set.

ACTIVE_STATUS_DT_TM

The application context number from the record info block.

UPDT_APPLCTX

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

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

ACTIVE_STATUS_PRSNL_ID

Trust

INST_ID

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

LAST_UTC_TS

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

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

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

TXN_ID_TEXT

Clinic Id assoiciated to the location and schedule.

SCH_CLINIC_ID

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

SCHEDULE_ID

A 12-char description of the location association type.

LOCATION_TYPE_MEANING

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

CANDIDATE_ID

The free text description corresponding to the location.

LOCATION_FREETEXT

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

ADC_UPDT

Defines the locations meaning to scheduling.

LOCATION_TYPE_CD

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

Schedule Location: 
Defined the location associated with a scheduled appointment

mill_sch_location

This is free textlocation of the procedure.

PROC_FT_LOC

This is the free texttime frame for the procedure

PROC_FT_TIME_FRAME

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.

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

PROC_MINUTES

The number of minutes the patient was under anesthesia

ANESTHESIA_MINUTES

The date and time when the procedure was performed.

PROC_DT_TM

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

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

PROC_FUNC_TYPE_CD

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

PROC_LOC_FT_IND

ANESTHESIA_CD

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

PROC_TYPE_FLAG

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

LATERALITY_CD

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

TISSUE_TYPE_CD

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

PROC_FT_DT_TM_IND

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

ENCNTR_ID

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.

NOMENCLATURE_ID

Free-text note for an individual procedure

PROCEDURE_NOTE

Identifies an Encounter as it relates to a time slice.

ENCNTR_SLICE_ID

This is the unique identifier to the long text table.

LONG_TEXT_ID

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

PROC_FTDESC

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 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.

PARENT_ENTITY_NAME

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

PROC_LOC_CD

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

GENERIC_VAL_CD

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

SEG_UNIQUE_KEY

The data and time the procedure was started.

PROC_START_DT_TM

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

REFERENCE_NBR

The nomenclature Id of the nomenclature row used as a modifier

MOD_NOMENCLATURE_ID

Indicator that a comment was added about the procedure

COMMENT_IND

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

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

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

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

PROCEDURE_ID

The data and time the procedure was ended.

PROC_END_DT_TM

DIAG_NOMENCLATURE_ID

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

UNITS_OF_SERVICE

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.

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

SUPPRESS_NARRATIVE_IND

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

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

PROC_DT_TM_PREC_FLAG

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

PROC_PRIORITY

PARENT_ENTITY_ID

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

RANKING_CD

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.

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

mill_procedure

DEFINITION

Indicates whether this code set will be cached by the decoder

CACHE_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

DOMAIN_CODE_SET

CONTRIBUTOR

determines whether this code set can be viewed in crmcode

INQ_ACCESS_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 can change code values in CRMCode.

CHG_ACCESS_IND

DOMAIN_QUALIFIER_IND

OWNER_MODULE

DISPLAY

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

CODE_SET

DESCRIPTION

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

ADD_ACCESS_IND

Controls whether code values can be deleted in CRMCODE

DEL_ACCESS_IND

use display_key as the duplicate check for this code set

DISPLAY_KEY_DUP_IND

DEFINITION_DUP_IND

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

DISPLAY_DUP_IND

CODE_SET_HITS

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

ACTIVE_IND_DUP_IND

TABLE_NAME

Indicates whether code_set_extension rows exist

EXTENSION_IND

CODE_VALUES_CNT

Defines how the code set should be handled during merge.

DEF_DUP_RULE_FLAG

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

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

This is the unique identifier for the service category history table.

The originating nomenclature id of the diagnosis.  This is used to record the source nomenclature id of the diagnosis.

ORIGINATING_NOMENCLATURE_ID

Prsnl_id of person that added the diagnosis.

DIAG_PRSNL_ID

CLINICAL_DIAG_PRIORITY

Date/time for which the Diagnosis was saved

DIAG_DT_TM

Priority of diagnoses as determined by application.

DIAG_PRIORITY

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

A denormalized, and possibly annotated description of the clinical diagnosis. This will default from the description of the chosen codified diagnosis code, and can be annotated (extended) by the clinician. This will be the column used when displaying this clinical diagnosis back to the user.

DIAGNOSIS_DISPLAY

The date by when the diagnosis was attested.

ATTESTATION_DT_TM

DIAGNOSIS_ID

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 Trust Cerner Millenium Electronic Patient Record

Documentation

Coverage

Provenance

Origin

Temporal

Accessibility

Access

Usage

Format and Standards

Observations

Origin