PRADIBON FILE
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
Element: Company Hr
PIB-REC-TYPE Alpha 1 UK102 UK52.2
Element: Rec Type Defines whether or not this is a manual
accrual.
" "
A = Manual Record
PIB-EMPLOYEE Numeric 9 UK102 UK52.2
Element: 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
Element: Table Contains the user defined table name.
PIB-EFFECT-DATE Numeric 8 (yyyymmdd) UK102 UK52.2
Element: Effect Date Contains the effective date of the
table.
PIB-ACCRUAL-DATE Numeric 8 (yyyymmdd) UK102 UK52.2
Element: 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
Element: Accrual Amt Contains the amount of the periodic
bonus accrual for the employee.
PIB-BNS-HRS-WORKED Signed 6.2 UK102
Element: Bns Hrs WorkedContains 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
Element: 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
Element: Payout1 Amt Contains the amount of the bonus pay
out in the 9th month of service for the
first six months of accruals.
PIB-PAYOUT1-DATE Numeric 8 (yyyymmdd) UK102
Element: Payout1 Date Contains the date of the pay out for
the first six month bonus (from the
Payment Date on AD102).
PIB-PER2-ACCRUAL Signed 11.2
Element: 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
Element: Payout2 Amt Contains the amount of the bonus pay
out in the 15th month of service for the
second six months of accruals.
PIB-PAYOUT2-DATE Numeric 8 (yyyymmdd) UK102
Element: Payout2 Date Contains the date of the pay out for
the second six month bonus (from the
Payment Date on AD102).
PIB-MANUAL-ACCRUAL Signed 11.2 UK102 UK52.2
Element: Manual AccrualContains the amount of manual accrual
adjustments stored with an effective
date entered by the user.
PIB-CURRENCY-CODE Alpha 5
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
PIB-CURR-ND Numeric 1
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
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
Employee EMPLOYEE Required
PIB-COMPANY -> EMP-COMPANY
PIB-EMPLOYEE -> EMP-EMPLOYEE
Progpay PROGPAY Required
PIB-COMPANY -> PGP-COMPANY
"B" -> PGP-REC-TYPE
PIB-TABLE -> PGP-TABLE
PIB-EFFECT-DATE -> PGP-EFFECT-DATE
|
