EMPAUTO

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
Element: Company Hr		Numeric 4
Contains the company number represents an established company.
PA17.1
EAT-EMPLOYEE
Element: Employee		Numeric 9
Employee number.
PA17.1
EAT-AUTO-NBR
Element: Auto Nbr		Numeric 1
This field contains the automobile number.
1 = Primary
2 = Secondary
PA17.1
EAT-STICKER
Element: Sticker		Alpha 10
This field contains the parking sticker number.
PA17.1
EAT-MODEL
Element: Model		Alpha 10
This field contains the automobile model.
PA17.1
EAT-MAKE
Element: Make		Alpha 10
This field contains the made of the automobile.
PA17.1
EAT-YEAR
Element: Year		Numeric 4
This field contains the year of the automobile.
PA17.1
EAT-COLOR
Element: Color		Alpha 5
This field contains the color of the automobile.
PA17.1
EAT-LIC-NBR
Element: Lic Nbr		Alpha 10
This field contains the license number of the automobile.
PA17.1
EAT-LIC-STATE
Element: Lic State		Alpha 2
This field contains the state of the automobile's license.
PA17.1
EAT-LIC-COUNTRY
Element: Lic Country		Alpha 2
Contains the county of the license.
PA17.1


EMPAUTO FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EATSET1 COMPANY
EMPLOYEE
AUTO-NBR
HR11.1 HR170
HR70.1 PA115
PA17.1 PA217
PA311


EMPAUTO FILE RELATIONS


ONE TO ONE RELATIONS

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

File created: Thu Jun 09 02:24:45 2016

Home
Contact Us



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