Wyoming

1
Wyomings Labor Exchange (Wyoming at Work )
Utilization Analysis Presented toThe Wyoming
Workforce Development CouncilCheyenne,
WY02/09/2011 Presented byWilliam (Tony)
GloverWyoming Department of EmploymentResearch
Planningwilliam.glover_at_state.wy.us
2

• Executive Summary
• In 2009
• 13.9 of employers with New Hires hired at least
  1 individual that browsed a job on W_at_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_at_W
• Employers in the Public Administration and
  Educational Services industries are more likely
  to have hired at least 1 employee that browsed
  W_at_W but the Manufacturing industry has the
  highest percent of New Hires that browsed W_at_W.

3
This is what Wyoming at Work looks like to
employers, job seekers, and other end users.
4
This is what Wyoming at Work looks like to
Programmers and Analysts.
5

• 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

6
Data Validation Comparison of Active Job Orders
to Average Quarterly Employment.
7

• 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.

8

• Tables used for this analysis from Research
  Plannings 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.

9

• Linking Wyoming at Work to Research Plannings
  databases part 1
• Individuals - Both W_at_W and RPs administrative
  databases are SSN based. Therefore linking
  jobseekers from W_at_W to persons employed in RPs
  data was relatively easy.
• Employers RPs qcew data captures employers
  unemployment insurance account number (UI), as
  well as, a Federal Employer Identification Number
  (FEIN). RPs wage data is captured at the UI
  level. W_at_Ws emp data captures FEIDs on 72 and
  UI on 47 of the employers records.

10

• Linking Wyoming at Work to Research Plannings
  databases part 2
• RP staff created a lookup table that
  crosswalks the employers username to a valid UI
  account number. The results are below.

11
The Nuts Bolts, Pieces Parts, etc extracted
from Wyoming at Work Database. Data from the W_at_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 Number of Browses Number of
distinct dates on which the individual browsed or
requested a job order.
12
The Nuts Bolts extracted from Research
Plannings Databases. Data from the RPs
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 Employers industry Size Class
Employers size class based on number of employees
13
The Working Table from combined W_at_W and Research
Plannings Databases.
SSN UI HIRED BROWSED QTRS RETAINED
999-99-9999 23A 2007Q3 0
999-99-9999 92A 2007Q4 2007Q3 8
999-99-9999 23B 2008Q1 2
999-99-9999 23C 2008Q3 0
999-99-9999 81C 2008Q3 0
999-99-9999 21A 2008Q3 1
14
The Working Table Quarters in which the
individual Browsed or Requested in W_at_W.
SSN UI HIRED BROWSED QTRS RETAINED
999-99-9999 23A 2007Q3 0
999-99-9999 92A 2007Q4 2007Q3 8
999-99-9999 23B 2008Q1 2
999-99-9999 23C 2008Q3 0
999-99-9999 81C 2008Q3 0
999-99-9999 21A 2008Q3 1
15
The Working Table Quarters in which the
individual was a New Hire.
SSN UI HIRED BROWSED QTRS RETAINED
999-99-9999 23A 2007Q3 0
999-99-9999 92A 2007Q4 2007Q3 8
999-99-9999 23B 2008Q1 2
999-99-9999 23C 2008Q3 0
999-99-9999 81C 2008Q3 0
999-99-9999 21A 2008Q3 1
16
The Working Table New Hire event where the
individual Browsed employer posting in W_at_W.
SSN UI HIRED BROWSED QTRS RETAINED
999-99-9999 23A 2007Q3 0
999-99-9999 92A 2007Q4 2007Q3 8
999-99-9999 23B 2008Q1 2
999-99-9999 23C 2008Q3 0
999-99-9999 81C 2008Q3 0
999-99-9999 21A 2008Q3 1
17
Results From 2007 to 2010 the percent of New
Hires that Browsed a job on W_at_W runs 5.0 7.0
percent.
18
(No Transcript)
19
(No Transcript)
20
(No Transcript)
21
(No Transcript)
22
(No Transcript)
23
Hypothetically In the top right corner 100 of
the employers would use W_at_W for 100 of their New
Hires.
24
Future Research Suggestions Recall that the
analysis is built from the SSN UI Account level
SSN UI HIRED BROWSED QTRS RETAINED
999-99-9999 23A 2007Q3 0
999-99-9999 92A 2007Q4 2007Q3 8
999-99-9999 23B 2008Q1 2
999-99-9999 23C 2008Q3 0
999-99-9999 81C 2008Q3 0
999-99-9999 21A 2008Q3 1
25

• 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

26

• 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