| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P05EIR_IKV | Electronic Illness Reporting. Work Relationship Data | 4 | BEGDAIV | Start Date | nvarchar | 8 | 0 | | |
TOPReporting |
2 | P05T_CURR_NUMIV | Wage Return: current IR number | 5 | BEGDAIV | Start Date | nvarchar | 8 | 0 | | |
3 | P05T_IV_AANGIFTE | Wage Return: Income Relationship - Nominative Return | 8 | BEGDAIV | Start Date | nvarchar | 8 | 0 | | |
4 | P05T_IV_AANG_CUM | Wage Return: Cumulated Values per Income Relationship | 8 | BEGDAIV | Start Date | nvarchar | 8 | 0 | | |
5 | P05T_IV_AA_BSN | Wage Return: Cumulated Values for BSN Changers | 8 | BEGDAIV | Start Date | nvarchar | 8 | 0 | | |
6 | P05T_IV_ADM | Wage Return: Income Relationship - Admin. Table | 8 | BEGDAIV | Start Date | nvarchar | 8 | 0 | | |
7 | P05T_IV_ADM_STAT | Wage Return: Income Relationship - Status Table | 8 | BEGDAIV | Start Date | nvarchar | 8 | 0 | | |
8 | P05T_IV_DA | Wage Return: Income Relationship - Return Data | 8 | BEGDAIV | Start Date | nvarchar | 8 | 0 | | |
9 | P05T_IV_DA_BSN | Wage Return: Other Cumulated Return Data | 8 | BEGDAIV | Start Date | nvarchar | 8 | 0 | | |
10 | P05T_IV_DA_CUM | Wage Return: Other Cumulated Return Data | 8 | BEGDAIV | Start Date | nvarchar | 8 | 0 | | |
11 | P05T_IV_INKPER | Wage Return: Income Relationship - Income Period | 8 | BEGDAIV | Start Date | nvarchar | 8 | 0 | | |
12 | P05T_IV_INKPERSA | Wage Return: Income Relationship - Income Period SI | 8 | BEGDAIV | Start Date | nvarchar | 8 | 0 | | |
13 | P05T_IV_PERSOON | Wage Return: Income Relationship - Personal Data | 8 | BEGDAIV | Start Date | nvarchar | 8 | 0 | | |
14 | P05T_IV_RG | Wage Return: Income Relationship - Risk Group Sector | 8 | BEGDAIV | Start Date | nvarchar | 8 | 0 | | |
15 | P05T_IV_RG_CUM | Wage Return: Income Relationship: Sect./Riskgrp. cumulated | 8 | BEGDAIV | Start Date | nvarchar | 8 | 0 | | |
16 | P05T_JLO_DATA | Data for Annual Wage Return | 7 | BEGDAIV | Start Date | nvarchar | 8 | 0 | | |
17 | P05T_NOM_ERROR | Errors in Nominative Wage Returns | 8 | BEGDAIV | Start Date | nvarchar | 8 | 0 | | |