tblDEMOGRAPHICS


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PATIENT_ID int identity 4 √ null
lnkPatientAddress.PatientID FK_lnkPatientAddress_tblDEMOGRAPHICSR
tblLinkedReferrals.PatientID FK_tblLinkedReferrals_tblDEMOGRAPHICSR
tblMAIN_REFERRALS.PATIENT_ID FK_tblMAIN_REFERRALS_tblDEMOGRAPHICSC
tblPALLIATIVE_CARE.PATIENT_ID FK_tblPALLIATIVE_CARE_tblDEMOGRAPHICSC
tblSPINAL_CORD_COMPRESSION.PATIENT_ID FK_tblSPINAL_CORD_COMPRESSION_tblDEMOGRAPHICSC

Demographic Record ID
N1_1_NHS_NUMBER varchar 10 null

NHS Number
NHS_NUMBER_STATUS varchar 3 √ null

NHS Number Status
L_RA3_RID varchar 50 √ null

Hospital Number for RA3 (Bristol specific)
L_RA7_RID varchar 50 √ null

Hospital Number for RA7 (Bristol specific)
L_RVJ01_RID varchar 50 √ null

Hospital Number for RVJ01 (Bristol specific)
TEMP_ID varchar 255 √ null
ltblTEMP_NHS_NUMBERS.TEMP_ID Implied ConstraintR
L_NSTS_STATUS int 4 √ null

Whether NHS Number is valid (1 - Valid, 9 - Invalid)
N1_2_HOSPITAL_NUMBER varchar 20 √ null

Hospital Number
L_TITLE int 4 √ null

Title
N1_5_SURNAME varchar 60 √ null

Family Name
N1_6_FORENAME varchar 50 √ null

Given Name
N1_7_ADDRESS_1 varchar 150 √ null

Address at Diagnosis - Line 1
N1_7_ADDRESS_2 varchar 150 √ null

Address at Diagnosis - Line 2
N1_7_ADDRESS_3 varchar 150 √ null

Address at Diagnosis - Line 3
N1_7_ADDRESS_4 varchar 150 √ null

Address at Diagnosis - Line 4
N1_7_ADDRESS_5 varchar 150 √ null

Address at Diagnosis - Line 5
N1_8_POSTCODE varchar 10 √ null

Address at Diagnosis - Postcode
N1_9_SEX char 1 √ null
ltblGENDER.GENDER_CODE FK_ltblGENDER_N1_9_SEXR

Gender
N1_10_DATE_BIRTH date 20 √ null

Date of Birth
N1_11_GP_CODE varchar 8 √ null

Registered GP - GMC Code
N1_12_GP_PRACTICE_CODE varchar 15 √ null

Registered GP - Practice Code
N1_13_PCT varchar 5 √ null

Registered GP - PCT Code
N1_14_SURNAME_BIRTH varchar 60 √ null

Family Name at Birth
N1_15_ETHNICITY varchar 50 √ null

Ethnicity
PAT_PREF_NAME varchar 50 √ null

Preferred Name
PAT_OCCUPATION varchar 50 √ null

Occupation
PAT_SOCIAL_CLASS varchar 5 √ null

Social Class
PAT_LIVES_ALONE bit 1 ((0))

Lives Alone
MARITAL_STATUS char 1 √ null

Marital Status
PAT_PREF_LANGUAGE varchar 50 √ null

Preferred Language
PAT_PREF_CONTACT int 4 √ null

Preferred Contact Method
L_DEATH_STATUS int 4 √ null

Patient Status (0 - Alive, 1 - Dead)
N15_1_DATE_DEATH date 20 √ null

Date of Death
N15_2_DEATH_LOCATION int 4 √ null

Place of Death
N15_3_DEATH_CAUSE int 4 √ null

Cause of Death Indentification Method
N15_4_DEATH_CANCER int 4 √ null

Cancer Related Death
N15_5_DEATH_CODE_1 varchar 5 √ null

Cause of Death - Immediate
N15_6_DEATH_CODE_2 varchar 5 √ null

Cause of Death - Condition Giving Rise to Death
N15_7_DEATH_CODE_3 varchar 5 √ null

Cause of Death - Underlying Condition Leading to Death
N15_8_DEATH_CODE_4 varchar 5 √ null

Cause of Death - Significant Condition Not Directly Related
N15_9_DEATH_DISCREPANCY int 4 √ null

Death Discrepancy
N_CC4_TOWN varchar 50 √ null

Child Additional Details - Town (Birth)
N_CC5_COUNTRY varchar 3 √ null

Child Additional Details - Country (Birth)
N_CC6_M_SURNAME varchar 35 √ null

Biological Mother - Surname
N_CC7_M_CLASS varchar 1 √ null

Biological Mother - Classification
N_CC8_M_FORENAME varchar 35 √ null

Biological Mother - Forename
N_CC9_M_DOB date 20 √ null

Biological Mother - Date of Birth
N_CC10_M_TOWN varchar 50 √ null

Biological Mother - Birth Town
N_CC11_M_COUNTRY varchar 3 √ null

Biological Mother - Birth Country
N_CC12_M_OCC varchar 50 √ null

Biological Mother - Occupation (Birth)
N_CC13_M_OCC_DIAG varchar 50 √ null

Biological Mother - Occupation (Diagnosis)
N_CC6_F_SURNAME varchar 35 √ null

Biological Father - Surname
N_CC7_F_CLASS varchar 1 √ null

Biological Father - Classification
N_CC8_F_FORENAME varchar 35 √ null

Biological Father - Forename
N_CC9_F_DOB date 20 √ null

Biological Father - Date of Birth
N_CC10_F_TOWN varchar 50 √ null

