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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
PAV-COMPANY PKCOMPANY | Numeric 4 | — | PA49.2 |
PAV-EMPLOYEE PKEMPLOYEE | Numeric 9 | Contains 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 PKTEST | Alpha 10 | Contains the test. | PA49.2 |
PAV-REASONREASON | Alpha 10 | Contains the reason for the override. | PA49.2 |
PAV-ELIG-FLAGELIG_FLAG | Alpha 1 | Indicates whether the employee is eligible or ineligible for the test. | PA49.2 |
PAV-DATE-STAMPDATE_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-STAMPTIME_STAMP | Numeric 6 (hhmmss) | Contains the server time (hour, minute, and second) when the record was last changed. | PA49.2 |
PAV-USER-IDUSER_ID | Alpha 10 (Lower Case) | — | PA49.2 |
Indexes (2)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
PAVSET1 | COMPANY, EMPLOYEE, TEST | Primary | HR00.1, HR01.1, HR11.1, PA115, PA149, PA248, PA249, PA49.1 +4 more | |
PAVSET2 | COMPANY, TEST, EMPLOYEE | PA248, PA48.1 |
Relations
One to one (5) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Company | PRSYSTEM | Required | PAV-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL | |
| Employee | EMPLOYEE | Required | PAV-COMPANY → EMP-COMPANY, PAV-EMPLOYEE → EMP-EMPLOYEE | |
| Paemployee | PAEMPLOYEE | Required | PAV-COMPANY → PEM-COMPANY, PAV-EMPLOYEE → PEM-EMPLOYEE | |
| Reason | PCODES | Required | When (PAV-REASON != Spaces) | "TE" → PCO-TYPE, PAV-REASON → PCO-CODE |
| Test | PATSTSETUP | Required | PAV-COMPANY → PAP-COMPANY, PAV-TEST → PAP-TEST |
Programs
Updated by (6)
- HR00.1 Company
- HR01.1 Process Level
- HR11.1 Employee
- PA115 Employee Purge
- PA48.1 Test Setup
- PA49.2 Employee Test Eligibility Override