Field Name

Required

Data Type

Max

Description

EmployeeID

Yes

String

50

Stores the unique identifier of a specific employee

CheckDate

Yes

Datetime

Stores the check date in datetime format

CheckNumber

Yes

String

50

Stores the check number

BatchCode

Yes

String

50

Batch code differentiates payroll batches

BenefitCodeID

Yes

String

20

Stores the unique identifier to a specific benefit

CodeDescription

Yes

String

100

Stores the description of the benefit in question

StartDate

Yes

Datetime

Stores the benefit start date

EndDate

Yes

Datetime

Stores the benefit end date

BenefitAmount

Decimal

Stores the amount (Decimal) of the benefit for the check in question

Custom1

String

User-defined field

Custom2

String

User-defined field