| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /GBT/N_MS_EV_OBJ | Objects with potentially missing events | 10 | LAST_CHANGED_ON | Time at Which Object for Missing Event Was Changed | decimal | 15 | 0 | | |
2 | FARR_D_CONTRACT | Contract | 32 | LAST_CHANGED_ON | Changed On | nvarchar | 8 | 0 | | |
3 | FARR_D_DEFERRAL | Deferrals | 15 | LAST_CHANGED_ON | Changed On | nvarchar | 8 | 0 | | |
4 | FARR_D_MANL_CHNG | Manual Change Table | 9 | LAST_CHANGED_ON | Date on Which Record Was Created | nvarchar | 8 | 0 | | |
5 | FARR_D_POB | Performance Obligation | 64 | LAST_CHANGED_ON | Changed On | nvarchar | 8 | 0 | | |
6 | FARR_D_RECON_KEY | Reconciliation Key | 12 | LAST_CHANGED_ON | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
7 | MDGHDB001H | HANA View Generation Header data | 5 | LAST_CHANGED_ON | Search View Changed On | decimal | 15 | 0 | | |
8 | MDGHDB002H | Drill down search header data | 3 | LAST_CHANGED_ON | Last Modified date for Model | decimal | 15 | 0 | | |
TOPBasic Functions |
9 | LFSSTN | Sustainability details for Vendor | 8 | LAST_CHANGED_ON | Date | nvarchar | 8 | 0 | | |
TOPCommon Functions |
10 | INM_INITIATIVE | Initiative Master Table | 9 | LAST_CHANGED_ON | UTC Time Stamp in Short Form | decimal | 15 | 0 | | |
11 | INM_INIT_CD | Initiative- Pseudo table for change documents | 9 | LAST_CHANGED_ON | UTC Time Stamp in Short Form | decimal | 15 | 0 | | |
TOPControl Plan |
12 | DPR_CTRLPLAN_H | Control Plan: Header | 6 | LAST_CHANGED_ON | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
TOPData Quality |
13 | MDG_DQ_MATCH_DC | Match profile for duplicate check configuration | 6 | LAST_CHANGED_ON | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
14 | USMD_DUPCHK_MOD | Duplicate Check Mode For Particular Data Model | 13 | LAST_CHANGED_ON | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
TOPEvaluations |
15 | DPR_DASHBOARD | Dashboard Data for Project | 5 | LAST_CHANGED_ON | UTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit) | decimal | 15 | 0 | | |
TOPMaterial Master |
16 | MGIR_SSTN | Material / Info Record Sustainability table | 7 | LAST_CHANGED_ON | Date | nvarchar | 8 | 0 | | |
TOPPortfolio Management |
17 | /RPM/QNNR | Questionnaire Header | 6 | LAST_CHANGED_ON | TimeStamp | decimal | 15 | 0 | | |
18 | RPM_FES_MANGER_A | Resources for Resource Manager | 15 | LAST_CHANGED_ON | UTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit) | decimal | 15 | 0 | | |
19 | RPM_FES_PRJ_ASGN | Assignments for Project Manager | 19 | LAST_CHANGED_ON | UTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit) | decimal | 15 | 0 | | |
20 | RPM_FES_PRJ_ROLE | Assignments for Project Manager | 19 | LAST_CHANGED_ON | UTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit) | decimal | 15 | 0 | | |
21 | RPM_FES_RES_ASGN | To be deleted | 19 | LAST_CHANGED_ON | UTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit) | decimal | 15 | 0 | | |
22 | RPM_FES_RES_ROLE | To be deleted | 19 | LAST_CHANGED_ON | UTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit) | decimal | 15 | 0 | | |
TOPStructure |
23 | DPR_CHECKLIST_H | Checklist Header | 18 | LAST_CHANGED_ON | UTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit) | decimal | 15 | 0 | | |
24 | DPR_PROJECT | Project Definition | 26 | LAST_CHANGED_ON | UTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit) | decimal | 15 | 0 | | |