PAPEPAUDIT FILE
Retroactive Pos, Job Changes
Contains field information for retroactive changes made with HR11.1
(Employee) or PA52.1 (Individual Action).
UPDATED BY
HR11.1 HR511 PA02.1 PA100 PA102 PA113
PA13.1 PA13.2 PA502 PA513 PA52.1 PA52.3
PA52.4 PA52.5 PR110 PR13.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PEA-COMPANY Numeric 4 HR11.1 HR511
Company Contains the company number. PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR13.1
PEA-EMPLOYEE Numeric 9 HR11.1 HR511
Employee Contains the employee number. Each PA02.1 PA100
person employed by the company is PA102 PA13.1
assigned a unique number. The system PA13.2 PA502
uses the employee number to correlate PA513 PA52.1
all of the information related to that PA52.3 PA52.4
person. PA52.5 PR110
PR13.1
PEA-FLD-NBR Numeric 4 Occurs 16 Times HR11.1 HR511
Dictionary Field This field contains the PO dictionary PA02.1 PA100
Number field number. PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR13.1
PEA-POS-LEVEL Numeric 2 HR11.1 HR511
Pos Level Contains the position level. PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR13.1
PEA-EFFECT-DATE Numeric 8 (yyyymmdd) HR11.1 HR511
Effective Date Contains the effective date the PA02.1 PA100
position was changed. PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR13.1
PEA-UPDATE-DATE Numeric 8 (yyyymmdd) HR11.1 HR511
Update Date This field contains the date the record PA02.1 PA100
was updated. PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR13.1
PEA-ACTION-CODE Alpha 10 HR11.1 HR511
Action Code This field contains the personnel PA02.1 PA100
action code. PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEA-USER-ID Alpha 10 (Lower Case) HR11.1 HR511
User ID Name Contains the user ID of the person who PA02.1 PA100
last changed this record. PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR13.1
PAPEPAUDIT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PEASET1 COMPANY HR11.1 HR511
EMPLOYEE PA02.1 PA100
POS-LEVEL PA102 PA113
EFFECT-DATE PA115 PA13.1
UPDATE-DATE PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR13.1
PAPEPAUDIT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Action Code PERSACTYPE Required
When (PEA-ACTION-CODE != Spaces )
PEA-COMPANY -> PAT-COMPANY
PEA-ACTION-CODE -> PAT-ACTION-CODE
Company PRSYSTEM Required
PEA-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
PEA-COMPANY -> EMP-COMPANY
PEA-EMPLOYEE -> EMP-EMPLOYEE
Fld Nbr PADICT Required
PEA-FLD-NBR -> PAD-FLD-NBR
PAPEPAUDIT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Hrhistory HRHISTORY
PEA-COMPANY -> HRH-COMPANY
PEA-EMPLOYEE -> HRH-EMPLOYEE
Zeroes -> HRH-OBJ-ID
PEA-FLD-NBR -> HRH-FLD-NBR
PEA-POS-LEVEL -> HRH-POS-LEVEL
PEA-EFFECT-DATE -> HRH-BEG-DATE
HRH-SEQ-NBR
|