EMPAUTO FILE
Employee Automobiles
The Employee Automobiles file contains information on the employee's
automobile.
REFERENCED BY
HR170 HR70.1 PA217 PA311
UPDATED BY
PA17.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EAT-COMPANY Numeric 4 PA17.1
Company Contains the company number represents
an established company.
EAT-EMPLOYEE Numeric 9 PA17.1
Employee Employee number.
EAT-AUTO-NBR Numeric 1 PA17.1
Automobile Number This field contains the automobile
number.
1 = Primary
2 = Secondary
EAT-STICKER Alpha 10 PA17.1
Parking Sticker This field contains the parking sticker
number.
EAT-MODEL Alpha 10 PA17.1
Automobile Model This field contains the automobile
model.
EAT-MAKE Alpha 10 PA17.1
Automobile Make This field contains the made of the
automobile.
EAT-YEAR Numeric 4 PA17.1
Last Closed Year This field contains the year of the
automobile.
EAT-COLOR Alpha 5 PA17.1
Color This field contains the color of the
automobile.
EAT-LIC-NBR Alpha 10 PA17.1
License Number This field contains the license number
of the automobile.
EAT-LIC-STATE Alpha 2 PA17.1
License State This field contains the state of the
automobile's license.
EAT-LIC-COUNTRY Alpha 2 PA17.1
Lic Country Contains the county of the license.
EMPAUTO FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EATSET1 COMPANY HR170 HR70.1
EMPLOYEE PA17.1 PA217
AUTO-NBR PA311
EMPAUTO FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
EAT-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Country INSTCTRYCD Required
When (EAT-LIC-COUNTRY != Spaces )
EAT-LIC-COUNTRY -> INT-COUNTRY-CODE
Employee EMPLOYEE Required
EAT-COMPANY -> EMP-COMPANY
EAT-EMPLOYEE -> EMP-EMPLOYEE
Pa Employee PAEMPLOYEE Required
EAT-COMPANY -> PEM-COMPANY
EAT-EMPLOYEE -> PEM-EMPLOYEE
|
