| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPSwitzerland |
1 | T5CSA | HR-CH: Payroll unit UVG | 12 | VERTRNR | UVG Contract Identification (ELM) | nvarchar | 15 | 0 | | |
2 | T5CSC | HR-CH: Payroll Unit: Voluntary Accident Insurance | 12 | VERTRNR | UEB Contract Identification | nvarchar | 15 | 0 | | |
3 | T5CSD | HR-CH: Payroll Unit - Sickness Indemnity Insurance | 12 | VERTRNR | KTG Contract Identification (ELM) | nvarchar | 15 | 0 | | |
4 | T5CSE | HR-CH: Payroll unit: NBU additional insurance | 12 | VERTRNR | HR-CH: UVGZ Contract Identification ELM | nvarchar | 15 | 0 | | |
5 | T5CSM | HR-CH: Payroll Unit BVG ELM | 7 | VERTRNR | HR-CH: BVG Contract Identification ELM | nvarchar | 15 | 0 | | |