Education, Training, and Experience Categories

Purpose:Provide descriptions of the Education, Training, and Experience percent frequency categories.
Table Name:ete_categories
Download: 05_ete_categories.sql
Structure and Description:
ColumnTypeColumn Content
element_idCharacter Varying(20)Content Model Outline Position (see Content Model Reference)
scale_idCharacter Varying(3)Scale ID (see Scales Reference)
categoryDecimal(3,0)Category value associated with element
category_descriptionCharacter Varying(1000)Detail description of category associated with element

This file contains the categories associated with the Education, Training, and Experience content area. Categories for the following scales are included: Required Level of Education (RL), Related Work Experience (RW), On-Site or In-Plant Training (PT), and On-The-Job Training (OJ).

The file is displayed in four tab delimited fields with the columns named Element ID, Scale ID, Category, and Category Description. The four fields are represented by one row. There are a total of 41 rows of data in this file.

File Structure Changes:
Release NumberDescription of Change
9.0Added as a new file
10.0 - 23.0No structure changes

Data Example - ete_categories:
element_​idscale_​idcategorycategory_​description
3.A.1RW1None
3.A.1RW2Up to and including 1 month
3.A.1RW3Over 1 month, up to and including 3 months
3.A.1RW4Over 3 months, up to and including 6 months
3.A.1RW5Over 6 months, up to and including 1 year
3.A.1RW6Over 1 year, up to and including 2 years
3.A.1RW7Over 2 years, up to and including 4 years
3.A.1RW8Over 4 years, up to and including 6 years
3.A.1RW9Over 6 years, up to and including 8 years
3.A.1RW10Over 8 years, up to and including 10 years
3.A.1RW11Over 10 years