| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T5D1I | Health Insurance Contributions for the Compulsory Insured | 2 | KVSCH | HI Fund Key for Compulsory Health Insurance Fund | nvarchar | 8 | 0 | | |
2 | T5D1KK | Account Data from Contribution Rate File | 2 | KVSCH | HI Fund Key for Compulsory Health Insurance Fund | nvarchar | 8 | 0 | | |
3 | T5D1L | SI Withholding Deductions (D) | 4 | KVSCH | HI Fund Key for Compulsory Health Insurance Fund | nvarchar | 8 | 0 | | |
4 | T5D1O | Health Insurance Funds, Voluntary Contributions | 2 | KVSCH | HI Fund Key for Compulsory Health Insurance Fund | nvarchar | 8 | 0 | | |
5 | T5T1M_N | Health insurers - data for XML | 3 | KVSCH | Health insurance key for compulsory HI fund | nvarchar | 8 | 0 | | |
TOPGermany |
6 | PD3DSAP | HR-DDU: Administration Record for Notifications | 22 | KVSCH | HR-DDU: Health Insurance Fund | nvarchar | 8 | 0 | | |
7 | T5D11 | Calculation Procedures and Indicators of Health Ins. Funds | 2 | KVSCH | HI Fund Key for Compulsory Health Insurance Fund | nvarchar | 8 | 0 | | |
8 | T5D16 | Advanced Payment - Statement of Contributions Paid | 8 | KVSCH | HI Fund Key for Compulsory Health Insurance Fund | nvarchar | 8 | 0 | | |
9 | T5D19 | Assignment of Individual SI Contribution Funds | 7 | KVSCH | HI Fund Key for Compulsory Health Insurance Fund | nvarchar | 8 | 0 | | |
10 | T5D1A | Social Insurance Contributions | 7 | KVSCH | HI Fund Key for Compulsory Health Insurance Fund | nvarchar | 8 | 0 | | |
11 | T5D1J | Health Insurance Contribution Rates | 2 | KVSCH | HI Fund Key for Compulsory Health Insurance Fund | nvarchar | 8 | 0 | | |
12 | T5D1K | Branch Offices | 2 | KVSCH | HI Fund Key for Compulsory Health Insurance Fund | nvarchar | 8 | 0 | | |
13 | T5D1M | HI Contributions Reduced Voluntarily | 2 | KVSCH | HI Fund Key for Compulsory Health Insurance Fund | nvarchar | 8 | 0 | | |
14 | T5D1Z | Contributions to Care Insurance, Voluntarily Insured | 2 | KVSCH | HI Fund Key for Compulsory Health Insurance Fund | nvarchar | 8 | 0 | | |
15 | T5D30 | Attributes for Reimbursing Employer Expenses | 2 | KVSCH | HI Fund Key for Compulsory Health Insurance Fund | nvarchar | 8 | 0 | | |
16 | T5D49 | Assignment SI Contribution Rates U1 | 4 | KVSCH | HI Fund Key for Compulsory Health Insurance Fund | nvarchar | 8 | 0 | | |
17 | T5D4R | DEUEV: Assignment to Recipient Funds | 7 | KVSCH | HI Fund Key for Compulsory Health Insurance Fund | nvarchar | 8 | 0 | | |
18 | T5D4S | DEUEV: File Counter | 4 | KVSCH | HI Fund Key for Compulsory Health Insurance Fund | nvarchar | 8 | 0 | | |
TOPPayroll |
19 | T5T1K | Health insurance institutions | 2 | KVSCH | Health insurance key for compulsory HI fund | nvarchar | 8 | 0 | | |
20 | T5T1M | Zdravotni pojištovny - rozširující informace | 2 | KVSCH | Císlo zdravotní pojištovny | nvarchar | 8 | 0 | | |
21 | T5T1X | Last foreign Health insurance - name | 2 | KVSCH | Health insurance key for compulsory HI fund | nvarchar | 8 | 0 | | |
22 | T5TA2 | Medium for health insurance | 4 | KVSCH | Health insurance key for compulsory HI fund | nvarchar | 8 | 0 | | |
23 | T7SK1K | Health insurance institutions | 2 | KVSCH | Health insurance key for compulsory HI fund | nvarchar | 8 | 0 | | |
TOPPublic Sector |
24 | P593R | Application Status: SI Reimbursement for Rehabilitants | 15 | KVSCH | HI Fund Key for Compulsory Health Insurance Fund | nvarchar | 8 | 0 | | |
25 | T5D8Q | Properties of Rehabilitation Programs | 9 | KVSCH | SI Key | nvarchar | 1 | 0 | | |
TOPSocial Insurance |
26 | T5D17 | Subsequent Administration of Locked HI Funds | 6 | KVSCH | HI Fund Key for Compulsory Health Insurance Fund | nvarchar | 8 | 0 | | |
TOPSouth Africa |
27 | T5W1H | Medical Aid Payment model Assignment | 2 | KVSCH | Social Insurance Company | nvarchar | 8 | 0 | | |
28 | T5W1K | Pension Funds and Medical Aid Schemes (RSA) | 3 | KVSCH | Insurance Company | nvarchar | 8 | 0 | | |
29 | T5W1M | Social insurance companies | 3 | KVSCH | Social Insurance Company | nvarchar | 8 | 0 | | |
30 | T5W1N | Social insurance schemes | 3 | KVSCH | Social Insurance Company | nvarchar | 8 | 0 | | |
31 | T5W1O | Contributions for Social Insurances | 3 | KVSCH | Social Insurance Company | nvarchar | 8 | 0 | | |
32 | T5W1R | Social Insurance schemes ZA Text | 4 | KVSCH | Social Insurance Company | nvarchar | 8 | 0 | | |
33 | T5W1U | Contribution class for social insurances ZA | 3 | KVSCH | Social Insurance Company | nvarchar | 8 | 0 | | |
34 | T5W1V | Contribution class for social insurances ZA text | 4 | KVSCH | Social Insurance Company | nvarchar | 8 | 0 | | |
35 | T5W1X | Social Insurance Contributions ZA | 3 | KVSCH | Social Insurance Company | nvarchar | 8 | 0 | | |
36 | T5W1Y | Medical Aid contribution (as of 01.01.2000) | 2 | KVSCH | Social Insurance Company | nvarchar | 8 | 0 | | |
37 | T5W1Z | Late Joiner Penalties | 2 | KVSCH | Social Insurance Company | nvarchar | 8 | 0 | | |
TOPStatements |
38 | P01W_ADMIN_01 | HR: Data Module: Administration for Health Insurance Funds | 13 | KVSCH | HIF Key of Payee Health Insurance Fund | nvarchar | 8 | 0 | | |