| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /CPD/D_PFP_PH | Plan Header | 3 | PLAN_ID | Plan ID | nvarchar | 24 | 0 | | |
2 | /CPD/PFP_HEADER | Database Table for Plan Header | 3 | PLAN_ID | Plan ID | nvarchar | 24 | 0 | | |
3 | /IAM/D_I_ROOT | Root node DB table | 75 | PLAN_ID | Plan | nvarchar | 24 | 0 | | |
4 | GRACBGRULEGEN | Background Rule Generation. | 2 | PLAN_ID | UUID of the GRC object (char32) | nvarchar | 32 | 0 | | |
5 | GRACROLEJOB | Role Mangement Job Log | 3 | PLAN_ID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
6 | GRFNPLANRCPT | Scheduler Recipient relation | 2 | PLAN_ID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
7 | GRFNPLANREG | scheduler-regulation relation | 2 | PLAN_ID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
8 | GRRMRISKCONS | Consolidation run at Orgunit(Cons. Group) level | 3 | PLAN_ID | UUID of the GRC object (char32) | nvarchar | 32 | 0 | | |
9 | GRRMRISKCONSORG | Orgnization hierarchy of Risk Consolidations | 2 | PLAN_ID | UUID of the GRC object (char32) | nvarchar | 32 | 0 | | |
10 | GRRMRISKCONSPLAN | Infomation for one plan of risk consolidation. | 2 | PLAN_ID | UUID of the GRC object (char32) | nvarchar | 32 | 0 | | |
11 | RSSMA_REORG | Reorg plans | 1 | PLAN_ID | Name of a reorganization plan | nvarchar | 30 | 0 | | |
TOPControl Plan |
12 | QPCPD_CPLAN | Control Plan - Header | 3 | PLAN_ID | External ID of Control Plan | nvarchar | 24 | 0 | | |
TOPNetwork Operations |
13 | GHO_PP_PTABLE_HD | Header Table for Results of GHO Planning Table | 2 | PLAN_ID | Plan-ID for Planning Table Object | varbinary | 16 | 0 | | |
14 | GHO_PP_PTABLE_IT | Item Table for Results of GHO Planning Table | 2 | PLAN_ID | Plan-ID for Planning Table Object | varbinary | 16 | 0 | | |
15 | GHO_PP_PTABLE_IV | Item-Validity Table for GHO Planning Table | 2 | PLAN_ID | Plan-ID for Planning Table Object | varbinary | 16 | 0 | | |
16 | GHO_PP_PTABLE_LN | Schedule Lines Table for Results of GHO Planning Table | 2 | PLAN_ID | Plan-ID for Planning Table Object | varbinary | 16 | 0 | | |
17 | GHO_PP_PTABLE_TX | Text Table for OPM Planning Table Header | 2 | PLAN_ID | Plan-ID for Planning Table Object | varbinary | 16 | 0 | | |
TOPProcess Controls |
18 | GRPCRMPLANLOG | RM plan action logs | 3 | PLAN_ID | Case ID | nvarchar | 32 | 0 | | |
TOPRepetitive Manufacturing |
19 | T437P | Planning IDs for Repetitive Manufacturing | 3 | PLAN_ID | Planning identification | nvarchar | 8 | 0 | | |
TOPSingapore |
20 | PA0739 | HR Master Record: Infotype 0739 [Stock Option] (SG) | 25 | PLAN_ID | Stock Option Scheme | nvarchar | 6 | 0 | | |
21 | T5RSOP_PLAN | Stock Option Plan | 2 | PLAN_ID | Stock Option Scheme | nvarchar | 6 | 0 | | |
22 | T5RSOP_PLAN_T | Test table for Plan | 3 | PLAN_ID | Stock Option Scheme | nvarchar | 6 | 0 | | |
23 | T5RSOP_P_SCHEME | Stock Option Scheme Assignment to Plan | 3 | PLAN_ID | Stock Option Scheme | nvarchar | 6 | 0 | | |
TOPTest Organizer |
24 | TWB_TBTCO | Assignment Test Plan and Test Package to Batch Job | 1 | PLAN_ID | GUID for Structure | nvarchar | 32 | 0 | | |