PATESTOVER FILE
Contains employee test override information. This file is maintained
primarily by PA49.2 (Employee Test Override).
REFERENCED BY
PA149 PA248 PA249 PA549 PA81.1
UPDATED BY
PA49.2 HR00.1 HR01.1 HR11.1 PA115 PBIP.1
PR197 PA48.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAV-COMPANY Numeric 4 PA49.2
Company The company number represents an
established company and is entered on
all function codes.
PAV-EMPLOYEE Numeric 9 PA49.2
Employee 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.
PAV-TEST Alpha 10 PA49.2
Test Contains the test.
PAV-REASON Alpha 10 PA49.2
Reason Contains the reason for the override.
PAV-ELIG-FLAG Alpha 1 PA49.2
Elig Flag Indicates whether the employee is
eligible or ineligible for the test.
PAV-DATE-STAMP Numeric 8 (yyyymmdd) PA49.2
Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
PAV-TIME-STAMP Numeric 6 (hhmmss) PA49.2
Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
PAV-USER-ID Alpha 10 (Lower Case) PA49.2
User ID Name Contains the user ID of the person who
last changed this record.
PATESTOVER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAVSET1 COMPANY HR00.1 HR01.1
EMPLOYEE HR11.1 PA115
TEST PA149 PA248
PA249 PA49.1
PA49.2 PA49.3
PA549 PA81.1
PBIP.1 PR197
PAVSET2 COMPANY PA248 PA48.1
TEST
EMPLOYEE
PATESTOVER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PAV-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
PAV-COMPANY -> EMP-COMPANY
PAV-EMPLOYEE -> EMP-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
|
