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)