| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | GRFNPLCACTION | review/approval action info | 10 | MAIN_USER | User Name | nvarchar | 12 | 0 | | |
2 | GRFNPOLICYAPPANS | Approval answers for Policy Management | 3 | MAIN_USER | Changed by | nvarchar | 12 | 0 | | |
3 | GRFNPOLICYRACMNT | Reviewer and approver comments of Policy object (Policy Ver. | 6 | MAIN_USER | User Name | nvarchar | 12 | 0 | | |
4 | GRRMRISKCONSACT | Review action info | 4 | MAIN_USER | User Name | nvarchar | 12 | 0 | | |
TOPManagement of Internal Controls |
5 | FOPCDEFICORG | MIC: Deficiency Analysis Status for Org Unit | 7 | MAIN_USER | User Replaced by Delegate | nvarchar | 12 | 0 | | |
6 | FOPCUSERDATA | User-Specific Settings | 12 | MAIN_USER | User Replaced by Delegate | nvarchar | 12 | 0 | | |
TOPProcess Controls |
7 | GRPCAODDATA | aod data | 13 | MAIN_USER | User Name | nvarchar | 12 | 0 | | |
8 | GRPCAODGROUP | aod group | 11 | MAIN_USER | User Name | nvarchar | 12 | 0 | | |
9 | GRPCAODGRPCTRL | relation table for aod group and it's controls | 11 | MAIN_USER | User Name | nvarchar | 12 | 0 | | |
10 | GRPCAODORG | aod org | 7 | MAIN_USER | User Name | nvarchar | 12 | 0 | | |
11 | GRPCDEFICORG | PC: Deficiency Analysis Status for Org Unit | 7 | MAIN_USER | User Replaced by Delegate | nvarchar | 12 | 0 | | |
12 | GRPCUSERDATA | User-Specific Settings | 12 | MAIN_USER | User Replaced by Delegate | nvarchar | 12 | 0 | | |