Skip to content

Class: CoreDemographics

Pseudonymised patient demographic data (sex, DOB, ethnicity, LLSOA, etc.) for linkage with clinical datasets.

URI: demographics:CoreDemographics

 classDiagram
    class CoreDemographics
    click CoreDemographics href "../CoreDemographics/"
      CoreDemographics : admin_gender

      CoreDemographics : core_pid_published_runid

      CoreDemographics : date_of_death

      CoreDemographics : deceased

      CoreDemographics : dob_first_of_month

      CoreDemographics : ethnicity

      CoreDemographics : ethnicity_desc

      CoreDemographics : etl_date

      CoreDemographics : etl_id

      CoreDemographics : gender_identity

      CoreDemographics : gender_identity_desc

      CoreDemographics : llsoa

      CoreDemographics : marital_status

      CoreDemographics : marital_status_desc

      CoreDemographics : nationality

      CoreDemographics : ndo_run_date

      CoreDemographics : pseudo_nhs_number

      CoreDemographics : religion

      CoreDemographics : religion_desc

      CoreDemographics : sex

      CoreDemographics : sex_desc

Class Properties

Property Value
Tree Root Yes

Slots

Name Cardinality and Range Description Inheritance
etl_id 0..1
Integer		 Internal identifier for the ETL batch run that loaded this record direct
etl_date 0..1
Datetime		 Date and time the ETL process ran direct
core_pid_published_runid 0..1
Integer		 pipeline meta data direct
ndo_run_date 0..1
Date		 direct
pseudo_nhs_number 0..1
String		 The NHS NUMBER, the primary identifier of a PERSON, is a unique identifier fo... direct
dob_first_of_month 0..1
Date		 First of month proxy date of birth direct
deceased 0..1
Integer		 an integer code defining wether the participant is deceased direct
date_of_death 0..1
Date		 The date of the participant's death direct
sex 0..1
String		 The sex of PATIENTS intended to use a WARD indicated in the WARD OPERATIONAL ... direct
sex_desc 0..1
String		 The sex of PATIENTS intended to use a WARD indicated in the WARD OPERATIONAL ... direct
gender_identity 0..1
String		 The gender identity of a PERSON as stated by the PERSON direct
gender_identity_desc 0..1
String		 The gender identity of a PERSON as stated by the PERSON direct
admin_gender 0..1
String		 a code detailing the patient's gender from and administrative perspective direct
ethnicity 0..1
String		 The ethnicity of a PERSON, as specified by the PERSON direct
ethnicity_desc 0..1
String		 The ethnicity of a PERSON, as specified by the PERSON direct
marital_status 0..1
String		 An indicator to identify the legal marital status of a PERSON direct
marital_status_desc 0..1
String		 An indicator to identify the legal marital status of a PERSON direct
religion 0..1
String		 The RELIGIOUS OR OTHER BELIEF SYSTEM AFFILIATION of a PERSON , as specified ... direct
religion_desc 0..1
String		 The RELIGIOUS OR OTHER BELIEF SYSTEM AFFILIATION of a PERSON , as specified ... direct
nationality 0..1
String		 a text description of the patient's nationality direct
llsoa 0..1
String		 Lower Layer Super Output Area, derived from PATIENT POSTCODE for geographic a... direct

Identifier and Mapping Information

Schema Source

  • from schema: https://health-informatics-uon.github.io/nuh-data/datasets/demographics

Mappings

Mapping Type Mapped Value
self demographics:CoreDemographics
native demographics:CoreDemographics

LinkML Source

Direct

name: CoreDemographics
description: Pseudonymised patient demographic data (sex, DOB, ethnicity, LLSOA, etc.)
  for linkage with clinical datasets.
from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/demographics
slots:
- etl_id
- etl_date
- core_pid_published_runid
- ndo_run_date
- pseudo_nhs_number
- dob_first_of_month
- deceased
- date_of_death
- sex
- sex_desc
- gender_identity
- gender_identity_desc
- admin_gender
- ethnicity
- ethnicity_desc
- marital_status
- marital_status_desc
- religion
- religion_desc
- nationality
- llsoa
tree_root: true

Induced

name: CoreDemographics
description: Pseudonymised patient demographic data (sex, DOB, ethnicity, LLSOA, etc.)
  for linkage with clinical datasets.
