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