| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPNetherlands |
1 | P05FBN_ACGRP_OMS | Description Absence Quota Groups | 5 | OMSCHRIJVING | Description of Absence Quota Group | nvarchar | 40 | 0 | | |
2 | P05FBN_BSTG_OMS | Description Spending Group | 5 | OMSCHRIJVING | Description Spending Group | nvarchar | 30 | 0 | | |
3 | P05FBN_CATEG_OMS | Description Benefits Categories | 4 | OMSCHRIJVING | Description Category | nvarchar | 40 | 0 | | |
4 | P05FBN_DVRT_OMS | Description Target Variant | 6 | OMSCHRIJVING | Description Target Variant | nvarchar | 30 | 0 | | |
5 | P05FBN_KMOD_OMS | Description Programs | 5 | OMSCHRIJVING | Description Program | nvarchar | 40 | 0 | | |
6 | T5N13T | Text Table for Risk Group Sector | 5 | OMSCHRIJVING | Desciption of Sector Risk Group | nvarchar | 75 | 0 | | |
7 | T5N15T | Text Table for Risk Group Sector | 4 | OMSCHRIJVING | Sector Text | nvarchar | 75 | 0 | | |
TOPReporting |
8 | T5N16T | Text Table for SI Types | 4 | OMSCHRIJVING | Description of SI Type | nvarchar | 40 | 0 | | |
9 | T5N17T | Description of Social Insurance Calculation Methods | 4 | OMSCHRIJVING | Description of SI Method | nvarchar | 75 | 0 | | |