Transcript doe.state.wy.us

Wyoming’s Labor Exchange
(Wyoming at Work ) Utilization
Analysis
Presented to
The Wyoming Workforce Development
Council
Cheyenne, WY
02/09/2011
Presented by
William (Tony) Glover
Wyoming Department of Employment
Research & Planning
[email protected]
7/17/2015
1
Executive Summary
• In 2009
• 13.9% of employers with New Hires hired at least
1 individual that browsed a job on W@W.
• 6.1% of all New Hires browsed/requested
information on a job order placed by the employer
that would hire them.
• Larger employers are more likely to have hired
at least 1 New Hire that had browsed W@W
• Employers in the Public Administration and
Educational Services industries are more likely to
have hired at least 1 employee that browsed
W@W but the Manufacturing industry has the
highest percent of New Hires that browsed W@W.
7/17/2015
2
This is what Wyoming at Work looks like to
employers, job seekers, and other end users.
7/17/2015
3
This is what Wyoming at Work looks like to
Programmers and Analysts.
7/17/2015
4
The Wyoming at Work Database has;
• 1,208 User Tables
• 41 System Tables
• 12,081 Distinct Column Names (Fields)
• 3,399 Stored Procedures (Pre-written programs)
Of the 12,081 field names, many are used multiple
times in different tables with different meanings.
For example, username refers to the employers’
usernames in employer tables and username
refers to the clients’ usernames in job seeker
tables
7/17/2015
5
Data Validation; Comparison of Active Job Orders
to Average Quarterly Employment.
325,000
305,000
285,000
265,000
245,000
225,000
2002 2003 2004 2005 2006 2007 2008 2009 2010
Job Orders Active
7/17/2015
Average Employment
6
Average Quarterly
Employment
13,000
12,000
11,000
10,000
9,000
8,000
7,000
6,000
5,000
4,000
3,000
1
2
3
4
1
2
3
4
1
2
3
4
1
2
3
4
1
2
3
4
1
2
3
4
1
2
3
4
1
2
3
4
1
2
3
Active Job Orders
Number of Active Job Orders in W@W and Average
Quarterly Employment form QCEW
Tables used for this analysis from the
Wyoming at Work database;
• joborders – Information pertaining to the job
order posted for recruitment.
• emp – Information about the employers.
• ind – Information about the job seekers.
• joborderstracker – Records a transaction
each time a jobseeker requests contact
information on a job order.
• indjobsfolder – Records a transaction each
time a job seeker browses a job order.
7/17/2015
7
Tables used for this analysis from Research &
Planning’s databases;
• wr_base – Contains a record for each
individual employed in Wyoming by year, qtr,
and employer.
• qcew – Contains a record for each employer
paying wages in Wyoming by year and quarter.
It also includes data that describes the
employer such as industry, ownership, size,
etc.
• lookup_tables – NAICS and SOC.
7/17/2015
8
Linking Wyoming at Work to Research &
Planning’s databases – part 1;
• Individuals - Both W@W and R&P’s
administrative databases are SSN based.
Therefore linking jobseekers from W@W to
persons employed in R&P’s data was relatively
easy.
• Employers – R&P’s qcew data captures
employers’ unemployment insurance account
number (UI), as well as, a Federal Employer
Identification Number (FEIN). R&P’s wage data
is captured at the UI level. W@W’s emp data
captures FEIDs on 72% and UI on 47% of the
employers records.
7/17/2015
9
Linking Wyoming at Work to Research &
Planning’s databases – part 2;
• R&P staff created a lookup table that
crosswalks the employers username to a valid
UI account number. The results are below.
Percent of Employer Usernames Successfully Matched to a
Unemployment Insurance Account Number
Non Matched
14%
Out of State
Address
4%
R&P Matched
82%
7/17/2015
10
The Nuts & Bolts, Pieces & Parts, etc extracted
from Wyoming at Work Database.
Data from the W@W database combined with
the UI account lookup table were combined to
create a table with the following data;
SSN – Social Security Number
UI – Employer UI Account
First Browse Date – Date job order was
requested or browsed
Highest Browse Status – Request for contact
info ranked higher than browse
7/17/2015
Number of Browses – Number of distinct dates
on which the individual browsed or requested
a job order.
11
The Nuts & Bolts extracted from Research &
Planning’s Databases.
Data from the R&P’s databases were combined
to create a table with the following data;
SSN – Social Security Number
UI – Employer UI Account
New Hire Quarter – First quarter that the SSN
occurred with the UI account
NAICS – Employer’s industry
Size Class – Employer’s size class based on
number of employees
7/17/2015
12
The Working Table from combined W@W and
Research & Planning’s Databases.
SSN
UI
HIRED
QTRS
BROWSED RETAINED
999-99-9999
23A
2007Q3
0
999-99-9999
92A 2007Q4
2007Q3
8
999-99-9999
23B 2008Q1
999-99-9999 23C
2
2008Q3
0
999-99-9999 81C 2008Q3
0
999-99-9999
1
7/17/2015
21A 2008Q3
13
The Working Table – Quarters in which the
individual Browsed or Requested in W@W.
SSN
UI
HIRED
QTRS
BROWSED RETAINED
999-99-9999
23A
2007Q3
0
999-99-9999
92A 2007Q4
2007Q3
8
999-99-9999
23B 2008Q1
999-99-9999 23C
2
2008Q3
0
999-99-9999 81C 2008Q3
0
999-99-9999
1
7/17/2015
21A 2008Q3
14
The Working Table – Quarters in which the
individual was a New Hire.
SSN
UI
HIRED
QTRS
BROWSED RETAINED
999-99-9999
23A
2007Q3
0
999-99-9999
92A 2007Q4
2007Q3
8
999-99-9999
23B 2008Q1
999-99-9999 23C
2
2008Q3
0
999-99-9999 81C 2008Q3
0
999-99-9999
1
7/17/2015
21A 2008Q3
15
The Working Table – New Hire event where the
individual Browsed employer posting in W@W.
SSN
UI
HIRED
QTRS
BROWSED RETAINED
999-99-9999
23A
2007Q3
0
999-99-9999
92A 2007Q4
2007Q3
8
999-99-9999
23B 2008Q1
999-99-9999 23C
2
2008Q3
0
999-99-9999 81C 2008Q3
0
999-99-9999
1
7/17/2015
21A 2008Q3
16
Results – From 2007 to 2010 the percent of
New Hires that Browsed a job on W@W runs
5.0 – 7.0 percent.
New Hires With & Without W@W Exposure
Number of New Hires
80,000
64,000
48,000
32,000
16,000
0
1
2
3
2007
4
1
2
3
2008
New Hires without W@W
7/17/2015
4
1
2
3
2009
4
1
2
2010
Newhires with W@W
17
3
Percent of Employers with at least 1 New Hire from W@W.
Em ployers w ith at
least 1 New Hire
associated w ith
W@W, 13.9%
Em ployers w ith no
New Hires
associated W@W,
86.1%
7/17/2015
18
Percent of New Hires in 2009 that are a result of a W@W
Contact.
New Hires
associated with
W@W, 6.1%
New Hires not
associated with
W@W, 93.9%
7/17/2015
19
Percent of Employers Within Industry with at least 1 New Hire
from W@W and Percent of all New Hires Within Industry that are
a result of W@W Contact.
01-Natural Rescources & Mining
02-Construction
03-Manufacturing
04-Wholesale, Transportation, & Utilities
05-Retail Trade
06-Inform ation
07-Financial Activities
08-Professional & Business Services
09-Educational Services
10-Health Care & Social Assistance
11-Leisure & Hospitality
12-Other Services
13-Public Adm inistration
14-Nonclassified Industry
Total
0
10
20
30
40
50
60
70
Percent of Employers with at least 1 New Hire from W@W
Percent of New Hires with W@W Contact
7/17/2015
20
80
90
100
Percent of Employers Within Employer Size Class with at least 1
New Hire from W@W and Percent of all New Hires Within
Employer Size Class that are a result of W@W Contact.
0001to0004
0005to0009
0010to0019
0020to0049
0050to0099
0100to0249
0250to0499
0500to0999
1000plus
Total
0
10
20
30
40
50
60
70
80
Percent of Employers with at least 1 New Hire from W@W
Percent of New Hires with W@W Contact
7/17/2015
21
90
100
Percent of all New Hires that browsed a job on W@W
Wyoming at Work Utilization Scatter Plot 2009
03-Manufacturing
13-Public Administration
12.0
08-Professional & Business
Services
10-Health Care & Social
Assistance
06-Information
8.0
09-Educational Services
04-Wholesale,
Transportation, & Utilities
07-Financial Activities
02-Construction
12-Other Services
Total
05-Retail Trade
01-Natural Rescources &
Mining
4.0
11-Leisure & Hospitality
14-Nonclassified Industry
0.0
0.0
6.0
12.0
18.0
24.0
Percent of Employers with at least One New Hire from W@W
7/17/2015
22
30.0
Wyoming at Work Utilization Scatter Plot 2009
Percent of all New Hires that browsed a job
on W@W
100.0
90.0
Hypothetically: In
the top right corner
100% of the
employers would
use W@W for 100%
of their New Hires.
80.0
70.0
60.0
50.0
40.0
30.0
20.0
10.0
Total
0.0
0.0
10.0
20.0
30.0
40.0
50.0
60.0
70.0
80.0
90.0
Percent of Employers with at least One New Hire from W@W
7/17/2015
23
100.0
Future Research Suggestions
Recall that the analysis is built from the SSN &
UI Account level
QTRS
SSN
UI
HIRED BROWSED RETAINED
999-99-9999
23A
2007Q3
0
999-99-9999
92A 2007Q4
2007Q3
8
999-99-9999
23B 2008Q1
999-99-9999 23C
2
2008Q3
0
999-99-9999 81C 2008Q3
0
999-99-9999
1
7/17/2015
21A 2008Q3
24
Future Research Suggestions
What we know about the individuals
• Age and Gender
• Where they live & Where they work
• Attachment to Wyoming
•Attachment to an industry
•Attachment to an employer
•Stability or instability as an employee
• Work History, Employment Retention, Wage
Progression
•Career Readiness Status, Unemployment
Insurance & Workers Compensation Claims
History and Status
7/17/2015
25
Future Research Suggestions
What we know about the employers
• Industry and Ownership
• Counties with Employment
• Employees attachment to the employer
• Stability of the employers employees
• Previous hiring and retention patterns
• Wage Competitiveness
7/17/2015
26