 |
Lawson Insight Technical Documentation |
|
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
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
Effective 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
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
Ending 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
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
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
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
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
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
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
Hist Corr Type 3 = 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
Hist Corr Flag 2 = 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
|