| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPSwitzerland |
1 | T5CS9 | HR-CH: Payroll unit - AHV/UI | 7 | VERSGES | HR-CH: Insurance company | nvarchar | 30 | 0 | | |
2 | T5CSA | HR-CH: Payroll unit UVG | 7 | VERSGES | HR-CH: Insurance company | nvarchar | 30 | 0 | | |
3 | T5CSB | HR-CH: Payroll unit: Social Funds | 6 | VERSGES | HR-CH: Insurance company | nvarchar | 30 | 0 | | |
4 | T5CSC | HR-CH: Payroll Unit: Voluntary Accident Insurance | 7 | VERSGES | HR-CH: Insurance company | nvarchar | 30 | 0 | | |
5 | T5CSD | HR-CH: Payroll Unit - Sickness Indemnity Insurance | 7 | VERSGES | HR-CH: Insurance company | nvarchar | 30 | 0 | | |
6 | T5CSE | HR-CH: Payroll unit: NBU additional insurance | 7 | VERSGES | HR-CH: Insurance company | nvarchar | 30 | 0 | | |
7 | T5CSK | HR-CH: PAyroll Unit Compensation Fund VD | 6 | VERSGES | HR-CH: Insurance company | nvarchar | 30 | 0 | | |
8 | T5CSM | HR-CH: Payroll Unit BVG ELM | 5 | VERSGES | HR-CH: BVG Insurance Company ELM | nvarchar | 40 | 0 | | |
9 | T5CSX | HR-CH: Payroll unit: Customer insurance 1 | 7 | VERSGES | HR-CH: Insurance company | nvarchar | 30 | 0 | | |
10 | T5CSY | HR-CH: Payroll unit: Customer insurance 2 | 7 | VERSGES | HR-CH: Insurance company | nvarchar | 30 | 0 | | |
11 | T5CSZ | HR-CH: Payroll unit: Customer insurance 3 | 7 | VERSGES | HR-CH: Insurance company | nvarchar | 30 | 0 | | |
12 | T5CZ1 | HR-CH: Payroll Unit: Family-Related Bonuses | 9 | VERSGES | HR-CH: Insurance company | nvarchar | 30 | 0 | | |