Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PBBLDEDUCT


                            PBBLDEDUCT FILE

UPDATED BY

PR197     PR85.1    PR36.1    PR45.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PLD-COMPANY            Numeric 4                                 PR197   PR85.1
Element: Company Hr    Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

PLD-EMPLOYEE           Numeric 9                                 PR197   PR85.1
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.

PLD-CHECK-ID           Numeric 12                                PR197   PR85.1
Internal Check ID      Contains the payment identification
Number                 number (unique payment identifier used
                       in tracking payment information).

PLD-DED-CODE           Alpha 4                                   PR197   PR85.1
Element: Deduction Code

PLD-EDM-SEQ-NBR        Numeric 4                                 PR197   PR85.1
Emp Deduction
Sequence Number

PLD-PROCESS-LEVEL      Alpha 5                                   PR197   PR85.1
Element: Process Lev HrThis field contains the process level,
                       which is the reporting hierarchy below
                       company.

PLD-WORK-STATE         Alpha 2                                   PR197   PR85.1
Element: Work State    Identifies the state in which the
                       workers' compensation plan is affective.


PLD-WC-STATE           Alpha 2                                   PR197   PR85.1
Element: Wc State

PLD-WC-CODE            Alpha 10                                  PR197   PR85.1
Workers Comp Policy    Contains the workers' compensation code.
Code

PLD-WC-CLASS           Alpha 4                                   PR197   PR85.1
Workers Comp           Contains the workers' compensation
Classification         class.

PLD-WC-RATE            Signed 13.4                               PR197   PR85.1
Element: Wc Rate

PLD-PAYROLL-YEAR       Numeric 4                                 PR197   PR85.1
Element: Current PayrolContains the payroll year in which the
                       allocation was taken.

PLD-QUARTER            Numeric 1                                 PR197   PR85.1
Element: Quarter       Contains the fiscal quarter for the
                       data stored in this record.

PLD-TAX-CATEGORY       Numeric 2                                 PR197   PR85.1
Element: Tax Category

PLD-TAX-AUTH-TYPE      Alpha 2                                   PR197   PR85.1
Element: Tax Auth Type

PLD-ADJUST-PAY         Alpha 1                                   PR197   PR85.1
Element: Adjust Pay

PLD-DED-AMT            Signed 13.2                               PR197   PR85.1
Element: Deduction Amount

PLD-TAX-WAGES          Signed 13.2                               PR197   PR85.1
Element: Taxable Wages

PLD-WAGE-AMOUNT        Signed 13.2                               PR197   PR85.1
Element: Wage Amount   Contains the sum of all wage amounts
                       from the time records for pay codes tied
                       to this pay summary group.

PLD-EXCESS             Signed 13.2                               PR197   PR85.1
Element: Excess

PLD-BILLABLE-AMT       Signed 15.2                               PR197   PR85.1
Element: Billable Amt

PLD-GARN-OBJ-ID        Numeric 12                                PR197   PR85.1
Element: Garn Obj Id

PLD-REPORT-ENTITY      Alpha 5                                   PR197   PR85.1
Element: Report Entity

PLD-BUS-NBR-GRP        Alpha 4                                   PR197   PR85.1
Element: Bus Nbr Grp

PLD-QC-ENT-NBR-GRP     Alpha 4                                   PR197   PR85.1
Element: Qc Ent Nbr Grp

PLD-CURRENCY-CODE      Alpha 5
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

PLD-CURR-ND            Numeric 1
Account Currency       Represents the number of decimals
Code                   defined for the currency of the object.

PLD-BN-DED-CODE        Alpha 1
Element: Bn Ded Code

                         PBBLDEDUCT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PLDSET1   COMPANY                                                PR197   PR36.1
          EMPLOYEE                                               PR45.1  PR85.1
          CHECK-ID
          DED-CODE
          EDM-SEQ-NBR
          REPORT-ENTITY
          BUS-NBR-GRP
          QC-ENT-NBR-GRP
          PROCESS-LEVEL
          WORK-STATE

PLDSET3   COMPANY
          EMPLOYEE
          DED-CODE
          EDM-SEQ-NBR
          CHECK-ID
          REPORT-ENTITY
          BUS-NBR-GRP
          QC-ENT-NBR-GRP
          PROCESS-LEVEL
          WORK-STATE

                         PBBLDEDUCT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Paydeduct      PAYDEDUCTN   Required

                            PLD-COMPANY          -> PYD-COMPANY  (PYDSET1)
                            PLD-EMPLOYEE         -> PYD-EMPLOYEE
                            PLD-CHECK-ID         -> PYD-CHECK-ID
                            PLD-DED-CODE         -> PYD-DED-CODE
                            PLD-EDM-SEQ-NBR      -> PYD-EDM-SEQ-NBR
                            Spaces               -> PYD-REPORT-ENTITY
                            Spaces               -> PYD-BUS-NBR-GRP
                            Spaces               -> PYD-QC-ENT-NBR-GRP
                            PLD-PROCESS-LEVEL    -> PYD-PROCESS-LEVEL
                            PLD-WORK-STATE       -> PYD-WORK-STATE