| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | HRPAYDEPBS_D_DNZ | Dest. Rep. Data: Suppl.Pens. "Business Complete" Information | 5 | AINSL | Key for Investment Institution | nvarchar | 8 | 0 | | |
2 | PDPBSZVADM_R | SPI Confirmation: Administration Table | 6 | AINSL | Key for Investment Institution | nvarchar | 8 | 0 | | |
3 | T5DRE | BVV: Conversion Table for AVmG | 9 | AINSL | Key for Investment Institution | nvarchar | 8 | 0 | | |
TOPGermany |
4 | PA0699 | Personnel Master Record Infotype 0699 | 25 | AINSL | Key for Investment Institution | nvarchar | 8 | 0 | | |
5 | T5DRB | AVmG: Investment Institute | 3 | AINSL | Key for Investment Institution | nvarchar | 8 | 0 | | |
TOPPublic Sector |
6 | PDPBSZVABM | Dereg. from Compulsory Insurance (Record Type 40), ZVE-PBS | 5 | AINSL | Key for Investment Institution | nvarchar | 8 | 0 | | |
7 | PDPBSZVABS | Periods (Record Type 60), ZVE-PBS | 5 | AINSL | Key for Investment Institution | nvarchar | 8 | 0 | | |
8 | PDPBSZVADM | Administration Table for ZVE-PBS Notification Procedure | 5 | AINSL | Key for Investment Institution | nvarchar | 8 | 0 | | |
9 | PDPBSZVADR | Address (Record Type 81), ZVE-PBS | 5 | AINSL | Key for Investment Institution | nvarchar | 8 | 0 | | |
10 | PDPBSZVANM | Reg. for Compulsory Insurance (Record Type 30), ZVE-PBS | 5 | AINSL | Key for Investment Institution | nvarchar | 8 | 0 | | |
11 | PDPBSZVDCARRIERS | ZVE-PBS Notification Procedure for Data Medium Admin. | 3 | AINSL | Key for Investment Institution | nvarchar | 8 | 0 | | |
12 | PDPBSZVDIF | Difference (Record Type 70), ZVE-PBS | 5 | AINSL | Key for Investment Institution | nvarchar | 8 | 0 | | |
13 | PDPBSZVLOG | Log Table for ZVE-PBS Notification Procedure | 5 | AINSL | Key for Investment Institution | nvarchar | 8 | 0 | | |
14 | PDPBSZVMDCARRS | Grouped Data Medium Administration, SP Reporting | 3 | AINSL | Key for Investment Institution | nvarchar | 8 | 0 | | |
15 | PDPBSZVNAM | Name (Record Type 80), ZVE-PBS | 5 | AINSL | Key for Investment Institution | nvarchar | 8 | 0 | | |
16 | PDPBSZVSUM | Totals Record (Record Type 90), SPI | 5 | AINSL | Key for Investment Institution | nvarchar | 8 | 0 | | |
17 | T5D5Z | Supplementary Pension Public Sector: SPI Data | 34 | AINSL | Key for Investment Institution | nvarchar | 8 | 0 | | |
18 | T5DPBSZVAB | Temporal Validity of Deregistration Reasons | 3 | AINSL | Key for Investment Institution | nvarchar | 8 | 0 | | |
19 | T5DPBSZVABT | Valid Deregistration Reasons: Texts | 4 | AINSL | Key for Investment Institution | nvarchar | 8 | 0 | | |
20 | T5DPBSZVAG | Employer-Specific Settings | 8 | AINSL | Key for Investment Institution | nvarchar | 8 | 0 | | |
21 | T5DPBSZVAV | Ring-Fencing of Supplementary Pension Institute | 3 | AINSL | Key for Investment Institution | nvarchar | 8 | 0 | | |
22 | T5DPBSZVAVT | Ring-Fencing of Supplementary Pension Institute | 4 | AINSL | Key for Investment Institution | nvarchar | 8 | 0 | | |
23 | T5DPBSZVRZ | Data Center Information | 3 | AINSL | Key for Investment Institution | nvarchar | 8 | 0 | | |
24 | T5DPBSZVRZT | Data Center Information: Text | 4 | AINSL | Key for Investment Institution | nvarchar | 8 | 0 | | |
25 | T5DPBSZVZVE | Supplementary Pension Institute | 3 | AINSL | Key for Investment Institution | nvarchar | 8 | 0 | | |