Occupational Projections and Training Data (OPTD) Files Developed and Distributed by the National Crosswalk Service Center January, 2010 The OPTD0818.ZIP files contains the OPTD data in three file formats: FoxPro (.dbf), MS Access (.MDB) and Excel (.XLS). Record layout: Field Description occcode 2008 national employment matrix code occtype Occupation Type (Summary or Line item) title 2008 national employment matrix title empl2008 2008 estimated employment (thousands) empl2018 2018 projected employment (thousands) empchg 2008-18 projected employment numeric change (thousands) pctchg 2008-18 projected employment percentage change self 2008 percentage of total in self employment growth 2008-18 openings due to growth (thousands) netr 2008-18 average annual job openings due to net replacement needs (thousands) grownetr 2008-18 average annual job openings due to growth and net replacement needs (thousands) medearn 2008 median annual earnings earnqart 2008 median annual earnings quartile rank (see below) edlevel Most significant source of education or training hs Percentage of workers with High school or less sc Percentage of workers with Some college col Percentage of workers with Bachelor's or higher degree lths Percentage of workers with Less than a high school degree highschool Percentage of workers with High school diploma or equivalent somecol Percentage of workers with Some college, no degree assoc Percentage of workers with Associate's degree bach Percentage of workers with Bachelor's degree master Percentage of workers with Master's degree doc Percentage of workers with Doctoral or professional degree ________________ NOTES: 1. Contents of this file were taken from several worksheets found in the file ftp://ftp.bls.gov/pub/special.requests/ep/ind-occ.matrix/Occupation.xls 2. Variables hs, sc and col contain a summarized version of the more detailed information found in lths, highschool, somecol, assoc, bach, master and doc.