PAPEPAUDIT – Retroactive Pos, Job Changes

System
Personnel (PA)
Prefix
PEA
Primary key
COMPANY, EMPLOYEE, POS-LEVEL, EFFECT-DATE, UPDATE-DATE, FLD-NBR, ACT-OBJ-ID
Fields
15
Updated by
48 programs
Referenced by
0 programs

PAPEPAUDIT is the Retroactive Pos, Job Changes table in Lawson Personnel (prefix PEA). It is indexed by COMPANY, EMPLOYEE, POS-LEVEL, EFFECT-DATE, UPDATE-DATE, FLD-NBR, ACT-OBJ-ID (PEASET1); alternate indexes: PEASET2 and PEASET3. It is related 1:1 to PERSACTYPE, PRSYSTEM, EMPLOYEE, PADICT, PAEMPLOYEE and PERSACTHST and 1:M to HRHISTORY and PRRATEHIST. It is updated by BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 and 40 more. The table has 15 fields, 3 indexes and 9 documented relations.

About PAPEPAUDIT

No description in the Lawson data dictionary.

Fields (15)

Column = COBOL field name without the PEA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
PEA-COMPANY PK
COMPANY		Numeric 4Contains the company number.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +40 more
PEA-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +40 more
PEA-FLD-NBR PK
FLD_NBR		Numeric 4This field contains the PO dictionary field number.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +40 more
PEA-POS-LEVEL PK
POS_LEVEL		Numeric 2Contains the position level.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +40 more
PEA-EFFECT-DATE PK
EFFECT_DATE		Numeric 8 (yyyymmdd)Contains the effective date the position was changed.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +40 more
PEA-UPDATE-DATE PK
UPDATE_DATE		Numeric 8 (yyyymmdd)This field contains the date the record was updated.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +40 more
PEA-ACTION-CODE
ACTION_CODE		Alpha 10This field contains the personnel action code.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEA-USER-ID
USER_ID		Alpha 10 (Lower Case)—BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEA-ACT-OBJ-ID PK
ACT_OBJ_ID		Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +40 more
PEA-HIST-CORR-TYPE
HIST_CORR_TYPE		Alpha 1Contains the type of history correction. Valid values are:
  • 1 Reverse
  • 2 Combine
  • 3 PEP History Only
  • 5 Reverse
BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEA-ACT-OBJ-ID-REV
ACT_OBJ_ID_REV		Numeric 12Contains the history action object ID for the field being reversed.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEA-HIST-CORR-FLAG
HIST_CORR_FLAG		Alpha 2This allows field-level override. If no value is entered, the system uses default method for the Action or Company. If flag is set as "Don't fix history log," the system still fixes PEP.
  • 1 Don't fix History Log
  • 2 Delete
  • 3 Move to Hist Error
BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +40 more
PEA-HOLD-FLAG
HOLD_FLAG		Alpha 1This field enables this entire lot to be put on hold, not allowing any issues or transfers to be made for this lot.
  • Y Yes
PA55.1
PEA-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEA-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PEASET1COMPANY, EMPLOYEE, POS-LEVEL, EFFECT-DATE, UPDATE-DATE, FLD-NBR, ACT-OBJ-IDPrimaryBN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)
PEASET2COMPANY, EMPLOYEE, POS-LEVEL, ACT-OBJ-ID, EFFECT-DATE, UPDATE-DATE, FLD-NBRPA113
PEASET3COMPANY, EMPLOYEE, POS-LEVEL, FLD-NBR, ACT-OBJ-ID, EFFECT-DATE, UPDATE-DATEBN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)

Relations

One to one (7) — lookups and parents

RelationTableRulesConditionField map
Action CodePERSACTYPERequiredWhen (PEA-ACTION-CODE != Spaces)PEA-COMPANY → PAT-COMPANY, PEA-ACTION-CODE → PAT-ACTION-CODE
CompanyPRSYSTEMRequiredPEA-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequiredPEA-COMPANY → EMP-COMPANY, PEA-EMPLOYEE → EMP-EMPLOYEE
Fld NbrPADICTRequiredPEA-FLD-NBR → PAD-FLD-NBR
PaemployeePAEMPLOYEERequiredPEA-COMPANY → PEM-COMPANY, PEA-EMPLOYEE → PEM-EMPLOYEE
PersacthstPERSACTHSTNot RequiredValid When PEA-ACT-OBJ-ID != ZeroesPEA-ACT-OBJ-ID → PAH-OBJ-ID
Reverse ActPERSACTHSTRequiredWhen (PEA-ACT-OBJ-ID-REV != Zeroes)PEA-ACT-OBJ-ID-REV → PAH-OBJ-ID

One to many (2) — child tables

RelationTableRulesConditionField map
HrhistoryHRHISTORYValid 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 HistPRRATEHISTValid 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

Programs

Updated by (48)