PAPOSERR – Position Errors

System
Personnel (PA)
Prefix
PPE
Primary key
COMPANY, EMPLOYEE, REQUISITION, POSITION, EFFECT-DATE, UPDATE-TYPE
Fields
7
Updated by
18 programs
Referenced by
0 programs

PAPOSERR is the Position Errors table in Lawson Personnel (prefix PPE). It is indexed by COMPANY, EMPLOYEE, REQUISITION, POSITION, EFFECT-DATE, UPDATE-TYPE (PPESET1); alternate indexes: PPESET2. It is related 1:1 to PRSYSTEM, EMPLOYEE, PAEMPLOYEE, PAPOSITION and PAJOBREQ and 1:M to PAEMPPOS and PAPOSCHG. It is updated by HR00.1, HR01.1, HR11.1, LT101, LT111, PA02.1, PA03.1, PA03.2 and 10 more. The table has 7 fields, 2 indexes and 7 documented relations.

About PAPOSERR

No description in the Lawson data dictionary.

Fields (7)

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

Field / columnTypeDescription & valuesUpdated by
PPE-COMPANY PK
COMPANY		Numeric 4—LT101, LT111, PA02.1, PA102, PA502, PA52.1, PA52.5
PPE-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.LT101, LT111, PA02.1, PA102, PA502, PA52.1, PA52.5
PPE-REQUISITION PK
REQUISITION		Numeric 9Contains the requisition.LT101, LT111, PA02.1, PA102, PA502, PA52.1, PA52.5
PPE-POSITION PK
POSITION		Alpha 12Contains the user-defined code that represents a position in the company.LT101, LT111, PA02.1, PA102, PA502, PA52.1, PA52.5
PPE-EFFECT-DATE PK
EFFECT_DATE		Numeric 8 (yyyymmdd)Contains the position effective date.LT101, LT111, PA02.1, PA102, PA502, PA52.1, PA52.5
PPE-UPDATE-TYPE PK
UPDATE_TYPE		Alpha 3Indicates why the change could not be performed. Data Change indicates an action exists for an employee; End Date indicates the position has ended; and Upd Error indicates a general error.
  • 1 Data Change
  • 2 End Date
  • 3 Upd Error
LT101, LT111, PA02.1, PA102, PA502, PA52.1, PA52.5
PPE-POS-LEVEL
POS_LEVEL		Numeric 2 Occurs 98 Times ×98Contains the position level.LT101, LT111, PA02.1, PA100, PA102, PA502, PA52.1, PA52.5

Indexes (2)

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

IndexKeysFlagsConditionUsed in
PPESET1COMPANY, EMPLOYEE, REQUISITION, POSITION, EFFECT-DATE, UPDATE-TYPEPrimaryHR00.1, HR01.1, HR11.1, LT101, LT111, PA02.1, PA100, PA102 +5 more
PPESET2COMPANY, POSITION, EFFECT-DATE, EMPLOYEE, REQUISITION, UPDATE-TYPELT101, LT111, PA02.1, PA03.1, PA03.2, PA03.3, PA102, PA302 +3 more

Relations

One to one (5) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredPPE-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequiredWhen (PPE-EMPLOYEE != Zeroes)PPE-COMPANY → EMP-COMPANY, PPE-EMPLOYEE → EMP-EMPLOYEE
PaemployeePAEMPLOYEERequiredWhen (PPE-EMPLOYEE != Zeroes)PPE-COMPANY → PEM-COMPANY, PPE-EMPLOYEE → PEM-EMPLOYEE
PositionPAPOSITIONRequiredPPE-COMPANY → POS-COMPANY, PPE-POSITION → POS-POSITION, PPE-EFFECT-DATE → POS-EFFECT-DATE
RequisitionPAJOBREQRequiredWhen (PPE-REQUISITION != Zeroes)PPE-COMPANY → PJR-COMPANY, PPE-REQUISITION → PJR-REQUISITION

One to many (2) — child tables

RelationTableRulesConditionField map
Mult PosPAEMPPOSValid When (PPE-EMPLOYEE != Zeroes)PPE-COMPANY → PEP-COMPANY, PPE-EMPLOYEE → PEP-EMPLOYEE, → PEP-POS-LEVEL, → PEP-EFFECT-DATE
Pos ChgPAPOSCHGPPE-COMPANY → PPC-COMPANY, PPE-POSITION → PPC-POSITION, PPE-EFFECT-DATE → PPC-EFFECT-DATE, → PPC-FLD-NBR

Programs

Updated by (18)