SIRDGRPID FILE
UPDATED BY
RD65.2 RD65.3 RD65.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GID-GROUP Alpha 20 (Lower Case) RD65.2 RD65.3
Element: Group RD65.4
GID-ROLE Alpha 20 (Lower Case) RD65.2 RD65.3
Element: Role RD65.4
GID-ID Alpha 20 (Lower Case) RD65.2 RD65.3
Element: Id RD65.4
GID-DATE Numeric 8 (yyyymmdd) RD65.2 RD65.3
Element: Date This field contains the system date RD65.4
when this was created.
GID-TIME Numeric 6 (hhmmss) RD65.2 RD65.3
Element: Time RD65.4
GID-GRPTYPE-RECORD Derived
Element: Grptype Record
GID-ID-RECORD Derived
Element: Id Record
SIRDGRPID FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GIDSET1 GROUP RD65.2 RD65.3
ROLE RD65.4
ID
GIDSET2 GROUP RD65.3
ID
ROLE
GIDSET3 ROLE
GROUP
ID
GIDSET4 ROLE
ID
GROUP
GIDSET5 ID
GROUP
ROLE
GIDSET6 ID
ROLE
GROUP
SIRDGRPID FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Name First LOMXVALUE Not Required
IDH-OBJ-ID -> LMV-OBJ-ID (LMVSET1)
"PRIMARY " -> LMV-MATRIX-TYPE
"NAME-FIRST -> LMV-MATRIX-CAT
Name Last LOMXVALUE Not Required
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"NAME-LAST -> LMV-MATRIX-CAT
Sirdgrp SIRDGRP Required
GID-GROUP -> RDG-GROUP
Sirdgrprol SIRDGRPROL Required
GID-GROUP -> RGP-GROUP
GID-ROLE -> RGP-ROLE
Sirdidgrp SIRDIDGRP Required
GID-GROUP -> WDG-GROUP
GID-ID -> WDG-ID
Sirdidhdr SIRDIDHDR Required
GID-ID -> IDH-ID
Sirdrole SIRDROLE Required
GID-ROLE -> SRO-ROLE
SIRDGRPID FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Sirdidstt SIRDIDSTT
GID-ID -> IDS-ID
IDS-STRUCTURE
|
