LMI For All

Documentation & Development

User Tools

Site Tools


Sidebar

Start Pages

Team Pages

Upcoming Events

Apr 24 Modding Day
data:format_employer_skills_survey

ESS Format

  • Submitted by:
  • Submitted on: 28/08/2013
  • Revision: 1
  • Status: To be revised by datateam
  • Revised by:
  • Revised on: ../../….

Filename

ESS_%createdate%_%sequence%_%dataset%.csv

with:

%createdate%creation date of the file yyyymmdd
%sequence%2 digit number
%dataset% value: region, region1dig, region2dig, region3dig, region4dig,
uk1dig, uk2dig, uk3dig, uk4dig, wfregion1dig, wfuk1dig, wfuk2dig, wfuk3dig, wfuk4dig

Columns & Rules

ESS data

column DB column description rules
nutsreg regionId 12 UK countries and English regions value 1-12
null: yes
C7_XDIGIT socValue 1,2,3 or 4 digit SOC value -1 to 9279
null: yes
wf75 industryId WF% dataset only, 75 standard industries value: 1-75
null: no
NUMVAC numvac Number of vacancies value: double-precision floating point
null: no
HTF htf Hard-to-fill vacancies value: double-precision floating point
null: no
SSV ssv Skill shortage vacancies value: double-precision floating point
null: no
unweight unweight Unweighted cell count numeric
null: no
weight weight Weighted cell count numeric
null: no
pchtf pchtf Percentage of vacancies hard to fill 0-100
null: no
pcssv pcssv Percentage of vacancies due to skills shortages 0-100
null :no
validcell validcell cell validity for publication 0-1
null: no

Sample

wf75,C7_2DIGIT,NUMVAC,HTF,SSV,unweight,weight,pchtf,pcssv,validcell 1,-1,101.324013317747,0,0,2,67.5493422118313,0,0,0 1,12,235.278997087167,177.638152016744,177.638152016744,3,177.638152016744,75.5010664853065,75.5010664853065,0 1,21,125.667846528178,69.7279404053933,69.7279404053933,3,72.2667729222832,55.4859037787032,55.4859037787032,0 1,23,46.625130644005,46.625130644005,46.625130644005,1,46.625130644005,100,100,0 1,31,3.84632346862045,0,0,1,3.84632346862045,0,0,0 1,35,107.1939262731,0,0,3,107.1939262731,0,0,0 1,41,444.178718421121,0,0,9,387.315046378077,0,0,0 1,42,86.2475706856243,0,0,2,86.2475706856243,0,0,0 1,51,1758.58197883477,556.034586144981,349.582577369963,14,1475.68295191864,31.6183489218631,19.8786625575224,0 1,52,128.06765690652,64.625479425749,64.625479425749,2,128.06765690652,50.461983132026,50.461983132026,0 1,53,66.00674700314,0,0,1,66.00674700314,0,0,0 1,54,164.353525579934,106.010459487264,106.010459487264,2,164.353525579934,64.5014818594233,64.5014818594233,0 1,61,969.18767295741,322.446229269401,322.446229269401,6,638.407665418366,33.2697410693925,33.2697410693925,0 1,71,184.433378699091,1.98360780200211,1.98360780200211,4,183.44157479809,1.07551453863372,1.07551453863372,0 1,72,132.623444525644,0,0,3,132.623444525644,0,0,0 1,81,115.748349124467,0,0,2,115.748349124467,0,0,0 1,82,1175.31044741098,513.017037074222,506.655179661732,13,900.066649022885,43.6494917750723,43.1082001166425,0 1,91,2770.77623070263,1249.91055361584,621.446289322908,28,2301.7391622818,45.1104834726721,22.4285989765878,0 1,92,1087.80973326112,624.574864470323,294.027596126378,5,841.280234862791,57.4158187202393,27.0293220529402,0

data/format_employer_skills_survey.txt · Last modified: 2013-08-28 15:43 by Rolandas Zikis Ziukevicius