Table Detail Report
NOMEN_CAT_LIST
Column Section | Top of Page |
Table-level Detail
Description: | Nomenclature Category List |
Definition: | Identifies the children for each Nomenclature Category. |
Table Type: | REFERENCE |
Column Detail - NOMEN_CAT_LIST
Column Name | Type | Null? | Definition |
---|---|---|---|
CHILD_CATEGORY_ID | DOUBLE | N | Unique Identifier for child categories. |
CHILD_FLAG | DOUBLE | Y | Flag used to identify the kind of list item. |
LIST_SEQUENCE | DOUBLE | Y | The sequence of the child objects with the parent. |
NOMENCLATURE_ID | DOUBLE | N | Identifies the Nomenclature Item in the category. |
NOMEN_CAT_LIST_ID | DOUBLE | N | Unique identifier for a row in the Nomenclature Category List table. |
PARENT_CATEGORY_ID | DOUBLE | N | Identifies the "owner", or parent, category for the list item. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | 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_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | 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_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
NORMALIZED_STRING_INDEX
Column Section | Top of Page |
Table-level Detail
Description: | Normalized String Index |
Definition: | Connects each individual word or phrase in any string to all its related strings. |
Table Type: | REFERENCE |
Column Detail - NORMALIZED_STRING_INDEX
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | 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_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | Y | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
BEG_EFFECTIVE_DT_TM | DATETIME | N | 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. |
END_EFFECTIVE_DT_TM | DATETIME | N | 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. |
LANGUAGE_CD | DOUBLE | N | The language that the string is expressed. |
NOMENCLATURE_ID | DOUBLE | N | This is the value of the unique primary identifier of the nomenclature table. It is an internal system assigned number. |
NORMALIZED_STRING | VARCHAR(255) | Y | A normalized string is the result of breaking the string down into its constituent words, lower-casing each word, converting each word to its canonical form, and sorting the words in alphabetic order. |
NORMALIZED_STRING_A_NLS | VARCHAR(1020) | Y | NORMALIZED_STRING_A_NLS column |
NORMALIZED_STRING_ID | DOUBLE | N | This is the value of the unique primary identifier of the normalized string index table. It is an internal system assigned number. |
NORMALIZED_STRING_NLS | VARCHAR(255) | Y | This column is used for non-English based strings with the NLSSORT function. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | 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_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | 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_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
NORMAL_STRING_INDEX_LOAD
Column Section | Top of Page |
Table-level Detail
Description: | NORMALIZED_STRING_INDEX_LOAD |
Definition: | NSI Load Table |
Table Type: | REFERENCE |
Column Detail - NORMAL_STRING_INDEX_LOAD
Column Name | Type | Null? | Definition |
---|---|---|---|
CMTI_IDENT | VARCHAR(60) | N | First column of the Unique Identifier for rows in this table. A global unique identifier from an outside source. |
NOMENCLATURE_ID | DOUBLE | N | Foreign Key from the NOMENCLATURE table |
NORMALIZED_STRING | VARCHAR(255) | N | The Normalized String data |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | 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_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | 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_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
PCT_SHA_DATA
Column Section | Top of Page |
Table-level Detail
Description: | PCT SHA Data |
Definition: | This table stores relationships between the Postcode, Primary Care Trust, and Strategic Health Authority residence |
Table Type: | REFERENCE |
Column Detail - PCT_SHA_DATA
Column Name | Type | Null? | Definition |
---|---|---|---|
BEG_EFFECTIVE_DT_TM | DATETIME | Y | 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. |
BTHAS_SC_NBR | DOUBLE | Y | Barriers To Housing And Services Score |
BTHAS_SC_R_NBR | DOUBLE | Y | Rank Of Barriers To Housing And Services Score (Where 1 Is Most Deprived) |
CAD_SC_NBR | DOUBLE | Y | Crime And Disorder Score |
CAD_SC_R_NBR | DOUBLE | Y | Rank Of Crime and Disorder Score (Where 1 Is Most Deprived) |
CANNET_TXT | VARCHAR(3) | Y | The former cancer network that each postcode falls within. Closed in March 2013 and replaced with Strategic Clinical Networks. |
CANREG_TXT | VARCHAR(5) | Y | The cancer registry that each postcode falls within. |
CENED_TXT | VARCHAR(6) | Y | Same as PSED except a Census code is provided |
CTRY_TXT | VARCHAR(9) | N | The code for the appropriate country |
CYPSD_SC_NBR | DOUBLE | Y | Children/Young People Sub-Domain Score |
CYPSD_SC_R_NBR | DOUBLE | Y | Rank of Children/Young People Sub-Domain Score (Where 1 Is Most Deprived) |
DOINTR_DT_TM | DATETIME | N | The most recent occurrence of the postcode¿s date of introduction. |
DOTERM_DT_TM | DATETIME | Y | If present, the most recent occurrence of the postcode¿s date of termination, otherwise 31-DEC-2100 indicates live postcode. |
EDIND_FLAG | DOUBLE | N | Shows the status of the assigned ED. |
EMPL_SC_NBR | DOUBLE | Y | Employment Score |
EMPL_SC_R_NBR | DOUBLE | Y | Rank Of Employment Score (Where 1 Is Most Deprived) |
END_EFFECTIVE_DT_TM | DATETIME | Y | 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. |
ESAT_SC_NBR | DOUBLE | Y | Education Skills And Training Score |
ESAT_SC_R_NBR | DOUBLE | Y | Rank Of Education Skills And Training Score (Where 1 Is Most Deprived) |
GBSD_SC_NBR | DOUBLE | Y | Geographical Barriers Sub-Domain Score |
GBSD_SC_R_NBR | DOUBLE | Y | Rank of Geographical Barriers Sub-Domain Score (Where 1 Is Most Deprived) |
GOR_TXT | VARCHAR(9) | Y | The Region code for each postcode. |
HDAD_SC_NBR | DOUBLE | Y | Health Deprivation And Disability Score |
HDAD_SC_R_NBR | DOUBLE | Y | Rank Of Health Deprivation And Disability Score (Where 1 Is Most Deprived) |
HRO_TXT | VARCHAR(3) | Y | The former Pan SHA responsible for the associated strategic health authority for each postcode in England. |
IDACI_SC_NBR | DOUBLE | Y | Income Deprivation Affecting Children Index Score |
IDACI_SC_R_NBR | DOUBLE | Y | Rank Of Income Deprivation Affecting Children Index Score (Where 1 Is Most Deprived) |
IDAOPI_SC_NBR | DOUBLE | Y | Income Deprivation Affecting Older People Index Score |
IDAOPI_SC_R_NBR | DOUBLE | Y | Rank Of Income Deprivation Affecting Older People Index Score (Where 1 Is Most Deprived) |
IMD_SC_NBR | DOUBLE | Y | Index of Mass Deprivation Score |
IMD_SC_R_NBR | DOUBLE | Y | Rank of Index of Mass Deprivation Score (Where 1 Is Most Deprived) |
INC_SC_NBR | DOUBLE | Y | Income Score |
INC_SC_R_NBR | DOUBLE | Y | Rank Of Income Score (Where 1 Is Most Deprived) |
ISD_SC_NBR | DOUBLE | Y | Indoors Sub-Domain Score |
ISD_SC_R_NBR | DOUBLE | Y | Rank of Indoors Sub-Domain Score (Where 1 Is Most Deprived) |
LE_SC_NBR | DOUBLE | Y | Living Environment Score |
LE_SC_R_NBR | DOUBLE | Y | Rank Of Living Environment Score (Where 1 Is Most Deprived) |
LSOA01_TXT | VARCHAR(9) | N | The 2001 Census Lower Layer SOA code for England and Wales, SOA code for Northern Ireland and data zone code for Scotland. |
LSOA11_TXT | VARCHAR(9) | Y | The 2011 Census lower layer SOA code for England and Wales, SOA code for Northern Ireland and data zone code for Scotland. |
MSOA01_TXT | VARCHAR(9) | Y | The 2001 Census Middle Layer SOA (MSOA) code for England and Wales and intermediate zone for Scotland. |
MSOA11_TXT | VARCHAR(9) | Y | The 2011 Census middle layer SOA (MSOA) code for England and Wales and intermediate zone for Scotland. |
NHSAT_TXT | VARCHAR(3) | Y | The Area Team code for the postcode. |
NHSCR_TXT | VARCHAR(3) | Y | The Commissioning Region code for the postcode. |
OA01_TXT | VARCHAR(10) | Y | The 2001 Census Output Areas were built from unit postcodes and constrained to 2003 `statistical¿ wards, and they form the building bricks for defining higher level geographies. |
OA11_TXT | VARCHAR(9) | Y | The 2011 Census output areas were based on 2001 Census output areas, and they form the building bricks for defining higher level geographies. |
ODSLAUA_TXT | VARCHAR(3) | Y | Organisation Data Service allocated identifiers for top-tier Local Authority organisations in England and Wales to which the postcode has been assigned |
OLDHA_TXT | VARCHAR(3) | Y | The health authority existing prior to the reorganisation of health areas (England in 2002, Wales in 2003). |
OLDHRO_TXT | VARCHAR(3) | Y | The pre-Pan SHA IT Cluster responsible for the associated strategic health authority for each postcode in England. |
OLDPCT_TXT | VARCHAR(3) | Y | The pre-October 2006 code for the primary care areas in England and Wales; primary care areas do not exist in Scotland or Northern Ireland. |
OSCTY_TXT | VARCHAR(9) | Y | The county to which the postcode has been assigned. |
OSD_SC_NBR | DOUBLE | Y | Outdoors Sub-Domain Score |
OSD_SC_R_NBR | DOUBLE | Y | Rank of Outdoors Sub-Domain Score(Where 1 Is Most Deprived) |
OSEAST100M_NBR | DOUBLE | Y | The Ordnance Survey postcode grid reference Easting to 100 metre resolution; blank for postcodes in the Channel Islands and the Isle of Man. Grid references for postcodes in Northern Ireland relate to the Irish Grid system. |
OSEAST1M_NBR | DOUBLE | Y | The Ordnance Survey postcode grid reference Easting to 1 metre resolution; blank for postcodes in the Channel Islands and the Isle of Man. Grid references for postcodes in Northern Ireland relate to the Irish Grid system. |
OSGRDIND_FLAG | DOUBLE | N | Shows the status of the assigned grid reference. |
OSHAPREV_TXT | VARCHAR(3) | Y | The health area code for the postcode prior to the NHS reorganisation on 1 July 2006. |
OSLAUA_TXT | VARCHAR(9) | Y | The district/UA to which the postcode has been assigned. |
OSNRTH100M_NBR | DOUBLE | Y | The Ordnance Survey postcode grid reference Northing to 100 metre resolution; blank for postcodes in the Channel Islands and the Isle of Man. Grid references for postcodes in Northern Ireland relate to the Irish Grid system. |
OSNRTH1M_NBR | DOUBLE | Y | The Ordnance Survey postcode grid reference Northing to 1 metre resolution; blank for postcodes in the Channel Islands and the Isle of Man. Grid references for postcodes in Northern Ireland relate to the Irish Grid system. |
OSWARD_TXT | VARCHAR(9) | Y | The administrative/electoral area to which the postcode has been assigned. |
PCDS_TXT | VARCHAR(8) | N | Unformatted postcode:2, 3 or 4-character outward codeSingle space () 3-character inward codePseudo country postcode as used by the NHS. |
PCON_TXT | VARCHAR(9) | Y | The Westminster Parliamentary Constituency code for each postcode. Pseudo codes are included for Channel Islands and Isle of Man. |
PCT_RESIDENCE | VARCHAR(3) | N | PCT/CT of Residence |
PCT_TXT | VARCHAR(3) | Y | The code for the Primary Care areas in England, LHBs in Wales, CHPs in Scotland, LCG in Northern Ireland and PHD in the Isle of Man prior to the abolition of PCTs in 2013; there are no equivalent areas in the Channel Islands |
POSTCODE | VARCHAR(8) | N | Residence Postcode |
POSTCODE_KEY | VARCHAR(8) | Y | key value form of Residence Postcode |
PSED_TXT | VARCHAR(8) | Y | The code for the 1991 Census ED. |
SCN_TXT | VARCHAR(3) | Y | The Strategic Clinical Network that each postcode falls within. Introduced in April 2013. |
SHA_RESIDENCE | VARCHAR(3) | N | Strategic Health Authority of Residence |
SSD_SC_NBR | DOUBLE | Y | Skills Sub-Domain Score |
SSD_SC_R_NBR | DOUBLE | Y | Rank of Skills Sub-Domain Score (Where 1 Is Most Deprived) |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | 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_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | 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_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
UR01IND_TXT | VARCHAR(1) | Y | The 2001 Census Urban and rural classification of Output Areas for England and Wales, Scotland and Northern Ireland. |
USERTYPE_FLAG | DOUBLE | N | Shows whether the postcode is a small or large user.0 = small user;1 = large user |
WARD98_TXT | VARCHAR(6) | Y | The 1998 administrative and electoral areas for each postcode. |
WBSD_SC_NBR | DOUBLE | Y | Wider Barriers Sub-Domain Score |
WBSD_SC_R_NBR | DOUBLE | Y | Rank of Wider Barriers Sub-Domain Score (Where 1 Is Most Deprived) |
PCT_SHA_DATA_LOAD
Column Section | Top of Page |
Table-level Detail
Description: | PCT SHA Data Load |
Definition: | This is a temporary LOAD table. |
Table Type: | REFERENCE |
Column Detail - PCT_SHA_DATA_LOAD
Column Name | Type | Null? | Definition |
---|---|---|---|
BTHAS_SC_NBR | DOUBLE | Y | Barriers To Housing And Services Score |
BTHAS_SC_R_NBR | DOUBLE | Y | Rank Of Barriers To Housing And Services Score (Where 1 Is Most Deprived) |
CAD_SC_NBR | DOUBLE | Y | Crime And Disorder Score |
CAD_SC_R_NBR | DOUBLE | Y | Rank Of Crime and Disorder Score (Where 1 Is Most Deprived) |
CANNET_TXT | VARCHAR(3) | Y | The former cancer network that each postcode falls within. Closed in March 2013 and replaced with Strategic Clinical Networks. |
CANREG_TXT | VARCHAR(5) | Y | The cancer registry that each postcode falls within. |
CENED_TXT | VARCHAR(6) | Y | Same as PSED except a Census code is provided |
CTRY_TXT | VARCHAR(9) | N | The code for the appropriate country |
CYPSD_SC_NBR | DOUBLE | Y | Children/Young People Sub-Domain Score |
CYPSD_SC_R_NBR | DOUBLE | Y | Rank of Children/Young People Sub-Domain Score (Where 1 Is Most Deprived) |
DOINTR_DT_TM | DATETIME | N | The most recent occurrence of the postcode¿s date of introduction. |
DOTERM_DT_TM | DATETIME | Y | If present, the most recent occurrence of the postcode¿s date of termination, otherwise 31-DEC-2100 indicates live postcode. |
EDIND_FLAG | DOUBLE | Y | Shows the status of the assigned ED. |
EMPL_SC_NBR | DOUBLE | Y | Employment Score |
EMPL_SC_R_NBR | DOUBLE | Y | Rank Of Employment Score (Where 1 Is Most Deprived) |
ESAT_SC_NBR | DOUBLE | Y | Education Skills And Training Score |
ESAT_SC_R_NBR | DOUBLE | Y | Rank Of Education Skills And Training Score (Where 1 Is Most Deprived) |
GBSD_SC_NBR | DOUBLE | Y | Geographical Barriers Sub-Domain Score |
GBSD_SC_R_NBR | DOUBLE | Y | Rank of Geographical Barriers Sub-Domain Score (Where 1 Is Most Deprived) |
GOR_TXT | VARCHAR(9) | Y | The Region code for each postcode. |
HDAD_SC_NBR | DOUBLE | Y | Health Deprivation And Disability Score |
HDAD_SC_R_NBR | DOUBLE | Y | Rank Of Health Deprivation And Disability Score (Where 1 Is Most Deprived) |
HRO_TXT | VARCHAR(3) | Y | The former Pan SHA responsible for the associated strategic health authority for each postcode in England. |
IDACI_SC_NBR | DOUBLE | Y | Income Deprivation Affecting Children Index Score |
IDACI_SC_R_NBR | DOUBLE | Y | Rank Of Income Deprivation Affecting Children Index Score (Where 1 Is Most Deprived) |
IDAOPI_SC_NBR | DOUBLE | Y | Income Deprivation Affecting Older People Index Score |
IDAOPI_SC_R_NBR | DOUBLE | Y | Rank Of Income Deprivation Affecting Older People Index Score (Where 1 Is Most Deprived) |
IMD_SC_NBR | DOUBLE | Y | Index of Mass Deprivation Score |
IMD_SC_R_NBR | DOUBLE | Y | Rank of Index of Mass Deprivation Score (Where 1 Is Most Deprived) |
INC_SC_NBR | DOUBLE | Y | Income Score |
INC_SC_R_NBR | DOUBLE | Y | Rank Of Income Score (Where 1 Is Most Deprived) |
ISD_SC_NBR | DOUBLE | Y | Indoors Sub-Domain Score |
ISD_SC_R_NBR | DOUBLE | Y | Rank of Indoors Sub-Domain Score (Where 1 Is Most Deprived) |
LE_SC_NBR | DOUBLE | Y | Living Environment Score |
LE_SC_R_NBR | DOUBLE | Y | Rank Of Living Environment Score (Where 1 Is Most Deprived) |
LSOA01_TXT | VARCHAR(9) | N | The 2001 Census Lower Layer SOA code for England and Wales, SOA code for Northern Ireland and data zone code for Scotland. |
LSOA11_TXT | VARCHAR(9) | Y | The 2011 Census lower layer SOA code for England and Wales, SOA code for Northern Ireland and data zone code for Scotland. |
MSOA01_TXT | VARCHAR(9) | Y | The 2001 Census Middle Layer SOA (MSOA) code for England and Wales and intermediate zone for Scotland. |
MSOA11_TXT | VARCHAR(9) | Y | The 2011 Census middle layer SOA (MSOA) code for England and Wales and intermediate zone for Scotland. |
NHSAT_TXT | VARCHAR(3) | Y | The Area Team code for the postcode. |
NHSCR_TXT | VARCHAR(3) | Y | The Commissioning Region code for the postcode. |
OA01_TXT | VARCHAR(10) | Y | The 2001 Census Output Areas were built from unit postcodes and constrained to 2003 `statistical¿ wards, and they form the building bricks for defining higher level geographies. |
OA11_TXT | VARCHAR(9) | Y | The 2011 Census output areas were based on 2001 Census output areas, and they form the building bricks for defining higher level geographies. |
ODSLAUA_TXT | VARCHAR(3) | Y | Organisation Data Service allocated identifiers for top-tier Local Authority organisations in England and Wales to which the postcode has been assigned |
OLDHA_TXT | VARCHAR(3) | Y | The health authority existing prior to the reorganisation of health areas (England in 2002, Wales in 2003). |
OLDHRO_TXT | VARCHAR(3) | Y | The pre-Pan SHA IT Cluster responsible for the associated strategic health authority for each postcode in England. |
OLDPCT_TXT | VARCHAR(3) | Y | The pre-October 2006 code for the primary care areas in England and Wales; primary care areas do not exist in Scotland or Northern Ireland. |
OSCTY_TXT | VARCHAR(9) | Y | The county to which the postcode has been assigned. |
OSD_SC_NBR | DOUBLE | Y | Outdoors Sub-Domain Score |
OSD_SC_R_NBR | DOUBLE | Y | Rank of Outdoors Sub-Domain Score(Where 1 Is Most Deprived) |
OSEAST100M_NBR | DOUBLE | Y | The Ordnance Survey postcode grid reference Easting to 100 metre resolution; blank for postcodes in the Channel Islands and the Isle of Man. Grid references for postcodes in Northern Ireland relate to the Irish Grid system. |
OSEAST1M_NBR | DOUBLE | Y | The Ordnance Survey postcode grid reference Easting to 1 metre resolution; blank for postcodes in the Channel Islands and the Isle of Man. Grid references for postcodes in Northern Ireland relate to the Irish Grid system. |
OSGRDIND_FLAG | DOUBLE | N | Shows the status of the assigned grid reference. |
OSHAPREV_TXT | VARCHAR(3) | Y | The health area code for the postcode prior to the NHS reorganisation on 1 July 2006. |
OSLAUA_TXT | VARCHAR(9) | Y | The district/UA to which the postcode has been assigned. |
OSNRTH100M_NBR | DOUBLE | Y | The Ordnance Survey postcode grid reference Northing to 100 metre resolution; blank for postcodes in the Channel Islands and the Isle of Man. Grid references for postcodes in Northern Ireland relate to the Irish Grid system. |
OSNRTH1M_NBR | DOUBLE | Y | The Ordnance Survey postcode grid reference Northing to 1 metre resolution; blank for postcodes in the Channel Islands and the Isle of Man. Grid references for postcodes in Northern Ireland relate to the Irish Grid system. |
OSWARD_TXT | VARCHAR(9) | Y | The administrative/electoral area to which the postcode has been assigned. |
PCDS_TXT | VARCHAR(8) | N | Unformatted postcode:2, 3 or 4-character outward codeSingle space () 3-character inward codePseudo country postcode as used by the NHS. |
PCON_TXT | VARCHAR(9) | Y | The Westminster Parliamentary Constituency code for each postcode. Pseudo codes are included for Channel Islands and Isle of Man. |
PCT_RESIDENCE | VARCHAR(3) | N | PCT/CT of Residence |
PCT_TXT | VARCHAR(3) | Y | The code for the Primary Care areas in England, LHBs in Wales, CHPs in Scotland, LCG in Northern Ireland and PHD in the Isle of Man prior to the abolition of PCTs in 2013; there are no equivalent areas in the Channel Islands |
POSTCODE | VARCHAR(8) | N | Residence Postcode |
PSED_TXT | VARCHAR(8) | Y | The code for the 1991 Census ED. |
SCN_TXT | VARCHAR(3) | Y | The Strategic Clinical Network that each postcode falls within. Introduced in April 2013. |
SHA_RESIDENCE | VARCHAR(3) | N | Strategic Health Authority of Residence |
SSD_SC_NBR | DOUBLE | Y | Skills Sub-Domain Score |
SSD_SC_R_NBR | DOUBLE | Y | Rank of Skills Sub-Domain Score (Where 1 Is Most Deprived) |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | 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_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | 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_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
UR01IND_TXT | VARCHAR(1) | Y | The 2001 Census Urban and rural classification of Output Areas for England and Wales, Scotland and Northern Ireland. |
USERTYPE_FLAG | DOUBLE | N | Shows whether the postcode is a small or large user.0 = small user;1 = large user |
WARD98_TXT | VARCHAR(6) | Y | The 1998 administrative and electoral areas for each postcode. |
WBSD_SC_NBR | DOUBLE | Y | Wider Barriers Sub-Domain Score |
WBSD_SC_R_NBR | DOUBLE | Y | Rank of Wider Barriers Sub-Domain Score (Where 1 Is Most Deprived) |