| 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 | | |
