SAP ABAP Table NEHC_PAT (IS-H: Health Insurance Card (Patient 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_PAT	Table Relationship Diagram
Short Description	IS-H: Health Insurance Card (Patient 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_PAT	☑	ISH_LNCARD_DET		NUMC	5	0	Sequential Details of Health Insurance Card
4	.INCLUDE	☐				0	0	IS-H: Health Insurance Card (Patient Data) Fields
5	NAME_LAST	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
6	NAME_FIRST	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
7	BIRTHDT	☐	BU_BIRTHDT	DATUM	DATS	8	0	Date of Birth of Business Partner
8	GENDER	☐	GSCHL	GSCHL	CHAR	1	0	IS-H: Sex Indicator - Internal
9	EXPDT	☐	ISH_EHIC_EXPDT	RI_DATUM	DATS	8	0	IS-H: EHIC - Validity End
10	INSID	☐	ISH_VERS_NR		CHAR	10	0	DE: Eindeutige Versichertennummer (EGK)
11	AD_PREFIX_TXT	☐	AD_PREFIXT	TEXT20	CHAR	20	0	Name prefix
12	AD_TITLES_TXT	☐	AD_TITLEST	TEXT20	CHAR	20	0	Name supplement, e.g. noble title (written form)
13	AD_TITLE1_TXT	☐	AD_TITLE1T	TEXT20	CHAR	20	0	Academic Title: Written Form
14	POST_CODE2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
15	PO_BOX_LOC	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
16	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
17	PO_BOX_CTY	☐	AD_POBXCTY	LAND1	CHAR	3	0	PO box country	*
18	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
19	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
20	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
21	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
22	HOUSE_NUM	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
23	STREET_SUPPL	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
24	.INCLUDE	☐				0	0	IS-H: Change Information NEHC Tables
25	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
26	ERTIM	☐	RI_ERTIM	UHRZT	TIMS	6	0	IS-H: Time Record Created
27	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
28	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
29	UPTIM	☐	RI_UPTIM	UHRZT	TIMS	6	0	IS-H: Time of Last Change
30	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
31	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
32	.INCLUDE	☐				0	0	Kartenfelder speziell für DE:EGK
33	EGK_CDM_PVSD	☐			CHAR	20	0
34	EGK_NAMEF	☐	ISH_EGK_NAMEF		CHAR	45	0	EGK: Vornamen
35	EGK_NAMEL	☐	ISH_EGK_NAMEL		CHAR	45	0	EGK: Nachname
36	EGK_GSCHL	☐	ISH_EGK_GSCHL	ISH_EGK_GSCHL	CHAR	1	0	IS-H: EGK Geschlechtskennzeichen
37	UNKNOWN_GBDAT	☐	ISH_UNKNOWN_GBDAT	ISH_UNKNOWN_GBDAT	CHAR	1	0	Geburtsdatum nicht genau bekannt
38	.INCLUDE	☐				0	0	Structure: EGK carte landes version Niederlande
39	BSNNR	☐	ISH_NL_BSNNR	ISH_LNCARD	NUMC	10	0	Burger service nummer BSN nummer
40	BSN_STAT	☐	ISH_NL_BSN_STATUS	ISH_NL_BSN_STATUS	CHAR	1	0	Burger service nummer BSN status
41	SOURCE	☐	ISH_NL_BSN_SOURCE	ISH_NL_BSN_SOURCE	CHAR	1	0	Burger service nummer BSN herkunft
42	CRDNR	☐	ISH_NL_CRDNR	ISH_NL_CRDNR	CHAR	10	0	Burger service nummer ausweis nummer
43	ID_STAT	☐	ISH_NL_ID_STATUS	ISH_NL_ID_STATUS	CHAR	1	0	Burger service nummer Ausweis status
44	ID_TYPE	☐	ISH_NL_ID_TYPE	ISH_PASSTY	CHAR	2	0	Burger service nummer ausweis art	*
45	LAST_UPD	☐	ISH_NL_LAST_UPD	DATUM	DATS	8	0	Burger service nummer letzte äenderung
46	PERSON	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
47	.INCLUDE	☐				0	0	Structure: EGK Patientendaten LV Schweiz
48	RVNUM	☐	ISH_RVNUM	ISH_SVNUM	CHAR	20	0	IS-H: Social Insurance Number
49	PO_BOX_TEXT	☐	ISH_EHC_PO_BOX_TEXT	CHAR015	CHAR	15	0	PO Box Text
50	LOCATION	☐	ISH_EHC_LOCATION	CHAR040	CHAR	40	0	Location
51	POST_CODE3	☐	ISH_EHC_POST_CODE3	CHAR015	CHAR	15	0	Foreign Postal Code
52	VERSID	☐	ISH_EHC_VERSID	CHAR020	CHAR	20	0	Nummer des Patienten bei der Versicherung

Foreign Keys

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

History

Last changed by/on	SAP	20131127
SAP Release Created in