MDW - Discover Metadata Catalogue

MDW Discover  > NHS e-Referral Service (e-RS) @ 1355

MDW Discover

Browse All

London SDE

West Midlands SDE

Kent, Medway & Sussex SDE

MDW - Discover

https://www.england.nhs.uk/long-read/e-referrals/

Total number of distinct individuals in the dataset

Highest number of referrals from Patient residing in LA: Wirral (latest 12 months)

HDR UK

Provider Submitted: ?1? if the Service has a Supported Request Flow of Advice and Guidance Request Flow. ?0? if the Service does NOT have a Supported Request Flow of Advice and Guidance Request Flow.

ACCEPTS_ADVICE_REQUESTS

Provider Submitted: ?1? if the Service has a Supported Request Flow of Appointment Request Flow. ?0? if the Service does NOT have a Supported Request Flow of Appointment Request Flow.

ACCEPTS_APPOINTMENT_REQUESTS

Provider Submitted: ?1? if the Service has a Supported Request Flow of Triage Request Flow. ?0? if the Service does NOT have a Supported Request Flow of Triage Request Flow.

ACCEPTS_TRIAGE_REQUESTS

Provider Submitted: The generic code for the Activity being reported.

ACTION_CD

Provider Submitted: The generic description for the Activity being reported.

ACTION_DESC

Provider Submitted: The Date and Time the Activity was logged Format is YYYYMMDDhhmmss.

ACTION_DT_TM

Provider Submitted: Every individual Activity logged has a unique numeric identifier.  for the Activity is presented.

ACTION_ID

Provider Submitted: The activity log entry.

ACTION_REASON_CD

Provider Submitted: The activity log entry description.

ACTION_REASON_DESC

Provider Submitted: The SDS User ID (smartcard number) of Appointment Clinician associated to the Appointment Booking at the time the Activity Log entry was logged.

ALLOCATED_CLINICIAN_ID

Provider Submitted: Format for the Appointment Start Date and Time is YYYYMMDDhhmm.

APPT_DT_TM

Provider Submitted: Service appointment type code.

APPT_TYPE_CD

Provider Submitted: Sevice appointment type description.

APPT_TYPE_DESC

Provider Submitted: This field will contain the generic code for the Additional Requirement status being added/updated/cancelled.

AR_STATUS_CD

Provider Submitted: This field will contain the description for the Additional Requirement status being added/updated/cancelled.

AR_STATUS_DESC

Provider Submitted: The responsible Area Team Code based on the Patients CCG of registration.

AREA_TEAM_CODE_OF_REGISTRATION

Provider Submitted: The responsible Area Team Code based on the Patients CCG of residence.

AREA_TEAM_CODE_OF_RESIDENCE

Provider Submitted: The responsible Area Team Name based on the Patients CCG of registration.

AREA_TEAM_NAME_OF_REGISTRATION

Provider Submitted: The responsible Area Team Name based on the Patients CCG of residence.

AREA_TEAM_NAME_OF_RESIDENCE

AGEM Derived: Unique identifier generated by DSCRO to designate a single data load.

AuditId

Provider Submitted: The generic Business Function code of the Professional User/Patient User/System that performed the Activity being logged.

BUS_FUNCTION_CD

Provider Submitted: The generic Business Function description of the Professional User/Patient User/System that performed the Activity being logged.

BUS_FUNCTION_DESC

Provider Submitted: The generic code for the requested Clinic Type that was associated to the Service Search Criteria for the Request at the time the Activity Log entry was logged.

CLINIC_TYPE_CD

Provider Submitted: The generic description for the requested Clinic Type that was associated to the Service Search Criteria for the Request at the time the Activity Log entry was logged.

CLINIC_TYPE_DESC

Provider Submitted: The generic code for the Clinical Assessment Outcome Reason selected by the Professional User when an Assessment was recorded/modified.

CLINICAL_ASSESS_OUTCOME_DESC

CLINICAL_ASSESSMENT_OUTCOME_CD

Provider Submitted: The generic description for the Clinical Assessment Outcome Reason selected by the Professional User when an Assessment was recorded/modified.

COMMISSIONER_FOUND

Provider Submitted: ID code of responsible commissioner.

COMMISSIONER_ID

Provider Submitted: Name of responsible commissioner.

COMMISSIONER_NAME

AGEM Derived: A concatenated list of fields deriving the customers eligible to receive the record of activity. See Dissemination Logic tab for list of fields used to lookup responsible CCGs/ICBs

CustomerAll

AGEM Derived: A date formatted version of the ACTION_DT_TM field.

Der_ACTION_DT_TM

AGEM Derived: Generates the Financial month that the activity took place.

Der_ACTION_DT_TM_FINMONTH

