| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | GRFNDMOBJATTR | DataMart: Object attributes (multivalue, CDF) | 4 | REGULATION_ID | Regulation ID | nvarchar | 8 | 0 | | |
2 | GRFNDMOBJREG | DataMart: Object x Regulation | 3 | REGULATION_ID | Object ID | nvarchar | 50 | 0 | | |
3 | GRFNJOB | Job | 5 | REGULATION_ID | Object ID | nvarchar | 50 | 0 | | |
4 | GRFNPLANREG | scheduler-regulation relation | 3 | REGULATION_ID | Object ID | nvarchar | 8 | 0 | | |
5 | GRRMRESP | Response attributes | 35 | REGULATION_ID | Object ID | nvarchar | 50 | 0 | | |
TOPGovernance, Risk and Compliance |
6 | GRFNCORPORATE | OBSOLETE Table for the Corporate node | 3 | REGULATION_ID | Object ID | nvarchar | 8 | 0 | | |
7 | GRFNMDCR | Master Data Change Request | 16 | REGULATION_ID | Object ID | nvarchar | 50 | 0 | | |
TOPGRC Risk Management |
8 | GRRMRESPONSE | Table for Response | 34 | REGULATION_ID | Object ID | nvarchar | 50 | 0 | | |
TOPProcess Controls |
9 | GRPCCTRLPROPOSAL | GRPC:Control Proposal | 9 | REGULATION_ID | GRPC ID of the individual object | nvarchar | 50 | 0 | | |
10 | GRPCEVENTRLEV | Event Monitoring: Rule evaluation results | 7 | REGULATION_ID | GRPC ID of the individual object | nvarchar | 50 | 0 | | |
11 | GRPCSCHEDULER | Scheduler | 20 | REGULATION_ID | Object ID | nvarchar | 50 | 0 | | |
12 | GRPC_ACCOUNT_GRP | Account Group Scoping Info. | 2 | REGULATION_ID | Object ID | nvarchar | 8 | 0 | | |
13 | GRPC_SCOP_THRESH | Scoping Threshold | 5 | REGULATION_ID | Object ID | nvarchar | 8 | 0 | | |