Section III: Creation of Yearly Files

In the process of tracking labor market behaviors such as multiple job holding (i.e., when an individual simultaneously works two or more jobs), R&P decided that quarterly files alone were inadequate, because the time frame within the quarter a job was worked is unknown. A year-based file was created to aid this tracking process (See Appendix C for more extensive information on Multiple Job Holding). R&P developed a new file structure and procedures for populating that structure with data. R&P personal created several programs that systematically reproduce the population process. The following basic steps describe the process of populating these yearly files (some steps are processed basically at the same time during the execution of these programs):

• Compile the SSNs in the four quarterly files into a list of unique SSNs for the year.
• Sum all wages earned in the year by SSN to total_wa.
• Calculate the number of employers worked for in the year by SSN to count_em.
• Calculate the number of quarters worked for each SSN to quarters.
• Calculate the primary employer (employer of most wages) for the year by SSN to pri_emp.
• Calculate wages earned from primary employer by SSN to pri_wage.
• Calculate secondary employer (employer of second highest wages) for the year by SSN to sec_emp.
• Calculate wages earned for secondary employer by SSN to sec_wage.
• Calculate the quintile distribution based on total_wa and assign a quintile to each SSN.
• Compile the QUI (Quarterly Unemployment Insurance, ES-202) database by year.
• Match the compiled QUI with the yearly file based on the UI tax number of both the primary and secondary employers. This adds the employer-based information to the file (Ownership, Industry, Employment Size and County of physical location). Ownership is government or private (government is divided into three groups, local, state and federal).
• Create a demographic file by compiling all available administrative databases.
• Match the demographic file with the yearly file on SSN. This adds Date of Birth and Gender to most of the records. Race, education level and place of residence may be added to this file in the future.
• An individual's age as of December 31 of that year is then calculated from the Date of Birth.
• An individual's attachment to the labor market is calculated by a process that uses the four quarters of the reference year, the fourth quarter previous year and the first quarter of the following year when needed (see Appendix C Part B pg. C-4 for examples of criteria for inclusion in an attachment category).
• This attachment variable is then added to the file by matching on SSN.

Part B of this section contains crosstabulations of economic and demographic variables for the years 1992 through 1998. They show the distribution and relationship of these variables to each other in Wyoming's labor market over this time period.

Part C of this section contains crosstabulations of the variable Attachment to the Labor Market by Primary Industry, Gender and (Current Population Survey) CPS Age Group for the years 1993 and 1998. They show how different age groups, genders and industries have chosen to interact with the labor market over time.

Part D of this section contains crosstabulations of Primary Industry by Secondary Industry for 1993 and 1998. They show what industries tend to employ individuals who work for more than one employer in a year and in what industry that second job tends to occur.