PAPOSCHG

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 HR11.4 HR28.1 HR511
LT101 LT111 ZH510 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 PR12.6 PR120 PR13.1
PR13.5 PR13.6 PR13.8 PR13.9 PR30.2 PR512
HR00.1 HR01.1 PA302

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PPC-COMPANY
Element: Company Hr
Numeric 4
Contains the company number.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
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 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
PPC-EFFECT-DATE
Element: Effect Date
Numeric 8 (yyyymmdd)
Contains the effective date for the position.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
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 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
PPC-POSITION
Element: Position
Alpha 12
Contains the user-defined code that represents a position in the company.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
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 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
PPC-FLD-NBR
Element: Fld Nbr
Numeric 4
This field contains the PO dictionary field number.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
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 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
PPC-END-DATE
Element: End Date
Numeric 8 (yyyymmdd)
Contains the last date for the position.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
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 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
PPC-UPDATE-TYPE
Element: Update Type
Alpha 3
Indicates whether the update was due to a data change or an end date addition. Data changes include the field number of the position changed.
1 = Data Chg
2 = End Date
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
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 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
PPC-A-VALUE-PRIOR
Element: A Value Prior
Alpha 30 (Lower Case)
Contains the value of any alpha field of the position before the change.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
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 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
PPC-A-VALUE
Element: A Value
Alpha 30 (Lower Case)
Contains the value of the any alpha field of the position after the change.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
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 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
PPC-N-VALUE-PRIOR
Element: N Value Prior
Signed 13.4
Contains the value of any numeric field of the position before the change.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
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 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
PPC-N-VALUE
Element: N Value
Signed 15.6
Contains the value of any numeric field for the position after the change.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
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 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
PPC-RETRO-DATE
Element: Retro Date
Numeric 8 (yyyymmdd)
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
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 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
PPC-HIST-CORR-TYPE
Element: Hist Corr Type
Alpha 1

2 = Retroactive Change
4 = Reverse
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
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 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
PPC-HIST-CORR-FLAG
Element: Hist Corr Flag
Alpha 2

2 = Delete
3 = Move to Hist Error
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
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 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
PPC-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
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 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
PPC-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
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 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
PPC-CREATE-USER
Element: User
Alpha 10 (Lower Case)
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
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 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
PPC-UPDATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
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 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
PPC-UPDATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
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 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
PPC-UPDATE-USER
Element: User
Alpha 10 (Lower Case)
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
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 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510


PAPOSCHG FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PPCSET1 COMPANY
POSITION
EFFECT-DATE
FLD-NBR
...
BN305 HR00.1
HR01.1 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
ZH510 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


PAPOSCHG FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Thu Jun 09 02:25:02 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.