Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PAPOSERR


                             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    PA42.3    PA535     PBIP.1    PR197     PA302

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PPE-COMPANY            Numeric 4                                 PA02.1  PA102
Element: Company Hr    Identifies the AP company if the          PA502   PA52.1
                       resource type = V.  Identifies the HR     PA52.5
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

PPE-EMPLOYEE           Numeric 9                                 PA02.1  PA102
Element: 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
Element: Requisition   Contains the requisition.                 PA502   PA52.1
                                                                 PA52.5

PPE-POSITION           Alpha 12                                  PA02.1  PA102
Element: 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
Element: Effective DateContains the position effective date.     PA502   PA52.1
                                                                 PA52.5

PPE-UPDATE-TYPE        Alpha 3                                   PA02.1  PA102
Element: 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 98 Times                 PA02.1  PA100
Element: Pos Level     Contains the position level.              PA102   PA502
                                                                 PA52.1  PA52.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                                            PA42.3  PA502
          UPDATE-TYPE                                            PA535   PBIP.1
                                                                 PR197

PPESET2   COMPANY                                                PA02.1  PA03.1
          POSITION                                               PA03.2  PA03.3
          EFFECT-DATE                                            PA102   PA302
          EMPLOYEE                                               PA502   PA52.1
          REQUISITION                                            PA52.5
          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

Paemployee     PAEMPLOYEE   Required
                            When (PPE-EMPLOYEE != Zeroes )

                            PPE-COMPANY        -> PEM-COMPANY
                            PPE-EMPLOYEE       -> PEM-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