Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| PATIENT_ID | int identity | 4 | null |
|
|
|||||
| N1_1_NHS_NUMBER | varchar | 10 | null |
|
|
|||||
| L_RA3_RID | varchar | 50 | √ | null |
|
|
||||
| L_RA7_RID | varchar | 50 | √ | null |
|
|
||||
| L_RVJ01_RID | varchar | 50 | √ | null |
|
|
||||
| TEMP_ID | varchar | 255 | √ | null |
|
|
||||
| L_NSTS_STATUS | int | 4 | √ | null |
|
|
||||
| N1_2_HOSPITAL_NUMBER | varchar | 20 | √ | null |
|
|
||||
| L_TITLE | int | 4 | √ | null |
|
|
||||
| N1_5_SURNAME | varchar | 60 | √ | null |
|
|
||||
| N1_6_FORENAME | varchar | 50 | √ | null |
|
|
||||
| N1_7_ADDRESS_1 | varchar | 150 | √ | null |
|
|
||||
| N1_7_ADDRESS_2 | varchar | 150 | √ | null |
|
|
||||
| N1_7_ADDRESS_3 | varchar | 150 | √ | null |
|
|
||||
| N1_7_ADDRESS_4 | varchar | 150 | √ | null |
|
|
||||
| N1_7_ADDRESS_5 | varchar | 150 | √ | null |
|
|
||||
| N1_8_POSTCODE | varchar | 10 | √ | null |
|
|
||||
| N1_9_SEX | int | 4 | √ | null |
|
|
||||
| N1_10_DATE_BIRTH | date | 20 | √ | null |
|
|
||||
| N1_11_GP_CODE | varchar | 8 | √ | null |
|
|
||||
| N1_12_GP_PRACTICE_CODE | varchar | 15 | √ | null |
|
|
||||
| N1_13_PCT | varchar | 5 | √ | null |
|
|
||||
| N1_14_SURNAME_BIRTH | varchar | 60 | √ | null |
|
|
||||
| N1_15_ETHNICITY | varchar | 50 | √ | null |
|
|
||||
| PAT_PREF_NAME | varchar | 50 | √ | null |
|
|
||||
| PAT_OCCUPATION | varchar | 50 | √ | null |
|
|
||||
| PAT_SOCIAL_CLASS | varchar | 5 | √ | null |
|
|
||||
| PAT_LIVES_ALONE | bit | 1 | null |
|
|
|||||
| MARITAL_STATUS | char | 1 | √ | null |
|
|
||||
| PAT_PREF_LANGUAGE | varchar | 50 | √ | null |
|
|
||||
| PAT_PREF_CONTACT | int | 4 | √ | null |
|
|
||||
| L_DEATH_STATUS | int | 4 | √ | null |
|
|
||||
| N15_1_DATE_DEATH | date | 20 | √ | null |
|
|
||||
| N15_2_DEATH_LOCATION | int | 4 | √ | null |
|
|
||||
| N15_3_DEATH_CAUSE | int | 4 | √ | null |
|
|
||||
| N15_4_DEATH_CANCER | int | 4 | √ | null |
|
|
||||
| N15_5_DEATH_CODE_1 | varchar | 5 | √ | null |
|
|
||||
| N15_6_DEATH_CODE_2 | varchar | 5 | √ | null |
|
|
||||
| N15_7_DEATH_CODE_3 | varchar | 5 | √ | null |
|
|
||||
| N15_8_DEATH_CODE_4 | varchar | 5 | √ | null |
|
|
||||
| N15_9_DEATH_DISCREPANCY | int | 4 | √ | null |
|
|
||||
| N_CC4_TOWN | varchar | 50 | √ | null |
|
|
||||
| N_CC5_COUNTRY | varchar | 3 | √ | null |
|
|
||||
| N_CC6_M_SURNAME | varchar | 35 | √ | null |
|
|
||||
| N_CC7_M_CLASS | varchar | 1 | √ | null |
|
|
||||
| N_CC8_M_FORENAME | varchar | 35 | √ | null |
|
|
||||
| N_CC9_M_DOB | date | 20 | √ | null |
|
|
||||
| N_CC10_M_TOWN | varchar | 50 | √ | null |
|
|
||||
| N_CC11_M_COUNTRY | varchar | 3 | √ | null |
|
|
||||
| N_CC12_M_OCC | varchar | 50 | √ | null |
|
|
||||
| N_CC13_M_OCC_DIAG | varchar | 50 | √ | null |
|
|
||||
| N_CC6_F_SURNAME | varchar | 35 | √ | null |
|
|
||||
| N_CC7_F_CLASS | varchar | 1 | √ | null |
|
|
||||
| N_CC8_F_FORENAME | varchar | 35 | √ | null |
|
|
||||
| N_CC9_F_DOB | date | 20 | √ | null |
|
|
||||
| N_CC10_F_TOWN | varchar | 50 | √ | null |
|
|
||||
| N_CC11_F_COUNTRY | varchar | 3 | √ | null |
|
|
||||
| N_CC12_F_OCC | varchar | 50 | √ | null |
|
|
||||
| N_CC13_F_OCC_DIAG | varchar | 50 | √ | null |
|
|
||||
| N_CC14_MULTI_BIRTH | int | 4 | √ | null |
|
|
||||
| R_POST_MORTEM | bit | 1 | null |
|
|
|||||
| R_DAY_PHONE | varchar | 50 | √ | null |
|
|
||||
| R_EVE_PHONE | varchar | 50 | √ | null |
|
|
||||
| R_DEATH_TREATMENT | varchar | 1 | √ | null |
|
|
||||
| R_PM_DETAILS | varchar | 255 | √ | null |
|
|
||||
| L_IATROGENIC_DEATH | bit | 1 | null |
|
|
|||||
| L_INFECTION_DEATH | bit | 1 | null |
|
|
|||||
| L_DEATH_COMMENTS | varchar | 255 | √ | null |
|
|
||||
| RELIGION | int | 4 | √ | null |
|
|
||||
| CONTACT_DETAILS | varchar | 255 | √ | null |
|
|
||||
| NOK_NAME | varchar | 100 | √ | null |
|
|
||||
| NOK_ADDRESS_1 | varchar | 150 | √ | null |
|
|
||||
| NOK_ADDRESS_2 | varchar | 150 | √ | null |
|
|
||||
| NOK_ADDRESS_3 | varchar | 150 | √ | null |
|
|
||||
| NOK_ADDRESS_4 | varchar | 150 | √ | null |
|
|
||||
| NOK_ADDRESS_5 | varchar | 150 | √ | null |
|
|
||||
| NOK_POSTCODE | varchar | 10 | √ | null |
|
|
||||
| NOK_CONTACT | varchar | 255 | √ | null |
|
|
||||
| NOK_RELATIONSHIP | varchar | 4 | √ | null |
|
|
||||
| PAT_DEPENDANTS | varchar | 2147483647 | √ | null |
|
|
||||
| CARER_NAME | varchar | 100 | √ | null |
|
|
||||
| CARER_ADDRESS_1 | varchar | 150 | √ | null |
|
|
||||
| CARER_ADDRESS_2 | varchar | 150 | √ | null |
|
|
||||
| CARER_ADDRESS_3 | varchar | 150 | √ | null |
|
|
||||
| CARER_ADDRESS_4 | varchar | 150 | √ | null |
|
|
||||
| CARER_ADDRESS_5 | varchar | 150 | √ | null |
|
|
||||
| CARER_POSTCODE | varchar | 10 | √ | null |
|
|
||||
| CARER_CONTACT | varchar | 255 | √ | null |
|
|
||||
| CARER_RELATIONSHIP | varchar | 1 | √ | null |
|
|
||||
| CARER1_TYPE | varchar | 4 | √ | null |
|
|
||||
| CARER2_NAME | varchar | 100 | √ | null |
|
|
||||
| CARER2_ADDRESS_1 | varchar | 150 | √ | null |
|
|
||||
| CARER2_ADDRESS_2 | varchar | 150 | √ | null |
|
|
||||
| CARER2_ADDRESS_3 | varchar | 150 | √ | null |
|
|
||||
| CARER2_ADDRESS_4 | varchar | 150 | √ | null |
|
|
||||
| CARER2_ADDRESS_5 | varchar | 150 | √ | null |
|
|
||||
| CARER2_POSTCODE | varchar | 10 | √ | null |
|
|
||||
| CARER2_CONTACT | varchar | 255 | √ | null |
|
|
||||
| CARER2_RELATIONSHIP | varchar | 4 | √ | null |
|
|
||||
| CARER2_TYPE | varchar | 4 | √ | null |
|
|
||||
| PT_AT_RISK | bit | 1 | null |
|
|
|||||
| REASON_RISK | varchar | 2147483647 | √ | null |
|
|
||||
| GESTATION | varchar | 100 | √ | null |
|
|