PR
PRPTOAdjustmentDetail
Stores the details of the PTO adjustment
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AdjustmentHours | decimal | Adjustment Hours | - | |
Description:Adjustment hours (positive or negative). | ||||
AdjustmentReason | char(3) | Adjustment Reason | - | |
Description:The reason of the PTO adjustment. The field can have one of the values described in PTOAdjustmentReason.ListAttribute. | ||||
BAccountID | int | Employee | PREmployee | |
Description:The unique identifier of the business account to which the employee bank belongs. The field is included in FK.Employee. | ||||
BalanceLimit | decimal | Balance Limit | - | |
Description:The upper limit for the bank. Once the hours accumulated in the bank reach the limit, the system stops accruing the hours. | ||||
BankID | nvarchar(15) | PTO Bank | PRPTOBank | |
Description:The unique identifier of the PTO bank to be used for the paid-time-off calculation. The field is included in FK.PTOBank. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
EffectiveStartDate | datetime | PTO Bank Effective From | - | |
Description:The start date when the settings of the PTO bank are affected by the current PTO adjustment detail. | ||||
InitialBalance | decimal | Initial Balance | - | |
Description:Year to date available hours for the selected Employee and PTO Bank on the date of adjustment. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified On | - | |
Description:No description available | ||||
NewBalance | decimal | New Balance | - | |
Description:Updated year to date available hours calculated as 'Initial Balance' + 'Adjustment Hours'. | ||||
PaymentDocType | char(3) | Payment Doc. Type | PRPayment | |
Description:The type of the payment. The field is included in FK.Payment. The value of this field corresponds to the value of the PRPayment.DocType field. | ||||
PaymentRefNbr | nvarchar(15) | Payment Ref. Number | PRPayment | |
Description:The unique identifier of the payment. The field is included in FK.Payment. The value of this field corresponds to the value of the PRPayment.RefNbr field. | ||||
ReasonDetails | nvarchar(255) | Reason Details | - | |
Description:The description of the PTO adjustment. | ||||
RefNbr | nvarchar(15) | PRPTOAdjustment | ||
Description:The user-friendly unique identifier of the PTO Adjustment. The field is included in FK.PTOAdjustment. The value of this field corresponds to the value of the PRPTOAdjustment.RefNbr field. | ||||
TStamp | timestamp | - | ||
Description:No description available | ||||
Type | char(3) | - | ||
Description:The type of the PTO adjustment. The field is included in FK.PTOAdjustment. The value of this field corresponds to the value of the PRPTOAdjustment.Type field. | ||||