PR
PRPaymentPTOBank
Includes detailed information about the paid time off (PTO) usage and balance data associated to the current pay check.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AccrualAmount | decimal | Paycheck Accrual Hours | - | |
Description:The number of hours accrued for the bank during the current period. | ||||
AccrualLimit | 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. | ||||
AccrualMethod | char(3) | Accrual Method | - | |
Description:The method of PTO hours accrual, which can be one of the following: Percentage or Total Hours per Year. The field can have one of the values described in PTOAccrualMethod.ListAttribute. | ||||
AccrualMoney | decimal | Paycheck Accrual Amount | - | |
Description:The amount of money accrued for the bank during the current period. | ||||
AccrualRate | decimal | Accrual % | - | |
Description:An accrual rate to be used to accumulate hours. | ||||
AccruingDays | int | - | ||
Description:The number of days accrued during the current period. | ||||
AccruingHours | decimal | - | ||
Description:The number of hours accrued during the current period. | ||||
AccumulatedAmount | decimal | Total Accrued Hours | - | |
Description:The number of hours accrued for the bank. | ||||
AccumulatedMoney | decimal | Accrued Amount | - | |
Description:The amount of money accrued for the bank. | ||||
AdjustmentCarryoverHours | decimal | Adjustment Carryover Hours | - | |
Description:PTO adjustment hours applied to the current paycheck as carryover hours from the previous pay period. | ||||
AdjustmentHours | decimal | Adjustment Hours | - | |
Description:PTO adjustment hours applied to the current paycheck. | ||||
AvailableAmount | decimal | Total Available Hours | - | |
Description:The number of hours accrued for the employee through all released paychecks. | ||||
AvailableMoney | decimal | Available Amount | - | |
Description:The amount of money accrued for the employee through all released paychecks. | ||||
BankID | nvarchar(15) | PTO Bank | PRPTOBank | |
Description:The unique identifier of the bank. The field is included in FK.PTOBank The value of this field corresponds to the value of the PRPTOBank.bankID field. | ||||
CalculationFormulaNonexistent in DB | string | Paycheck Accrual Calculation | - | |
Description:The calculation formula for the accrual of PTO hours, which depends on the specified accrual method and the resulting amount. | ||||
CarryoverAmount | decimal | Carryover Hours | - | |
Description:The number of hours the system carries over to the following year. | ||||
CarryoverMoney | decimal | Carryover Amount | - | |
Description:The amount of money the system carries over to the following year. | ||||
CreateFinancialTransactionNonexistent in DB | bool? | - | ||
Description:Enable the money calculation and the creation of general ledger transaction for paid time off on Paychecks and Adjustments. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
DaysInPeriod | int | - | ||
Description:The amount of days during the current period. | ||||
DisbursementAmount | decimal | Disbursement Hours | - | |
Description:The total of the disbursement hours and paid carryover hours. | ||||
DisbursementMoney | decimal | Disbursement Amount | - | |
Description:The amount of disbursement money and paid carryover money. | ||||
DocType | char(3) | Type | PRPayment | |
Description:The document type of the current paycheck. The field is included in FK.Payment The value of this field corresponds to the value of the PRPayment.docType field. | ||||
EarningTypeCDNonexistent in DB | string | Disbursing Earning Type | EPEarningType | |
Description:An earning type code to be used to disburse it on a paycheck. The field is included in FK.DisbursingEarningType. | ||||
EffectiveCoefficientNonexistent in DB | decimal? | - | ||
Description:The effective coefficient which is calculated by dividing the number of days accrued by the amount of days during the current period. | ||||
EffectiveEndDate | datetime | Effective End Date | - | |
Description:The end date when the settings of the PTO bank are applied to the employee. | ||||
EffectiveStartDate | datetime | Effective Date | - | |
Description:The start date when the settings of the PTO bank are applied to the employee. | ||||
FrontLoadingAmount | decimal | Front Loading Hours | - | |
Description:The number of hours the system adds to the bank each year on a date specified in the Start Date box. | ||||
HoursPerYear | decimal | Hours per Year | - | |
Description:The number of hours that the employee may accrue throughout the year. | ||||
IsActive | bit | Active | - | |
Description:Indicates (if set to true) that the bank accrues hours. | ||||
IsCertifiedJob | bit | Applies to Certified Job Only | - | |
Description:Indicates (if set to true) that only hours worked on certified project should be included in the paid time off calculation. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
NbrOfPayPeriodsNonexistent in DB | short? | - | ||
Description:Number of pay periods. | ||||
ProcessedCarryover | bit | Processed Carryover | - | |
Description:Indicates (if set to true) that the PTO has already processed carryover. | ||||
ProcessedFrontLoading | bit | Processed Front Loading | - | |
Description:Indicates (if set to true) that the PTO has already processed front loading. | ||||
RefNbr | nvarchar(15) | Reference Nbr. | PRPayment | |
Description:The reference number of the current paycheck. The field is included in FK.Payment The value of this field corresponds to the value of the PRPayment.refNbr field. | ||||
SettlementDiscardAmount | decimal | Settlement Discard Amount | - | |
Description:Paid time off hours that will not be paid as part of an employee settlement. | ||||
TStamp | timestamp | - | ||
Description:No description available | ||||
TotalAccrualNonexistent in DB | decimal? | Paycheck Total Accrual Hours | - | |
Description:The number of hours accrued for the bank. | ||||
TotalAccrualMoneyNonexistent in DB | decimal? | Total Accrual Amount | - | |
Description:The amount of money accrued for the bank during the current year. | ||||
TotalDisbursementNonexistent in DB | decimal? | Paycheck Disbursed Hours | - | |
Description:The total of the disbursement hours, paid carryover hours and settlement discard amount. | ||||
TotalDisbursementMoneyNonexistent in DB | decimal? | Total Disbursement Amount | - | |
Description:The total amount of money of the disbursement. | ||||
UsedAmount | decimal | Total Used Hours | - | |
Description:The number of hours currently used by the employee. | ||||
UsedMoney | decimal | Used Amount | - | |
Description:The amount of money currently used by the employee. | ||||