| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T5CS1_CE | HR-CH CE: Maximum Wage, Exemptions Distribution Mechanisms | 4 | MOSV | Payroll unit grouping for SI | nvarchar | 2 | 0 | | |
TOPSwitzerland |
2 | T5CS1 | HR-CH: Control of SI | 4 | MOSV | Payroll unit grouping for SI | nvarchar | 2 | 0 | | |
3 | T5CS3 | HR-CH: Creation of Wage Types for SI | 4 | MOSV | Payroll unit grouping for SI | nvarchar | 2 | 0 | | |
4 | T5CS5 | HR-CH: Creation of Wage Types for SI | 4 | MOSV | Payroll unit grouping for SI | nvarchar | 2 | 0 | | |
5 | T5CS9 | HR-CH: Payroll unit - AHV/UI | 5 | MOSV | Payroll unit grouping for SI | nvarchar | 2 | 0 | | |
6 | T5CSA | HR-CH: Payroll unit UVG | 5 | MOSV | Payroll unit grouping for SI | nvarchar | 2 | 0 | | |
7 | T5CSB | HR-CH: Payroll unit: Social Funds | 5 | MOSV | Payroll unit grouping for SI | nvarchar | 2 | 0 | | |
8 | T5CSC | HR-CH: Payroll Unit: Voluntary Accident Insurance | 5 | MOSV | Payroll unit grouping for SI | nvarchar | 2 | 0 | | |
9 | T5CSD | HR-CH: Payroll Unit - Sickness Indemnity Insurance | 5 | MOSV | Payroll unit grouping for SI | nvarchar | 2 | 0 | | |
10 | T5CSE | HR-CH: Payroll unit: NBU additional insurance | 5 | MOSV | Payroll unit grouping for SI | nvarchar | 2 | 0 | | |
11 | T5CSH | Grouping for Social Insurance | 2 | MOSV | Payroll unit grouping for SI | nvarchar | 2 | 0 | | |
12 | T5CSHT | Grouping for Social Insurance Switzerland | 3 | MOSV | Payroll unit grouping for SI | nvarchar | 2 | 0 | | |
13 | T5CSK | HR-CH: PAyroll Unit Compensation Fund VD | 5 | MOSV | Payroll unit grouping for SI | nvarchar | 2 | 0 | | |
14 | T5CSX | HR-CH: Payroll unit: Customer insurance 1 | 5 | MOSV | Payroll unit grouping for SI | nvarchar | 2 | 0 | | |
15 | T5CSY | HR-CH: Payroll unit: Customer insurance 2 | 5 | MOSV | Payroll unit grouping for SI | nvarchar | 2 | 0 | | |
16 | T5CSZ | HR-CH: Payroll unit: Customer insurance 3 | 5 | MOSV | Payroll unit grouping for SI | nvarchar | 2 | 0 | | |