| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPInvoicing |
1 | EBBPTEMP | Temporary Budget Billing Data | 16 | START_YEAR | Beginning year of payment plan | nvarchar | 4 | 0 | | |
2 | TE632 | PS Unmeasured Customers: General Settings for One Year | 2 | START_YEAR | PS Unmeasured Customers: Start Year of Payment Period | nvarchar | 4 | 0 | | |
3 | TE632A | PS Unmeasured Customer: Frequency-Specific Settings for Year | 2 | START_YEAR | PS Unmeasured Customers: Start Year of Payment Period | nvarchar | 4 | 0 | | |
TOPPortfolio Management |
4 | /RPM/PERIOD_TYPE | Breakdown Periods | 4 | START_YEAR | Start Year of the Planning Process | nvarchar | 4 | 0 | | |
TOPWorkforce Management Core |
5 | WFMCAS_HOL_HIST | Holiday History table (OBSOLETE) | 7 | START_YEAR | Year from which data is stored | nvarchar | 4 | 0 | | |