Lawson Insight Technical Documentation |
|
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 PA02.1 PA03.1 PA100
PA102 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 PBIP.1 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PPC-COMPANY Numeric 4 HR11.1 HR11.2
Element: Company Hr Contains the company number. HR511 PA02.1
PA100 PA102
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) HR11.1 HR11.2
Element: Effective DateContains the effective date for the HR511 PA02.1
position. PA100 PA102
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 HR11.1 HR11.2
Element: Position Contains the user-defined code that HR511 PA02.1
represents a position in the company. PA100 PA102
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 HR11.1 HR11.2
Dictionary Field This field contains the PO dictionary HR511 PA02.1
Number field number. PA100 PA102
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) HR11.1 HR11.2
Element: Ending Date Contains the last date for the position. HR511 PA02.1
PA100 PA102
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 HR11.1 HR11.2
Element: Update Type Indicates whether the update was due to HR511 PA02.1
a data change or an end date addition. PA100 PA102
Data changes include the field number of PA13.1 PA13.2
the position changed. PA42.1 PA42.3
1 = Data Chg PA502 PA513
2 = End Date 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) HR11.1 HR11.2
Element: Value Prior Contains the value of any alpha field HR511 PA02.1
of the position before the change. PA100 PA102
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) HR11.1 HR11.2
Element: A Value Contains the value of the any alpha HR511 PA02.1
field of the position after the change. PA100 PA102
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 HR11.1 HR11.2
Element: N Value Prior Contains the value of any numeric field HR511 PA02.1
of the position before the change. PA100 PA102
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 HR11.1 HR11.2
Element: N Value Contains the value of any numeric field HR511 PA02.1
for the position after the change. PA100 PA102
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) HR11.1 HR11.2
Element: Retro Date HR511 PA02.1
PA100 PA102
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 HR11.1 HR11.2
Element: Hist Corr Type2 = Retroactive Change HR511 PA02.1
4 = Reverse PA100 PA102
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 HR11.1 HR11.2
Element: Hist Corr Flag2 = Delete HR511 PA02.1
3 = Move to Hist Error PA100 PA102
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 HR00.1 HR01.1
POSITION HR11.1 HR11.2
EFFECT-DATE HR511 PA02.1
FLD-NBR PA03.1 PA100
PA102 PA13.1
PA13.2 PA302
PA42.1 PA42.3
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA535 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
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
|