 |
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
HR511 HR650 PA03.1 PA42.1 PA502 PA513
PR13.1 PR13.5 PR13.6 PR13.8 HR00.1 HR01.1
PA302 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PPC-COMPANY Numeric 4 HR511 HR650
Company Contains the company number. PA42.1 PA502
PA513 PR13.1
PR13.5 PR13.6
PR13.8
PPC-EFFECT-DATE Numeric 8 (yyyymmdd) HR511 HR650
Effective Date Contains the effective date for the PA42.1 PA502
position. PA513 PR13.1
PR13.5 PR13.6
PR13.8
PPC-POSITION Alpha 12 HR511 HR650
Position Contains the user-defined code that PA42.1 PA502
represents a position in the company. PA513 PR13.1
PR13.5 PR13.6
PR13.8
PPC-FLD-NBR Numeric 4 HR511 HR650
Dictionary Field This field contains the PO dictionary PA42.1 PA502
Number field number. PA513 PR13.1
PR13.5 PR13.6
PR13.8
PPC-END-DATE Numeric 8 (yyyymmdd) HR511 HR650
Ending Date Contains the last date for the position. PA42.1 PA502
PA513 PR13.1
PR13.5 PR13.6
PR13.8
PPC-UPDATE-TYPE Alpha 3 HR511 HR650
Update Type Indicates whether the update was due to PA42.1 PA502
a data change or an end date addition. PA513 PR13.1
Data changes include the field number of PR13.5 PR13.6
the position changed. PR13.8
1 = Data Chg
2 = End Date
PPC-A-VALUE-PRIOR Alpha 30 (Lower Case) HR511 HR650
Value Prior Contains the value of any alpha field PA42.1 PA502
of the position before the change. PA513 PR13.1
PR13.5 PR13.6
PR13.8
PPC-A-VALUE Alpha 30 (Lower Case) HR511 HR650
A Value Contains the value of the any alpha PA42.1 PA502
field of the position after the change. PA513 PR13.1
PR13.5 PR13.6
PR13.8
PPC-N-VALUE-PRIOR Signed 13.4 HR511 HR650
N Value Prior Contains the value of any numeric field PA42.1 PA502
of the position before the change. PA513 PR13.1
PR13.5 PR13.6
PR13.8
PPC-N-VALUE Signed 13.4 HR511 HR650
N Value Contains the value of any numeric field PA42.1 PA502
for the position after the change. PA513 PR13.1
PR13.5 PR13.6
PR13.8
PPC-RETRO-DATE Numeric 8 (yyyymmdd) HR511 HR650
Retro Date PA42.1 PA502
PA513 PR13.1
PR13.5 PR13.6
PR13.8
PPC-HIST-CORR-TYPE Alpha 1 HR511 HR650
Hist Corr Type 3 = Reverse PA42.1 PA502
5 = Position Correction PA513 PR13.1
PR13.5 PR13.6
PR13.8
PPC-HIST-CORR-FLAG Alpha 2 HR511 HR650
Hist Corr Flag 2 = Delete PA42.1 PA502
3 = Move to Hist Error PA513 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 HR511 HR650
EFFECT-DATE PA03.1 PA302
FLD-NBR PA42.1 PA502
PA513 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
|