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 HR511 PA02.1 PA03.1 PA100 PA102
PA13.1 PA13.2 PA42.1 PA502 PA513 PA52.1
PA52.3 PA52.4 PA52.5 PR13.1 HR00.1 HR01.1
PA302 PBIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PPC-COMPANY Numeric 4 HR11.1 HR511
Company Contains the company number. PA02.1 PA100
PA102 PA13.1
PA13.2 PA42.1
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PPC-EFFECT-DATE Numeric 8 (yyyymmdd) HR11.1 HR511
Effective Date Contains the effective date for the PA02.1 PA100
position. PA102 PA13.1
PA13.2 PA42.1
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PPC-POSITION Alpha 12 HR11.1 HR511
Position Contains the user-defined code that PA02.1 PA100
represents a position in the company. PA102 PA13.1
PA13.2 PA42.1
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PPC-FLD-NBR Numeric 4 HR11.1 HR511
Dictionary Field This field contains the PO dictionary PA02.1 PA100
Number field number. PA102 PA13.1
PA13.2 PA42.1
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PPC-END-DATE Numeric 8 (yyyymmdd) HR11.1 HR511
Ending Date Contains the last date for the position. PA02.1 PA100
PA102 PA13.1
PA13.2 PA42.1
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PPC-UPDATE-TYPE Alpha 3 HR11.1 HR511
Update Type Indicates whether the update was due to PA02.1 PA100
a data change or an end date addition. PA102 PA13.1
Data changes include the field number of PA13.2 PA42.1
the position changed. PA502 PA513
1 = Data Chg PA52.1 PA52.3
2 = End Date PA52.4 PA52.5
PR13.1
PPC-A-VALUE-PRIOR Alpha 30 (Lower Case) HR11.1 HR511
Value Prior Contains the value of any alpha field PA02.1 PA100
of the position before the change. PA102 PA13.1
PA13.2 PA42.1
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PPC-A-VALUE Alpha 30 (Lower Case) HR11.1 HR511
A Value Contains the value of the any alpha PA02.1 PA100
field of the position after the change. PA102 PA13.1
PA13.2 PA42.1
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PPC-N-VALUE-PRIOR Signed 13.4 HR11.1 HR511
N Value Prior Contains the value of any numeric field PA02.1 PA100
of the the position before the change. PA102 PA13.1
PA13.2 PA42.1
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PPC-N-VALUE Signed 13.4 HR11.1 HR511
N Value Contains the value of any numeric field PA02.1 PA100
for the position after the change. PA102 PA13.1
PA13.2 PA42.1
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PAPOSCHG FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PPCSET1 COMPANY HR00.1 HR01.1
POSITION HR11.1 HR511
EFFECT-DATE PA02.1 PA03.1
FLD-NBR PA100 PA102
PA13.1 PA13.2
PA302 PA42.1
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PBIP.1 PR13.1
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
|