| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPEarly Warning System |
| 1 | MCYA | Early Warning: Exceptions | 20 | ANZPER | Number of periods for trend analysis | int | 10 | 0 | | |
| 2 | MCYC | Key Figures: Early Warning | 15 | ANZPER | Number of periods for trend analysis | int | 10 | 0 | | |
| TOPPool Asset Management |
| 3 | PAMS_NEED | Graphical Planning Board: Requests (Objects to Schedule) | 58 | ANZPER | Maximum number of occupants | nvarchar | 4 | 0 | | |
| 4 | PAMS_SPLIT | Graphical Planning Board: Splits (Scheduled Objects) | 59 | ANZPER | Maximum number of occupants | nvarchar | 4 | 0 | | |
| TOPRemaining Beverage - Obsolete Objects |
| 5 | /BEV1/TSSSPBG | Statistics: Column Definition | 20 | ANZPER | Number of Periods in an LIS table to Be Considered | nvarchar | 4 | 0 | | |
