DATA SOURCES IN LIRDATA SETSDATA SOURCESAverage hourly wages for up to 480 occupations in over 85 metropolitan and nonmetropolitan localitiesWeekly and annual earnings and hours for full-time workersEarnings by work level that permit wage comparisons across occupational groupsData presented at three levels: Localities, broad regions, and the NationWorkers are shown as a total (All workers) and broken out by Private industry and State and local governmentWage data are shown by industry, occupational group, full-time and part-time status, union and nonunion status, establishment size, time and incentive status, and job level.(3) Compensation Cost Trends:Employment Cost Index (ECI)Employer Costs for Employee Compensation (ECEC)NCS Survey MethodologyCoverageSource of DataUsesData availableCoverageSources of dataUsesDataCoverageData sourceUsesLIR 832 - LIR Data Sources DATA SOURCES IN LIR A look at data sources that can be used to study the compensation, unionization, and many aspects of the employment relationship. DATA SETS • National Compensation Survey o Wages o Benefits o Compensation Cost Trends • ECI • ECEC • Current Population Survey o Unicon Research DATA SOURCES • Bureau of the Census o Economic Census • Bureau of Labor Statistics o Employment, Hours and Earnings o Occupational Outlook Handbook o Consumer Price Index (CPI) o Producer Price Index (PPI) o Handbook of Methods 1LIR 832 - LIR Data Sources NATIONAL COMPENSATION SURVEY http://www.bls.gov/ncs/home.htm The National Compensation Survey (NCS) provides comprehensive measures of occupational earnings; compensation cost trends, benefit incidence, and detailed plan provisions. Detailed occupational earnings are available for metropolitan and non-metropolitan areas, broad geographic regions, and on a national basis. The index component of the NCS (ECI) measures changes in labor costs. Average hourly employer cost for employee compensation is presented in the ECEC. 2LIR 832 - LIR Data Sources (1) Wages • Average hourly wages for up to 480 occupations in over 85 metropolitan and nonmetropolitan localities • Weekly and annual earnings and hours for full-time workers • Earnings by work level that permit wage comparisons across occupational groups • Data presented at three levels: Localities, broad regions, and the Nation • Workers are shown as a total (All workers) and broken out by Private industry and State and local government • Wage data are shown by industry, occupational group, full-time and part-time status, union and nonunion status, establishment size, time and incentive status, and job level. To Locate A Wage for a Given Occupation / Location / Work Level: In the NCS web site, http://www.bls.gov/ncs/home.htm, hit “Wages (NCS)” under the heading of “Create Customized Tables (one screen)”. The following should appear: 3LIR 832 - LIR Data Sources Using this screen, we can select the occupation / location combination we are interested in. For example, let’s look at the wage of labor relations specialists in the Detroit area: RESULTS: Area Occupation Level DataSource Year Period Hourly Rate Detroit-Ann Arbor-Flint, MI Personnel, training, and labor relations specialists Overall Published 1998 Mar $24.07 Detroit-Ann Arbor-Flint, MI Personnel, training, and labor relations specialists Overall Published 1998 Jul $23.89 Detroit-Ann Arbor-Flint, MI Personnel, training, and labor relations specialists Overall Published 1999 Aug $24.24 Detroit-Ann Arbor-Flint, MI Personnel, training, and labor relations specialists Overall Published 2000 Apr $24.69 Detroit-Ann Arbor-Flint, MI Personnel, training, and labor relations specialists Overall Published 2001 Apr $21.91 Detroit-Ann Arbor-Flint, MI Personnel, training, and labor relations specialists Overall Published 2002 Apr $24.66 4LIR 832 - LIR Data Sources WORK LEVELS: Instead of just looking at the wages of an overall occupation, the NCS is ground-breaking in that it allows you to analyze the wages within an occupation according to work levels. Work levels measure the difficulty / importance of a job, as one can compare entry-level wages for an occupation and that of journeymen or supervisors. Work levels take into account nine criteria: knowledge, supervision received, guidelines, complexity, scope and effect, personal contacts, purpose of contacts, physical demands, and work environment. To calculate the work level you are interested in, different point totals are allotted to each mark on the scale for each criteria. To see an example, suppose we were interested in the wages of HR managers in the Chicago area (those fresh out of MSU LIR, e.g.). Off the top of our head, we do not know the necessary work level, so going back to our query screen from before, we can select “Get help choosing a Work Level”, which will kick us into the following screen: From here, we can select the choices that best fit the job we are interested in, as our selections may look like the following: 5LIR 832 - LIR Data Sources Thus, according to our calculations, we have found that these HR manager positions are at Work Level 8. So, going “back” to our query screen, we select our occupation / location / work level combination and hit “Get Data”: 6LIR 832 - LIR Data Sources What results is the following: Area Occupation Level DataSource Year Period Hourly Rate Factors Chicago-Gary-Kenosha, IL-IN-WI Personnel and labor relations managers Level 08 Modeled 2002 Jul $27.38 F1=6;F2=2;F3=3; F4=3;F5=3;F6=2; F7=3;F8=1;F9=1 We could also look at the highest level of labor relations managers in the Chicago area: Area Occupation Level DataSource Year Period Hourly Rate Factors Chicago-Gary-Kenosha, IL-IN-WI Personnel and labor relations managers Level 13 Modeled 2002 Jul $59.50 Typical Factors F1=8;F2=4;F3=4; F4=5;F5=5;F6=3; F7=3;F8=1;F9=1; You can look at similar combinations for all 480 occupations. 7LIR 832 - LIR Data Sources (2) Benefits The National Compensation Survey (NCS) covers the incidence and detailed provisions of selected employee benefit plans in small private establishments, medium and large private establishments, and state and local governments. The data are presented as the percent of employees who have access to or participate in certain benefits, or as average benefit provisions (for example, the average number of paid holidays provided to employees each