IA RIC Common Remitter Report - File Layout and Data Mapping

The default file name of the IA RIC Common Remitter report is IA RIC Common Remitter_<MMDDYYYY>.csv.

The file format is comma-delimited.

The following table shows the columns, names, descriptions, lengths, data types, the data sources or valid values, and whether the field is required or optional for the IA RIC Common Remitter report.

Column	Name	Description	Length	Data Type	Data Source or Valid Values	Required or Optional
A	Payroll Date	The employee’s payroll date.	10	Date	Retrieved from the Payroll Date field on the Employee Information form of the IA RIC Common Remitter Report page.	Required
B	SSN	The employee's Social Security number.	11	Alphanumeric	Retrieved from the Social Security field on the Employee Information form of the IA RIC Common Remitter Report page.	Required
C	Last Name	The employee's last name.	35	Alphanumeric	Retrieved from the Last Name field on the Employee Information form of the IA RIC Common Remitter Report page.	Required
D	First Name	The employee's first name.	20	Alphanumeric	Retrieved from the First Name field on the Employee Information form of the IA RIC Common Remitter Report page.	Required
E	Source	The source of the contribution.	2	Code	Valid values: VO = Employee ER = Employer RT = Roth Retrieved from the Source field on the Employee Information form of the IA RIC Common Remitter Report page.	Required
F	Amount	The contribution amount being remitted for the current payroll cycle.	9.2	Numeric	Retrieved from the Amount field on the Employee Information form of the IA RIC Common Remitter Report page.	Required
G	Vendor Name	The RIC plan provider’s name.	15	Alphanumeric	Retrieved from the Vendor field on the Employee Information form of the IA RIC Common Remitter Report page.	Required if Vendor Code is blank.
H	Vendor Code	The RIC plan provider’s code.	10	Alphanumeric	Retrieved from the Vendor field on the Employee Information form of the IA RIC Common Remitter Report page.	Required if Vendor Name is blank.
I	Address 1	The first line of the employee's address.	50	Alphanumeric	Retrieved from the Street Address 1 field on the Employee Information form of the IA RIC Common Remitter Report page.	Required if utilizing a default enrollment process.
J	Address 2	The second line of the employee's address.	50	Alphanumeric	Retrieved from the Street Address 2 field on the Employee Information form of the IA RIC Common Remitter Report page.	Required if utilizing a default enrollment process.
K	City	The employee's city of residence.	18	Alphanumeric	Retrieved from the City field on the Employee Information form of the IA RIC Common Remitter Report page.	Required if utilizing a default enrollment process.
L	State	The employee's state of residence.	2	Alphanumeric	Retrieved from the State field on the Employee Information form of the IA RIC Common Remitter Report page.	Required if utilizing a default enrollment process.
M	Zip	The employee's zip code.	10	Alphanumeric	Retrieved from the Zip Code field on the Employee Information form of the IA RIC Common Remitter Report page.	Required if utilizing a default enrollment process.
N	Date of Birth	The employee's date of birth.	10	Date	Retrieved from the Birth Date field on the Employee Information form of the IA RIC Common Remitter Report page.	Required if utilizing a default enrollment process.
O	Date of Hire	The employee's date of hire.	10	Date	Retrieved from the Hire Date field on the Employee Information form of the IA RIC Common Remitter Report page.	Required if utilizing a default enrollment process.
P	Gender	The employee's gender.	1	Alphanumeric	Valid values: M = Male F = Female O = Other Retrieved from the Gender field on the Employee Information form of the IA RIC Common Remitter Report page.	Required if utilizing a default enrollment process.