Lawson Insight Technical Documentation

                             PRDEDDTL FILE

UPDATED BY

AC542     BN66.1    PR140     PR189     PR195     PR197
PR80.1    PR82.1    PR85.1    PR89.1    PR300     HR00.1
HR01.1    HR11.1    PA115     PBIP.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PDE-COMPANY          Numeric 4                                   BN66.1  PR140
Company              The company number represents an            PR189   PR195
                     established company and is entered on       PR80.1  PR89.1
                     all function codes.


PDE-EMPLOYEE         Numeric 9                                   BN66.1  PR140
Employee             Contains the employee number. Each          PR189   PR195
                     person employed by the company is           PR80.1  PR89.1
                     assigned a unique number. The system
                     uses the employee number to correlate
                     all of the information related to that
                     person.


PDE-PYD-OBJ-ID       Numeric 12                                  BN66.1  PR140
Pyd Obj Id                                                       PR189   PR195
                                                                 PR80.1  PR89.1

PDE-QTD-OBJ-ID       Numeric 12                                  AC542   BN66.1
Qtd Obj Id                                                       PR140   PR189
                                                                 PR195   PR197
                                                                 PR80.1  PR82.1
                                                                 PR85.1  PR89.1

PDE-TAX-STATUS       Alpha 2                                     BN66.1  PR140
Tax Status                                                       PR189   PR195
                                                                 PR80.1  PR89.1

PDE-NONTAX-REMUN     Signed 13.2                                 BN66.1  PR140
Nontax Remun                                                     PR189   PR195
                                                                 PR80.1  PR89.1

PDE-TAXABLE-MATCH    Signed 13.2                                 BN66.1  PR140
Taxable Match                                                    PR189   PR195
                                                                 PR80.1  PR89.1

PDE-REMUN-CODE       Alpha 4
Remun Code

                         PRDEDDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PDESET1   PYD-OBJ-ID                                             AC542   BN66.1
          TAX-STATUS                                             PR140   PR189
                                                                 PR195   PR197
                                                                 PR80.1  PR82.1
                                                                 PR85.1  PR89.1

PDESET2   QTD-OBJ-ID    KeyChange, Subset                        PR300
          TAX-STATUS    Where QTD-OBJ-ID != Zeroes
          PYD-OBJ-ID

PDESET3   COMPANY       Subset                                   HR00.1  HR01.1
          EMPLOYEE      Where TAX-STATUS != Spaces               HR11.1  PA115
          PYD-OBJ-ID                                             PBIP.1  PR197
          TAX-STATUS

PDESET4   COMPANY       Subset
          EMPLOYEE      Where REMUN-CODE != Spaces
          PYD-OBJ-ID
          REMUN-CODE

PDESET5   COMPANY       Subset
          EMPLOYEE      Where REMUN-CODE != Spaces
          REMUN-CODE
          PYD-OBJ-ID