| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPCompany Pension Scheme Germany |
1 | P01CBT | Transfer Records for Reimbursement of Contributions CPS | 3 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
2 | P01CCV | CPS Cumulated Future Rights | 3 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
3 | P01CGP | Vested Entitlements CPS | 3 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
4 | P01CIX | Entitlement Index | 5 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
5 | P01CKA | Funded Pension Rights CPS | 3 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
6 | P01CRP | Reimbursement Amounts CPS | 3 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
7 | P01CSL | Social Benefits CPS | 3 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
8 | P01CUA | Vested Pension Rights CPS | 3 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
9 | P01CVD | Actuarial CPS Data | 8 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
10 | P01CVR | Actuarial CPS Pension Data | 8 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
11 | P01CVU | Capital Transfers for CPS | 3 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
12 | P01VA_AUFT | PEP: Distribution Proposal Pension Equalization Payment | 3 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
13 | P01VA_BE | Actual Contributions CPS for Pension Equalization Payment | 5 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
14 | P01VA_BF | Notional Contributions CPS for Pension Equalization Payment | 5 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
15 | P01VA_CBE | Reduction Amounts for Actual Contributions CPS | 5 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
16 | P01VA_CBF | Reduction Amounts for Notional Contributions CPS | 5 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
17 | P01VA_CKA | Reduction Amounts for Funded Pension Rights CPS | 5 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
18 | P01VA_CLST | PEP: Benefit Reductions Pension Equalization Payment | 5 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
19 | P01VA_KA | Funded Pension Rights CPS for Pension Equalization Payment | 5 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
20 | P01VA_LSTV | PEP: Benefits Vector Pension Equalization Payment | 3 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
21 | PA0202 | HR Master Record Infotype 0202 (Entitlements) | 24 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
22 | PA0263 | HR Master Record for Infotype 0263 | 24 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
23 | PDAVRT | Result Table: Data for Future Pension Rights | 6 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
24 | T5DCV | Entitlement Status | 2 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
25 | T5DCVT | Entitlement Status Text | 3 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
26 | T5DV2 | Entitlement Assignment of Value Types | 3 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
27 | T5DVN | Definition of DC Conversion Models | 2 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
28 | T5DVNT | Text Table for Definitions of DC Conversion Models | 3 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
29 | T5DVP | Definition of Identifiers for Default Values | 3 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
30 | T5DW0 | Special Functions for Contribution Calculation | 3 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
31 | T5DW9 | Assignment of Benefit Types to CPS Imputation Groups | 4 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
32 | T5DWB | Entitlements of a Pension Plan | 3 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
33 | T5DWC | Entitlements/Benefit Types of a Pension Plan | 3 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
34 | T5DWH | Entitlement Control for Deferred Compensation | 2 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
35 | T5DWQ | Transfer Basic Data (Contributions) | 2 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
36 | T5DWV | Member Status | 2 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
37 | T5DWVT | Membership Status Text | 3 | HANSP | Company Pension Scheme Entitlement | nvarchar | 4 | 0 | | |
TOPGermany |
38 | T5DR4 | AVmG: Specifications of Modules | 23 | HANSP | AVmG: Company Pension Entitlement | nvarchar | 4 | 0 | | |