H95: Object and Environment Tech |
| Schema | Table | Prefix | Columns | Indexes | Description | Type | Report | Category |
---|
1 | 920 | F95921 | RL | 36 | 6 | Role Relationships Table | Files | H95: Object and Environment Tech | System Tables |
Number | Description |
---|
1 | Member MemberOf EffDate (Primary/Unique) |
| Element | Alias | Description | Sequence |
---|
1 | FRROLE | Member | Ascending | 2 | TOROLE | Member of | Ascending | 3 | EFFDATE | Effective Date | Ascending |
|
2 | MemberOf |
| Element | Alias | Description | Sequence |
---|
1 | TOROLE | Member of | Ascending |
|
3 | Effective Date |
| Element | Alias | Description | Sequence |
---|
1 | EFFDATE | Effective Date | Ascending |
|
4 | System Role |
| Element | Alias | Description | Sequence |
---|
1 | SYSROLE | System Role | Ascending | 2 | TOROLE | Member of | Ascending |
|
5 | Default Role |
| Element | Alias | Description | Sequence |
---|
1 | DEFROLE | Default Role | Ascending | 2 | TOROLE | Member of | Ascending |
|
6 | Role Type |
| Element | Alias | Description | Sequence |
---|
1 | ROLETYP | Member Type | Ascending |
|