| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2RG_CNIC | Cumulated NI Contributions | 5 | NICAT | NI category (GB) | nvarchar | 2 | 0 | | |
2 | P2RG_NIC | National Insurance Contributions | 5 | NICAT | NI category (GB) | nvarchar | 2 | 0 | | |
3 | P2RG_RTINI | Real Time Information - National Insurance | 5 | NICAT | NI category (GB) | nvarchar | 2 | 0 | | |
TOPGreat Britain |
4 | PA0069 | HR Master Record: Infotype 0069 (Nat. Insurance - GB) | 25 | NICAT | NI category (GB) | nvarchar | 2 | 0 | | |
5 | T5G06 | NIC Percentages (obsolete: contains NI % up to 1998) | 1 | NICAT | NI category (GB) | nvarchar | 2 | 0 | | |
6 | T5G08 | NI Control Data Texts | 3 | NICAT | NI category (GB) | nvarchar | 2 | 0 | | |
7 | T5G09 | NI Categories (GB) OBSOLETE !!! | 1 | NICAT | NI category (GB) | nvarchar | 2 | 0 | | |
8 | T5G41 | National Insurance Percentage Rates (obsolete: old NI) | 1 | NICAT | NI category (GB) | nvarchar | 2 | 0 | | |
TOPUnited Kingdom |
9 | T5G42 | HR-GB: National Insurance Categories | 1 | NICAT | NI category (GB) | nvarchar | 2 | 0 | | |
10 | T5G_DTONI | National Insurance Data Take-on | 3 | NICAT | NI category (GB) | nvarchar | 2 | 0 | | |
11 | T5G_NICPCT | NIC Percentages | 1 | NICAT | NI category (GB) | nvarchar | 2 | 0 | | |
12 | T5G_NIDTO | National Insurance data take on | 5 | NICAT | NI category (GB) | nvarchar | 2 | 0 | | |