AGEM Derived: Generates the Financial year that the activity took place.

Der_ACTION_DT_TM_FINYEAR

AGEM Derived: Generates the Financial Quarter number of when the activity took place.

Der_ACTION_FINMONTH_QTR

AGEM Derived: Generates the Month number that the activity took place.

Der_ACTION_MONTH

AGEM Derived: Generates the Year only of when the activity took place.

Der_ACTION_MONTH_YEAR

AGEM Derived: A date formatted version of the APPT_DT_TM field.

Der_APPT_DT_TM

AGEM Derived: A date formatted version of the E_REFERRAL_PATHWAY_START field.

Der_E_REFERRAL_PATHWAY_START

AGEM Derived: Hearts Valley supplied lookup table value

Der_HV_Local_Community_Flag

Der_HV_Local_Locality

Der_HV_Local_Practice_Name

AGEM Derived: Derived CCG Code based on PATIENTS_POSTCODE field.

Der_Postcode_CCG_Code

AGEM Derived: Derived Constituency Code based on PATIENTS_POSTCODE field.

Der_Postcode_Constituency_Code

AGEM Derived: Derived Unitary Ward District based on PATIENTS_POSTCODE field.

Der_Postcode_Dist_Unitary_Auth

AGEM Derived: Derived Electoral Ward based on PATIENTS_POSTCODE field.

Der_Postcode_Electoral_Ward

AGEM Derived: Derived Local Authority Name based on PATIENTS_POSTCODE field.

Der_Postcode_Local_Auth

AGEM Derived: Derived Lower Super Output Area based on PATIENTS_POSTCODE field.

Der_Postcode_LSOA_Code

AGEM Derived: Derived Middle Super Output Area based on PATIENTS_POSTCODE field.

Der_Postcode_MSOA_Code

AGEM Derived: Derived PCT Code based on PATIENTS_POSTCODE field.

Der_Postcode_PCT_Code

AGEM Derived: Derived Postcode Sector based on PATIENTS_POSTCODE field.

Der_Postcode_Sector

AGEM Derived: Derived Postcode Lower Super Output Area using 2011 refernce data Code based on PATIENTS_POSTCODE field.

Der_Postcode_yr2011_LSOA

AGEM Derived: Derived Postcode Middle Super Output Area using 2011 refernce data Code based on PATIENTS_POSTCODE field.

Der_Postcode_yr2011_MSOA

AGEM Derived: A concatenated list of fields deriving the commissioners responsible for the activity. See Dissemination Logic tab for list of fields used to lookup responsible CCGs/ICBs

DerRfaRecipientAll

Provider Submitted: The date stored in e-Referrals Pathway Start Date for the Pathway yyyymmdd.

E_REFERRAL_PATHWAY_START

Provider Submitted: The first UBRN in the Pathway (associated to the Request).

INITIAL_UBRN

Provider Submitted: Unique Identifier to INITIAL_UBRN.

INITIAL_UBRN_ID

Provider Submitted: If the Request Priority at the time the Activity was performed was Routine or Urgent, then this will present the indicative wait Time value for the appropriate Service Priority that was presented to the user at the time they were booking/rebooking.

Provider Submitted: The exact hospital that the service/clinic is taking place.

LOCATION_ORG_ID

Provider Submitted: The trust main site&#039;s name.

LOCATION_ORG_NAME

Provider Submitted: The SDS User ID (smartcard number) of the requested Named Clinician that was associated to the Service Search Criteria for the UBRN at the time the Activity Log entry was logged.

NAMED_CLINICIAN_ID

Provider Submitted: This field will display the UBRN that was created as a result of an refer on Assessment.

NEXT_UBRN

Provider Submitted: Trust / Organisation ID.

ORG_ID

Provider Submitted: Trust / Organisation Name.

ORG_NAME

Provider Submitted: The generic code for the requested Priority that was associated to the first ever Service Search Criteria for the Request.

ORIGINAL_PRIORITY_CD

Provider Submitted: The generic description for the requested Priority that was associated to the first ever Service Search Criteria for the Request.

ORIGINAL_PRIORITY_DESC

Provider Submitted: The age of the patient in whole years.

PATIENT_AGE

Provider Submitted: The generic code relating to the e-RS Patient?s Gender.

PATIENT_GENDER_CD

Provider Submitted: The generic description relating to the e-RS Patient?s Gender.

PATIENT_GENDER_DESC

Provider Submitted: The Unique, anonymous numeric identifier of the NHS Number (associated to the Request). This is NOT the NHS Number itself as this is considered patient identifiable for the context of this extract.

PATIENT_ID

Provider Submitted: ID code of the Patient&#039;s CCG of registration.