Biological Father - Birth Town
N_CC11_F_COUNTRY varchar 3 √ null

Biological Father - Birth Country
N_CC12_F_OCC varchar 50 √ null

Biological Father - Occupation (Birth)
N_CC13_F_OCC_DIAG varchar 50 √ null

Biological Father - Occupation (Diagnosis)
N_CC14_MULTI_BIRTH int 4 √ null

Part of Multiple Birth
R_POST_MORTEM bit 1 ((0))

Post Mortem Undertaken
R_DAY_PHONE varchar 50 √ null

Day Time Phone No.
DAY_PHONE_EXT varchar 10 √ null
R_EVE_PHONE varchar 50 √ null

Evening Phone No.
EVE_PHONE_EXT varchar 10 √ null
R_DEATH_TREATMENT varchar 1 √ null

Was Death Related to Treatment
R_PM_DETAILS varchar 255 √ null

Post Mortem Details
L_IATROGENIC_DEATH bit 1 ((0))

Iatrogenic Death
L_INFECTION_DEATH bit 1 ((0))

Death due to Infection
L_DEATH_COMMENTS varchar 255 √ null

Death Comments
RELIGION int 4 √ null

Religion
CONTACT_DETAILS varchar 255 √ null

Preferred Contact Method
NOK_NAME varchar 100 √ null

Next of Kin - Name
NOK_ADDRESS_1 varchar 150 √ null

Next of Kin - Address Line 1
NOK_ADDRESS_2 varchar 150 √ null

Next of Kin - Address Line 2
NOK_ADDRESS_3 varchar 150 √ null

Next of Kin - Address Line 3
NOK_ADDRESS_4 varchar 150 √ null

Next of Kin - Address Line 4
NOK_ADDRESS_5 varchar 150 √ null

Next of Kin - Address Line 5
NOK_POSTCODE varchar 10 √ null

Next of Kin - Postcode
NOK_CONTACT varchar 255 √ null

Next of Kin - Contact Details
NOK_RELATIONSHIP varchar 4 √ null

Next of Kin - Relationship to patient
PAT_DEPENDANTS varchar 2147483647 √ null

Dependants
CARER_NAME varchar 100 √ null

Carer 1 - Name
CARER_ADDRESS_1 varchar 150 √ null

Carer 1 - Address Line 1
CARER_ADDRESS_2 varchar 150 √ null

Carer 1 - Address Line 2
CARER_ADDRESS_3 varchar 150 √ null

Carer 1 - Address Line 3
CARER_ADDRESS_4 varchar 150 √ null

Carer 1 - Address Line 4
CARER_ADDRESS_5 varchar 150 √ null

Carer 1 - Address Line 5
CARER_POSTCODE varchar 10 √ null

Carer 1 - Postcode
CARER_CONTACT varchar 255 √ null

Carer 1 - Contact Details
CARER_RELATIONSHIP varchar 1 √ null

Carer 1 - Relationship to patient
CARER1_TYPE varchar 4 √ null

Carer 1 - Type
CARER2_NAME varchar 100 √ null

Carer 2 - Name
CARER2_ADDRESS_1 varchar 150 √ null

Carer 2 - Address Line 1
CARER2_ADDRESS_2 varchar 150 √ null

Carer 2 - Address Line 2
CARER2_ADDRESS_3 varchar 150 √ null

Carer 2 - Address Line 3
CARER2_ADDRESS_4 varchar 150 √ null

Carer 2 - Address Line 4
CARER2_ADDRESS_5 varchar 150 √ null

Carer 2 - Address Line 5
CARER2_POSTCODE varchar 10 √ null

Carer 2 - Postcode
CARER2_CONTACT varchar 255 √ null

Carer 2 - Contact Details
CARER2_RELATIONSHIP varchar 4 √ null

Carer 2 - Relationship to patient
CARER2_TYPE varchar 4 √ null

Carer 2 - Type
PT_AT_RISK bit 1 ((0))

Patient At Risk
REASON_RISK varchar 2147483647 √ null

At Risk Reason
GESTATION varchar 100 √ null

Gestation/Birth Weight
CAUSE_OF_DEATH_UROLOGY int 4 √ null

Not in use
AVOIDABLE_DEATH bit 1 √ null

Not in use
AVOIDABLE_DETAILS varchar 255 √ null

Not in use
OTHER_DEATH_CAUSE_UROLOGY varchar 255 √ null

Not in use
ACTION_ID int 4 √ null

Latest Audit ID for Demographic Data
STATED_GENDER_CODE varchar 2 √ null

Person Stated Gender
CAUSE_OF_DEATH_UROLOGY_FUP int 4 √ null
DEATH_WITHIN_30_DAYS_OF_TREAT int 4 √ null
DEATH_CAUSE_WITHIN_30_DAYS_OF_TREAT int 4 √ null
DEATH_CAUSE_LATER_DATE int 4 √ null
RegisteredPractice int 4 √ null
Practice.ID FK_tblDEMOGRAPHICS_PracticeR
RegisteredGP int 4 √ null
GP.ID FK_tblDEMOGRAPHICS_GPR
PersonSexualOrientation int 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_tblDEMOGRAPHICS Primary key Asc PATIENT_ID
IX_CWTBasic Performance Asc PATIENT_ID
IX_tblDEMOGRAPHICS Performance Asc/Asc/Asc/Asc/Asc N1_1_NHS_NUMBER + N1_2_HOSPITAL_NUMBER + N1_5_SURNAME + N1_6_FORENAME + N1_10_DATE_BIRTH
IX_tblDEMOGRAPHICS_N1_2_HOSPITAL_NUMBER Performance Asc N1_2_HOSPITAL_NUMBER

Relationships

Close relationships within degrees of separation