Wyoming’s Labor Exchange (Wyoming at Work ) Utilization Analysis

1. Wyoming’s 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@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@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.

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

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

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

11. 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 Number of Browses – Number of distinct dates on which the individual browsed or requested a job order.

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

13. The Working Table from combined W@W and Research & Planning’s Databases.

14. The Working Table – Quarters in which the individual Browsed or Requested in W@W.

15. The Working Table – Quarters in which the individual was a New Hire.

16. The Working Table – New Hire event where the individual Browsed employer posting in W@W.

17. Results – From 2007 to 2010 the percent of New Hires that Browsed a job on W@W runs 5.0 – 7.0 percent.

23. Hypothetically: In the top right corner 100% of the employers would use W@W for 100% of their New Hires.

24. Future Research Suggestions Recall that the analysis is built from the SSN & UI Account level

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