Skip to main content
PR

PRPTOAdjustmentDetail

PX.Objects.PRRelease 2025.2

Stores the details of the PTO adjustment

Field NameTypeDisplay NameForeign Key
AdjustmentHours
decimalAdjustment 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.
BAccountIDDefault Navigation
intEmployeePREmployee
Description:The unique identifier of the business account to which the employee bank belongs. The field is included in FK.Employee.
BalanceLimit
decimalBalance Limit-
Description:The upper limit for the bank. Once the hours accumulated in the bank reach the limit, the system stops accruing the hours.
BankIDDefault Navigation
nvarchar(15)PTO BankPRPTOBank
Description:The unique identifier of the PTO bank to be used for the paid-time-off calculation. The field is included in FK.PTOBank.
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime
datetimeCreated On-
Description:No description available
EffectiveStartDate
datetimePTO Bank Effective From-
Description:The start date when the settings of the PTO bank are affected by the current PTO adjustment detail.
InitialBalance
decimalInitial Balance-
Description:Year to date available hours for the selected Employee and PTO Bank on the date of adjustment.
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
Description:No description available
LastModifiedByScreenID
char(8)-
Description:No description available
LastModifiedDateTime
datetimeLast Modified On-
Description:No description available
NewBalance
decimalNew Balance-
Description:Updated year to date available hours calculated as 'Initial Balance' + 'Adjustment Hours'.
PaymentDocType
char(3)Payment Doc. TypePRPayment
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. NumberPRPayment
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.