|
SIRDGRPROL FILE
This file assigns roles previously defined in WF to ID groups.
REFERENCED BY
RD66.1 RD66.2
UPDATED BY
RD42.1 RD42.2 RD65.1 RD65.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RGP-GROUP Alpha 20 (Lower Case) RD42.1 RD65.1
Element: Group RD65.2
RGP-ROLE Alpha 20 (Lower Case) RD42.1 RD65.1
Element: Role RD65.2
RGP-DATE Numeric 8 (yyyymmdd) RD42.1 RD65.1
Element: Date This field contains the system date RD65.2
when this was created.
RGP-TIME Numeric 6 (hhmmss) RD42.1 RD65.1
Element: Time RD65.2
RGP-TYPE-RECORD Derived
Element: Type Record
SIRDGRPROL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RGPSET1 GROUP RD42.1 RD65.1
ROLE RD65.2 RD65.3
RD65.4 RD66.1
RD66.2
RGPSET2 ROLE RD42.1 RD42.2
GROUP
SIRDGRPROL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Sirdgrp SIRDGRP Required
RGP-GROUP -> RDG-GROUP
Sirdgrprls SIRDGRPRLS Not Required, Delete Restricted
RGP-GROUP -> SRS-GROUP
RGP-ROLE -> SRS-ROLE
Sirdrole SIRDROLE Required
RGP-ROLE -> SRO-ROLE
SIRDGRPROL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Sirdgrpid SIRDGRPID
RGP-GROUP -> GID-GROUP
RGP-ROLE -> GID-ROLE
GID-ID
Sirdgrprlsp SIRDGRPRLS Delete Restricted
RGP-GROUP -> SRS-PARENT-GROUP
RGP-ROLE -> SRS-PARENT-ROLE
SRS-GROUP
SRS-ROLE
|