PATESTOVER – Contains employee test override information.

System
Personnel (PA)
Prefix
PAV
Primary key
COMPANY, EMPLOYEE, TEST
Fields
8
Updated by
6 programs
Referenced by
5 programs

PATESTOVER is the Contains employee test override information. table in Lawson Personnel (prefix PAV). It is indexed by COMPANY, EMPLOYEE, TEST (PAVSET1); alternate indexes: PAVSET2. It is related 1:1 to PRSYSTEM, EMPLOYEE, PAEMPLOYEE, PCODES and PATSTSETUP. It is updated by HR00.1, HR01.1, HR11.1, PA115, PA48.1 and PA49.2 and referenced by PA149, PA248, PA249, PA549 and PA81.1. The table has 8 fields, 2 indexes and 5 documented relations.

About PATESTOVER

Contains employee test override information. This file is maintained primarily by PA49.2 (Employee Test Override).

Fields (8)

Column = COBOL field name without the PAV- 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
#PAV-COMPANY PK
COMPANY		Numeric 4—PA49.2
#PAV-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.PA49.2
#PAV-TEST PK
TEST		Alpha 10Contains the test.PA49.2
#PAV-REASON
REASON		Alpha 10Contains the reason for the override.PA49.2
#PAV-ELIG-FLAG
ELIG_FLAG		Alpha 1Indicates whether the employee is eligible or ineligible for the test.PA49.2
#PAV-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.PA49.2
#PAV-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.PA49.2
#PAV-USER-ID
USER_ID		Alpha 10 (Lower Case)—PA49.2

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
PAVSET1
  1. COMPANY
  2. EMPLOYEE
  3. TEST
PrimaryHR00.1, HR01.1, HR11.1, PA115, PA149, PA248, PA249, PA49.1 +4 more
PAVSET2
  1. COMPANY
  2. TEST
  3. EMPLOYEE
PA248, PA48.1

Relations

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

One to one (5) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
PAV-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequired
PAV-COMPANY→EMP-COMPANY
PAV-EMPLOYEE→EMP-EMPLOYEE
PaemployeePAEMPLOYEERequired
PAV-COMPANY→PEM-COMPANY
PAV-EMPLOYEE→PEM-EMPLOYEE
ReasonPCODESRequiredWhen (PAV-REASON != Spaces)
"TE"→PCO-TYPE
PAV-REASON→PCO-CODE
TestPATSTSETUPRequired
PAV-COMPANY→PAP-COMPANY
PAV-TEST→PAP-TEST

Programs

Updated by (6)

Referenced by (5)