| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | JUPER | Representing Legal Person | nvarchar | 4 | 0 | CHAR | (N' ') | No | T5N9P | P05_REPER | Allow NULL? |
| 3 | PABRJ | HCIB for year period | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | P05T_CVZ_ANPRJ | Allow NULL? |
| 4 | PABRP | HCIB for period | nvarchar | 2 | 0 | NUMC | (N'00') | No | | P05T_CVZ_ANPRP | Allow NULL? |
| 5 | PERNR | Personnel number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | PA0003 | PERSNO | Allow NULL? |
| 6 | PERSID | HCIB: Sequence number instead of personnel number | nvarchar | 3 | 0 | NUMC | (N'000') | No | | P05T_CVZ_PERSID | Allow NULL? |
| 7 | SEQNO | Alphanumeric symbol for HCIB files | nvarchar | 4 | 0 | CHAR | (N' ') | No | | P05T_CVZ_SEQNO | Allow NULL? |
| 8 | GDATE | Creation/Change Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | P05T_GDATE | Allow NULL? |
| 9 | GTIME | Creation/Change Hour | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | P05T_GTIME | Allow NULL? |
| 10 | CVZ_ORGNR | Organization number for HCIB | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P05T_CVZ_ORGNR | Allow NULL? |
| 11 | CVZ_ORGCDE | Organizational key for HCIB | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | P05T_CVZ_ORGCDE | Allow NULL? |
| 12 | CVZ_ID | Insured person's identifier with HCIB | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | P05T_CVZ_ID | Allow NULL? |
| 13 | CVZ_MAAND | Month for HCIB | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | P05T_CVZ_MAAND | Allow NULL? |
| 14 | CVZ_JAAR | Year for HCIB | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | P05T_CVZ_JAAR | Allow NULL? |
| 15 | CVZ_ACTUEEL | Current status of insured person for HCIB | char | 1 | 0 | NUMC | (N'0') | Yes | | P05T_CVZ_ACTUEEL | Allow NULL? |
| 16 | CVZ_INH_NOMINAAL | Deduction for nominal ZVW contribution | decimal | 6 | 2 | DEC | ((0)) | Yes | | P05T_CVZ_INH_NOMINAAL | |
| 17 | CVZ_INH_ZVW | Translation factor for deduction of ZVW contribution | decimal | 4 | 3 | DEC | ((0)) | Yes | | P05T_CVZ_INH_ZVW | |
| 18 | CVZ_INH_AWBZ | Conversion factor for deduction of AWBZ contribution | decimal | 4 | 3 | DEC | ((0)) | Yes | | P05T_CVZ_INH_AWBZ | |
| 19 | CVZ_HM | Registration number of main person insured/co-insured | char | 1 | 0 | CHAR | (N' ') | Yes | | P05T_CVZ_HM | Allow NULL? |
| 20 | CVZ_ID_HV | Main person insured's identifier for co-insured person | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | P05T_CVZ_ID_HV | Allow NULL? |
| 21 | CVZ_GESLACHT | Gender of insured person | char | 1 | 0 | CHAR | (N' ') | Yes | | P05T_CVZ_GESLACHT | Allow NULL? |
| 22 | CVZ_OVERL | Reference number deceased | char | 1 | 0 | NUMC | (N'0') | Yes | | P05T_CVZ_OVERL | Allow NULL? |
| 23 | CVZ_VOORLETTERS | Initials | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | P05T_CVZ_VOORLETTERS | Allow NULL? |
| 24 | CVZ_VOORVOEGSEL | Name Prefix | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P05T_CVZ_VOORVOEGSEL | Allow NULL? |
| 25 | CVZ_ACHTERNAAM | Last Name | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | P05T_CVZ_ACHTERNAAM | Allow NULL? |
| 26 | CVZ_PARTNERNAAM | Partner Name | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | P05T_CVZ_PARTNERNAAM | Allow NULL? |
| 27 | CVZ_ADRES | Address for Health Care Insurance Board | nvarchar | 55 | 0 | CHAR | (N' ') | Yes | | P05T_CVZ_ADRES | Allow NULL? |
| 28 | CVZ_POSTCODE | Postal Code for HCIB | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | P05T_CVZ_POSTCODE | Allow NULL? |
| 29 | CVZ_WOONPLAATS | City for HCIB | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | P05T_CVZ_WOONPLAATS | Allow NULL? |
| 30 | CVZ_LAND | Country indicator for HCIB | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | P05T_CVZ_LAND | Allow NULL? |
| 31 | CVZ_SOFINUMMER | Social Security Number for HCIB | nvarchar | 9 | 0 | NUMC | (N'000000000') | Yes | | P05T_CVZ_SOFINUMMER | Allow NULL? |
| 32 | CVZ_GBDAT | Date of Birth for HCIB | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P05T_CVZ_GEBOORTEDATUM | Allow NULL? |
| 33 | CVZ_DT_START | Start Date Deduction | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P05T_CVZ_DT_START | Allow NULL? |
| 34 | CVZ_DT_EIND | End Date deduction | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P05T_CVZ_DT_EIND | Allow NULL? |
| 35 | CVZ_REGNR | External registration number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | P05T_CVZ_REGISTRATIENR | Allow NULL? |
| 36 | FOUTMELDING | Error message code | nvarchar | 2 | 0 | NUMC | (N'00') | No | | P05T_CVZ_FOUTMELDING | Allow NULL? |
| 37 | REGNR | External registration number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | P05T_CVZ_REGISTRATIENR | Allow NULL? |
| 38 | INH_NOMINAAL | Deduction for nominal ZVW contribution | decimal | 6 | 2 | DEC | ((0)) | Yes | | P05T_CVZ_INH_NOMINAAL | |
| 39 | INH_PERC_ZVW | Translation factor for deduction of ZVW contribution | decimal | 4 | 3 | DEC | ((0)) | Yes | | P05T_CVZ_INH_ZVW | |
| 40 | INH_ZVW | Amount of deduction by pension fund for ZVW contribution | decimal | 6 | 2 | DEC | ((0)) | Yes | | P05T_CVZ_INH_BDRG_ZVW | |
| 41 | INH_PERC_AWBZ | Conversion factor for deduction of AWBZ contribution | decimal | 4 | 3 | DEC | ((0)) | Yes | | P05T_CVZ_INH_AWBZ | |
| 42 | INH_AWBZ | Amount of deduction by pension fund for AWBZ contribution | decimal | 6 | 2 | DEC | ((0)) | Yes | | P05T_CVZ_INH_BDRG_AWBZ | |
| 43 | DT_START | Start Date Deduction | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P05T_CVZ_DT_START | Allow NULL? |
| 44 | DT_EIND | End Date deduction | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P05T_CVZ_DT_EIND | Allow NULL? |
| 45 | ORGCDE | Organizational key for HCIB | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | P05T_CVZ_ORGCDE | Allow NULL? |
| 46 | CVZ_FACTOR | Country of residence factor | decimal | 8 | 7 | DEC | ((0)) | Yes | | P05T_CVZ_FACTOR | |
| 47 | CVZ_INH_NOM_F | Nominal contribution amount, adjusted for COR HCIB | decimal | 6 | 2 | DEC | ((0)) | Yes | | P05T_CVZ_INH_NOM_F | |
| 48 | CVZ_INH_ZVW_F | Amount ZVW, adjusted for country of residence factor HCIB | decimal | 6 | 2 | DEC | ((0)) | Yes | | P05T_CVZ_INH_ZVW_F | |
| 49 | CVZ_INH_AWBZ_F | AWBZ amount, adjusted for country of residence factor HCIB | decimal | 6 | 2 | DEC | ((0)) | Yes | | P05T_CVZ_INH_AWBZ_F | |
| 50 | CVZ_DT_OVERL | Date of death | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P05T_CVZ_DT_OVERL | Allow NULL? |
| 51 | DT_OVERL | Date of death | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P05T_CVZ_DT_OVERL | Allow NULL? |
| 52 | PREMIELOON_ZVW | Cumulative Zvw premium rate (as of 1 Jan. of current year) | decimal | 8 | 2 | DEC | ((0)) | Yes | | P05T_CVZ_PREMIELOON_ZVW | |
| 53 | PREMIELOON_AWBZ | Cumulative premium rate AWBZ (beginning 1 Jan of current yr) | decimal | 8 | 2 | DEC | ((0)) | Yes | | P05T_CVZ_PREMIELOON_AWBZ | |
| 54 | WOONLAND | Country indicator for HCIB | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | P05T_CVZ_LAND | Allow NULL? |
| 55 | FACTOR | Country of residence factor | decimal | 8 | 7 | DEC | ((0)) | Yes | | P05T_CVZ_FACTOR | |
| 56 | CVZ_AANTAL_VERZ | Number of insured persons for whom contribution is deducted | decimal | 2 | 0 | DEC | ((0)) | Yes | | P05T_CVZ_AANT_VERZ | |
| 57 | AANTAL_VER | Number of insured persons for whom contribution is deducted | decimal | 2 | 0 | DEC | ((0)) | Yes | | P05T_CVZ_AANT_VERZ | |
| 58 | ALL_OUDEREN_KORT | Care Insurance Board: All Elderly Persons' Tax Credit | char | 1 | 0 | CHAR | (N' ') | Yes | | P05T_CVZ_ALL_OUDEREN_KORTING | Allow NULL? |
| 59 | CVZ_INH_ZVW_2008 | Translation Ratio for Deduction of Contribution ZVW (2008) | decimal | 6 | 5 | DEC | ((0)) | Yes | | P05T_CVZ_INH_ZVW_2008 | |
| 60 | CVZ_IH_AWBZ_2008 | Translation Ratio for Deduction of Contribution AWBZ (2008) | decimal | 6 | 5 | DEC | ((0)) | Yes | | P05T_CVZ_INH_AWBZ_2008 | |
| 61 | INH_PER_ZVW_2008 | Translation Ratio for Deduction of Contribution ZVW (2008) | decimal | 6 | 5 | DEC | ((0)) | Yes | | P05T_CVZ_INH_ZVW_2008 | |
| 62 | INH_PR_AWBZ_2008 | Translation Ratio for Deduction of Contribution AWBZ (2008) | decimal | 6 | 5 | DEC | ((0)) | Yes | | P05T_CVZ_INH_AWBZ_2008 | |
| 63 | CVZ_IH_ZVW_F_08 | Amount Zvw, adjusted for country of residence factor CVZ | decimal | 5 | 4 | DEC | ((0)) | Yes | | P05T_CVZ_INH_ZVW_F_2008 | |
| 64 | CVZ_IH_AWBZ_F_08 | AWBZ amount, adjusted for country of residence factor CVZ | decimal | 5 | 4 | DEC | ((0)) | Yes | | P05T_CVZ_INH_AWBZ_F_2008 | |
