FedScope Employment Cube (September 2016)
Raw Data Set (http://www.data.gov/)
Source: FedScope (https://www.fedscope.opm.gov/
) 11
3.11 STEM Occupations
This “delimited” (comma separated value (CSV)) data file provides translations for the
STEM occupations data element contained in the employee population data file
(FACTDATA.TXT). See Table 2.1
. Each column value is separated by a “comma” from the
next column's value and each row starts a new record. Each record contains 6 data
elements. The record layout for DTstemocc.txt is depicted in Table 3.11
below:
Table 3.
11: DTstemocc.txt Record Layout
Data
Column
DATA ELEMENT NAME
CSV
Column
Name
CSV
Column
Format
1 STEM Occupation Aggregate STEMAGG TEXT
2 STEM Occupation Aggregate Translation STEMAGGT TEXT
3 STEM Occupation Type STEMTYP TEXT
4 STEM Occupation Type Translation STEMTYPT TEXT
5 STEM Occupation STEMOCC TEXT
6 STEM Occupation Translation STEMOCCT TEXT
Total Records: 69
NOTE: I
f importing this table (data set) into Excel, change the “column data format” for
columns 1-6 from “General” to “Text”.
3.12 Supervisory Status
This “delimited” (comma separated value (CSV)) data file provides translations for the
supervisory status data element contained in the employee population data file
(FACTDATA.TXT). See Table 2.1
. Each column value is separated by a “comma” from the
next column's value and each row starts a new record. Each record contains 4 data
elements. The record layout for DTsuper.txt is depicted in Table 3.12
below:
Table 3.
12: DTsuper.txt Record Layout
Data
Column
DATA ELEMENT NAME
CSV
Column
Name
CSV
Column
Format
1 Supervisory Status Type SUPERTYP TEXT
2 Supervisory Status Type Translation SUPERTYPT TEXT
3 Supervisory Status SUPERVIS TEXT
4 Supervisory Status Translation SUPERVIST TEXT
Total Records: 7
NOTE: If importing this table (data set) into Excel, change the “column data format” for
columns 1-4 from “General” to “Text”.