from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/demographics
attributes:
  etl_id:
    name: etl_id
    annotations:
      sql_column:
        tag: sql_column
        value: ETL_ID
      sql_type:
        tag: sql_type
        value: INT
    description: Internal identifier for the ETL batch run that loaded this record.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/demographics
    rank: 1000
    owner: CoreDemographics
    domain_of:
    - CoreDemographics
    range: integer
    required: false
  etl_date:
    name: etl_date
    annotations:
      sql_column:
        tag: sql_column
        value: ETL_DATE
      sql_type:
        tag: sql_type
        value: DATETIME
    description: Date and time the ETL process ran.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/demographics
    rank: 1000
    owner: CoreDemographics
    domain_of:
    - CoreDemographics
    range: datetime
    required: false
  core_pid_published_runid:
    name: core_pid_published_runid
    annotations:
      sql_column:
        tag: sql_column
        value: CORE_PID_PUBLISHED_RUNID
      sql_type:
        tag: sql_type
        value: INT
    description: pipeline meta data
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/demographics
    rank: 1000
    owner: CoreDemographics
    domain_of:
    - CoreDemographics
    range: integer
    required: false
  ndo_run_date:
    name: ndo_run_date
    annotations:
      sql_column:
        tag: sql_column
        value: NDO_RUN_DATE
      sql_type:
        tag: sql_type
        value: DATE
    description: ''
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/demographics
    rank: 1000
    owner: CoreDemographics
    domain_of:
    - CoreDemographics
    range: date
    required: false
  pseudo_nhs_number:
    name: pseudo_nhs_number
    annotations:
      sql_column:
        tag: sql_column
        value: PSEUDO_NHS_NUMBER
      sql_type:
        tag: sql_type
        value: VARBINARY(100)
      sensitivity:
        tag: sensitivity
        value: pseudonymised
    description: The NHS NUMBER, the primary identifier of a PERSON, is a unique identifier
      for a PATIENT within the NHS in England and Wales. Pseudonymised for research
      use.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/demographics
    rank: 1000
    owner: CoreDemographics
    domain_of:
    - CoreDemographics
    range: string
    required: false
  dob_first_of_month:
    name: dob_first_of_month
    annotations:
      sql_column:
        tag: sql_column
        value: DOB_FIRST_OF_MONTH
      sql_type:
        tag: sql_type
        value: DATE
    description: First of month proxy date of birth.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/demographics
    rank: 1000
    owner: CoreDemographics
    domain_of:
    - CoreDemographics
    range: date
    required: false
  deceased:
    name: deceased
    annotations:
      sql_column:
        tag: sql_column
        value: DECEASED
      sql_type:
        tag: sql_type
        value: INT
    description: an integer code defining wether the participant is deceased
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/demographics
    rank: 1000
    owner: CoreDemographics
    domain_of:
    - CoreDemographics
    range: integer
    required: false
  date_of_death:
    name: date_of_death
    annotations:
      sql_column:
        tag: sql_column
        value: DATE_OF_DEATH
      sql_type:
        tag: sql_type
        value: DATE
    description: The date of the participant's death
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/demographics
    rank: 1000
    owner: CoreDemographics
    domain_of:
    - CoreDemographics
    range: date
    required: false
  sex:
    name: sex
    annotations:
      sql_column:
        tag: sql_column
        value: SEX
      sql_type:
        tag: sql_type
        value: NVARCHAR(6)
    description: 'The sex of PATIENTS intended to use a WARD indicated in the WARD
      OPERATIONAL PLANS, with the addition of Home Leave.

      https://www.datadictionary.nhs.uk/data_elements/sex_of_patients_code.html'
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/demographics
    rank: 1000
    owner: CoreDemographics
    domain_of:
    - CoreDemographics
    range: string
    required: false
  sex_desc:
    name: sex_desc
    annotations:
      sql_column:
        tag: sql_column
        value: SEX_DESC
      sql_type:
        tag: sql_type
        value: NVARCHAR(64)
    description: 'The sex of PATIENTS intended to use a WARD indicated in the WARD
      OPERATIONAL PLANS, with the addition of Home Leave.

      https://www.datadictionary.nhs.uk/data_elements/sex_of_patients_code.html'
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/demographics
    rank: 1000
    owner: CoreDemographics
    domain_of:
    - CoreDemographics
    range: string
    required: false
  gender_identity:
    name: gender_identity
    annotations:
      sql_column:
        tag: sql_column
        value: GENDER_IDENTITY
      sql_type:
        tag: sql_type
        value: NVARCHAR(6)
    description: 'The gender identity of a PERSON as stated by the PERSON.

      https://www.datadictionary.nhs.uk/attributes/gender_identity_code.html'
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/demographics
    rank: 1000
    owner: CoreDemographics
    domain_of:
    - CoreDemographics
    range: string
    required: false
  gender_identity_desc:
    name: gender_identity_desc
    annotations:
      sql_column:
        tag: sql_column
        value: GENDER_IDENTITY_DESC
      sql_type:
        tag: sql_type
        value: NVARCHAR(64)
    description: 'The gender identity of a PERSON as stated by the PERSON.

      https://www.datadictionary.nhs.uk/attributes/gender_identity_code.html'
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/demographics
    rank: 1000
    owner: CoreDemographics
    domain_of:
    - CoreDemographics
    range: string
    required: false
  admin_gender:
    name: admin_gender
    annotations:
      sql_column:
        tag: sql_column
        value: ADMIN_GENDER
      sql_type:
        tag: sql_type
        value: NVARCHAR(64)
    description: a code detailing the patient's gender from and administrative perspective
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/demographics
    rank: 1000
    owner: CoreDemographics
    domain_of:
    - CoreDemographics
    range: string
    required: false
  ethnicity:
    name: ethnicity
    annotations:
      sql_column:
        tag: sql_column
        value: ETHNICITY
      sql_type:
        tag: sql_type
        value: NVARCHAR(6)
    description: The ethnicity of a PERSON, as specified by the PERSON.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/demographics
    rank: 1000
    owner: CoreDemographics
    domain_of:
    - CoreDemographics
    range: string
    required: false
  ethnicity_desc:
    name: ethnicity_desc
    annotations:
      sql_column:
        tag: sql_column
        value: ETHNICITY_DESC
      sql_type:
        tag: sql_type
        value: NVARCHAR(64)
    description: The ethnicity of a PERSON, as specified by the PERSON.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/demographics
    rank: 1000
    owner: CoreDemographics
    domain_of:
    - CoreDemographics
    range: string
    required: false
  marital_status:
    name: marital_status
    annotations:
      sql_column:
        tag: sql_column
        value: MARITAL_STATUS
      sql_type:
        tag: sql_type
        value: NVARCHAR(6)
    description: 'An indicator to identify the legal marital status of a PERSON.

      https://www.datadictionary.nhs.uk/data_elements/person_marital_status.html'
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/demographics
    rank: 1000
    owner: CoreDemographics
    domain_of:
    - CoreDemographics
    range: string
    required: false
  marital_status_desc:
    name: marital_status_desc
    annotations:
      sql_column:
        tag: sql_column
        value: MARITAL_STATUS_DESC
      sql_type:
        tag: sql_type
        value: NVARCHAR(64)
    description: 'An indicator to identify the legal marital status of a PERSON.

      https://www.datadictionary.nhs.uk/data_elements/person_marital_status.html'
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/demographics
    rank: 1000
    owner: CoreDemographics
    domain_of:
    - CoreDemographics
    range: string
    required: false
  religion:
    name: religion
    annotations:
      sql_column:
        tag: sql_column
        value: RELIGION
      sql_type:
        tag: sql_type
        value: NVARCHAR(6)
    description: 'The RELIGIOUS OR OTHER BELIEF SYSTEM AFFILIATION  of a PERSON ,
      as specified by a PERSON .

      https://archive.datadictionary.nhs.uk/DD%20Release%20May%202024/attributes/religious_or_other_belief_system_affiliation_code.html'
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/demographics
    rank: 1000
    owner: CoreDemographics
    domain_of:
    - CoreDemographics
    range: string
    required: false
  religion_desc:
    name: religion_desc
    annotations:
      sql_column:
        tag: sql_column
        value: RELIGION_DESC
      sql_type:
        tag: sql_type
        value: NVARCHAR(64)
    description: 'The RELIGIOUS OR OTHER BELIEF SYSTEM AFFILIATION  of a PERSON ,
      as specified by a PERSON .

      https://archive.datadictionary.nhs.uk/DD%20Release%20May%202024/attributes/religious_or_other_belief_system_affiliation_code.html'
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/demographics
    rank: 1000
    owner: CoreDemographics
    domain_of:
    - CoreDemographics
    range: string
    required: false
  nationality:
    name: nationality
    annotations:
      sql_column:
        tag: sql_column
        value: NATIONALITY
      sql_type:
        tag: sql_type
        value: NVARCHAR(50)
    description: a text description of the patient's nationality
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/demographics
    rank: 1000
    owner: CoreDemographics
    domain_of:
    - CoreDemographics
    range: string
    required: false
  llsoa:
    name: llsoa
    annotations:
      sql_column:
        tag: sql_column
        value: LLSOA
      sql_type:
        tag: sql_type
        value: NVARCHAR(100)
    description: Lower Layer Super Output Area, derived from PATIENT POSTCODE for
      geographic analysis while preserving patient privacy.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/demographics
    rank: 1000
    owner: CoreDemographics
    domain_of:
    - CoreDemographics
    range: string
    required: false
tree_root: true