EDUSRGRPAT – No description in the Lawson data dictionary

System
EDI (ED)
Prefix
EGA
Primary key
UGAID
Fields
4
Updated by
1 program
Referenced by
1 program

EDUSRGRPAT is a Lawson EDI table (prefix EGA); no description in the lawson data dictionary. It is indexed by UGAID (EGASET1); alternate indexes: EGASET2 and EGASET3. It is related 1:1 to EDATTRIBS and EDUSRGRP. It is updated by ED47.1 and referenced by ED51.2. The table has 4 fields, 3 indexes and 2 documented relations.

About EDUSRGRPAT

No description in the Lawson data dictionary.

Fields (4)

Column = COBOL field name without the EGA- 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
#EGA-UGAID PK
UGAID		Alpha 9 (Lower Case)—ED47.1
#EGA-ATTRID SET3
ATTRID		Alpha 9 (Lower Case)—ED47.1
#EGA-UGID SET2
UGID		Alpha 9 (Lower Case)—ED47.1
#EGA-UGNAME SET3
UGNAME		Alpha 40 (Lower Case)—ED47.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
EGASET1
  1. UGAID
PrimaryED47.1
EGASET2
  1. UGID
  2. UGAID
KeyChangeED51.2
EGASET3
  1. UGNAME
  2. ATTRID
KeyChangeED47.1

Relations

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

One to one (2) — lookups and parents

RelationTableRulesConditionField map
EdattribsEDATTRIBSRequired
EGA-ATTRID→EDA-ATTRID
EdusrgrpEDUSRGRPRequired
EGA-UGID→EUG-UGID

Programs

Updated by (1)

Referenced by (1)