| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2RD_VBL | Payroll Result: Supplementary Pension Public Sector | 36 | BTRTL_SUM | Personnel Subarea Reporting | nvarchar | 4 | 0 | | |
TOPGermany |
2 | T5D3R | HR-DEH: Entry of External Data | 5 | BTRTL_SUM | Personnel Subarea Reporting | nvarchar | 4 | 0 | | |
3 | T5D3S_EHVE | Additional Data: Reporting Company for Earnings Survey | 3 | BTRTL_SUM | Personnel Subarea Reporting | nvarchar | 4 | 0 | | |
4 | T5D3S_EHVS | Additional Data Report Company for Earnings Structure Survey | 3 | BTRTL_SUM | Personnel Subarea Reporting | nvarchar | 4 | 0 | | |
TOPPublic Sector |
5 | PA0051 | HR Master Record Infotype 0051 (VBL/SPI Data) | 47 | BTRTL_SUM | Personnel Subarea Reporting | nvarchar | 4 | 0 | | |
6 | PDPBSZVADM | Administration Table for ZVE-PBS Notification Procedure | 13 | BTRTL_SUM | Personnel Subarea Reporting | nvarchar | 4 | 0 | | |
7 | PDPBSZVSUM | Totals Record (Record Type 90), SPI | 7 | BTRTL_SUM | Personnel Subarea Reporting | nvarchar | 4 | 0 | | |
8 | PDPBSZV_PA0051 | ZVMP Employer to Be Overridden in IT0051 (Before ZVMP) | 6 | BTRTL_SUM | Personnel Subarea Reporting | nvarchar | 4 | 0 | | |
9 | T5DPBSZVAG | Employer-Specific Settings | 3 | BTRTL_SUM | Personnel Subarea Reporting | nvarchar | 4 | 0 | | |
10 | T5DPBSZVAGE | Employer-Specific Settings: Entity | 3 | BTRTL_SUM | Personnel Subarea Reporting | nvarchar | 4 | 0 | | |
11 | T5DPBSZVAGT | Employer-Specific Settings: Text | 4 | BTRTL_SUM | Personnel Subarea Reporting | nvarchar | 4 | 0 | | |
TOPReuse Services for Country Development |
12 | T596L | Determination of Personnel Area Reporting | 7 | BTRTL_SUM | Personnel Subarea Reporting | nvarchar | 4 | 0 | | |
13 | T596M | Data Personnel Area Reporting | 5 | BTRTL_SUM | Personnel Subarea Reporting | nvarchar | 4 | 0 | | |
14 | T596N | Summary Personnel Area Reporting | 9 | BTRTL_SUM | Personnel Subarea Reporting | nvarchar | 4 | 0 | | |
15 | T596NV | Summary Personnel Area Reporting | 10 | BTRTL_SUM | Personnel Subarea Reporting | nvarchar | 4 | 0 | | |
TOPSocial Insurance |
16 | T5D4ATS_VAL | DEUEV Occupational Code 2010 Input Help | 3 | BTRTL_SUM | Personnel Subarea Reporting | nvarchar | 4 | 0 | | |
TOPTax |
17 | P01E2_ADM | ELStAM Procedure: Administration Data | 7 | BTRTL_SUM | Personnel Subarea Company Office for Employment Tax | nvarchar | 4 | 0 | | |
18 | P01E2_LISTMTL_ST | ELStAM: Status Table for Monthly Change Lists | 8 | BTRTL_SUM | Personnel Subarea Company Office for Employment Tax | nvarchar | 4 | 0 | | |