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

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 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
PPESET1
  1. COMPANY
  2. EMPLOYEE
  3. REQUISITION
  4. POSITION
  5. EFFECT-DATE
  6. UPDATE-TYPE
PrimaryHR00.1, HR01.1, HR11.1, LT101, LT111, PA02.1, PA100, PA102 +5 more
PPESET2
  1. COMPANY
  2. POSITION
  3. EFFECT-DATE
  4. EMPLOYEE
  5. REQUISITION
  6. UPDATE-TYPE
LT101, LT111, PA02.1, PA03.1, PA03.2, PA03.3, PA102, PA302 +3 more

Relations

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

One to one (5) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
PPE-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
PositionPAPOSITIONRequired
PPE-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 ChgPAPOSCHG
PPE-COMPANY→PPC-COMPANY
PPE-POSITION→PPC-POSITION
PPE-EFFECT-DATE→PPC-EFFECT-DATE
—→PPC-FLD-NBR

Programs

Updated by (18)