Certified Payroll Bulk Upload File Format



Download 23.28 Kb.
Date conversion14.12.2016
Size23.28 Kb.
Certified Payroll Bulk Upload File Format
Files are to be in CSV (comma-separated values) format. Two separate files will be uploaded: employee demographics and payroll
Employee Demographics File
Once an employee’s demographic has been entered into our system, it is only necessary to submit new employees, or employees whose information has recently changed. The employee demographics file will consist of multiple records in the following format:


  • SSN

    • Numeric, 9 digits

    • Required

  • First Name

    • Character, max length of 20

    • Required

  • Last Name

    • Character, max length of 20

    • Required

  • Physical Address 1

    • Character, max length of 30

    • Required

  • Physical Address 2

    • Character, max length of 30

  • Physical City

    • Character, max length of 20

    • Required

  • Physical State

  • Physical Zip

    • Numeric, 5 or 9 digits

    • Required

  • Mailing Address 1

    • Character, max length of 30

    • Required

  • Mailing Address 2

    • Character, max length of 30

  • Mailing City

    • Character, max length of 20

    • Required

  • Mailing State

    • 2 character state abbreviation

    • Required

  • Mailing Zip

    • Numeric, 5 or 9 digits

    • Required

  • Certificate of Fitness #

    • Character, max length of 15

  • Truck License #

    • Character, max length of 15

  • Apprentice Percent

  • Union Member

    • T (true) or F (false)

  • Owner Operator

    • T (true) or F (false)

  • Progress Payment Date

    • Date, format mm/dd/yyyy

  • Progress Payment Amount

    • Numeric

  • Race Code

    • 2 character race code: A (Asian Pacific), AA (Black American), AI (Asian Indian), C (Caucasian), H (Hispanic), NA (AK Native/American Indian)

    • Required for DOT projects

  • Gender Code

    • M (male) or F (female)

    • Required for DOT projects

  • Skill Level Code

    • 1 character skill level code: A (Apprentice), J (Journeyman), T (Trainee)

    • Required for DOT projects

    • Apprentice Percent or Skill Level Code is required for all projects

  • Hire Date

    • Date, format mm/dd/yyyy

  • Rehire Date

    • Date, format mm/dd/yyyy

  • Termination Date

    • Date, format mm/dd/yyyy



Payroll File
The payroll file will begin with a single record with the basic payroll information in the following format:


  • Week Ending Date

    • Date, format mm/dd/yyyy

    • Required

  • Number of weeks

    • 1 (weekly) or 2 (biweekly)

    • Required

  • Payroll #

    • Character, max length of 10

    • Required

  • Revised

    • T (true) or F (false)

    • Required

    • If true, previous payroll for the same week ending date must exist in the system

    • If false, previous payroll for the same week ending date cannot exist in the system

For each employee in the payroll, there must be one wage header record, followed by 1 or more wage detail records for that employee. The wage header record must be in the following format:




  • SSN

    • Numeric, 9 digits

    • Required

  • Week #

    • 1 or 2

    • Required

  • Gross Earnings

    • Numeric

    • Required

  • Per Diem Rate

    • Numeric

  • Per Diem Earnings

    • Numeric

  • Total Deductions

    • Numeric

    • Required

  • Net Paid

    • Numeric

    • Required

  • Check #

    • Character, max length of 10

    • Check # or Direct Deposit Date is required

  • Direct Deposit Date

    • Date, format mm/dd/yyyy

    • Check # of Direct Deposit Date is required

  • Net Paid includes amounts from other projects?

    • T (true) or F (false)

    • Required

Each wage header record must be followed by one or more wage detail records in the following format:




  • Wage Type Code

    • 2 character wage type code: ST (Standard Time), OT (Overtime), FB (Fringe Benefits)

    • Required

  • AK Class Code

    • Character, max length of 10

    • Required

  • US Class Code

    • Character, max length of 50

    • Required for DOT projects

  • Day 1 Amount

    • Numeric

    • Required

  • Day 2 Amount

    • Numeric

    • Required

  • Day 3 Amount

    • Numeric

    • Required

  • Day 4 Amount

    • Numeric

    • Required

  • Day 5 Amount

    • Numeric

    • Required

  • Day 6 Amount

    • Numeric

    • Required

  • Day 7 Amount

    • Numeric

    • Required

  • Hours Worked

    • Numeric

    • Required

  • Hourly Rate

    • Numeric

    • Required


The database is protected by copyright ©dentisty.org 2016
send message

    Main page