Standard 401k to Principal IPP

Aug 13, 2026

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
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

Field	Principal IPP Field	Standard 401k Field	Field Size	Field Start	Field End	Details
1	Contract Number	PLAN ID	6	1	6
2	Pay Date	PAYROLL CHECK DATE	10	7	16	MM/DD/YYYY
3	Social Security Number	SSN	11	17	27	Format SSN w/dashes
4	Birth Date	DOB	10	28	37	MM/DD/YYYY
5	Current Employment Date	HIRE DATE REHIRE DATE	10	38	47	Most recent hire date MM/DD/YYYY
6	Employee Contribution 1 Amount	Custom Per Plan	12	48	59	Zero-fill if field empty Round Force 2 decimals Remove Separators Numeric Padding
7	Employee Contribution 2 Amount	Custom Per Plan	12	60	71	Zero-fill if field empty Round Force 2 decimals Remove Separators Numeric Padding
8	Employee Contribution 3 Amount	Custom Per Plan	12	72	83	Zero-fill if field empty Round Force 2 decimals Remove Separators Numeric Padding
9	Employee Contribution 4 Amount	Custom Per Plan	12	84	95	Zero-fill if field empty Round Force 2 decimals Remove Separators Numeric Padding
10	Employee Contribution 5 Amount	Custom Per Plan	12	96	107	Zero-fill if field empty Round Force 2 decimals Remove Separators Numeric Padding
11	Employer Contribution 1 Amount	Custom Per Plan	12	108	119	Zero-fill if field empty Round Force 2 decimals Remove Separators Numeric Padding
12	Employer Contribution 2 Amount	Custom Per Plan	12	120	131	Zero-fill if field empty Round Force 2 decimals Remove Separators Numeric Padding
13	Employer Contribution 3 Amount	Custom Per Plan	12	132	143	Zero-fill if field empty Round Force 2 decimals Remove Separators Numeric Padding
14	Employer Contribution 4 Amount	Custom Per Plan	12	144	155	Zero-fill if field empty Round Force 2 decimals Remove Separators Numeric Padding
15	Employer Contribution 5 Amount	Custom Per Plan	12	156	167	Zero-fill if field empty Round Force 2 decimals Remove Separators Numeric Padding
16	Other Contribution 1 Amount	Custom Per Plan	12	168	179	Zero-fill if field empty Round Force 2 decimals Remove Separators Numeric Padding
17	Other Contribution 2 Amount	Custom Per Plan	12	180	191	Zero-fill if field empty Round Force 2 decimals Remove Separators Numeric Padding
18	Other Contribution 3 Amount	Custom Per Plan	12	192	203	Zero-fill if field empty Round Force 2 decimals Remove Separators Numeric Padding
19	Other Contribution 4 Amount	Custom Per Plan	12	204	215	Zero-fill if field empty Round Force 2 decimals Remove Separators Numeric Padding
20	Other Contribution 5 Amount	Custom Per Plan	12	216	227	Zero-fill if field empty Round Force 2 decimals Remove Separators Numeric Padding
21	Loan ID 1	401K LOAN 1 ID	3	228	230
22	Loan Payment 1 Amount	401K LOAN 1 REPAYMENT	12	231	242	Zero-fill if field empty Round Force 2 decimals Remove Separators Numeric Padding
23	Loan Additional Principal Payment		12	243	254
24	Loan ID 2	401K LOAN 2 ID	3	255	257
25	Loan Payment 2 Amount	401K LOAN 2 REPAYMENT	12	258	269	Zero-fill if field empty Round Force 2 decimals Remove Separators Numeric Padding
26	Loan Additional Principal Payment		12	270	281
27	Loan ID 3		3	282	284
28	Loan Payment 3 Amount		12	285	296
29	Loan Additional Principal Payment		12	297	308
30	Loan ID 4		3	309	311
31	Loan Payment 4 Amount		12	312	323
32	Loan Additional Principal Payment		12	324	335
33	Loan ID 5		3	336	338
34	Loan Payment 5 Amount		12	339	350
35	Loan Additional Principal Payment		12	351	362
36	Compensation 0		12	363	374	Plan or ADP Comp (YTD preferred)
37	Compensation 1	YTD GROSS PAY	12	375	386	Gross or 415 Comp (YTD preferred)
38	Compensation 2		12	387	398	Excluded Pay (YTD preferred)
39	Compensation 3		12	399	410	Section 125 (YTD preferred)
40	Compensation 4 (Annualized Salary)		12	411	422	Estimated annual income
41	Compensation 5		12	423	434
42	First Name	FIRST NAME	25	435	459
43	Middle Initial	MIDDLE NAME/INITIAL	1	460	460
44	Last Name	LAST NAME	25	461	485
45	Blank Fill		30	486	515
46	Alternate ID	EMPLOYEE NUMBER	20	516	535
47	Address Line 1	ADDRESS LINE 1	50	536	585	No Special Characters
48	Address Line 2	ADDRESS LINE 2	50	586	635	No Special Characters
49	Address Line 3		50	636	685	No Special Characters
50	City	CITY	30	686	715
51	State	STATE	2	716	717
52	Zip Code +4	ZIP	10	718	727	Format zip +4
53	Contry Code		2	728	729	Default value: US
54	Blank Fill		1	730	730
55	Home Phone	PHONE	24	731	754
56	Work Phone	PHONE	24	755	778
57	Blank Fill		24	779	802
58	Work Email	EMAIL	75	803	877
59	Personal Email	EMAIL	75	878	952
60	Division		20	953	972
61	Blank Fill		10	973	982
62	Sub-Division		10	983	992
63	Blank Fill		10	993	1002
64	Location		7	1003	1009
65	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)
66	Benefit End Date	EMPLOYMENT STATUS	10	1012	1021	Return Term Date if Status is T,R,D MM/DD/YYYY
67	Leave of Absence Code		2	1022	1023
68	Blank Fill		1	1024	1024
69	Leave of Absence Begin Date		10	1025	1034	MM/DD/YYYY
70	Leave of Absence End Date		10	1035	1044	MM/DD/YYYY
71	Hours	YTD HOURS WORKED	8	1045	1052	Explicit decimal Round force 2
72	Pay Frequency	PAY PERIOD START 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
73	Gender	GENDER	1	1054	1054	1 = Male 2 = Female
74	Preferred Language Code		1	1055	1055	0 = English 1 = Spanish
75	Actual Married Status	MARRIAGE STATUS	1	1056	1056	1 = Married 2 = Single 3 = Legally Separated
76	Blank Fill		10	1057	1066
77	Union/Bargaining Status		1	1067	1067	1 = Union-bargaining 2 = Not Union 3 = Union-Nonbar gaining
78	Blank Fill		10	1068	1077
79	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
80	Blank Fill		10	1079	1088
81	Highly Compensated Status	HIGHLY COMPENSATED EMPLOYEE	1	1089	1089	1 = Yes 2 = No
82	Blank Fill		10	1090	1099
83	Leased Status		1	1100	1100	1 = Yes 2 = No
84	Blank Fill		10	1101	1110
85	Non-Resident Alien Indicator		1	1111	1111	1 = Yes 2 = No
86	Blank Fill		10	1112	1121
87	Independent Contractor Indicator		1	1122	1122	1 = Yes 2 = No
88	Blank Fill		10	1123	1132
89	Employer		3	1133	1135
90	Blank Fill		10	1136	1145
91	Employment Method		1	1146	1146	1 = Hired 2 = Appointed 3 = Elected
92	Blank Fill		10	1147	1156
93	Employment Condition		1	1157	1157	Transformation override for Reserved field 1 = Full Time 2 = Part Time 3 = Seasonal 4 = Temporary
94	Blank Fill		10	1158	1167
95	Compensation Basis		1	1168	1168	Transformation override for Reserved field 1 = Salaried 2 = Hourly 3 = Commission 4 = Non-Commission 5 = Non-Hourly 6 = Non-Salaried
96	Blank Fill		10	1169	1178
97	Override Eligibility Date 1		10	1179	1188	MM/DD/YYYY
98	Override Eligibility Date 2		10	1189	1198	MM/DD/YYYY
99	Override Eligibility Date 3		10	1199	1208	MM/DD/YYYY
100	Term Reason Code		1	1209	1209
101	Resident of Puerto Rico		1	1210	1210	1 = Yes 2 = No
102	Blank Fill		10	1211	1220
103	Prevailing Wage		1	1221	1221	1 = Yes 2 = No
104	Blank Fill		10	1222	1231
105	Student		1	1232	1232	1 = Yes 2 = No
106	Blank Fill		10	1233	1242
107	Covered by 401k 403b or 457 Plan		1	1243	1243	1 = Yes 2 = No
108	Blank Fill		10	1244	1253
109	Covered by Another Pension Plan		1	1254	1254	1 = Yes 2 = No
110	Blank Fill		10	1255	1264
111	Covered by Another Profit Sharing Plan		1	1265	1265	1 = Yes 2 = No
112	Blank Fill		10	1266	1275
113	Blank Fill		2	1276	1277
114	Blank Fill		10	1278	1287
115	Blank Fill		10	1288	1297
116	Blank Fill		10	1298	1307
117	Blank Fill		10	1308	1317
118	Blank Fill		10	1318	1327
119	Blank Fill		10	1328	1337
120	Blank Fill		10	1338	1347
121	Blank Fill		10	1348	1357
122	Job Code		32	1358	1389
123	Custom Code 1		10	1390	1399
124	Custom Code 2		10	1400	1409
125	Custom Code 3		10	1410	1419
126	Custom Code 4		10	1420	1429
127	Custom Code 5		10	1430	1439
128	Custom Code 6		10	1440	1449
129	Custom Integer 1		8	1450	1457
130	Custom Integer 2		8	1458	1465
131	Custom Integer 3		8	1466	1473
132	Custom Integer 4		8	1474	1481
133	Custom Integer 5		8	1482	1489
134	Custom Integer 6		8	1490	1497
135	Custom Date 1		10	1498	1507
136	Custom Date 2		10	1508	1517
137	Custom Date 3		10	1518	1527
138	Custom Date 4		10	1528	1537
139	Custom Date 5		10	1538	1547
140	Custom Date 6		10	1548	1557
141	Custom Decimal 1		19	1558	1576
142	Custom Decimal 2		19	1577	1595
143	Custom Decimal 3		19	1596	1614
144	Custom Decimal 4		19	1615	1633
145	Custom Decimal 5		19	1634	1652
146	Custom Decimal 6		19	1653	1671
147	Blank Fill		3	1672	1674
148	Blank Fill		3	1675	1677
149	Blank Fill		3	1678	1680
150	Blank Fill		3	1681	1683
151	Blank Fill		3	1684	1686
152	Blank Fill		7	1687	1693
153	Blank Fill		7	1694	1700
154	Blank Fill		7	1701	1707
155	Blank Fill		7	1708	1714
156	Blank Fill		7	1715	1721
157	Custom Code 17		10	1722	1731
158	Custom Pay Status		4	1732	1735
159	Custom Reporting Field 1		50	1736	1785
160	Custom Employment Status Code		4	1786	1789
161	Class Code		5	1790	1794
162	Pay Period End Date	PAY PERIOD END DATE	10	1795	1804	MM/DD/YYYY
163	Blank Fill		10	1805	1814
164	Prior Term Date 1		10	1815	1824
165	Blank Fill		10	1824	1834
166	Blank Fill		10	1835	1844
167	Blank Fill		10	1845	1854
168	Blank Fill		10	1855	1864
169	Blank Fill		10	1865	1874
170	Blank Fill		10	1875	1884
171	Blank Fill		10	1885	1894
172	Blank Fill		10	1895	1904
173	Over FICA WAGE Cap 1		1	1905	1905	1 = Yes 2 = No
173	Over FICA WAGE Cap 1		1	1905	1905	1 = Yes 2 = No
174	Tax Yr Over FICA Cap 1		4	1906	1909
175	Over FICA WAGE Cap 2		1	1910	1910	1 = Yes 2 = No
175	Over FICA WAGE Cap 2		1	1910	1910	1 = Yes 2 = No
176	Tax Yr Over FICA Cap 2		4	1911	1914
177	Over FICA WAGE Cap 3		1	1915	1915	1 = Yes 2 = No
177	Over FICA WAGE Cap 3		1	1915	1915	1 = Yes 2 = No
178	Tax Yr Over FICA Cap 3		4	1916	1919

Tags