Lawson Insight Technical Documentation |
|
SIRDROLE
SIRDROLE FILE
REFERENCED BY
RD54.1 RD54.2 RD64.1 RD64.2 RD64.3 RD65.1
RD65.2 RD65.3 RD65.4 RD66.1 RD66.2
UPDATED BY
RD42.1 RD42.2 RD43.1 RD43.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SRO-ROLE Alpha 20 (Lower Case) RD42.1 RD42.2
Element: Role RD43.1 RD43.2
SRO-PARENT-ROLE Alpha 20 (Lower Case) RD43.1 RD43.2
Element: Parent Role
SRO-DESCRIPTION Alpha 50 (Lower Case) RD42.1 RD42.2
Element: Description This field contains the description. RD43.1 RD43.2
SRO-OBJ-ID Numeric 12 RD42.1 RD42.2
Element: Obj Id RD43.1
SRO-DATE Numeric 8 (yyyymmdd) RD42.1 RD42.2
Element: Date This field contains the system date RD43.1
when this was created.
SRO-TIME Numeric 6 (hhmmss) RD42.1 RD42.2
Element: Time RD43.1
SRO-CHILD-EXISTS Derived
Element: Child Exists
SIRDROLE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SROSET1 ROLE RD42.1 RD42.2
RD43.1 RD43.2
RD54.1 RD54.2
RD64.1 RD64.2
RD64.3 RD65.1
RD65.2 RD65.3
RD65.4 RD66.1
RD66.2
SROSET2 OBJ-ID KeyChange, Subset RD42.1 RD42.2
Where OBJ-ID != Zeroes
SROSET3 PARENT-ROLE KeyChange RD43.1 RD43.2
ROLE
SIRDROLE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Sirdrole SIRDROLE Required
When SRO-PARENT-ROLE != Spaces
SRO-PARENT-ROLE -> SRO-ROLE
SIRDROLE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Child Exists SIRDROLE Delete Restricted
SRO-ROLE -> SRO-PARENT-ROLE
SRO-ROLE
Lomxvalue LOMXVALUE
SRO-ROLE -> LMV-ROLE
SRO-OBJ-ID -> LMV-OBJ-ID
LMV-MATRIX-TYPE
LMV-MATRIX-CAT
Sirdgrprol SIRDGRPROL Delete Cascades
SRO-ROLE -> RGP-ROLE
RGP-GROUP
Sirdidrole SIRDIDROLE Delete Cascades
SRO-ROLE -> SIR-ROLE
SIR-ID
|