You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
You are viewing the article in preview mode. It is not live at the moment.
Standard 401k to CalSavers
print icon

This article will describe the file transformation that has been created in detamoov to transform the standard 401k file format to the CalSavers Payroll Contribution fixed length file specifications. This transformation is used in a detamoov integration with CalSavers.

 

Source File

Destination File

Standard 401k

CalSavers Payroll Contribution Fixed Length

 

File Specifications

File Type Generated

Fixed length

Header Row(s) Generated

No

Footer Row(s) Generated

No

End of Row Character

 

File Naming Generated

Production

    <Program>_<EIN>_<EmployeeDeduction/9X>_ASTRO_AsciiA8Fmt_YYYYMMDD_HHMMSS_<sequence>_[Anything you want here].txt

 

Field Mappings

The table below details the specific field mapping and transformation rules applied to ensure the Empower Payroll Contribution fixed length format is created correctly from the standard 401k format.

Empower Field Name

Standard 401k Field Name

Field Size

Details

Payroll Number

Payroll Run Number

6

 

Employer ID/BIN

Company EIN

11

 

Payroll End Date

Pay Period End Date

8

 

Social Security Number

SSN

9

 

Last Name, First Name

Last Name, First Name

32

 

Address Line 1

Address Line 1

30

 

Address Line 2

Address Line 2

30

 

City, State

City, State

20

 

Zip

Zip

9

 

Date of Birth

DOB

8

Will be in MMDDYYYY

Date of Hire

Hire Date

8

Will be in MMDDYYYY

Date of Termination

Termination Date

8

Will be in MMDDYYYY

Gross Wages Pay Period

Current Pay Period Gross Pay

11

No Decimal Places, No Commas

Traditional Deferral Amount

Current Payroll Pretax Contribution

11

No Decimal Places, No Commas

Loan Repayment

401K Loan 1 Repayment

11

No Decimal Places, No Commas

ER Match

Current Payroll Employer Match Contribution

11

No Decimal Places, No Commas

Profit Sharing

Current Payroll Non Elective Contribution

11

No Decimal Places, No Commas

Roth Deferral Amount

Current Payroll Employee Roth Contribution

11

No Decimal Places, No Commas

Current Pay Period Hours

Current Pay Period Hours Worked

4

No Decimal Places, No Commas

Division Code

 

5

 

External Payroll Id

Employee Number

25

 

Extra Spaces for Future Fields

 

192

 

scroll to top icon