PayPeriod

Data Element

Data Type

What is it

Mandatory

Id

Integer

The unique id for the record

No

Name

VarChar

The name for the pay period

Yes

Active

Boolean True/False

Whether the pay period is active

Yes

StartDate

DateTime

The time of the pay period start

Yes

Cycle

Integer

The cycle of the pay period eg weekly, monthly etc.

1 = Weekly
2 = Fortnightly
3 = Monthly
4 = 3 weekly
5 = 4 weekly
6 = BiMonthly

Yes

Creator

Integer

The id of the user who created the record

No

Created

DateTime

When the record was originally created

No