| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPEvaluations |
1 | DPR_DASHBOARD | Dashboard Data for Project | 10 | ACTUAL_START | Actual Start | nvarchar | 8 | 0 | | |
TOPMaintenance Orders |
2 | /MRSS/D_DEM_H | Complex Demand | 12 | ACTUAL_START | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
TOPPortfolio Management |
3 | /RPM/DECISION | Decision Point Object Data | 9 | ACTUAL_START | Actual Start Date | nvarchar | 8 | 0 | | |
4 | /RPM/ITEM_D | Operational item persisted data | 26 | ACTUAL_START | Actual Start Date | nvarchar | 8 | 0 | | |
5 | RPM_DECISION_CD | Decision Point - Pseudo table for change documents | 9 | ACTUAL_START | Actual Start Date | nvarchar | 8 | 0 | | |
6 | RPM_ITEM_D_CD | Item details - Pseudo table for change documents | 26 | ACTUAL_START | Actual Start Date | nvarchar | 8 | 0 | | |
TOPProject Management |
7 | DPR_CONF_DET | Project Management Confirmation: Detail Fields of Tasks | 5 | ACTUAL_START | Actual Start | nvarchar | 8 | 0 | | |
TOPWaste Management |
8 | EWA_ORDER_HEAD | Header Table for Waste Disposal Order | 33 | ACTUAL_START | Actual Start Time for Waste Disposal Order | nvarchar | 6 | 0 | | |
9 | EWA_ORDER_RESOBJ | Resource Table for Waste Disposal Order | 11 | ACTUAL_START | Actual Start Time for Waste Disposal Order | nvarchar | 6 | 0 | | |