| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /PERSONAS/SCRIPT | DB table containing all scripts created with script editor. | 5 | CONTROL_ID | Flavor Control ID | ntext | 1073741823 | 0 | | |
2 | /PERSONAS/SCRP_V | DB table containing all script versions | 6 | CONTROL_ID | Flavor Control ID | ntext | 1073741823 | 0 | | |
3 | GRRMRESP | Response attributes | 28 | CONTROL_ID | Object ID | nvarchar | 50 | 0 | | |
4 | N1MCI_MSG | Message Log | 15 | CONTROL_ID | Message Control ID | nvarchar | 50 | 0 | | |
TOPGRC Risk Management |
5 | GRRMRESPONSE | Table for Response | 27 | CONTROL_ID | Object ID | nvarchar | 50 | 0 | | |
TOPProcess Controls |
6 | GRPCAODDATA | aod data | 5 | CONTROL_ID | Object ID | nvarchar | 8 | 0 | | |
7 | GRPCAODGRPCTRL | relation table for aod group and it's controls | 7 | CONTROL_ID | Object ID | nvarchar | 8 | 0 | | |
8 | GRPCCRASS | Control Risk Assessment | 4 | CONTROL_ID | Object ID | nvarchar | 8 | 0 | | |
9 | GRPCCRASSFACTOR | Factor for the control risk assessment | 4 | CONTROL_ID | Object ID | nvarchar | 8 | 0 | | |
10 | GRPCCTRLPROPOSAL | GRPC:Control Proposal | 6 | CONTROL_ID | GRPC ID of the individual object | nvarchar | 50 | 0 | | |
11 | GRPCEVENT1AGGR | Event Monitoring Aggregation | 2 | CONTROL_ID | PC Reporting: Control ID | nvarchar | 9 | 0 | | |
12 | GRPCEVENTAGGR | OBSOLETE Event Monitoring Aggregation | 3 | CONTROL_ID | PC Reporting: Control ID | nvarchar | 9 | 0 | | |
13 | GRPCEVENTENABLE | Event Monitoring: Monitoring Enabling | 2 | CONTROL_ID | PC Reporting: Control ID | nvarchar | 9 | 0 | | |
14 | GRPCEVENTENABLEL | Event Monitoring: Monitoring Enabling change log | 2 | CONTROL_ID | PC Reporting: Control ID | nvarchar | 9 | 0 | | |
15 | GRPCEVENTMAP | Event Monitoring : Event to Control Rule mapping | 3 | CONTROL_ID | PC Reporting: Control ID | nvarchar | 9 | 0 | | |
16 | GRPCEVENTRLEV | Event Monitoring: Rule evaluation results | 8 | CONTROL_ID | GRPC ID of the individual object | nvarchar | 50 | 0 | | |
17 | GRPCJOBCASE | Case Data for Job | 3 | CONTROL_ID | GRPC ID of the individual object | nvarchar | 50 | 0 | | |
18 | GRPCJOBLOG | Job Log from Scheduler | 5 | CONTROL_ID | GRPC ID of the individual object | nvarchar | 50 | 0 | | |
19 | GRPCVIOLATION | Event Monitoring: Violations | 2 | CONTROL_ID | PC Reporting: Control ID | nvarchar | 9 | 0 | | |
20 | GRPC_MCF_REF_TST | Referenced test results for controls | 2 | CONTROL_ID | GRPC ID of the individual object | nvarchar | 50 | 0 | | |
21 | GRPC_S_EVENT | Event | 3 | CONTROL_ID | GRPC ID of the individual object | nvarchar | 50 | 0 | | |