| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | GRFNJOB | Job | 19 | TASKPLAN_ID | UUID of the GRC object (char32) | nvarchar | 32 | 0 | | |
2 | GRFNPLANRESULT | Object in scheduler | 2 | TASKPLAN_ID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
3 | GRPCSIGNOFFPLAN | Sign-Off Guid | 3 | TASKPLAN_ID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
4 | GRRMOBRCSA | RCSA Plan Matrix | 9 | TASKPLAN_ID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
TOPGovernance, Risk and Compliance |
5 | GRFNTASKPLAN | Data for task plan | 2 | TASKPLAN_ID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
TOPGRC Risk Management |
6 | GRRMANALYSIS | Analysis Table | 15 | TASKPLAN_ID | UUID of the GRC object (char32) | nvarchar | 32 | 0 | | |
TOPProcess Controls |
7 | GRPCTASKPLAN | Obsolete: Data for task plan | 2 | TASKPLAN_ID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
8 | GRPCTASKPLANGRP | Obsolete: Data for task plan group | 3 | TASKPLAN_ID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |