Standard 401k to CalSavers Census
Dec 20, 2024
This article will describe the file transformation that has been created in detamoov to transform the standard 401k file format to the CalSavers Payroll Census AscensusX fixed length file specifications. This transformation is used in a detamoov integration with CalSavers.
|
Source File |
Destination File |
|
Standard 401k |
CalSavers Payroll Census Fixed Length |
|
File Type Generated |
Fixed length |
|
Header Row(s) Generated |
Yes |
|
Footer Row(s) Generated |
Yes |
|
End of Row Character |
CRLF |
|
File Naming Generated |
<Program>_<EIN>_<EmployeeCensus/8X>_ASTRO_AscensusXFmt_YYYYMMDD_HHMMSS_ <sequence>_<Client specified>.txt |
Header Record:
| CalSavers Field Name | Field Size | Standard 401k Field Name | Details |
| Header Record | 5 | Hardcoded to HDR | |
| File Type | 12 | Hardcoded to CENS | |
| Employer ID (BIN) | 20 | COMPANY EIN | For OR it is the BIN, else it is a generated ID |
| Blank Spaces | 1 | ||
| Client Name | 15 | LEGAL COMPANY NAME | |
| Blank Spaces | 183 |
Body:
| CalSavers Field Name | Field Size | Standard 401k Field Name | Details |
| Detail record | 5 | Hardcoded to DTL | |
| Soc. Sec # | 12 | SSN | Numeric Only |
| Last Name | 20 | LAST NAME | |
| Middle Name | 1 | MIDDLE NAME/INITIAL | |
| First Name | 15 | FIRST NAME | |
| Location Code | 10 | Three digit payroll number Including leading zeros This should be requested from the employer or Payroll Provider support |
|
| Employee Number | 10 | ||
| Physical Address Line 1 | 30 | ADDRESS LINE 1 | |
| Physical Address Line 2 | 30 | ADDRESS LINE 2 | |
| Physical City | 23 | CITY | |
| Physical State | 2 | STATE | |
| Physical Zip Code | 10 | ZIP | Five or nine digit number |
| Gender | 1 | GENDER | 1=Male 2=Female |
| Date of Birth | 8 | DOB | MMDDYYYY |
| Current Hire Date | 8 | HIRE DATE | MMDDYYYY |
| Current Termination Date | 8 | TERMINATION DATE | MMDDYYYY |
| Prior Hire Date | 8 | MMDDYYYY | |
| Prior Termination Date | 8 | MMDDYYYY | |
| Estimated Annual Comp | 10 | ||
| Thousand Hours Service Code | 1 | ||
| Number of Federal Exemptions | 3 | ||
| Marital Status | 1 | MARITAL STATUS | Blank=Not Reported 1=Married 2=Divorced 3=Separated 4=Single 5=Widowed |
| Employee Status Code | 4 | EMPLOYEE STATUS | 0001=Termed <500 hours 0002=Termed>500 hours 0003=Active 0004=Deceased 0005=Disabled 0006=Unpaid Leave 0007=Retired |
| Payroll Frequency Code | 1 | ||
| Highly Compensated Code | 1 | ||
| Insider Code | 1 | ||
| Union Classification Code | 1 | ||
| Payroll Status Code | 4 |
Footer:
| CalSavers Field Name | Field Size | Standard 401k Field Name | Details |
| Total Record | 5 | Hardcoded to TOT | |
| Total Number of Records | 12 | Custom Field | |
| Filler | 219 |
