Skip to main content

Back to C20072

Derived field specifications - Revisions

The table below contains the revisions for all specifications of derived fields created by HESA. They are provided to aid in understanding the onwards usage of data. They may be subject to updating during the collection year, until the database for the collection closes.

For the full list of specifications, please see the Derived field specifications - Contents page.

Search by element:

Field name Version Date Revision notes
XACTMEAN2.1.12023-07-12Derivation simplification from using ALLACT01-11 to just the MIMPACT field as a result of survey changes
XACTONTRACK2.1.12023-07-12Derivation simplification from using ALLACT01-11 to just the MIMPACT field as a result of survey changes
XACTSKILLS2.1.12023-07-12Derivation simplification from using ALLACT01-11 to just the MIMPACT field as a result of survey changes
XBUS2020SOC1.1.32023-06-29Valid entry labels updated for 1137, 2472, 3554 and 5315 inline with the latest release of the SOC2020 framework by ONS (v8
XEMP2020SOC1.1.32023-06-29Valid entry labels updated for 1137, 2472, 3554 and 5315 inline with the latest release of the SOC2020 framework by ONS (v8
XWRK2020SOC1.1.32023-06-29Valid entry labels updated for 1137, 2472, 3554 and 5315 inline with the latest release of the SOC2020 framework by ONS (v8
XBUSCOMPFUND1.2.12023-03-14References to BUSCOMPFUND1-6 (depreciated from 20072 onwards) removed from specification
XBUS2020SOC1.1.22023-01-10Valid entry labels updated for 1224, 2161, 2232, 2233, 2234, 2235, 2236, 2237, 2316, 2472, 2491, 2492 and 3554 inline with the latest release of the SOC2020 framework by ONS
XEMP2020SOC1.1.22023-01-10Valid entry labels updated for 1224, 2161, 2232, 2233, 2234, 2235, 2236, 2237, 2316, 2472, 2491, 2492 and 3554 inline with the latest release of the SOC2020 framework by ONS
XWRK2020SOC1.1.22023-01-10Valid entry labels updated for 1224, 2161, 2232, 2233, 2234, 2235, 2236, 2237, 2316, 2472, 2491, 2492 and 3554 inline with the latest release of the SOC2020 framework by ONS
ZBUSAREA1.1.42022-11-03Technical specification updated to reflect changes to the data populated to BUSEMPCITY, which is now returned as a value from a drop down list presented to the survey respondant
ZEMPAREA1.1.42022-11-03Technical specification updated to reflect changes to the data populated to EMPCITY, which is now returned as a value from a drop down list presented to the survey respondant
XACTIVITY2.1.12022-07-01CONSTART (and corresponding codes 10 and 11) removed from specification as CONSTART data is no longer collected
XBUSLOCGR2.1.12022-07-01Depend upon fields updated from ZBUSCOUNTRY to BUSEMPCOUNTRY and derivation based on BUSEMPPLOC 06 added
XBUSLOCUC2.1.12022-07-01Depend upon fields updated from ZBUSCOUNTRY to BUSEMPCOUNTRY and derivation based on BUSEMPPLOC 06 added
XEMPLOCGR2.1.12022-07-01Depend upon fields updated from ZEMPCOUNTRY to EMPCOUNTRY and derivation based on EMPPLOC 06 added
XEMPLOCUC2.1.12022-07-01Depend upon fields updated from ZEMPCOUNTRY to EMPCOUNTRY and derivation based on EMPPLOC 06 added
XHOMELOCGR2.1.12022-07-01Depend upon field updated from ZHOMECOUNTRY to HOMECOUNTRY
XHOMELOCUC2.1.12022-07-01Depend upon field updated from ZHOMECOUNTRY to HOMECOUNTRY
XSTULOCGR3.1.12022-07-01Depend upon fields updated from ZSTUCOUNTRY to STUCOUNTRY and from ZSTUPROV to UCNAME, specification updated accordingly
XSTULOCUC3.1.12022-07-01Depend upon fields updated from ZSTUCOUNTRY to STUCOUNTRY and from ZSTUPROV to UCNAME, specification updated accordingly
XWRKJOBRSN2.1.12022-07-01References to JOBRSNALL and BUSJOBRSNALL removed from specification. JOBRSNALL and BUSJOBRSNALL data is no longer collected
XBUS2020SOC1.1.12022-03-11Valid entry label updated to match SOC2020 revision 5 for code 2252 ('Ophthalmic opticians' updated to 'Optometrists') and code 3557 ('Conference and exhibition managers and organisers' updated to 'Events managers and organisers'
XEMP2020SOC1.1.12022-03-11Valid entry label updated to match SOC2020 revision 5 for code 2252 ('Ophthalmic opticians' updated to 'Optometrists') and code 3557 ('Conference and exhibition managers and organisers' updated to 'Events managers and organisers'
XWRK2020SOC1.1.12022-03-11Valid entry label updated to match SOC2020 revision 5 for code 2252 ('Ophthalmic opticians' updated to 'Optometrists') and code 3557 ('Conference and exhibition managers and organisers' updated to 'Events managers and organisers'
XHOMELOCN1.1.12022-03-10Reference to English regions removed from technical specification, included in error from 17072 collection
XSTULOCGR2.0.02021-11-01Additional fields (D_Country.CountryCode, D_Country.GeographicGroupCode and Reference.T000_INSTHQPC.F_XSTULOCGR) upon which the updated specification for XSTULOCGR depends added to list of 'depends upon' fields. Technical specification updated. Valid entries updated to match new specification. XMLOCGR removed as a dependent field
XSTULOCUC2.0.02021-11-01Additional fields (D_Country.CountryCode, D_Country.GeographicGroupCode, Reference.T000_INSTHQPC.F_XDOMUC01) upon which the updated specification for XSTULOCUC depends added to list of 'depends upon' fields. Technical specification updated. Valid entries updated to match new specification. XMLOCUC removed as a dependent field
XBUSLOCGR1.1.32021-10-13XMLOCGR removed as a dependent field
XBUSLOCUC1.1.32021-10-13XMLOCUC removed as a dependent field
XEMPLOCGR1.1.32021-10-13XMLOCGR removed as a dependent field
XEMPLOCUC1.1.32021-10-13XMLOCUC removed as a dependent field
XHOMELOCGR1.1.12021-10-13XMLOCGR removed as a dependent field
XHOMELOCN1.1.12021-10-13XMLOCN removed as a dependent field
XHOMELOCUC1.1.12021-10-13XMLOCUC removed as a dependent field
XSTULOCN1.1.12021-10-13XMLOCN removed as a dependent field
ZBUSSICSOCKEY1.1.12021-10-13ZMSICSOCKEY removed as a dependent field
ZEMPSICSOCKEY1.1.12021-10-10ZMSICSOCKEY removed as a dependent field
XBUSLOCGR1.1.32021-06-14Additional details for a second level of refinement of the derived data has been added to the technical specification
XBUSLOCUC1.1.32021-06-14Valid entries C837 "Bournemouth" and C836 "Poole" have been removed and replaced by C838 "Bournemouth, Poole and Christchurch". Additional details for a second level of refinement of the derived data has been added to the technical specification
XEMPLOCGR1.1.32021-06-14Additional details for a second level of refinement of the derived data has been added to the technical specification
XEMPLOCUC1.1.32021-06-14Valid entries C837 "Bournemouth" and C836 "Poole" have been removed and replaced by C838 "Bournemouth, Poole and Christchurch". Additional details for a second level of refinement of the derived data has been added to the technical specification
XWRKLOCUC1.1.22021-06-14Valid entries C837 - Bournemouth and C836 - Poole have been removed and replaced by C838 - Bournemouth, Poole and Christchurch
XWRKHSKILL1.1.22021-04-07Specification updated to derive data using a simplified method
XBUS2007SIC11.1.22021-02-10Labels updated to match revisions by ONS
XBUS2007SIC21.1.22021-02-10Labels updated to match revisions by ONS
XEMP2007SIC11.1.22021-02-10Labels updated to match revisions by ONS
XEMP2007SIC21.1.22021-02-10Labels updated to match revisions by ONS
XWRK2007SIC11.1.22021-02-10Labels updated to match revisions by ONS
XWRK2007SIC21.1.22021-02-10Labels updated to match revisions by ONS
XBUS2007SIC1.1.22021-02-09Labels updated to match revisions by ONS
XEMP2007SIC1.1.22021-02-09Labels updated to match revisions by ONS
XWRK2007SIC1.1.22021-02-09Labels updated to match revisions by ONS
XACTMEAN1.1.12020-12-01Created
XACTONTRACK1.1.12020-12-01Created
XACTSKILLS1.1.12020-12-01Created
XBUS2020SOC1.1.12020-12-01Created
XBUS2020SOC11.1.12020-12-01Created
XBUS2020SOC31.1.12020-12-01Created
XBUSCOMPFUND1.1.12020-12-01Created
XBUSMARKER1.1.12020-12-01Created
XEMP2020SOC1.1.12020-12-01Created
XEMP2020SOC11.1.12020-12-01Created
XEMP2020SOC31.1.12020-12-01Created
XINTSTUDY1.1.12020-12-01Created
XWRK2007SIC1.1.12020-12-01Created
XWRK2007SIC11.1.12020-12-01Created
XWRK2007SIC21.1.12020-12-01Created
XWRK2020SOC1.1.12020-12-01Created
XWRK2020SOC11.1.12020-12-01Created
XWRK2020SOC31.1.12020-12-01Created
XWRKHSKILL1.1.12020-12-01Created
XWRKINTENSITY1.1.12020-12-01Created
XWRKJOBRSN1.1.12020-12-01Created
XWRKLOCGR1.1.12020-12-01Created
XWRKLOCN1.1.12020-12-01Created
XWRKLOCUC1.1.12020-12-01Created
ZNOEMPBAND1.1.12020-06-11Created
XACTIVITY1.1.22020-04-30SURVEYSTATUS removed as depend upon field and ZRESPSTATUS added as dependent field
ZRESPSTATUS1.1.22020-04-30Code 01 removed and Depend upon fields changed from XACTIV03 to XACTIVITY
XBUSLOCGR1.1.22020-03-18Copyright information added
XBUSLOCN1.1.22020-03-18Copyright information added
XBUSLOCUC1.1.22020-03-18Copyright information added
XEMPLOCGR1.1.22020-03-18Copyright information added
XEMPLOCN1.1.22020-03-18Copyright information added
XEMPLOCUC1.1.22020-03-18Copyright information added
ZBUSAREA1.1.32020-03-18Copyright information added
ZBUSPCODE1.1.22020-03-18Copyright information added
ZEMPAREA1.1.32020-03-18Copyright information added
ZEMPPCODE1.1.22020-03-18Copyright information added
XACTIVITY1.1.12020-02-20Created
XANXYESTGRP1.1.12020-02-14Field Created
XHAPYESTGRP1.1.12020-02-14Field Created
XLIFEWORTHGRP1.1.12020-02-14Field Created
XSATLIFEGRP1.1.12020-02-14Field Created
XHOMELOCUC1.1.12020-01-30Field created
XSTULOCUC1.1.12020-01-30Field created
ZRESPSTATUS1.1.12020-01-30Field Created
XWEIGHT011.1.12020-01-21First creation of field
ZBUSSICSOCKEY1.1.12019-12-18Created
ZEMPSICSOCKEY1.1.12019-12-18Created
XSTULOCGR1.1.12019-10-27Created
XBUS2007SIC1.1.12019-10-23Created
XBUS2007SIC11.1.12019-10-23Created
XBUS2007SIC21.1.12019-10-23Created
XEMP2007SIC1.1.12019-10-23Created
XEMP2007SIC11.1.12019-10-23Created
XSTULOCN1.1.12019-10-23Created
XHOMELOCGR1.1.12019-10-15Created
XHOMELOCN1.1.12019-10-15Created
XEMP2007SIC21.1.12010-10-23Created

Need help?

Contact Liaison by email or on +44 (0)1242 388 531.