This article will describe the file transformation that has been created in detamoov to transform the standard 401k file format to the Alerus file specifications. This transformation is used in a detamoov integration with Alerus.
| Source File | Destination file |
| Standard 401k | Alerus |
File Specifications
| File Type Generated | CSV |
|
Header Row(s) Generated |
No |
| Footer Row(s) Generated | Yes |
| End of Row Character | CRLF (Carriage Return Line Feed) |
| File Naming Generated | [PLANID]_current date in YYYYMMDD]_[current time in HHMMSSS].csv |
Field Mappings
The table below details the specific field mapping and transformation rules applied to ensure the Alerus Payroll Contribution csv format is created correctly from the standard 401k format.
BODY
| Alerus Field Name | Standard 401k Field Name | Field size | Details |
| Social Security Number | SSN | 9 | Format SSN, Remove (-) |
| Last Name, First Name MI | LAST NAME AND FIRST NAME | 30 | Concatenate using a comma and space |
| Street Address 1 | ADDRESS LINE 1 | 40 | |
| Street Address 2 | ADDRESS LINE 2 | 40 | |
| City | CITY | 28 | |
| State | STATE | 3 | 2 character state code |
| Zip + 4 | ZIP | Format zip transformation, remove dash | |
| Division/Location | 4 | ||
| Date of Birth | DOB | 8 | YYYYMMDD |
| Original Date of Hire | HIRE DATE | 8 | YYYYMMDD |
| Date of Eligibility | 8 | YYYYMMDD | |
| Date of Rehire | REHIRE DATE | 8 | YYYYMMDD |
| Date of Term | TERMINATION DATE | 8 | YYYYMMDD |
| Current Pay Period - hours | CURRENT PAY PERIOD HOURS WORKED | 8 | Round to 2 decimal places |
| Current Pay Period - Gross Compensation | CURRENT PAY PERIOD GROSS PAY | 15 | Round to 2 decimals places |
| Current Pay Period - Excluded Compensation | 15 | ||
| Current Pay Period - Employee Deferral | CURRENT PAYROLL EMPLOYEE PRETAX CONTRIBUTION | 10 | Round to 2 decimal places |
| Current Pay Period - Employee Roth Deferral | CURRENT PAYROLL EMPLOYEE ROTH CONTRIBUTION | 10 | Round to 2 decimal places |
| Current Pay Period - Employer Match | CURRENT PAYROLL EMPLOYER MATCH CONTRIBUTION | 10 | Round to 2 decimal places |
| Current Pay Period - Employer Discretionary | 10 | Round to 2 decimal places | |
| Current Pay Period - Employee After -Tax Deferrals | CURRENT PAYROLL EMPLOYEE POSTTAX CONTRIBUTION | 10 | Round to 2 decimal places |
| Current Pay Period - Safe Harbor Profit Sharing | CURRENT PAYROLL SAFE HARBOT NON ELECTIVE CONTRIBUTION | 10 | Round to 2 decimal places |
| Current Pay Period - Safe Harbor Match | CURRENT PAYROLL SAFE HARBOR EMPLOYER MATCH | 10 | Round to 2 decimal places |
| Current Pay Period - Pension | CURRENT PAYROLL QUALIFIED ELECTIVE CONTRIBUTION | 10 | Round to 2 decimal places |
| Current Pay Period - Loan Payments | 401K LOAN 1 REPAYMENT | 10 | Round to 2 decimal places |
| Payroll Frequency | PAY PERIOD START DATE, PAY PERIOD END DATE | 1 |
WEEKLY = 7 BI-WEEKLY = 6 SEMI-MONTHLY = 5 MPNTHLY = 4 |
| Company Email Address | |||
| Personal Email Address | 50 | ||
| Mobile Phone Number | PHONE | 20 |
Only Digits |
FOOTER
| Placeholder | |||
| Payroll Date | PAYROLL CHECK DATE | 8 | YYYYMMDD |
| Multi ACH Acct ID | 40 | ||
| Placeholder | |||
| Placeholder | |||
| Placeholder | |||
| Placeholder | |||
| Placeholder | |||
| Placeholder | |||
| Placeholder | |||
| Placeholder | |||
| Placeholder | |||
| Placeholder | |||
| Placeholder | |||
| Placeholder | |||
| Placeholder | |||
| Total Current Pay Period - Employee Deferral | CURRENT PAYROLL EMPLOYEE PRETAX CONTRIBUTION | 10 |
Sums value across all employees contributing Round to 2 decimal places |
| Total Current Pay Period - Employee Roth Deferral | CURRENT PAYROLL EMPLOYEE ROTH CONTRIBUTION | 10 |
Sums value across all employees contributing Round to 2 decimal places |
| Total Current Pay Period - Employer Match | CURRENT PAYROLL EMPLOYER MATCH CONTRIBUTION | 10 |
Sums value across all employees contributing Round to 2 decimal places |
| Total Current Pay Period - Employer Discretionary | 10 |
Sums value across all employees contributing Round to 2 decimal places |
|
| Total Current Pay Period - Employee After-tax Deferrals | CURRENT PAYROLL EMPLOYEE POSTTAX CONTRIBUTION | 10 |
Sums value across all employees contributing Round to 2 decimal places |
| Total Current Pay Period - Safe Harbor Profit Sharing | CURRENT PAYROLL SAFE HARBOR NON ELECTIVE CONTRIBUTION | 10 |
Sums value across all employees contributing Round to 2 decimal places |
| Total Current Pay Period - Safe Harbor Match | CURRENT PAYROLL SAFE HARBOR EMPLOYER MATCH | 10 |
Sums value across all employees contributing Round to 2 decimals places |
| Total Current Pay Period - Pension | CURRENT PAYROLL QUALIFIED ELECTIVE CONTRIBUTION | 10 |
Sums value across all employees contributing Round to 2 decimals places |
| Total Current Pay Period - Loan | 401K LOAN 1 REPAYMENT | 10 |
Sums value across all employees contributing Round to 2 decimal places |
| Placeholder | |||
| Placeholder |
