PRADIBON FILE
ADI Employee Bonus Accrual
This file contains the employee bonus accrual detail.
UPDATED BY
UK102 UK52.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PIB-COMPANY Numeric 4 UK102 UK52.2
Company The company number represents an
established company and is entered on
all function codes.
PIB-REC-TYPE Alpha 1 UK102 UK52.2
Record Type Defines whether or not this is a manual
accrual.
" "
A = Manual Record
PIB-EMPLOYEE Numeric 9 UK102 UK52.2
Employee Contains the employee number. Each
person employed by the company is
assigned a unique number. The system
uses the employee number to correlate
all of the information related to that
person.
PIB-TABLE Alpha 10 UK102 UK52.2
Table Contains the user defined table name.
PIB-EFFECT-DATE Numeric 8 (yyyymmdd) UK102 UK52.2
Effective Date Contains the effective date of the
table.
PIB-ACCRUAL-DATE Numeric 8 (yyyymmdd) UK102 UK52.2
Accrual Date Contains the date the accrual was
calculated and updated on the employee
record (defaults to the To Date
parameter on AD102 as the accrual date).
Also contains the effective date for
manual accruals and is updated when a
manual adjustment and date is entered
on AD22.
PIB-ACCRUAL-AMT Signed 11.2 UK102
Accrual Amount Contains the amount of the periodic
bonus accrual for the employee.
PIB-BNS-HRS-WORKED Signed 6.2 UK102
Bns Hrs Worked Contains the number of hours worked in
the pay period that are used for bonus
accrual calculation. This is determined
by checking the time records in current
status and using the pay class from
AD102.
PIB-PER1-ACCRUAL Signed 11.2
Per1 Accrual Contains the cumulative total of the
monthly system and manual accruals for
the first six month period.
PIB-PAYOUT1-AMT Signed 11.2 UK102
Payout1 Amt Contains the amount of the bonus payout
in the 9th month of service for the
first six months of accruals.
PIB-PAYOUT1-DATE Numeric 8 (yyyymmdd) UK102
Payout1 Date Contains the date of the payout for the
first six month bonus (from the Payment
Date on AD102).
PIB-PER2-ACCRUAL Signed 11.2
Per2 Accrual Contains the cumulative total of the
monthly and manual accruals for the
second six month period.
PIB-PAYOUT2-AMT Signed 11.2 UK102
Payout2 Amt Contains the amount of the bonus payout
in the 15th month of service for the
second six months of accruals.
PIB-PAYOUT2-DATE Numeric 8 (yyyymmdd) UK102
Payout2 Date Contains the date of the payout for the
second six month bonus (from the Payment
Date on AD102).
PIB-MANUAL-ACCRUAL Signed 11.2 UK102 UK52.2
Manual Accrual Contains the amount of manual accrual
adjustments stored with an effective
date entered by the user.
PRADIBON FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PIBSET1 COMPANY UK102 UK52.2
REC-TYPE UK52.3
EMPLOYEE
TABLE
EFFECT-DATE
ACCRUAL-DATE
PIBSET2 COMPANY UK52.2
REC-TYPE
EMPLOYEE
TABLE
EFFECT-DATE
ACCRUAL-DATE*
PIBSET3 COMPANY UK52.1
REC-TYPE
TABLE
EFFECT-DATE
EMPLOYEE
ACCRUAL-DATE
PRADIBON FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PIB-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Progpay PROGPAY Required
PIB-COMPANY -> PGP-COMPANY
"B" -> PGP-REC-TYPE
PIB-TABLE -> PGP-TABLE
PIB-EFFECT-DATE -> PGP-EFFECT-DATE
|