Field Name

Required

Data Type

Max

Description

EmployeeID

Yes

String

50

Stores the unique identifier of a specific employee

CheckNumber

Yes

String

50

Stores the check number

CheckDate

Yes

Datetime

Stores the check date in datetime format

BatchCode

Yes

String

20

Batch code differentiates payroll batches

PayCodeID

Yes

String

20

Stores the unique identifier to a specific earning

CodeDescription

Yes

String

100

Stores the description of the benefit in question

PayRate

Yes

Decimal

Employee’s per unit Pay Rate

UnitsToPay

Yes

Int

Units To Pay

TipType

String

20

Tip Type

EarnedAmount

Yes

Decimal

Earning Amount

StateCode

Yes

String

3

The two-digit state abbreviation corresponding to the state where the pay was earned

SutaCode

Yes

String

3

The two-digit state abbreviation corresponding to the state where state unemployment is to be paid

StateJurisdiction

Yes

String

50

Greenshades Jurisdiction code corresponding to the StateCode. This is typically “US-“ plus the state abbreviation; e.g. US-FL

SutaStateJurisdiction

Yes

String

50

Greenshades Jurisdiction code corresponding to the SutaCode. This is typically “US-“ plus the state abbreviation; e,g. US-FL

LocalTaxCode

String

10

Local Tax Code corresponding to the local tax assessed on the earning; must correspond to local type tax in the EmployeeTaxRecords file

WorkersCompCode

String

10

Workers Compensation code

DaysWorked

Int

Days worked

WeeksWorked

Int

Weeks worked

Custom1

String

30

User-defined field

Custom2

String

30

User-defined field

SubjectToFIT

Bool

1 if subject to FIT; 0 otherwise

SubjectToEmployeeFICA

Bool

1 if subject to FICA; 0 otherwise

SubjectToEmployerFICA

Bool

1 if subject to employer FICA; 0 otherwise

SubjectToEmployeeMedicare

Bool

1 if subject to Employee Medicare; 0 otherwise

SubjectToEmployerMedicare

Bool

1 if subject to Employer Medicare; 0 otherwise

SubjectToFederalUnemployment

Bool

1 if subject to Federal Unemployment; 0 otherwise

SubjectToStateWithholding

Bool

1 if subject to State Withholding; 0 otherwise

SubjectToStateSDI

Bool

1 if subject to State SDI; 0 otherwise

SubjectToStateUnemployment

Bool

1 if subject to State Unemployment; 0 otherwise

SubjectToLocalWithholding

Bool

1 if subject to Local Withholding; 0 otherwise

SubjectToLocalLDI

Bool

1 if subject to local LDI; 0 otherwise

SubjectToLocalUnemployment

Bool

1 if subject to local unemployment; 0 otherwise

SubjectToLocalOther

Bool

1 if subject to Local Other; 0 otherwise

SubjectToEmployeeSUI

Bool

1 if subject to employee SUI; 0 otherwise

SubjectToWorkersComp

Bool

1 if subject to Workers Comp; 0 otherwise