Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            PBBLDEDUCT FILE

UPDATED BY

PR197     PR85.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PLD-COMPANY          Numeric 4                                   PR197   PR85.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.

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

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

PLD-PROCESS-LEVEL    Alpha 5                                     PR197   PR85.1
Process Level        This field contains the process level,
                     which is the reporting hierarchy below
                     company.

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


PLD-WC-STATE         Alpha 2                                     PR197   PR85.1
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
Wc Rate

PLD-PAYROLL-YEAR     Numeric 4                                   PR197   PR85.1
Current Payroll Year Contains the payroll year in which the
                     allocation was taken.

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

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

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

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

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

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

PLD-WAGE-AMOUNT      Signed 13.2                                 PR197   PR85.1
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
Excess

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

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

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

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

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

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

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

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

                         PBBLDEDUCT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PLDSET1   COMPANY                                                PR197   PR85.1
          EMPLOYEE
          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