100R Report - File Layout and Data Mapping

The default file name for the 100R report is gateway100R.csv.

The following table shows the columns, column names, descriptions, and data sources or valid values for the 100R report.

Column	Column Name	Description	Data Source or Valid Values
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.