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 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.

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 four tab delimited fields with the columns named O*NET-SOC Code, T2 Type, T2 Example, and Commodity Code. The four fields are represented by one row. There are a total of 67,137 rows of data in this file.

File Structure Changes:
Release NumberDescription of Change
20.1Added as a new file
20.2 - 20.3No structure changes

Data Example - tools_and_technology:
onetsoc_​codet2_​typet2_​examplecommodity_​code
11-2011.00TechnologyActuate software43231602
11-2011.00TechnologyAdobe Systems Adobe Acrobat43232202
11-2011.00TechnologyAdobe Systems Adobe AfterEffects43232103
11-2011.00TechnologyAdobe Systems Adobe Creative Suite software43232402
11-2011.00TechnologyAdobe Systems Adobe Dreamweaver43232107