Lawson Insight Technical Documentation |
|
PAPEPAUDIT
PAPEPAUDIT FILE
Retroactive Pos, Job Changes
Contains field information for retroactive changes made with HR11.1
(Employee) or PA52.1 (Individual Action).
UPDATED BY
BN305 HAP3.1 HEP4.1 HPOS.1 HPQC.1 HPRS.1
HR11.1 HR11.2 HR15.1 HR511 HR515 HR54.1
HRS1.1 HRSC.1 PA02.1 PA100 PA102 PA113
PA115 PA13.1 PA13.2 PA502 PA513 PA52.1
PA52.3 PA52.4 PA52.5 PA54.1 PA55.1 PR110
PR113 PR120 PR13.1 PR13.5 PR13.6 PR13.8
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PEA-COMPANY Numeric 4 BN305 HAP3.1
Element: Company Hr Contains the company number. HEP4.1 HPOS.1
HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PA55.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEA-EMPLOYEE Numeric 9 BN305 HAP3.1
Element: Employee Contains the employee number. Each HEP4.1 HPOS.1
person employed by the company is HPQC.1 HPRS.1
assigned a unique number. The system HR11.1 HR11.2
uses the employee number to correlate HR15.1 HR511
all of the information related to that HR515 HR54.1
person. HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PA55.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEA-FLD-NBR Numeric 4 BN305 HAP3.1
Element: Fld Nbr This field contains the PO dictionary HEP4.1 HPOS.1
field number. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PA55.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEA-POS-LEVEL Numeric 2 BN305 HAP3.1
Element: Pos Level Contains the position level. HEP4.1 HPOS.1
HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PA55.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEA-EFFECT-DATE Numeric 8 (yyyymmdd) BN305 HAP3.1
Element: Effect Date Contains the effective date the HEP4.1 HPOS.1
position was changed. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PA55.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEA-UPDATE-DATE Numeric 8 (yyyymmdd) BN305 HAP3.1
Element: Update Date This field contains the date the record HEP4.1 HPOS.1
was updated. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PA55.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEA-ACTION-CODE Alpha 10 BN305 HAP3.1
Element: Action Code This field contains the personnel HEP4.1 HPOS.1
action code. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEA-USER-ID Alpha 10 (Lower Case) BN305 HAP3.1
Element: User HEP4.1 HPOS.1
HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEA-ACT-OBJ-ID Numeric 12 BN305 HAP3.1
Element: Obj Id This is the object identifier. It is HEP4.1 HPOS.1
used to relate commitments or posted HPQC.1 HPRS.1
transactions back to the originating HR11.1 HR11.2
subsystems. Each subsystem record that HR15.1 HR511
is updated as a commitment or posted HR515 HR54.1
transaction is assigned an object HRS1.1 HRSC.1
identifier. The object identifier is PA02.1 PA100
maintained in the subsystem files and in PA102 PA113
the Activity Commitments Detail and PA115 PA13.1
Activity Transaction files. The object PA13.2 PA502
identifier is a unique key used to drill PA513 PA52.1
back from Activity Management to the PA52.3 PA52.4
subsystems. PA52.5 PA54.1
PA55.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEA-HIST-CORR-TYPE Alpha 1 BN305 HAP3.1
Element: Hist Corr TypeContains the type of history correction. HEP4.1 HPOS.1
Valid values are: HPQC.1 HPRS.1
1 = Reverse HR11.1 HR11.2
2 = Combine HR15.1 HR511
3 = PEP History Only HR515 HR54.1
5 = Reverse HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEA-ACT-OBJ-ID-REV Numeric 12 BN305 HAP3.1
Element: Act Obj Id RevContains the history action object ID HEP4.1 HPOS.1
for the field being reversed. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEA-HIST-CORR-FLAG Alpha 2 BN305 HAP3.1
Element: Hist Corr FlagThis allows field-level override. If no HEP4.1 HPOS.1
value is entered, the system uses HPQC.1 HPRS.1
default method for the Action or HR11.1 HR11.2
Company. If flag is set as "Don't fix HR15.1 HR511
history log," the system still fixes HR515 HR54.1
PEP. HRS1.1 HRSC.1
1 = Don't fix History Log PA02.1 PA100
2 = Delete PA102 PA113
3 = Move to Hist Error PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PA55.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEA-HOLD-FLAG Alpha 1 PA55.1
Element: Hold Flag This field enables this entire lot to
be put on hold, not allowing any issues
or transfers to be made for this lot.
Y = Yes
PEA-DATE-STAMP Numeric 8 (yyyymmdd) BN305 HAP3.1
Element: Date Stamp This field contains the server date HEP4.1 HPOS.1
(month, date, and year) of the last HPQC.1 HPRS.1
change to this record. HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEA-TIME-STAMP Numeric 6 (hhmmss) BN305 HAP3.1
Element: Time Stamp Contains the server time (hour, minute, HEP4.1 HPOS.1
and second) when the record was last HPQC.1 HPRS.1
changed. HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PAPEPAUDIT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PEASET1 COMPANY BN305 HAP3.1
EMPLOYEE HEP4.1 HPOS.1
POS-LEVEL HPQC.1 HPRS.1
EFFECT-DATE HR11.1 HR11.2
UPDATE-DATE HR15.1 HR511
FLD-NBR HR515 HR54.1
ACT-OBJ-ID HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
...
PEASET2 COMPANY PA113
EMPLOYEE
POS-LEVEL
ACT-OBJ-ID
EFFECT-DATE
UPDATE-DATE
FLD-NBR
PEASET3 COMPANY BN305 HAP3.1
EMPLOYEE HEP4.1 HPOS.1
POS-LEVEL HPQC.1 HPRS.1
FLD-NBR HR11.1 HR11.2
ACT-OBJ-ID HR15.1 HR511
EFFECT-DATE HR515 HR54.1
UPDATE-DATE HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PA55.1 PR110
...
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
Paemployee PAEMPLOYEE Required
PEA-COMPANY -> PEM-COMPANY
PEA-EMPLOYEE -> PEM-EMPLOYEE
Persacthst PERSACTHST Not Required
Valid When PEA-ACT-OBJ-ID != Zeroes
PEA-ACT-OBJ-ID -> PAH-OBJ-ID
Reverse Act PERSACTHST Required
When (PEA-ACT-OBJ-ID-REV != Zeroes )
PEA-ACT-OBJ-ID-REV -> PAH-OBJ-ID
PAPEPAUDIT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Hrhistory HRHISTORY
Valid When (PEA-FLD-NBR != 62 )
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
Pay Hist PRRATEHIST
Valid When (PEA-FLD-NBR = 62 )
PEA-COMPANY -> PRH-COMPANY
PEA-EMPLOYEE -> PRH-EMPLOYEE
PEA-POS-LEVEL -> PRH-POS-LEVEL
PEA-EFFECT-DATE -> PRH-BEG-DATE
PRH-SEQ-NBR
|