Lawson Insight Technical Documentation

                            SIRDGRPLOC FILE

UPDATED BY

RD96.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GRL-GROUP              Alpha 20  (Lower Case)                    RD96.2
Element: Group

GRL-LEVEL              Alpha 20                                  RD96.2
Element: Level

GRL-LEVEL-PARENT       Alpha 20                                  RD96.2
Element: Level Parent

GRL-COORDINATE-1       Numeric 5                                 RD96.2
Element: Coordinate 1

GRL-SPAN-1             Numeric 5                                 RD96.2
Element: Span 1

GRL-COORDINATE-2       Numeric 5                                 RD96.2
Element: Coordinate 2

GRL-SPAN-2             Numeric 5                                 RD96.2
Element: Span 2

GRL-MEMO               Alpha 99  (Lower Case)                    RD96.2
Element: Memo

GRL-DATE               Numeric 8  (yyyymmdd)                     RD96.2
Element: Date          This field contains the system date
                       when this was created.

GRL-TIME               Numeric 6  (hhmmss)                       RD96.2
Element: Time

GRL-LEVEL-DESC         Derived
Element: Level Desc

GRL-TYPE-RECORD        Derived
Element: Type Record

                         SIRDGRPLOC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GRLSET1   GROUP                                                  RD96.2
          LEVEL

GRLSET2   LEVEL
          GROUP

GRLSET3   LEVEL-PARENT  KeyChange
          LEVEL
          GROUP

                         SIRDGRPLOC FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Sirdgrp        SIRDGRP      Required

                            GRL-GROUP    -> RDG-GROUP  (RDGSET1)

Sirdlevel      SIRDLEVEL    Required

                            GRL-LEVEL    -> SLV-LEVEL