What are Wage Records?

1. What are Wage Records? Wage records are an administrative database used to calculate Unemployment Insurance benefits for employees who have been laid-off through no fault of their own.

2. What type of Information is on the Wage Record Social Security Number Year & Quarter Wages Earned for the Quarter Employee Name Employer Code

3. Linking Administrative Data 202 File Industry code Geo code Employer # Soc Sec Adm SSN Age Gender UI File SSN Wages Year / Qtr Employer #

4. Wage Records to Labor Market Dynamics Possible Indicators Wage Distribution by Industry Turnover Rates Multiple Job Holdings New Hires Separations Recalls

5. Possible Administrative Records for Linking Driver’s License Military Educational Institutions Social Security Administration Census Bureau State Tax files Government Program Participants

6. Benefits of Wage Record Research Wage records are a fluid measure – not a snapshot Longitudinal studies (over time or across variables) Less expensive and more efficient than conventional surveys Wide Capabilities – Able to answer a wide range of questions Program evaluation would be the primary purpose It’s not an estimate – it is a tangible collected data

7. Texas Wage Records 11 million records generated per quarter Data from 1st quarter 1995 Files are housed locally SSN UI account # Name Quarterly wages Year Quarter

8. Turning Data Into Information Wage Records are a tool. We can apply the measures to many research questions. What are the questions our customers are asking.

9. New Economic Indicators Stability Measures Measure Worker Flows Turnover Ratios

10. Longitudinal Wage Record Uses Program Performance - ability to objectively evaluate the performance of Federal and State initiatives. Worker Cohort Analysis - ability to track work experiences and outcomes for identified subgroups. Economic Indicator Tabulations - standard quarterly reports on profiled economic conditions.

13. The Local Employment Dynamics Program

14. The Nature of the Partnership • Census - LED • Microdata matching experience • Address sanitization and geocoding experience • Industry coding experience • Massive computer resources • Data infrastructure - demographic and economic • Numident information • Survey data • Census data • Administrative data • Controlled environment - data security • Data dissemination and data access • Cornell site • Census Bureau HQ

15. The Nature of the Partnership • States • Data collection and editing resources • ES-202 files • Unemployment insurance files • Expert knowledge of state and local data • Expert knowledge of state and local conditions • Understand state and local clients

16. Demographic Surveys Link RecordPerson-ID Employer-IDData Economic Censuses and SurveysCensus Entity-ID Data Household RecordHousehold-IDData Person Record Household-IDPerson-IDData Business RegisterEmployer-IDCensus Entity-IDData The Local Employment Dynamics Program

17. Data • Census data provides city and country of birth • Other basic demographic characteristics such as Race / Ethnicity also available • Numident linked by SSN with State UI data at Bureau of the Census • Sample includes individuals employed at a UI covered firm in the state • Virtually complete work history and earnings • Census Bureau and State data on employers. • Location, industry, firm size, sales, etc.

18. Numident Other Census Data (CPS, SIPP, ACS) LEHD ARRS State Individual Master File Global Individual Master File SSN Wage Record Data Wage Record Data PIK State Work History File Global Work HistoryFile Employer Data (ES202, etc.) Employer Data (ES202, etc.) State Employer Master File Global Employer Master File Other Census Data (Business Censuses/Surveys) Overall Employment Dynamics Estimates Design Numident

19. Baseline Products:Summary Quarterly Tables • By age and sex of worker • By industry and geographic area • By place of work and place of residence

20. How these can be used: Labor Market Information Who has the jobs? Where is the job growth? Where is the job loss? Who’s getting hired? Who makes what?

21. What else can be done? • Different age/sex categories • Trends over time • Industry Analysis • Temporary Help • High technology • County Analysis • Cross state migration • Additional demographic and business information

22. Current New Current New Jobs Total payrollGross job gainGross job lossNet jobsNew hiresRecalls Layoffs/quits Individual earnings National State County Sub-county Workforce investment area National State County JobsTotal payroll New New Current Workplace Residence Male Female Age categories 14-18 19-21 22-24 25-34 35-44 45-54 55-64 65+ ImmigrantNative born Workplace Current None Clients Questions Businesses Economic development agencies Chambers of commerce Federal, state and local agencies Where are the workers? How much are they paid? Indicators Workforce Investment Boards Chambers of commerce School career counselors Job search professionals Businesses Federal, state, and local agencies Geography Where are the jobs? How much do they pay? Who needs training? Demography Location How can workers get to their jobs? Where should a business locate? Businesses Transportation planners Federal, state and local agencies

31. What Industries are creating the most jobs?