EMPAUTO FILE

                          Employee Automobiles

The Employee Automobiles file contains information on the employee's
automobile.

REFERENCED BY

HR170     HR70.1    PA217     PA311

UPDATED BY

PA115     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          Conains the county of the license.

                         EMPAUTO FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

EATSET1   COMPANY                                                HR170   HR70.1
          EMPLOYEE                                               PA115   PA17.1
          AUTO-NBR                                               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