| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPCompany Pension Scheme Germany |
1 | P01CBE | Active CPS Contributions | 4 | ANTYP | Entitlement Type (Entitlement/Benefit Type) | nvarchar | 1 | 0 | | |
2 | P01CBF | Notional CPS Contributions | 4 | ANTYP | Entitlement Type (Entitlement/Benefit Type) | nvarchar | 1 | 0 | | |
3 | T5DCA | Entitlements / Benefit Types | 2 | ANTYP | Entitlement Type (Entitlement/Benefit Type) | nvarchar | 1 | 0 | | |
4 | T5DCC | Texts for Benefit Types | 3 | ANTYP | Entitlement Type (Entitlement/Benefit Type) | nvarchar | 1 | 0 | | |
5 | T5DCD | Control Information: Entitlements | 2 | ANTYP | Entitlement Type (Entitlement/Benefit Type) | nvarchar | 1 | 0 | | |
6 | T5DCM | Calculation Method for Calculated/Actual Contributions | 2 | ANTYP | Entitlement Type (Entitlement/Benefit Type) | nvarchar | 1 | 0 | | |
7 | T5DCN | Calculation Method Employment Period/Income | 2 | ANTYP | Entitlement Type (Entitlement/Benefit Type) | nvarchar | 1 | 0 | | |
8 | T5DCQ | Working Time Calculation Method | 2 | ANTYP | Entitlement Type (Entitlement/Benefit Type) | nvarchar | 1 | 0 | | |
9 | T5DCR | ONE-TIME PAYMENT Calculation Method | 2 | ANTYP | Entitlement Type (Entitlement/Benefit Type) | nvarchar | 1 | 0 | | |
10 | T5DW6 | Wage Type Filter for Calculation of Basis Amount | 2 | ANTYP | Entitlement Type (Entitlement/Benefit Type) | nvarchar | 1 | 0 | | |
11 | T5DWE | Calculation Variants per Entitlement | 2 | ANTYP | Entitlement Type (Entitlement/Benefit Type) | nvarchar | 1 | 0 | | |
12 | T5DWET | Texts for Calculation Variants per Entitlement/Benefit Type | 3 | ANTYP | Entitlement Type (Entitlement/Benefit Type) | nvarchar | 1 | 0 | | |
13 | T5DWZ | Bonus for Company Pension Scheme | 2 | ANTYP | Entitlement Type (Entitlement/Benefit Type) | nvarchar | 1 | 0 | | |
TOPPersonnel Administration |
14 | T503 | Employee Group/Subgroup | 6 | ANTYP | Employee category | nvarchar | 1 | 0 | | |