| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | GRFNCASEIS | Case table of Issue | 13 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
2 | GRFNJOB | Job | 7 | TF_YEAR | Timeframe Year | nvarchar | 4 | 0 | | |
3 | GRFNJOBCASE | Case Data for Job | 6 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
4 | GRFNJOBDETAIL | Job Step | 7 | TF_YEAR | Timeframe Year | nvarchar | 4 | 0 | | |
5 | GRPCDBBUF | Dashboard buffer | 5 | TF_YEAR | Timeframe Year | nvarchar | 4 | 0 | | |
6 | GRPCSIGNOFFPLAN | Sign-Off Guid | 5 | TF_YEAR | Timeframe Year | nvarchar | 4 | 0 | | |
7 | GRRMRESP | Response attributes | 16 | TF_YEAR | year | nvarchar | 4 | 0 | | |
8 | GRRMRISKCONSPLAN | Infomation for one plan of risk consolidation. | 9 | TF_YEAR | Timeframe Year | nvarchar | 4 | 0 | | |
TOPGovernance, Risk and Compliance |
9 | GRFNDMLOG | Datamart: Central Log | 5 | TF_YEAR | Timeframe Year | nvarchar | 4 | 0 | | |
10 | GRFNMDCR | Master Data Change Request | 7 | TF_YEAR | Timeframe Year | nvarchar | 4 | 0 | | |
11 | GRFNTASKPLAN | Data for task plan | 7 | TF_YEAR | Timeframe Year | nvarchar | 4 | 0 | | |
12 | GRPCACCVERSION | Version of Central Account Group | 6 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
TOPGRC Risk Management |
13 | GRRMFACTREP | Fact Report Header | 5 | TF_YEAR | Timeframe Year | nvarchar | 4 | 0 | | |
14 | GRRMRESPONSE | Table for Response | 15 | TF_YEAR | year | nvarchar | 4 | 0 | | |
TOPManagement of Internal Controls |
15 | FOPCCASEAS | Assessment | 6 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
16 | FOPCCASETE | Attributes: Testing | 6 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
17 | FOPCCASETL | Test log | 6 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
18 | FOPCCLOSING | Close | 9 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
19 | FOPCDEFICANA | MIC: Deficiency Analysis | 13 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
20 | FOPCDEFICSEL | MIC: Selection Conditions for Deficiency Analysis | 10 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
21 | FOPCMTESTERASGN | Mass Tester Assignment | 5 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
22 | FOPCMTESTERASGNS | Mass Tester Assignment - Settings | 5 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
23 | FOPCPRTUSERPARA | User Parameters for Print | 7 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
24 | FOPCRBFLOG | Reporting Buffers: Central Log | 4 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
25 | FOPCRBFTL | Reporting Buffer: Cases - Test Logs | 20 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
26 | FOPCSHM2 | Activate Shared Objects Memory | 4 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
27 | FOPCSIGNOFF | Sign-Off | 4 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
28 | FOPCTASKFREQ_TF | Timeframes of Tasks That Can Be Scheduled at Corporate Level | 5 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
29 | FOPCTASKFREQ_TFC | Controls for Timeframes of Tasks that Can Be Scheduled | 5 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
30 | FOPCUSERDATA | User-Specific Settings | 7 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
31 | FOPC_ORM_PROT | ORM Transfer: Log | 3 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
32 | HRP1814 | DB Table for InfoType 1814 | 19 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
TOPProcess Controls |
33 | GRPCAODINFO | aod infos | 5 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
34 | GRPCCASEAS | Assessment | 6 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
35 | GRPCCASECP | CAPA Plan | 6 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
36 | GRPCCASEIS | Issue | 6 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
37 | GRPCCASEPL | Remediation Plan | 6 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
38 | GRPCCASETE | Attributes: Testing | 6 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
39 | GRPCCASETL | Test log | 6 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
40 | GRPCCLOSING | Closed/Frozen organizations | 10 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
41 | GRPCDEFICANA | PC: Deficiency Analysis | 13 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
42 | GRPCDEFICSEL | PC: Selection Conditions for Deficiency Analysis | 10 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
43 | GRPCEVENTAGGR | OBSOLETE Event Monitoring Aggregation | 6 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
44 | GRPCEVENTRLEV | Event Monitoring: Rule evaluation results | 12 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
45 | GRPCJOBCASE | Case Data for Job | 5 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
46 | GRPCJOBLOG | Job Log from Scheduler | 7 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
47 | GRPCMTESTERASGN | Obsolete: Mass Tester Assignment | 5 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
48 | GRPCMTESTERASGNS | Obsolete: Mass Tester Assignment - Settings | 5 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
49 | GRPCPRTUSERPARA | User Parameters for Print | 7 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
50 | GRPCRBFAS | Reporting Buffer: Cases - Assessments | 10 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
51 | GRPCRBFLOG | Reporting Buffers: Central Log | 4 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
52 | GRPCRBFTL | Reporting Buffer: Cases - Test Logs | 20 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
53 | GRPCSCHEDULER | Scheduler | 12 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
54 | GRPCSHM2 | Activate Shared Objects Memory | 4 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
55 | GRPCSIGNOFF | Sign-Off | 4 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
56 | GRPCTASKFREQ_TF | Obsolete: Tasks That Can Be Scheduled at Corporate Level | 5 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
57 | GRPCTASKFREQ_TFC | Obsolete: Timeframes of Tasks that Can Be Scheduled | 5 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
58 | GRPCTASKPLAN | Obsolete: Data for task plan | 7 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
59 | GRPCUSERDATA | User-Specific Settings | 7 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
60 | GRPC_ACCOUNT_GRP | Account Group Scoping Info. | 7 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
61 | GRPC_MCF_REF_TST | Referenced test results for controls | 9 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
62 | GRPC_ORM_PROT | ORM Transfer: Log | 3 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
63 | GRPC_SCOP_THRESH | Scoping Threshold | 3 | TF_YEAR | Year | nvarchar | 4 | 0 | | |
64 | HRP5314 | DB Table for Infotype 5314 | 19 | TF_YEAR | Year | nvarchar | 4 | 0 | | |