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 Blue Star
print icon

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

 

scroll to top icon