PATIENTS_CCG_OF_REGISTRATION_ID

Provider Submitted: The Name of the Patient&#039;s CCG of registration.

PATIENTS_CCG_OF_REGISTRATION_NAME

Provider Submitted: ID Code of the Patient&#039;s CCG of residence.

PATIENTS_CCG_OF_RESIDENCE_ID

Provider Submitted: Name of the Patient&#039;s CCG of residence.

PATIENTS_CCG_OF_RESIDENCE_NAME

Provider Submitted: ID of the Local Authority, based on the Patient&#039;s CCG of registration.

PATIENTS_LA_OF_REGISTRATION_ID

Provider Submitted: Name of the Local Authority, based on the Patient&#039;s CCG of registration.

PATIENTS_LA_OF_REGISTRATION_NAME

Provider Submitted: ID of the Local Authority, based on the Patient&#039;s CCG of residence.

PATIENTS_LA_OF_RESIDENCE_ID

Provider Submitted: Name of the Local Authority, based on the Patient&#039;s CCG of residence.

PATIENTS_LA_OF_RESIDENCE_NAME

Provider Submitted: Lower Super Output Area based on PATIENTS_POSTCODE field - generated by the eRS system.

PATIENTS_LSOA

Provider Submitted: Comprising an outward code of 2-4 characters and an inward code of three characters. For example: LS16 6TN, where LS16 is the outward code and 6TN is the inward code. This column will present the outward code and first digit of the inward code portion of the e-RS Patients Postcode (derived from PDS)? e.g. LS16 6.

PATIENTS_PARTIAL_POSTCODE

Provider Submitted: The Patient&#039;s Registered GP Practice&#039;s ID.

PATIENTS_REG_GP_PRACTICE_ID

Provider Submitted: The Patient&#039;s Registered GP Practice&#039;s Name.

PATIENTS_REG_GP_PRACTICE_NAME

Provider Submitted: The previous UBRN in the Pathway chain (associated to the Request).

PREVIOUS_UBRN

Provider Submitted: Unique Identifier to PREVIOUS_UBRN.

PREVIOUS_UBRN_ID

Provider Submitted: The generic code for the requested Priority that was associated to the Service Search Criteria for the Request at the time the Activity Log entry was logged.

PRIORITY_CD

Provider Submitted: The generic description for the requested Priority that was associated to the Service Search Criteria for the Request at the time the Activity Log entry was logged.

PRIORITY_DESC

Provider Submitted: A referrer should add a referral letter to an Appointment Request within the Referral Letter Days (as per reference data) for the Request Priority (excluding Saturdays &amp; Sundays), from the date the Appointment Request was initiated (using appointment_initiated date). If this (in full calendar days) had been exceeded when the REFERRER_CLINICAL_INFORMATION_ADDED Activity was logged, then this column needs to say how many full calendar days it was breached by.

PRIORITY_TIME_LIMIT_BREACH

PROVIDER_ORG_ID

PROVIDER_ORG_NAME

Provider Submitted: The trust main site&#039;s code.

PROVIDER_ORG_TYPE_CODE

Provider Submitted: The trust main site&#039;s Organisation Type.

PROVIDER_ORG_TYPE_DESC

Provider Submitted: The code of the Proxied Business Function being undertaken.

PROXIED_BUS_FUNCTION_CD

Provider Submitted: The description of the Proxied Business Function being undertaken.

PROXIED_BUS_FUNCTION_DESC

Provider Submitted: Flag to denote the Proxied commissioner has been identified.

PROXIED_COMMISSIONER_FOUND

Provider Submitted: Where the Commisioner, performing the Activity, is logged into e-RS on behalf of another commissioner, then the commissioner ID they are logged on behalf of is presented.

PROXIED_COMMISSIONER_ID

Provider Submitted: Where the Commisioner, performing the Activity, is logged into e-RS on behalf of another commissioner, then the commissioner Name they are logged on behalf of is presented.

PROXIED_COMMISSIONER_NAME

Provider Submitted: Where the provider, performing the Activity, is logged into e-RS on behalf of another provider, then the provider ID they are logged on behalf of is presented.

PROXIED_ORG_ID

Provider Submitted: Where the provider, performing the Activity, is logged into e-RS on behalf of another provider, then the provider Name they are logged on behalf of is presented.

PROXIED_ORG_NAME

Provider Submitted: Where the Professional User, performing the Activity, is logged into e-RS on behalf of another Professional User, then the appropriate SDS User ID (smartcard ID) for the Professional User they are logged on behalf of is presented.

NHS e-Referral Service (e-RS)

Documentation

Coverage

Provenance

Origin

Temporal

Accessibility

Access

Usage

Format and Standards

Observations

Origin