PRADIBON – Employee Bonus Accrual Detail

System
Payroll (PR)
Prefix
PIB
Primary key
COMPANY, REC-TYPE, EMPLOYEE, TABLE, EFFECT-DATE, ACCRUAL-DATE
Fields
17
Updated by
2 programs
Referenced by
0 programs

PRADIBON is the Employee Bonus Accrual Detail table in Lawson Payroll (prefix PIB). It is indexed by COMPANY, REC-TYPE, EMPLOYEE, TABLE, EFFECT-DATE, ACCRUAL-DATE (PIBSET1); alternate indexes: PIBSET2 and PIBSET3. It is related 1:1 to PRSYSTEM, EMPLOYEE and PROGPAY. It is updated by UK102 and UK52.2. The table has 17 fields, 3 indexes and 3 documented relations.

About PRADIBON

No description in the Lawson data dictionary.

Fields (17)

Column = COBOL field name without the PIB- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PIB-COMPANY PK
COMPANY		Numeric 4—UK102, UK52.2
#PIB-REC-TYPE PK
REC_TYPE		Alpha 1Defines whether or not this is a manual accrual. " "
  • A Manual Record
UK102, UK52.2
#PIB-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains 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.UK102, UK52.2
#PIB-TABLE PK
TABLE		Alpha 10Contains the user defined table name.UK102, UK52.2
#PIB-EFFECT-DATE PK
EFFECT_DATE		Numeric 8 (yyyymmdd)Contains the effective date of the table.UK102, UK52.2
#PIB-ACCRUAL-DATE PK
ACCRUAL_DATE		Numeric 8 (yyyymmdd)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.UK102, UK52.2
#PIB-ACCRUAL-AMT
ACCRUAL_AMT		Signed 11.2Contains the amount of the periodic bonus accrual for the employee.UK102
#PIB-BNS-HRS-WORKED
BNS_HRS_WORKED		Signed 6.2Contains 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.UK102
#PIB-PER1-ACCRUAL
PER1_ACCRUAL		Signed 11.2Contains the cumulative total of the monthly system and manual accruals for the first six month period.—
#PIB-PAYOUT1-AMT
PAYOUT1_AMT		Signed 11.2Contains the amount of the bonus pay out in the 9th month of service for the first six months of accruals.UK102
#PIB-PAYOUT1-DATE
PAYOUT1_DATE		Numeric 8 (yyyymmdd)Contains the date of the pay out for the first six month bonus (from the Payment Date on AD102).UK102
#PIB-PER2-ACCRUAL
PER2_ACCRUAL		Signed 11.2Contains the cumulative total of the monthly and manual accruals for the second six month period.—
#PIB-PAYOUT2-AMT
PAYOUT2_AMT		Signed 11.2Contains the amount of the bonus pay out in the 15th month of service for the second six months of accruals.UK102
#PIB-PAYOUT2-DATE
PAYOUT2_DATE		Numeric 8 (yyyymmdd)Contains the date of the pay out for the second six month bonus (from the Payment Date on AD102).UK102
#PIB-MANUAL-ACCRUAL
MANUAL_ACCRUAL		Signed 11.2Contains the amount of manual accrual adjustments stored with an effective date entered by the user.UK102, UK52.2
#PIB-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).—
#PIB-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.—

Indexes (3)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PIBSET1
  1. COMPANY
  2. REC-TYPE
  3. EMPLOYEE
  4. TABLE
  5. EFFECT-DATE
  6. ACCRUAL-DATE
PrimaryUK102, UK52.2, UK52.3
PIBSET2
  1. COMPANY
  2. REC-TYPE
  3. EMPLOYEE
  4. TABLE
  5. EFFECT-DATE
  6. ACCRUAL-DATE ↓
UK52.2
PIBSET3
  1. COMPANY
  2. REC-TYPE
  3. TABLE
  4. EFFECT-DATE
  5. EMPLOYEE
  6. ACCRUAL-DATE
UK52.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PRSYSTEMEMPLOYEEPROGPAYPRADIBON

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
PIB-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequired
PIB-COMPANY→EMP-COMPANY
PIB-EMPLOYEE→EMP-EMPLOYEE
ProgpayPROGPAYRequired
PIB-COMPANY→PGP-COMPANY
"B"→PGP-REC-TYPE
PIB-TABLE→PGP-TABLE
PIB-EFFECT-DATE→PGP-EFFECT-DATE

Programs

Updated by (2)