rendered paste bodyObjectId,Attribute,Order,Name1,Name2,Expression,Flag,LvExtra-2147483617,0,,"","","",0,-2147483617,255,,"","","",,-2147483617,3,,"","","",8,-2147483617,5,,"QryDistSelect","","",,-2147483617,6,,"","","[QryDistSelect].[Code]",0,-2147483617,6,,"","","[QryDistSelect].[Name]",0,-2147483616,0,,"","","",0,-2147483616,255,,"","","",,-2147483616,1,,"CH2008","","",3,-2147483616,3,,"","","",0,-2147483616,5,,"Changes","","",,-2147483616,6,,"","GEOG09CD","Changes.GEOGCD",0,-2147483616,6,,"","GEOG09NM","Changes.GEOGNM",0,-2147483616,6,,"","GEOG08CD","Changes.GEOGCD_P",0,-2147483616,6,,"","GEOG08NM","Changes.GEOGNM_P",0,-2147483616,6,,"","SI_ID09","Changes.SI_ID",0,-2147483616,6,,"","SI_TITLE09","Changes.SI_TITLE",0,-2147483616,6,,"","OPER_DATE09","Changes.OPER_DATE",0,-2147483616,6,,"","ENTITYCD","Changes.ENTITYCD",0,-2147483616,8,,"","","(((Changes.ENTITYCD)=""K01""))",,-2147483616,11,,"","","Changes.GEOGCD",,-2147483615,0,,"","","",0,-2147483615,255,,"","","",,-2147483615,1,,"","","",1,-2147483615,3,,"","","",0,-2147483615,5,,"ChangeHistory","","",,-2147483615,5,,"Changes","","",,-2147483615,6,,"","","ChangeHistory.GEOGCD",0,-2147483615,6,,"","","ChangeHistory.GEOGNM",0,-2147483615,6,,"","","ChangeHistory.SI_ID",0,-2147483615,6,,"","","ChangeHistory.SI_TITLE",0,-2147483615,6,,"","","ChangeHistory.OPER_DATE",0,-2147483615,6,,"","","ChangeHistory.TERM_DATE",0,-2147483615,6,,"","","ChangeHistory.PARENTCD",0,-2147483615,6,,"","","ChangeHistory.ENTITYCD",0,-2147483615,6,,"","","ChangeHistory.OWNER",0,-2147483615,7,,"ChangeHistory","Changes","ChangeHistory.GEOGCD = Changes.GEOGCD",2,-2147483615,8,,"","","(((Changes.GEOGCD) Is Null))",,-2147483614,0,,"","","",0,-2147483614,255,,"","","",,-2147483614,1,,"CH2008eoy","","",3,-2147483614,3,,"","","",0,-2147483614,5,,"ChangeHistory","","",,-2147483614,5,,"Changes","","",,-2147483614,6,,"GEOG09CD","GEOG09CD","ChangeHistory.GEOGCD",0,-2147483614,6,,"GEOG09NM","GEOG09NM","ChangeHistory.GEOGNM",0,-2147483614,6,,"GEOG08CD","GEOG08CD","Changes.GEOGCD_P",0,-2147483614,6,,"GEOG08NM","GEOG08NM","Changes.GEOGNM_P",0,-2147483614,6,,"SI_ID09","SI_ID09","ChangeHistory.SI_ID",0,-2147483614,6,,"SI_TITLE09","SI_TITLE09","ChangeHistory.SI_TITLE",0,-2147483614,6,,"OPER_DATE09","OPER_DATE09","ChangeHistory.OPER_DATE",0,-2147483614,6,,"PARENT09CD","PARENT09CD","ChangeHistory.PARENTCD",0,-2147483614,6,,"ENTITY09CD","ENTITY09CD","ChangeHistory.ENTITYCD",0,-2147483614,7,,"ChangeHistory","Changes","ChangeHistory.GEOGCD = Changes.GEOGCD",2,-2147483614,8,,"","","(((ChangeHistory.OPER_DATE) Between #1/2/2009# And #12/31/2009#) AND ((ChangeHistory.TERM_DATE)>#1/1/2010# Or (ChangeHistory.TERM_DATE) Is Null))",,-2147483614,11,,"","","ChangeHistory.GEOGCD",,-2147483613,0,,"","","",0,-2147483613,255,,"","","",,-2147483613,1,,"CH2008eoy","","",2,-2147483613,3,,"","","",0,-2147483613,5,,"ChangeHistory","","",,-2147483613,5,,"Changes","","",,-2147483613,6,,"GEOG09CD","","ChangeHistory.GEOGCD",0,-2147483613,6,,"GEOG09NM","","ChangeHistory.GEOGNM",0,-2147483613,6,,"GEOG08CD","","Changes.GEOGCD",0,-2147483613,6,,"GEOG08NM","","Changes.GEOGNM",0,-2147483613,6,,"SI_ID09","","ChangeHistory.SI_ID",0,-2147483613,6,,"SI_TITLE09","","ChangeHistory.SI_TITLE",0,-2147483613,6,,"OPER_DATE09","","ChangeHistory.OPER_DATE",0,-2147483613,6,,"PARENT09CD","","ChangeHistory.PARENTCD",0,-2147483613,6,,"ENTITY09CD","","ChangeHistory.ENTITYCD",0,-2147483613,7,,"ChangeHistory","Changes","ChangeHistory.GEOGCD = Changes.GEOGCD",2,-2147483613,8,,"","","(((ChangeHistory.OPER_DATE)<=#1/1/2009#) AND ((ChangeHistory.TERM_DATE)>#1/1/2010# Or (ChangeHistory.TERM_DATE) Is Null))",,-2147483613,11,,"","","ChangeHistory.GEOGCD",,-2147483612,0,,"","","",0,-2147483612,255,,"","","",,-2147483612,1,,"","","",1,-2147483612,3,,"","","",0,-2147483612,5,,"N05 (DCAs)","","",,-2147483612,5,,"N92 (CTRY)","","",,-2147483612,6,,"DCACD","","[N05 (DCAs)].GEOGCD",0,-2147483612,6,,"DCANM","","[N05 (DCAs)].GEOGNM",0,-2147483612,6,,"CTRYCD","","[N92 (CTRY)].GEOGCD",0,-2147483612,6,,"CTRYNM","","[N92 (CTRY)].GEOGNM",0,-2147483612,7,,"N92 (CTRY)","N05 (DCAs)","[N92 (CTRY)].GEOGCD = [N05 (DCAs)].PARENTCD",1,-2147483612,8,,"","","((([N92 (CTRY)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([N92 (CTRY)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([N92 (CTRY)].TERM_DATE) Is Null) AND (([N05 (DCAs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([N05 (DCAs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([N05 (DCAs)].TERM_DATE) Is Null))",,-2147483612,11,,"","","[N05 (DCAs)].GEOGCD",,-2147483611,0,,"","","",0,-2147483611,255,,"","","",,-2147483611,1,,"","","",1,-2147483611,3,,"","","",0,-2147483611,5,,"N04 (Wards)","","",,-2147483611,5,,"N05 (DCAs)","","",,-2147483611,5,,"N92 (CTRY)","","",,-2147483611,6,,"WDCD","","[N04 (Wards)].GEOGCD",0,-2147483611,6,,"WDNM","","[N04 (Wards)].GEOGNM",0,-2147483611,6,,"DCACD","","[N05 (DCAs)].GEOGCD",0,-2147483611,6,,"DCANM","","[N05 (DCAs)].GEOGNM",0,-2147483611,6,,"CTRYCD","","[N92 (CTRY)].GEOGCD",0,-2147483611,6,,"CTRYNM","","[N92 (CTRY)].GEOGNM",0,-2147483611,7,,"N92 (CTRY)","N05 (DCAs)","[N92 (CTRY)].GEOGCD = [N05 (DCAs)].PARENTCD",1,-2147483611,7,,"N05 (DCAs)","N04 (Wards)","[N05 (DCAs)].GEOGCD = [N04 (Wards)].PARENTCD",1,-2147483611,8,,"","","((([N92 (CTRY)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([N92 (CTRY)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([N92 (CTRY)].TERM_DATE) Is Null) AND (([N05 (DCAs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([N05 (DCAs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([N05 (DCAs)].TERM_DATE) Is Null) AND (([N04 (Wards)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([N04 (Wards)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([N04 (Wards)].TERM_DATE) Is Null))",,-2147483611,11,,"","","[N04 (Wards)].GEOGCD",,-2147483610,0,,"","","",0,-2147483610,255,,"","","",,-2147483610,1,,"","","",1,-2147483610,3,,"","","",0,-2147483610,5,,"CTRY_GOR_CTY_NMD_WD","","",,-2147483610,6,,"","","CTRY_GOR_CTY_NMD_WD.CTYCD",0,-2147483610,6,,"","","CTRY_GOR_CTY_NMD_WD.CTYNM",0,-2147483610,6,,"","","CTRY_GOR_CTY_NMD_WD.GORCD",0,-2147483610,6,,"","","CTRY_GOR_CTY_NMD_WD.GORNM",0,-2147483610,6,,"","","CTRY_GOR_CTY_NMD_WD.CTRYCD",0,-2147483610,6,,"","","CTRY_GOR_CTY_NMD_WD.CTRYNM",0,-2147483610,9,,"","","CTRY_GOR_CTY_NMD_WD.CTYCD",0,-2147483610,9,,"","","CTRY_GOR_CTY_NMD_WD.CTYNM",0,-2147483610,9,,"","","CTRY_GOR_CTY_NMD_WD.GORCD",0,-2147483610,9,,"","","CTRY_GOR_CTY_NMD_WD.GORNM",0,-2147483610,9,,"","","CTRY_GOR_CTY_NMD_WD.CTRYCD",0,-2147483610,9,,"","","CTRY_GOR_CTY_NMD_WD.CTRYNM",0,-2147483610,11,,"","","CTRY_GOR_CTY_NMD_WD.CTYCD",,-2147483609,0,,"","","",0,-2147483609,255,,"","","",,-2147483609,1,,"","","",1,-2147483609,3,,"","","",0,-2147483609,5,,"CTRY_GOR_CTY_NMD_WD","","",,-2147483609,6,,"","","CTRY_GOR_CTY_NMD_WD.NMDCD",0,-2147483609,6,,"","","CTRY_GOR_CTY_NMD_WD.NMDNM",0,-2147483609,6,,"","","CTRY_GOR_CTY_NMD_WD.CTYCD",0,-2147483609,6,,"","","CTRY_GOR_CTY_NMD_WD.CTYNM",0,-2147483609,6,,"","","CTRY_GOR_CTY_NMD_WD.GORCD",0,-2147483609,6,,"","","CTRY_GOR_CTY_NMD_WD.GORNM",0,-2147483609,6,,"","","CTRY_GOR_CTY_NMD_WD.CTRYCD",0,-2147483609,6,,"","","CTRY_GOR_CTY_NMD_WD.CTRYNM",0,-2147483609,9,,"","","CTRY_GOR_CTY_NMD_WD.NMDCD",0,-2147483609,9,,"","","CTRY_GOR_CTY_NMD_WD.NMDNM",0,-2147483609,9,,"","","CTRY_GOR_CTY_NMD_WD.CTYCD",0,-2147483609,9,,"","","CTRY_GOR_CTY_NMD_WD.CTYNM",0,-2147483609,9,,"","","CTRY_GOR_CTY_NMD_WD.GORCD",0,-2147483609,9,,"","","CTRY_GOR_CTY_NMD_WD.GORNM",0,-2147483609,9,,"","","CTRY_GOR_CTY_NMD_WD.CTRYCD",0,-2147483609,9,,"","","CTRY_GOR_CTY_NMD_WD.CTRYNM",0,-2147483609,11,,"","","CTRY_GOR_CTY_NMD_WD.NMDCD",,-2147483608,0,,"","","",0,-2147483608,255,,"","","",,-2147483608,1,,"","","",1,-2147483608,3,,"","","",0,-2147483608,5,,"E12 (GORs)","","",,-2147483608,5,,"E10 (Counties)","","",,-2147483608,5,,"E07 (NMDs)","","",,-2147483608,5,,"E05 (Wards)","","",,-2147483608,5,,"E92 (Ctry - England)","","",,-2147483608,6,,"WDCD","","[E05 (Wards)].GEOGCD",0,-2147483608,6,,"WDNM","","[E05 (Wards)].GEOGNM",0,-2147483608,6,,"NMDCD","","[E07 (NMDs)].GEOGCD",0,-2147483608,6,,"NMDNM","","[E07 (NMDs)].GEOGNM",0,-2147483608,6,,"CTYCD","","[E10 (Counties)].GEOGCD",0,-2147483608,6,,"CTYNM","","[E10 (Counties)].GEOGNM",0,-2147483608,6,,"GORCD","","[E12 (GORs)].GEOGCD",0,-2147483608,6,,"GORNM","","[E12 (GORs)].GEOGNM",0,-2147483608,6,,"CTRYCD","","[E92 (Ctry - England)].GEOGCD",0,-2147483608,6,,"CTRYNM","","[E92 (Ctry - England)].GEOGNM",0,-2147483608,7,,"E12 (GORs)","E10 (Counties)","[E12 (GORs)].GEOGCD = [E10 (Counties)].PARENTCD",1,-2147483608,7,,"E10 (Counties)","E07 (NMDs)","[E10 (Counties)].GEOGCD = [E07 (NMDs)].PARENTCD",1,-2147483608,7,,"E07 (NMDs)","E05 (Wards)","[E07 (NMDs)].GEOGCD = [E05 (Wards)].PARENTCD",1,-2147483608,7,,"E92 (Ctry - England)","E12 (GORs)","[E92 (Ctry - England)].GEOGCD = [E12 (GORs)].PARENTCD",1,-2147483608,8,,"","","((([E92 (Ctry - England)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([E92 (Ctry - England)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([E92 (Ctry - England)].TERM_DATE) Is Null) AND (([E12 (GORs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([E12 (GORs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([E12 (GORs)].TERM_DATE) Is Null) AND (([E10 (Counties)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([E10 (Counties)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([E10 (Counties)].TERM_DATE) Is Null) AND (([E07 (NMDs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([E07 (NMDs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([E07 (NMDs)].TERM_DATE) Is Null) AND (([E05 (Wards)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([E05 (Wards)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([E05 (Wards)].TERM_DATE) Is Null))",,-2147483608,11,,"","","[E05 (Wards)].GEOGCD",,-2147483607,0,,"","","",0,-2147483607,255,,"","","",,-2147483607,1,,"","","",1,-2147483607,3,,"","","",0,-2147483607,5,,"E12 (GORs)","","",,-2147483607,5,,"E92 (Ctry - England)","","",,-2147483607,6,,"GORCD","","[E12 (GORs)].GEOGCD",0,-2147483607,6,,"GORNM","","[E12 (GORs)].GEOGNM",0,-2147483607,6,,"CTRYCD","","[E92 (Ctry - England)].GEOGCD",0,-2147483607,6,,"CTRYNM","","[E92 (Ctry - England)].GEOGNM",0,-2147483607,7,,"E92 (Ctry - England)","E12 (GORs)","[E92 (Ctry - England)].GEOGCD = [E12 (GORs)].PARENTCD",1,-2147483607,8,,"","","((([E92 (Ctry - England)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([E92 (Ctry - England)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([E92 (Ctry - England)].TERM_DATE) Is Null) AND (([E12 (GORs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([E12 (GORs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([E12 (GORs)].TERM_DATE) Is Null))",,-2147483607,11,,"","","[E12 (GORs)].GEOGCD",,-2147483606,0,,"","","",0,-2147483606,255,,"","","",,-2147483606,1,,"","","",1,-2147483606,3,,"","","",0,-2147483606,5,,"CTRY_GOR_LB_WD","","",,-2147483606,6,,"","","CTRY_GOR_LB_WD.LBCD",0,-2147483606,6,,"","","CTRY_GOR_LB_WD.LBNM",0,-2147483606,6,,"","","CTRY_GOR_LB_WD.GORCD",0,-2147483606,6,,"","","CTRY_GOR_LB_WD.GORNM",0,-2147483606,6,,"","","CTRY_GOR_LB_WD.CTRYCD",0,-2147483606,6,,"","","CTRY_GOR_LB_WD.CTRYNM",0,-2147483606,9,,"","","CTRY_GOR_LB_WD.LBCD",0,-2147483606,9,,"","","CTRY_GOR_LB_WD.LBNM",0,-2147483606,9,,"","","CTRY_GOR_LB_WD.GORCD",0,-2147483606,9,,"","","CTRY_GOR_LB_WD.GORNM",0,-2147483606,9,,"","","CTRY_GOR_LB_WD.CTRYCD",0,-2147483606,9,,"","","CTRY_GOR_LB_WD.CTRYNM",0,-2147483606,11,,"","","CTRY_GOR_LB_WD.LBCD",,-2147483605,0,,"","","",0,-2147483605,255,,"","","",,-2147483605,1,,"","","",1,-2147483605,3,,"","","",0,-2147483605,5,,"E12 (GORs)","","",,-2147483605,5,,"E09 (LBs)","","",,-2147483605,5,,"E05 (Wards)","","",,-2147483605,5,,"E92 (Ctry - England)","","",,-2147483605,6,,"WDCD","","[E05 (Wards)].GEOGCD",0,-2147483605,6,,"WDNM","","[E05 (Wards)].GEOGNM",0,-2147483605,6,,"LBCD","","[E09 (LBs)].GEOGCD",0,-2147483605,6,,"LBNM","","[E09 (LBs)].GEOGNM",0,-2147483605,6,,"GORCD","","[E12 (GORs)].GEOGCD",0,-2147483605,6,,"GORNM","","[E12 (GORs)].GEOGNM",0,-2147483605,6,,"CTRYCD","","[E92 (Ctry - England)].GEOGCD",0,-2147483605,6,,"CTRYNM","","[E92 (Ctry - England)].GEOGNM",0,-2147483605,7,,"E12 (GORs)","E09 (LBs)","[E12 (GORs)].GEOGCD = [E09 (LBs)].PARENTCD",1,-2147483605,7,,"E09 (LBs)","E05 (Wards)","[E09 (LBs)].GEOGCD = [E05 (Wards)].PARENTCD",1,-2147483605,7,,"E92 (Ctry - England)","E12 (GORs)","[E92 (Ctry - England)].GEOGCD = [E12 (GORs)].PARENTCD",1,-2147483605,8,,"","","((([E92 (Ctry - England)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([E92 (Ctry - England)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([E92 (Ctry - England)].TERM_DATE) Is Null) AND (([E12 (GORs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([E12 (GORs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([E12 (GORs)].TERM_DATE) Is Null) AND (([E09 (LBs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([E09 (LBs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([E09 (LBs)].TERM_DATE) Is Null) AND (([E05 (Wards)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([E05 (Wards)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([E05 (Wards)].TERM_DATE) Is Null))",,-2147483605,11,,"","","[E05 (Wards)].GEOGCD",,-2147483604,0,,"","","",0,-2147483604,255,,"","","",,-2147483604,1,,"","","",1,-2147483604,3,,"","","",0,-2147483604,5,,"CTRY_GOR_MD_WD","","",,-2147483604,6,,"","","CTRY_GOR_MD_WD.MDCD",0,-2147483604,6,,"","","CTRY_GOR_MD_WD.MDNM",0,-2147483604,6,,"","","CTRY_GOR_MD_WD.GORCD",0,-2147483604,6,,"","","CTRY_GOR_MD_WD.GORNM",0,-2147483604,6,,"","","CTRY_GOR_MD_WD.CTRYCD",0,-2147483604,6,,"","","CTRY_GOR_MD_WD.CTRYNM",0,-2147483604,9,,"","","CTRY_GOR_MD_WD.MDCD",0,-2147483604,9,,"","","CTRY_GOR_MD_WD.MDNM",0,-2147483604,9,,"","","CTRY_GOR_MD_WD.GORCD",0,-2147483604,9,,"","","CTRY_GOR_MD_WD.GORNM",0,-2147483604,9,,"","","CTRY_GOR_MD_WD.CTRYCD",0,-2147483604,9,,"","","CTRY_GOR_MD_WD.CTRYNM",0,-2147483604,11,,"","","CTRY_GOR_MD_WD.MDCD",,-2147483603,0,,"","","",0,-2147483603,255,,"","","",,-2147483603,1,,"","","",1,-2147483603,3,,"","","",0,-2147483603,5,,"E12 (GORs)","","",,-2147483603,5,,"E08 (MDs)","","",,-2147483603,5,,"E05 (Wards)","","",,-2147483603,5,,"E92 (Ctry - England)","","",,-2147483603,6,,"WDCD","","[E05 (Wards)].GEOGCD",0,-2147483603,6,,"WDNM","","[E05 (Wards)].GEOGNM",0,-2147483603,6,,"MDCD","","[E08 (MDs)].GEOGCD",0,-2147483603,6,,"MDNM","","[E08 (MDs)].GEOGNM",0,-2147483603,6,,"GORCD","","[E12 (GORs)].GEOGCD",0,-2147483603,6,,"GORNM","","[E12 (GORs)].GEOGNM",0,-2147483603,6,,"CTRYCD","","[E92 (Ctry - England)].GEOGCD",0,-2147483603,6,,"CTRYNM","","[E92 (Ctry - England)].GEOGNM",0,-2147483603,7,,"E12 (GORs)","E08 (MDs)","[E12 (GORs)].GEOGCD = [E08 (MDs)].PARENTCD",1,-2147483603,7,,"E08 (MDs)","E05 (Wards)","[E08 (MDs)].GEOGCD = [E05 (Wards)].PARENTCD",1,-2147483603,7,,"E92 (Ctry - England)","E12 (GORs)","[E92 (Ctry - England)].GEOGCD = [E12 (GORs)].PARENTCD",1,-2147483603,8,,"","","((([E92 (Ctry - England)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([E92 (Ctry - England)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([E92 (Ctry - England)].TERM_DATE) Is Null) AND (([E12 (GORs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([E12 (GORs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([E12 (GORs)].TERM_DATE) Is Null) AND (([E08 (MDs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([E08 (MDs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([E08 (MDs)].TERM_DATE) Is Null) AND (([E05 (Wards)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([E05 (Wards)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([E05 (Wards)].TERM_DATE) Is Null))",,-2147483603,11,,"","","[E05 (Wards)].GEOGCD",,-2147483602,0,,"","","",0,-2147483602,255,,"","","",,-2147483602,1,,"","","",1,-2147483602,3,,"","","",0,-2147483602,5,,"CTRY_GOR_UA_WD","","",,-2147483602,6,,"","","CTRY_GOR_UA_WD.UACD",0,-2147483602,6,,"","","CTRY_GOR_UA_WD.UANM",0,-2147483602,6,,"","","CTRY_GOR_UA_WD.GORCD",0,-2147483602,6,,"","","CTRY_GOR_UA_WD.GORNM",0,-2147483602,6,,"","","CTRY_GOR_UA_WD.CTRYCD",0,-2147483602,6,,"","","CTRY_GOR_UA_WD.CTRYNM",0,-2147483602,9,,"","","CTRY_GOR_UA_WD.UACD",0,-2147483602,9,,"","","CTRY_GOR_UA_WD.UANM",0,-2147483602,9,,"","","CTRY_GOR_UA_WD.GORCD",0,-2147483602,9,,"","","CTRY_GOR_UA_WD.GORNM",0,-2147483602,9,,"","","CTRY_GOR_UA_WD.CTRYCD",0,-2147483602,9,,"","","CTRY_GOR_UA_WD.CTRYNM",0,-2147483602,11,,"","","CTRY_GOR_UA_WD.UACD",,-2147483601,0,,"","","",0,-2147483601,255,,"","","",,-2147483601,1,,"","","",1,-2147483601,3,,"","","",0,-2147483601,5,,"E12 (GORs)","","",,-2147483601,5,,"E06 (UAs)","","",,-2147483601,5,,"E05 (Wards)","","",,-2147483601,5,,"E92 (Ctry - England)","","",,-2147483601,6,,"WDCD","","[E05 (Wards)].GEOGCD",0,-2147483601,6,,"WDNM","","[E05 (Wards)].GEOGNM",0,-2147483601,6,,"UACD","","[E06 (UAs)].GEOGCD",0,-2147483601,6,,"UANM","","[E06 (UAs)].GEOGNM",0,-2147483601,6,,"GORCD","","[E12 (GORs)].GEOGCD",0,-2147483601,6,,"GORNM","","[E12 (GORs)].GEOGNM",0,-2147483601,6,,"CTRYCD","","[E92 (Ctry - England)].GEOGCD",0,-2147483601,6,,"CTRYNM","","[E92 (Ctry - England)].GEOGNM",0,-2147483601,7,,"E12 (GORs)","E06 (UAs)","[E12 (GORs)].GEOGCD = [E06 (UAs)].PARENTCD",1,-2147483601,7,,"E06 (UAs)","E05 (Wards)","[E06 (UAs)].GEOGCD = [E05 (Wards)].PARENTCD",1,-2147483601,7,,"E92 (Ctry - England)","E12 (GORs)","[E92 (Ctry - England)].GEOGCD = [E12 (GORs)].PARENTCD",1,-2147483601,8,,"","","((([E92 (Ctry - England)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([E92 (Ctry - England)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([E92 (Ctry - England)].TERM_DATE) Is Null) AND (([E12 (GORs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([E12 (GORs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([E12 (GORs)].TERM_DATE) Is Null) AND (([E06 (UAs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([E06 (UAs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([E06 (UAs)].TERM_DATE) Is Null) AND (([E05 (Wards)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([E05 (Wards)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([E05 (Wards)].TERM_DATE) Is Null))",,-2147483601,11,,"","","[E05 (Wards)].GEOGCD",,-2147483600,0,,"","","",0,-2147483600,255,,"","","",,-2147483600,1,,"","","",1,-2147483600,3,,"","","",0,-2147483600,5,,"CTRY_UA_WD_WA","","",,-2147483600,6,,"","","CTRY_UA_WD_WA.UACD",0,-2147483600,6,,"","","CTRY_UA_WD_WA.UANM",0,-2147483600,6,,"","","CTRY_UA_WD_WA.CTRYCD",0,-2147483600,6,,"","","CTRY_UA_WD_WA.CTRYNM",0,-2147483600,9,,"","","CTRY_UA_WD_WA.UACD",0,-2147483600,9,,"","","CTRY_UA_WD_WA.UANM",0,-2147483600,9,,"","","CTRY_UA_WD_WA.CTRYCD",0,-2147483600,9,,"","","CTRY_UA_WD_WA.CTRYNM",0,-2147483600,11,,"","","CTRY_UA_WD_WA.UACD",,-2147483599,0,,"","","",0,-2147483599,255,,"","","",,-2147483599,1,,"","","",1,-2147483599,3,,"","","",0,-2147483599,5,,"W06 (UAs)","","",,-2147483599,5,,"W92 (Ctry - Wales)","","",,-2147483599,5,,"W05 (WalesWards)","","",,-2147483599,6,,"WDCD","","[W05 (WalesWards)].GEOGCD",0,-2147483599,6,,"WDNM","","[W05 (WalesWards)].GEOGNM",0,-2147483599,6,,"UACD","","[W06 (UAs)].GEOGCD",0,-2147483599,6,,"UANM","","[W06 (UAs)].GEOGNM",0,-2147483599,6,,"CTRYCD","","[W92 (Ctry - Wales)].GEOGCD",0,-2147483599,6,,"CTRYNM","","[W92 (Ctry - Wales)].GEOGNM",0,-2147483599,7,,"W92 (Ctry - Wales)","W06 (UAs)","[W92 (Ctry - Wales)].GEOGCD = [W06 (UAs)].PARENTCD",1,-2147483599,7,,"W06 (UAs)","W05 (WalesWards)","[W06 (UAs)].GEOGCD = [W05 (WalesWards)].PARENTCD",1,-2147483599,8,,"","","((([W92 (Ctry - Wales)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([W92 (Ctry - Wales)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([W92 (Ctry - Wales)].TERM_DATE) Is Null) AND (([W06 (UAs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([W06 (UAs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([W06 (UAs)].TERM_DATE) Is Null) AND (([W05 (WalesWards)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([W05 (WalesWards)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([W05 (WalesWards)].TERM_DATE) Is Null))",,-2147483598,0,,"","","",0,-2147483598,255,,"","","",,-2147483598,1,,"","","",1,-2147483598,3,,"","","",0,-2147483598,5,,"W05 (Wards)","","",,-2147483598,5,,"W06 (UAs)","","",,-2147483598,5,,"W92 (Ctry - Wales)","","",,-2147483598,6,,"CTRYCD","","[W92 (Ctry - Wales)].GEOGCD",0,-2147483598,6,,"CTRYNM","","[W92 (Ctry - Wales)].GEOGNM",0,-2147483598,6,,"UACD","","[W06 (UAs)].GEOGCD",0,-2147483598,6,,"UANM","","[W06 (UAs)].GEOGNM",0,-2147483598,6,,"WDCD","","[W05 (Wards)].GEOGCD",0,-2147483598,6,,"WDNM","","[W05 (Wards)].GEOGNM",0,-2147483598,7,,"W92 (Ctry - Wales)","W06 (UAs)","[W92 (Ctry - Wales)].GEOGCD = [W06 (UAs)].PARENTCD",1,-2147483598,7,,"W06 (UAs)","W05 (Wards)","[W06 (UAs)].GEOGCD = [W05 (Wards)].PARENTCD",1,-2147483598,8,,"","","((([W92 (Ctry - Wales)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([W92 (Ctry - Wales)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([W92 (Ctry - Wales)].TERM_DATE) Is Null) AND (([W06 (UAs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([W06 (UAs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([W06 (UAs)].TERM_DATE) Is Null) AND (([W05 (Wards)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([W05 (Wards)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([W05 (Wards)].TERM_DATE) Is Null))",,-2147483598,11,,"","","[W05 (Wards)].GEOGCD",,-2147483597,0,,"","","",0,-2147483597,255,,"","","",,-2147483597,1,,"","","",1,-2147483597,3,,"","","",0,-2147483597,5,,"W16 (DCELLs)","","",,-2147483597,5,,"W17 (LEAs)","","",,-2147483597,6,,"DCELLCD","","[W16 (DCELLs)].GEOGCD",0,-2147483597,6,,"DCELLNM","","[W16 (DCELLs)].GEOGNM",0,-2147483597,6,,"LEACD","","[W17 (LEAs)].GEOGCD",0,-2147483597,6,,"LEANM","","[W17 (LEAs)].GEOGNM",0,-2147483597,7,,"W16 (DCELLs)","W17 (LEAs)","[W16 (DCELLs)].GEOGCD = [W17 (LEAs)].PARENTCD",1,-2147483597,8,,"","","((([W16 (DCELLs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([W16 (DCELLs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([W16 (DCELLs)].TERM_DATE) Is Null) AND (([W17 (LEAs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([W17 (LEAs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([W17 (LEAs)].TERM_DATE) Is Null))",,-2147483597,11,,"","","[W16 (DCELLs)].GEOGCD",,-2147483597,11,,"","","[W17 (LEAs)].GEOGCD",,-2147483596,0,,"","","",0,-2147483596,255,,"","","",,-2147483596,1,,"","","",1,-2147483596,3,,"","","",0,-2147483596,5,,"ChangeHistory","","",,-2147483596,6,,"","","ChangeHistory.GEOGCD",0,-2147483596,6,,"","","ChangeHistory.GEOGNM",0,-2147483596,6,,"","","ChangeHistory.SI_ID",0,-2147483596,6,,"","","ChangeHistory.SI_TITLE",0,-2147483596,6,,"","","ChangeHistory.OPER_DATE",0,-2147483596,6,,"","","ChangeHistory.TERM_DATE",0,-2147483596,6,,"","","ChangeHistory.PARENTCD",0,-2147483596,6,,"","","ChangeHistory.ENTITYCD",0,-2147483596,8,,"","","(((ChangeHistory.ENTITYCD)=""E00""))",,-2147483596,11,,"","","ChangeHistory.GEOGCD",,-2147483595,0,,"","","",0,-2147483595,255,,"","","",,-2147483595,1,,"","","",1,-2147483595,3,,"","","",0,-2147483595,5,,"ChangeHistory","","",,-2147483595,6,,"","","ChangeHistory.GEOGCD",0,-2147483595,6,,"","","ChangeHistory.GEOGNM",0,-2147483595,6,,"","","ChangeHistory.SI_ID",0,-2147483595,6,,"","","ChangeHistory.SI_TITLE",0,-2147483595,6,,"","","ChangeHistory.OPER_DATE",0,-2147483595,6,,"","","ChangeHistory.TERM_DATE",0,-2147483595,6,,"","","ChangeHistory.PARENTCD",0,-2147483595,6,,"","","ChangeHistory.ENTITYCD",0,-2147483595,8,,"","","(((ChangeHistory.ENTITYCD)=""E01""))",,-2147483595,11,,"","","ChangeHistory.GEOGCD",,-2147483594,0,,"","","",0,-2147483594,255,,"","","",,-2147483594,1,,"","","",1,-2147483594,3,,"","","",0,-2147483594,5,,"ChangeHistory","","",,-2147483594,6,,"","","ChangeHistory.GEOGCD",0,-2147483594,6,,"","","ChangeHistory.GEOGNM",0,-2147483594,6,,"","","ChangeHistory.SI_ID",0,-2147483594,6,,"","","ChangeHistory.SI_TITLE",0,-2147483594,6,,"","","ChangeHistory.OPER_DATE",0,-2147483594,6,,"","","ChangeHistory.TERM_DATE",0,-2147483594,6,,"","","ChangeHistory.PARENTCD",0,-2147483594,6,,"","","ChangeHistory.ENTITYCD",0,-2147483594,8,,"","","(((ChangeHistory.ENTITYCD)=""E02""))",,-2147483594,11,,"","","ChangeHistory.GEOGCD",,-2147483593,0,,"","","",0,-2147483593,255,,"","","",,-2147483593,1,,"","","",1,-2147483593,3,,"","","",0,-2147483593,5,,"ChangeHistory","","",,-2147483593,6,,"","","ChangeHistory.GEOGCD",0,-2147483593,6,,"","","ChangeHistory.GEOGNM",0,-2147483593,6,,"","","ChangeHistory.SI_ID",0,-2147483593,6,,"","","ChangeHistory.SI_TITLE",0,-2147483593,6,,"","","ChangeHistory.OPER_DATE",0,-2147483593,6,,"","","ChangeHistory.TERM_DATE",0,-2147483593,6,,"","","ChangeHistory.PARENTCD",0,-2147483593,6,,"","","ChangeHistory.ENTITYCD",0,-2147483593,8,,"","","(((ChangeHistory.ENTITYCD)=""E05""))",,-2147483593,11,,"","","ChangeHistory.GEOGCD",,-2147483593,11,,"","","ChangeHistory.OPER_DATE",,-2147483592,0,,"","","",0,-2147483592,255,,"","","",,-2147483592,1,,"","","",1,-2147483592,3,,"","","",0,-2147483592,5,,"ChangeHistory","","",,-2147483592,6,,"","","ChangeHistory.GEOGCD",0,-2147483592,6,,"","","ChangeHistory.GEOGNM",0,-2147483592,6,,"","","ChangeHistory.SI_ID",0,-2147483592,6,,"","","ChangeHistory.SI_TITLE",0,-2147483592,6,,"","","ChangeHistory.OPER_DATE",0,-2147483592,6,,"","","ChangeHistory.TERM_DATE",0,-2147483592,6,,"","","ChangeHistory.PARENTCD",0,-2147483592,6,,"","","ChangeHistory.ENTITYCD",0,-2147483592,8,,"","","(((ChangeHistory.ENTITYCD)=""E06""))",,-2147483592,11,,"","","ChangeHistory.GEOGCD",,-2147483591,0,,"","","",0,-2147483591,255,,"","","",,-2147483591,1,,"","","",1,-2147483591,3,,"","","",0,-2147483591,5,,"ChangeHistory","","",,-2147483591,6,,"","","ChangeHistory.GEOGCD",0,-2147483591,6,,"","","ChangeHistory.GEOGNM",0,-2147483591,6,,"","","ChangeHistory.SI_ID",0,-2147483591,6,,"","","ChangeHistory.SI_TITLE",0,-2147483591,6,,"","","ChangeHistory.OPER_DATE",0,-2147483591,6,,"","","ChangeHistory.TERM_DATE",0,-2147483591,6,,"","","ChangeHistory.PARENTCD",0,-2147483591,6,,"","","ChangeHistory.ENTITYCD",0,-2147483591,8,,"","","(((ChangeHistory.ENTITYCD)=""E07""))",,-2147483591,11,,"","","ChangeHistory.GEOGCD",,-2147483590,0,,"","","",0,-2147483590,255,,"","","",,-2147483590,1,,"","","",1,-2147483590,3,,"","","",0,-2147483590,5,,"ChangeHistory","","",,-2147483590,6,,"","","ChangeHistory.GEOGCD",0,-2147483590,6,,"","","ChangeHistory.GEOGNM",0,-2147483590,6,,"","","ChangeHistory.SI_ID",0,-2147483590,6,,"","","ChangeHistory.SI_TITLE",0,-2147483590,6,,"","","ChangeHistory.OPER_DATE",0,-2147483590,6,,"","","ChangeHistory.TERM_DATE",0,-2147483590,6,,"","","ChangeHistory.PARENTCD",0,-2147483590,6,,"","","ChangeHistory.ENTITYCD",0,-2147483590,8,,"","","(((ChangeHistory.ENTITYCD)=""E08""))",,-2147483590,11,,"","","ChangeHistory.GEOGCD",,-2147483589,0,,"","","",0,-2147483589,255,,"","","",,-2147483589,1,,"","","",1,-2147483589,3,,"","","",0,-2147483589,5,,"ChangeHistory","","",,-2147483589,6,,"","","ChangeHistory.GEOGCD",0,-2147483589,6,,"","","ChangeHistory.GEOGNM",0,-2147483589,6,,"","","ChangeHistory.SI_ID",0,-2147483589,6,,"","","ChangeHistory.SI_TITLE",0,-2147483589,6,,"","","ChangeHistory.OPER_DATE",0,-2147483589,6,,"","","ChangeHistory.TERM_DATE",0,-2147483589,6,,"","","ChangeHistory.PARENTCD",0,-2147483589,6,,"","","ChangeHistory.ENTITYCD",0,-2147483589,8,,"","","(((ChangeHistory.ENTITYCD)=""E09""))",,-2147483589,11,,"","","ChangeHistory.GEOGCD",,-2147483588,0,,"","","",0,-2147483588,255,,"","","",,-2147483588,1,,"","","",1,-2147483588,3,,"","","",0,-2147483588,5,,"ChangeHistory","","",,-2147483588,6,,"","","ChangeHistory.GEOGCD",0,-2147483588,6,,"","","ChangeHistory.GEOGNM",0,-2147483588,6,,"","","ChangeHistory.SI_ID",0,-2147483588,6,,"","","ChangeHistory.SI_TITLE",0,-2147483588,6,,"","","ChangeHistory.OPER_DATE",0,-2147483588,6,,"","","ChangeHistory.TERM_DATE",0,-2147483588,6,,"","","ChangeHistory.PARENTCD",0,-2147483588,6,,"","","ChangeHistory.ENTITYCD",0,-2147483588,8,,"","","(((ChangeHistory.ENTITYCD)=""E10""))",,-2147483588,11,,"","","ChangeHistory.GEOGCD",,-2147483587,0,,"","","",0,-2147483587,255,,"","","",,-2147483587,1,,"","","",1,-2147483587,3,,"","","",0,-2147483587,5,,"ChangeHistory","","",,-2147483587,6,,"","","ChangeHistory.GEOGCD",0,-2147483587,6,,"","","ChangeHistory.GEOGNM",0,-2147483587,6,,"","","ChangeHistory.SI_ID",0,-2147483587,6,,"","","ChangeHistory.SI_TITLE",0,-2147483587,6,,"","","ChangeHistory.OPER_DATE",0,-2147483587,6,,"","","ChangeHistory.TERM_DATE",0,-2147483587,6,,"","","ChangeHistory.PARENTCD",0,-2147483587,6,,"","","ChangeHistory.ENTITYCD",0,-2147483587,8,,"","","(((ChangeHistory.ENTITYCD)=""E12""))",,-2147483587,11,,"","","ChangeHistory.GEOGCD",,-2147483586,0,,"","","",0,-2147483586,255,,"","","",,-2147483586,1,,"","","",1,-2147483586,3,,"","","",0,-2147483586,5,,"ChangeHistory","","",,-2147483586,6,,"","","ChangeHistory.GEOGCD",0,-2147483586,6,,"","","ChangeHistory.GEOGNM",0,-2147483586,6,,"","","ChangeHistory.SI_ID",0,-2147483586,6,,"","","ChangeHistory.SI_TITLE",0,-2147483586,6,,"","","ChangeHistory.OPER_DATE",0,-2147483586,6,,"","","ChangeHistory.TERM_DATE",0,-2147483586,6,,"","","ChangeHistory.PARENTCD",0,-2147483586,6,,"","","ChangeHistory.ENTITYCD",0,-2147483586,8,,"","","(((ChangeHistory.ENTITYCD)=""E14""))",,-2147483586,11,,"","","ChangeHistory.GEOGCD",,-2147483585,0,,"","","",0,-2147483585,255,,"","","",,-2147483585,1,,"","","",1,-2147483585,3,,"","","",0,-2147483585,5,,"ChangeHistory","","",,-2147483585,6,,"","","ChangeHistory.GEOGCD",0,-2147483585,6,,"","","ChangeHistory.GEOGNM",0,-2147483585,6,,"","","ChangeHistory.SI_ID",0,-2147483585,6,,"","","ChangeHistory.SI_TITLE",0,-2147483585,6,,"","","ChangeHistory.OPER_DATE",0,-2147483585,6,,"","","ChangeHistory.TERM_DATE",0,-2147483585,6,,"","","ChangeHistory.PARENTCD",0,-2147483585,6,,"","","ChangeHistory.ENTITYCD",0,-2147483585,8,,"","","(((ChangeHistory.ENTITYCD)=""E15""))",,-2147483585,11,,"","","ChangeHistory.GEOGCD",,-2147483584,0,,"","","",0,-2147483584,255,,"","","",,-2147483584,1,,"","","",1,-2147483584,3,,"","","",0,-2147483584,5,,"ChangeHistory","","",,-2147483584,6,,"","","ChangeHistory.GEOGCD",0,-2147483584,6,,"","","ChangeHistory.GEOGNM",0,-2147483584,6,,"","","ChangeHistory.SI_ID",0,-2147483584,6,,"","","ChangeHistory.SI_TITLE",0,-2147483584,6,,"","","ChangeHistory.OPER_DATE",0,-2147483584,6,,"","","ChangeHistory.TERM_DATE",0,-2147483584,6,,"","","ChangeHistory.PARENTCD",0,-2147483584,6,,"","","ChangeHistory.ENTITYCD",0,-2147483584,8,,"","","(((ChangeHistory.ENTITYCD)=""E16""))",,-2147483584,11,,"","","ChangeHistory.GEOGCD",,-2147483583,0,,"","","",0,-2147483583,255,,"","","",,-2147483583,1,,"","","",1,-2147483583,3,,"","","",0,-2147483583,5,,"ChangeHistory","","",,-2147483583,6,,"","","ChangeHistory.GEOGCD",0,-2147483583,6,,"","","ChangeHistory.GEOGNM",0,-2147483583,6,,"","","ChangeHistory.SI_ID",0,-2147483583,6,,"","","ChangeHistory.SI_TITLE",0,-2147483583,6,,"","","ChangeHistory.OPER_DATE",0,-2147483583,6,,"","","ChangeHistory.TERM_DATE",0,-2147483583,6,,"","","ChangeHistory.PARENTCD",0,-2147483583,6,,"","","ChangeHistory.ENTITYCD",0,-2147483583,8,,"","","(((ChangeHistory.ENTITYCD)=""E18""))",,-2147483583,11,,"","","ChangeHistory.GEOGCD",,-2147483582,0,,"","","",0,-2147483582,255,,"","","",,-2147483582,1,,"","","",1,-2147483582,3,,"","","",0,-2147483582,5,,"ChangeHistory","","",,-2147483582,6,,"","","ChangeHistory.GEOGCD",0,-2147483582,6,,"","","ChangeHistory.GEOGNM",0,-2147483582,6,,"","","ChangeHistory.SI_ID",0,-2147483582,6,,"","","ChangeHistory.SI_TITLE",0,-2147483582,6,,"","","ChangeHistory.OPER_DATE",0,-2147483582,6,,"","","ChangeHistory.TERM_DATE",0,-2147483582,6,,"","","ChangeHistory.PARENTCD",0,-2147483582,6,,"","","ChangeHistory.ENTITYCD",0,-2147483582,8,,"","","(((ChangeHistory.ENTITYCD)=""E19""))",,-2147483582,11,,"","","ChangeHistory.GEOGCD",,-2147483581,0,,"","","",0,-2147483581,255,,"","","",,-2147483581,1,,"","","",1,-2147483581,3,,"","","",0,-2147483581,5,,"ChangeHistory","","",,-2147483581,6,,"","","ChangeHistory.GEOGCD",0,-2147483581,6,,"","","ChangeHistory.GEOGNM",0,-2147483581,6,,"","","ChangeHistory.SI_ID",0,-2147483581,6,,"","","ChangeHistory.SI_TITLE",0,-2147483581,6,,"","","ChangeHistory.OPER_DATE",0,-2147483581,6,,"","","ChangeHistory.TERM_DATE",0,-2147483581,6,,"","","ChangeHistory.PARENTCD",0,-2147483581,6,,"","","ChangeHistory.ENTITYCD",0,-2147483581,8,,"","","(((ChangeHistory.ENTITYCD)=""E28""))",,-2147483581,11,,"","","ChangeHistory.GEOGCD",,-2147483580,0,,"","","",0,-2147483580,255,,"","","",,-2147483580,1,,"","","",1,-2147483580,3,,"","","",0,-2147483580,5,,"ChangeHistory","","",,-2147483580,6,,"","","ChangeHistory.GEOGCD",0,-2147483580,6,,"","","ChangeHistory.GEOGNM",0,-2147483580,6,,"","","ChangeHistory.SI_ID",0,-2147483580,6,,"","","ChangeHistory.SI_TITLE",0,-2147483580,6,,"","","ChangeHistory.OPER_DATE",0,-2147483580,6,,"","","ChangeHistory.TERM_DATE",0,-2147483580,6,,"","","ChangeHistory.PARENTCD",0,-2147483580,6,,"","","ChangeHistory.ENTITYCD",0,-2147483580,8,,"","","(((ChangeHistory.ENTITYCD)=""E29""))",,-2147483580,11,,"","","ChangeHistory.GEOGCD",,-2147483579,0,,"","","",0,-2147483579,255,,"","","",,-2147483579,1,,"","","",1,-2147483579,3,,"","","",0,-2147483579,5,,"ChangeHistory","","",,-2147483579,6,,"","","ChangeHistory.GEOGCD",0,-2147483579,6,,"","","ChangeHistory.GEOGNM",0,-2147483579,6,,"","","ChangeHistory.SI_ID",0,-2147483579,6,,"","","ChangeHistory.SI_TITLE",0,-2147483579,6,,"","","ChangeHistory.OPER_DATE",0,-2147483579,6,,"","","ChangeHistory.TERM_DATE",0,-2147483579,6,,"","","ChangeHistory.PARENTCD",0,-2147483579,6,,"","","ChangeHistory.ENTITYCD",0,-2147483579,8,,"","","(((ChangeHistory.ENTITYCD)=""E92""))",,-2147483579,11,,"","","ChangeHistory.GEOGCD",,-2147483579,11,,"","","ChangeHistory.OPER_DATE",,-2147483578,0,,"","","",0,-2147483578,255,,"","","",,-2147483578,1,,"","","",1,-2147483578,3,,"","","",0,-2147483578,5,,"E14 (WPCs)","","",,-2147483578,5,,"E15 (EERs)","","",,-2147483578,6,,"PCONCD","","[E14 (WPCs)].GEOGCD",0,-2147483578,6,,"PCONNM","","[E14 (WPCs)].GEOGNM",0,-2147483578,6,,"EERCD","","[E15 (EERs)].GEOGCD",0,-2147483578,6,,"EERNM","","[E15 (EERs)].GEOGNM",0,-2147483578,7,,"E15 (EERs)","E14 (WPCs)","[E15 (EERs)].GEOGCD = [E14 (WPCs)].PARENTCD",1,-2147483578,8,,"","","((([E14 (WPCs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([E14 (WPCs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([E14 (WPCs)].TERM_DATE) Is Null) AND (([E15 (EERs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([E15 (EERs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([E15 (EERs)].TERM_DATE) Is Null))",,-2147483578,11,,"","","[E14 (WPCs)].GEOGCD",,-2147483577,0,,"","","",0,-2147483577,255,,"","","",,-2147483577,1,,"","","",1,-2147483577,3,,"","","",0,-2147483577,5,,"N06 (WPCs)","","",,-2147483577,5,,"N07 (EERs)","","",,-2147483577,6,,"PCONCD","","[N06 (WPCs)].GEOGCD",0,-2147483577,6,,"PCONNM","","[N06 (WPCs)].GEOGNM",0,-2147483577,6,,"EERCD","","[N07 (EERs)].GEOGCD",0,-2147483577,6,,"EERNM","","[N07 (EERs)].GEOGNM",0,-2147483577,7,,"N07 (EERs)","N06 (WPCs)","[N07 (EERs)].GEOGCD = [N06 (WPCs)].PARENTCD",1,-2147483577,8,,"","","((([N07 (EERs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([N07 (EERs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([N07 (EERs)].TERM_DATE) Is Null) AND (([N06 (WPCs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([N06 (WPCs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([N06 (WPCs)].TERM_DATE) Is Null))",,-2147483577,11,,"","","[N06 (WPCs)].GEOGCD",,-2147483576,0,,"","","",0,-2147483576,255,,"","","",,-2147483576,1,,"","","",1,-2147483576,3,,"","","",0,-2147483576,5,,"W07 (WPCs)","","",,-2147483576,5,,"W08 (EERs)","","",,-2147483576,6,,"PCONCD","","[W07 (WPCs)].GEOGCD",0,-2147483576,6,,"PCONNM","","[W07 (WPCs)].GEOGNM",0,-2147483576,6,,"EERCD","","[W08 (EERs)].GEOGCD",0,-2147483576,6,,"EERNM","","[W08 (EERs)].GEOGNM",0,-2147483576,7,,"W08 (EERs)","W07 (WPCs)","[W08 (EERs)].GEOGCD = [W07 (WPCs)].PARENTCD",1,-2147483576,8,,"","","((([W08 (EERs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([W08 (EERs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([W08 (EERs)].TERM_DATE) Is Null) AND (([W07 (WPCs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([W07 (WPCs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([W07 (WPCs)].TERM_DATE) Is Null))",,-2147483576,11,,"","","[W07 (WPCs)].GEOGCD",,-2147483575,0,,"","","",0,-2147483575,255,,"","","",,-2147483575,1,,"","","",1,-2147483575,3,,"","","",0,-2147483575,5,,"Entity Table","","",,-2147483575,6,,"","","[Entity Table].ENTITYCD",0,-2147483575,6,,"","","[Entity Table].ENTITYNM",0,-2147483575,11,,"","","[Entity Table].ENTITYCD",,-2147483574,0,,"","","",0,-2147483574,255,,"","","",,-2147483574,1,,"","","",1,-2147483574,3,,"","","",0,-2147483574,5,,"Equivalents","","",,-2147483574,5,,"Changes","","",,-2147483574,6,,"","","Equivalents.GEOGCD",0,-2147483574,6,,"","","Equivalents.GEOGNM",0,-2147483574,6,,"","","Equivalents.GEOGCDO",0,-2147483574,6,,"","","Equivalents.GEOGNMO",0,-2147483574,6,,"","","Equivalents.GEOGCDD",0,-2147483574,6,,"","","Equivalents.GEOGNMD",0,-2147483574,6,,"","","Equivalents.GEOGCDH",0,-2147483574,6,,"","","Equivalents.GEOGNMH",0,-2147483574,6,,"","","Equivalents.GEOGCDS",0,-2147483574,6,,"","","Equivalents.GEOGNMS",0,-2147483574,6,,"","","Equivalents.GEOGCDI",0,-2147483574,6,,"","","Equivalents.GEOGNMI",0,-2147483574,6,,"","","Equivalents.OPER_DATE",0,-2147483574,6,,"","","Equivalents.TERM_DATE",0,-2147483574,6,,"","","Equivalents.ENTITYCD",0,-2147483574,6,,"","","Equivalents.YEAR",0,-2147483574,7,,"Equivalents","Changes","Equivalents.GEOGCD = Changes.GEOGCD",2,-2147483574,8,,"","","(((Changes.GEOGCD) Is Null))",,-2147483573,0,,"","","",0,-2147483573,255,,"","","",,-2147483573,1,,"","","",1,-2147483573,3,,"","","",0,-2147483573,5,,"Gazetteer","","",,-2147483573,6,,"","","Gazetteer.Geographytype",0,-2147483573,9,,"","","Gazetteer.Geographytype",0,-2147483572,0,,"","","",0,-2147483572,255,,"","","",,-2147483572,1,,"","","",1,-2147483572,3,,"","","",0,-2147483572,5,,"S00 (OAs)","","",,-2147483572,5,,"S01 (DZs)","","",,-2147483572,5,,"S02 (IGs)","","",,-2147483572,6,,"OACD","","[S00 (OAs)].GEOGCD",0,-2147483572,6,,"OANM","","[S00 (OAs)].GEOGNM",0,-2147483572,6,,"DZCD","","[S01 (DZs)].GEOGCD",0,-2147483572,6,,"DZNM","","[S01 (DZs)].GEOGNM",0,-2147483572,6,,"IGCD","","[S02 (IGs)].GEOGCD",0,-2147483572,6,,"IGNM","","[S02 (IGs)].GEOGNM",0,-2147483572,7,,"S02 (IGs)","S01 (DZs)","[S02 (IGs)].GEOGCD = [S01 (DZs)].PARENTCD",1,-2147483572,7,,"S01 (DZs)","S00 (OAs)","[S01 (DZs)].GEOGCD = [S00 (OAs)].PARENTCD",1,-2147483572,8,,"","","((([S02 (IGs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([S02 (IGs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([S02 (IGs)].TERM_DATE) Is Null) AND (([S01 (DZs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([S01 (DZs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([S01 (DZs)].TERM_DATE) Is Null) AND (([S00 (OAs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([S00 (OAs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([S00 (OAs)].TERM_DATE) Is Null))",,-2147483572,11,,"","","[S00 (OAs)].GEOGCD",,-2147483571,0,,"","","",0,-2147483571,255,,"","","",,-2147483571,1,,"","","",1,-2147483571,3,,"","","",0,-2147483571,5,,"S01 (DZs)","","",,-2147483571,5,,"S02 (IGs)","","",,-2147483571,6,,"DZCD","","[S01 (DZs)].GEOGCD",0,-2147483571,6,,"DZNM","","[S01 (DZs)].GEOGNM",0,-2147483571,6,,"IGCD","","[S02 (IGs)].GEOGCD",0,-2147483571,6,,"IGNM","","[S02 (IGs)].GEOGNM",0,-2147483571,7,,"S02 (IGs)","S01 (DZs)","[S02 (IGs)].GEOGCD = [S01 (DZs)].PARENTCD",1,-2147483571,8,,"","","((([S02 (IGs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([S02 (IGs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([S02 (IGs)].TERM_DATE) Is Null) AND (([S01 (DZs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([S01 (DZs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([S01 (DZs)].TERM_DATE) Is Null))",,-2147483570,0,,"","","",0,-2147483570,255,,"","","",,-2147483570,1,,"","","",1,-2147483570,3,,"","","",0,-2147483570,5,,"N00 (OAs)","","",,-2147483570,5,,"N01 (LSOAN)","","",,-2147483570,6,,"OACD","","[N00 (OAs)].GEOGCD",0,-2147483570,6,,"OANM","","[N00 (OAs)].GEOGNM",0,-2147483570,6,,"LSOANCD","","[N01 (LSOAN)].GEOGCD",0,-2147483570,6,,"LSOANNM","","[N01 (LSOAN)].GEOGNM",0,-2147483570,7,,"N01 (LSOAN)","N00 (OAs)","[N01 (LSOAN)].GEOGCD = [N00 (OAs)].PARENTCD",1,-2147483570,8,,"","","((([N01 (LSOAN)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([N01 (LSOAN)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([N01 (LSOAN)].TERM_DATE) Is Null) AND (([N00 (OAs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([N00 (OAs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([N00 (OAs)].TERM_DATE) Is Null))",,-2147483570,11,,"","","[N00 (OAs)].GEOGCD",,-2147483569,0,,"","","",0,-2147483569,255,,"","","",,-2147483569,1,,"","","",1,-2147483569,3,,"","","",0,-2147483569,5,,"MSOA_LSOA_OA_EN","","",,-2147483569,6,,"","","MSOA_LSOA_OA_EN.LSOACD",0,-2147483569,6,,"","","MSOA_LSOA_OA_EN.LSOANM",0,-2147483569,6,,"","","MSOA_LSOA_OA_EN.MSOACD",0,-2147483569,6,,"","","MSOA_LSOA_OA_EN.MSOANM",0,-2147483569,9,,"","","MSOA_LSOA_OA_EN.LSOACD",0,-2147483569,9,,"","","MSOA_LSOA_OA_EN.LSOANM",0,-2147483569,9,,"","","MSOA_LSOA_OA_EN.MSOACD",0,-2147483569,9,,"","","MSOA_LSOA_OA_EN.MSOANM",0,-2147483569,11,,"","","MSOA_LSOA_OA_EN.LSOACD",,-2147483568,0,,"","","",0,-2147483568,255,,"","","",,-2147483568,1,,"","","",1,-2147483568,3,,"","","",0,-2147483568,5,,"E02 (MSOAs)","","",,-2147483568,5,,"E01 (LSOAs)","","",,-2147483568,5,,"E00 (OAs)","","",,-2147483568,6,,"OACD","","[E00 (OAs)].GEOGCD",0,-2147483568,6,,"OANM","","[E00 (OAs)].GEOGNM",0,-2147483568,6,,"LSOACD","","[E01 (LSOAs)].GEOGCD",0,-2147483568,6,,"LSOANM","","[E01 (LSOAs)].GEOGNM",0,-2147483568,6,,"MSOACD","","[E02 (MSOAs)].GEOGCD",0,-2147483568,6,,"MSOANM","","[E02 (MSOAs)].GEOGNM",0,-2147483568,7,,"E02 (MSOAs)","E01 (LSOAs)","[E02 (MSOAs)].GEOGCD = [E01 (LSOAs)].PARENTCD",1,-2147483568,7,,"E01 (LSOAs)","E00 (OAs)","[E01 (LSOAs)].GEOGCD = [E00 (OAs)].PARENTCD",1,-2147483568,8,,"","","((([E02 (MSOAs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([E02 (MSOAs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([E02 (MSOAs)].TERM_DATE) Is Null) AND (([E01 (LSOAs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([E01 (LSOAs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([E01 (LSOAs)].TERM_DATE) Is Null) AND (([E00 (OAs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([E00 (OAs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([E00 (OAs)].TERM_DATE) Is Null))",,-2147483568,11,,"","","[E00 (OAs)].GEOGCD",,-2147483567,0,,"","","",0,-2147483567,255,,"","","",,-2147483567,1,,"","","",1,-2147483567,3,,"","","",0,-2147483567,5,,"W00 (OAs)","","",,-2147483567,5,,"W01 (LSOAs)","","",,-2147483567,5,,"W02 (MSOAs)","","",,-2147483567,5,,"W03 (USOAs)","","",,-2147483567,6,,"OACD","","[W00 (OAs)].GEOGCD",0,-2147483567,6,,"OANM","","[W00 (OAs)].GEOGNM",0,-2147483567,6,,"LSOACD","","[W01 (LSOAs)].GEOGCD",0,-2147483567,6,,"LSOANM","","[W01 (LSOAs)].GEOGNM",0,-2147483567,6,,"MSOACD","","[W02 (MSOAs)].GEOGCD",0,-2147483567,6,,"MSOANM","","[W02 (MSOAs)].GEOGNM",0,-2147483567,6,,"USOACD","","[W03 (USOAs)].GEOGCD",0,-2147483567,6,,"USOANM","","[W03 (USOAs)].GEOGNM",0,-2147483567,6,,"","","[W03 (USOAs)].OPER_DATE",0,-2147483567,6,,"","","[W03 (USOAs)].TERM_DATE",0,-2147483567,7,,"W02 (MSOAs)","W01 (LSOAs)","[W02 (MSOAs)].GEOGCD = [W01 (LSOAs)].PARENTCD",1,-2147483567,7,,"W01 (LSOAs)","W00 (OAs)","[W01 (LSOAs)].GEOGCD = [W00 (OAs)].PARENTCD",1,-2147483567,7,,"W03 (USOAs)","W02 (MSOAs)","[W03 (USOAs)].GEOGCD = [W02 (MSOAs)].PARENTCD",1,-2147483567,8,,"","","((([W03 (USOAs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([W03 (USOAs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([W03 (USOAs)].TERM_DATE) Is Null) AND (([W02 (MSOAs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([W02 (MSOAs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([W02 (MSOAs)].TERM_DATE) Is Null) AND (([W01 (LSOAs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([W01 (LSOAs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([W01 (LSOAs)].TERM_DATE) Is Null) AND (([W00 (OAs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([W00 (OAs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([W00 (OAs)].TERM_DATE) Is Null))",,-2147483567,11,,"","","[W00 (OAs)].GEOGCD",,-2147483566,0,,"","","",0,-2147483566,255,,"","","",,-2147483566,1,,"","","",1,-2147483566,3,,"","","",0,-2147483566,5,,"MSOA_LSOA_OA_WA","","",,-2147483566,6,,"","","MSOA_LSOA_OA_WA.LSOACD",0,-2147483566,6,,"","","MSOA_LSOA_OA_WA.LSOANM",0,-2147483566,6,,"","","MSOA_LSOA_OA_WA.MSOACD",0,-2147483566,6,,"","","MSOA_LSOA_OA_WA.MSOANM",0,-2147483566,6,,"","","MSOA_LSOA_OA_WA.USOACD",0,-2147483566,6,,"","","MSOA_LSOA_OA_WA.USOANM",0,-2147483566,9,,"","","MSOA_LSOA_OA_WA.LSOACD",0,-2147483566,9,,"","","MSOA_LSOA_OA_WA.LSOANM",0,-2147483566,9,,"","","MSOA_LSOA_OA_WA.MSOACD",0,-2147483566,9,,"","","MSOA_LSOA_OA_WA.MSOANM",0,-2147483566,9,,"","","MSOA_LSOA_OA_WA.USOACD",0,-2147483566,9,,"","","MSOA_LSOA_OA_WA.USOANM",0,-2147483566,11,,"","","MSOA_LSOA_OA_WA.LSOACD",,-2147483565,0,,"","","",0,-2147483565,255,,"","","",,-2147483565,1,,"","","",1,-2147483565,3,,"","","",0,-2147483565,5,,"ChangeHistory","","",,-2147483565,6,,"","","ChangeHistory.GEOGCD",0,-2147483565,6,,"","","ChangeHistory.GEOGNM",0,-2147483565,6,,"","","ChangeHistory.SI_ID",0,-2147483565,6,,"","","ChangeHistory.SI_TITLE",0,-2147483565,6,,"","","ChangeHistory.OPER_DATE",0,-2147483565,6,,"","","ChangeHistory.TERM_DATE",0,-2147483565,6,,"","","ChangeHistory.PARENTCD",0,-2147483565,6,,"","","ChangeHistory.ENTITYCD",0,-2147483565,8,,"","","(((ChangeHistory.ENTITYCD)=""N00""))",,-2147483565,11,,"","","ChangeHistory.GEOGCD",,-2147483564,0,,"","","",0,-2147483564,255,,"","","",,-2147483564,1,,"","","",1,-2147483564,3,,"","","",0,-2147483564,5,,"ChangeHistory","","",,-2147483564,6,,"","","ChangeHistory.GEOGCD",0,-2147483564,6,,"","","ChangeHistory.GEOGNM",0,-2147483564,6,,"","","ChangeHistory.SI_ID",0,-2147483564,6,,"","","ChangeHistory.SI_TITLE",0,-2147483564,6,,"","","ChangeHistory.OPER_DATE",0,-2147483564,6,,"","","ChangeHistory.TERM_DATE",0,-2147483564,6,,"","","ChangeHistory.PARENTCD",0,-2147483564,6,,"","","ChangeHistory.ENTITYCD",0,-2147483564,8,,"","","(((ChangeHistory.ENTITYCD)=""N01""))",,-2147483564,11,,"","","ChangeHistory.GEOGCD",,-2147483563,0,,"","","",0,-2147483563,255,,"","","",,-2147483563,1,,"","","",1,-2147483563,3,,"","","",0,-2147483563,5,,"ChangeHistory","","",,-2147483563,6,,"","","ChangeHistory.GEOGCD",0,-2147483563,6,,"","","ChangeHistory.GEOGNM",0,-2147483563,6,,"","","ChangeHistory.SI_ID",0,-2147483563,6,,"","","ChangeHistory.SI_TITLE",0,-2147483563,6,,"","","ChangeHistory.OPER_DATE",0,-2147483563,6,,"","","ChangeHistory.TERM_DATE",0,-2147483563,6,,"","","ChangeHistory.PARENTCD",0,-2147483563,6,,"","","ChangeHistory.ENTITYCD",0,-2147483563,8,,"","","(((ChangeHistory.ENTITYCD)=""N04""))",,-2147483563,11,,"","","ChangeHistory.GEOGCD",,-2147483562,0,,"","","",0,-2147483562,255,,"","","",,-2147483562,1,,"","","",1,-2147483562,3,,"","","",0,-2147483562,5,,"ChangeHistory","","",,-2147483562,6,,"","","ChangeHistory.GEOGCD",0,-2147483562,6,,"","","ChangeHistory.GEOGNM",0,-2147483562,6,,"","","ChangeHistory.SI_ID",0,-2147483562,6,,"","","ChangeHistory.SI_TITLE",0,-2147483562,6,,"","","ChangeHistory.OPER_DATE",0,-2147483562,6,,"","","ChangeHistory.TERM_DATE",0,-2147483562,6,,"","","ChangeHistory.PARENTCD",0,-2147483562,6,,"","","ChangeHistory.ENTITYCD",0,-2147483562,8,,"","","(((ChangeHistory.ENTITYCD)=""N05""))",,-2147483562,11,,"","","ChangeHistory.GEOGCD",,-2147483561,0,,"","","",0,-2147483561,255,,"","","",,-2147483561,1,,"","","",1,-2147483561,3,,"","","",0,-2147483561,5,,"ChangeHistory","","",,-2147483561,6,,"","","ChangeHistory.GEOGCD",0,-2147483561,6,,"","","ChangeHistory.GEOGNM",0,-2147483561,6,,"","","ChangeHistory.SI_ID",0,-2147483561,6,,"","","ChangeHistory.SI_TITLE",0,-2147483561,6,,"","","ChangeHistory.OPER_DATE",0,-2147483561,6,,"","","ChangeHistory.TERM_DATE",0,-2147483561,6,,"","","ChangeHistory.PARENTCD",0,-2147483561,6,,"","","ChangeHistory.ENTITYCD",0,-2147483561,8,,"","","(((ChangeHistory.ENTITYCD)=""N06""))",,-2147483561,11,,"","","ChangeHistory.GEOGCD",,-2147483560,0,,"","","",0,-2147483560,255,,"","","",,-2147483560,1,,"","","",1,-2147483560,3,,"","","",0,-2147483560,5,,"ChangeHistory","","",,-2147483560,6,,"","","ChangeHistory.GEOGCD",0,-2147483560,6,,"","","ChangeHistory.GEOGNM",0,-2147483560,6,,"","","ChangeHistory.SI_ID",0,-2147483560,6,,"","","ChangeHistory.SI_TITLE",0,-2147483560,6,,"","","ChangeHistory.OPER_DATE",0,-2147483560,6,,"","","ChangeHistory.TERM_DATE",0,-2147483560,6,,"","","ChangeHistory.PARENTCD",0,-2147483560,6,,"","","ChangeHistory.ENTITYCD",0,-2147483560,8,,"","","(((ChangeHistory.ENTITYCD)=""N07""))",,-2147483560,11,,"","","ChangeHistory.GEOGCD",,-2147483559,0,,"","","",0,-2147483559,255,,"","","",,-2147483559,1,,"","","",1,-2147483559,3,,"","","",0,-2147483559,5,,"ChangeHistory","","",,-2147483559,6,,"","","ChangeHistory.GEOGCD",0,-2147483559,6,,"","","ChangeHistory.GEOGNM",0,-2147483559,6,,"","","ChangeHistory.SI_ID",0,-2147483559,6,,"","","ChangeHistory.SI_TITLE",0,-2147483559,6,,"","","ChangeHistory.OPER_DATE",0,-2147483559,6,,"","","ChangeHistory.TERM_DATE",0,-2147483559,6,,"","","ChangeHistory.PARENTCD",0,-2147483559,6,,"","","ChangeHistory.ENTITYCD",0,-2147483559,8,,"","","(((ChangeHistory.ENTITYCD)=""N92""))",,-2147483559,11,,"","","ChangeHistory.GEOGCD",,-2147483558,0,,"","","",0,-2147483558,255,,"","","",,-2147483558,1,,"","","",1,-2147483558,3,,"","","",0,-2147483558,5,,"W09 (NAWCs)","","",,-2147483558,5,,"W10 (NAWERs)","","",,-2147483558,6,,"NAWCCD","","[W09 (NAWCs)].GEOGCD",0,-2147483558,6,,"NAWCNM","","[W09 (NAWCs)].GEOGNM",0,-2147483558,6,,"NAWERCD","","[W10 (NAWERs)].GEOGCD",0,-2147483558,6,,"NAWERNM","","[W10 (NAWERs)].GEOGNM",0,-2147483558,7,,"W10 (NAWERs)","W09 (NAWCs)","[W10 (NAWERs)].GEOGCD = [W09 (NAWCs)].PARENTCD",1,-2147483558,8,,"","","((([W10 (NAWERs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([W10 (NAWERs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([W10 (NAWERs)].TERM_DATE) Is Null) AND (([W09 (NAWCs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([W09 (NAWCs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([W09 (NAWCs)].TERM_DATE) Is Null))",,-2147483558,11,,"","","[W09 (NAWCs)].GEOGCD",,-2147483557,0,,"","","",0,-2147483557,255,,"","","",,-2147483557,1,,"","","",1,-2147483557,3,,"","","",0,-2147483557,5,,"E18 (SHAs)","","",,-2147483557,5,,"E19 (PSHAs)","","",,-2147483557,6,,"SHACD","","[E18 (SHAs)].GEOGCD",0,-2147483557,6,,"SHANM","","[E18 (SHAs)].GEOGNM",0,-2147483557,6,,"PSHACD","","[E19 (PSHAs)].GEOGCD",0,-2147483557,6,,"PSHANM","","[E19 (PSHAs)].GEOGNM",0,-2147483557,7,,"E19 (PSHAs)","E18 (SHAs)","[E19 (PSHAs)].GEOGCD = [E18 (SHAs)].PARENTCD",1,-2147483557,8,,"","","((([E19 (PSHAs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([E19 (PSHAs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([E19 (PSHAs)].TERM_DATE) Is Null) AND (([E18 (SHAs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([E18 (SHAs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([E18 (SHAs)].TERM_DATE) Is Null))",,-2147483557,11,,"","","[E18 (SHAs)].GEOGCD",,-2147483556,0,,"","","",0,-2147483556,255,,"","","",,-2147483556,3,,"","","",1,-2147483556,5,,"Changes","","",,-2147483556,8,,"","","Changes.ENTITYCD IN('E31')AND Changes.YEAR IN('2009')",,-2147483556,11,,"","","Changes.ENTITYCD",,-2147483556,11,,"","","Changes.GEOGCD",,-2147483555,0,,"","","",0,-2147483555,255,,"","","",,-2147483555,1,,"","","",1,-2147483555,3,,"","","",0,-2147483555,5,,"CH2008","","",,-2147483555,5,,"CH2008eoy","","",,-2147483555,6,,"","","CH2008.GEOG08CD",0,-2147483555,6,,"","","CH2008.GEOG08NM",0,-2147483555,6,,"code09b","","CH2008.GEOG09CD",0,-2147483555,6,,"name09b","","CH2008.GEOG09NM",0,-2147483555,6,,"","","CH2008.SI_ID09",0,-2147483555,6,,"","","CH2008.SI_TITLE09",0,-2147483555,6,,"","","CH2008.OPER_DATE09",0,-2147483555,6,,"","","CH2008eoy.GEOG09CD",0,-2147483555,6,,"","","CH2008eoy.GEOG09NM",0,-2147483555,6,,"","","CH2008eoy.SI_ID09",0,-2147483555,6,,"","","CH2008eoy.SI_TITLE09",0,-2147483555,6,,"","","CH2008eoy.OPER_DATE09",0,-2147483555,6,,"","","CH2008eoy.ENTITY09CD",0,-2147483555,7,,"CH2008","CH2008eoy","CH2008.GEOG09CD = CH2008eoy.GEOG08CD",3,-2147483555,11,,"","","CH2008.GEOG09CD",,-2147483554,0,,"","","",0,-2147483554,255,,"","","",,-2147483554,3,,"","","",1,-2147483554,5,,"InfoTable","","",,-2147483554,8,,"","","InfoTable.ENTITYCD IN('W06','W16')",,-2147483554,11,,"","","InfoTable.ENTITYCD",,-2147483553,0,,"","","",0,-2147483553,255,,"","","",,-2147483553,1,,"","","",1,-2147483553,3,,"","","",0,-2147483553,5,,"Changes","","",,-2147483553,6,,"","","Changes.GEOGCD",0,-2147483553,6,,"","","Changes.GEOGNM",0,-2147483553,6,,"Previous Geography Code","","CombineChildRecords(""Changes"",""GEOGCD_P"",""GEOGCD"",[GEOGCD],"", "")",0,-2147483553,6,,"","","Changes.SI_ID",0,-2147483553,6,,"","","Changes.SI_TITLE",0,-2147483553,6,,"","","Changes.OPER_DATE",0,-2147483553,6,,"","","Changes.ENTITYCD",0,-2147483553,9,,"","","Changes.GEOGCD",0,-2147483553,9,,"","","Changes.GEOGNM",0,-2147483553,9,,"","","Changes.SI_ID",0,-2147483553,9,,"","","Changes.SI_TITLE",0,-2147483553,9,,"","","Changes.OPER_DATE",0,-2147483553,9,,"","","Changes.ENTITYCD",0,-2147483553,9,,"","","CombineChildRecords(""Changes"",""GEOGCD_P"",""GEOGCD"",[GEOGCD],"","")",0,-2147483552,0,,"","","",0,-2147483552,255,,"","","",,-2147483552,1,,"","","",1,-2147483552,3,,"","","",0,-2147483552,5,,"QryChangesbyEntity","","",,-2147483552,6,,"","","QryChangesbyEntity.GEOGCD",0,-2147483552,6,,"","","QryChangesbyEntity.GEOGNM",0,-2147483552,6,,"Previous Geography Code","","CombineChildRecordsEntity(""QryChangesbyEntity"",""GEOGCD_P"",""GEOGCD"",[GEOGCD],"", "")",0,-2147483552,6,,"","","QryChangesbyEntity.SI_ID",0,-2147483552,6,,"","","QryChangesbyEntity.SI_TITLE",0,-2147483552,6,,"","","QryChangesbyEntity.OPER_DATE",0,-2147483552,6,,"","","QryChangesbyEntity.ENTITYCD",0,-2147483552,9,,"","","QryChangesbyEntity.GEOGCD",0,-2147483552,9,,"","","QryChangesbyEntity.GEOGNM",0,-2147483552,9,,"","","QryChangesbyEntity.SI_ID",0,-2147483552,9,,"","","QryChangesbyEntity.SI_TITLE",0,-2147483552,9,,"","","QryChangesbyEntity.OPER_DATE",0,-2147483552,9,,"","","QryChangesbyEntity.ENTITYCD",0,-2147483552,9,,"","","CombineChildRecordsEntity(""QryChangesbyEntity"",""GEOGCD_P"",""GEOGCD"",[GEOGCD],"","")",0,-2147483551,0,,"","","",0,-2147483551,255,,"","","",,-2147483551,1,,"","","",1,-2147483551,3,,"","","",0,-2147483551,5,,"E28 (REGDs)","","",,-2147483551,5,,"E29 (REGSDs)","","",,-2147483551,6,,"REGSDCD","","[E29 (REGSDs)].GEOGCD",0,-2147483551,6,,"REGSDNM","","[E29 (REGSDs)].GEOGNM",0,-2147483551,6,,"REGDCD","","[E28 (REGDs)].GEOGCD",0,-2147483551,6,,"REGDNM","","[E28 (REGDs)].GEOGNM",0,-2147483551,7,,"E28 (REGDs)","E29 (REGSDs)","[E28 (REGDs)].GEOGCD = [E29 (REGSDs)].PARENTCD",1,-2147483551,8,,"","","((([E28 (REGDs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([E28 (REGDs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([E28 (REGDs)].TERM_DATE) Is Null) AND (([E29 (REGSDs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([E29 (REGSDs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([E29 (REGSDs)].TERM_DATE) Is Null))",,-2147483550,0,,"","","",0,-2147483550,255,,"","","",,-2147483550,1,,"","","",1,-2147483550,3,,"","","",0,-2147483550,5,,"W20 (REGDs)","","",,-2147483550,5,,"W21 (REGSDs)","","",,-2147483550,6,,"REGSDCD","","[W21 (REGSDs)].GEOGCD",0,-2147483550,6,,"REGSDNM","","[W21 (REGSDs)].GEOGNM",0,-2147483550,6,,"REGDCD","","[W20 (REGDs)].GEOGCD",0,-2147483550,6,,"REGDNM","","[W20 (REGDs)].GEOGNM",0,-2147483550,7,,"W20 (REGDs)","W21 (REGSDs)","[W20 (REGDs)].GEOGCD = [W21 (REGSDs)].PARENTCD",1,-2147483550,8,,"","","((([W20 (REGDs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([W20 (REGDs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([W20 (REGDs)].TERM_DATE) Is Null) AND (([W21 (REGSDs)].OPER_DATE)<=[Forms]![FrmConstitutionsView]![Start Date]) AND (([W21 (REGSDs)].TERM_DATE)>=[Forms]![FrmConstitutionsView]![Start Date] Or ([W21 (REGSDs)].TERM_DATE) Is Null))",,-2147483550,11,,"","","[W20 (REGDs)].GEOGCD",,-2147483549,0,,"","","",0,-2147483549,255,,"","","",,-2147483549,1,,"","","",1,-2147483549,3,,"","","",0,-2147483549,5,,"ChangeHistory","","",,-2147483549,6,,"","","ChangeHistory.GEOGCD",0,-2147483549,6,,"","","ChangeHistory.GEOGNM",0,-2147483549,6,,"","","ChangeHistory.SI_ID",0,-2147483549,6,,"","","ChangeHistory.SI_TITLE",0,-2147483549,6,,"","","ChangeHistory.OPER_DATE",0,-2147483549,6,,"","","ChangeHistory.TERM_DATE",0,-2147483549,6,,"","","ChangeHistory.PARENTCD",0,-2147483549,6,,"","","ChangeHistory.ENTITYCD",0,-2147483549,8,,"","","(((ChangeHistory.ENTITYCD)=""S00""))",,-2147483549,11,,"","","ChangeHistory.GEOGCD",,-2147483548,0,,"","","",0,-2147483548,255,,"","","",,-2147483548,1,,"","","",1,-2147483548,3,,"","","",0,-2147483548,5,,"ChangeHistory","","",,-2147483548,6,,"","","ChangeHistory.GEOGCD",0,-2147483548,6,,"","","ChangeHistory.GEOGNM",0,-2147483548,6,,"","","ChangeHistory.SI_ID",0,-2147483548,6,,"","","ChangeHistory.SI_TITLE",0,-2147483548,6,,"","","ChangeHistory.OPER_DATE",0,-2147483548,6,,"","","ChangeHistory.TERM_DATE",0,-2147483548,6,,"","","ChangeHistory.PARENTCD",0,-2147483548,6,,"","","ChangeHistory.ENTITYCD",0,-2147483548,8,,"","","(((ChangeHistory.ENTITYCD)=""S01""))",,-2147483548,11,,"","","ChangeHistory.GEOGCD",,-2147483547,0,,"","","",0,-2147483547,255,,"","","",,-2147483547,1,,"","","",1,-2147483547,3,,"","","",0,-2147483547,5,,"ChangeHistory","","",,-2147483547,6,,"","","ChangeHistory.GEOGCD",0,-2147483547,6,,"","","ChangeHistory.GEOGNM",0,-2147483547,6,,"","","ChangeHistory.SI_ID",0,-2147483547,6,,"","","ChangeHistory.SI_TITLE",0,-2147483547,6,,"","","ChangeHistory.OPER_DATE",0,-2147483547,6,,"","","ChangeHistory.TERM_DATE",0,-2147483547,6,,"","","ChangeHistory.PARENTCD",0,-2147483547,6,,"","","ChangeHistory.ENTITYCD",0,-2147483547,8,,"","","(((ChangeHistory.ENTITYCD)=""S02""))",,-2147483547,11,,"","","ChangeHistory.GEOGCD",,-2147483546,0,,"","","",0,-2147483546,255,,"","","",,-2147483546,1,,"","","",1,-2147483546,3,,"","","",0,-2147483546,5,,"Gazetteer","","",,-2147483546,6,,"","","Gazetteer.Status",0,-2147483546,9,,"","","Gazetteer.Status",0,-2147483545,0,,"","","",0,-2147483545,255,,"","","",,-2147483545,1,,"","","",4,-2147483545,3,,"","","",0,-2147483545,5,,"CHDB_Update","","",,-2147483545,5,,"SIDetails","","",,-2147483545,6,,"","CHDB_Update.[SI TITLE]","[SIDetails]![SI Title]",0,-2147483545,7,,"CHDB_Update","SIDetails","CHDB_Update.[SI NUMBER] = SIDetails.[SI Number]",1,-2147483544,0,,"","","",0,-2147483544,255,,"","","",,-2147483544,1,,"","","",4,-2147483544,3,,"","","",0,-2147483544,5,,"CHDB_Update","","",,-2147483544,5,,"Equivalents","","",,-2147483544,6,,"","CHDB_Update.[OLD GEOGCD]","[Equivalents]![GEOGCD]",0,-2147483544,6,,"","CHDB_Update.[OLD GEOGNM]","[Equivalents]![GEOGNM]",0,-2147483544,6,,"","CHDB_Update.[OLD GEOGNMW]","[Equivalents]![GEOGNMW]",0,-2147483544,6,,"","CHDB_Update.ONSNAME_PREV","[Equivalents]![GEOGNMO]",0,-2147483544,7,,"CHDB_Update","Equivalents","CHDB_Update.ONSCODE_PREV = Equivalents.GEOGCDO",1,-2147483544,7,,"CHDB_Update","Equivalents","CHDB_Update.ENTITYCD = Equivalents.ENTITYCD",1,-2147483543,0,,"","","",0,-2147483543,255,,"","","",,-2147483543,1,,"ChangeHistory","","",3,-2147483543,3,,"","","",0,-2147483543,5,,"CHDB_Update","","",,-2147483543,6,,"","GEOGCD","CHDB_Update.GEOGCD",0,-2147483543,6,,"","GEOGNM","CHDB_Update.GEOGNM",0,-2147483543,6,,"","GEOGNMW","CHDB_Update.GEOGNMW",0,-2147483543,6,,"","SI_ID","CHDB_Update.[SI NUMBER]",0,-2147483543,6,,"","SI_TITLE","CHDB_Update.[SI TITLE]",0,-2147483543,6,,"","OPER_DATE","CHDB_Update.OPER_DATE",0,-2147483543,6,,"","ENTITYCD","CHDB_Update.ENTITYCD",0,-2147483543,6,,"","OWNER","CHDB_Update.OWNER",0,-2147483543,6,,"","PARENTCD","CHDB_Update.PARENTCD",0,-2147483543,9,,"","","CHDB_Update.GEOGCD",0,-2147483543,9,,"","","CHDB_Update.GEOGNM",0,-2147483543,9,,"","","CHDB_Update.GEOGNMW",0,-2147483543,9,,"","","CHDB_Update.[SI NUMBER]",0,-2147483543,9,,"","","CHDB_Update.[SI TITLE]",0,-2147483543,9,,"","","CHDB_Update.OPER_DATE",0,-2147483543,9,,"","","CHDB_Update.ENTITYCD",0,-2147483543,9,,"","","CHDB_Update.OWNER",0,-2147483543,9,,"","","CHDB_Update.PARENTCD",0,-2147483543,10,,"","","(((CHDB_Update.GEOGCD) Is Not Null))",,-2147483543,11,,"","","CHDB_Update.ENTITYCD",,-2147483542,0,,"","","",0,-2147483542,255,,"","","",,-2147483542,1,,"","","",4,-2147483542,3,,"","","",0,-2147483542,5,,"ChangeHistory","","",,-2147483542,5,,"CHDB_Update","","",,-2147483542,6,,"","ChangeHistory.TERM_DATE","[CHDB_Update]![TERM_DATE]",0,-2147483542,7,,"CHDB_Update","ChangeHistory","CHDB_Update.[OLD GEOGCD] = ChangeHistory.GEOGCD",1,-2147483542,8,,"","","(([CHDB_Update]![TERM_DATE]>[ChangeHistory]![OPER_DATE]))",,-2147483541,0,,"","","",0,-2147483541,255,,"","","",,-2147483541,1,,"Changes","","",3,-2147483541,3,,"","","",0,-2147483541,5,,"CHDB_Update","","",,-2147483541,6,,"","GEOGCD","CHDB_Update.GEOGCD",0,-2147483541,6,,"","GEOGNM","CHDB_Update.GEOGNM",0,-2147483541,6,,"","GEOGNMW","CHDB_Update.GEOGNMW",0,-2147483541,6,,"","GEOGCD_P","CHDB_Update.[OLD GEOGCD]",0,-2147483541,6,,"","GEOGNM_P","CHDB_Update.[OLD GEOGNM]",0,-2147483541,6,,"","GEOGNMW_P","CHDB_Update.[OLD GEOGNMW]",0,-2147483541,6,,"","SI_ID","CHDB_Update.[SI NUMBER]",0,-2147483541,6,,"","SI_TITLE","CHDB_Update.[SI TITLE]",0,-2147483541,6,,"","OPER_DATE","CHDB_Update.OPER_DATE",0,-2147483541,6,,"","ENTITYCD","CHDB_Update.ENTITYCD",0,-2147483541,6,,"","YEAR","CHDB_Update.YEAR",0,-2147483541,9,,"","","CHDB_Update.GEOGCD",0,-2147483541,9,,"","","CHDB_Update.GEOGNM",0,-2147483541,9,,"","","CHDB_Update.GEOGNMW",0,-2147483541,9,,"","","CHDB_Update.[OLD GEOGCD]",0,-2147483541,9,,"","","CHDB_Update.[OLD GEOGNM]",0,-2147483541,9,,"","","CHDB_Update.[OLD GEOGNMW]",0,-2147483541,9,,"","","CHDB_Update.[SI NUMBER]",0,-2147483541,9,,"","","CHDB_Update.[SI TITLE]",0,-2147483541,9,,"","","CHDB_Update.OPER_DATE",0,-2147483541,9,,"","","CHDB_Update.ENTITYCD",0,-2147483541,9,,"","","CHDB_Update.YEAR",0,-2147483540,0,,"","","",0,-2147483540,255,,"","","",,-2147483540,1,,"Equivalents","","",3,-2147483540,3,,"","","",0,-2147483540,5,,"CHDB_Update","","",,-2147483540,6,,"","GEOGCD","CHDB_Update.GEOGCD",0,-2147483540,6,,"","GEOGNM","CHDB_Update.GEOGNM",0,-2147483540,6,,"","GEOGNMW","CHDB_Update.GEOGNMW",0,-2147483540,6,,"","GEOGCDO","CHDB_Update.ONSCODE",0,-2147483540,6,,"","GEOGNMO","CHDB_Update.ONSNAME",0,-2147483540,6,,"","GEOGCDD","CHDB_Update.GEOGCDD",0,-2147483540,6,,"","GEOGNMD","CHDB_Update.GEOGNMD",0,-2147483540,6,,"","GEOGCDH","CHDB_Update.GEOGCDH",0,-2147483540,6,,"","GEOGNMH","CHDB_Update.GEOGNMH",0,-2147483540,6,,"","GEOGCDS","CHDB_Update.GEOGCDS",0,-2147483540,6,,"","GEOGNMS","CHDB_Update.GEOGNMS",0,-2147483540,6,,"","GEOGCDI","CHDB_Update.GEOGCDI",0,-2147483540,6,,"","GEOGNMI","CHDB_Update.GEOGNMI",0,-2147483540,6,,"","GEOGCDWAG","CHDB_Update.GEOGCDWAG",0,-2147483540,6,,"","GEOGNMWAG","CHDB_Update.GEOGNMWAG",0,-2147483540,6,,"","OPER_DATE","CHDB_Update.OPER_DATE",0,-2147483540,6,,"","YEAR","CHDB_Update.YEAR",0,-2147483540,6,,"","ENTITYCD","CHDB_Update.ENTITYCD",0,-2147483540,9,,"","","CHDB_Update.GEOGCD",0,-2147483540,9,,"","","CHDB_Update.GEOGNM",0,-2147483540,9,,"","","CHDB_Update.GEOGNMW",0,-2147483540,9,,"","","CHDB_Update.ONSCODE",0,-2147483540,9,,"","","CHDB_Update.ONSNAME",0,-2147483540,9,,"","","CHDB_Update.GEOGCDD",0,-2147483540,9,,"","","CHDB_Update.GEOGNMD",0,-2147483540,9,,"","","CHDB_Update.GEOGCDH",0,-2147483540,9,,"","","CHDB_Update.GEOGNMH",0,-2147483540,9,,"","","CHDB_Update.GEOGCDS",0,-2147483540,9,,"","","CHDB_Update.GEOGNMS",0,-2147483540,9,,"","","CHDB_Update.GEOGCDI",0,-2147483540,9,,"","","CHDB_Update.GEOGNMI",0,-2147483540,9,,"","","CHDB_Update.GEOGCDWAG",0,-2147483540,9,,"","","CHDB_Update.GEOGNMWAG",0,-2147483540,9,,"","","CHDB_Update.OPER_DATE",0,-2147483540,9,,"","","CHDB_Update.YEAR",0,-2147483540,9,,"","","CHDB_Update.ENTITYCD",0,-2147483540,10,,"","","(((CHDB_Update.GEOGCD) Not Like ""E04999999"" And (CHDB_Update.GEOGCD) Not Like ""W04999999""))",,-2147483540,11,,"","","CHDB_Update.GEOGCD",,-2147483539,0,,"","","",0,-2147483539,255,,"","","",,-2147483539,1,,"","","",4,-2147483539,3,,"","","",0,-2147483539,5,,"CHDB_Update","","",,-2147483539,5,,"Equivalents","","",,-2147483539,6,,"","Equivalents.TERM_DATE","[CHDB_Update]![TERM_DATE]",0,-2147483539,7,,"CHDB_Update","Equivalents","CHDB_Update.[OLD GEOGCD] = Equivalents.GEOGCD",1,-2147483539,8,,"","","(((CHDB_Update.TERM_DATE)>[Equivalents]![OPER_DATE]))",,-2147483538,0,,"","","",0,-2147483538,255,,"","","",,-2147483538,1,,"","","",4,-2147483538,3,,"","","",0,-2147483538,5,,"Gazetteer","","",,-2147483538,5,,"InfoTable","","",,-2147483538,6,,"","InfoTable.ENTITYNM","[Gazetteer]![Geography]",0,-2147483538,6,,"","InfoTable.Acronym","[Gazetteer]![Acronym]",0,-2147483538,6,,"","InfoTable.Theme","[Gazetteer]![Geographytype]",0,-2147483538,6,,"","InfoTable.Coverage","[Gazetteer]![Country]",0,-2147483538,6,,"","InfoTable.[Number of live instances]","[Gazetteer]![Number of entities]",0,-2147483538,6,,"","InfoTable.[Parental Hierarchy]","[Gazetteer]![Lower level hierarchy]",0,-2147483538,6,,"","InfoTable.[Summary description]","[Gazetteer]![Summary description]",0,-2147483538,6,,"","InfoTable.Weblink","[Gazetteer]![Weblink]",0,-2147483538,6,,"","InfoTable.[Policy Department]","[Gazetteer]![Policy Department]",0,-2147483538,6,,"","InfoTable.[Policy Department website]","[Gazetteer]![Policy Department website]",0,-2147483538,6,,"","InfoTable.[Policy Department contact]","[Gazetteer]![Policy Department contact]",0,-2147483538,6,,"","InfoTable.[Revision Cycle]","[Gazetteer]![Revision cycle]",0,-2147483538,6,,"","InfoTable.[Are digital boundaries available?]","[Gazetteer]![Are digital boundaries available?]",0,-2147483538,6,,"","InfoTable.[Organisation responsible for boundary creation]","[Gazetteer]![Organisation responsible for boundary creation]",0,-2147483538,6,,"","InfoTable.[Notes/Issues:]","[Gazetteer]![Notes/Issues:]",0,-2147483538,6,,"","InfoTable.[on the ONS All Fields Postcode Directory?]","[Gazetteer]![on the ONS All Fields Postcode Directory?]",0,-2147483538,6,,"","InfoTable.[in the ONS Digital Boundary Library?]","[Gazetteer]![in the ONS Digital Boundary Library?]",0,-2147483538,6,,"","InfoTable.Status","[Gazetteer]![Status]",0,-2147483538,7,,"Gazetteer","InfoTable","Gazetteer.[Entitiy Code] = InfoTable.ENTITYCD",1,-2147483537,0,,"","","",0,-2147483537,255,,"","","",,-2147483537,1,,"","","",1,-2147483537,3,,"","","",0,-2147483537,5,,"ChangeHistory","","",,-2147483537,6,,"","","ChangeHistory.GEOGCD",0,-2147483537,6,,"","","ChangeHistory.GEOGNM",0,-2147483537,6,,"","","ChangeHistory.SI_ID",0,-2147483537,6,,"","","ChangeHistory.SI_TITLE",0,-2147483537,6,,"","","ChangeHistory.OPER_DATE",0,-2147483537,6,,"","","ChangeHistory.TERM_DATE",0,-2147483537,6,,"","","ChangeHistory.PARENTCD",0,-2147483537,6,,"","","ChangeHistory.ENTITYCD",0,-2147483537,8,,"","","(((ChangeHistory.ENTITYCD)=""W00""))",,-2147483537,11,,"","","ChangeHistory.GEOGCD",,-2147483536,0,,"","","",0,-2147483536,255,,"","","",,-2147483536,1,,"","","",1,-2147483536,3,,"","","",0,-2147483536,5,,"ChangeHistory","","",,-2147483536,6,,"","","ChangeHistory.GEOGCD",0,-2147483536,6,,"","","ChangeHistory.GEOGNM",0,-2147483536,6,,"","","ChangeHistory.SI_ID",0,-2147483536,6,,"","","ChangeHistory.SI_TITLE",0,-2147483536,6,,"","","ChangeHistory.OPER_DATE",0,-2147483536,6,,"","","ChangeHistory.TERM_DATE",0,-2147483536,6,,"","","ChangeHistory.PARENTCD",0,-2147483536,6,,"","","ChangeHistory.ENTITYCD",0,-2147483536,8,,"","","(((ChangeHistory.ENTITYCD)=""W01""))",,-2147483536,11,,"","","ChangeHistory.GEOGCD",,-2147483535,0,,"","","",0,-2147483535,255,,"","","",,-2147483535,1,,"","","",1,-2147483535,3,,"","","",0,-2147483535,5,,"ChangeHistory","","",,-2147483535,6,,"","","ChangeHistory.GEOGCD",0,-2147483535,6,,"","","ChangeHistory.GEOGNM",0,-2147483535,6,,"","","ChangeHistory.SI_ID",0,-2147483535,6,,"","","ChangeHistory.SI_TITLE",0,-2147483535,6,,"","","ChangeHistory.OPER_DATE",0,-2147483535,6,,"","","ChangeHistory.TERM_DATE",0,-2147483535,6,,"","","ChangeHistory.PARENTCD",0,-2147483535,6,,"","","ChangeHistory.ENTITYCD",0,-2147483535,8,,"","","(((ChangeHistory.ENTITYCD)=""W02""))",,-2147483535,11,,"","","ChangeHistory.GEOGCD",,-2147483534,0,,"","","",0,-2147483534,255,,"","","",,-2147483534,1,,"","","",1,-2147483534,3,,"","","",0,-2147483534,5,,"ChangeHistory","","",,-2147483534,6,,"","","ChangeHistory.GEOGCD",0,-2147483534,6,,"","","ChangeHistory.GEOGNM",0,-2147483534,6,,"","","ChangeHistory.SI_ID",0,-2147483534,6,,"","","ChangeHistory.SI_TITLE",0,-2147483534,6,,"","","ChangeHistory.OPER_DATE",0,-2147483534,6,,"","","ChangeHistory.TERM_DATE",0,-2147483534,6,,"","","ChangeHistory.PARENTCD",0,-2147483534,6,,"","","ChangeHistory.ENTITYCD",0,-2147483534,8,,"","","(((ChangeHistory.ENTITYCD)=""W03""))",,-2147483534,11,,"","","ChangeHistory.GEOGCD",,-2147483533,0,,"","","",0,-2147483533,255,,"","","",,-2147483533,1,,"","","",1,-2147483533,3,,"","","",0,-2147483533,5,,"WalesWards","","",,-2147483533,6,,"","","WalesWards.GEOGCD",0,-2147483533,6,,"","","WalesWards.GEOGNM",0,-2147483533,6,,"","","WalesWards.SI_ID",0,-2147483533,6,,"","","WalesWards.SI_TITLE",0,-2147483533,6,,"","","WalesWards.OPER_DATE",0,-2147483533,6,,"","","WalesWards.TERM_DATE",0,-2147483533,6,,"","","WalesWards.PARENTCD",0,-2147483533,6,,"","","WalesWards.ENTITYCD",0,-2147483533,8,,"","","(((WalesWards.ENTITYCD)=""W05""))",,-2147483533,11,,"","","WalesWards.GEOGCD",,-2147483532,0,,"","","",0,-2147483532,255,,"","","",,-2147483532,1,,"","","",1,-2147483532,3,,"","","",0,-2147483532,5,,"ChangeHistory","","",,-2147483532,6,,"","","ChangeHistory.GEOGCD",0,-2147483532,6,,"","","ChangeHistory.GEOGNM",0,-2147483532,6,,"","","ChangeHistory.SI_ID",0,-2147483532,6,,"","","ChangeHistory.SI_TITLE",0,-2147483532,6,,"","","ChangeHistory.OPER_DATE",0,-2147483532,6,,"","","ChangeHistory.TERM_DATE",0,-2147483532,6,,"","","ChangeHistory.PARENTCD",0,-2147483532,6,,"","","ChangeHistory.ENTITYCD",0,-2147483532,8,,"","","(((ChangeHistory.ENTITYCD)=""W05""))",,-2147483532,11,,"","","ChangeHistory.GEOGCD",,-2147483531,0,,"","","",0,-2147483531,255,,"","","",,-2147483531,1,,"","","",1,-2147483531,3,,"","","",0,-2147483531,5,,"ChangeHistory","","",,-2147483531,6,,"","","ChangeHistory.GEOGCD",0,-2147483531,6,,"","","ChangeHistory.GEOGNM",0,-2147483531,6,,"","","ChangeHistory.SI_ID",0,-2147483531,6,,"","","ChangeHistory.SI_TITLE",0,-2147483531,6,,"","","ChangeHistory.OPER_DATE",0,-2147483531,6,,"","","ChangeHistory.TERM_DATE",0,-2147483531,6,,"","","ChangeHistory.PARENTCD",0,-2147483531,6,,"","","ChangeHistory.ENTITYCD",0,-2147483531,8,,"","","(((ChangeHistory.ENTITYCD)=""W06""))",,-2147483531,11,,"","","ChangeHistory.GEOGCD",,-2147483530,0,,"","","",0,-2147483530,255,,"","","",,-2147483530,1,,"","","",1,-2147483530,3,,"","","",0,-2147483530,5,,"ChangeHistory","","",,-2147483530,6,,"","","ChangeHistory.GEOGCD",0,-2147483530,6,,"","","ChangeHistory.GEOGNM",0,-2147483530,6,,"","","ChangeHistory.SI_ID",0,-2147483530,6,,"","","ChangeHistory.SI_TITLE",0,-2147483530,6,,"","","ChangeHistory.OPER_DATE",0,-2147483530,6,,"","","ChangeHistory.TERM_DATE",0,-2147483530,6,,"","","ChangeHistory.PARENTCD",0,-2147483530,6,,"","","ChangeHistory.ENTITYCD",0,-2147483530,8,,"","","(((ChangeHistory.ENTITYCD)=""W07""))",,-2147483530,11,,"","","ChangeHistory.GEOGCD",,-2147483529,0,,"","","",0,-2147483529,255,,"","","",,-2147483529,1,,"","","",1,-2147483529,3,,"","","",0,-2147483529,5,,"ChangeHistory","","",,-2147483529,6,,"","","ChangeHistory.GEOGCD",0,-2147483529,6,,"","","ChangeHistory.GEOGNM",0,-2147483529,6,,"","","ChangeHistory.SI_ID",0,-2147483529,6,,"","","ChangeHistory.SI_TITLE",0,-2147483529,6,,"","","ChangeHistory.OPER_DATE",0,-2147483529,6,,"","","ChangeHistory.TERM_DATE",0,-2147483529,6,,"","","ChangeHistory.PARENTCD",0,-2147483529,6,,"","","ChangeHistory.ENTITYCD",0,-2147483529,8,,"","","(((ChangeHistory.ENTITYCD)=""W08""))",,-2147483529,11,,"","","ChangeHistory.GEOGCD",,-2147483528,0,,"","","",0,-2147483528,255,,"","","",,-2147483528,1,,"","","",1,-2147483528,3,,"","","",0,-2147483528,5,,"ChangeHistory","","",,-2147483528,6,,"","","ChangeHistory.GEOGCD",0,-2147483528,6,,"","","ChangeHistory.GEOGNM",0,-2147483528,6,,"","","ChangeHistory.SI_ID",0,-2147483528,6,,"","","ChangeHistory.SI_TITLE",0,-2147483528,6,,"","","ChangeHistory.OPER_DATE",0,-2147483528,6,,"","","ChangeHistory.TERM_DATE",0,-2147483528,6,,"","","ChangeHistory.PARENTCD",0,-2147483528,6,,"","","ChangeHistory.ENTITYCD",0,-2147483528,8,,"","","(((ChangeHistory.ENTITYCD)=""W09""))",,-2147483528,11,,"","","ChangeHistory.GEOGCD",,-2147483527,0,,"","","",0,-2147483527,255,,"","","",,-2147483527,1,,"","","",1,-2147483527,3,,"","","",0,-2147483527,5,,"ChangeHistory","","",,-2147483527,6,,"","","ChangeHistory.GEOGCD",0,-2147483527,6,,"","","ChangeHistory.GEOGNM",0,-2147483527,6,,"","","ChangeHistory.SI_ID",0,-2147483527,6,,"","","ChangeHistory.SI_TITLE",0,-2147483527,6,,"","","ChangeHistory.OPER_DATE",0,-2147483527,6,,"","","ChangeHistory.TERM_DATE",0,-2147483527,6,,"","","ChangeHistory.PARENTCD",0,-2147483527,6,,"","","ChangeHistory.ENTITYCD",0,-2147483527,8,,"","","(((ChangeHistory.ENTITYCD)=""W10""))",,-2147483527,11,,"","","ChangeHistory.GEOGCD",,-2147483526,0,,"","","",0,-2147483526,255,,"","","",,-2147483526,1,,"","","",1,-2147483526,3,,"","","",0,-2147483526,5,,"ChangeHistory","","",,-2147483526,6,,"","","ChangeHistory.GEOGCD",0,-2147483526,6,,"","","ChangeHistory.GEOGNM",0,-2147483526,6,,"","","ChangeHistory.SI_ID",0,-2147483526,6,,"","","ChangeHistory.SI_TITLE",0,-2147483526,6,,"","","ChangeHistory.OPER_DATE",0,-2147483526,6,,"","","ChangeHistory.TERM_DATE",0,-2147483526,6,,"","","ChangeHistory.PARENTCD",0,-2147483526,6,,"","","ChangeHistory.ENTITYCD",0,-2147483526,8,,"","","(((ChangeHistory.ENTITYCD)=""W16""))",,-2147483526,11,,"","","ChangeHistory.GEOGCD",,-2147483525,0,,"","","",0,-2147483525,255,,"","","",,-2147483525,1,,"","","",1,-2147483525,3,,"","","",0,-2147483525,5,,"ChangeHistory","","",,-2147483525,6,,"","","ChangeHistory.GEOGCD",0,-2147483525,6,,"","","ChangeHistory.GEOGNM",0,-2147483525,6,,"","","ChangeHistory.SI_ID",0,-2147483525,6,,"","","ChangeHistory.SI_TITLE",0,-2147483525,6,,"","","ChangeHistory.OPER_DATE",0,-2147483525,6,,"","","ChangeHistory.TERM_DATE",0,-2147483525,6,,"","","ChangeHistory.PARENTCD",0,-2147483525,6,,"","","ChangeHistory.ENTITYCD",0,-2147483525,8,,"","","(((ChangeHistory.ENTITYCD)=""W17""))",,-2147483525,11,,"","","ChangeHistory.GEOGCD",,-2147483524,0,,"","","",0,-2147483524,255,,"","","",,-2147483524,1,,"","","",1,-2147483524,3,,"","","",0,-2147483524,5,,"ChangeHistory","","",,-2147483524,6,,"","","ChangeHistory.GEOGCD",0,-2147483524,6,,"","","ChangeHistory.GEOGNM",0,-2147483524,6,,"","","ChangeHistory.SI_ID",0,-2147483524,6,,"","","ChangeHistory.SI_TITLE",0,-2147483524,6,,"","","ChangeHistory.OPER_DATE",0,-2147483524,6,,"","","ChangeHistory.TERM_DATE",0,-2147483524,6,,"","","ChangeHistory.PARENTCD",0,-2147483524,6,,"","","ChangeHistory.ENTITYCD",0,-2147483524,8,,"","","(((ChangeHistory.ENTITYCD)=""W20""))",,-2147483524,11,,"","","ChangeHistory.GEOGCD",,-2147483523,0,,"","","",0,-2147483523,255,,"","","",,-2147483523,1,,"","","",1,-2147483523,3,,"","","",0,-2147483523,5,,"ChangeHistory","","",,-2147483523,6,,"","","ChangeHistory.GEOGCD",0,-2147483523,6,,"","","ChangeHistory.GEOGNM",0,-2147483523,6,,"","","ChangeHistory.SI_ID",0,-2147483523,6,,"","","ChangeHistory.SI_TITLE",0,-2147483523,6,,"","","ChangeHistory.OPER_DATE",0,-2147483523,6,,"","","ChangeHistory.TERM_DATE",0,-2147483523,6,,"","","ChangeHistory.PARENTCD",0,-2147483523,6,,"","","ChangeHistory.ENTITYCD",0,-2147483523,8,,"","","(((ChangeHistory.ENTITYCD)=""W21""))",,-2147483523,11,,"","","ChangeHistory.GEOGCD",,-2147483522,0,,"","","",0,-2147483522,255,,"","","",,-2147483522,1,,"","","",1,-2147483522,3,,"","","",0,-2147483522,5,,"ChangeHistory","","",,-2147483522,6,,"","","ChangeHistory.GEOGCD",0,-2147483522,6,,"","","ChangeHistory.GEOGNM",0,-2147483522,6,,"","","ChangeHistory.SI_ID",0,-2147483522,6,,"","","ChangeHistory.SI_TITLE",0,-2147483522,6,,"","","ChangeHistory.OPER_DATE",0,-2147483522,6,,"","","ChangeHistory.TERM_DATE",0,-2147483522,6,,"","","ChangeHistory.PARENTCD",0,-2147483522,6,,"","","ChangeHistory.ENTITYCD",0,-2147483522,8,,"","","(((ChangeHistory.ENTITYCD)=""W92""))",,-2147483522,11,,"","","ChangeHistory.GEOGCD",,-2147483521,0,,"","","",0,-2147483521,255,,"","","",,-2147483521,1,,"","","",1,-2147483521,3,,"","","",0,-2147483521,5,,"Year Table","","",,-2147483521,6,,"","","[Year Table].YEAR",0,-2147483521,11,,"","","[Year Table].YEAR",,-2147483520,0,,"","","",0,-2147483520,255,,"","","",,-2147483520,1,,"","","",1,-2147483520,3,,"","","",0,-2147483520,5,,"Year Table - SI","","",,-2147483520,6,,"","","[Year Table - SI].YEAR",0,-2147483520,11,,"","","[Year Table - SI].YEAR",,