| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2RC_CHVS | HR-CH: Payroll result insurance | 9 | ANWSCHLCH | Application key Switzerland | nvarchar | 4 | 0 | | |
2 | T5CS1_CE | HR-CH CE: Maximum Wage, Exemptions Distribution Mechanisms | 2 | ANWSCHLCH | Application key Switzerland | nvarchar | 4 | 0 | | |
3 | T5CS7_CE | HR-CH-CE: Grouping for Insurances CE | 2 | ANWSCHLCH | Application key Switzerland | nvarchar | 4 | 0 | | |
TOPSwitzerland |
4 | T5C3I | HR-CH: Application Key Switzerland | 2 | ANWSCHLCH | Application key Switzerland | nvarchar | 4 | 0 | | |
5 | T5C3IT | HR-CH: Application key Switzerland | 3 | ANWSCHLCH | Application key Switzerland | nvarchar | 4 | 0 | | |
6 | T5C3J | HR-CH: Assignment of Application Keys to Payroll Units | 2 | ANWSCHLCH | Application key Switzerland | nvarchar | 4 | 0 | | |
7 | T5C51 | ELM: Grouping Payroll Units for Enterprise | 3 | ANWSCHLCH | Application key Switzerland | nvarchar | 4 | 0 | | |
8 | T5CEN | HR-CH: Payroll Units for Master Data Sheet | 4 | ANWSCHLCH | Application key Switzerland | nvarchar | 4 | 0 | | |
9 | T5CEO | HR-CH: Data from Payroll Units | 4 | ANWSCHLCH | Application key Switzerland | nvarchar | 4 | 0 | | |
10 | T5CS1 | HR-CH: Control of SI | 2 | ANWSCHLCH | Application key Switzerland | nvarchar | 4 | 0 | | |
11 | T5CS2 | HR-CH: Application Key Switzerland | 3 | ANWSCHLCH | Application key Switzerland | nvarchar | 4 | 0 | | |
12 | T5CS3 | HR-CH: Creation of Wage Types for SI | 2 | ANWSCHLCH | Application key Switzerland | nvarchar | 4 | 0 | | |
13 | T5CS4 | HR-CH: Application Key Switzerland | 2 | ANWSCHLCH | Application key Switzerland | nvarchar | 4 | 0 | | |
14 | T5CS5 | HR-CH: Creation of Wage Types for SI | 2 | ANWSCHLCH | Application key Switzerland | nvarchar | 4 | 0 | | |
15 | T5CS7 | HR-CH: Premium Rates for Insurance | 2 | ANWSCHLCH | Application key Switzerland | nvarchar | 4 | 0 | | |
16 | T5CS8 | HR-CH: Texts for Contribution Rates for Insurance | 3 | ANWSCHLCH | Application key Switzerland | nvarchar | 4 | 0 | | |