Field Name

Required

Data Type

Max

Description

RecordID

Yes

Integer

An ID number that uniquely identifies this pay record

BatchCode

Yes

String

20

Batch code differentiates payroll batches

CheckNumber

Yes

String

25

Stores the check number

CheckDate

Yes

Datetime

Stores the check date in datetime format

SequenceNumber

Yes

Integer

Shows the order checks were processed within a batch

EmployeeID

Yes

String

50

Stores the unique identifier of a specific employee

EmployeeSSN

Yes

String

15

Stores employee SSN

EmployeeName

Yes

String

100

Stores employee name

EmployeeDepartmentID

String

30

Stores employee department; use the department ID

PeriodStartDate

Yes

Datetime

Stores the starting date for the check's pay period

PeriodEndDate

Yes

Datetime

Stores the ending date for the check's pay period

DeclaredTips

Decimal

Stores the declared tips on the check, if applicable

NetWages

Decimal

Stores the net wages on the check

VacationHoursAccrued

Decimal

Stores the vacation hours accrued on the check

SickHoursAccrued

Decimal

Stores the sick hours accrued on the check

RecordType

Yes

String

20

Stores the pay record type. Options are “DirectDeposit” and “Check”

IsVoided

Yes

Bit

1 if the check is voided; 0 otherwise

EmployeeAddress1

Yes

String

61

Stores the employee address

EmployeeAddress2

String

61

Stores the employee address continued

EmployeeCity

Yes

String

35

Stores employee's city

EmployeeState

Yes

String

29

Stores employee's state

EmployeePostal

Yes

String

10

Stores employee's ZIP code

EmployeeCountry

Yes

String

100

Stores employee's country

FederalExemptions

Integer

Number of federal exemptions

FederalAdditionalWithholding

Decimal

Amount of additional federal withholding

FederalFilingStatus

String

30

Federal filing status. (SINGLE - single, MAR- married, HOH - Head of Household)

Custom1

String

50

User-defined field

Custom2

String

50

User-defined field