| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OPT/X021 | Key Determination Templates for Product Roles | 3 | ROLEID | Responsible Party | nvarchar | 15 | 0 | | |
2 | /OPT/Y021 | Key Determination Templates for Product Roles | 3 | ROLEID | Responsible Party | nvarchar | 15 | 0 | | |
3 | /OPT/Z021 | Key Determination Templates for Product Roles | 3 | ROLEID | Responsible Party | nvarchar | 15 | 0 | | |
4 | ACMRULE | ACM: Rule Persistence | 2 | ROLEID | ACM: UUID of a Role | varbinary | 16 | 0 | | |
5 | ACMTSTRULE | ACMTST: Rule (Expected test-results) | 2 | ROLEID | ACM: UUID of a Role | varbinary | 16 | 0 | | |
6 | GRACHROBJACTVL | HR Object Action Violation Table | 11 | ROLEID | Role ID | nvarchar | 32 | 0 | | |
7 | GRACHROBJCRPVL | HR Object Critical Role/Profile Violation Table | 6 | ROLEID | Role ID | nvarchar | 32 | 0 | | |
8 | GRACHROBJPRMVL | User Permission Violation Table | 15 | ROLEID | Role ID | nvarchar | 32 | 0 | | |
9 | GRACRLCOMPANY | Role Company | 2 | ROLEID | Role ID | nvarchar | 32 | 0 | | |
10 | GRACRLCONNSTA | Role generation status | 2 | ROLEID | UUID of the GRC object (char32) | nvarchar | 32 | 0 | | |
11 | GRACRLCONNVAL | Role Connector (system) Validity | 2 | ROLEID | Role ID | nvarchar | 32 | 0 | | |
12 | GRACRLCONSTASYST | Table to store descriptions of roles per system. | 2 | ROLEID | UUID of the GRC object (char32) | nvarchar | 32 | 0 | | |
13 | GRACRLCUSTPRF | Template role custom profile details | 2 | ROLEID | Role ID | nvarchar | 32 | 0 | | |
14 | GRACRLORGLVMPG | Role - Org Level Mapping Association table | 2 | ROLEID | Role ID | nvarchar | 32 | 0 | | |
15 | GRACRLPREREQ | Role Prerequisites | 2 | ROLEID | Role ID | nvarchar | 32 | 0 | | |
16 | GRACROLE | Role | 2 | ROLEID | Role ID | nvarchar | 32 | 0 | | |
17 | GRACROLEACT | Role Action Table | 2 | ROLEID | UUID of the GRC object (char32) | nvarchar | 32 | 0 | | |
18 | GRACROLEACTVL | Role Action Violation Table | 3 | ROLEID | Role ID | nvarchar | 32 | 0 | | |
19 | GRACROLEACTVLEXT | Role Action Violations for Extended Objects | 3 | ROLEID | Role ID | nvarchar | 32 | 0 | | |
20 | GRACROLEAPPRVR | Role Approver | 2 | ROLEID | Role ID | nvarchar | 32 | 0 | | |
21 | GRACROLEARC | Role Archiving table for deleted roles | 2 | ROLEID | Role ID | nvarchar | 32 | 0 | | |
22 | GRACROLECRIT | Role with risk violation | 2 | ROLEID | Role ID | nvarchar | 32 | 0 | | |
23 | GRACROLECRPVL | Role Critical Role/Profile Violation Table | 3 | ROLEID | Role ID | nvarchar | 32 | 0 | | |
24 | GRACROLEFA | Role Function Area | 2 | ROLEID | Role ID | nvarchar | 32 | 0 | | |
25 | GRACROLEFUNC | Role Function | 2 | ROLEID | Role ID | nvarchar | 32 | 0 | | |
26 | GRACROLEJOB | Role Mangement Job Log | 5 | ROLEID | Object ID | nvarchar | 50 | 0 | | |
27 | GRACROLEORGFLD | Role Global Org Fields | 2 | ROLEID | UUID of the GRC object (char32) | nvarchar | 32 | 0 | | |
28 | GRACROLEORGLVL | Derived Role Leading Org Level Information | 2 | ROLEID | Role ID | nvarchar | 32 | 0 | | |
29 | GRACROLEPERM | Role Permission Table | 2 | ROLEID | UUID of the GRC object (char32) | nvarchar | 32 | 0 | | |
30 | GRACROLEPERMAUTH | Role Permission Authorization Table | 3 | ROLEID | UUID of the GRC object (char32) | nvarchar | 32 | 0 | | |
31 | GRACROLEPRMVL | Role Permission Violation Table | 3 | ROLEID | Role ID | nvarchar | 32 | 0 | | |
32 | GRACROLEPRMVLEXT | Role Permission Violation Table | 3 | ROLEID | Role ID | nvarchar | 32 | 0 | | |
33 | GRACROLEREAFFIRM | Role Reaffirm | 2 | ROLEID | Role ID | nvarchar | 32 | 0 | | |
34 | GRACROLEREQ | Role Request Details | 2 | ROLEID | Role ID | nvarchar | 32 | 0 | | |
35 | GRACROLESTEP | Role Step | 2 | ROLEID | Role ID | nvarchar | 32 | 0 | | |
36 | GRACROLET | Role Descriptions | 3 | ROLEID | Role ID | nvarchar | 32 | 0 | | |
37 | GRACROLETICKET | Ticket for role | 2 | ROLEID | Role ID | nvarchar | 32 | 0 | | |
38 | GRACROLETST | Role Testing Header | 2 | ROLEID | UUID of the GRC object (char32) | nvarchar | 32 | 0 | | |
39 | GRACRRACTIONS | Table for Role Reaffirm Actions | 3 | ROLEID | Role ID | nvarchar | 32 | 0 | | |
40 | GRACSTDROLESYS | Default Role - Role and Systems | 3 | ROLEID | Role ID | nvarchar | 32 | 0 | | |
41 | GRACUSERACTVL | User Action Violation Table | 10 | ROLEID | Role ID | nvarchar | 32 | 0 | | |
42 | GRACUSERACTVLEXT | User Action Violations for Extended Objects | 10 | ROLEID | Role ID | nvarchar | 32 | 0 | | |
43 | GRACUSERCRPVL | User Critical Role/Profile Violation Table | 5 | ROLEID | Role ID | nvarchar | 32 | 0 | | |
44 | GRACUSERPRMVL | User Permission Violation Table | 14 | ROLEID | Role ID | nvarchar | 32 | 0 | | |
45 | GRACUSERPRMVLEXT | User Permission Violations for Extended Objects | 14 | ROLEID | Role ID | nvarchar | 32 | 0 | | |
46 | YLP_TX_MAST_LINK | Transaction table to store Master Link | 4 | ROLEID | ROLE ID | smallint | 5 | 0 | | |
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector |
47 | CRMAHR | Data on Persons | 11 | ROLEID | User Role | nvarchar | 10 | 0 | | |
48 | CRMAHRROL | Roles | 1 | ROLEID | User Role | nvarchar | 10 | 0 | | |
49 | CRMAHRROLT | Roles text table | 2 | ROLEID | User Role | nvarchar | 10 | 0 | | |
TOPBusiness Package for Manager Self-Service HR |
50 | EREC_GENERAL | General Requisition Form Settings | 6 | ROLEID | Object ID of Standard Object | nvarchar | 8 | 0 | | |
51 | TWPC_PCR_GENERAL | General PCR Settings | 7 | ROLEID | Object ID of Standard Object | nvarchar | 8 | 0 | | |
TOPCross-Application Components |
52 | /OPT/CP_T912 | Key Determination Templates for Product Roles | 3 | ROLEID | Responsible Party | nvarchar | 15 | 0 | | |
TOPDSD Connector |
53 | /DSD/ME_ROLE | DSD CN: Role for Mobile Devices, group specific | 2 | ROLEID | Key for DSD Cockpit Roles | nvarchar | 20 | 0 | | |
54 | /DSD/ME_ROLET | DSD CN: Description of DSD Role for Mobile Devices | 3 | ROLEID | Key for DSD Cockpit Roles | nvarchar | 20 | 0 | | |
55 | /DSD/ME_ROLE_GRP | DSD CN: Assignment of roles to a group of devices | 3 | ROLEID | Key for DSD Cockpit Roles | nvarchar | 20 | 0 | | |
TOPGeneral Object Relations |
56 | SRRELROLES | Object Relationship Service: Roles | 6 | ROLEID | Object Relationship Service : Role GUID | nvarchar | 22 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
57 | /DSD/ME_CPT_ROLE | DSD Roles | 2 | ROLEID | Key for DSD Cockpit Roles | nvarchar | 20 | 0 | | |
TOPWithout Description |
58 | RSBCTCBROLEMAP | Content Browser: Role Numbers | 2 | ROLEID | | int | 10 | 0 | | |