Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
macupryk
Starting Member
9 Posts |
Posted - 2013-05-12 : 13:48:08
|
I need to setup the following in some table in sql.How should I setup my tables.<code>CREATE TABLE Career_Category(category_id char(2),category_title varchar(255))CREATE TABLE Career(career_id char(10),career_title varchar(255),category_id char(2))GO<script language="JavaScript" type="text/JavaScript"><!--var oCareersData = new Objectvar tmp1 = new Objecttmp1["category_title"] = "Management"var tmp2 = new Objecttmp2["11-1011.00"] = "Chief Executives"tmp2["11-1021.00"] = "General & Operations Managers"tmp2["11-1031.00"] = "Legislators"tmp2["11-2011.00"] = "Advertising & Promotions Managers"tmp2["11-2021.00"] = "Marketing Managers"tmp2["11-2022.00"] = "Sales Managers"tmp2["11-2031.00"] = "Public Relations Managers"tmp2["11-3011.00"] = "Administrative Services Managers"tmp2["11-3021.00"] = "Computer & Information Systems Managers"tmp2["11-3031.01"] = "Treasurers & Controllers"tmp2["11-3031.02"] = "Financial Managers, Branch or Department"tmp2["11-3040.00"] = "Human Resources Managers"tmp2["11-3041.00"] = "Compensation & Benefits Managers"tmp2["11-3042.00"] = "Training & Development Managers"tmp2["11-3049.99"] = "Human Resources Managers, Other"tmp2["11-3051.00"] = "Industrial Production Managers"tmp2["11-3061.00"] = "Purchasing Managers"tmp2["11-3071.01"] = "Transportation Managers"tmp2["11-3071.02"] = "Storage & Distribution Managers"tmp2["11-9011.01"] = "Nursery & Greenhouse Managers"tmp2["11-9011.02"] = "Crop & Livestock Managers"tmp2["11-9011.03"] = "Aquacultural Managers"tmp2["11-9012.00"] = "Farmers & Ranchers"tmp2["11-9021.00"] = "Construction Managers"tmp2["11-9031.00"] = "Education Administrators - Preschool & Child Care Centers"tmp2["11-9032.00"] = "Education Administrators - Elementary & High School"tmp2["11-9033.00"] = "Education Administrators - College"tmp2["11-9039.99"] = "Education Administrators, Other"tmp2["11-9041.00"] = "Engineering Managers"tmp2["11-9051.00"] = "Food Service Managers"tmp2["11-9061.00"] = "Funeral Directors"tmp2["11-9071.00"] = "Gaming Managers"tmp2["11-9081.00"] = "Lodging Managers"tmp2["11-9111.00"] = "Medical & Health Services Managers"tmp2["11-9121.00"] = "Natural Sciences Managers"tmp2["11-9131.00"] = "Postmasters & Mail Superintendents"tmp2["11-9141.00"] = "Property, Real Estate & Community Association Managers"tmp2["11-9151.00"] = "Social & Community Service Managers"tmp2["11-9199.99"] = "Managers, Other"tmp1["careers"] = tmp2tmp2 = nulloCareersData["11"] = tmp1tmp1 = nullvar tmp2 = new Objecttmp2["category_title"] = "Business & Financial Operations"var tmp3 = new Objecttmp3["13-1011.00"] = "Agents & Business Managers of Artists, Performers & Athletes"tmp3["13-1021.00"] = "Purchasing Agents & Buyers - Farm Products"tmp3["13-1022.00"] = "Wholesale & Retail Buyers"tmp3["13-1023.00"] = "Purchasing Agents"tmp3["13-1031.01"] = "Claims Examiners - Property & Casualty Insurance"tmp3["13-1031.02"] = "Insurance Adjusters - Examiners & Investigators"tmp3["13-1032.00"] = "Insurance Appraisers - Auto Damage"tmp3["13-1041.01"] = "Environmental Compliance Inspectors"tmp3["13-1041.02"] = "Licensing Examiners & Inspectors"tmp3["13-1041.03"] = "Equal Opportunity Representatives & Officers"tmp3["13-1041.04"] = "Government Property Inspectors & Investigators"tmp3["13-1041.06"] = "Coroners"tmp3["13-1051.00"] = "Cost Estimators"tmp3["13-1061.00"] = "Emergency Management Specialists"tmp3["13-1071.01"] = "Employment Interviewers"tmp3["13-1071.02"] = "Personnel Recruiters"tmp3["13-1072.00"] = "Compensation, Benefits & Job Analysis Specialists"tmp3["13-1073.00"] = "Training & Development Specialists"tmp3["13-1079.99"] = "Human Resource Specialists, Other"tmp3["13-1081.00"] = "Logisticians"tmp3["13-1111.00"] = "Management Analysts"tmp3["13-1121.00"] = "Meeting & Convention Planners"tmp3["13-1199.99"] = "Business Operations Specialists, Other"tmp3["13-2011.01"] = "Accountants"tmp3["13-2011.02"] = "Auditors"tmp3["13-2021.01"] = "Assessors"tmp3["13-2021.02"] = "Appraisers - Real Estate"tmp3["13-2031.00"] = "Budget Analysts"tmp3["13-2041.00"] = "Credit Analysts"tmp3["13-2051.00"] = "Financial Analysts"tmp3["13-2052.00"] = "Personal Financial Advisors"tmp3["13-2053.00"] = "Insurance Underwriters"tmp3["13-2061.00"] = "Financial Examiners"tmp3["13-2071.00"] = "Loan Counselors"tmp3["13-2072.00"] = "Loan Officers & Mortgage Brokers"tmp3["13-2081.00"] = "Tax Examiners, Collectors & Revenue Agents"tmp3["13-2082.00"] = "Tax Preparers"tmp3["13-2099.99"] = "Financial Specialists, Other"tmp2["careers"] = tmp3tmp3 = nulloCareersData["13"] = tmp2tmp2 = nullvar tmp3 = new Objecttmp3["category_title"] = "Computer & Mathematical"var tmp4 = new Objecttmp4["15-1011.00"] = "Computer & Information Scientists - Research"tmp4["15-1021.00"] = "Computer Programmers"tmp4["15-1031.00"] = "Computer Software Engineers - Applications"tmp4["15-1032.00"] = "Computer Software Engineers - Systems Software"tmp4["15-1041.00"] = "Computer Support Specialists"tmp4["15-1051.00"] = "Computer Systems Analysts"tmp4["15-1061.00"] = "Database Administrators"tmp4["15-1071.00"] = "Network & Computer Systems Administrators"tmp4["15-1071.01"] = "Computer Security Specialists"tmp4["15-1081.00"] = "Network Systems & Data Communications Analysts"tmp4["15-1099.01"] = "Software Quality Assurance Engineers & Testers"tmp4["15-1099.02"] = "Computer Systems Engineers/Architects"tmp4["15-1099.03"] = "Network Designers"tmp4["15-1099.04"] = "Web Developers"tmp4["15-1099.05"] = "Web Administrators"tmp4["15-1099.99"] = "Computer Specialists, Other"tmp4["15-2011.00"] = "Actuaries"tmp4["15-2021.00"] = "Mathematicians"tmp4["15-2031.00"] = "Operations Research Analysts"tmp4["15-2041.00"] = "Statisticians"tmp4["15-2091.00"] = "Mathematical Technicians"tmp4["15-2099.99"] = "Mathematical Science Occupations, Other"tmp3["careers"] = tmp4tmp4 = nulloCareersData["15"] = tmp3tmp3 = nullvar tmp4 = new Objecttmp4["category_title"] = "Engineering & Architecture"var tmp5 = new Objecttmp5["17-1011.00"] = "Architects"tmp5["17-1012.00"] = "Landscape Architects"tmp5["17-1021.00"] = "Cartographers & Photogrammetrists"tmp5["17-1022.00"] = "Surveyors"tmp5["17-2011.00"] = "Aerospace Engineers"tmp5["17-2021.00"] = "Agricultural Engineers"tmp5["17-2031.00"] = "Biomedical Engineers"tmp5["17-2041.00"] = "Chemical Engineers"tmp5["17-2051.00"] = "Civil Engineers"tmp5["17-2061.00"] = "Computer Hardware Engineers"tmp5["17-2071.00"] = "Electrical Engineers"tmp5["17-2072.00"] = "Electronics Engineers"tmp5["17-2081.00"] = "Environmental Engineers"tmp5["17-2111.01"] = "Industrial Safety & Health Engineers"tmp5["17-2111.02"] = "Fire-Prevention & Protection Engineers"tmp5["17-2111.03"] = "Product Safety Engineers"tmp5["17-2112.00"] = "Industrial Engineers"tmp5["17-2121.01"] = "Marine Engineers"tmp5["17-2121.02"] = "Marine Architects"tmp5["17-2131.00"] = "Materials Engineers"tmp5["17-2141.00"] = "Mechanical Engineers"tmp5["17-2151.00"] = "Mining & Geological Engineers"tmp5["17-2161.00"] = "Nuclear Engineers"tmp5["17-2171.00"] = "Petroleum Engineers"tmp5["17-2199.99"] = "Engineers, Other"tmp5["17-3011.01"] = "Architectural Drafters"tmp5["17-3011.02"] = "Civil Drafters"tmp5["17-3012.01"] = "Electronic Drafters"tmp5["17-3012.02"] = "Electrical Drafters"tmp5["17-3013.00"] = "Mechanical Drafters"tmp5["17-3019.99"] = "Drafters, Other"tmp5["17-3021.00"] = "Aerospace Engineering & Operations Technicians"tmp5["17-3022.00"] = "Civil Engineering Technicians"tmp5["17-3023.01"] = "Electronics Engineering Technicians"tmp5["17-3023.03"] = "Electrical Engineering Technicians"tmp5["17-3024.00"] = "Electro-Mechanical Technicians"tmp5["17-3025.00"] = "Environmental Engineering Technicians"tmp5["17-3026.00"] = "Industrial Engineering Technicians"tmp5["17-3027.00"] = "Mechanical Engineering Technicians"tmp5["17-3029.99"] = "Engineering Technicians, Other"tmp5["17-3031.01"] = "Surveying Technicians"tmp5["17-3031.02"] = "Mapping Technicians"tmp4["careers"] = tmp5tmp5 = nulloCareersData["17"] = tmp4tmp4 = nullvar tmp5 = new Objecttmp5["category_title"] = "Life, Physical, & Social Sciences"var tmp6 = new Objecttmp6["19-1011.00"] = "Animal Scientists"tmp6["19-1012.00"] = "Food Scientists & Technologists"tmp6["19-1013.00"] = "Soil & Plant Scientists"tmp6["19-1020.01"] = "Biologists"tmp6["19-1021.00"] = "Biochemists & Biophysicists"tmp6["19-1022.00"] = "Microbiologists"tmp6["19-1023.00"] = "Zoologists & Wildlife Biologists"tmp6["19-1029.99"] = "Biological Scientists, Other"tmp6["19-1031.01"] = "Soil & Water Conservationists"tmp6["19-1031.02"] = "Range Managers"tmp6["19-1031.03"] = "Park Naturalists"tmp6["19-1032.00"] = "Foresters"tmp6["19-1041.00"] = "Epidemiologists"tmp6["19-1042.00"] = "Medical Scientists"tmp6["19-1099.99"] = "Life Scientists, Other"tmp6["19-2011.00"] = "Astronomers"tmp6["19-2012.00"] = "Physicists"tmp6["19-2021.00"] = "Atmospheric & Space Scientists"tmp6["19-2031.00"] = "Chemists"tmp6["19-2032.00"] = "Materials Scientists"tmp6["19-2041.00"] = "Environmental Scientists & Specialists"tmp6["19-2042.00"] = "Geologists & Geoscientists"tmp6["19-2043.00"] = "Hydrologists"tmp6["19-2099.99"] = "Physical Scientists, Other"tmp6["19-3011.00"] = "Economists"tmp6["19-3021.00"] = "Market Research Analysts"tmp6["19-3022.00"] = "Survey Researchers"tmp6["19-3031.01"] = "School Psychologists"tmp6["19-3031.02"] = "Clinical Psychologists"tmp6["19-3031.03"] = "Counseling Psychologists"tmp6["19-3032.00"] = "Industrial-Organizational Psychologists"tmp6["19-3039.99"] = "Psychologists, Other"tmp6["19-3041.00"] = "Sociologists"tmp6["19-3051.00"] = "Urban & Regional Planners"tmp6["19-3091.01"] = "Anthropologists"tmp6["19-3091.02"] = "Archeologists"tmp6["19-3092.00"] = "Geographers"tmp6["19-3093.00"] = "Historians"tmp6["19-3094.00"] = "Political Scientists"tmp6["19-3099.99"] = "Social Scientists, Other"tmp6["19-4011.01"] = "Agricultural Technicians"tmp6["19-4011.02"] = "Food Science Technicians"tmp6["19-4021.00"] = "Biological Technicians"tmp6["19-4031.00"] = "Chemical Technicians"tmp6["19-4041.01"] = "Geophysical Data Technicians"tmp6["19-4041.02"] = "Geological Sample Test Technicians"tmp6["19-4051.01"] = "Nuclear Equipment Operation Technicians"tmp6["19-4051.02"] = "Nuclear Monitoring Technicians"tmp6["19-4061.00"] = "Social Science Research Assistants"tmp6["19-4061.01"] = "City Planning Aides"tmp6["19-4091.00"] = "Environmental Science & Protection Technicians"tmp6["19-4092.00"] = "Forensic Science Technicians"tmp6["19-4093.00"] = "Forest & Conservation Technicians"tmp6["19-4099.99"] = "Life, Physical & Social Science Technicians, Other"tmp5["careers"] = tmp6tmp6 = nulloCareersData["19"] = tmp5tmp5 = nullvar tmp6 = new Objecttmp6["category_title"] = "Counseling, Community & Social Services"var tmp7 = new Objecttmp7["21-1011.00"] = "Substance Abuse & Behavioral Disorder Counselors"tmp7["21-1012.00"] = "Educational, Vocational & School Counselors"tmp7["21-1013.00"] = "Marriage & Family Therapists"tmp7["21-1014.00"] = "Mental Health Counselors"tmp7["21-1015.00"] = "Rehabilitation Counselors"tmp7["21-1019.99"] = "Counselors, Other"tmp7["21-1021.00"] = "Child, Family & School Social Workers"tmp7["21-1022.00"] = "Medical & Public Health Social Workers"tmp7["21-1023.00"] = "Mental Health & Substance Abuse Social Workers"tmp7["21-1029.99"] = "Social Workers, Other"tmp7["21-1091.00"] = "Health Educators"tmp7["21-1092.00"] = "Probation Officers & Correctional Treatment Specialists"tmp7["21-1093.00"] = "Social & Human Service Assistants"tmp7["21-1099.99"] = "Community & Social Service Specialists, Other"tmp7["21-2011.00"] = "Clergy"tmp7["21-2021.00"] = "Directors - Religious Activities & Education"tmp7["21-2099.99"] = "Religious Workers, Other"tmp6["careers"] = tmp7tmp7 = nulloCareersData["21"] = tmp6tmp6 = nullvar tmp7 = new Objecttmp7["category_title"] = "Legal"var tmp8 = new Objecttmp8["23-1011.00"] = "Lawyers"tmp8["23-1021.00"] = "Administrative Law Judges, Adjudicators & Hearing Officers"tmp8["23-1022.00"] = "Arbitrators, Mediators & Conciliators"tmp8["23-1023.00"] = "Judges, Magistrate Judges & Magistrates"tmp8["23-2011.00"] = "Paralegals & Legal Assistants"tmp8["23-2091.00"] = "Court Reporters"tmp8["23-2092.00"] = "Law Clerks"tmp8["23-2093.00"] = "Title Examiners, Abstractors & Searchers"tmp8["23-2099.99"] = "Legal Support Workers, Other"tmp7["careers"] = tmp8tmp8 = nulloCareersData["23"] = tmp7tmp7 = nullvar tmp8 = new Objecttmp8["category_title"] = "Education, Training, & Library"var tmp9 = new Objecttmp9["25-1011.00"] = "College Professors - Business"tmp9["25-1021.00"] = "College Professors - Computer Science"tmp9["25-1022.00"] = "College Professors - Mathematical Science"tmp9["25-1031.00"] = "College Professors - Architecture"tmp9["25-1032.00"] = "College Professors - Engineering"tmp9["25-1041.00"] = "College Professors - Agricultural Sciences"tmp9["25-1042.00"] = "College Professors - Biological Science"tmp9["25-1043.00"] = "College Professors - Forestry & Conservation Science"tmp9["25-1051.00"] = "College Professors - Atmospheric, Earth, Marine, & Space Science"tmp9["25-1052.00"] = "College Professors - Chemistry"tmp9["25-1053.00"] = "College Professors - Environmental Science"tmp9["25-1054.00"] = "College Professors - Physics"tmp9["25-1061.00"] = "College Professors - Anthropology & Archeology"tmp9["25-1062.00"] = "College Professors - Area, Ethnic & Cultural Studies"tmp9["25-1063.00"] = "College Professors - Economics"tmp9["25-1064.00"] = "College Professors - Geography"tmp9["25-1065.00"] = "College Professors - Political Science"tmp9["25-1066.00"] = "College Professors - Psychology"tmp9["25-1067.00"] = "College Professors - Sociology"tmp9["25-1069.99"] = "College Professors - Other Social Sciences"tmp9["25-1071.00"] = "College Instructors - Medicine & Health Specialties"tmp9["25-1072.00"] = "College Instructors - Nursing"tmp9["25-1081.00"] = "College Instructors - Education"tmp9["25-1082.00"] = "College Instructors - Library Science"tmp9["25-1111.00"] = "College Instructors - Criminal Justice & Law Enforcement"tmp9["25-1112.00"] = "College Professors - Law"tmp9["25-1113.00"] = "College Instructors - Social Work"tmp9["25-1121.00"] = "College Professors - Art, Drama & Music Teachers"tmp9["25-1122.00"] = "College Professors - Communications"tmp9["25-1123.00"] = "College Professors - English Language & Literature"tmp9["25-1124.00"] = "College Professors - Foreign Language & Literature"tmp9["25-1125.00"] = "College Professors - History"tmp9["25-1126.00"] = "College Professors - Philosophy & Religion"tmp9["25-1191.00"] = "Graduate Teaching Assistants"tmp9["25-1192.00"] = "College Instructors - Home Economics"tmp9["25-1193.00"] = "College Instructors - Recreation & Fitness Studies"tmp9["25-1194.00"] = "College Instructors - Vocational Studies"tmp9["25-1199.99"] = "College Instructors - Other"tmp9["25-2011.00"] = "Preschool Teachers"tmp9["25-2012.00"] = "Kindergarten Teachers"tmp9["25-2021.00"] = "Elementary School Teachers"tmp9["25-2022.00"] = "Middle School Teachers"tmp9["25-2023.00"] = "Middle School Teachers - Vocational Studies"tmp9["25-2031.00"] = "High School Teachers"tmp9["25-2032.00"] = "High School Teachers - Vocational Studies"tmp9["25-2041.00"] = "Preschool & Elementary School Teachers - Special Education"tmp9["25-2042.00"] = "Middle School Teachers - Special Education"tmp9["25-2043.00"] = "High School Teachers - Special Education"tmp9["25-3011.00"] = "Adult Literacy, Remedial Education & GED Teachers"tmp9["25-3021.00"] = "Self-Enrichment Education Teachers"tmp9["25-3099.99"] = "Teachers & Instructors, Other"tmp9["25-4011.00"] = "Archivists"tmp9["25-4012.00"] = "Curators"tmp9["25-4013.00"] = "Museum Technicians & Conservators"tmp9["25-4021.00"] = "Librarians"tmp9["25-4031.00"] = "Library Technicians"tmp9["25-9011.00"] = "Audio-Visual Collections Specialists"tmp9["25-9021.00"] = "Farm & Home Management Advisors"tmp9["25-9031.00"] = "Instructional Coordinators"tmp9["25-9041.00"] = "Teaching Assistants"tmp9["25-9099.99"] = "Education, Training & Library Workers, Other"tmp8["careers"] = tmp9tmp9 = nulloCareersData["25"] = tmp8tmp8 = nullvar tmp9 = new Objecttmp9["category_title"] = "Arts, Design, Entertainment, Sports, & Media"var tmp10 = new Objecttmp10["27-1011.00"] = "Art Directors"tmp10["27-1012.00"] = "Craft Artists"tmp10["27-1013.00"] = "Fine Artists - Painters, Sculptors & Illustrators"tmp10["27-1014.00"] = "Multi-Media Artists & Animators"tmp10["27-1019.99"] = "Artists and Related Workers, Other"tmp10["27-1021.00"] = "Commercial & Industrial Designers"tmp10["27-1022.00"] = "Fashion Designers"tmp10["27-1023.00"] = "Floral Designers"tmp10["27-1024.00"] = "Graphic Designers"tmp10["27-1025.00"] = "Interior Designers"tmp10["27-1026.00"] = "Merchandise Displayers & Window Trimmers"tmp10["27-1027.00"] = "Set & Exhibit Designers"tmp10["27-1029.99"] = "Designers, Other"tmp10["27-2011.00"] = "Actors"tmp10["27-2012.01"] = "Producers"tmp10["27-2012.02"] = "Directors - Stage, Film, Television & Radio"tmp10["27-2012.03"] = "Program Directors"tmp10["27-2012.04"] = "Talent Directors"tmp10["27-2012.05"] = "Technical Directors & Production Managers"tmp10["27-2021.00"] = "Athletes & Sports Competitors"tmp10["27-2022.00"] = "Coaches & Scouts"tmp10["27-2023.00"] = "Umpires, Referees & Other Sports Officials"tmp10["27-2031.00"] = "Dancers"tmp10["27-2032.00"] = "Choreographers"tmp10["27-2041.01"] = "Music Directors"tmp10["27-2041.04"] = "Music Composers & Arrangers"tmp10["27-2042.01"] = "Singers"tmp10["27-2042.02"] = "Musicians"tmp10["27-2099.99"] = "Entertainment, Performance, or Sports Workers, Other"tmp10["27-3011.00"] = "Radio & Television Announcers"tmp10["27-3012.00"] = "Public Address System & Other Announcers"tmp10["27-3021.00"] = "Broadcast News Analysts"tmp10["27-3022.00"] = "Reporters & Correspondents"tmp10["27-3031.00"] = "Public Relations Specialists"tmp10["27-3041.00"] = "Editors"tmp10["27-3042.00"] = "Technical Writers"tmp10["27-3043.04"] = "Copy Writers"tmp10["27-3043.05"] = "Creative Writers - Authors, Poets & Lyricists"tmp10["27-3091.00"] = "Interpreters & Translators"tmp10["27-3099.99"] = "Media & Communication Workers, Other"tmp10["27-4011.00"] = "Audio & Video Equipment Technicians"tmp10["27-4012.00"] = "Broadcast Technicians"tmp10["27-4013.00"] = "Radio Operators"tmp10["27-4014.00"] = "Sound Engineering Technicians"tmp10["27-4021.00"] = "Photographers"tmp10["27-4031.00"] = "Camera Operators - Television, Video & Motion Picture"tmp10["27-4032.00"] = "Film & Video Editors"tmp10["27-4099.99"] = "Media & Communication Equipment Workers, Other"tmp9["careers"] = tmp10tmp10 = nulloCareersData["27"] = tmp9tmp9 = nullvar tmp10 = new Objecttmp10["category_title"] = "Healthcare Practitioners & Technical"var tmp11 = new Objecttmp11["29-1011.00"] = "Chiropractors"tmp11["29-1021.00"] = "Dentists - General"tmp11["29-1022.00"] = "Oral & Maxillofacial Surgeons"tmp11["29-1023.00"] = "Orthodontists"tmp11["29-1024.00"] = "Prosthodontists"tmp11["29-1029.99"] = "Dentists, Other Specialties"tmp11["29-1031.00"] = "Dietitians & Nutritionists"tmp11["29-1041.00"] = "Optometrists"tmp11["29-1051.00"] = "Pharmacists"tmp11["29-1061.00"] = "Anesthesiologists"tmp11["29-1062.00"] = "Family & General Practitioners"tmp11["29-1063.00"] = "Internists - General"tmp11["29-1064.00"] = "Obstetricians & Gynecologists"tmp11["29-1065.00"] = "Pediatricians - General"tmp11["29-1066.00"] = "Psychiatrists"tmp11["29-1067.00"] = "Surgeons"tmp11["29-1069.99"] = "Physicians & Surgeons, Other"tmp11["29-1071.00"] = "Physician Assistants"tmp11["29-1081.00"] = "Podiatrists"tmp11["29-1111.00"] = "Registered Nurses"tmp11["29-1121.00"] = "Audiologists"tmp11["29-1122.00"] = "Occupational Therapists"tmp11["29-1123.00"] = "Physical Therapists"tmp11["29-1124.00"] = "Radiation Therapists"tmp11["29-1125.00"] = "Recreational Therapists"tmp11["29-1126.00"] = "Respiratory Therapists"tmp11["29-1127.00"] = "Speech-Language Pathologists"tmp11["29-1129.99"] = "Therapists, Other"tmp11["29-1131.00"] = "Veterinarians"tmp11["29-1199.99"] = "Health Diagnosing & Treating Practitioners, Other"tmp11["29-2011.00"] = "Medical & Clinical Laboratory Technologists"tmp11["29-2012.00"] = "Medical & Clinical Laboratory Technicians"tmp11["29-2021.00"] = "Dental Hygienists"tmp11["29-2031.00"] = "Cardiovascular Technologists & Technicians"tmp11["29-2032.00"] = "Diagnostic Medical Sonographers"tmp11["29-2033.00"] = "Nuclear Medicine Technologists"tmp11["29-2034.01"] = "Radiologic Technologists"tmp11["29-2034.02"] = "Radiologic Technicians"tmp11["29-2041.00"] = "Emergency Medical Technicians (EMT) & Paramedics"tmp11["29-2051.00"] = "Dietetic Technicians"tmp11["29-2052.00"] = "Pharmacy Technicians"tmp11["29-2053.00"] = "Psychiatric Technicians"tmp11["29-2054.00"] = "Respiratory Therapy Technicians"tmp11["29-2055.00"] = "Surgical Technologists"tmp11["29-2056.00"] = "Veterinary Technologists & Technicians"tmp11["29-2061.00"] = "Licensed Practical & Licensed Vocational Nurses"tmp11["29-2071.00"] = "Medical Records & Health Information Technicians"tmp11["29-2081.00"] = "Opticians - Dispensing"tmp11["29-2091.00"] = "Orthotists & Prosthetists"tmp11["29-2099.99"] = "Health Technologists & Technicians, Other"tmp11["29-9011.00"] = "Occupational Health & Safety Specialists"tmp11["29-9012.00"] = "Occupational Health & Safety Technicians"tmp11["29-9091.00"] = "Athletic Trainers"tmp11["29-9099.99"] = "Healthcare Practitioners & Technical Workers, Other"tmp10["careers"] = tmp11tmp11 = nulloCareersData["29"] = tmp10tmp10 = nullvar tmp11 = new Objecttmp11["category_title"] = "Healthcare Support"var tmp12 = new Objecttmp12["31-1011.00"] = "Home Health Aides"tmp12["31-1012.00"] = "Nursing Aides, Orderlies & Attendants"tmp12["31-1013.00"] = "Psychiatric Aides"tmp12["31-2011.00"] = "Occupational Therapist Assistants"tmp12["31-2012.00"] = "Occupational Therapist Aides"tmp12["31-2021.00"] = "Physical Therapist Assistants"tmp12["31-2022.00"] = "Physical Therapist Aides"tmp12["31-9011.00"] = "Massage Therapists"tmp12["31-9091.00"] = "Dental Assistants"tmp12["31-9092.00"] = "Medical Assistants"tmp12["31-9093.00"] = "Medical Equipment Preparers"tmp12["31-9094.00"] = "Medical Transcriptionists"tmp12["31-9095.00"] = "Pharmacy Aides"tmp12["31-9096.00"] = "Veterinary Assistants & Laboratory Animal Caretakers"tmp12["31-9099.99"] = "Healthcare Support Workers, Other"tmp11["careers"] = tmp12tmp12 = nulloCareersData["31"] = tmp11tmp11 = nullvar tmp12 = new Objecttmp12["category_title"] = "Protective Service"var tmp13 = new Objecttmp13["33-1011.00"] = "Managers/Supervisors of Correctional Officers"tmp13["33-1012.00"] = "Managers/Supervisors of Police & Detectives"tmp13["33-1021.01"] = "Managers/Supervisors of Municipal Fire Fighters"tmp13["33-1021.02"] = "Managers/Supervisors of Forest Fire Fighters"tmp13["33-1099.99"] = "Managers/Supervisors of Other Protective Service Workers"tmp13["33-2011.01"] = "Municipal Fire Fighters"tmp13["33-2011.02"] = "Forest Fire Fighters"tmp13["33-2021.01"] = "Fire Inspectors"tmp13["33-2021.02"] = "Fire Investigators"tmp13["33-2022.00"] = "Forest Fire Inspectors & Prevention Specialists"tmp13["33-3011.00"] = "Bailiffs"tmp13["33-3012.00"] = "Correctional Officers & Jailers"tmp13["33-3021.01"] = "Police Detectives"tmp13["33-3021.02"] = "Police Identification & Records Officers"tmp13["33-3021.03"] = "Criminal Investigators & Special Agents"tmp13["33-3021.05"] = "Immigration & Customs Inspectors"tmp13["33-3031.00"] = "Fish & Game Wardens"tmp13["33-3041.00"] = "Parking Enforcement Workers"tmp13["33-3051.01"] = "Police Patrol Officers"tmp13["33-3051.03"] = "Sheriffs & Deputy Sheriffs"tmp13["33-3052.00"] = "Transit & Railroad Police"tmp13["33-9011.00"] = "Animal Control Workers"tmp13["33-9021.00"] = "Private Detectives & Investigators"tmp13["33-9031.00"] = "Gaming Surveillance Officers & Gaming Investigators"tmp13["33-9032.00"] = "Security Guards"tmp13["33-9091.00"] = "Crossing Guards"tmp13["33-9092.00"] = "Lifeguards, Ski Patrol & Recreational Protective Service"tmp13["33-9099.01"] = "Transportation Security Screeners"tmp13["33-9099.99"] = "Protective Service Workers, Other"tmp12["careers"] = tmp13tmp13 = nulloCareersData["33"] = tmp12tmp12 = nullvar tmp13 = new Objecttmp13["category_title"] = "Food Preparation & Service"var tmp14 = new Objecttmp14["35-1011.00"] = "Chefs & Head Cooks"tmp14["35-1012.00"] = "Managers of Food Preparation & Serving Workers"tmp14["35-2011.00"] = "Cooks - Fast Food"tmp14["35-2012.00"] = "Cooks - Institution & Cafeteria"tmp14["35-2013.00"] = "Cooks - Private Household"tmp14["35-2014.00"] = "Cooks - Restaurant"tmp14["35-2015.00"] = "Cooks - Short Order"tmp14["35-2019.99"] = "Cooks - Other"tmp14["35-2021.00"] = "Food Preparation Workers"tmp14["35-3011.00"] = "Bartenders"tmp14["35-3021.00"] = "Food Preparation & Serving Workers (including fast food)"tmp14["35-3022.00"] = "Counter Attendants - Cafeteria & Coffee Shop"tmp14["35-3031.00"] = "Waiters & Waitresses"tmp14["35-3041.00"] = "Food Servers - Nonrestaurant"tmp14["35-9011.00"] = "Dining Room & Cafeteria Attendants & Bartender Helpers"tmp14["35-9021.00"] = "Dishwashers"tmp14["35-9031.00"] = "Hosts & Hostesses - Restaurant, Lounge & Coffee Shop"tmp14["35-9099.99"] = "Food Preparation & Serving Workers, Other"tmp13["careers"] = tmp14tmp14 = nulloCareersData["35"] = tmp13tmp13 = nullvar tmp14 = new Objecttmp14["category_title"] = "Building and Grounds Cleaning & Maintenance"var tmp15 = new Objecttmp15["37-1011.00"] = "Managers/Supervisors of Housekeeping & Janitorial Workers"tmp15["37-1012.00"] = "Managers/Supervisors of Landscaping & Groundskeeping Workers"tmp15["37-2011.00"] = "Janitors & Cleaners"tmp15["37-2012.00"] = "Maids & Housekeeping Cleaners"tmp15["37-2019.99"] = "Building Cleaning Workers, Other"tmp15["37-2021.00"] = "Pest Control Workers"tmp15["37-3011.00"] = "Landscaping & Groundskeeping Workers"tmp15["37-3012.00"] = "Pesticide Handlers, Sprayers & Applicators - Vegetation"tmp15["37-3013.00"] = "Tree Trimmers & Pruners"tmp15["37-3019.99"] = "Grounds Maintenance Workers, Other"tmp14["careers"] = tmp15tmp15 = nulloCareersData["37"] = tmp14tmp14 = nullvar tmp15 = new Objecttmp15["category_title"] = "Personal Care & Hospitality"var tmp16 = new Objecttmp16["39-1011.00"] = "Gaming Supervisors"tmp16["39-1012.00"] = "Slot Key Persons"tmp16["39-1021.00"] = "Managers of Personal Service Workers"tmp16["39-2011.00"] = "Animal Trainers"tmp16["39-2021.00"] = "Nonfarm Animal Caretakers"tmp16["39-3011.00"] = "Gaming Dealers"tmp16["39-3012.00"] = "Gaming & Sports Book Writers & Runners"tmp16["39-3019.99"] = "Gaming Service Workers, Other"tmp16["39-3021.00"] = "Motion Picture Projectionists"tmp16["39-3031.00"] = "Ushers, Lobby Attendants & Ticket Takers"tmp16["39-3091.00"] = "Amusement & Recreation Attendants"tmp16["39-3092.00"] = "Costume Attendants"tmp16["39-3093.00"] = "Locker Room, Coatroom & Dressing Room Attendants"tmp16["39-3099.99"] = "Entertainment Attendants & Related Workers, Other"tmp16["39-4011.00"] = "Embalmers"tmp16["39-4021.00"] = "Funeral Attendants"tmp16["39-5011.00"] = "Barbers"tmp16["39-5012.00"] = "Hairdressers, Hairstylists & Cosmetologists"tmp16["39-5091.00"] = "Makeup Artists - Theatrical & Performance"tmp16["39-5092.00"] = "Manicurists & Pedicurists"tmp16["39-5093.00"] = "Shampooers"tmp16["39-5094.00"] = "Skin Care Specialists"tmp16["39-6011.00"] = "Baggage Porters & Bellhops"tmp16["39-6012.00"] = "Concierges"tmp16["39-6021.00"] = "Tour Guides & Escorts"tmp16["39-6022.00"] = "Travel Guides"tmp16["39-6031.00"] = "Flight Attendants"tmp16["39-6032.00"] = "Transportation Attendants (except flight attendants)"tmp16["39-9011.00"] = "Child Care Workers"tmp16["39-9011.01"] = "Nannies"tmp16["39-9021.00"] = "Personal & Home Care Aides"tmp16["39-9031.00"] = "Fitness Trainers & Aerobics Instructors"tmp16["39-9032.00"] = "Recreation Workers"tmp16["39-9041.00"] = "Residential Advisors"tmp16["39-9099.99"] = "Personal Care & Service Workers, Other"tmp15["careers"] = tmp16tmp16 = nulloCareersData["39"] = tmp15tmp15 = nullvar tmp16 = new Objecttmp16["category_title"] = "Sales and Related"var tmp17 = new Objecttmp17["41-1011.00"] = "Managers of Retail Sales Workers"tmp17["41-1012.00"] = "Managers of Non-Retail Sales Workers"tmp17["41-2011.00"] = "Cashiers"tmp17["41-2012.00"] = "Gaming Change Persons & Booth Cashiers"tmp17["41-2021.00"] = "Counter & Rental Clerks"tmp17["41-2022.00"] = "Parts Salespersons"tmp17["41-2031.00"] = "Retail Salespersons"tmp17["41-3011.00"] = "Advertising Sales Agents"tmp17["41-3021.00"] = "Insurance Sales Agents"tmp17["41-3031.01"] = "Sales Agents - Securities & Commodities"tmp17["41-3031.02"] = "Sales Agents - Financial Services"tmp17["41-3041.00"] = "Travel Agents"tmp17["41-3099.99"] = "Sales Representatives - Other Services"tmp17["41-4011.00"] = "Sales Representatives - Technical & Scientific Products"tmp17["41-4012.00"] = "Sales Representatives - Wholesale & Manufacturing"tmp17["41-9011.00"] = "Demonstrators & Product Promoters"tmp17["41-9012.00"] = "Models"tmp17["41-9021.00"] = "Real Estate Brokers"tmp17["41-9022.00"] = "Real Estate Sales Agents"tmp17["41-9031.00"] = "Sales Engineers"tmp17["41-9041.00"] = "Telemarketers"tmp17["41-9091.00"] = "Door-To-Door Sales Workers, News & Street Vendors"tmp17["41-9099.99"] = "Sales Workers, Other"tmp16["careers"] = tmp17tmp17 = nulloCareersData["41"] = tmp16tmp16 = nullvar tmp17 = new Objecttmp17["category_title"] = "Office and Administrative Support"var tmp18 = new Objecttmp18["43-1011.00"] = "Managers/Supervisors of Office & Administrative Support Workers"tmp18["43-2011.00"] = "Switchboard Operators (including answering service)"tmp18["43-2021.00"] = "Telephone Operators"tmp18["43-2099.99"] = "Communications Equipment Operators, Other"tmp18["43-3011.00"] = "Bill & Account Collectors"tmp18["43-3021.01"] = "Statement Clerks"tmp18["43-3021.02"] = "Billing, Cost & Rate Clerks"tmp18["43-3021.03"] = "Billing, Posting & Calculating Machine Operators"tmp18["43-3031.00"] = "Bookkeeping, Accounting & Auditing Clerks"tmp18["43-3041.00"] = "Gaming Cage Workers"tmp18["43-3051.00"] = "Payroll & Timekeeping Clerks"tmp18["43-3061.00"] = "Procurement Clerks"tmp18["43-3071.00"] = "Tellers"tmp18["43-4011.00"] = "Brokerage Clerks"tmp18["43-4021.00"] = "Correspondence Clerks"tmp18["43-4031.01"] = "Court Clerks"tmp18["43-4031.02"] = "Municipal Clerks"tmp18["43-4031.03"] = "License Clerks"tmp18["43-4041.01"] = "Credit Authorizers"tmp18["43-4041.02"] = "Credit Checkers"tmp18["43-4051.00"] = "Customer Service Representatives"tmp18["43-4061.00"] = "Eligibility Interviewers - Government Programs"tmp18["43-4071.00"] = "File Clerks"tmp18["43-4081.00"] = "Hotel, Motel & Resort Desk Clerks"tmp18["43-4111.00"] = "Interviewers (except eligibility & loan)"tmp18["43-4121.00"] = "Library Assistants - Clerical"tmp18["43-4131.00"] = "Loan Interviewers & Clerks"tmp18["43-4141.00"] = "New Accounts Clerks"tmp18["43-4151.00"] = "Order Clerks"tmp18["43-4161.00"] = "Human Resources Assistants (except payroll & timekeeping)"tmp18["43-4171.00"] = "Receptionists & Information Clerks"tmp18["43-4181.00"] = "Reservation/Transportation Ticket Agents & Travel Clerks"tmp18["43-4199.99"] = "Information & Record Clerks, Other"tmp18["43-5011.00"] = "Cargo & Freight Agents"tmp18["43-5021.00"] = "Couriers & Messengers"tmp18["43-5031.00"] = "Police, Fire & Ambulance Dispatchers"tmp18["43-5032.00"] = "Dispatchers (except police, fire & ambulance)"tmp18["43-5041.00"] = "Meter Readers - Utilities"tmp18["43-5051.00"] = "Postal Service Clerks"tmp18["43-5052.00"] = "Postal Service Mail Carriers"tmp18["43-5053.00"] = "Postal Service Mail Sorters & Processors"tmp18["43-5061.00"] = "Production, Planning & Expediting Clerks"tmp18["43-5071.00"] = "Shipping, Receiving & Traffic Clerks"tmp18["43-5081.01"] = "Stock Clerks - Sales Floor"tmp18["43-5081.02"] = "Marking Clerks"tmp18["43-5081.03"] = "Stock Clerks - Stockroom, Warehouse or Storage Yard"tmp18["43-5081.04"] = "Order Fillers - Wholesale & Retail Sales"tmp18["43-5111.00"] = "Weighers, Measurers, Checkers & Samplers"tmp18["43-6011.00"] = "Executive Secretaries & Administrative Assistants"tmp18["43-6012.00"] = "Legal Secretaries"tmp18["43-6013.00"] = "Medical Secretaries"tmp18["43-6014.00"] = "Secretaries (except legal, medical & executive)"tmp18["43-9011.00"] = "Computer Operators"tmp18["43-9021.00"] = "Data Entry Keyers"tmp18["43-9022.00"] = "Word Processors & Typists"tmp18["43-9031.00"] = "Desktop Publishers"tmp18["43-9041.01"] = "Insurance Claims Clerks"tmp18["43-9041.02"] = "Insurance Policy Processing Clerks"tmp18["43-9051.00"] = "Mail Clerks & Mail Machine Operators (except postal service)"tmp18["43-9061.00"] = "Office Clerks - General"tmp18["43-9071.00"] = "Office Machine Operators (except computer)"tmp18["43-9081.00"] = "Proofreaders & Copy Markers"tmp18["43-9111.00"] = "Statistical Assistants"tmp18["43-9199.99"] = "Office & Administrative Support Workers, Other"tmp17["careers"] = tmp18tmp18 = nulloCareersData["43"] = tmp17tmp17 = nullvar tmp18 = new Objecttmp18["category_title"] = "Farming, Fishing, & Forestry"var tmp19 = new Objecttmp19["45-1011.05"] = "Managers/Supervisors of Logging Workers"tmp19["45-1011.06"] = "Managers/Supervisors of Aquacultural Workers"tmp19["45-1011.07"] = "Managers/Supervisors of Agricultural Crop & Horticultural Workers"tmp19["45-1011.08"] = "Managers/Supervisors of Animal Husbandry & Animal Care Workers"tmp19["45-1012.00"] = "Farm Labor Contractors"tmp19["45-2011.00"] = "Agricultural Inspectors"tmp19["45-2021.00"] = "Animal Breeders"tmp19["45-2041.00"] = "Graders & Sorters - Agricultural Products"tmp19["45-2091.00"] = "Agricultural Equipment Operators"tmp19["45-2092.01"] = "Nursery Workers"tmp19["45-2092.02"] = "Farmworkers & Laborers"tmp19["45-2093.00"] = "Farmworkers - Farm & Ranch Animals"tmp19["45-2099.99"] = "Agricultural Workers, Other"tmp19["45-3011.00"] = "Fishers & Related Fishing Workers"tmp19["45-3021.00"] = "Hunters & Trappers"tmp19["45-4011.00"] = "Forest & Conservation Workers"tmp19["45-4021.00"] = "Fallers"tmp19["45-4022.00"] = "Logging Equipment Operators"tmp19["45-4023.00"] = "Log Graders & Scalers"tmp19["45-4029.99"] = "Logging Workers, Other"tmp18["careers"] = tmp19tmp19 = nulloCareersData["45"] = tmp18tmp18 = nullvar tmp19 = new Objecttmp19["category_title"] = "Construction & Mining"var tmp20 = new Objecttmp20["47-1011.00"] = "Managers/Supervisors of Construction & Extraction Workers"tmp20["47-2011.00"] = "Boilermakers"tmp20["47-2021.00"] = "Brickmasons & Blockmasons"tmp20["47-2022.00"] = "Stonemasons"tmp20["47-2031.01"] = "Construction Carpenters"tmp20["47-2031.02"] = "Rough Carpenters"tmp20["47-2041.00"] = "Carpet Installers"tmp20["47-2042.00"] = "Floor Layers (except carpet, wood & hard tiles)"tmp20["47-2043.00"] = "Floor Sanders & Finishers"tmp20["47-2044.00"] = "Tile & Marble Setters"tmp20["47-2051.00"] = "Cement Masons & Concrete Finishers"tmp20["47-2053.00"] = "Terrazzo Workers & Finishers"tmp20["47-2061.00"] = "Construction Laborers"tmp20["47-2071.00"] = "Paving, Surfacing & Tamping Equipment Operators"tmp20["47-2072.00"] = "Pile-Driver Operators"tmp20["47-2073.00"] = "Operating Engineers & Construction Equipment Operators"tmp20["47-2081.00"] = "Drywall & Ceiling Tile Installers"tmp20["47-2082.00"] = "Tapers"tmp20["47-2111.00"] = "Electricians"tmp20["47-2121.00"] = "Glaziers"tmp20["47-2131.00"] = "Insulation Workers - Floor, Ceiling & Wall"tmp20["47-2132.00"] = "Insulation Workers - Mechanical"tmp20["47-2141.00"] = "Painters - Construction & Maintenance"tmp20["47-2142.00"] = "Paperhangers"tmp20["47-2151.00"] = "Pipelayers"tmp20["47-2152.01"] = "Pipe Fitters & Steamfitters"tmp20["47-2152.02"] = "Plumbers"tmp20["47-2161.00"] = "Plasterers & Stucco Masons"tmp20["47-2171.00"] = "Reinforcing Iron & Rebar Workers"tmp20["47-2181.00"] = "Roofers"tmp20["47-2211.00"] = "Sheet Metal Workers"tmp20["47-2221.00"] = "Structural Iron & Steel Workers"tmp20["47-3011.00"] = "Helpers - Brickmasons, Stonemasons & Setters"tmp20["47-3012.00"] = "Helpers - Carpenters"tmp20["47-3013.00"] = "Helpers - Electricians"tmp20["47-3014.00"] = "Helpers - Painters, Paperhangers & Plasterers"tmp20["47-3015.00"] = "Helpers - Pipelayers, Plumbers & Pipefitters"tmp20["47-3016.00"] = "Helpers - Roofers"tmp20["47-3019.99"] = "Helpers - Construction, Other"tmp20["47-4011.00"] = "Construction & Building Inspectors"tmp20["47-4021.00"] = "Elevator Installers & Repairers"tmp20["47-4031.00"] = "Fence Erectors"tmp20["47-4041.00"] = "Hazardous Materials Removal Workers"tmp20["47-4051.00"] = "Highway Maintenance Workers"tmp20["47-4061.00"] = "Rail-Track Laying & Maintenance Equipment Operators"tmp20["47-4071.00"] = "Septic Tank Servicers & Sewer Pipe Cleaners"tmp20["47-4091.00"] = "Segmental Pavers"tmp20["47-4099.99"] = "Construction & Related Workers, Other"tmp20["47-5011.00"] = "Derrick Operators - Oil & Gas"tmp20["47-5012.00"] = "Rotary Drill Operators - Oil & Gas"tmp20["47-5013.00"] = "Service Unit Operators - Oil, Gas & Mining"tmp20["47-5021.00"] = "Earth Drillers (except oil & gas)"tmp20["47-5031.00"] = "Explosives Workers - Ordnance Handling Experts & Blasters"tmp20["47-5041.00"] = "Continuous Mining Machine Operators"tmp20["47-5042.00"] = "Mine Cutting & Channeling Machine Operators"tmp20["47-5049.99"] = "Mining Machine Operators, Other"tmp20["47-5051.00"] = "Rock Splitters - Quarry"tmp20["47-5061.00"] = "Roof Bolters - Mining"tmp20["47-5071.00"] = "Roustabouts - Oil & Gas"tmp20["47-5081.00"] = "Helpers - Extraction Workers"tmp20["47-5099.99"] = "Extraction Workers, Other"tmp19["careers"] = tmp20tmp20 = nulloCareersData["47"] = tmp19tmp19 = nullvar tmp20 = new Objecttmp20["category_title"] = "Installation, Maintenance, & Repair"var tmp21 = new Objecttmp21["49-1011.00"] = "Managers of Mechanics, Installers & Repairers"tmp21["49-2011.00"] = "Computer, Automated Teller & Office Machine Repairers"tmp21["49-2021.00"] = "Radio Mechanics"tmp21["49-2022.00"] = "Telecommunications Equipment Installers & Repairers"tmp21["49-2091.00"] = "Avionics Technicians"tmp21["49-2092.00"] = "Electric Motor & Power Tool Repairers"tmp21["49-2093.00"] = "Electrical Installers/Repairers - Transportation Equipment"tmp21["49-2094.00"] = "Electrical Repairers - Commercial & Industrial Equipment"tmp21["49-2095.00"] = "Electrical Repairers - Powerhouse, Substation & Relay"tmp21["49-2096.00"] = "Electronic Equipment Installers - Motor Vehicles"tmp21["49-2097.00"] = "Electronic Home Entertainment Equipment Installers"tmp21["49-2098.00"] = "Security & Fire Alarm Systems Installers"tmp21["49-3011.00"] = "Aircraft Mechanics & Service Technicians"tmp21["49-3021.00"] = "Automotive Body & Related Repairers"tmp21["49-3022.00"] = "Automotive Glass Installers & Repairers"tmp21["49-3023.01"] = "Automotive Master Mechanics"tmp21["49-3023.02"] = "Automotive Specialty Technicians"tmp21["49-3031.00"] = "Bus & Truck Mechanics and Diesel Engine Specialists"tmp21["49-3041.00"] = "Farm Equipment Mechanics"tmp21["49-3042.00"] = "Mobile Heavy Equipment Mechanics (except engines)"tmp21["49-3043.00"] = "Rail Car Repairers"tmp21["49-3051.00"] = "Motorboat Mechanics"tmp21["49-3052.00"] = "Motorcycle Mechanics"tmp21["49-3053.00"] = "Outdoor Power Equipment & Other Small Engine Mechanics"tmp21["49-3091.00"] = "Bicycle Repairers"tmp21["49-3092.00"] = "Recreational Vehicle Service Technicians"tmp21["49-3093.00"] = "Tire Repairers & Changers"tmp21["49-9011.00"] = "Mechanical Door Repairers"tmp21["49-9012.00"] = "Control & Valve Installers & Repairers (except mechanical door)"tmp21["49-9021.01"] = "Heating & Air Conditioning Mechanics"tmp21["49-9021.02"] = "Refrigeration Mechanics"tmp21["49-9031.00"] = "Home Appliance Repairers"tmp21["49-9041.00"] = "Industrial Machinery Mechanics"tmp21["49-9042.00"] = "Maintenance & Repair Workers - General"tmp21["49-9043.00"] = "Maintenance Workers - Machinery"tmp21["49-9044.00"] = "Millwrights"tmp21["49-9045.00"] = "Refractory Materials Repairers (except brickmasons)"tmp21["49-9051.00"] = "Electrical Power-Line Installers & Repairers"tmp21["49-9052.00"] = "Telecommunications Line Installers & Repairers"tmp21["49-9061.00"] = "Camera & Photographic Equipment Repairers"tmp21["49-9062.00"] = "Medical Equipment Repairers"tmp21["49-9063.00"] = "Musical Instrument Repairers & Tuners"tmp21["49-9064.00"] = "Watch Repairers"tmp21["49-9069.99"] = "Precision Instrument & Equipment Repairers, Other"tmp21["49-9091.00"] = "Coin, Vending & Amusement Machine Servicers/Repairers"tmp21["49-9092.00"] = "Commercial Divers"tmp21["49-9093.00"] = "Fabric Menders (except garment)"tmp21["49-9094.00"] = "Locksmiths & Safe Repairers"tmp21["49-9095.00"] = "Manufactured Building & Mobile Home Installers"tmp21["49-9096.00"] = "Riggers"tmp21["49-9097.00"] = "Signal & Track Switch Repairers"tmp21["49-9098.00"] = "Helpers - Installation, Maintenance & Repair Workers"tmp21["49-9099.99"] = "Installation, Maintenance & Repair Workers, Other"tmp20["careers"] = tmp21tmp21 = nulloCareersData["49"] = tmp20tmp20 = nullvar tmp21 = new Objecttmp21["category_title"] = "Manufacturing & Production"var tmp22 = new Objecttmp22["51-1011.00"] = "Managers of Production & Operating Workers"tmp22["51-2011.00"] = "Aircraft Assemblers - Structure, Surfaces, Rigging & Systems"tmp22["51-2021.00"] = "Coil Winders, Tapers & Finishers"tmp22["51-2022.00"] = "Electrical & Electronic Equipment Assemblers"tmp22["51-2023.00"] = "Electromechanical Equipment Assemblers"tmp22["51-2031.00"] = "Engine & Other Machine Assemblers"tmp22["51-2041.00"] = "Structural Metal Fabricators & Fitters"tmp22["51-2091.00"] = "Fiberglass Laminators & Fabricators"tmp22["51-2092.00"] = "Team Assemblers"tmp22["51-2093.00"] = "Timing Device Assemblers, Adjusters & Calibrators"tmp22["51-2099.99"] = "Assemblers & Fabricators, Other"tmp22["51-3011.00"] = "Bakers"tmp22["51-3021.00"] = "Butchers & Meat Cutters"tmp22["51-3022.00"] = "Meat, Poultry & Fish Cutters/Trimmers"tmp22["51-3023.00"] = "Slaughterers & Meat Packers"tmp22["51-3091.00"] = "Food & Tobacco Roasting, Baking & Drying Machine Operators"tmp22["51-3092.00"] = "Food Batchmakers"tmp22["51-3093.00"] = "Food Cooking Machine Operators & Tenders"tmp22["51-4011.00"] = "Computer-Controlled Machine Tool Operators - Metal and Plastic"tmp22["51-4012.00"] = "Numerical Tool & Process Control Programmers"tmp22["51-4021.00"] = "Extruding & Drawing Machine Setters, Operators & Tenders"tmp22["51-4022.00"] = "Forging Machine Setters, Operators & Tenders"tmp22["51-4023.00"] = "Rolling Machine Setters, Operators & Tenders"tmp22["51-4031.00"] = "Cutting, Punching & Press Machine Setters, Operators & Tenders - Metal and Plastic"tmp22["51-4032.00"] = "Drilling & Boring Machine Tool Setters, Operators & Tenders"tmp22["51-4033.00"] = "Grinding, Lapping, Polishing & Buffing Machine Tool Setters, Operators & Tenders"tmp22["51-4034.00"] = "Lathe & Turning Machine Tool Setters, Operators & Tenders"tmp22["51-4035.00"] = "Milling & Planing Machine Setters, Operators & Tenders"tmp22["51-4041.00"] = "Machinists"tmp22["51-4051.00"] = "Metal-Refining Furnace Operators & Tenders"tmp22["51-4052.00"] = "Pourers & Casters - Metal"tmp22["51-4061.00"] = "Model Makers - Metal & Plastic"tmp22["51-4062.00"] = "Patternmakers - Metal & Plastic"tmp22["51-4071.00"] = "Foundry Mold & Coremakers"tmp22["51-4072.00"] = "Molding, Coremaking & Casting Machine Setters, Operators & Tenders - Metal and Plastic"tmp22["51-4081.00"] = "Multiple Machine Tool Setters, Operators & Tenders - Metal and Plastic"tmp22["51-4111.00"] = "Tool & Die Makers"tmp22["51-4121.06"] = "Welders, Cutters & Welder Fitters"tmp22["51-4121.07"] = "Solderers & Brazers"tmp22["51-4122.00"] = "Welding, Soldering & Brazing Machine Setters, Operators & Tenders"tmp22["51-4191.00"] = "Heat Treating Equipment Setters, Operators & Tenders - Metal and Plastic"tmp22["51-4192.00"] = "Lay-Out Workers - Metal & Plastic"tmp22["51-4193.00"] = "Plating & Coating Machine Setters, Operators & Tenders - Metal and Plastic"tmp22["51-4194.00"] = "Tool Grinders, Filers & Sharpeners"tmp22["51-4199.99"] = "Metal Workers & Plastic Workers, Other"tmp22["51-5011.00"] = "Bindery Workers"tmp22["51-5012.00"] = "Bookbinders"tmp22["51-5021.00"] = "Job Printers"tmp22["51-5022.00"] = "Prepress Technicians & Workers"tmp22["51-5023.00"] = "Printing Machine Operators"tmp22["51-6011.00"] = "Laundry & Dry-Cleaning Workers"tmp22["51-6021.00"] = "Pressers - Textile & Garment"tmp22["51-6031.00"] = "Sewing Machine Operators"tmp22["51-6041.00"] = "Shoe & Leather Workers & Repairers"tmp22["51-6042.00"] = "Shoe Machine Operators & Tenders"tmp22["51-6051.00"] = "Sewers - Hand"tmp22["51-6052.00"] = "Tailors, Dressmakers & Custom Sewers"tmp22["51-6061.00"] = "Textile Bleaching & Dyeing Machine Operators & Tenders"tmp22["51-6062.00"] = "Textile Cutting Machine Setters, Operators & Tenders"tmp22["51-6063.00"] = "Textile Knitting & Weaving Machine Setters & Operators"tmp22["51-6064.00"] = "Textile Winding, Twisting & Drawing Out Machine Operators"tmp22["51-6091.00"] = "Extruding & Forming Machine Setters, Operators & Tenders - Synthetic & Glass Fibers"tmp22["51-6092.00"] = "Fabric & Apparel Patternmakers"tmp22["51-6093.00"] = "Upholsterers"tmp22["51-6099.99"] = "Textile, Apparel & Furnishings Workers, Other"tmp22["51-7011.00"] = "Cabinetmakers & Bench Carpenters"tmp22["51-7021.00"] = "Furniture Finishers"tmp22["51-7031.00"] = "Model Makers - Wood"tmp22["51-7032.00"] = "Patternmakers - Wood"tmp22["51-7041.00"] = "Sawing Machine Setters, Operators & Tenders - Wood"tmp22["51-7042.00"] = "Woodworking Machine Setters, Operators & Tenders"tmp22["51-7099.99"] = "Woodworkers, Other"tmp22["51-8011.00"] = "Nuclear Power Reactor Operators"tmp22["51-8012.00"] = "Power Distributors & Dispatchers"tmp22["51-8013.00"] = "Power Plant Operators"tmp22["51-8021.00"] = "Stationary Engineers & Boiler Operators"tmp22["51-8031.00"] = "Water & Liquid Waste Treatment Plant & System Operators"tmp22["51-8091.00"] = "Chemical Plant & System Operators"tmp22["51-8092.00"] = "Gas Plant Operators"tmp22["51-8093.00"] = "Petroleum Pump System Operators, Refinery Operators & Gaugers"tmp22["51-8099.99"] = "Plant & System Operators, Other"tmp22["51-9011.00"] = "Chemical Equipment Operators & Tenders"tmp22["51-9012.00"] = "Separating, Filtering, Clarifying & Still Machine Operators"tmp22["51-9021.00"] = "Crushing, Grinding & Polishing Machine Operators"tmp22["51-9022.00"] = "Grinding & Polishing Workers - Hand"tmp22["51-9023.00"] = "Mixing & Blending Machine Setters, Operators & Tenders"tmp22["51-9031.00"] = "Cutters & Trimmers - Hand"tmp22["51-9032.00"] = "Cutting & Slicing Machine Setters, Operators & Tenders"tmp22["51-9041.00"] = "Extruding, Forming, Pressing & Compacting Machine Setters, Operators & Tenders"tmp22["51-9051.00"] = "Furnace, Kiln, Oven, Drier & Kettle Operators & Tenders"tmp22["51-9061.00"] = "Inspectors, Testers, Sorters, Samplers & Weighers"tmp22["51-9071.01"] = "Jewelers"tmp22["51-9071.06"] = "Gem & Diamond Workers"tmp22["51-9071.07"] = "Precious Metal Workers"tmp22["51-9081.00"] = "Dental Laboratory Technicians"tmp22["51-9082.00"] = "Medical Appliance Technicians"tmp22["51-9083.00"] = "Ophthalmic Laboratory Technicians"tmp22["51-9111.00"] = "Packaging & Filling Machine Operators & Tenders"tmp22["51-9121.00"] = "Coating, Painting & Spraying Machine Setters, Operators & Tenders"tmp22["51-9122.00"] = "Painters - Transportation Equipment"tmp22["51-9123.00"] = "Painting, Coating & Decorating Workers"tmp22["51-9131.00"] = "Photographic Process Workers"tmp22["51-9132.00"] = "Photographic Processing Machine Operators"tmp22["51-9141.00"] = "Semiconductor Processors"tmp22["51-9191.00"] = "Cementing & Gluing Machine Operators & Tenders"tmp22["51-9192.00"] = "Cleaning, Washing & Metal Pickling Equipment Operators"tmp22["51-9193.00"] = "Cooling & Freezing Equipment Operators & Tenders"tmp22["51-9194.00"] = "Etchers & Engravers"tmp22["51-9195.03"] = "Stone Cutters & Carvers - Manufacturing"tmp22["51-9195.04"] = "Glass Blowers, Molders, Benders & Finishers"tmp22["51-9195.05"] = "Potters - Manufacturing"tmp22["51-9195.07"] = "Molding & Casting Workers"tmp22["51-9196.00"] = "Paper Goods Machine Setters, Operators & Tenders"tmp22["51-9197.00"] = "Tire Builders"tmp22["51-9198.00"] = "Helpers - Production Workers"tmp22["51-9199.99"] = "Production Workers, Other"tmp21["careers"] = tmp22tmp22 = nulloCareersData["51"] = tmp21tmp21 = nullvar tmp22 = new Objecttmp22["category_title"] = "Transportation & Material Moving"var tmp23 = new Objecttmp23["53-1011.00"] = "Aircraft Cargo Handling Supervisors"tmp23["53-1021.00"] = "Managers of Helpers, Laborers & Material Movers - Hand"tmp23["53-1031.00"] = "Managers of Transportation & Vehicle Operators"tmp23["53-2011.00"] = "Airline Pilots, Copilots & Flight Engineers"tmp23["53-2012.00"] = "Commercial Pilots"tmp23["53-2021.00"] = "Air Traffic Controllers"tmp23["53-2022.00"] = "Airfield Operations Specialists"tmp23["53-3011.00"] = "Ambulance Drivers & Attendants (except EMTs)"tmp23["53-3021.00"] = "Bus Drivers - Transit & Intercity"tmp23["53-3022.00"] = "Bus Drivers - School"tmp23["53-3031.00"] = "Driver/Sales Workers"tmp23["53-3032.00"] = "Truck Drivers - Heavy & Tractor-Trailer"tmp23["53-3033.00"] = "Truck Drivers - Light or Delivery Services"tmp23["53-3041.00"] = "Taxi Drivers & Chauffeurs"tmp23["53-3099.99"] = "Motor Vehicle Operators, Other"tmp23["53-4011.00"] = "Locomotive Engineers"tmp23["53-4012.00"] = "Locomotive Firers"tmp23["53-4013.00"] = "Rail Yard Engineers, Dinkey Operators & Hostlers"tmp23["53-4021.00"] = "Railroad Brake, Signal & Switch Operators"tmp23["53-4031.00"] = "Railroad Conductors & Yardmasters"tmp23["53-4041.00"] = "Subway & Streetcar Operators"tmp23["53-4099.99"] = "Rail Transportation Workers, Other"tmp23["53-5011.00"] = "Sailors & Marine Oilers"tmp23["53-5021.01"] = "Ship & Boat Captains"tmp23["53-5021.02"] = "Mates - Ship, Boat & Barge"tmp23["53-5021.03"] = "Pilots - Ship"tmp23["53-5022.00"] = "Motorboat Operators"tmp23["53-5031.00"] = "Ship Engineers"tmp23["53-6011.00"] = "Bridge & Lock Tenders"tmp23["53-6021.00"] = "Parking Lot Attendants"tmp23["53-6031.00"] = "Service Station Attendants"tmp23["53-6041.00"] = "Traffic Technicians"tmp23["53-6051.01"] = "Aviation Inspectors"tmp23["53-6051.07"] = "Transportation Vehicle, Equipment & Systems Inspectors"tmp23["53-6051.08"] = "Freight & Cargo Inspectors"tmp23["53-6099.99"] = "Transportation Workers, Other"tmp23["53-7011.00"] = "Conveyor Operators & Tenders"tmp23["53-7021.00"] = "Crane & Tower Operators"tmp23["53-7031.00"] = "Dredge Operators"tmp23["53-7032.00"] = "Excavating & Loading Machine and Dragline Operators"tmp23["53-7033.00"] = "Loading Machine Operators - Underground Mining"tmp23["53-7041.00"] = "Hoist & Winch Operators"tmp23["53-7051.00"] = "Industrial Truck & Tractor Operators"tmp23["53-7061.00"] = "Cleaners of Vehicles & Equipment"tmp23["53-7062.00"] = "Freight, Stock & Material Movers and Longshoremen"tmp23["53-7063.00"] = "Machine Feeders & Offbearers"tmp23["53-7064.00"] = "Packers & Packagers"tmp23["53-7071.00"] = "Gas Compressor & Gas Pumping Station Operators"tmp23["53-7072.00"] = "Pump Operators (except wellhead pumpers)"tmp23["53-7073.00"] = "Wellhead Pumpers"tmp23["53-7081.00"] = "Refuse & Recyclable Material Collectors"tmp23["53-7111.00"] = "Shuttle Car Operators"tmp23["53-7121.00"] = "Tank Car, Truck & Ship Loaders"tmp23["53-7199.99"] = "Material Moving Workers, Other"tmp22["careers"] = tmp23tmp23 = nulloCareersData["53"] = tmp22tmp22 = nullvar tmp23 = new Objecttmp23["category_title"] = "Military"var tmp24 = new Objecttmp24["55-1011.00"] = "Air Crew Officers"tmp24["55-1012.00"] = "Aircraft Launch & Recovery Officers"tmp24["55-1013.00"] = "Armored Assault Vehicle Officers"tmp24["55-1014.00"] = "Artillery & Missile Officers"tmp24["55-1015.00"] = "Command & Control Center Officers"tmp24["55-1016.00"] = "Infantry Officers"tmp24["55-1017.00"] = "Special Forces Officers"tmp24["55-1019.99"] = "Military Officer Special & Tactical Operations Leaders/Managers, Other"tmp24["55-2011.00"] = "Supervisors/Managers of Air Crew Members"tmp24["55-2012.00"] = "Supervisors/Managers of Weapons Specialists/Crew Members"tmp24["55-2013.00"] = "Supervisors/Managers of All Other Tactical Operations Specialists"tmp24["55-3011.00"] = "Air Crew Members"tmp24["55-3012.00"] = "Aircraft Launch & Recovery Specialists"tmp24["55-3013.00"] = "Armored Assault Vehicle Crew Members"tmp24["55-3014.00"] = "Artillery & Missile Crew Members"tmp24["55-3015.00"] = "Command & Control Center Specialists"tmp24["55-3016.00"] = "Infantry"tmp24["55-3017.00"] = "Radar & Sonar Technicians"tmp24["55-3018.00"] = "Special Forces"tmp24["55-3019.99"] = "Military Enlisted Tactical Operations & Air/Weapons Specialists and Crew, Other"tmp23["careers"] = tmp24tmp24 = nulloCareersData["55"] = tmp23tmp23 = nullfunction init(){ var categories = document.search_form.career_category; if (categories && categories.selectedIndex > 0) { career_category_change(''); }}function career_category_change(sSelectedValue){ var categories = document.search_form.career_category; var careers = document.search_form.career; if (categories && careers) { if (categories.selectedIndex == 0) { careers.options[0].text = '-- Select Career --'; careers.options.length = 1; careers.disabled = true; } else { var aCareerData = oCareersData[categories.options[categories.selectedIndex].value]['careers']; careers.options[0].selected = true; careers.options[0].text = '-- Select Career --'; careers.options[0].value = ''; var i = 1; for (var career_id in aCareerData) { careers.options.length = i + 1; careers.options[i].value = career_id; careers.options[i].text = aCareerData[career_id]; if (typeof(sSelectedValue) != 'undefined' && sSelectedValue == career_id) careers.options[i].selected = true; i++; } careers.disabled = false; } }}//--></script></code> |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-13 : 00:41:14
|
do the population by means of series of insert statements likeI think easiest way would be to make id field (category_id,career_id) of integer and identity type so that you can do likeDECLARE @CategoryID intINSERT Career_Category(category_title)VALUES('Management')SET @CategoryID = SCOPE_IDENTITY()INSERT Career(career_title,category_id )VALUES('Chief Executives',@CategoryID),('General & Operations Managers',@CategoryID)('Legislators',@CategoryID).. ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
|