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 Blue Star file specifications. This transformation is used in a detamoov integration with Blue Star.
Source File | Destination file |
Standard 401k | Blue Star |
File Specifications
File Type Generated | CSV |
Header Row(s) Generated | Yes |
Footer Row(s) Generated | No |
End of Row Character | |
File Naming Generated |
Production: [Plan ID]_[Date in mmddyyyy]_[timestamp in hhmmssff].csv Testing: TEST_[Plan ID]_[Date in mmddyyyy]_[timestamp in hhmmssff].csv |
Field Mappings
The table below details the specific field mapping and transformation rules applied to ensure the Blue Star Payroll Contribution comma-separated format is created correctly from the standard 401k format.
Blue Star Field Name | Standard 401k Field Name | Field Size | Details |
PlanName | COMPANY LEGAL NAME | 50 | |
Company | COMPANY LEGAL NAME | 50 | |
ClientID | PLAN ID | 50 | System Client ID, System Client Number or BlueStar Plan ID |
Payroll | PAYROLL CHECK DATE | MM/DD/YYYY | |
SSN | SSN | 11 | |
EENum | EMPLOYEE NUMBER | ||
FName | FIRST NAME | 20 | |
LName | LAST NAME | 20 | |
Street1 | ADDRESS LINE 1 | 30 | |
Street2 | ADDRESS LINE 2 | 30 | |
City | CITY | 30 | |
State | STATE | 2 | |
Zip | ZIP | 11 | |
Cell | PHONE | 12 | |
Home | PHONE | 12 | |
Office | 12 | ||
50 | |||
DoB | DOB | MM/DD/YYYY | |
DoH | HIRE DATE | MM/DD/YYYY | |
DoT | TERMINATION DATE | MM/DD/YYYY | |
DoR | REHIRE DATE | MM/DD/YYYY | |
PayFreq | PAY PERIOD START DATE AND PAY PERIOD END DATE | 1 | Annual = A Semiannual = 2 Quarterly = Q Monthly = M Semimonthly = S Biweekly = B Weekly = W |
Hours | CURRENT PAY PERIOD HOURS WORKED | 9 | Round - Force 2 decimals |
GrossComp | CURRENT PAY PERIOD GROSS PAY | 13 | Round - Force 2 decimals |
PlanComp | CURRENT PAY PERIOD GROSS PAY | 13 | Total eligible plan compensation |
Deferral | CURRENT PAYROLL EMPLOYEE PRETAX CONTRIBUTION | 13 | Round - Force 2 decimals |
RothDeferral | CURRENT PAYROLL EMPLOYEE ROTH CONTRIBUTION | 13 | Round - Force 2 decimals |
Match | CURRENT PAYROLL EMPLOYER MATCH CONTRIBUTION | 13 | Round - Force 2 decimals |
NonElect | CURRENT PAYROLL NON ELECTIVE CONTRIBUTION | 13 | Round - Force 2 decimals |
Loan1 | 401k LOAN 1 REPAYMENT | 13 | Round - Force 2 decimals |
Loan2 | 401k LOAN 2 REPAYMENT | 13 | Round - Force 2 decimals |
Loan3 | 13 | ||
HoursYTD | YTD HOURS WORKED | 9 | Round - Force 2 decimals |
GrossCompYTD | YTD GROSS PAY | 13 | Round - Force 2 decimals |
PlanCompYTD | YTD GROSS PAY | 13 | Total eligible plan compensation |
DeferralYTD | 13 | ||
RothDeferralYTD | 13 | ||
MatchYTD | 13 | ||
NonElectYTD | 13 | ||
Loan1YTD | 13 | ||
Loan2YTD | 13 | ||
Loan3YTD | 13 | ||
Gender | GENDER | 1 | Male = M Female = F |
EEType | 1 | ||
FTPT | 1 | ||
MaritalStatus | MARITAL STATUS | 1 | Married = M Single = S Divorced = D Widowed = W |
DivCode | 50 | Company Division Code/Number | |
LocCode | 50 | Location Code | |
EEClass | 50 | ||
UnionEE | 1 | Required if Union EEs |