| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPControl Plan |
1 | DPR_CTRLPLAN_I | Control Plan: Characteristics Within Control Plan | 36 | EA_DUMMY | Dummy Data Element for Enhanced Proj. Mgmt Attributes | nvarchar | 1 | 0 | | |
2 | DPR_CTRLPLAN_V | Control Plan: Versions | 22 | EA_DUMMY | Dummy Data Element for Enhanced Proj. Mgmt Attributes | nvarchar | 1 | 0 | | |
TOPEngineering Documents |
3 | EDMS_AT01 | EDMS: Documents - GUID | 9 | EA_DUMMY | | nvarchar | 1 | 0 | | |
TOPPortfolio Management |
4 | /RPM/BUCKET_D | Operational bucket persisted data | 20 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
5 | /RPM/BUCKET_D_DR | Operational derrived bucket persisted data | 13 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
6 | /RPM/CAP_B_CAT | Demand planning for bucket categories | 9 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
7 | /RPM/CAP_B_GROUP | Demand planning bucket category groups | 10 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
8 | /RPM/CAP_CAT | Demand Planning Category | 9 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
9 | /RPM/CAP_GROUP | xRPM Demand planning group object | 10 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
10 | /RPM/COLLECTN_D | Collection Persisted Data | 10 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
11 | /RPM/DECISION | Decision Point Object Data | 20 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
12 | /RPM/FIN_B_CAT | Financial planning for bucket categories | 9 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
13 | /RPM/FIN_B_GROUP | Financial planning bucket category groups | 10 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
14 | /RPM/FIN_CAT | Financial Category | 9 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
15 | /RPM/FIN_GROUP | xRPM Financial Group Object | 10 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
16 | /RPM/HIERARCHY_D | Strategic hierarchy persisted data | 8 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
17 | /RPM/ITEM_D | Operational item persisted data | 50 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
18 | /RPM/ITEM_D_DER | Project data | 49 | EA_DUMMY | Single-Character Indicator | nvarchar | 1 | 0 | | |
19 | /RPM/ITEM_H | Operational item persisted data | 9 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
20 | /RPM/PORTFOLIO_D | Portfolio Operational persisted data | 18 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
21 | /RPM/PORTFOLIO_S | Portfolio Details persisted data | 8 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
22 | /RPM/RELATION_D | Portofolio relation object persisted data | 14 | EA_DUMMY | Single-Character Indicator | nvarchar | 1 | 0 | | |
23 | /RPM/REVIEW_D | Portfolio Review Persisted Data | 10 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
24 | /RPM/WHATIF_D | What If Persisted Data | 12 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
25 | RPM_BUCKET_D_CD | Bucket - Pseudo table for change documents | 20 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
26 | RPM_CAP_B_CAT_CD | Bucket demand category - Pseudo table for change documents | 9 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
27 | RPM_CAP_B_GRP_CD | Bucket demand groups - Pseudo table for change docu | 10 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
28 | RPM_CAP_CAT_CD | Demand Planning Category- Pseudo table for change documents | 9 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
29 | RPM_CAP_GRP_CD | Demand planning groups - Pseudo table for change documents | 10 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
30 | RPM_COLLECTN_CD | Collection - Pseudo table for change documents | 10 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
31 | RPM_DECISION_CD | Decision Point - Pseudo table for change documents | 20 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
32 | RPM_FIN_B_CAT_CD | Bucket Financial Categories - Pseudo table for change docu | 9 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
33 | RPM_FIN_B_GRP_CD | Bucket financial groups - Pseudo table for change docu | 10 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
34 | RPM_FIN_CAT_CD | Financial Category - Pseudo table for change documents | 9 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
35 | RPM_FIN_GRP_CD | Financial Group Object - Pseudo table for change documents | 10 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
36 | RPM_ITEM_DER_CD | Project data | 49 | EA_DUMMY | Single-Character Indicator | nvarchar | 1 | 0 | | |
37 | RPM_ITEM_D_CD | Item details - Pseudo table for change documents | 50 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
38 | RPM_ITEM_H_CD | Item header - Pseudo table for change documents | 9 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
39 | RPM_PORTFOLIO_CD | Portfolio attributes - Pseudo table for change documents | 16 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
40 | RPM_RELATION_CD | Portofolio Relations - Pseudo table for change documents | 14 | EA_DUMMY | Single-Character Indicator | nvarchar | 1 | 0 | | |
41 | RPM_REVIEW_CD | Portfolio Review - Pseudo table for change documents | 10 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
42 | RPM_WHATIF_D_CD | What If Scenario - Pseudo table for change documents | 12 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | nvarchar | 1 | 0 | | |
TOPResources |
43 | DPR_BUPA_FAVO | List of Favorites (Business Partner) | 11 | EA_DUMMY | Dummy Data Element for Enhanced Proj. Mgmt Attributes | nvarchar | 1 | 0 | | |
44 | DPR_BUPA_LINK | Role-Business Partner Links | 21 | EA_DUMMY | Dummy Data Element for Enhanced Proj. Mgmt Attributes | nvarchar | 1 | 0 | | |
45 | DPR_ENTITY_LINK | Role Assignments | 17 | EA_DUMMY | Dummy Data Element for Enhanced Proj. Mgmt Attributes | nvarchar | 1 | 0 | | |
46 | DPR_PART | Project Participants | 34 | EA_DUMMY | Dummy Data Element for Enhanced Proj. Mgmt Attributes | nvarchar | 1 | 0 | | |
47 | DPR_SKILL | Qualification Requirements | 13 | EA_DUMMY | Dummy Data Element for Enhanced Proj. Mgmt Attributes | nvarchar | 1 | 0 | | |
48 | RPM_BUPA_CUST | Customer Fields for BUPA | 3 | EA_DUMMY | Single-Character Indicator | nvarchar | 1 | 0 | | |
TOPStructure |
49 | DPR_APPROVAL | Approval | 21 | EA_DUMMY | Dummy Data Element for Enhanced Proj. Mgmt Attributes | nvarchar | 1 | 0 | | |
50 | DPR_CHECKLIST_H | Checklist Header | 24 | EA_DUMMY | Dummy Data Element for Enhanced Proj. Mgmt Attributes | nvarchar | 1 | 0 | | |
51 | DPR_CHECKLIST_I | Checklist Items | 25 | EA_DUMMY | Dummy Data Element for Enhanced Proj. Mgmt Attributes | nvarchar | 1 | 0 | | |
52 | DPR_CHECKLIST_R | Checklist References | 12 | EA_DUMMY | Dummy Data Element for Enhanced Proj. Mgmt Attributes | nvarchar | 1 | 0 | | |
53 | DPR_IND_APPROVAL | Individual Approval | 17 | EA_DUMMY | Dummy Data Element for Enhanced Proj. Mgmt Attributes | nvarchar | 1 | 0 | | |
54 | DPR_PHASE | Phase | 15 | EA_DUMMY | Dummy Data Element for Enhanced Proj. Mgmt Attributes | nvarchar | 1 | 0 | | |
55 | DPR_PROJECT | Project Definition | 39 | EA_DUMMY | Dummy Data Element for Enhanced Proj. Mgmt Attributes | nvarchar | 1 | 0 | | |
56 | DPR_TASK | Tasks | 36 | EA_DUMMY | Dummy Data Element for Enhanced Proj. Mgmt Attributes | nvarchar | 1 | 0 | | |