100R Report - File Layout and Data Mapping

A

Year

The calendar year of the 100R data.

Retrieved from the Reporting Year field on the IN 100R Report - Report page.

B

Last

The employee's last name.

Retrieved from the Last Name field on the Employee Information form of the IN - 100R Report page.

C

First

The employee’s first name.

Retrieved from the First Name field on the Employee Information form of the IN - 100R Report page.

D

Middle

The employee's middle initial.

Retrieved from the Middle Initial field on the Employee Information form of the IN - 100R Report page.

E

Dept

The employee’s department, office, or building name.

Retrieved from the Department field on the Employee Information form of the IN - 100R Report page.

F

Street

The first line of the employee's location address. 

Retrieved from the Street Address field on the Employee Information form of the IN - 100R Report page.

G

City

The employee's location city. 

Retrieved from the City field on the Employee Information form of the IN - 100R Report page.

H

State

The employee's location state. 

Retrieved from the State field on the Employee Information form of the IN - 100R Report page.

I

Zip

The employee's location zip code. 

Retrieved from the Zip field on the Employee Information form of the IN - 100R Report page.

J

Title

The employee’s position, title, or duties.

Retrieved from the Title field on the Employee Information form of the IN - 100R Report page.

K

Comp

The total compensation paid to the employee in the calendar year that just ended.

Retrieved from the Compensation field on the Employee Information form of the IN - 100R Report page.

L

Donation

Indicates whether the employee’s compensation is funded totally or partially by donated funds.

Valid values:

• 1 = Yes

• 0 = No

Retrieved from the Donation field on the Employee Information form of the IN - 100R Report page.