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 for client plans that allow for multiple employee loans.
| Source File | Destination file |
| Standard 401k | Alerus - plans with multiple loans |
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 |
Contributions: [PLANID]_current date in YYYYMMDD]_[current time in HHMMSSS].csv Loans: [PLANID]L_[current date in YYYYMMDD]_[current time in HHMMSSS].csv |
Field Mappings
The tables below detail the specific field mapping and transformation rules applied to ensure the Alerus Payroll Contribution and Loan csv formats are created correctly from the standard 401k format.
| 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 | |||
| 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 |
| Alerus Field Name | Standard 401k Field Name | Field size | Details |
| 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 |
|
||
| Placeholder | |||
| Placeholder |
A separate loan record will be created for each active loan for an employee.
| 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 |
| Loan Number |
401K LOAN 1 ID 40K LOAN 2 ID |
3 | |
| Loan Payment Amount |
401K LOAN 1 REPAYMENT 401K LOAN 2 REPAYMENT |
10 | Round to 2 decimal places |
| Division/Location | 4 | ||
| Payroll Frequency | PAY PERIOD START DATE PAY PERIOD END DATE |
1 |
WEEKLY = 7 BI-WEEKLY = 6 SEMI-MONTHLY = 5 MPNTHLY = 4 |
| Alerus Field Name | Standard 401k Field Name | Field size | Details |
| Placeholder | |||
| Payroll Date | PAYROLL CHECK DATE | 8 | YYYYMMDD |
| Placeholder | 40 | ||
| Total Loan Amount |
401K LOAN 1 REPAYMENT 401K LOAN 2 REPAYMENT |
10 |
Sum across all employee loans Round to 2 decimal places |
| Placeholder | |||
| Placeholder |
