| 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 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | NPAT | PATNR | Allow NULL? |
| 3 | LFDNR | IS-H: Sequence Number of Insurance Relationship | nvarchar | 3 | 0 | NUMC | (N'000') | No | | LFDVV | Allow NULL? |
| 4 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | NGPA | KH_KOSTR | Allow NULL? |
| 5 | SELKZ | IS-H: Indicator for self-payer/copayer ins.relation. | char | 1 | 0 | CHAR | (N' ') | Yes | | SELBZ_KZ | Allow NULL? |
| 6 | MGART | IS-H: Type of Insurance Coverage | char | 1 | 0 | CHAR | (N' ') | Yes | * | MITART_VER | Allow NULL? |
| 7 | UNTGR | IS-H: Insurance Subgroup | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | UNTGR | Allow NULL? |
| 8 | VERNR | IS-H: Patient Health Insurance Number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | VERSNR | Allow NULL? |
| 9 | VERAB | IS-H: Valid-From Date of Insurance Relationship | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BEGDTVVP | Allow NULL? |
| 10 | VERBI | IS-H: Valid-to Date of Insurance Relationship | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ENDDTVVP | Allow NULL? |
| 11 | VERGE | IS-H: Sex of Person Insured | char | 1 | 0 | CHAR | (N' ') | Yes | | VERGE | Allow NULL? |
| 12 | VERNN | Last Name of Insured Person | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | VERNN | Allow NULL? |
| 13 | VERVN | First Name of Insured Person | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | VERVN | Allow NULL? |
| 14 | VERAN | IS-H: Form-of-Address Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | RI_ANRDS | Allow NULL? |
| 15 | VERTI | Title of Insured Person | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | * | VERTI | Allow NULL? |
| 16 | VERNZ | Name Affix of Insured Person | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | * | VERNZ | Allow NULL? |
| 17 | VERVW | Name Prefix of Insured Person | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | * | VERVW | Allow NULL? |
| 18 | VERGB | IS-H: Date of Birth of Person Insured | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VERGB | Allow NULL? |
| 19 | VERLA | Country of Insured Person | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | VERLA | Allow NULL? |
| 20 | VERNA | IS-H: Nationality of Person | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | ISH_NATIO | Allow NULL? |
| 21 | VERPL | Postal Code of Insured Person | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | VERPLZ | Allow NULL? |
| 22 | VEROR | City where Insured Person Resides | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | VERORT | Allow NULL? |
| 23 | VERST | Street and House Number of Insured Person | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | VERST | Allow NULL? |
| 24 | VERTE | Telephone Number of Insured Person | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | VERTE_D | Allow NULL? |
| 25 | VERSV | Social Insurance Number of Insured Person | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | VERSV | Allow NULL? |
| 26 | BERUF | IS-H: Patient Occupation | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | BERUF | Allow NULL? |
| 27 | AGNUM | IS-H: Employer | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | NGPA | KH_ARBGEB | Allow NULL? |
| 28 | AGNAM | Name of Insured Person's Employer | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | VERAGNA | Allow NULL? |
| 29 | AGLAN | Country of Insured Person's Employer | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | VERAGLA | Allow NULL? |
| 30 | AGPLZ | Postal Code of Insured Person's Employer | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | VERAGPLZ | Allow NULL? |
| 31 | AGORT | IS-H: City of Insured's Employer | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | VERAGORT | Allow NULL? |
| 32 | AGSTR | IS-H: Street and Number of Insured's Employer | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | VERAGSTR | Allow NULL? |
| 33 | AGTEL | IS-H: Telephone Number of Business Partner | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | TELEFON_GP | Allow NULL? |
| 34 | SZDEB | IS-H: Customer Number of Self-Payer in Financial Accounting | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | KNA1 | SZ_DEBNR | Allow NULL? |
| 35 | KZTXT | IS-H: Comment on Patient-Related Insurance Relationship | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | TEXT_VVP | Allow NULL? |
| 36 | LGTXT | Indicator that Long Text Exists | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_LGTXT | Allow NULL? |
| 37 | ERDAT | IS-H: Date when Record Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_ERDAT | Allow NULL? |
| 38 | ERUSR | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_ERNAM | Allow NULL? |
| 39 | UPDAT | IS-H: Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_UPDAT | Allow NULL? |
| 40 | UPUSR | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_UPNAM | Allow NULL? |
| 41 | STORN | IS-H: Cancellation Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_STORN | Allow NULL? |
| 42 | STUSR | IS-H: Name of User who Canceled Data Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | STORN_USER | Allow NULL? |
| 43 | STDAT | Date of Cancellation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | STORN_DAT | Allow NULL? |
| 44 | ABREE | Indicator Whether Alternative Invoice Recipient Exists | char | 1 | 0 | CHAR | (N' ') | Yes | | ABWREMPF | Allow NULL? |
| 45 | VKVST | Healthcare Smart Card - Status of Insured Person | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | ISH_VK_VST | Allow NULL? |
| 46 | VKVSE | IS-H: Healthcare Smart Card - Health Ins. Status Supplement | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ISH_VK_VSE | Allow NULL? |
| 47 | VKNRA | IS-H: Healthcare Smart Card - Directory of Health Ins. No's | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | ISH_VK_VKN | Allow NULL? |
| 48 | RANGP | IS-H: Ranking Order of Patient-Rel. Insurance Relationship | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | ISH_RANGP | Allow NULL? |
| 49 | KVMAN | IS-H: Indicator that HCSC Data Entered Manually | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_KVMAN | Allow NULL? |
| 50 | VTRTY | IS-H: Insurance Contract Scheme | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | ISH_VTRTY | Allow NULL? |
| 51 | VKNUM | Healthcare Smart Card - Health Insurer Number | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | | ISH_VK_KNR | Allow NULL? |
| 52 | KVDAT | IS-H: Date Healthcare Smart Card Imported | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISH_KVDAT | Allow NULL? |
| 53 | VCEND | IS-H: Healthcare Smart Card - Validity | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISH_VK_END | Allow NULL? |
| 54 | VERVV | IS-H: Relationship to Main Insured | char | 1 | 0 | CHAR | (N' ') | Yes | TNVVA | N1HVD | Allow NULL? |
| 55 | ADNHV | IS-H: Address Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | NADR | ISH_ADRNR | Allow NULL? |
| 56 | ADOHV | IS-H: Address Object | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | ISH_ADROBJ | Allow NULL? |
| 57 | ADNAG | IS-H: Address Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | NADR | ISH_ADRNR | Allow NULL? |
| 58 | ADOAG | IS-H: Address Object | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | ISH_ADROBJ | Allow NULL? |
| 59 | VERGN | IS-H: Name at Birth of Person Insured | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | VERGN | Allow NULL? |
| 60 | VERSN | Tax Number 1 | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | STCD1 | Allow NULL? |
| 61 | VCODE | IS-H CA: Version Code for OHIP Health Number | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ISH_VERSIONCODE | Allow NULL? |
| 62 | XPRA | IS-H: Boolean Data Type for ON (= "X") and OFF (= " ") | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_ON_OFF | Allow NULL? |
