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