SAP ABAP Table RNEHC (IS-H Screen Structure for General Health Ins. Card)

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	INTTAB	Structure
Structure	RNEHC	Table Relationship Diagram
Short Description	IS-H Screen Structure for General Health Ins. Card

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	Health Insurance Card EHC
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	LNCRD	☐	ISH_LNCARD	ISH_LNCARD	NUMC	10	0	Sequence Number of Health Insurance Card
4	CRDTYPE	☐	ISH_CRDTYPE	ISH_CRDTYPE	CHAR	10	0	Card Category EHC
5	EXT_KEY1	☐			CHAR	20	0
6	EXT_KEY2	☐			CHAR	20	0
7	PATNR	☐	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number
8	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
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	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
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	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
15	.INCLUDE	☐				0	0	Structure: EGK Kartendaten LV Schweiz
16	DOCTYPE	☐	ISH_EHC_DOCTYPE	ISH_EHC_DOCTYPE	CHAR	2	0	IS-H: EHIC Health Insurance Card - Document Category
17	MANUAL	☐	ISH_MANUAL	ISH_MANUAL	CHAR	1	0	IS-H: Manual Entry of Card Data
18	READ_DATE	☐	ISH_READ_DATE	ISH_READ_DATE	DATS	8	0	IS-H: Last Date Card Read
19	ONLINQOK	☐	ISH_EHC_ONLINQOK	ISH_ON_OFF	CHAR	1	0	Online Query Allowed
20	BEGDT	☐	ISH_EHC_BEGDT	DATS	DATS	8	0	Card Valid From
21	ENDDT	☐	ISH_EHC_ENDDT	DATS	DATS	8	0	Card Valid To
22	CARDVALID	☐	ISH_EHC_CARDVALID	ISH_ON_OFF	CHAR	1	0	Indicates Whether Card Is Valid
23	CVUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
24	CVDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
25	CVTIM	☐	RI_UPTIM	UHRZT	TIMS	6	0	IS-H: Time of Last Change
26	.INCLUDE	☐				0	0	Include NEHC für DE_EGK
27	EF_VERSION	☐	ISH_EGK_EF_VERSION	ISH_EGK_EF_VERSION	CHAR	40	0	Versionsdaten der EGK
28	LNCRD_PAT	☐	ISH_LNCARD_DET		NUMC	5	0	Sequential Details of Health Insurance Card
29	.INCLUDE	☐				0	0	IS-H: Health Insurance Card (Patient Data) Fields
30	NAME_LAST	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
31	NAME_FIRST	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
32	BIRTHDT	☐	BU_BIRTHDT	DATUM	DATS	8	0	Date of Birth of Business Partner
33	GENDER	☐	GSCHL	GSCHL	CHAR	1	0	IS-H: Sex Indicator - Internal
34	EXPDT	☐	ISH_EHIC_EXPDT	RI_DATUM	DATS	8	0	IS-H: EHIC - Validity End
35	INSID	☐	ISH_VERS_NR		CHAR	10	0	DE: Eindeutige Versichertennummer (EGK)
36	AD_PREFIX_TXT	☐	AD_PREFIXT	TEXT20	CHAR	20	0	Name prefix
37	AD_TITLES_TXT	☐	AD_TITLEST	TEXT20	CHAR	20	0	Name supplement, e.g. noble title (written form)
38	AD_TITLE1_TXT	☐	AD_TITLE1T	TEXT20	CHAR	20	0	Academic Title: Written Form
39	POST_CODE2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
40	PO_BOX_LOC	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
41	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
42	PO_BOX_CTY	☐	AD_POBXCTY	LAND1	CHAR	3	0	PO box country	*
43	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
44	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
45	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
46	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
47	HOUSE_NUM	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
48	STREET_SUPPL	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
49	LNCRD_INS	☐	ISH_LNCARD_DET		NUMC	5	0	Sequential Details of Health Insurance Card
50	.INCLUDE	☐				0	0	IS-H: Health Insurance Card (Insurance Data) Fields
51	INSURANCE_NAME	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
52	KOSTR_INSTN	☐	INSTNR	INSTNR	CHAR	10	0	IS-H: Institute Indicator
53	KOSTR_LAND	☐	LAND_GP	LAND1	CHAR	3	0	IS-H: Country of Business Partner	*
54	COV_BEGDT	☐	ISH_COV_BEGDT	ISH_COV_BEGDT	DATS	8	0	IS-H: Start Date of Coverage
55	COV_ENDDT	☐	ISH_COV_ENDDT	ISH_COV_ENDDT	DATS	8	0	IS-H: End Date of Coverage
56	.INCLUDE	☐				0	0	Kartenfelder speziell für DE:EGK
57	EGK_CDM_PVSD	☐			CHAR	20	0
58	EGK_NAMEF	☐	ISH_EGK_NAMEF		CHAR	45	0	EGK: Vornamen
59	EGK_NAMEL	☐	ISH_EGK_NAMEL		CHAR	45	0	EGK: Nachname
60	EGK_GSCHL	☐	ISH_EGK_GSCHL	ISH_EGK_GSCHL	CHAR	1	0	IS-H: EGK Geschlechtskennzeichen
61	UNKNOWN_GBDAT	☐	ISH_UNKNOWN_GBDAT	ISH_UNKNOWN_GBDAT	CHAR	1	0	Geburtsdatum nicht genau bekannt
62	.INCLUDE	☐				0	0	IS-H: spezielle EGK (Versicherungsdaten) Felder
63	ABR_KOSTR_INSTN	☐	INSTNR	INSTNR	CHAR	10	0	IS-H: Institute Indicator
64	EGK_CDM_AVSD	☐			CHAR	20	0
65	EGK_KOSTR_NAME	☐	ISH_EGK_KOSTR_NAME		CHAR	45	0	EGK: Name der Institution / Organisation
66	EGK_ABR_KOSTR_NA	☐	ISH_EGK_ABR_KOSTR_NAME		CHAR	45	0	EGK: Name der abrechnenden Institution / Organisation
67	EGK_RECHTSKREIS	☐	ISH_EGK_RECHTSKREIS	ISH_EGK_RECHTSKREIS	CHAR	1	0	EGK: Rechtskreis
68	EGK_VERS_ART	☐	ISH_EGK_VERS_ART	ISH_EGK_VERS_ART	CHAR	1	0	EGK: Versichertenart
69	EGK_VERS_STAT_RS	☐	ISH_EGK_VERS_STAT_RSA	ISH_EGK_VERS_STAT_RSA	CHAR	1	0	EGK: Versichertenstatus RSA
70	EGK_KOSTENERST_A	☐	ISH_EGK_KOSTENERST_AMB	ISH_EGK_KOSTENERST_AMB	CHAR	1	0	EGK: Kostenerstattung ambulant
71	EGK_KOSTENERST_S	☐	ISH_EGK_KOSTENERST_STAT	ISH_EGK_KOSTENERST_STAT	CHAR	1	0	EGK: Kostenerstattung stationär
72	EGK_WOP	☐	ISH_EGK_WOP	ISH_EGK_WOP	CHAR	2	0	EGK: Kennzeichen WOP
73	EGK_PKV_VERB_TAR	☐	ISH_EGK_PKV_VERB_TAR	ISH_EGK_PKV_VERB_TAR	CHAR	2	0	EGK: PKV Verbandstarif
74	EGK_PKV_BEIH_BER	☐	ISH_EGK_PKV_BEIH_BER	ISH_EGK_PKV_BEIH_BER	CHAR	2	0	EGK: PKV Beihilfeberechtigung
75	EGK_STAT_WLU	☐	ISH_EGK_STAT_WLU	ISH_EGK_STAT_WLU	CHAR	2	0	EGK: PKV Stat.Wahlleistung Unterkunft
76	EGK_WLU_PROZ	☐	ISH_EGK_WLU_PROZ		CHAR	3	0	EGK: PKV Prozentwert Wahleistung Unterkunft
77	EGK_HS_WLU	☐	ISH_EGK_HS_WLU		CHAR	6	0	EGK: PKV Höchstsatz Wahlleistung Unterkunft
78	EGK_STAT_WLA	☐	ISH_EGK_STAT_WLA	ISH_EGK_STAT_WLA	CHAR	2	0	EGK: PKV Stat.Wahlleistung Arzt
79	EGK_STAT_WLA_PRO	☐	ISH_EGK_WLA_PROZ		CHAR	3	0	EGK: PKV Prozentwert Wahleistung Arzt
80	EGK_PKV_CLINICCA	☐	ISH_EGK_PKV_CLINICCARD	ISH_EGK_PKV_CLINICCARD	CHAR	1	0	EGK: PKV Cliniccard-Verfahren
81	EGK_CDM_GVSD	☐			CHAR	20	0
82	EGK_ZUZA_STATUS	☐	ISH_EGK_ZUZA_STATUS	ISH_EGK_ZUZA_STATUS	CHAR	1	0	EGK: Zuzahlungsstatus
83	EGK_ZUZA_STATU_B	☐	ISH_EGK_ZUZA_STATUS_BIS	ISH_EGK_ZUZA_STATUS_BIS	DATS	8	0	EGK: Zuzahlungsstatus gültig bis
84	EGK_BES_PERS_GRU	☐	ISH_EGK_BES_PERS_GRU	ISH_EGK_BES_PERS_GRU	CHAR	2	0	EGK: Besondere Personengruppe
85	EGK_DMP_KZ	☐	ISH_EGK_DMP_KZ	ISH_EGK_DMP_KZ	CHAR	2	0	EGK: Teilnahme am Disease Managment Programm
86	EGK_EINL_DAT_MLG	☐	ISH_EGK_EINL_DATUM_MLG	RI_DATUM	DATS	8	0	EGK: Datum, an dem Versichertenkarte mobil eingelesen wurde
87	EGK_VKZML	☐	ISH_EGK_VKZML		CHAR	30	0	EGK: Versichertenkarte - Zulassungsnummer mobiles Lesegerät
88	.INCLUDE	☐				0	0	Structure: EGK carte landes version Niederlande
89	BSNNR	☐	ISH_NL_BSNNR	ISH_LNCARD	NUMC	10	0	Burger service nummer BSN nummer
90	BSN_STAT	☐	ISH_NL_BSN_STATUS	ISH_NL_BSN_STATUS	CHAR	1	0	Burger service nummer BSN status
91	SOURCE	☐	ISH_NL_BSN_SOURCE	ISH_NL_BSN_SOURCE	CHAR	1	0	Burger service nummer BSN herkunft
92	CRDNR	☐	ISH_NL_CRDNR	ISH_NL_CRDNR	CHAR	10	0	Burger service nummer ausweis nummer
93	ID_STAT	☐	ISH_NL_ID_STATUS	ISH_NL_ID_STATUS	CHAR	1	0	Burger service nummer Ausweis status
94	ID_TYPE	☐	ISH_NL_ID_TYPE	ISH_PASSTY	CHAR	2	0	Burger service nummer ausweis art	TN17D
95	LAST_UPD	☐	ISH_NL_LAST_UPD	DATUM	DATS	8	0	Burger service nummer letzte äenderung
96	PERSON	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
97	.INCLUDE	☐				0	0	Structure: EGK Versicherungsdaten LV Schweiz
98	STCODE	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
99	INSTNR	☐	ISH_EHIC_INSTNR	CHAR10	CHAR	10	0	IS-H: EHIC - Institute Code of Responsible Insurance Carrier
100	ACNYM	☐	ISH_EHIC_ACNYM	CHAR21	CHAR	21	0	IS-H: EHIC - Acronym of Responsible Insurance Carrier
101	CARDNR	☐	ISH_EHIC_CARDNR_CHAR	CHAR20	CHAR	20	0	EHIC - Card Number (Alphanumeric)
102	PERSID	☐	ISH_EHC_PERSID		CHAR	20	0	E111 Personal ID Number
103	CERTIF_BEGDT	☐	ISH_CERTIF_BEGDT	RI_DATUM	DATS	8	0	IS-H: EHIC - Valid From
104	CERTIF_ENDDT	☐	ISH_CERTIF_ENDDT	RI_DATUM	DATS	8	0	IS-H: EHIC - Validity End
105	KOSTR	☐	KH_KOSTR	RI_KUNNR	CHAR	10	0	IS-H: Insurance Provider	*
106	BAG	☐	NWCH_EHC_BAG	NWCH_EHC_BAG	NUMC	5	0	BAG Nummer der Versicherung
107	EANR	☐	ISH_EHC_EANR	CHAR013	CHAR	13	0	Insurer's IAN
108	INSFORM	☐	ISH_EHC_INSFORM	ISH_EHC_INSFORM	CHAR	2	0	Insurance Form
109	INSFORM_TEXT	☐	ISH_EHC_INSFORM_TEXT	CHAR040	CHAR	40	0	Description of Insurance Form
110	CANTON	☐	ISH_EHC_CANTON	ISH_EHC_CANTON	CHAR	2	0	Canton
111	ACCIDENT	☐	ISH_EHC_ACCIDENT	ISH_EHC_ACCIDENT	CHAR	2	0	Accident Coverage SIA
112	SERVDEF	☐	ISH_EHC_SERVDEF	ISH_TRUE_FALSE	CHAR	1	0	Service Deferment
113	VVG_EXIST	☐	ISH_EHC_VVG_EXIST	ISH_ON_OFF	CHAR	1	0	Supplementary Insurance Available Yes/No
114	BASEINS	☐	ISH_EHC_BASEINS	ISH_EHC_BASEINS	CHAR	2	0	Basic Insurance
115	DESCRIPTION	☐	ISH_EHC_DESCRIPTION	CHAR040	CHAR	40	0	Kontaktstelle: Bezeichnung
116	PHONE	☐	ISH_EHC_PHONE	NWCH_TELNR	CHAR	30	0	Kontaktstelle: Telefonnnummer
117	EMAIL	☐	ISH_EHC_EMAIL	CHAR100	CHAR	100	0	Kontaktemailadresse
118	NAME1	☐	ISH_EHC_NAME1	CHAR040	CHAR	40	0	Kontaktperson Name 1
119	NAME2	☐	ISH_EHC_NAME2	CHAR040	CHAR	40	0	Kontaktperson Name 2
120	INS_POST_CODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
121	INS_CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
122	INS_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
123	INS_STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
124	INS_HOUSE_NUM	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
125	INS_STREET_SUPPL	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
126	INS_LOCATION	☐	ISH_EHC_LOCATION	CHAR040	CHAR	40	0	Location
127	INS_PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
128	INS_PO_BOX_TEXT	☐	ISH_EHC_PO_BOX_TEXT	CHAR015	CHAR	15	0	PO Box Text
129	INS_POST_CODE3	☐	ISH_EHC_POST_CODE3	CHAR015	CHAR	15	0	Foreign Postal Code
130	MDELAY	☐	ISH_EHC_MDELAY	ISH_TRUE_FALSE	CHAR	1	0	Unterbrechung Versicherung wegen Militär
131	MEDHORS	☐	ISH_EHC_MEDHORS	ISH_EHC_MEDHORS	CHAR	2	0	Coverage for Unlisted Drug
132	UMEDHORS	☐	ISH_EHC_UMEDHORS	ISH_EHC_UMEDHORS	CHAR	2	0	Accident Coverage for Unlisted Drugs
133	MEDKOMP	☐	ISH_EHC_MEDKOMP	ISH_EHC_MEDKOMP	CHAR	2	0	Coverage for Drugs in Complementary Medicine
134	UMEDKOMP	☐	ISH_EHC_UMEDKOMP	ISH_EHC_UMEDKOMP	CHAR	2	0	Accident Coverage for Drugs in Complementary Medicine
135	SPITABT	☐	ISH_EHC_SPITABT	ISH_EHC_SPITABT	CHAR	2	0	Hospital Department
136	SPITMOD	☐	ISH_EHC_SPITMOD	ISH_EHC_SPITMOD	CHAR	2	0	Hospital Model
137	USPITVERS	☐	ISH_EHC_USPITVERS	ISH_EHC_USPITVERS	CHAR	2	0	Accident Coverage for Hospital Insurance
138	COVINT_DRUGS	☐	ISH_EHC_COVINT_DRUGS	ISH_EHC_COVINT_DRUGS	CHAR	1	0	Deckungsunterbrechung bei Nichtbezahlung Medikam
139	COVINT_HOSP	☐	ISH_EHC_COVINT_HOSP	ISH_EHC_COVINT_HOSP	CHAR	1	0	Deckungsunterbrechung bei Nichtbezahlung Spitalsk
140	DATEOFIMPORT	☐	ISH_EHC_DATEOFIMPORT	DATS	DATS	8	0	Datum Import VeKA-Server
141	TIMEOFIMPORT	☐	ISH_EHC_TIMEOFIMPORT	TIMES	TIMS	6	0	Zeit Import Daten VeKA-Server
142	REMARK_KVG	☐	ISH_EHC_REMARK_KVG	ISH_ON_OFF	CHAR	1	0	Bemerkung für KVG vorhanden
143	REMARK_HOSP	☐	ISH_EHC_REMARK_HOSP	ISH_ON_OFF	CHAR	1	0	Bemerkung für Hospital vorhanden
144	.INCLUDE	☐				0	0	Structure: EGK Patientendaten LV Schweiz
145	RVNUM	☐	ISH_RVNUM	ISH_SVNUM	CHAR	20	0	IS-H: Social Insurance Number
146	PO_BOX_TEXT	☐	ISH_EHC_PO_BOX_TEXT	CHAR015	CHAR	15	0	PO Box Text
147	LOCATION	☐	ISH_EHC_LOCATION	CHAR040	CHAR	40	0	Location
148	POST_CODE3	☐	ISH_EHC_POST_CODE3	CHAR015	CHAR	15	0	Foreign Postal Code
149	VERSID	☐	ISH_EHC_VERSID	CHAR020	CHAR	20	0	Nummer des Patienten bei der Versicherung
150	.INCLUDE	☐				0	0	IS-H Dynpostruktur allg. Gesundheitskarte (Schweiz)
151	VVG_UPDKZ	☐	ISH_TRUE_FALSE	ISH_TRUE_FALSE	CHAR	1	0	IS-H: Boolean Data Type for TRUE (="1") and FALSE (="0")
152	CARDVALID_ICON	☐	ISH_EHC_CARDVALID_ICON	CHAR034	CHAR	34	0	Icon-Feld für Cardvalid
153	SERVDEFTXT	☐	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
154	COVINT_DRUGSTXT	☐	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
155	COVINT_HOSPTXT	☐	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
156	KVGPROD	☐	CHAR_02	CHAR02	CHAR	2	0	Character length 2
157	VVGPROD	☐	CHAR_02	CHAR02	CHAR	2	0	Character length 2
158	FROM_READER	☐	ISH_ON_OFF	ISH_ON_OFF	CHAR	1	0	IS-H: Boolscher Datentyp für ON (= 'X') und OFF (=' ')
159	INSREL_ASS	☐	ISH_CARD_INSREL_ASS	ISH_ON_OFF	CHAR	1	0	Card Assigned to Insurance Relationship
160	SAVE_VERSION	☐	ISH_ON_OFF	ISH_ON_OFF	CHAR	1	0	IS-H: Boolscher Datentyp für ON (= 'X') und OFF (=' ')
161	PO_BOX_CTYTXT	☐	LANDX	TEXT15	CHAR	15	0	Country Name
162	COUNTRYTXT	☐	LANDX	TEXT15	CHAR	15	0	Country Name
163	KOSTR_LANDTXT	☐	LANDX	TEXT15	CHAR	15	0	Country Name
164	GSCHLTXT	☐	DDTEXT	DDTEXT	CHAR	60	0	Explanatory short text

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RNEHC	ID_TYPE	TN17D	PASSTY

History

Last changed by/on	SAP	20131127
SAP Release Created in