Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EMPAUTO


                              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: Automobile NumThis field contains the automobile
                       number.
                       1 = Primary
                       2 = Secondary

EAT-STICKER            Alpha 10                                  PA17.1
Element: Parking StickeThis field contains the parking sticker
                       number.

EAT-MODEL              Alpha 10                                  PA17.1
Element: Automobile ModThis field contains the automobile
                       model.

EAT-MAKE               Alpha 10                                  PA17.1
Element: Automobile MakThis field contains the made of the
                       automobile.

EAT-YEAR               Numeric 4                                 PA17.1
Element: Last Closed YeThis 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: License NumberThis field contains the license number
                       of the automobile.

EAT-LIC-STATE          Alpha 2                                   PA17.1
Element: License 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