Tools and Technology

Purpose:Provide Tools and Technology examples.
Table Name:tools_and_technology
Structure and Description:
ColumnTypeColumn Content
onetsoc_codeCharacter(10)O*NET-SOC Code (see Occupation Data)
t2_typeCharacter Varying(10)“Tools” or “Technology”
t2_exampleCharacter Varying(150)Text of T2 example
commodity_codeDecimal(8,0)UNSPSC commodity code (see UNSPSC Reference)

This file contains the Tools and Technology examples, including hot technologies, associated with O*NET-SOC occupations. Each example is classified in two ways: the column “T2 Type” indicates whether the example is a tool or a technology (software product), and the columns “Commodity Code” and “Commodity Title” classify the example under the United Nations Standard Products and Services Code (UNSPSC). See the UNSPSC Reference section for more information.

The “Hot Technology” column indicates requirements frequently included in employer job postings. A concise list of all hot technologies may be downloaded from O*NET OnLine.

We welcome feedback on the T2 database. We accept suggestions for new tools and technologies via our T2 feedback process. Suggestions will be considered for a future update of the T2 database.

The file is displayed in five tab delimited fields with the columns named O*NET-SOC Code, T2 Type, T2 Example, Commodity Code, and Hot Technology. The five fields are represented by one row. There are a total of 68,230 rows of data in this file.

For more information, see:

File Structure Changes:
Release NumberDescription of Change
20.1Added as a new file
20.2 - 20.3No structure changes
21.0Added “Hot Technology” column
21.1 - 22.2No structure changes

Data Example - tools_and_technology:
11-2011.00TechnologyActuate BIRT43232314N
11-2011.00TechnologyAdobe Systems Adobe Acrobat43232202Y
11-2011.00TechnologyAdobe Systems Adobe AfterEffects43232103Y
11-2011.00TechnologyAdobe Systems Adobe Creative Suite43232402N
11-2011.00TechnologyAdobe Systems Adobe Dreamweaver43232107Y