Standard 401k to T. Rowe Price (direct)

Aug 27, 2026

This article will describe the file transformation that has been created in detamoov to transform the standard 401k file format to the T. Rowe Price file specifications. This transformation is used in a detamoov integration with T. Rowe Price.

Source File	Destination file
Standard 401k	T. Rowe Price

File Specifications

File Type Generated	Fixed Length
Header Row(s) Generated	No
Footer Row(s) Generated	Yes - Employee Contribution Totals
End of Row Character	CRLF
File Naming Generated	Maintenance Records: Production: XM[TRP provided value]YYYYMMDDHHMMSSFFF.txt Testing: TM[TRP provided value]YYYYMMDDHHMMSSFFF.txt Contribution Records: Production: XC[TRP provided value]YYYYMMDDHHMMSSFFF.txt TestingL TC[TRP provided value]YYYYMMDDHHMMSSFFF.txt

Field Mappings

The tables below detail the specific field mapping and transformation rules applied to ensure the T. Rowe Price fixed-length format is created correctly from the standard 401k format.

Maintenance Records (one record per employee)

Field	T. Rowe Price Field Name	Standard 401k Field Name	Field Length	Details
1	Plan	PLAN ID	6	TRP assigned value
2	Record ID		3	Hardcoded value: 812
3	SSN	SSN	9	Numeric only
4	Type		1	Hardcoded value: M
5	Name	LAST NAME FIRST NAME	30	Last, First
6	Status	EMPLOYMENT STATUS	2	03 = Active, Hired, Rehired 30 = Terminated
7	Birth Date	DOB	8	YYYYMMDD
8	Hire Date	HIRE DATE REHIRE DATE	8	YYYYMMDD Hire Date or Rehire Date
9	Filler		8
10	Address 1	ADDRESS LINE 1	30
11	Address 2	ADDRESS LINE 2	30
12	City	CITY	18
13	State	STATE	3
14	Zip Code	ZIP	9	Numeric only
15	Employee ID	EMPLOYEE NUMBER	11
16	Key Employee Indicator	KEY EMPLOYEE	1	0 = Non-highly Compensated Employee 1 = Five Percent Owner 5 = HCE since Age 55 6 = Highly Compensated Employee
17	Marital Status	MARITAL STATUS	1	1 = Single 2 = Married
18	Filler		4
19	Hours of Service	CURRENT PAY PERIOD HOURS WORKED	7	PPP or YTD based on plan rules Default set to PPP Round Number - Force 3 decimals Remove separators Numeric Padding
20	Filler		10
21	Termination Date	TERMINATION DATE	8	YYYYMMDD Required if Status (field 6) = 30
22	Filler		8
23	Eligibility Date		8
24	Status Reason Code	EMPLOYMENT STATUS	1	Required if Status (field 6) = 30, else space fill 0 = Voluntary/clear 4 = Retirement 5 = Disability 6 = Death X = Excluded class T = Transfer
25	Salary	CURRENT PAY PERIOD GROSS PAY	11	PPP or YTD based on plan rules Default set to PPP Round Number - Force 2 decimals Remove separators Numeric Padding
26	Location		4	Up to 4 digit code for division/location
27	Variable Cash		132
28	Variable Code 1		1
29	Payroll Frequency	PAY PERIOD START DATE PAY PERIOD END DATE	1	1 = Annually 2 = Semi-Annually 3 = Quarterly 4 = Monthly 5 = Semi-Monthly 6 = Bi-Weekly 7 = Weekly 8 = Daily
30	Variable Code 3		1
31	Officer		1	0 = Not an officer 3 = Officer
32	Variable Code 5		1
33	Variable Text 1		10
34	Variable Text 2		10
35	Variable Date		8
36	Original Hire Date	REHIRE DATE HIRE DATE	8	YYYYMMDD Upon rehire, retain original date of hire here
37	Variable Date 3 & 4		16
38	Rehire Date	REHIRE DATE	8	YYYYMMDD
39	Alt Vesting Date		8
40	Variable Date		8
41	Variable Date		8
42	Variable Extended Text		26
43	Alt Employee ID		13
44	Filler		1
45	Corporate Email Address	EMAIL	80	Work Email required
46	EE Type		1	Reserved field override 0 = N/A 1 = Full Time 2 = Part Time
47	EE Stat Reason		2	33 = LOA Paid 34 = LOA Unpaid (default) 35 = Military LOA Paid 36 = Military LOA Unpaid (default) 32 = Military LOA Paid/Unpaid 37 = LOA Paid/Unpaid 00= to clear (custom)
48	LOA Start Date		8
49	LOA End Date		8
50	Match Elig Date		8
51	Annualized Salary		11
52	Benefits Comp		11
53	ADP Testing Comp		11
54	ACP Testing Comp		11
55	415 Testing Comp		11
56	Bonus Comp		11
57	ACP Eligibility		8
58	ER Eligibility		8
59	Top Heavy Key Employee		1	1 = Top Heavy Employee
60	Participant Supplied Email Address	EMAIL	80
61	Participant Supplied Phone Number	PHONE	20	Format Phone with Dashes
62	Gender	GENDER	1	1 = Male 2 = Female
63	Effective Date	PAYROLL CHECK DATE	8	YYYYMMDD
64	Public Safety Officer		1	Y = Yes N = No Space acceptable

Employee Contributions (one record per contribution, per employee)

Field	T. Rowe Price Field Name	Standard 401k Field Name	Field Length	Details
Field	T. Rowe Price Field Name	Standard 401k Field Name	Field Length	Details
1	Plan	PLAN ID	6	TRP assigned value
2	Record ID		1
3	Date	PAYROLL CHECK DATE	8	YYYYMMDD
4	SSN	SSN	9	Numeric only
5	Source/Fund		3	Custom per plan provided by TRP during integration
6	Loan Number		2	00 fill if not a loan payment record or loan number is not known
7	Amount	CONTRIBUTION AND LOAN FIELDS	11	Custom per plan to match Source/Fund code Implied 2 decimal places Round Number - Force 2 decimals Remove separators Numeric Padding
8	Salary		11	"may not be required" per specs Round Number - Force 2 decimals Remove separators Numeric Padding
9	Salary Type		1
10	Contrib Type		3	Hardcoded value: STD
11	State Tax		1	Withheld = Y (PA only) Not withheld = N
12	Loan Payment Type		1	Set 1 if loan Space if not a loan
13	Filler		23

Total Contributions (one record to sum each contribution type)

Field	T. Rowe Price Field Name	Standard 401k Field Name	Field Length	Details
Field	T. Rowe Price Field Name	Standard 401k Field Name	Field Length	Details
1	Plan	PLAN ID	6	TRP assigned value
2	Record ID		1	Hardcoded value: A
3	Date	PAYROLL CHECK DATE	8	YYYYMMDD
4	Filler		9
5	Source/Fund		3	Custom per plan provided by TRP during integration
6	Filler		2
7	Total Source Dollars		11	Total sum of all contributions per source/fund Round Number - Force 2 decimals Remove separators Numeric Padding
8	Filler		40

Tags