Standard 401k to BPAS
Jun 01, 2023
This article will describe the file transformation that has been created in detamoov to transform the standard 401k file format to the BPAS file specifications. This transformation is used in a detamoov integration with BPAS.
| Source file | Destination file |
| Standard 401k | BPAS |
File Specifications
| File Type Generated | Fixed Length |
| Header Row(s) Generated | No |
| Footer Rows(s) Generated | No |
| End of Row Character | |
| File Naming Generated |
Production: FTP__[Plan specific]__TEXT_[PLAN ID].txt Testing: TEST__FTP__[Plan specific]__TEXT_[PLAN ID].txt |
Field Mappings
The table below details that specific field mapping and transformation rules applied to BPAS Payroll Contribution fixed length format is created correctly from the standard 401k format.
BODY
| BPAS Field Name | Standard 401k Field Name | Position | Field Size | Notes |
| Social Security Number | SSN | 1 | 9 | Format SSN, remove dashes |
| First Name and Initial | FIRST NAME AND MIDDLE NAME/INITIAL | 10 | 20 | Concatenate with space separator, left each delimited part |
| Last Name | LAST NAME | 30 | 20 | |
| Date of Birth | DOB | 50 | 8 | Date format conversion |
| Original Date of Hire | HIRE DATE | 58 | 8 | Date format conversion |
| Date of Termination | TERMINATION DATE | 66 | 8 | Space fill if N/A |
| Year to Date Hours | YTD HOURS WORKED | 74 | 6 | 1 decimal or 1 assumed |
| Gender Code | GENDER | 80 | 1 | |
| Year to Date Compensation | YTD GROSS PAY | 81 | 9 | 2 decimals or 2 assumed |
| BPAS Plan Number | PLAN ID | 90 | 6 | |
| Filler | 96 | 1 | ||
| Filler | 97 | 6 | ||
| Contribution Source Code 1 | 103 | 1 | ||
| Contribution Source (Name) Amount per Pay Period | 104 | 8 | 2 decimals or 2 assumed | |
| Contribution Source Code 2 | 112 | 1 | ||
| Contribution Source (Name) Amount per Pay Period | 113 | 8 | 2 decimals or 2 assumed | |
| Contribution Source Code 3 | 121 | 1 | ||
| Contribution Source (Name) Amount per Pay Period | 122 | 8 | 2 decimals or 2 assumed | |
| Contribution Source Code 4 | 130 | 1 | ||
| Contribution Source (Name) Amount per Pay Period | 131 | 8 | 2 decimals or 2 assumed | |
| Contribution Source Code 5 | 139 | 1 | ||
| Contribution Source (Name) Amount per Pay Period | 140 | 8 | 2 decimals or 2 assumed | |
| Contribution Source Code 6 | 148 | 1 | ||
| Contribution Source (Name) Amount per Pay Period | 149 | 8 | 2 decimals or 2 assumed | |
| Contribution Source Code 7 | 157 | 1 | ||
| Contribution Source (Name) Amount per Pay Period | 158 | 8 | 2 decimals or 2 assumed | |
| Contribution Source Code 8 | 166 | 1 | ||
| Contribution Source (Name) Amount per Pay Period | 167 | 8 | 2 decimals or 2 assumed | |
| Division Code | 175 | 4 | ||
| Address Line 1 | ADDRESS LINE 1 | 179 | 30 | |
| Address Line 2 | ADDRESS LINE 2 | 209 | 30 | |
| City | CITY | 239 | 20 | |
| State | STATE | 259 | 2 | 2-digit state code |
| Filler | 261 | 2 | ||
| Zip Code (first 5 numbers) | Zip Code | 263 | 5 | take first 5 chars |
| Zip plus 4(extension) | Zip Code | 268 | 4 | format zip with dash, split by dash, take index 1 |
| Loan Processing Code | 401k LOAN 1 ID | 272 | 1 | |
| Loan Payment Amount | 401K LOAN 1 REPAYMENT | 273 | 7 | 2 decimals or 2 assumed |
| Loan Processing Code | 280 | 1 | ||
| Loan Payment Amount | 401K LOAN 2 ID | 281 | 7 | 2 decimals or 2 assumed |
| Loan Processing Code | 401K LOAN 2 REPAYMENT | 288 | 1 | |
| Loan Payment Amount | 289 | 7 | ||
| Loan Processing Code | 296 | 1 | ||
| Loan Payment Amount | 297 | 7 | ||
| Loan Processing Code | 304 | 1 | ||
| Loan Payment Amount | 305 | 7 | ||
| Loan Processing Code | 312 | 1 | ||
| Loan Payment Amount | 313 | 7 | ||
| Loan Processing Code | 320 | 1 | ||
| Loan Payment Amount | 321 | 7 | ||
| Loan Processing Code | 328 | 1 | ||
| Loan Payment Amount | 329 | 7 | ||
| Loan Processing Code | 336 | 1 | ||
| Loan Payment Amount | 337 | 7 | ||
| Filler | 344 | 7 | ||
| Re-hire Date | REHIRE DATE | 351 | 8 | space fill if N/A |
| Pay Date | PAYROLL CHECK DATE | 359 | 8 | |
| Excluded employee | 367 | 1 | ||
| Filler | 368 | 17 | ||
| Email Address | 385 | 50 | ||
| Employee ID | EMPLOYEE NUMBER | 435 | 13 | |
| Filler | 448 | 53 |
