Chemical Exposure Health Data - Dataset Field Definitions

• Field 01 Name: Inspection_Number
• Field 01 Description: Unique identifier tied to inspection - nine numbers in length.
• Field 01 Data Type: NUMBER(9)

• Field 02 Name: Establishment_Name
• Field 02 Description: Sampled Establishment Note: names contained in the IMIS are not unique; i.e., there may be more than one variation in the way a single establishment is spelled. For example, Springdale Waste Water Treatment Facility may be associated with one inspection, and Springdale Water Treatment Plant with another. The user should specify as few words as necessary to uniquely identify the establishment. For the example above, Springdale Water might be a good first choice.
• Field 02 Data Type: VARCHAR2(50)

• Field 03 Name: City
• Field 03 Description: Identifies the site city where the inspection was performed.
• Field 03 Data Type: VARCHAR2(30)

• Field 04 Name: State
• Field 04 Description: Identifies the site state where the inspection was performed.
• Field 04 Data Type: VARCHAR2(2)

• Field 05 Name: Zip_Code
• Field 05 Description: Identifies the site zip code where the inspection was performed.
• Field 05 Data Type: NUMBER(5)

• Field 06 Name: SIC_Code
• Field 06 Description: Indicates the 4-digit Standard Industrial Classification Code from the 1987 version SIC manual which most closely applies. See http://www.osha.gov/pls/imis/sicsearch.html.
• Field 06 Data Type: NUMBER(4)

• Field 07 Name: NAICS_Code
• Field 07 Description: North American Industrial Classification System Code. See http://www.census.gov/epcd/naics02/.
• Field 07 Data Type: NUMBER(6)

• Field 08 Name: Sampling_Number
• Field 08 Description: Unique identifier tied to single exposure assessment - There may be multiple media tied to this number, reflecting multiple samples in the time-weighted sample.
• Field 08 Data Type: NUMBER

• Field 09 Name: Office_ID
• Field 09 Description: Unique number assigned to an OSHA Office.
• Field 09 Data Type: NUMBER

• Field 10 Name: Date_Sampled
• Field 10 Description: Date sample was taken.
• Field 10 Data Type: DATE

• Field 11 Name: Date_Reported
• Field 11 Description: Date results released OSHA Office
• Field 11 Data Type: DATE

• Field 12 Name: Eight_Hour_TWA_Calc
• Field 12 Description: Eight hour TWA calculation used.
• Field 12 Data Type: VARCHAR2(1)

• Field 13 Name: Instrument_Type
• Field 13 Description: Laboratory instrument type used for analysis.
• Field 13 Data Type: VARCHAR2(16)

• Field 14 Name: Lab_Number
• Field 14 Description: Unique identifier assigned by laboratory for internal use - 5 digits followed by a letter.
• Field 14 Data Type: VARCHAR2(6)

• Field 15 Name: Field_Number
• Field 15 Description: Unique identifier tied to individual sample media submitted for analysis.
• Field 15 Data Type: VARCHAR2(25)

• Field 16 Name: Sample_Type
• Field 16 Description: Sample type populated with following values:[P - Personal, A - Area, B - Bulk, W - Wipe]
• Field 16 Data Type: VARCHAR2(2)

• Field 17 Name: Blank_Used
• Field 17 Description: Sample represents a blank used for analysis. Possible values: [Y, N].
• Field 17 Data Type: VARCHAR2(1)

• Field 18 Name: Time_Sampled
• Field 18 Description: Time sampled in minutes.
• Field 18 Data Type: NUMBER

• Field 19 Name: Air_Volume_Sampled
• Field 19 Description: Air Volume sampled in liters.
• Field 19 Data Type: VARCHAR2(10)

• Field 20 Name: Sample_Weight
• Field 20 Description: Sample weight for bulks and silica samples.
• Field 20 Data Type: NUMBER

• Field 21 Name: IMIS_Substance_Code
• Field 21 Description: IMIS substance code number is the substance code assigned by OSHA to each substance. See OSHA Chemical Sampling Information at http://www.osha.gov/dts/chemicalsampling/toc/field.html.
• Field 21 Data Type: VARCHAR2(4)

• Field 22 Name: Substance
• Field 22 Description: Substances are primarily listed by the Chemical name as it appears in the OSHA PELs, 29 CFR 1910.1000, TABLES Z-1-A, Z-2, Z-3; the ACGIH TLV's; or by common name.
• Field 22 Data Type: VARCHAR2(70)

• Field 23 Name: Sample_Result
• Field 23 Description: Sample result from laboratory analysis for each sample submitted with a unique field number. Note: multiple media integrated samples can be tied with a single Sampling Number.
• Field 23 Data Type: NUMBER(10)

• Field 24 Name: Unit_of_Measurement
• Field 24 Description: Unit of measurement (UOM) from IMIS manual. Values: [M - mg/m3, X - micrograms, P - Parts per million, Y - milligrams, F - fibers/cc, % - percentage]
• Field 24 Data Type: VARCHAR2(5)

• Field 25 Name: Qualifier
• Field 25 Description: Result qualifier values: [ND - Result less than quantitation limit, BLK - Blank, @ - Approximately...etc]
• Field 25 Data Type: VARCHAR2(6)

[Last Updated: 04/23/2010]