This article will describe the file transformation that has been created in detamoov to transform the standard 401k file format to the Alerus 3(16) - plans with multiple loans file specifications. This transformation is used in a detamoov integration with Alerus.
| Source File | Destination files |
| Standard 401k | Alerus 3(16) multiple Loans |
File Specifications
| File Type Generated | CSV (multi-record) |
|
Header Row(s) Generated |
No |
| Footer Row(s) Generated | Yes |
| End of Row Character | CRLF (Carriage Return Line Feed) |
| File Names 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 table below details the specific field mapping and transformation rules applied to ensure the Alerus 3(16) Multi Loan Payroll Contribution csv formats are created correctly from the standard 401k format.
|
Field |
Alerus Field Name |
Standard 401k Field Name |
Details |
|
1 |
Social Security Number |
SSN |
Numeric only |
|
2 |
Last Name, First Name MI |
LAST NAME |
Concatenate |
|
3 |
Street Address 1 |
ADDRESS LINE 1 |
|
|
4 |
Street Address 2 |
ADDRESS LINE 2 |
|
|
5 |
City |
CITY |
|
|
6 |
State |
STATE |
|
|
7 |
Zip + 4 |
ZIP |
Numeric only |
|
8 |
Division/Location/Excluded Employees |
|
Field Override |
|
9 |
Date of Birth |
DOB |
YYYYMMDD |
|
10 |
Original Date of Hire |
HIRE DATE |
YYYYMMDD |
|
11 |
Placeholder |
|
YYYYMMDD |
|
12 |
Date of Rehire |
REHIRE DATE |
YYYYMMDD |
|
13 |
Date of Term |
TERMINATION DATE |
YYYYMMDD |
|
14 |
Current Pay Period - Hours |
CURRENT PAY PERIOD HOURS WORKED |
Round to 2 decimal places |
|
15 |
Current Pay Period - Gross Compensation |
CURRENT PAY PERIOD GROSS PAY |
Round to 2 decimal places |
|
16 |
Current Pay Period - Excluded Compensation |
|
|
|
17 |
Current Pay Period - Employee Deferral |
CURRENT PAYROLL EMPLOYEE PRETAX CONTRIBUTION |
Round to 2 decimal places |
|
18 |
Current Pay Period - Employee Roth Deferral |
CURRENT PAYROLL EMPLOYEE ROTH CONTRIBUTION |
Round to 2 decimal places |
|
19 |
Current Pay Period - Employer Match |
CURRENT PAYROLL EMPLOYER MATCH CONTRIBUTION |
Round to 2 decimal places |
|
20 |
Current Pay Period - Employer Discretionary |
|
Round to 2 decimal places |
|
21 |
Current Pay Period - Employee After-Tax Deferrals |
CURRENT PAYROLL EMPLOYEE POSTTAX CONTRIBUTION |
Round to 2 decimal places |
|
22 |
Current Pay Period - Safe Harbor Profit Sharing |
CURRENT PAYROLL SAFE HARBOR NON ELECTIVE CONTRIBUTION |
Round to 2 decimal places |
|
23 |
Current Pay Period - Safe Harbor Match |
CURRENT PAYROLL SAFE HARBOR EMPLOYER MATCH |
Round to 2 decimal places |
|
24 |
Current Pay Period - Pension |
CURRENT PAYROLL QUALIFIED ELECTIVE CONTRIBUTION |
Round to 2 decimal places |
|
25 |
Current Pay Period - Loan Payments |
401k LOAN 1 REPAYMENT |
Round to 2 decimal places |
|
26 |
Payroll Frequency |
PAY PERIOD START DATE |
WEEKLY = 7 |
|
27 |
Employee Type |
RESERVED FIELD |
N/A = 0 |
|
28 |
Expected Annual Salary |
|
|
|
29 |
Company Email Address |
|
|
|
30 |
Personal Email Address |
|
|
|
31 |
Mobile Phone Number |
PHONE |
Numeric only |
|
Field |
Alerus Field Name |
Standard 401k Field Name |
Details |
|
1 |
Placeholder |
|
|
|
2 |
Payroll Date |
PAYROLL CHECK DATE |
YYYYMMDD |
|
3 |
Multi ACH Acct ID |
|
moov configuration override if needed |
|
4 |
Placeholder |
|
|
|
5 |
Placeholder |
|
|
|
6 |
Placeholder |
|
|
|
7 |
Placeholder |
|
|
|
8 |
Placeholder |
|
|
|
9 |
Placeholder |
|
|
|
10 |
Placeholder |
|
|
|
11 |
Placeholder |
|
|
|
12 |
Placeholder |
|
|
|
13 |
Placeholder |
|
|
|
14 |
Placeholder |
|
|
|
15 |
Placeholder |
|
|
|
16 |
Placeholder |
|
|
|
17 |
Total Current Pay Period - Employee Deferral |
CURRENT PAYROLL EMPLOYEE PRETAX CONTRIBUTION |
Sum of all employees |
|
18 |
Total Current Pay Period - Employee Roth Deferral |
CURRENT PAYROLL EMPLOYEE ROTH CONTRIBUTION |
Sum of all employees |
|
19 |
Total Current Pay Period - Employer Match |
CURRENT PAYROLL EMPLOYER MATCH CONTRIBUTION |
Sum of all employees |
|
20 |
Total Current Pay Period - Employer Discretionary |
|
Sum of all employees |
|
21 |
Total Current Pay Period - Employee After-Tax Deferrals |
CURRENT PAYROLL EMPLOYEE POSTTAX CONTRIBUTION |
Sum of all employees |
|
22 |
Total Current Pay Period - Safe Harbor Profit Sharing |
CURRENT PAYROLL SAFE HARBOR NON ELECTIVE CONTRIBUTION |
Sum of all employees |
|
23 |
Total Current Pay Period - Safe Harbor Match |
CURRENT PAYROLL SAFE HARBOR EMPLOYER MATCH |
Sum of all employees |
|
24 |
Total Current Pay Period - Pension |
CURRENT PAYROLL QUALIFIED ELECTIVE CONTRIBUTION |
Sum of all employees |
|
25 |
Total Current Pay Period - Loan Payments |
|
|
|
26 |
Placeholder |
|
|
|
27 |
Placeholder |
|
|
A separate loan record will be created for each active loan for an employee.
|
Alerus Field Name |
Standard 401k Field Name |
Details |
|
Social Security Number |
SSN |
Numeric only |
|
Last Name, First Name MI |
LAST NAME |
Concatenate |
|
Loan Number |
401K LOAN 1 ID OR |
|
|
Loan Payment Amount |
401K LOAN 1 REPAYMENT OR |
Round to 2 decimals |
|
Division/Location |
|
Field Override |
|
Payroll Frequency |
PAY PERIOD START DATE |
WEEKLY = 7 |
|
Field |
Alerus Field Name |
Standard 401k Field Name |
Details |
|
1 |
Placeholder |
|
|
|
2 |
Payroll Date |
PAYROLL CHECK DATE |
YYYYMMDD |
|
3 |
Placeholder |
|
|
|
4 |
Total Loan Amount |
401k LOAN 1 REPAYMENT |
Sum of all employee loans |
|
5 |
Placeholder |
|
|
|
6 |
Placeholder |
|
|
