EMPAUTO – Employee Automobiles
- System
- Personnel (PA)
- Prefix
EAT- Primary key
COMPANY,EMPLOYEE,AUTO-NBR- Fields
- 11
- Updated by
- 3 programs
- Referenced by
- 4 programs
EMPAUTO is the Employee Automobiles table in Lawson Personnel (prefix EAT). It is indexed by COMPANY, EMPLOYEE, AUTO-NBR (EATSET1). It is related 1:1 to PRSYSTEM, INSTCTRYCD, EMPLOYEE and PAEMPLOYEE. It is updated by HR11.1, PA115 and PA17.1 and referenced by HR170, HR70.1, PA217 and PA311. The table has 11 fields, 1 index and 4 documented relations.
About EMPAUTO
The Employee Automobiles file contains information on the employee's automobile.
Fields (11)
Column = COBOL field name without the EAT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
EAT-COMPANY PKCOMPANY | Numeric 4 | Contains the company number represents an established company. | PA17.1 |
EAT-EMPLOYEE PKEMPLOYEE | Numeric 9 | Employee number. | PA17.1 |
EAT-AUTO-NBR PKAUTO_NBR | Numeric 1 | This field contains the automobile number.
| PA17.1 |
EAT-STICKERSTICKER | Alpha 10 | This field contains the parking sticker number. | PA17.1 |
EAT-MODELMODEL | Alpha 10 | This field contains the automobile model. | PA17.1 |
EAT-MAKEMAKE | Alpha 10 | This field contains the made of the automobile. | PA17.1 |
EAT-YEARYEAR | Numeric 4 | This field contains the year of the automobile. | PA17.1 |
EAT-COLORCOLOR | Alpha 5 | This field contains the color of the automobile. | PA17.1 |
EAT-LIC-NBRLIC_NBR | Alpha 10 | This field contains the license number of the automobile. | PA17.1 |
EAT-LIC-STATELIC_STATE | Alpha 2 | This field contains the state of the automobile's license. | PA17.1 |
EAT-LIC-COUNTRYLIC_COUNTRY | Alpha 2 | Contains the county of the license. | PA17.1 |
Indexes (1)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
EATSET1 | COMPANY, EMPLOYEE, AUTO-NBR | Primary | HR11.1, HR170, HR70.1, PA115, PA17.1, PA217, PA311 |
Relations
One to one (4) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 |