| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T7PIQPERIOD | Academic Sessions | 3 | PERTYPE | Session Type | nvarchar | 3 | 0 | | |
2 | T7PIQPERIODTYPE | Session Types | 2 | PERTYPE | Session Type | nvarchar | 3 | 0 | | |
3 | T7PIQPERIODTYPET | Session Types (Text Table) | 3 | PERTYPE | Session Type | nvarchar | 3 | 0 | | |
4 | T7PIQVARY | Session Variants | 3 | PERTYPE | Session Type | nvarchar | 3 | 0 | | |
TOPBusiness Consolidation |
5 | UCMT010 | Period Category: Periods | 2 | PERTYPE | Period Category | nvarchar | 4 | 0 | | |
6 | UCMT01C | Period Category | 2 | PERTYPE | Period Category | nvarchar | 4 | 0 | | |
7 | UCMT01T | Period Category: Name | 3 | PERTYPE | Period Category | nvarchar | 4 | 0 | | |
8 | UCS0100 | Tasks: Method | 8 | PERTYPE | Period Category | nvarchar | 4 | 0 | | |
9 | UCS01A2 | Tasks: Log Layout: Sequence, Active/Inactive | 8 | PERTYPE | Period Category | nvarchar | 4 | 0 | | |
TOPPortfolio Management |
10 | RPM_FIDATA | Financial Information | 10 | PERTYPE | Period Type | nvarchar | 2 | 0 | | |
11 | RPM_PROJECT_CO | Controlling Information about a project | 9 | PERTYPE | Period Type | nvarchar | 2 | 0 | | |
12 | RPM_SCENARIO_FIN | RPM : Scenario financial data | 7 | PERTYPE | Period Type | nvarchar | 2 | 0 | | |
13 | RPM_VALTYP | Period Type | 3 | PERTYPE | Period Type | nvarchar | 2 | 0 | | |
TOPSimulation |
14 | VSKPER_CN | Version: Workforce Planning | 8 | PERTYPE | Unit in which the duration of a period is specified | nvarchar | 1 | 0 | | |
TOPTime Sheet |
15 | TCATS | CATS: Data Entry Profiles | 11 | PERTYPE | Type of Data Entry Period | nvarchar | 1 | 0 | | |
TOPWorkforce Planning |
16 | KPER | Period Values for Workforce Planning | 7 | PERTYPE | Unit in which the duration of a period is specified | nvarchar | 1 | 0 | | |
17 | TCYMPP | Customizing Settings for Workforce Planning | 6 | PERTYPE | Unit in which the duration of a period is specified | nvarchar | 1 | 0 | | |
18 | TCYMPP_PERIODS | Period Split for Workforce Planning | 4 | PERTYPE | Unit in which the duration of a period is specified | nvarchar | 1 | 0 | | |