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

PA03.2    PA03.1    PA502     HR00.1    HR01.1    PA42.1
PR197     PA302

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

PPE-EMPLOYEE         Numeric 9                                   PA502
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.

PPE-REQUISITION      Numeric 9                                   PA502
Requisition          Contains the requisition.

PPE-POSITION         Alpha 12                                    PA502
Position             Contains the user-defined code that
                     represents a position in the company.

PPE-EFFECT-DATE      Numeric 8  (yyyymmdd)                       PA502
Effective Date       Contains the position effective date.

PPE-UPDATE-TYPE      Alpha 3                                     PA502
Update Type          Indicates why the change could not be
                     performed. Data Change indicates an
                     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                    PA502
Pos Level            Contains the position level.
                     01 = Level 1
                     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                                               PA42.1  PA502
          REQUISITION                                            PR197
          POSITION
          EFFECT-DATE
          UPDATE-TYPE

PPESET2   COMPANY                                                PA03.1  PA03.2
          POSITION                                               PA302   PA502
          EFFECT-DATE
          EMPLOYEE
          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