 |
Lawson Insight Technical Documentation |
|
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 HR11.2 HR15.1 HR511 HR515 HR54.1
HR650 HRS1.1 HRSC.1 PA02.1 PA100 PA102
PA113 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
PRSC.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PEA-COMPANY Numeric 4 HR11.1 HR11.2
Company Contains the company number. HR15.1 HR511
HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 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
PRSC.1
PEA-EMPLOYEE Numeric 9 HR11.1 HR11.2
Employee Contains the employee number. Each HR15.1 HR511
person employed by the company is HR515 HR54.1
assigned a unique number. The system HR650 HRS1.1
uses the employee number to correlate HRSC.1 PA02.1
all of the information related to that PA100 PA102
person. PA113 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
PRSC.1
PEA-FLD-NBR Numeric 4 HR11.1 HR11.2
Dictionary Field This field contains the PO dictionary HR15.1 HR511
Number field number. HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 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
PRSC.1
PEA-POS-LEVEL Numeric 2 HR11.1 HR11.2
Pos Level Contains the position level. HR15.1 HR511
HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 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
PRSC.1
PEA-EFFECT-DATE Numeric 8 (yyyymmdd) HR11.1 HR11.2
Effective Date Contains the effective date the HR15.1 HR511
position was changed. HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 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
PRSC.1
PEA-UPDATE-DATE Numeric 8 (yyyymmdd) HR11.1 HR11.2
Update Date This field contains the date the record HR15.1 HR511
was updated. HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 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
PRSC.1
PEA-ACTION-CODE Alpha 10 HR11.1 HR11.2
Action Code This field contains the personnel HR15.1 HR511
action code. HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 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 PRSC.1
PEA-USER-ID Alpha 10 (Lower Case) HR11.1 HR11.2
User ID Name Contains the user ID of the person who HR15.1 HR511
last changed this record. HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 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 PRSC.1
PEA-ACT-OBJ-ID Numeric 12 HR11.1 HR11.2
Subsystem Activity A subsystem activity interface HR15.1 HR511
InterfaceID identification number. Used for Drill HR515 HR54.1
Around purposes. HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 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
PRSC.1
PEA-HIST-CORR-TYPE Alpha 1 HR11.1 HR11.2
Hist Corr Type Contains the type of history correction. HR15.1 HR511
Valid values are: HR515 HR54.1
1 = Reverse HR650 HRS1.1
2 = Combine HRSC.1 PA02.1
3 = PEP History Only PA100 PA102
5 = Reverse PA113 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 PRSC.1
PEA-ACT-OBJ-ID-REV Numeric 12 HR11.1 HR11.2
Act Obj Id Rev Contains the history action object ID HR15.1 HR511
for the field being reversed. HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 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 PRSC.1
PEA-HIST-CORR-FLAG Alpha 2 HR11.1 HR11.2
Hist Corr Flag This allows field-level override. If no HR15.1 HR511
value is entered, the system uses HR515 HR54.1
default method for the Action or HR650 HRS1.1
Company. If flag is set as "Don't fix HRSC.1 PA02.1
history log," the system still fixes PA100 PA102
PEP. PA113 PA13.1
1 = Don't fix History Log PA13.2 PA502
2 = Delete PA513 PA52.1
3 = Move to Hist Error PA52.3 PA52.4
PA52.5 PA54.1
PA55.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PRSC.1
PEA-HOLD-FLAG Alpha 1 PA55.1
On 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) HR11.1 HR11.2
Date Stamp This field contains the server date HR15.1 HR511
(month, date, and year) of the last HR515 HR54.1
change to this record. HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 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 PRSC.1
PEA-TIME-STAMP Numeric 6 (hhmmss) HR11.1 HR11.2
Time Stamp Contains the server time (hour, minute, HR15.1 HR511
and second) when the record was last HR515 HR54.1
changed. HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 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 PRSC.1
PAPEPAUDIT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PEASET1 COMPANY HR11.1 HR11.2
EMPLOYEE HR15.1 HR511
POS-LEVEL HR515 HR54.1
EFFECT-DATE HR650 HRS1.1
UPDATE-DATE HRSC.1 PA02.1
FLD-NBR PA100 PA102
ACT-OBJ-ID 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
...
PEASET2 COMPANY PA113
EMPLOYEE
POS-LEVEL
ACT-OBJ-ID
EFFECT-DATE
UPDATE-DATE
FLD-NBR
PEASET3 COMPANY HR11.1 HR11.2
EMPLOYEE HR15.1 HR511
POS-LEVEL HR515 HR54.1
FLD-NBR HR650 HRS1.1
ACT-OBJ-ID HRSC.1 PA02.1
EFFECT-DATE PA100 PA102
UPDATE-DATE PA113 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
...
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
Persacthst PERSACTHST Not Required
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
|