| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPCompany Pension Scheme Germany |
1 | P01CCV | CPS Cumulated Future Rights | 6 | ANGRP | Pension Plan | nvarchar | 4 | 0 | | |
2 | P01CUA | Vested Pension Rights CPS | 9 | ANGRP | Pension Plan | nvarchar | 4 | 0 | | |
3 | P01CVD | Actuarial CPS Data | 29 | ANGRP | Pension Plan | nvarchar | 4 | 0 | | |
4 | P01CVR | Actuarial CPS Pension Data | 19 | ANGRP | Pension Plan | nvarchar | 4 | 0 | | |
5 | P01VA_CLST | PEP: Benefit Reductions Pension Equalization Payment | 14 | ANGRP | Pension Plan | nvarchar | 4 | 0 | | |
6 | P01VA_LSTV | PEP: Benefits Vector Pension Equalization Payment | 11 | ANGRP | Pension Plan | nvarchar | 4 | 0 | | |
7 | PA0202 | HR Master Record Infotype 0202 (Entitlements) | 27 | ANGRP | Pension Plan | nvarchar | 4 | 0 | | |
8 | PA0323 | HR Master Record IT 0323 (Pension Plan) | 24 | ANGRP | Pension Plan | nvarchar | 4 | 0 | | |
9 | PDAVLT | Data for Valuation Assignment | 8 | ANGRP | Pension Plan | nvarchar | 4 | 0 | | |
10 | T5DCW | CPS Pension Plans | 2 | ANGRP | Pension Plan | nvarchar | 4 | 0 | | |
11 | T5DCWT | Texts for CPS Pension Plans | 3 | ANGRP | Pension Plan | nvarchar | 4 | 0 | | |
12 | T5DW9 | Assignment of Benefit Types to CPS Imputation Groups | 3 | ANGRP | Pension Plan | nvarchar | 4 | 0 | | |
13 | T5DWA | CPS Pension Plans | 2 | ANGRP | Pension Plan | nvarchar | 4 | 0 | | |
14 | T5DWB | Entitlements of a Pension Plan | 2 | ANGRP | Pension Plan | nvarchar | 4 | 0 | | |
15 | T5DWC | Entitlements/Benefit Types of a Pension Plan | 2 | ANGRP | Pension Plan | nvarchar | 4 | 0 | | |
16 | T5DWR | Pension Adjustment Control | 2 | ANGRP | Pension Plan | nvarchar | 4 | 0 | | |
TOPConditions |
17 | KONA | Agreements | 49 | ANGRP | Trigger Group Message Determination | nvarchar | 2 | 0 | | |
18 | T6B1 | Rebate : Rebate Agreement Types | 50 | ANGRP | Trigger Group Message Determination | nvarchar | 2 | 0 | | |
TOPConstruction Industry |
19 | PDBKAN | Construction Industry Social Fund Proced: ANMEL Data Records | 20 | ANGRP | Employee Group for Data Record ANMEL | nvarchar | 4 | 0 | | |
TOPSubsequent Settlement |
20 | TMAN2 | Trigger Group of Message Determination | 3 | ANGRP | Trigger Group Message Determination | nvarchar | 2 | 0 | | |
21 | TMAN2T | Trigger Group of Message Determination - Description | 4 | ANGRP | Trigger Group Message Determination | nvarchar | 2 | 0 | | |
22 | TMAN3 | Trigger Group of Message Determination - Trigger Condition | 3 | ANGRP | Trigger Group Message Determination | nvarchar | 2 | 0 | | |