Tools and Technology

Purpose:For legacy use only.
Table Name:tools_and_technology
Download: 34_tools_and_technology.sql
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)
hot_technologyCharacter(1)Whether example is classified as a hot technology (Y=yes, N=no)

This file is deprecated and will be removed in a future release of the O*NET Database. Developers should transition to using the files Technology Skills and Tools Used instead.

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 70,148 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
21.0Added “Hot Technology” column
21.1 - 23.1No structure changes
23.2Deprecated, will be removed
23.3No structure changes

Data Example - tools_and_technology:
onetsoc_​codet2_​typet2_​examplecommodity_​codehot_​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