EDUSER – No description in the Lawson data dictionary

System
EDI (ED)
Prefix
EDU
Primary key
USID
Fields
5
Updated by
1 program
Referenced by
3 programs

EDUSER is a Lawson EDI table (prefix EDU); no description in the lawson data dictionary. It is indexed by USID (EDUSET1); alternate indexes: EDUSET2 and EDUSET3. It is related 1:1 to EDTEMPLATE and EDUSRGRP. It is updated by ED43.1 and referenced by ED41.1, ED49.1 and ED51.1. The table has 5 fields, 3 indexes and 2 documented relations.

About EDUSER

No description in the Lawson data dictionary.

Fields (5)

Column = COBOL field name without the EDU- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#EDU-USID PK
USID		Alpha 9 (Lower Case)—ED43.1
#EDU-USNAME SET2
USNAME		Alpha 40 (Lower Case)—ED43.1
#EDU-REQUESTER
REQUESTER		Alpha 10 (Lower Case)—ED43.1
#EDU-UGID SET2 SET3
UGID		Alpha 9 (Lower Case)—ED43.1
#EDU-TLID
TLID		Alpha 9 (Lower Case)—ED43.1

Indexes (3)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
EDUSET1
  1. USID
PrimaryED43.1, ED49.1
EDUSET2
  1. UGID
  2. USNAME
KeyChangeED41.1, ED43.1
EDUSET3
  1. UGID
  2. USID
KeyChangeED51.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
EDTEMPLATEEDUSRGRPEDUSER

One to one (2) — lookups and parents

RelationTableRulesConditionField map
EdtemplateEDTEMPLATERequired
EDU-TLID→EP1-TLID
EdusrgrpEDUSRGRPRequired
EDU-UGID→EUG-UGID

Programs

Updated by (1)

Referenced by (3)