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
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 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 HAP3.1 HEP4.1
Element: Company Hr Contains the company number. 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 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 HAP3.1 HEP4.1
Element: Employee Contains the employee number. Each HPOS.1 HPQC.1
person employed by the company is HPRS.1 HR11.1
assigned a unique number. The system HR11.2 HR15.1
uses the employee number to correlate HR511 HR515
all of the information related to that HR54.1 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 HAP3.1 HEP4.1
Dictionary Field This field contains the PO dictionary HPOS.1 HPQC.1
Number field number. HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 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 HAP3.1 HEP4.1
Element: Pos Level Contains the position level. 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 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) HAP3.1 HEP4.1
Element: Effective DateContains the effective date the HPOS.1 HPQC.1
position was changed. HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 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) HAP3.1 HEP4.1
Element: Update Date This field contains the date the record HPOS.1 HPQC.1
was updated. HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 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 HAP3.1 HEP4.1
Element: Action Code This field contains the personnel HPOS.1 HPQC.1
action code. HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 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) HAP3.1 HEP4.1
Element: User Contains the user ID of the person who HPOS.1 HPQC.1
last changed this record. HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 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 HAP3.1 HEP4.1
Object A subsystem activity interface HPOS.1 HPQC.1
Identification identification number. Used for Drill HPRS.1 HR11.1
Around purposes. HR11.2 HR15.1
HR511 HR515
HR54.1 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 HAP3.1 HEP4.1
Element: Hist Corr TypeContains the type of history correction. HPOS.1 HPQC.1
Valid values are: HPRS.1 HR11.1
1 = Reverse HR11.2 HR15.1
2 = Combine HR511 HR515
3 = PEP History Only HR54.1 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 HAP3.1 HEP4.1
Element: Act Obj Id RevContains the history action object ID HPOS.1 HPQC.1
for the field being reversed. HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 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 HAP3.1 HEP4.1
Element: Hist Corr FlagThis allows field-level override. If no HPOS.1 HPQC.1
value is entered, the system uses HPRS.1 HR11.1
default method for the Action or HR11.2 HR15.1
Company. If flag is set as "Don't fix HR511 HR515
history log," the system still fixes HR54.1 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) HAP3.1 HEP4.1
Element: Date Stamp This field contains the server date HPOS.1 HPQC.1
(month, date, and year) of the last HPRS.1 HR11.1
change to this record. HR11.2 HR15.1
HR511 HR515
HR54.1 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) HAP3.1 HEP4.1
Element: Time Stamp Contains the server time (hour, minute, HPOS.1 HPQC.1
and second) when the record was last HPRS.1 HR11.1
changed. HR11.2 HR15.1
HR511 HR515
HR54.1 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 HAP3.1 HEP4.1
EMPLOYEE HPOS.1 HPQC.1
POS-LEVEL HPRS.1 HR11.1
EFFECT-DATE HR11.2 HR15.1
UPDATE-DATE HR511 HR515
FLD-NBR HR54.1 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 HAP3.1 HEP4.1
EMPLOYEE HPOS.1 HPQC.1
POS-LEVEL HPRS.1 HR11.1
FLD-NBR HR11.2 HR15.1
ACT-OBJ-ID HR511 HR515
EFFECT-DATE HR54.1 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
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
|