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 HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EAT-COMPANY Numeric 4 PA17.1
Element: Company Hr Contains the company number represents
an established company.
EAT-EMPLOYEE Numeric 9 PA17.1
Element: Employee Employee number.
EAT-AUTO-NBR Numeric 1 PA17.1
Element: Auto Nbr This field contains the automobile
number.
1 = Primary
2 = Secondary
EAT-STICKER Alpha 10 PA17.1
Element: Sticker This field contains the parking sticker
number.
EAT-MODEL Alpha 10 PA17.1
Element: Model This field contains the automobile
model.
EAT-MAKE Alpha 10 PA17.1
Element: Make This field contains the made of the
automobile.
EAT-YEAR Numeric 4 PA17.1
Element: Year This field contains the year of the
automobile.
EAT-COLOR Alpha 5 PA17.1
Element: Color This field contains the color of the
automobile.
EAT-LIC-NBR Alpha 10 PA17.1
Element: Lic Nbr This field contains the license number
of the automobile.
EAT-LIC-STATE Alpha 2 PA17.1
Element: Lic State This field contains the state of the
automobile's license.
EAT-LIC-COUNTRY Alpha 2 PA17.1
Element: Lic Country Contains the county of the license.
EMPAUTO FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EATSET1 COMPANY HR11.1 HR170
EMPLOYEE HR70.1 PA115
AUTO-NBR PA17.1 PA217
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
|
