LMI For All

Documentation & Development

User Tools

Site Tools


data:format_employer_skills_survey

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
data:format_employer_skills_survey [2013-08-28 15:03]
Rolandas Zikis Ziukevicius
data:format_employer_skills_survey [2013-08-28 15:43] (current)
Rolandas Zikis Ziukevicius
Line 22: Line 22:
  
 ^ column ^ DB column ^ description ^ rules ^ ^ column ^ DB column ^ description ^ rules ^
-region ​       ​| ​  |  |+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