Tools and Technology
| Purpose: | For legacy use only. |
| Table Name: | tools_and_technology |
Structure and Description:
| Column | Type | Column Content |
|---|
| onetsoc_code | Character(10) | O*NET-SOC Code (see Occupation Data) |
| t2_type | Character Varying(10) | “Tools” or “Technology” |
| t2_example | Character Varying(150) | Text of T2 example |
| commodity_code | Decimal(8,0) | UNSPSC commodity code (see UNSPSC Reference) |
| hot_technology | Character(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 Number | Description of Change |
|---|
| 20.1 | Added as a new file |
| 20.2 - 20.3 | No structure changes |
| 21.0 | Added “Hot Technology” column |
| 21.1 - 23.1 | No structure changes |
| 23.2 | Deprecated, will be removed |
| 23.3 - 24.0 | No structure changes |
Data Example - tools_and_technology:
| onetsoc_code | t2_type | t2_example | commodity_code | hot_technology |
|---|
| 11-2011.00 | Technology | Actuate BIRT | 43232314 | N |
| 11-2011.00 | Technology | Adobe Systems Adobe Acrobat | 43232202 | Y |
| 11-2011.00 | Technology | Adobe Systems Adobe AfterEffects | 43232103 | Y |
| 11-2011.00 | Technology | Adobe Systems Adobe Creative Suite | 43232402 | N |
| 11-2011.00 | Technology | Adobe Systems Adobe Dreamweaver | 43232107 | Y |
