SAP ABAP Table NEHC_INS (IS-H: Health Insurance Card (Insurance Data))

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	NEHC_INS	Table Relationship Diagram
Short Description	IS-H: Health Insurance Card (Insurance Data)

Delivery and Maintenance

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	NEHC_INS	MANDT	T000	MANDT	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in