INDUSTRY AND OCCUPATION CODING

NIOCCS Input File Format Options for Industry and Occupation Coding

Files uploaded to NIOCCS for industry and occupation coding must be in a standard .txt file format delimited by a Tab or Pipe character (|).

Two options exist for submitting records to the NIOCCS system for I&O coding:

  1. NIOCCS I&O Slim File Format
  2. NIOCCS I&O Expanded File Format

The NIOCCS Slim File Format contains only 3 fields:  Unique Identifier, Industry Title or NAICS code, and Occupation Title.  This format should be used if no other additional information (i.e., employer name, job duties, etc.) is available.

Fields DO NOT need to be padded with spaces.  Each record submitted must have a value in the Unique Identifier field and must have at least one value in either the Industry Title or Occupation Title.

Field Field Sequence Format Max Length Comments
Unique Identifier 1  Alpha-Numeric 50 Required.   Must be unique value per record.   Example: 12345, or ID12345
Industry Title

or

NAICS code

2 Alpha-Numeric 250 At least one of these two fields (industry title or occupation title) must contain a value.

Examples for industry title or NAICS code:

Information Technology

Or 443112

Occupation Title 3 Alpha-Numeric 250 At least one of these two fields (industry title or occupation title) must contain a value.

Example for occupation title: Consultant

Example NIOCCS Slim File Format:

With Industry Titles

With Industry Titles

With Industry NAICS codes

With Industry NAICS codes

 

The NIOCCS Expanded File Format should be used if additional information is available that would support the computer assisted coding of the records.   Although NIOCCS currently only uses occupation text and industry text or industry NAICS codes in the autocoding engine, additional information can help users to select correct I&O codes on records that are not autocoded.

Fields DO NOT need to be padded with spaces to fill unused positions. However, each field, including optional fields must be delimited by a Tab or Pipe character ( | ).   Each record submitted must have a value in the Unique Identifier field and must have at least one value in either the Industry Title or Occupation Title.   All other fields are optional.

Field Field Sequence Format Max Length Comments
Unique Identifier 1 Alpha-Numeric 50 Required.   Must be unique value per record.   Example: 12345, or ID12345
Industry Title

Or

NAICS Code

2 Alpha-Numeric 250 At least one of these two fields must contain a value.

At least one of these two fields (industry title or occupation title) must contain a value.

Examples:

Information Technology or 112210

Occupation Title 3 Alpha-Numeric 250 At least one of these two fields (industry title or occupation title) must contain a value.

Example: “Consultant”

Employer Company Name 4 Alpha-Numeric 250 Optional.  Example: “ABCD Motor Company”
Job duties 5 Alpha-Numeric 250 Optional.  Enter text to describe job duties of the occupation.

Used during the computer assisted module to help coder decide on the most accurate occupation code.

Example: “assembling nuts and bolts”

Employer City 6 Alpha-Numeric 50 Optional.  Example: “Cincinnati”
Employer State 7 Alpha 2 Optional.  Example: “OH”
Employer Zip 8 Alpha-Numeric 10 Optional.
Age 9 Alpha-Numeric 5 Optional.  Examples: “25” or “25+” or “>25” or “30-35” or “senior”
Education level 10 Alpha-Numeric 25 Optional.   Examples:  “ <12 years”, “High School”, “1-4 years college”, “> 4 years college”
User defined field1 11 Alpha-Numeric 250 Free text field used for user defined purposes only.
User defined field2 12 Alpha-Numeric 250 Free text field used for user defined purposes only.

Example NIOCCS Expanded File Format:

Example NIOCCS Expanded File Format