| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2RB_CI | Payroll Result: Complementary Indemnity- CI (BE) | 21 | RSZKN | Worker Code (SI Employee Category) (00037) | nvarchar | 3 | 0 | | |
2 | P2RB_SV | Social Insurance payroll Belgium | 56 | RSZKN | Worker Code (SI Employee Category) (00037) | nvarchar | 3 | 0 | | |
3 | P2RB_SVEVL | Payroll Results: DMFA Social Insurance table for Evaluation | 9 | RSZKN | Worker Code (SI Employee Category) (00037) | nvarchar | 3 | 0 | | |
4 | T5B0A | Text Table SI Categories Employees (B) | 3 | RSZKN | Worker Code (SI Employee Category) (00037) | nvarchar | 3 | 0 | | |
5 | T5B9G | Employee Groups/Subgroups (B) | 12 | RSZKN | Worker Code (SI Employee Category) (00037) | nvarchar | 3 | 0 | | |
6 | T5BVY | Base Rates for SI Contributions | 3 | RSZKN | Worker Code (SI Employee Category) (00037) | nvarchar | 3 | 0 | | |
TOPBelgium |
7 | PA0100 | HR Master Record: Infotype 0100 (SI B) | 28 | RSZKN | Worker Code (SI Employee Category) (00037) | nvarchar | 3 | 0 | | |
8 | PA3270 | HR Master Record: Infotype 3270 | 35 | RSZKN | Worker Code | nvarchar | 3 | 0 | | |
9 | T5B01 | SI Categories Employees (B) | 2 | RSZKN | Worker Code (SI Employee Category) (00037) | nvarchar | 3 | 0 | | |
10 | T5B0J | Usage for SI Category Employee | 2 | RSZKN | Worker Code (SI Employee Category) (00037) | nvarchar | 3 | 0 | | |
11 | T5BCISIC | Complementary Indemnity: Social Insurance Contributions | 2 | RSZKN | Worker Code (SI Employee Category) (00037) | nvarchar | 3 | 0 | | |
12 | T5BD3 | Additional Social Insurance Contributions (obsolete) | 4 | RSZKN | Worker Code (SI Employee Category) (00037) | nvarchar | 3 | 0 | | |
13 | T5BDA | Additional Social Insurance Contributions | 4 | RSZKN | Worker Code (SI Employee Category) (00037) | nvarchar | 3 | 0 | | |
14 | T5BS3 | Employee information except reductions ( level 3 ) | 6 | RSZKN | Worker Code (SI Employee Category) (00037) | nvarchar | 3 | 0 | | |
15 | T5BS4 | Employee remuneration and absence information ( level 4) | 6 | RSZKN | Worker Code (SI Employee Category) (00037) | nvarchar | 3 | 0 | | |
16 | T5BSR | Reductions for an employee reported on level 3 | 6 | RSZKN | Worker Code (SI Employee Category) (00037) | nvarchar | 3 | 0 | | |
17 | T5BV2 | Percentages SI-part per category employer/employee | 3 | RSZKN | Worker Code (SI Employee Category) (00037) | nvarchar | 3 | 0 | | |
18 | T5BV3 | Total SI per employer/employee category | 3 | RSZKN | Worker Code (SI Employee Category) (00037) | nvarchar | 3 | 0 | | |
19 | T5BV5 | Rate for existance insurance fund | 3 | RSZKN | Worker Code (SI Employee Category) (00037) | nvarchar | 3 | 0 | | |
20 | T5BV7 | Rates for wage moderation | 3 | RSZKN | Worker Code (SI Employee Category) (00037) | nvarchar | 3 | 0 | | |
21 | T5BVO | Quarterly control ticket SI declaration | 2 | RSZKN | Worker Code (SI Employee Category) (00037) | nvarchar | 3 | 0 | | |
22 | T5BVT | Logic of the social security payments | 4 | RSZKN | Worker Code (SI Employee Category) (00037) | nvarchar | 3 | 0 | | |
23 | T5BVU | Logic of the social security reductions | 5 | RSZKN | Worker Code (SI Employee Category) (00037) | nvarchar | 3 | 0 | | |
24 | T5BVV | Level/block sequence of the social insurance declaration | 10 | RSZKN | SI category employee sequence | nvarchar | 2 | 0 | | |