PATESTOVER

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

REFERENCED BY
PA149 PA549


UPDATED BY
PA49.2 HR00.1 HR01.1 HR11.1 PA115 PA248
PA249 PA81.1 PA48.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAV-COMPANY
Element: Company Hr
Numeric 4
PA49.2
PAV-EMPLOYEE
Element: Employee
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
Element: Test
Alpha 10
Contains the test.
PA49.2
PAV-REASON
Element: Reason
Alpha 10
Contains the reason for the override.
PA49.2
PAV-ELIG-FLAG
Element: Elig Flag
Alpha 1
Indicates whether the employee is eligible or ineligible for the test.
PA49.2
PAV-DATE-STAMP
Element: 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
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
PA49.2
PAV-USER-ID
Element: User
Alpha 10 (Lower Case)
PA49.2


PATESTOVER FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAVSET1 COMPANY
EMPLOYEE
TEST
HR00.1 HR01.1
HR11.1 PA115
PA149 PA248
PA249 PA49.1
PA49.2 PA49.3
PA549 PA81.1
PAVSET2 COMPANY
TEST
EMPLOYEE
PA248 PA48.1


PATESTOVER FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
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


File created: Wed Jun 08 20:50:26 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.