Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRADIBON


                             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       The company number represents an
                       established company and is entered on
                       all function codes.

PIB-REC-TYPE           Alpha 1                                   UK102   UK52.2
Element: Record 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: 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 AmountContains 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
Account Currency
Code

                         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