| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPManagement of Internal Controls |
1 | FOPCDEFICANA | MIC: Deficiency Analysis | 24 | ANALYSIS_TIME | Last Changed On | decimal | 15 | 0 | | |
2 | FOPCDEFICORG | MIC: Deficiency Analysis Status for Org Unit | 6 | ANALYSIS_TIME | Last Changed On | decimal | 15 | 0 | | |
TOPProcess Controls |
3 | GRPCAODDATA | aod data | 11 | ANALYSIS_TIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
4 | GRPCAODGROUP | aod group | 9 | ANALYSIS_TIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
5 | GRPCAODGRPCTRL | relation table for aod group and it's controls | 9 | ANALYSIS_TIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
6 | GRPCAODORG | aod org | 5 | ANALYSIS_TIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
7 | GRPCDEFICANA | PC: Deficiency Analysis | 24 | ANALYSIS_TIME | Last Changed On | decimal | 15 | 0 | | |
8 | GRPCDEFICORG | PC: Deficiency Analysis Status for Org Unit | 6 | ANALYSIS_TIME | Last Changed On | decimal | 15 | 0 | | |