PP
MPCurrentPayCalendar
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
CalendarID | nvarchar(10) | Calendar ID | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created by | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created date (UTC) | - | |
Description:No description available | ||||
CurrentPayCalendarID | int | - | ||
Description:No description available | ||||
DaysPerPay | decimal | Days Per Pay | - | |
Description:No description available | ||||
Description | nvarchar(60) | Description | - | |
Description:No description available | ||||
EmployeeID | int | Employee ID | MPCurrentPay | |
Description:No description available | ||||
FriEndTime | datetime | - | ||
Description:No description available | ||||
FriStartTime | datetime | - | ||
Description:No description available | ||||
FriUnpaidTime | int | - | ||
Description:No description available | ||||
FriWorkDay | bit | Friday | - | |
Description:No description available | ||||
HoursPerWeek | decimal | Hours Per Week | - | |
Description:No description available | ||||
HoursPerYear | decimal | Hours Per Year | - | |
Description:No description available | ||||
IsAUNonexistent in DB | bool? | - | ||
Description:No description available | ||||
IsNZNonexistent in DB | bool? | - | ||
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last modified by | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last modified date | - | |
Description:No description available | ||||
MonEndTime | datetime | - | ||
Description:No description available | ||||
MonStartTime | datetime | - | ||
Description:No description available | ||||
MonUnpaidTime | int | - | ||
Description:No description available | ||||
MonWorkDay | bit | Monday | - | |
Description:No description available | ||||
PayRunID | int | Pay run ID | MPCurrentPay | |
Description:No description available | ||||
SatEndTime | datetime | Saturday End Time | - | |
Description:No description available | ||||
SatStartTime | datetime | - | ||
Description:No description available | ||||
SatUnpaidTime | int | - | ||
Description:No description available | ||||
SatWorkDay | bit | Saturday | - | |
Description:No description available | ||||
SunEndTime | datetime | - | ||
Description:No description available | ||||
SunStartTime | datetime | - | ||
Description:No description available | ||||
SunUnpaidTime | int | Unpaid Break Time | - | |
Description:No description available | ||||
SunWorkDay | bit | Sunday | - | |
Description:No description available | ||||
TStamp | timestamp | - | ||
Description:No description available | ||||
ThuEndTime | datetime | - | ||
Description:No description available | ||||
ThuStartTime | datetime | - | ||
Description:No description available | ||||
ThuUnpaidTime | int | - | ||
Description:No description available | ||||
ThuWorkDay | bit | Thursday | - | |
Description:No description available | ||||
TotalFriWorkHours | decimal | Total Work Hours | - | |
Description:No description available | ||||
TotalMonWorkHours | decimal | Total Work Hours | - | |
Description:No description available | ||||
TotalSatWorkHours | decimal | Total Work Hours | - | |
Description:No description available | ||||
TotalSunWorkHours | decimal | Total Work Hours | - | |
Description:No description available | ||||
TotalThuWorkHours | decimal | Total Work Hours | - | |
Description:No description available | ||||
TotalTueWorkHours | decimal | Total Work Hours | - | |
Description:No description available | ||||
TotalWedWorkHours | decimal | Total Work Hours | - | |
Description:No description available | ||||
TueEndTime | datetime | - | ||
Description:No description available | ||||
TueStartTime | datetime | - | ||
Description:No description available | ||||
TueUnpaidTime | int | - | ||
Description:No description available | ||||
TueWorkDay | bit | Tuesday | - | |
Description:No description available | ||||
WedEndTime | datetime | - | ||
Description:No description available | ||||
WedStartTime | datetime | - | ||
Description:No description available | ||||
WedUnpaidTime | int | - | ||
Description:No description available | ||||
WedWorkDay | bit | Wednesday | - | |
Description:No description available | ||||