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