| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPGermany |
1 | PD3DSAP | HR-DDU: Administration Record for Notifications | 23 | KVGES | HR-DDU: Health Insurance Fund/Branch Office | nvarchar | 6 | 0 | | |
2 | T5D19 | Assignment of Individual SI Contribution Funds | 8 | KVGES | HI Fund Branch Office | nvarchar | 6 | 0 | | |
3 | T5D1A | Social Insurance Contributions | 10 | KVGES | HI Fund Branch Office | nvarchar | 6 | 0 | | |
4 | T5D1K | Branch Offices | 3 | KVGES | HI Fund Branch Office | nvarchar | 6 | 0 | | |
5 | T5D4R | DEUEV: Assignment to Recipient Funds | 8 | KVGES | HI Fund Branch Office | nvarchar | 6 | 0 | | |
6 | T5D4S | DEUEV: File Counter | 5 | KVGES | HI Fund Branch Office | nvarchar | 6 | 0 | | |
TOPPayroll |
7 | T5T1K | Health insurance institutions | 5 | KVGES | Health insurance fund - branch office | nvarchar | 6 | 0 | | |
8 | T5T1X | Last foreign Health insurance - name | 3 | KVGES | Health insurance fund - branch office | nvarchar | 6 | 0 | | |
9 | T5TA2 | Medium for health insurance | 5 | KVGES | Health insurance fund - branch office | nvarchar | 6 | 0 | | |
10 | T7SK1K | Health insurance institutions | 5 | KVGES | Health insurance fund - branch office | nvarchar | 6 | 0 | | |
TOPPublic Sector |
11 | P593R | Application Status: SI Reimbursement for Rehabilitants | 16 | KVGES | HI Fund Branch Office | nvarchar | 6 | 0 | | |
TOPSouth Africa |
12 | T5W1H | Medical Aid Payment model Assignment | 3 | KVGES | Social Insurance Scheme | nvarchar | 6 | 0 | | |
13 | T5W1K | Pension Funds and Medical Aid Schemes (RSA) | 4 | KVGES | Subsidiary | nvarchar | 6 | 0 | | |
14 | T5W1N | Social insurance schemes | 4 | KVGES | Social Insurance Scheme | nvarchar | 6 | 0 | | |
15 | T5W1R | Social Insurance schemes ZA Text | 5 | KVGES | Social Insurance Scheme | nvarchar | 6 | 0 | | |
16 | T5W1U | Contribution class for social insurances ZA | 4 | KVGES | Social Insurance Scheme | nvarchar | 6 | 0 | | |
17 | T5W1V | Contribution class for social insurances ZA text | 5 | KVGES | Social Insurance Scheme | nvarchar | 6 | 0 | | |
18 | T5W1X | Social Insurance Contributions ZA | 4 | KVGES | Social Insurance Scheme | nvarchar | 6 | 0 | | |
19 | T5W1Y | Medical Aid contribution (as of 01.01.2000) | 3 | KVGES | Social Insurance Scheme | nvarchar | 6 | 0 | | |
20 | T5W1Z | Late Joiner Penalties | 3 | KVGES | Social Insurance Scheme | nvarchar | 6 | 0 | | |
TOPStatements |
21 | P01W_ADMIN_01 | HR: Data Module: Administration for Health Insurance Funds | 14 | KVGES | Branch Office of Payee Health Insurance Fund | nvarchar | 6 | 0 | | |