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
HGLM.1 HPOS.1 HPQC.1 HPRS.1 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 HGLM.1 HPOS.1
Element: Company Contains the company number. HPQC.1 HPRS.1
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
PEA-EMPLOYEE Numeric 9 HGLM.1 HPOS.1
Element: Employee Contains the employee number. Each HPQC.1 HPRS.1
person employed by the company is HR11.1 HR11.2
assigned a unique number. The system HR15.1 HR511
uses the employee number to correlate HR515 HR54.1
all of the information related to that HR650 HRS1.1
person. 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-FLD-NBR Numeric 4 HGLM.1 HPOS.1
Dictionary Field This field contains the PO dictionary HPQC.1 HPRS.1
Number field number. 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
PEA-POS-LEVEL Numeric 2 HGLM.1 HPOS.1
Element: Pos Level Contains the position level. HPQC.1 HPRS.1
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
PEA-EFFECT-DATE Numeric 8 (yyyymmdd) HGLM.1 HPOS.1
Element: Date Contains the effective date the HPQC.1 HPRS.1
position was changed. 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
PEA-UPDATE-DATE Numeric 8 (yyyymmdd) HGLM.1 HPOS.1
Element: Date HPQC.1 HPRS.1
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
PEA-ACTION-CODE Alpha 10 HGLM.1 HPOS.1
Element: Action Code This field contains the personnel HPQC.1 HPRS.1
action code. 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
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
PEA-USER-ID Alpha 10 (Lower Case) HGLM.1 HPOS.1
Element: User HPQC.1 HPRS.1
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
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
PEA-ACT-OBJ-ID Numeric 12 HGLM.1 HPOS.1
Object HPQC.1 HPRS.1
Identification 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
PEA-HIST-CORR-TYPE Alpha 1 HGLM.1 HPOS.1
Element: Hist Corr TypeContains the type of history correction. HPQC.1 HPRS.1
Valid values are: HR11.1 HR11.2
1 = Reverse HR15.1 HR511
2 = Combine HR515 HR54.1
3 = PEP History Only HR650 HRS1.1
5 = Reverse 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-REV Numeric 12 HGLM.1 HPOS.1
Element: Act Obj Id RevContains the history action object ID HPQC.1 HPRS.1
for the field being reversed. 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
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
PEA-HIST-CORR-FLAG Alpha 2 HGLM.1 HPOS.1
Element: Hist Corr FlagThis allows field-level override. If no HPQC.1 HPRS.1
value is entered, the system uses HR11.1 HR11.2
default method for the Action or HR15.1 HR511
Company. If flag is set as "Don't fix HR515 HR54.1
history log," the system still fixes HR650 HRS1.1
PEP. HRSC.1 PA02.1
1 = Don't fix History Log PA100 PA102
2 = Delete PA113 PA13.1
3 = Move to Hist Error 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-HOLD-FLAG Alpha 1 PA55.1
Element: 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) HGLM.1 HPOS.1
Element: Date Stamp This field contains the server date HPQC.1 HPRS.1
(month, date, and year) of the last HR11.1 HR11.2
change to this record. 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
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
PEA-TIME-STAMP Numeric 6 (hhmmss) HGLM.1 HPOS.1
Element: Time Stamp Contains the server time (hour, minute, HPQC.1 HPRS.1
and second) when the record was last HR11.1 HR11.2
changed. 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
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 HGLM.1 HPOS.1
EMPLOYEE HPQC.1 HPRS.1
POS-LEVEL HR11.1 HR11.2
EFFECT-DATE HR15.1 HR511
UPDATE-DATE HR515 HR54.1
FLD-NBR HR650 HRS1.1
ACT-OBJ-ID 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
...
PEASET2 COMPANY PA113
EMPLOYEE
POS-LEVEL
ACT-OBJ-ID
EFFECT-DATE
UPDATE-DATE
FLD-NBR
PEASET3 COMPANY HGLM.1 HPOS.1
EMPLOYEE HPQC.1 HPRS.1
POS-LEVEL HR11.1 HR11.2
FLD-NBR HR15.1 HR511
ACT-OBJ-ID HR515 HR54.1
EFFECT-DATE HR650 HRS1.1
UPDATE-DATE 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
...
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
|