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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PEASET1
  1. COMPANY
  2. EMPLOYEE
  3. POS-LEVEL
  4. EFFECT-DATE
  5. UPDATE-DATE
  6. FLD-NBR
  7. ACT-OBJ-ID
PrimaryBN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)
PEASET2
  1. COMPANY
  2. EMPLOYEE
  3. POS-LEVEL
  4. ACT-OBJ-ID
  5. EFFECT-DATE
  6. UPDATE-DATE
  7. FLD-NBR
PA113
PEASET3
  1. COMPANY
  2. EMPLOYEE
  3. POS-LEVEL
  4. FLD-NBR
  5. ACT-OBJ-ID
  6. EFFECT-DATE
  7. UPDATE-DATE
BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PERSACTYPEPRSYSTEMEMPLOYEEPADICTPAEMPLOYEEPERSACTHSTHRHISTORYPRRATEHISTPAPEPAUDIT

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
CompanyPRSYSTEMRequired
PEA-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequired
PEA-COMPANY→EMP-COMPANY
PEA-EMPLOYEE→EMP-EMPLOYEE
Fld NbrPADICTRequired
PEA-FLD-NBR→PAD-FLD-NBR
PaemployeePAEMPLOYEERequired
PEA-COMPANY→PEM-COMPANY
PEA-EMPLOYEE→PEM-EMPLOYEE
PersacthstPERSACTHSTNot RequiredValid When PEA-ACT-OBJ-ID != Zeroes
PEA-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)