| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | GRRMANLSAUTEHSRA | Analysis Automation - EH&S Risk Assessment Mapping | 2 | ANALYSIS_ID | Case GUID | nvarchar | 32 | 0 | | |
| TOPGRC Risk Management |
| 2 | GRRMCLUSTER | Scenario Risk Link | 5 | ANALYSIS_ID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
| TOPManagement of Internal Controls |
| 3 | FOPCDEFICANA | MIC: Deficiency Analysis | 2 | ANALYSIS_ID | Analysis GUID | nvarchar | 32 | 0 | | |
| 4 | FOPCDEFICORG | MIC: Deficiency Analysis Status for Org Unit | 2 | ANALYSIS_ID | Analysis GUID | nvarchar | 32 | 0 | | |
| 5 | FOPCDEFICSEL | MIC: Selection Conditions for Deficiency Analysis | 2 | ANALYSIS_ID | Analysis GUID | nvarchar | 32 | 0 | | |
| TOPProcess Controls |
| 6 | GRPCAODDATA | aod data | 2 | ANALYSIS_ID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
| 7 | GRPCAODGROUP | aod group | 2 | ANALYSIS_ID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
| 8 | GRPCAODGRPCTRL | relation table for aod group and it's controls | 2 | ANALYSIS_ID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
| 9 | GRPCAODINFO | aod infos | 2 | ANALYSIS_ID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
| 10 | GRPCAODORG | aod org | 2 | ANALYSIS_ID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
| 11 | GRPCDEFICANA | PC: Deficiency Analysis | 2 | ANALYSIS_ID | Analysis GUID | nvarchar | 32 | 0 | | |
| 12 | GRPCDEFICORG | PC: Deficiency Analysis Status for Org Unit | 2 | ANALYSIS_ID | Analysis GUID | nvarchar | 32 | 0 | | |
| 13 | GRPCDEFICSEL | PC: Selection Conditions for Deficiency Analysis | 2 | ANALYSIS_ID | Analysis GUID | nvarchar | 32 | 0 | | |
