PR
PROvertimeRule
Stores the rules that trigger overtime calculation in the paycheck. The information will be displayed on the Overtime Rules (PR104000) form.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
CountryID | char(2) | Country | ||
Description:The unique identifier of the country to which the overtime rule corresponds. The field is included in FK.State and FK.Country. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
Description | nvarchar(255) | Description | - | |
Description:The description of the overtime rule. | ||||
DisbursingTypeCD | nvarchar(15) | Disbursing Earning Type | EPEarningType | |
Description:The user-friendly unique identifier of the disbursing earning type. The field is included in FK.DisbursingEarningType. Corresponds to the EPEarningType.typeCD field. | ||||
IsActive | bit | Active | - | |
Description:Indicates that (if set to true) the overtime rule is active. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
NumberOfConsecutiveDays | tinyint | Number of Consecutive Days | - | |
Description:The number of consecutive days an employee should work to apply the 'Consecutive' overtime rule during the Paycheck calculation. The minimum 0 days, the maximum 7 days. | ||||
OvertimeMultiplierNonexistent in DB | decimal? | Multiplier | - | |
Description:The overtime multiplier. Corresponds to the EPEarningType.overtimeMultiplier field. | ||||
OvertimeRuleID | nvarchar(30) | Overtime Rule | - | |
Description:The unique identifier of the overtime rule. | ||||
OvertimeThreshold | decimal | Threshold for Overtime (Hours) | - | |
Description:The threshold (in hours) to apply the overtime rule to earning detail(s). The minimum 0 hours, the maximum 999.99 hours. | ||||
ProjectID | int | Project | PMProject | |
Description:The unique identifier of the associated project. The field is included in FK.Project. The value of this field corresponds to the value of the PMProject.ContractID field. | ||||
RuleType | char(3) | Type | - | |
Description:The type of the overtime rule. The field can have one of the values described in PROvertimeRuleType.ListAttribute. | ||||
State | nvarchar(50) | State | State | |
Description:The state or province to which the overtime rule is applied. The field is included in FK.State. | ||||
TStamp | timestamp | - | ||
Description:No description available | ||||
UnionID | nvarchar(15) | Union Local | PMUnion | |
Description:The unique identifier of the union local, if any. The field is included in FK.Union. The value of this field corresponds to the value of the PMUnion.UnionID field. | ||||
WeekDay | tinyint | Day of Week | - | |
Description:A specific day of the week to apply the 'Daily' overtime rule. The field can have one of the values described in EP.DayOfWeekAttribute. | ||||