Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PAPOSCHG


                             PAPOSCHG FILE

                            Position Changes

Contains
- pending changes when you run PA02.1 (Positions) and elect to update
affected records later, and
- changes for situations that can not be resolved by PA02.1 when you elect to
update affected records immediately.

UPDATED BY

BN305     HR11.1    HR11.2    HR511     PA02.1    PA03.1
PA100     PA102     PA115     PA13.1    PA13.2    PA42.1
PA42.3    PA502     PA513     PA52.1    PA52.3    PA52.4
PA52.5    PA535     PR110     PR113     PR120     PR13.1
PR13.5    PR13.6    PR13.8    HR00.1    HR01.1    PA302


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PPC-COMPANY            Numeric 4                                 BN305   HR11.1
Element: Company Hr    Contains the company number.              HR11.2  HR511
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA42.1  PA42.3
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA535   PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PPC-EFFECT-DATE        Numeric 8  (yyyymmdd)                     BN305   HR11.1
Element: Effect Date   Contains the effective date for the       HR11.2  HR511
                       position.                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA42.1  PA42.3
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA535   PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PPC-POSITION           Alpha 12                                  BN305   HR11.1
Element: Position      Contains the user-defined code that       HR11.2  HR511
                       represents a position in the company.     PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA42.1  PA42.3
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA535   PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PPC-FLD-NBR            Numeric 4                                 BN305   HR11.1
Element: Fld Nbr       This field contains the PO dictionary     HR11.2  HR511
                       field number.                             PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA42.1  PA42.3
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA535   PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PPC-END-DATE           Numeric 8  (yyyymmdd)                     BN305   HR11.1
Element: End Date      Contains the last date for the position.  HR11.2  HR511
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA42.1  PA42.3
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA535   PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PPC-UPDATE-TYPE        Alpha 3                                   BN305   HR11.1
Element: Update Type   Indicates whether the update was due to   HR11.2  HR511
                       a data change or an end date addition.    PA02.1  PA100
                       Data changes include the field number of  PA102   PA115
                       the position changed.                     PA13.1  PA13.2
                       1 = Data Chg                              PA42.1  PA42.3
                       2 = End Date                              PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA535   PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PPC-A-VALUE-PRIOR      Alpha 30  (Lower Case)                    BN305   HR11.1
Element: A Value Prior Contains the value of any alpha field     HR11.2  HR511
                       of the position before the change.        PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA42.1  PA42.3
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA535   PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PPC-A-VALUE            Alpha 30  (Lower Case)                    BN305   HR11.1
Element: A Value       Contains the value of the any alpha       HR11.2  HR511
                       field of the position after the change.   PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA42.1  PA42.3
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA535   PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PPC-N-VALUE-PRIOR      Signed 13.4                               BN305   HR11.1
Element: N Value Prior Contains the value of any numeric field   HR11.2  HR511
                       of the position before the change.        PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA42.1  PA42.3
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA535   PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PPC-N-VALUE            Signed 15.6                               BN305   HR11.1
Element: N Value       Contains the value of any numeric field   HR11.2  HR511
                       for the position after the change.        PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA42.1  PA42.3
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA535   PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PPC-RETRO-DATE         Numeric 8  (yyyymmdd)                     BN305   HR11.1
Element: Retro Date                                              HR11.2  HR511
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA42.1  PA42.3
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA535   PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PPC-HIST-CORR-TYPE     Alpha 1                                   BN305   HR11.1
Element: Hist Corr Type2 = Retroactive Change                    HR11.2  HR511
                       4 = Reverse                               PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA42.1  PA42.3
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA535   PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PPC-HIST-CORR-FLAG     Alpha 2                                   BN305   HR11.1
Element: Hist Corr Flag2 = Delete                                HR11.2  HR511
                       3 = Move to Hist Error                    PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA42.1  PA42.3
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA535   PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

                         PAPOSCHG FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PPCSET1   COMPANY                                                BN305   HR00.1
          POSITION                                               HR01.1  HR11.1
          EFFECT-DATE                                            HR11.2  HR511
          FLD-NBR                                                PA02.1  PA03.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA302
                                                                 PA42.1  PA42.3
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA535   PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

                         PAPOSCHG FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PPC-COMPANY        -> PRS-COMPANY
                            Spaces             -> PRS-PROCESS-LEVEL

Field Nbr      PADICT       Required
                            When (PPC-FLD-NBR != Zeroes )

                            PPC-FLD-NBR        -> PAD-FLD-NBR

Position       PAPOSITION   Required

                            PPC-COMPANY        -> POS-COMPANY
                            PPC-POSITION       -> POS-POSITION
                            PPC-EFFECT-DATE    -> POS-EFFECT-DATE

                         PAPOSCHG FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Pos Chg Error  PAPOSERR     Delete Cascades

                            PPC-COMPANY        -> PPE-COMPANY
                            PPC-POSITION       -> PPE-POSITION
                            PPC-EFFECT-DATE    -> PPE-EFFECT-DATE
                                                  PPE-EMPLOYEE
                                                  PPE-REQUISITION
                                                  PPE-UPDATE-TYPE