Tools and Technology
| Purpose: | For legacy use only. |
Structure and Description:
| Column | Type | Column Content |
|---|
| O*NET-SOC Code | Character(10) | O*NET-SOC Code (see Occupation Data) |
| Title | Character Varying(150) | O*NET-SOC Title (see Occupation Data) |
| T2 Type | Character Varying(10) | “Tools” or “Technology” |
| T2 Example | Character Varying(150) | Text of T2 example |
| Commodity Code | Integer(8) | UNSPSC commodity code (see UNSPSC Reference) |
| Commodity Title | Character Varying(150) | UNSPSC commodity title (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 seven tab delimited fields with the columns named O*NET-SOC Code, Title, T2 Type, T2 Example, Commodity Code, Commodity Title, and Hot Technology. The seven 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 | No structure changes |
Data Example - Tools and Technology:
| O*NET-SOC Code | Title | T2 Type | T2 Example | Commodity Code | Commodity Title | Hot Technology |
|---|
| 11-2011.00 | Advertising and Promotions Managers | Technology | Actuate BIRT | 43232314 | Business intelligence and data analysis software | N |
| 11-2011.00 | Advertising and Promotions Managers | Technology | Adobe Systems Adobe Acrobat | 43232202 | Document management software | Y |
| 11-2011.00 | Advertising and Promotions Managers | Technology | Adobe Systems Adobe AfterEffects | 43232103 | Video creation and editing software | Y |
| 11-2011.00 | Advertising and Promotions Managers | Technology | Adobe Systems Adobe Creative Suite | 43232402 | Development environment software | N |
| 11-2011.00 | Advertising and Promotions Managers | Technology | Adobe Systems Adobe Dreamweaver | 43232107 | Web page creation and editing software | Y |
