Standard 401k to Principal IPP
May 08, 2025
This article will describe the file transformation that has been created in detamoov to transform the standard 401k file format to the Principal IPP Format file specifications. This transformation is used in a detamoov integration with Principal.
| Source File | Destination file |
| Standard 401k | Principal IPP Format |
File Specifications
| File Type Generated | Fixed Length |
|
Header Row(s) Generated |
Yes |
| Footer Row(s) Generated | No |
| End of Row Character | CRLF (Carriage Return Line Feed) |
| File Naming Generated | [PLAN ID][Remittance Group][Date in YYYYMMDDHHMMSS].txt |
Field Mappings
The table below details the specific field mapping and transformation rules applied to ensure the Principal IIP Format Payroll Contribution .txt format is created correctly from the standard 401k format.
Header
| Field | Standard 401k Field Name | Field Size | Field Start | Field End | Hardcode Value | Details |
| 1 | 9 | 1 | 9 | $$ADD ID= | ||
| 2 | PLAN ID | 9 | 10 | 18 | Principal Plan Code | |
| 3 | 5 | 19 | 23 | BID=' | ||
| 4 | PLAN ID | 9 | 24 | 32 | Principal Plan Code | |
| 5 | 5 | 33 | 37 | Remittance Group # | ||
| 6 | 1 | 38 | 38 | ' | apostrophe |
Body
| Principal IPP Field name | Standard 401k Field Name | Field Size | Field Start | Field End | Details |
| Contract Number | PLAN ID | 6 | 1 | 6 | |
| Pay Date | PAYROLL CHECK DATE | 10 | 7 | 16 | MM/DD/YYYY |
| Social Security Number | SSN | 11 | 17 | 27 | Format SSN w/dashes |
| Birth Date | DOB | 10 | 28 | 37 | |
| Current Employment Date | HIRE DATE REHIRE DATE |
10 | 38 | 47 | Most recent hire date |
| Employee Contribution 1 Amount | Custom Per Plan | 12 | 48 | 59 | Plan specific mapping Implied 2 decimal places Zero fill |
| Employee Contribution 2 Amount | Custom Per Plan | 12 | 60 | 71 | Plan specific mapping Implied 2 decimal places Zero fill |
| Employee Contribution 3 Amount | Custom Per Plan | 12 | 72 | 83 | Plan specific mapping Implied 2 decimal places Zero fill |
| Employee Contribution 4 Amount | Custom Per Plan | 12 | 84 | 95 | Plan specific mapping Implied 2 decimal places Zero fill |
| Employee Contribution 5 Amount | Custom Per Plan | 12 | 96 | 107 | Plan specific mapping Implied 2 decimal places Zero fill |
| Employer Contribution 1 Amount | Custom Per Plan | 12 | 108 | 119 | Plan specific mapping Implied 2 decimal places Zero fill |
| Employer Contribution 2 Amount | Custom Per Plan | 12 | 120 | 131 | Plan specific mapping Implied 2 decimal places Zero fill |
| Employer Contribution 3 Amount | Custom Per Plan | 12 | 132 | 143 | Plan specific mapping Implied 2 decimal places Zero fill |
| Employer Contribution 4 Amount | Custom Per Plan | 12 | 144 | 155 | Plan specific mapping Implied 2 decimal places Zero fill |
| Employer Contribution 5 Amount | Custom Per Plan | 12 | 156 | 167 | Plan specific mapping Implied 2 decimal places Zero fill |
| Other Contribution 1 Amount | Custom Per Plan | 12 | 168 | 179 | Plan specific mapping Implied 2 decimal places Zero fill |
| Other Contribution 2 Amount | Custom Per Plan | 12 | 180 | 191 | Plan specific mapping Implied 2 decimal places Zero fill |
| Other Contribution 3 Amount | Custom Per Plan | 12 | 192 | 203 | Plan specific mapping Implied 2 decimal places Zero fill |
| Other Contribution 4 Amount | Custom Per Plan | 12 | 204 | 215 | Plan specific mapping Implied 2 decimal places Zero fill |
| Other Contribution 5 Amount | Custom Per Plan | 12 | 216 | 227 | Plan specific mapping Implied 2 decimal places Zero fill |
| Loan ID 1 | 401K LOAN 1 ID | 3 | 228 | 230 | |
| Loan Payment 1 Amount | 401K LOAN 1 REPAYMENT | 12 | 231 | 242 | Implied 2 decimal places Zero fill |
| Loan Additional Principal Payment | 12 | 243 | 254 | ||
| Loan ID 2 | 401K LOAN 2 ID | 3 | 255 | 257 | |
| Loan Payment 2 Amount | 401K LOAN 2 REPAYMENT | 12 | 258 | 269 | Implied 2 decimal places Zero fill |
| Loan Additional Principal Payment | 12 | 270 | 281 | ||
| Loan ID 3 | 3 | 282 | 284 | ||
| Loan Payment 3 Amount | 12 | 285 | 296 | ||
| Loan Additional Principal Payment | 12 | 297 | 308 | ||
| Loan ID 4 | 3 | 309 | 311 | ||
| Loan Payment 4 Amount | 12 | 312 | 323 | ||
| Loan Additional Principal Payment | 12 | 324 | 335 | ||
| Loan ID 5 | 3 | 336 | 338 | ||
| Loan Payment 5 Amount | 12 | 339 | 350 | ||
| Loan Additional Principal Payment | 12 | 351 | 362 | ||
| Compensation 0 | 12 | 363 | 374 | Plan or ADP Comp (YTD preferred) | |
| Compensation 1 | YTD Gross Pay | 12 | 375 | 386 | Gross or 415 Comp (YTD preferred) |
| Compensation 2 | 12 | 387 | 398 | Excluded Pay (YTD preferred) | |
| Compensation 3 | 12 | 399 | 410 | Section 125 (YTD preferred) | |
| Compensation 4 (Annualized Salary) | 12 | 411 | 422 | Estimated annual income | |
| Compensation 5 | 12 | 423 | 434 | ||
| First Name | FIRST NAME | 25 | 435 | 459 | |
| Middle Initial | MIDDLE NAME/INITIAL | 1 | 460 | 460 | |
| Last Name | LAST NAME | 25 | 461 | 485 | |
| Blank Fill | 30 | 486 | 515 | ||
| Alternate ID | EMPLOYEE NUMBER | 20 | 516 | 535 | |
| Address Line 1 | ADDRESS LINE 1 | 50 | 536 | 585 | No Special Characters |
| Address Line 2 | ADDRESS LINE 2 | 50 | 586 | 635 | No Special Characters |
| Address Line 3 | 50 | 636 | 685 | No Special Characters | |
| City | CITY | 30 | 686 | 715 | |
| State | STATE | 2 | 716 | 717 | |
| Zip Code +4 | ZIP | 10 | 718 | 727 | Format zip +4 |
| Contry Code | 2 | 728 | 729 | Hardcoded: US | |
| Blank Fill | 1 | 730 | 730 | ||
| Home Phone | PHONE | 24 | 731 | 754 | ###-###-#### |
| Work Phone | PHONE | 24 | 755 | 778 | ###-###-#### |
| Blank Fill | 24 | 779 | 802 | ||
| Work Email | 75 | 803 | 877 | ||
| Personal Email | 75 | 878 | 952 | ||
| Division | 20 | 953 | 972 | ||
| Blank Fill | 10 | 973 | 982 | ||
| Sub-Division | 10 | 983 | 992 | ||
| Blank Fill | 10 | 993 | 1002 | ||
| Location | 7 | 1003 | 1009 | ||
| Benefit Event Code | EMPLOYMENT STATUS | 2 | 1010 | 1011 | 1 = Termination 3 = Retirement 5 = Death 7 = Disability 50 = Retire Continue to Work 9 = Other/Transfer (Change in Control for Non-Qualified) |
| Benefit End Date | EMPLOYMENT STATUS TERMINATION DATE |
10 | 1012 | 1021 | MM/DD/YYYY Return Term Date if Status is T,R,D |
| Leave of Absence Code | 2 | 1022 | 1023 | ||
| Blank Fill | 1 | 1024 | 1024 | ||
| Leave of Absence Begin Date | 10 | 1025 | 1034 | ||
| Leave of Absence End Date | 10 | 1035 | 1044 | ||
| Hours | YTD HOURS WORKED | 8 | 1045 | 1052 | Explicit decimal Round force 2 |
| Pay Frequency | PAY PERIOD START DATE PAY PERIOD END DATE |
1 | 1053 | 1053 | 1 = Daily 2 = Weekly 3 = Semi-Monthly 4 = Monthly 5 = Annual 6 = One-Time 7 = Quarterly 8 = Semi-Annual 9 = Bi-Weekly |
| Gender | GENDER | 1 | 1054 | 1054 | 1 = Male 2 = Female |
| Preferred Language Code | 1 | 1055 | 1055 | ||
| Actual Married Status | MARRIAGE STATUS | 1 | 1056 | 1056 | 1 = Married 2 = Single 3 = Legally Separated |
| Blank Fill | 10 | 1057 | 1066 | ||
| Union/Bargaining Status | 1 | 1067 | 1067 | 1 = Union-bargaining 2 = Not Union 3 = Union-Nonbar gaining |
|
| Blank Fill | 10 | 1068 | 1077 | ||
| Key Employee Indicator | KEY EMPLOYEE | 1 | 1078 | 1078 | 1 = Nonkey 2 = Officer 4 = Greater than 5% Owner 5 = Greater than 1% Owner 6 = Former Key |
| Blank Fill | 10 | 1079 | 1088 | ||
| Highly Compensated Status | HIGHLY COMPENSATED EMPLOYEE | 1 | 1089 | 1089 | 1 = Yes 2 = No |
| Blank Fill | 10 | 1090 | 1099 | ||
| Leased Status | 1 | 1100 | 1100 | ||
| Blank Fill | 10 | 1101 | 1110 | ||
| Non-Resident Alien Indicator | 1 | 1111 | 1111 | ||
| Blank Fill | 10 | 1112 | 1121 | ||
| Independent Contractor Indicator | 1 | 1122 | 1122 | ||
| Blank Fill | 10 | 1123 | 1132 | ||
| Employer | 3 | 1133 | 1135 | ||
| Blank Fill | 10 | 1136 | 1145 | ||
| Employment Method | 1 | 1146 | 1146 | ||
| Blank Fill | 10 | 1147 | 1156 | ||
| Employment Condition | 1 | 1157 | 1157 | 1 = Full Time 2 = Part Time 3 = Seasonal 4 = Temporary |
|
| Blank Fill | 10 | 1158 | 1167 | ||
| Compensation Basis | 1 | 1168 | 1168 | 1 = Salaried 2 = Hourly 3 = Commission 4 = Non-Commission 5 = Non-Hourly 6 = Non-Salaried |
|
| Blank Fill | 10 | 1169 | 1178 | ||
| Override Eligibility Date 1 | 10 | 1179 | 1188 | ||
| Override Eligibility Date 2 | 10 | 1189 | 1198 | ||
| Override Eligibility Date 3 | 10 | 1199 | 1208 | ||
| Term Reason Code | 1 | 1209 | 1209 | ||
| Resident of Puerto Rico | 1 | 1210 | 1210 | ||
| Blank Fill | 10 | 1211 | 1220 | ||
| Prevailing Wage | 1 | 1221 | 1221 | ||
| Blank Fill | 10 | 1222 | 1231 | ||
| Student | 1 | 1232 | 1232 | ||
| Blank Fill | 10 | 1233 | 1242 | ||
| Covered by 401k 403b or 457 Plan | 1 | 1243 | 1243 | ||
| Blank Fill | 10 | 1244 | 1253 | ||
| Covered by Another Pension Plan | 1 | 1254 | 1254 | ||
| Blank Fill | 10 | 1255 | 1264 | ||
| Covered by Another Profit Sharing Plan | 1 | 1265 | 1265 | ||
| Blank Fill | 10 | 1266 | 1275 | ||
| Blank Fill | 2 | 1276 | 1277 | ||
| Blank Fill | 10 | 1278 | 1287 | ||
| Blank Fill | 10 | 1288 | 1297 | ||
| Blank Fill | 10 | 1298 | 1307 | ||
| Blank Fill | 10 | 1308 | 1317 | ||
| Blank Fill | 10 | 1318 | 1327 | ||
| Blank Fill | 10 | 1328 | 1337 | ||
| Blank Fill | 10 | 1338 | 1347 | ||
| Blank Fill | 10 | 1348 | 1357 | ||
| Job Code | 32 | 1358 | 1389 | ||
| Custom Code 1 | 10 | 1390 | 1399 | ||
| Custom Code 2 | 10 | 1400 | 1409 | ||
| Custom Code 3 | 10 | 1410 | 1419 | ||
| Custom Code 4 | 10 | 1420 | 1429 | ||
| Custom Code 5 | 10 | 1430 | 1439 | ||
| Custom Code 6 | 10 | 1440 | 1449 | ||
| Custom Integer 1 | 8 | 1450 | 1457 | ||
| Custom Integer 2 | 8 | 1458 | 1465 | ||
| Custom Integer 3 | 8 | 1466 | 1473 | ||
| Custom Integer 4 | 8 | 1474 | 1481 | ||
| Custom Integer 5 | 8 | 1482 | 1489 | ||
| Custom Integer 6 | 8 | 1490 | 1497 | ||
| Custom Date 1 | 10 | 1498 | 1507 | ||
| Custom Date 2 | 10 | 1508 | 1517 | ||
| Custom Date 3 | 10 | 1518 | 1527 | ||
| Custom Date 4 | 10 | 1528 | 1537 | ||
| Custom Date 5 | 10 | 1538 | 1547 | ||
| Custom Date 6 | 10 | 1548 | 1557 | ||
| Custom Decimal 1 | 19 | 1558 | 1576 | ||
| Custom Decimal 2 | 19 | 1577 | 1595 | ||
| Custom Decimal 3 | 19 | 1596 | 1614 | ||
| Custom Decimal 4 | 19 | 1615 | 1633 | ||
| Custom Decimal 5 | 19 | 1634 | 1652 | ||
| Custom Decimal 6 | 19 | 1653 | 1671 | ||
| Blank Fill | 3 | 1672 | 1674 | ||
| Blank Fill | 3 | 1675 | 1677 | ||
| Blank Fill | 3 | 1678 | 1680 | ||
| Blank Fill | 3 | 1681 | 1683 | ||
| Blank Fill | 3 | 1684 | 1686 | ||
| Blank Fill | 7 | 1687 | 1693 | ||
| Blank Fill | 7 | 1694 | 1700 | ||
| Blank Fill | 7 | 1701 | 1707 | ||
| Blank Fill | 7 | 1708 | 1714 | ||
| Blank Fill | 7 | 1715 | 1721 | ||
| Custom Code 17 | 10 | 1722 | 1731 | ||
| Custom Pay Status | 4 | 1732 | 1735 | ||
| Custom Reporting Field 1 | 50 | 1736 | 1785 | ||
| Custom Employment Status Code | 4 | 1786 | 1789 | ||
| Class Code | 5 | 1790 | 1794 | ||
| Pay Period End Date | PAY PERIOD END DATE | 10 | 1795 | 1804 | MM/DD/YYYY |
| Blank Fill | 10 | 1805 | 1814 | ||
| Prior Term Date 1 | 10 | 1815 | 1824 | ||
| Blank Fill | 10 | 1824 | 1834 | ||
| Blank Fill | 10 | 1835 | 1844 | ||
| Blank Fill | 10 | 1845 | 1854 | ||
| Blank Fill | 10 | 1855 | 1864 | ||
| Blank Fill | 10 | 1865 | 1874 | ||
| Blank Fill | 10 | 1875 | 1884 | ||
| Blank Fill | 10 | 1885 | 1894 | ||
| Blank Fill | 10 | 1895 | 1904 | ||
| Over FICA WAGE Cap 1 | 1 | 1905 | 1905 | ||
| Tax Yr Over FICA Cap 1 | 4 | 1906 | 1909 | YYYY | |
| Over FICA WAGE Cap 2 | 1 | 1910 | 1910 | ||
| Tax Yr Over FICA Cap 2 | 4 | 1911 | 1914 | YYYY | |
| Over FICA WAGE Cap 3 | 1 | 1915 | 1915 | ||
| Tax Yr Over FICA Cap 3 | 4 | 1916 | 1919 | YYYY |
