| 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 | * | MANDT | Allow NULL? |
| 2 | EINRI | Institution | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | EINRI | Allow NULL? |
| 3 | FALNR | IS-H: Case Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | FALNR | Allow NULL? |
| 4 | LFDNR | IS-H: Sequence Number of Insurance Relationship | nvarchar | 3 | 0 | NUMC | (N'000') | No | | LFDVV | Allow NULL? |
| 5 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KH_KOSTR | Allow NULL? |
| 6 | PATKZ | IS-H: Indicator for Self-Payer Insurance Relationship | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_PATKZ | Allow NULL? |
| 7 | MGART | IS-H: Type of Insurance Coverage | char | 1 | 0 | CHAR | (N' ') | Yes | TN16M | MITART_VER | Allow NULL? |
| 8 | UNTGR | IS-H: Insurance Subgroup | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TN16C | UNTGR | 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 | RANGF | IS-H: Ranking Order of Case-Rel. Insurance Relationships | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | ISH_RANGF | Allow NULL? |
| 12 | VKVST | Healthcare Smart Card - Status of Insured Person | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | ISH_VK_VST | Allow NULL? |
| 13 | VKVSE | IS-H: Healthcare Smart Card - Health Ins. Status Supplement | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ISH_VK_VSE | Allow NULL? |
| 14 | VKNRA | IS-H: Healthcare Smart Card - Directory of Health Ins. No's | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | ISH_VK_VKN | Allow NULL? |
| 15 | VKNUM | Healthcare Smart Card - Health Insurer Number | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | | ISH_VK_KNR | Allow NULL? |
| 16 | KVDAT | IS-H: Date Healthcare Smart Card Imported | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISH_KVDAT | Allow NULL? |
| 17 | VKMAN | IS-H: Indicator that HCSC Data Entered Manually | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_KVMAN | Allow NULL? |
| 18 | VCEND | IS-H: Healthcare Smart Card - Validity | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISH_VK_END | Allow NULL? |
| 19 | PCARD | IS-H: HC smart card - private card indicator (CfP) | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_VK_PKV | Allow NULL? |
| 20 | VERNR | IS-H: Patient Health Insurance Number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | VERSNR | Allow NULL? |
| 21 | VERGE | IS-H: Sex of Person Insured | char | 1 | 0 | CHAR | (N' ') | Yes | | VERGE | Allow NULL? |
| 22 | VERNN | Last Name of Insured Person | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | VERNN | Allow NULL? |
| 23 | VERVN | First Name of Insured Person | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | VERVN | Allow NULL? |
| 24 | VERAN | IS-H: Form-of-Address Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TN17U | RI_ANRDS | Allow NULL? |
| 25 | VERTI | Title of Insured Person | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | T535N | VERTI | Allow NULL? |
| 26 | VERNZ | Name Affix of Insured Person | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | T535N | VERNZ | Allow NULL? |
| 27 | VERVW | Name Prefix of Insured Person | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | T535N | VERVW | Allow NULL? |
| 28 | VERGB | IS-H: Date of Birth of Person Insured | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VERGB | Allow NULL? |
| 29 | VERNA | IS-H: Nationality of Person | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | ISH_NATIO | Allow NULL? |
| 30 | VERSV | Social Insurance Number of Insured Person | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | VERSV | Allow NULL? |
| 31 | VERVV | IS-H: Relationship to Main Insured | char | 1 | 0 | CHAR | (N' ') | Yes | TNVVA | N1HVD | Allow NULL? |
| 32 | VERGN | IS-H: Name at Birth of Person Insured | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | VERGN | Allow NULL? |
| 33 | VERSN | Tax Number 1 | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | STCD1 | Allow NULL? |
| 34 | ADNHV | IS-H: Address Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ISH_ADRNR | Allow NULL? |
| 35 | ADOHV | IS-H: Address Object | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | ISH_ADROBJ | Allow NULL? |
| 36 | BERUF | IS-H: Patient Occupation | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | BERUF | Allow NULL? |
| 37 | AGNUM | IS-H: Employer | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | NGPA | KH_ARBGEB | Allow NULL? |
| 38 | AGNAM | Name of Insured Person's Employer | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | VERAGNA | Allow NULL? |
| 39 | ADNAG | IS-H: Address Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ISH_ADRNR | Allow NULL? |
| 40 | ADOAG | IS-H: Address Object | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | ISH_ADROBJ | Allow NULL? |
| 41 | SZDEB | IS-H: Customer Number of Self-Payer in Financial Accounting | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SZ_DEBNR | Allow NULL? |
| 42 | ABREE | Indicator Whether Alternative Invoice Recipient Exists | char | 1 | 0 | CHAR | (N' ') | Yes | | ABWREMPF | Allow NULL? |
| 43 | KZTXT | IS-H: Comment on Patient-Related Insurance Relationship | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | TEXT_VVP | Allow NULL? |
| 44 | LGTXT | Language Key | char | 1 | 0 | LANG | (N' ') | Yes | T002 | LANGU | Allow NULL? |
| 45 | ERDAT | IS-H: Date when Record Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_ERDAT | Allow NULL? |
| 46 | ERUSR | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_ERNAM | Allow NULL? |
| 47 | UPDAT | IS-H: Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_UPDAT | Allow NULL? |
| 48 | UPUSR | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_UPNAM | Allow NULL? |
| 49 | STORN | IS-H: Cancellation Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_STORN | Allow NULL? |
| 50 | STUSR | IS-H: Name of User who Canceled Data Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | STORN_USER | Allow NULL? |
| 51 | STDAT | Date of Cancellation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | STORN_DAT | Allow NULL? |
| 52 | VTRTY | IS-H: Insurance Contract Scheme | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TN16 | ISH_VTRTY | Allow NULL? |
| 53 | VSCOD | IS-H CA: Version Code for OHIP Health Number | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ISH_VERSIONCODE | Allow NULL? |
| 54 | ADRNR | IS-H: Number of Address in General Address Management | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ISH_CADRNR | Allow NULL? |
| 55 | CPDKT | IS-H: One-Time Account for Alternative Invoice Recipient | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ISH_CPDKTO | Allow NULL? |
| 56 | VKZML | IS-H: Health Insurance Card - Mobile Card Reader License No. | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ISH_VK_ZML | Allow NULL? |
| 57 | VAL_QUARTER | IS-H: Validity Quarter Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISH_VAL_QUARTER_BEGIN | Allow NULL? |
| 58 | VKTITEL | IS-H: Healthcare smart card - title | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | ISH_VK_TIT | Allow NULL? |
| 59 | VKVNAM | Healthcare Smart Card - First Name | nvarchar | 28 | 0 | CHAR | (N' ') | Yes | | ISH_VK_VNM | Allow NULL? |
| 60 | VKNZU | IS-H: Healthcare Smart Card - Name Affix | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | ISH_VK_NZU | Allow NULL? |
| 61 | VKNNAM | IS-H: Healthcare smart card - last name | nvarchar | 28 | 0 | CHAR | (N' ') | Yes | | ISH_VK_NAM | Allow NULL? |
| 62 | VKGBDAT | IS-H: Healthcare Smart Card - Date of Birth | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISH_VK_GBD | Allow NULL? |
| 63 | VKSTRAS | IS-H: Healthcare smart card - street | nvarchar | 28 | 0 | CHAR | (N' ') | Yes | | ISH_VK_STR | Allow NULL? |
| 64 | VKLAND | IS-H: Healthcare Smart Card - Country | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ISH_VK_LAN | Allow NULL? |
| 65 | VKPLZ | IS-H: Healthcare Smart Card - Postal Code | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | | ISH_VK_PLZ | Allow NULL? |
| 66 | VKORT | IS-H: Healthcare Smart Card - City | nvarchar | 23 | 0 | CHAR | (N' ') | Yes | | ISH_VK_ORT | Allow NULL? |
| 67 | LNCRD | Sequence Number of Health Insurance Card | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | ISH_LNCARD | Allow NULL? |
| 68 | LNCRD_PAT | Sequence Number of Details for Health Insurance Card | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | ISH_LNCARD_DET | Allow NULL? |
| 69 | LNCRD_INS | Sequence Number of Details for Health Insurance Card | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | ISH_LNCARD_DET | Allow NULL? |
| 70 | VKUNKNOWN_GBDAT | Healthcare Smart Card: Exact Birthdate Unknown | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_VK_UNKNOWN_GBDAT | Allow NULL? |
| 71 | VERNR_KVK | Insurance Number PPA Card | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ISH_VERNR_KVK | Allow NULL? |
| 72 | KNAME_KVK | IS-H: Healthcare Smart Card - Health Insurer Name | nvarchar | 28 | 0 | CHAR | (N' ') | Yes | | ISH_VK_KNM | Allow NULL? |
| 73 | EGK_BES_PERS_GRU | | nvarchar | 2 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 74 | EGK_DMP_KZ | | nvarchar | 2 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 75 | EGK_WOP | | nvarchar | 2 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 76 | /ISHFR/ELSASS | IS-H FR: Insurance Provider ALSACE | char | 1 | 0 | CHAR | (N' ') | Yes | | /ISHFR/ELSASS | Allow NULL? |
| 77 | /ISHFR/BAMO | IS-H FR: Case Can Be Billed to Social Insurance | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | /ISHFR/TNWFR_BAO | /ISHFR/ISH_BAMO_EXT | Allow NULL? |
| 78 | /ISHFR/IPCAT | IS-H FR: Special Coverage | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | /ISHFR/IPCAT | Allow NULL? |
| 79 | PFINV | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 80 | MCDKZ | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 81 | IV_AU_LOCK | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 82 | IV_AU_LDAT | IS-H: Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_UPDAT | Allow NULL? |
| 83 | IV_AU_LUSR | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_UPNAM | Allow NULL? |
| 84 | WAERS | IS-H: Currency in Case-Related Insurance Relationship | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS_VVH | Allow NULL? |
| 85 | AKTKZ | IS-H: Number of Case on File with Insurance Provider | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | RI_AKTKZ | Allow NULL? |
| 86 | KKFAL | IS-H: Case Number Used by Insurance Provider | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ISH_KKFAL | Allow NULL? |
| 87 | VBGDT | IS-H: Insurance coverage start date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISH_VBGDT | Allow NULL? |
| 88 | PFLZZ | IS-H: Copayment Obligation Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_ZZPFL | Allow NULL? |
| 89 | NZZGR | Reason for Copayment Waiver | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TN22A | GRKZZ | Allow NULL? |
| 90 | BTRZZ | IS-H: Amount of Copayment Request | decimal | 11 | 2 | CURR | ((0)) | Yes | | ISH_BTRZZ | |
| 91 | VTAGE | IS-H: Previous Days | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | ISH_VTAGE | Allow NULL? |
| 92 | VTDAT | IS-H: Date of Report on Paid Copayment Days | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISH_VTDAT | Allow NULL? |
| 93 | EXTTY | External Contract Scheme | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | ISH_EXTTY | Allow NULL? |
| 94 | TWKTR | IS-H: Indicator for Main Insurance Relationship | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_MAINI | Allow NULL? |
| 95 | APSTATE | IS-H: Application Status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TNC301SA | ISH_APSTATE | Allow NULL? |
| 96 | PAYAM | IS-H: Amount Covered (by Insurance Relationship) | decimal | 15 | 2 | CURR | ((0)) | Yes | | ISH_PAYAM | |
| 97 | KUAUS | IS-H CH: Disable Case-Related Insurance Verification | char | 1 | 0 | CHAR | (N' ') | Yes | | NWCH_KUAUS | Allow NULL? |
| 98 | TPPROC | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 99 | REPAP | IS-H: Invoice requested as printout | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_REPAP | Allow NULL? |
| 100 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | PATNR | Allow NULL? |
| 101 | RFLNR | IS-H: Reference to Sequence Number of Patient-Related IR | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | NPIR | ISH_REFLNR | Allow NULL? |
| 102 | KKFAL_NEW | Case Number at Insurance Provider (New) | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ISH_KKFAL_NEW | Allow NULL? |
| 103 | CONTRACT_IND | | nvarchar | 30 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 104 | LNCRD_E111 | Sequence Number of Details for Health Insurance Card | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | ISH_LNCARD_DET | Allow NULL? |
| 105 | KOUB_COPAYDAYS | P301 - Paid Copayment Days from Insurance Verification Rec. | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | ISH_301_KOUB_COPAYDAYS | Allow NULL? |
| 106 | KOUB_COPD_STAT | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 107 | COP_RECEIPT | Indicates Whether Patient Has Submitted Receipt | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_COP_RECEIPT | Allow NULL? |
| 108 | SUSPEND_CLAIM | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
