| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | GRFNCASEIS | Case table of Issue | 12 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
2 | GRFNEXTRACTLOG | Extraction log | 3 | TIMEFRAME | Compounded timeframe ID | nvarchar | 32 | 0 | | |
3 | GRFNJOB | Job | 6 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
4 | GRFNJOBCASE | Case Data for Job | 5 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
5 | GRPCDBBUF | Dashboard buffer | 4 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
6 | GRPCSIGNOFFPLAN | Sign-Off Guid | 4 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
7 | GRRMRESP | Response attributes | 15 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
8 | GRRMRISKCONSPLAN | Infomation for one plan of risk consolidation. | 8 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
TOPGovernance, Risk and Compliance |
9 | GRFNDMLOG | Datamart: Central Log | 4 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
10 | GRFNMDCR | Master Data Change Request | 6 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
11 | GRFNTASKPLAN | Data for task plan | 6 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
12 | GRFNTIMEFRAME | Timeframes | 2 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
13 | GRFNTIMEFRAMET | Timeframes | 3 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
14 | GRPCACCVERSION | Version of Central Account Group | 5 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
TOPGRC Risk Management |
15 | /ORM/ORMT_PRY_CT | Risk priority matrix | 2 | TIMEFRAME | Speed of Onset | nvarchar | 4 | 0 | | |
16 | /ORM/ORMT_TIMEFR | Speed of Onset | 2 | TIMEFRAME | Speed of Onset | nvarchar | 4 | 0 | | |
17 | /ORM/ORMT_TMFR_T | Speed of Onset Texts | 3 | TIMEFRAME | Speed of Onset | nvarchar | 4 | 0 | | |
18 | GRRMANALYSIS | Analysis Table | 10 | TIMEFRAME | Speed of Onset | nvarchar | 4 | 0 | | |
19 | GRRMFACTREP | Fact Report Header | 6 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
20 | GRRMRESPONSE | Table for Response | 14 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
TOPManagement of Internal Controls |
21 | FOPCCASEAS | Assessment | 5 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
22 | FOPCCASETE | Attributes: Testing | 5 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
23 | FOPCCASETL | Test log | 5 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
24 | FOPCCLOSING | Close | 8 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
25 | FOPCDEFICANA | MIC: Deficiency Analysis | 12 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
26 | FOPCDEFICSEL | MIC: Selection Conditions for Deficiency Analysis | 9 | TIMEFRAME | Timeframe for the Selection of Issues | nvarchar | 10 | 0 | | |
27 | FOPCMTESTERASGN | Mass Tester Assignment | 4 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
28 | FOPCMTESTERASGNS | Mass Tester Assignment - Settings | 4 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
29 | FOPCPRTUSERPARA | User Parameters for Print | 6 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
30 | FOPCRBFLOG | Reporting Buffers: Central Log | 3 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
31 | FOPCRBFTL | Reporting Buffer: Cases - Test Logs | 19 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
32 | FOPCSHM2 | Activate Shared Objects Memory | 3 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
33 | FOPCSIGNOFF | Sign-Off | 3 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
34 | FOPCTASKFREQ_TF | Timeframes of Tasks That Can Be Scheduled at Corporate Level | 4 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
35 | FOPCTASKFREQ_TFC | Controls for Timeframes of Tasks that Can Be Scheduled | 4 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
36 | FOPCTIMEFRAME | Timeframe | 4 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
37 | FOPCTIMEFRAMET | Timeframe | 5 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
38 | FOPCUSERDATA | User-Specific Settings | 6 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
39 | FOPC_ORM_PROT | ORM Transfer: Log | 2 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
40 | HRP1814 | DB Table for InfoType 1814 | 18 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
TOPProcess Controls |
41 | GRPCAODINFO | aod infos | 4 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
42 | GRPCCASEAS | Assessment | 5 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
43 | GRPCCASECP | CAPA Plan | 5 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
44 | GRPCCASEIS | Issue | 5 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
45 | GRPCCASEPL | Remediation Plan | 5 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
46 | GRPCCASETE | Attributes: Testing | 5 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
47 | GRPCCASETL | Test log | 5 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
48 | GRPCCLOSING | Closed/Frozen organizations | 9 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
49 | GRPCDEFICANA | PC: Deficiency Analysis | 12 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
50 | GRPCDEFICSEL | PC: Selection Conditions for Deficiency Analysis | 9 | TIMEFRAME | Timeframe for the Selection of Issues | nvarchar | 10 | 0 | | |
51 | GRPCEVENTAGGR | OBSOLETE Event Monitoring Aggregation | 5 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
52 | GRPCEVENTRLEV | Event Monitoring: Rule evaluation results | 11 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
53 | GRPCJOBCASE | Case Data for Job | 4 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
54 | GRPCJOBLOG | Job Log from Scheduler | 6 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
55 | GRPCMTESTERASGN | Obsolete: Mass Tester Assignment | 4 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
56 | GRPCMTESTERASGNS | Obsolete: Mass Tester Assignment - Settings | 4 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
57 | GRPCPRTUSERPARA | User Parameters for Print | 6 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
58 | GRPCRBFAS | Reporting Buffer: Cases - Assessments | 9 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
59 | GRPCRBFLOG | Reporting Buffers: Central Log | 3 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
60 | GRPCRBFTL | Reporting Buffer: Cases - Test Logs | 19 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
61 | GRPCSCHEDULER | Scheduler | 11 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
62 | GRPCSHM2 | Activate Shared Objects Memory | 3 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
63 | GRPCSIGNOFF | Sign-Off | 3 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
64 | GRPCTASKFREQ_TF | Obsolete: Tasks That Can Be Scheduled at Corporate Level | 4 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
65 | GRPCTASKFREQ_TFC | Obsolete: Timeframes of Tasks that Can Be Scheduled | 4 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
66 | GRPCTASKPLAN | Obsolete: Data for task plan | 6 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
67 | GRPCTIMEFRAME | Timeframe | 4 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
68 | GRPCTIMEFRAMET | Timeframe | 5 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
69 | GRPCUSERDATA | User-Specific Settings | 6 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
70 | GRPC_ACCOUNT_GRP | Account Group Scoping Info. | 6 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
71 | GRPC_MCF_REF_TST | Referenced test results for controls | 8 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
72 | GRPC_ORM_PROT | ORM Transfer: Log | 2 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
73 | GRPC_SCOP_THRESH | Scoping Threshold | 2 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
74 | HRP5314 | DB Table for Infotype 5314 | 18 | TIMEFRAME | Timeframe | nvarchar | 10 | 0 | | |
TOPWaste Management |
75 | EEWA_BULK_DATA | Bulk refuse order data | 48 | TIMEFRAME | Service window | nvarchar | 2 | 0 | | |
76 | EWAOBJH | Service Frequency -> Services (History for EWAOBJ) | 6 | TIMEFRAME | Service window | nvarchar | 2 | 0 | | |
77 | EWA_OBJADDRESS | Object Address | 6 | TIMEFRAME | Service window | nvarchar | 2 | 0 | | |
78 | EWA_ORDER_OBJECT | Item Table for Waste Disposal Order | 14 | TIMEFRAME | Service window | nvarchar | 2 | 0 | | |
79 | EWA_SERVADDRESS | Service Address | 7 | TIMEFRAME | Service window | nvarchar | 2 | 0 | | |