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

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

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

PPC-FLD-NBR            Numeric 4                                 HR11.1  HR11.2
Dictionary Field       This field contains the PO dictionary     HR511   HR650
Number                 field number.                             PA02.1  PA100
                                                                 PA102   PA13.1
                                                                 PA13.2  PA42.1
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

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

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

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

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

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

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

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

PPC-HIST-CORR-TYPE     Alpha 1                                   HR11.1  HR11.2
Element: Hist Corr Type3 = Reverse                               HR511   HR650
                       5 = Position Correction                   PA02.1  PA100
                                                                 PA102   PA13.1
                                                                 PA13.2  PA42.1
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

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

                         PAPOSCHG FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

                         PAPOSCHG FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

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

Company        PRSYSTEM

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

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