|
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
BN305 HR11.1 HR11.2 HR511 PA02.1 PA03.1
PA100 PA102 PA115 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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PPC-COMPANY Numeric 4 BN305 HR11.1
Element: Company Hr Contains the company number. HR11.2 HR511
PA02.1 PA100
PA102 PA115
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) BN305 HR11.1
Element: Effect Date Contains the effective date for the HR11.2 HR511
position. PA02.1 PA100
PA102 PA115
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 BN305 HR11.1
Element: Position Contains the user-defined code that HR11.2 HR511
represents a position in the company. PA02.1 PA100
PA102 PA115
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 BN305 HR11.1
Element: Fld Nbr This field contains the PO dictionary HR11.2 HR511
field number. PA02.1 PA100
PA102 PA115
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) BN305 HR11.1
Element: End Date Contains the last date for the position. HR11.2 HR511
PA02.1 PA100
PA102 PA115
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 BN305 HR11.1
Element: Update Type Indicates whether the update was due to HR11.2 HR511
a data change or an end date addition. PA02.1 PA100
Data changes include the field number of PA102 PA115
the position changed. PA13.1 PA13.2
1 = Data Chg PA42.1 PA42.3
2 = End Date 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-PRIOR Alpha 30 (Lower Case) BN305 HR11.1
Element: A Value Prior Contains the value of any alpha field HR11.2 HR511
of the position before the change. PA02.1 PA100
PA102 PA115
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) BN305 HR11.1
Element: A Value Contains the value of the any alpha HR11.2 HR511
field of the position after the change. PA02.1 PA100
PA102 PA115
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 BN305 HR11.1
Element: N Value Prior Contains the value of any numeric field HR11.2 HR511
of the position before the change. PA02.1 PA100
PA102 PA115
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 BN305 HR11.1
Element: N Value Contains the value of any numeric field HR11.2 HR511
for the position after the change. PA02.1 PA100
PA102 PA115
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) BN305 HR11.1
Element: Retro Date HR11.2 HR511
PA02.1 PA100
PA102 PA115
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 BN305 HR11.1
Element: Hist Corr Type2 = Retroactive Change HR11.2 HR511
4 = Reverse PA02.1 PA100
PA102 PA115
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 BN305 HR11.1
Element: Hist Corr Flag2 = Delete HR11.2 HR511
3 = Move to Hist Error PA02.1 PA100
PA102 PA115
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 BN305 HR00.1
POSITION HR01.1 HR11.1
EFFECT-DATE HR11.2 HR511
FLD-NBR PA02.1 PA03.1
PA100 PA102
PA115 PA13.1
PA13.2 PA302
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 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
|