| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T5D1B | Special SI Rules | 2 | SVSPA | SI Division | nvarchar | 1 | 0 | | |
2 | T5D1C | Texts for Special Rules for SI | 3 | SVSPA | SI Division | nvarchar | 1 | 0 | | |
3 | T5D1F | Reasons for Exemption from SI Contributions | 3 | SVSPA | SI Division | nvarchar | 1 | 0 | | |
4 | T5D1G | Contribution Scales for Supplementary Insurance | 2 | SVSPA | Social Insurance Division | nvarchar | 1 | 0 | | |
5 | T5D1W | Supplementary Pensions | 2 | SVSPA | Social Insurance Division | nvarchar | 1 | 0 | | |
6 | T5D1X | Supplementary Pension (D) Percentage Rates | 2 | SVSPA | Social Insurance Division | nvarchar | 1 | 0 | | |
TOPGermany |
7 | T5D12 | Reason for Exemption from Insurance Liability | 2 | SVSPA | SI Division | nvarchar | 1 | 0 | | |
8 | T5D1H | Supplementary Insurance | 2 | SVSPA | Social Insurance Division | nvarchar | 1 | 0 | | |
9 | T5D1P | Social Insurance Keys | 3 | SVSPA | SI Division | nvarchar | 1 | 0 | | |
10 | T5D1S | Gross SI | 8 | SVSPA | SI Division Calculation | nvarchar | 1 | 0 | | |
11 | T5D1Y | Social Insurance Divisions w/ Valid SAP Contribution Groups | 2 | SVSPA | SI Division | nvarchar | 1 | 0 | | |
12 | T5D4M | Official Social Insurance Key | 1 | SVSPA | SI Division | nvarchar | 1 | 0 | | |
13 | T5DP9 | Conversion of HI Fund Infotypes 0013/0079 -> PAISY | 3 | SVSPA | Social Insurance Division | nvarchar | 1 | 0 | | |
TOPPayroll |
14 | T5T3A | SI insurance calculation | 4 | SVSPA | Type of SP/ZP | nvarchar | 1 | 0 | | |
15 | T5T3B | Forms for changes of eval.base of SI | 4 | SVSPA | Type of SP/ZP | nvarchar | 1 | 0 | | |
16 | T5T3C | Calculation of SI | 4 | SVSPA | Type of SP/ZP | nvarchar | 1 | 0 | | |
17 | T7SK3A | Insurance calculation configuration | 3 | SVSPA | Type of SP/ZP | nvarchar | 1 | 0 | | |
18 | T7SK3B | Changes of evaluated insurance bases | 3 | SVSPA | Type of SP/ZP | nvarchar | 1 | 0 | | |
19 | T7SK3C | Routines for calculation of HI&SI payment | 3 | SVSPA | Type of SP/ZP | nvarchar | 1 | 0 | | |
TOPSouth Africa |
20 | T5W1F | RSA SI Exemption Reasons | 3 | SVSPA | Social Insurance Type (1=MA, 2=PF, 3=UIF) | nvarchar | 1 | 0 | | |
21 | T5W1G | RSA SI Exemption Reasons | 2 | SVSPA | Social Insurance Type (1=MA, 2=PF, 3=UIF) | nvarchar | 1 | 0 | | |
22 | T5W1K | Pension Funds and Medical Aid Schemes (RSA) | 2 | SVSPA | Social Insurance Type (1=MA, 2=PF, 3=UIF) | nvarchar | 1 | 0 | | |
23 | T5W1M | Social insurance companies | 2 | SVSPA | Social Insurance Type (1=MA, 2=PF, 3=UIF) | nvarchar | 1 | 0 | | |
24 | T5W1N | Social insurance schemes | 2 | SVSPA | Social Insurance Type (1=MA, 2=PF, 3=UIF) | nvarchar | 1 | 0 | | |
25 | T5W1O | Contributions for Social Insurances | 2 | SVSPA | Social Insurance Type (1=MA, 2=PF, 3=UIF) | nvarchar | 1 | 0 | | |
26 | T5W1P | RSA Definitions of Social Insurances | 3 | SVSPA | Social Insurance Type (1=MA, 2=PF, 3=UIF) | nvarchar | 1 | 0 | | |
27 | T5W1Q | Social insurance indicator | 2 | SVSPA | Social Insurance Type (1=MA, 2=PF, 3=UIF) | nvarchar | 1 | 0 | | |
28 | T5W1R | Social Insurance schemes ZA Text | 3 | SVSPA | Social Insurance Type (1=MA, 2=PF, 3=UIF) | nvarchar | 1 | 0 | | |
29 | T5W1U | Contribution class for social insurances ZA | 2 | SVSPA | Social Insurance Type (1=MA, 2=PF, 3=UIF) | nvarchar | 1 | 0 | | |
30 | T5W1V | Contribution class for social insurances ZA text | 3 | SVSPA | Social Insurance Type (1=MA, 2=PF, 3=UIF) | nvarchar | 1 | 0 | | |
31 | T5W1X | Social Insurance Contributions ZA | 2 | SVSPA | Social Insurance Type (1=MA, 2=PF, 3=UIF) | nvarchar | 1 | 0 | | |
32 | T5W3A | Wagetypes to Subtype relation | 5 | SVSPA | Social Insurance Type (1=MA, 2=PF, 3=UIF) | nvarchar | 1 | 0 | | |