# Presentation: 104341

## DOE IISP Data Coordinators WorkshopData Requirements and Collection Review

**Phil Wallace and David Girardi**
**May 23, 2006**

## IISP Data Capture Tables

** ****Roster**
**RTW**
**OSHA**
**Death**
**Disability**
**Monitor**

## Roster Data

**Site Code ****- Not Null**
**ESSN****  - Not Null**
**Dateborn ****- Valid Date, <Today**
**Gender ****- M or F**

**Firsthire ***** Valid Date, <Today**
**Jobtitle ****- Not Null**
**OccCode ****- (see list)**
**Term Date ***** Valid Date, <Today, >Firsthire**

**Valid Date = MM/DD/YYYY**

******* = Not required, but if populated must meet the requirements.**

## Occupational Groups

**Management (M) ****– Predominately office work at a desk; first level supervisor and above; anticipated risks **_**primarily**_** ergonomic**
**Administrative Support (A) ****– Predominately office work at a desk; heavy computer usage; anticipated risks **_**primarily**_** ergonomic.  This category includes but is not limited to information technology, clerical, and secretarial staff.  **
**In-House Professionals (I) ****– Predominately office work at a desk typically without supervisory responsibilities.  The risks are **_**primarily**_** ergonomic.**
**Field Professionals (F) ****– Frequently works outside of their office in areas such as but not limited to laboratories, testing areas, and construction areas.  Potential for exposure to chemical or radiation hazards.**

## Occupational Groups Continued

**Technical Support (T) ****– Workers who typically support the field professionals and have hands-on work situations.  Potential for exposure to chemical or radiation hazards; the potential for exposure may be higher than for the field professionals.**
**Biohazard (B) ****– Workers who have the potential for exposure to biological hazards.  This includes medical technicians, nurses, laboratory staff, animal caretakers, physicians, and veterinarians.**
**Service (S) ****– Typically includes but is not limited to custodians, drivers, laborers, laundry workers, linemen, mail clerks, pilots, railroad engineers, records center workers, stationary engineers, utility workers, and water plant operators.  These workers support and maintain the facility’s infrastructure and have the potential for a broad range of exposures.  Most work is not performed sitting at a desk.**
**Security and Fire (E) ****– Typically includes protective forces and firefighters.****  **

## Occupational Groups Continued

**Crafts (C) ****– Typically includes bargaining unit employees and laborers.  They have the potential for a broad range of exposures.**
**Line Operators (O) ****–Typically workers who are involved in process, operation, or line activities at the facility.  Potential for chemical and/or radiation exposure on a regular basis.**
**Guests (G) ****– Employees on short-term assignments or internships.  Typically includes guest scientists, postdoctoral fellows, co-op students, and interns. Potential for exposure dependent on job assignment.**
**Unknown (U) ****– Job title is missing. **

## RTW Data

**Site Code ****- Not Null**
**ESSN ****- Not Null**
**Status ****- N, C or D**
**Datebegan ****- Valid Date, < Today**
**RTWDate ****- Valid Date, >Datebegan, <Today**
**Diagnosis ****- Not Null**

**Valid Date = MM/DD/YYYY**

## OSHA

**Site Code ****- Not Null**
**ESSN ****- Not Null**
**Status ****- N, C or D**
**EventDate**** - Valid Date**
**OSHA Event ****- Not Null**

**OSHA 300 log**

**Valid Date = MM/DD/YYYY**

**Days away from work**** ****- Numeric data**
**Days restricted at work**** ****- Numeric data**
**Injury Type**** ****- ****Injury, Skin Disorder, Respiratory Condition, Poisoning, Hearing Loss, All Other**

## CAIRS

**Tables From CAIRS**
**InjuryIllness**
**Events**
**Causes**
**Activity**

## Death Data

**Site Code**** - Not Null**
**ESSN ****- Not Null**
**Status ****- N, C or D**
**Death Date ****- Valid Date, < Today**
**Immediate Cause ****- (desired field)**

**Valid Date = MM/DD/YYYY**

## Disability Data

**Site Code ****- Not Null**
**ESSN ****- Not Null**
**Status ****- N, C or D**
**Datebegan ****- Valid Date, < Today**
**Disability Reason ****- Not Null**

**Valid Date = MM/DD/YYYY**

## Monitor

**Site Code ****- Not Null**
**ESSN ****- Not Null**
**Monitor Code ****- Not Null**
**Start Date ****- Valid Date, <(Today + 3yrs)**
**End Date ***** Valid Date, > Start Date, <(Today +3 yrs)**

**Valid Date = MM/DD/YYYY**

******* = Not required, but if populated must meet the requirements.**

## Issues to Review

**Reporting Frequencies**
**  ****Submitting record counts**
**Error reporting and resolution**
**Changing data collection/reporting systems at your site**
**  ****Need the fullest description possible for the health event**
**  ****ICD codes**** **
**Occupational groups – use the standard groups as defined at last workshop**
**CAIRS data vs OSHA data**

## Occupational Groups (short ver.)

**Management (M*) **
**Administrative Support (A) **
**In-House Professionals (I) **
**Field Professionals (F) **
**Technical Support (T) **
**Biohazard (B) **

***Occupation code used as the abbreviation**

**Service (S) **
**Security and Fire (E) **
**Crafts (C)**
**Line Operators (O)**
**Guests (G)**
**Unknown (U)**