Scales Reference

Purpose:Provide a reference to the scale names and values.
Table Name:scales_reference
Download: 04_scales_reference.sql
Structure and Description:
ColumnTypeColumn Content
scale_idCharacter Varying(3)Scale ID
scale_nameCharacter Varying(50)Scale Name
minimumDecimal(1,0)Scale Minimum
maximumDecimal(3,0)Scale Maximum

This file contains the Scale information by which the raw values are measured.

The file is displayed in four tab delimited fields with the columns named Scale ID, Scale Name, Minimum, and Maximum. The four fields are represented by one row. There are a total of 29 rows of data in this file.

File Structure Changes:
Release NumberDescription of Change
5.0 - 29.1No structure changes

Data Example - scales_reference:
scale_​idscale_​nameminimummaximum
CTContext13
CTPContext (Categories 1-3)0100
CXContext15
CXPContext (Categories 1-5)0100
IMImportance15
LVLevel07
OJOn-The-Job Training (Categories 1-9)0100
PTOn-Site Or In-Plant Training (Categories 1-9)0100
RLRequired Level Of Education (Categories 1-12)0100
RWRelated Work Experience (Categories 1-11)0100