SAP ABAP Table VNEHC_INS (Update Structure NEHC_PAT)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ NPAS (Package) Application development patient accounting system
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ NPAS (Package) Application development patient accounting system
Basic Data
Table Category | INTTAB | Structure |
Structure | VNEHC_INS | Table Relationship Diagram |
Short Description | Update Structure NEHC_PAT |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | IS-H: Health Insurance Card (Insurance Data) | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | LNCRD | ISH_LNCARD | ISH_LNCARD | NUMC | 10 | 0 | Sequence Number of Health Insurance Card | ||
4 | LNCRD_INS | ISH_LNCARD_DET | NUMC | 5 | 0 | Sequential Details of Health Insurance Card | |||
5 | .INCLUDE | 0 | 0 | IS-H: Health Insurance Card (Insurance Data) Fields | |||||
6 | INSURANCE_NAME | BU_NAMEOR1 | BU_NAME | CHAR | 40 | 0 | Name 1 of organization | ||
7 | KOSTR_INSTN | INSTNR | INSTNR | CHAR | 10 | 0 | IS-H: Institute Indicator | ||
8 | KOSTR_LAND | LAND_GP | LAND1 | CHAR | 3 | 0 | IS-H: Country of Business Partner | * | |
9 | .INCLUDE | 0 | 0 | IS-H: Change Information NEHC Tables | |||||
10 | ERDAT | RI_ERDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date when Record Created | ||
11 | ERTIM | RI_ERTIM | UHRZT | TIMS | 6 | 0 | IS-H: Time Record Created | ||
12 | ERUSR | RI_ERNAM | USNAM | CHAR | 12 | 0 | IS-H: Name of Employee who Created Record | ||
13 | UPDAT | RI_UPDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date of Last Change | ||
14 | UPTIM | RI_UPTIM | UHRZT | TIMS | 6 | 0 | IS-H: Time of Last Change | ||
15 | UPUSR | RI_UPNAM | USNAM | CHAR | 12 | 0 | IS-H: Name of Person who Last Changed Data | ||
16 | STORN | RI_STORN | XFELD | CHAR | 1 | 0 | IS-H: Cancellation Indicator | ||
17 | COV_BEGDT | ISH_COV_BEGDT | ISH_COV_BEGDT | DATS | 8 | 0 | IS-H: Start Date of Coverage | ||
18 | COV_ENDDT | ISH_COV_ENDDT | ISH_COV_ENDDT | DATS | 8 | 0 | IS-H: End Date of Coverage | ||
19 | .INCLUDE | 0 | 0 | IS-H: spezielle EGK (Versicherungsdaten) Felder | |||||
20 | ABR_KOSTR_INSTN | INSTNR | INSTNR | CHAR | 10 | 0 | IS-H: Institute Indicator | ||
21 | EGK_CDM_AVSD | CHAR | 20 | 0 | |||||
22 | EGK_KOSTR_NAME | ISH_EGK_KOSTR_NAME | CHAR | 45 | 0 | EGK: Name der Institution / Organisation | |||
23 | EGK_ABR_KOSTR_NA | ISH_EGK_ABR_KOSTR_NAME | CHAR | 45 | 0 | EGK: Name der abrechnenden Institution / Organisation | |||
24 | EGK_RECHTSKREIS | ISH_EGK_RECHTSKREIS | ISH_EGK_RECHTSKREIS | CHAR | 1 | 0 | EGK: Rechtskreis | ||
25 | EGK_VERS_ART | ISH_EGK_VERS_ART | ISH_EGK_VERS_ART | CHAR | 1 | 0 | EGK: Versichertenart | ||
26 | EGK_VERS_STAT_RS | ISH_EGK_VERS_STAT_RSA | ISH_EGK_VERS_STAT_RSA | CHAR | 1 | 0 | EGK: Versichertenstatus RSA | ||
27 | EGK_KOSTENERST_A | ISH_EGK_KOSTENERST_AMB | ISH_EGK_KOSTENERST_AMB | CHAR | 1 | 0 | EGK: Kostenerstattung ambulant | ||
28 | EGK_KOSTENERST_S | ISH_EGK_KOSTENERST_STAT | ISH_EGK_KOSTENERST_STAT | CHAR | 1 | 0 | EGK: Kostenerstattung stationär | ||
29 | EGK_WOP | ISH_EGK_WOP | ISH_EGK_WOP | CHAR | 2 | 0 | EGK: Kennzeichen WOP | ||
30 | EGK_PKV_VERB_TAR | ISH_EGK_PKV_VERB_TAR | ISH_EGK_PKV_VERB_TAR | CHAR | 2 | 0 | EGK: PKV Verbandstarif | ||
31 | EGK_PKV_BEIH_BER | ISH_EGK_PKV_BEIH_BER | ISH_EGK_PKV_BEIH_BER | CHAR | 2 | 0 | EGK: PKV Beihilfeberechtigung | ||
32 | EGK_STAT_WLU | ISH_EGK_STAT_WLU | ISH_EGK_STAT_WLU | CHAR | 2 | 0 | EGK: PKV Stat.Wahlleistung Unterkunft | ||
33 | EGK_WLU_PROZ | ISH_EGK_WLU_PROZ | CHAR | 3 | 0 | EGK: PKV Prozentwert Wahleistung Unterkunft | |||
34 | EGK_HS_WLU | ISH_EGK_HS_WLU | CHAR | 6 | 0 | EGK: PKV Höchstsatz Wahlleistung Unterkunft | |||
35 | EGK_STAT_WLA | ISH_EGK_STAT_WLA | ISH_EGK_STAT_WLA | CHAR | 2 | 0 | EGK: PKV Stat.Wahlleistung Arzt | ||
36 | EGK_STAT_WLA_PRO | ISH_EGK_WLA_PROZ | CHAR | 3 | 0 | EGK: PKV Prozentwert Wahleistung Arzt | |||
37 | EGK_PKV_CLINICCA | ISH_EGK_PKV_CLINICCARD | ISH_EGK_PKV_CLINICCARD | CHAR | 1 | 0 | EGK: PKV Cliniccard-Verfahren | ||
38 | EGK_CDM_GVSD | CHAR | 20 | 0 | |||||
39 | EGK_ZUZA_STATUS | ISH_EGK_ZUZA_STATUS | ISH_EGK_ZUZA_STATUS | CHAR | 1 | 0 | EGK: Zuzahlungsstatus | ||
40 | EGK_ZUZA_STATU_B | ISH_EGK_ZUZA_STATUS_BIS | ISH_EGK_ZUZA_STATUS_BIS | DATS | 8 | 0 | EGK: Zuzahlungsstatus gültig bis | ||
41 | EGK_BES_PERS_GRU | ISH_EGK_BES_PERS_GRU | ISH_EGK_BES_PERS_GRU | CHAR | 2 | 0 | EGK: Besondere Personengruppe | ||
42 | EGK_DMP_KZ | ISH_EGK_DMP_KZ | ISH_EGK_DMP_KZ | CHAR | 2 | 0 | EGK: Teilnahme am Disease Managment Programm | ||
43 | EGK_EINL_DAT_MLG | ISH_EGK_EINL_DATUM_MLG | RI_DATUM | DATS | 8 | 0 | EGK: Datum, an dem Versichertenkarte mobil eingelesen wurde | ||
44 | EGK_VKZML | ISH_EGK_VKZML | CHAR | 30 | 0 | EGK: Versichertenkarte - Zulassungsnummer mobiles Lesegerät | |||
45 | .INCLUDE | 0 | 0 | Structure: EGK Versicherungsdaten LV Schweiz | |||||
46 | STCODE | INTCA | INTCA | CHAR | 2 | 0 | Country ISO code | ||
47 | INSTNR | ISH_EHIC_INSTNR | CHAR10 | CHAR | 10 | 0 | IS-H: EHIC - Institute Code of Responsible Insurance Carrier | ||
48 | ACNYM | ISH_EHIC_ACNYM | CHAR21 | CHAR | 21 | 0 | IS-H: EHIC - Acronym of Responsible Insurance Carrier | ||
49 | CARDNR | ISH_EHIC_CARDNR_CHAR | CHAR20 | CHAR | 20 | 0 | EHIC - Card Number (Alphanumeric) | ||
50 | PERSID | ISH_EHC_PERSID | CHAR | 20 | 0 | E111 Personal ID Number | |||
51 | CERTIF_BEGDT | ISH_CERTIF_BEGDT | RI_DATUM | DATS | 8 | 0 | IS-H: EHIC - Valid From | ||
52 | CERTIF_ENDDT | ISH_CERTIF_ENDDT | RI_DATUM | DATS | 8 | 0 | IS-H: EHIC - Validity End | ||
53 | KOSTR | KH_KOSTR | RI_KUNNR | CHAR | 10 | 0 | IS-H: Insurance Provider | * | |
54 | BAG | NWCH_EHC_BAG | NWCH_EHC_BAG | NUMC | 5 | 0 | BAG Nummer der Versicherung | ||
55 | EANR | ISH_EHC_EANR | CHAR013 | CHAR | 13 | 0 | Insurer's IAN | ||
56 | INSFORM | ISH_EHC_INSFORM | ISH_EHC_INSFORM | CHAR | 2 | 0 | Insurance Form | ||
57 | INSFORM_TEXT | ISH_EHC_INSFORM_TEXT | CHAR040 | CHAR | 40 | 0 | Description of Insurance Form | ||
58 | CANTON | ISH_EHC_CANTON | ISH_EHC_CANTON | CHAR | 2 | 0 | Canton | ||
59 | ACCIDENT | ISH_EHC_ACCIDENT | ISH_EHC_ACCIDENT | CHAR | 2 | 0 | Accident Coverage SIA | ||
60 | SERVDEF | ISH_EHC_SERVDEF | ISH_TRUE_FALSE | CHAR | 1 | 0 | Service Deferment | ||
61 | VVG_EXIST | ISH_EHC_VVG_EXIST | ISH_ON_OFF | CHAR | 1 | 0 | Supplementary Insurance Available Yes/No | ||
62 | BASEINS | ISH_EHC_BASEINS | ISH_EHC_BASEINS | CHAR | 2 | 0 | Basic Insurance | ||
63 | DESCRIPTION | ISH_EHC_DESCRIPTION | CHAR040 | CHAR | 40 | 0 | Kontaktstelle: Bezeichnung | ||
64 | PHONE | ISH_EHC_PHONE | NWCH_TELNR | CHAR | 30 | 0 | Kontaktstelle: Telefonnnummer | ||
65 | ISH_EHC_EMAIL | CHAR100 | CHAR | 100 | 0 | Kontaktemailadresse | |||
66 | NAME1 | ISH_EHC_NAME1 | CHAR040 | CHAR | 40 | 0 | Kontaktperson Name 1 | ||
67 | NAME2 | ISH_EHC_NAME2 | CHAR040 | CHAR | 40 | 0 | Kontaktperson Name 2 | ||
68 | INS_POST_CODE | AD_PSTCD1 | CHAR10 | CHAR | 10 | 0 | City postal code | ||
69 | INS_CITY | AD_CITY1 | TEXT40 | CHAR | 40 | 0 | City | ||
70 | INS_COUNTRY | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
71 | INS_STREET | AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
72 | INS_HOUSE_NUM | AD_HSNM1 | TEXT10 | CHAR | 10 | 0 | House Number | ||
73 | INS_STREET_SUPPL | AD_STRSPP1 | TEXT40 | CHAR | 40 | 0 | Street 2 | ||
74 | INS_LOCATION | ISH_EHC_LOCATION | CHAR040 | CHAR | 40 | 0 | Location | ||
75 | INS_PO_BOX | AD_POBX | CHAR10 | CHAR | 10 | 0 | PO Box | ||
76 | INS_PO_BOX_TEXT | ISH_EHC_PO_BOX_TEXT | CHAR015 | CHAR | 15 | 0 | PO Box Text | ||
77 | INS_POST_CODE3 | ISH_EHC_POST_CODE3 | CHAR015 | CHAR | 15 | 0 | Foreign Postal Code | ||
78 | MDELAY | ISH_EHC_MDELAY | ISH_TRUE_FALSE | CHAR | 1 | 0 | Unterbrechung Versicherung wegen Militär | ||
79 | MEDHORS | ISH_EHC_MEDHORS | ISH_EHC_MEDHORS | CHAR | 2 | 0 | Coverage for Unlisted Drug | ||
80 | UMEDHORS | ISH_EHC_UMEDHORS | ISH_EHC_UMEDHORS | CHAR | 2 | 0 | Accident Coverage for Unlisted Drugs | ||
81 | MEDKOMP | ISH_EHC_MEDKOMP | ISH_EHC_MEDKOMP | CHAR | 2 | 0 | Coverage for Drugs in Complementary Medicine | ||
82 | UMEDKOMP | ISH_EHC_UMEDKOMP | ISH_EHC_UMEDKOMP | CHAR | 2 | 0 | Accident Coverage for Drugs in Complementary Medicine | ||
83 | SPITABT | ISH_EHC_SPITABT | ISH_EHC_SPITABT | CHAR | 2 | 0 | Hospital Department | ||
84 | SPITMOD | ISH_EHC_SPITMOD | ISH_EHC_SPITMOD | CHAR | 2 | 0 | Hospital Model | ||
85 | USPITVERS | ISH_EHC_USPITVERS | ISH_EHC_USPITVERS | CHAR | 2 | 0 | Accident Coverage for Hospital Insurance | ||
86 | COVINT_DRUGS | ISH_EHC_COVINT_DRUGS | ISH_EHC_COVINT_DRUGS | CHAR | 1 | 0 | Deckungsunterbrechung bei Nichtbezahlung Medikam | ||
87 | COVINT_HOSP | ISH_EHC_COVINT_HOSP | ISH_EHC_COVINT_HOSP | CHAR | 1 | 0 | Deckungsunterbrechung bei Nichtbezahlung Spitalsk | ||
88 | DATEOFIMPORT | ISH_EHC_DATEOFIMPORT | DATS | DATS | 8 | 0 | Datum Import VeKA-Server | ||
89 | TIMEOFIMPORT | ISH_EHC_TIMEOFIMPORT | TIMES | TIMS | 6 | 0 | Zeit Import Daten VeKA-Server | ||
90 | REMARK_KVG | ISH_EHC_REMARK_KVG | ISH_ON_OFF | CHAR | 1 | 0 | Bemerkung für KVG vorhanden | ||
91 | REMARK_HOSP | ISH_EHC_REMARK_HOSP | ISH_ON_OFF | CHAR | 1 | 0 | Bemerkung für Hospital vorhanden | ||
92 | .INCLUDE | 0 | 0 | Structures for generating change document update programs | |||||
93 | KZ | CDCHNGIND | CDCHNGIND | CHAR | 1 | 0 | Change type (U, I, E, D) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | VNEHC_INS | MANDT | T000 | MANDT | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |