You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
You are viewing the article in preview mode. It is not live at the moment.
Standard 401k to PAi
print icon

This article will describe the file transformation that has been created in detamoov to transform the standard 401k file format to the PAi Payroll Contribution fixed length file specifications. This transformation is used in a detamoov integration with PAi.

 

Source File

Destination File

Standard 401k

PAi Payroll Contribution CSV

 

File Specifications

File Type Generated

CSV

Header Row(s) Generated

Yes

Footer Row(s) Generated

No

End of Row Character

CRLF (Carriage Return Line Feed)

File Naming Generated

Production

  • PAI_[PAi ContractID]_MMDDYYYY.CSV

 

Field Mappings

The table below details the specific field mapping and transformation rules applied to ensure the PAi Payroll Contribution csv format is created correctly from the standard 401k format.

 
PAi Field Name Standard 401k Field Name Details
COMPANY CODE COMPANY CODE  
PAi CONTRACTID PLAN ID  
EMPLOYER EIN COMPANY EIN  
FIRST NAME FIRST NAME  
MIDDLE NAME MIDDLE NAME/INITIAL  
LAST NAME LAST NAME  
SUFFIX    
SOCIAL SECURITY NUMBER SSN  
EMPLOYEE CODE EMPLOYEE NUMBER  
GENDER GENDER M or F
EMPLOYEE STATUS EMPLOYMENT STATUS  
MARITAL STATUS MARITAL STATUS  
PAY TYPE    
UNION STATUS    
ADDRESS 1 ADDRESS LINE 1  
ADDRESS 2 ADDRESS LINE 2  
CITY CITY  
STATE STATE  
ZIP CODE ZIP  
CELLPHONE    
EMAIL EMAIL  
BIRTH DATE DOB MM/DD/YYYY
HIRE DATE HIRE DATE MM/DD/YYYY
REHIRE DATE REHIRE DATE MM/DD/YYYY
ADJUSTED SENIORITY DATE    
TERMINATION DATE TERMINATION DATE MM/DD/YYYY
LEAVE OF ABSENCE BEGIN DATE    
LEAVE OF ABSENCE END DATE    
CHECK DATE PAYROLL CHECK DATE MM/DD/YYYY
PAYROLL BEGIN DATE PAY PERIOD START DATE MM/DD/YYYY
PAYROLL END DATE PAY PERIOD END DATE MM/DD/YYYY
PAYROLL FREQUENCY PAY PERIOD START DATE & PAY PERIOD END DATE WEEKLY = W
BIWEEKLY = B
SEMIMONTHLY = S
MONTHLY = M
ANNUALLY = 52
DIVISION    
DEPARTMENT    
GROSS EARNINGS CURRENT PAY PERIOD GROSS PAY  
PLAN EARNINGS    
HOURS CURRENT PAY PERIOD HOURS WORKED  
EXCLUDED EARNINGS    
SECTION 125    
EMPLOYEE DEFERRAL CURRENT PAYROLL EMPLOYEE PRETAX CONTRIBUTION  
EMPLOYEE ROTH CURRENT PAYROLL EMPLOYEE ROTH CONTRIBUTION  
EMPLOYER MATCH CURRENT PAYROLL EMPLOYER MATCH CONTRIBUTION  
SAFE HARBOR MATCH CURRENT PAYROLL SAFE HARBOR EMPLOYER MATCH  
SAFE HARBOR NON-ELECTIVE CURRENT PAYROLL SAFE HARBOR NON-ELECTIVE  
PROFIT SHARING CURRENT PAYROLL NON-ELECTIVE CONTRIBUTION  
LOAN PAYMENT 1 401K LOAN 1 REPAYMENT  
LOAN NUMBER 1 401K LOAN 1 ID  
LOAN PAYMENT 2 401K LOAN 2 REPAYMENT  
LOAN NUMBER 2 401K LOAN 2 ID  
LOAN PAYMENT 3 401K LOAN 3 REPAYMENT  
LOAN NUMBER 3 401K LOAN 3 ID  
LOAN PAYMENT 4 401K LOAN 4 REPAYMENT  
LOAN NUMBER 4 401K LOAN 4 ID  
LOAN PAYMENT 5 401K LOAN 5 REPAYMENT  
LOAN NUMBER 5 401K LOAN 5 ID  
YTD GROSS EARNINGS YTD GROSS PAY  
PLAN YTD EARNINGS    
PLAN YTD HOURS YTD HOURS WORKED  
PLAN YTD EXCLUDED EARNINGS    
PLAN YTD SECTION 125    
PLAY YTD EMPLOYEE DEFERRAL    
PLAN YTD EMPLOYEE ROTH    
PLAN YTD EMPLOYER MATCH    
PLAN YTD SAFE HARBOR MATCH    
PLAN YTD SAFE HARBOR NON-ELECTIVE    
PLAN YTD PROFIT SHARING    
EMPLOYEE DEFFERAL IRA    
EMPLOYEE ROTH IRA    
PLAN YTD EMPLOYEE DEFERRAL IRA    
PLAN YTD EMPLOYEE ROTH IRA    
scroll to top icon