Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             PAPOSERR FILE

                            Position Errors

Holds information that is error when you run PA02.1 (Positions).

UPDATED BY

PA02.1    PA03.2    PA03.1    PA100     PA102     PA502
PA52.1    PA52.5    HR00.1    HR01.1    HR11.1    PA115
PA42.1    PBIP.1    PR197     PA302

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PPE-COMPANY          Numeric 4                                   PA02.1  PA102
Company              The company number represents an            PA502   PA52.1
                     established company and is entered on       PA52.5
                     all function codes.


PPE-EMPLOYEE         Numeric 9                                   PA02.1  PA102
Employee             Contains the employee number. Each          PA502   PA52.1
                     person employed by the company is           PA52.5
                     assigned a unique number. The system
                     uses the employee number to correlate
                     all of the information related to that
                     person.


PPE-REQUISITION      Numeric 9                                   PA02.1  PA102
Requisition          Contains the requisition.                   PA502   PA52.1
                                                                 PA52.5

PPE-POSITION         Alpha 12                                    PA02.1  PA102
Position             Contains the user-defined code that         PA502   PA52.1
                     represents a position in the company.       PA52.5

PPE-EFFECT-DATE      Numeric 8  (yyyymmdd)                       PA02.1  PA102
Effective Date       Contains the position effective date.       PA502   PA52.1
                                                                 PA52.5

PPE-UPDATE-TYPE      Alpha 3                                     PA02.1  PA102
Update Type          Indicates why the change could not be       PA502   PA52.1
                     performed. Data Change indicates an         PA52.5
                     action exists for an employee; End Date
                     indicates the position has ended; and
                     Upd Error indicates a general error.
                     1 = Data Change
                     2 = End Date
                     3 = Upd Error

PPE-POS-LEVEL        Numeric 2 Occurs 5 Times                    PA02.1  PA100
Pos Level            Contains the position level.                PA102   PA502
                     01 = Level 1                                PA52.1  PA52.5
                     02 = Level 2
                     03 = Level 3
                     04 = Level 4
                     05 = Level 5

                         PAPOSERR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PPESET1   COMPANY                                                HR00.1  HR01.1
          EMPLOYEE                                               HR11.1  PA02.1
          REQUISITION                                            PA100   PA102
          POSITION                                               PA115   PA42.1
          EFFECT-DATE                                            PA502   PBIP.1
          UPDATE-TYPE                                            PR197

PPESET2   COMPANY                                                PA02.1  PA03.1
          POSITION                                               PA03.2  PA102
          EFFECT-DATE                                            PA302   PA502
          EMPLOYEE                                               PA52.1  PA52.5
          REQUISITION
          UPDATE-TYPE

                         PAPOSERR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PPE-COMPANY        -> PRS-COMPANY
                            Spaces             -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required
                            When (PPE-EMPLOYEE != Zeroes )

                            PPE-COMPANY        -> EMP-COMPANY
                            PPE-EMPLOYEE       -> EMP-EMPLOYEE

Position       PAPOSITION   Required

                            PPE-COMPANY        -> POS-COMPANY
                            PPE-POSITION       -> POS-POSITION
                            PPE-EFFECT-DATE    -> POS-EFFECT-DATE

Requisition    PAJOBREQ     Required
                            When (PPE-REQUISITION != Zeroes )

                            PPE-COMPANY        -> PJR-COMPANY
                            PPE-REQUISITION    -> PJR-REQUISITION

                         PAPOSERR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Mult Pos       PAEMPPOS
                            Valid When (PPE-EMPLOYEE != Zeroes )

                            PPE-COMPANY        -> PEP-COMPANY
                            PPE-EMPLOYEE       -> PEP-EMPLOYEE
                                                  PEP-POS-LEVEL
                                                  PEP-EFFECT-DATE

Pos Chg        PAPOSCHG

                            PPE-COMPANY        -> PPC-COMPANY
                            PPE-POSITION       -> PPC-POSITION
                            PPE-EFFECT-DATE    -> PPC-EFFECT-DATE
                                                  PPC-FLD-NBR