SAP ABAP Table N1PDSPATM (IS-H*MED: Struktur Patientendaten der Mutter f. Perinat)

Hierarchy

☛ IS-H (Software Component) SAP Healthcare
   ⤷ IS-HMED (Application Component) Clinical System
     ⤷ N1PD (Package) IS-H*MED: Perinatal Documentation

Basic Data

Table Category	INTTAB	Structure
Structure	N1PDSPATM	Table Relationship Diagram
Short Description	IS-H*MED: Struktur Patientendaten der Mutter f. Perinat

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: Patient Master Data (General)
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	PATNR	☐	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number
4	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution	TN01
5	GSCHL	☐	GSCHL	GSCHL	CHAR	1	0	IS-H: Sex Indicator - Internal
6	NNAME	☐	NNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient Last Name
7	NNAMS	☐	NNAMES_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Last Name
8	VNAME	☐	VNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient First Name
9	VNAMS	☐	VNAMES_PAT	CHAR30	CHAR	30	0	Standardized First Name
10	TITEL	☐	RI_TITEL	TITEL	CHAR	15	0	IS-H: Title	*
11	NAMZU	☐	RI_NAMZU	TITEL	CHAR	15	0	IS-H: Name Affix	*
12	VORSW	☐	RI_VORSW	TITEL	CHAR	15	0	IS-H: Name Prefix	*
13	NAME2	☐	NAME2_PAT	TEXT30	CHAR	30	0	Pseudonym, Order Name
14	GBDAT	☐	RI_GBDAT	RI_DATUM	DATS	8	0	IS-H: Birthdate
15	GBNAM	☐	GBNAM	TEXT30	CHAR	30	0	IS-H: Birthname
16	GBNAS	☐	GBNAMS_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Birthname
17	GLAND	☐	GLAND	LAND1	CHAR	3	0	IS-H: Country of Birth	T005
18	TODKZ	☐	PAT_TOD	XFELD	CHAR	1	0	IS-H: Patient Is Deceased
19	TODDT	☐	TODDV	RI_DATUM	DATS	8	0	IS-H: Date of Death From
20	TODZT	☐	TODZV	UHRZT	TIMS	6	0	Time of Death From
21	TODDB	☐	TODDB	RI_DATUM	DATS	8	0	Date of Death To
22	TODZB	☐	TODZB	UHRZT	TIMS	6	0	IS-H: Time of Death To
23	TODUR	☐	TODUR	TODUR	CHAR	3	0	IS-H: Cause of Death	TN18A
24	ANRED	☐	RI_ANRDS	RI_ANRDS	CHAR	2	0	IS-H: Form-of-Address Key	*
25	FAMST	☐	RI_FAMST	RI_FAMST	CHAR	1	0	IS-H: Marital Status
26	KONFE	☐	RI_KONFE	RI_KONFE	CHAR	2	0	IS-H: Religion
27	NATIO	☐	RI_NATIO	LAND1	CHAR	3	0	IS-H: Nationality	T005
28	SPRAS	☐	SPRAS_PAT	SPRAS	LANG	1	0	Patient Language	T002
29	LAND	☐	LAND_PAT	LAND1	CHAR	3	0	IS-H: Country of patient's place of residence	T005
30	PSTLZ	☐	PSTLZ_PAT	PSTLZ	CHAR	10	0	IS-H: Patient Postal Code
31	ORT	☐	ORT01_PAT	TEXT25	CHAR	25	0	IS-H: City where Patient Resides
32	ORT2	☐	ORT02_PAT	TEXT25	CHAR	25	0	Patient District
33	STRAS	☐	STRAS_PAT	STRAS	CHAR	30	0	IS-H: Street and House Number of Patient
34	BLAND	☐	ISH_REGION	REGIO	CHAR	3	0	IS-H: Region (Federal State, Province, County)	T005S
35	GEBIE	☐	EINZGEBIET	EINZGEBIET	CHAR	9	0	IS-H: Geographical Area
36	TELF1	☐	TELF_PAT	TEXT16	CHAR	16	0	IS-H: Patient Telephone Number
37	SPEND	☐	SPENKZ	XFELD	CHAR	1	0	IS-H: Organ Donor Indicator
38	SPENT	☐	SPENTEXT	TEXT50	CHAR	50	0	Explanation for Donor Indicator
39	SPELT	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
40	VIPKZ	☐	VIPKZ	XFELD	CHAR	1	0	IS-H: VIP Indicator
41	ARCHV	☐	ARCHIV	XFELD	CHAR	1	0	IS-H: Archived Data Indicator
42	STATU	☐	PAT_STATUS	PAT_STATUS	CHAR	1	0	Patient Status
43	EXTNR	☐	EXT_PATNR	EXT_PATNR	CHAR	20	0	IS-H: External Patient Identification
44	NOTAN	☐	NOTAUF	XFELD	CHAR	1	0	IS-H: Emergency Admission Indicator
45	KRZAN	☐	KURZAUF	XFELD	CHAR	1	0	IS-H: Quick Admission Indicator
46	RFPAT	☐	RFPAT	PATNR	CHAR	10	0	Reference to Patient Number in Merging
47	RFZIF	☐	PZIFF_PAT	PZIFF	CHAR	1	0	IS-H: Check Digit for Patient
48	BERUF	☐	BERUF	TEXT25	CHAR	25	0	IS-H: Patient Occupation
49	AGNUM	☐	AGNUM_PAT	RI_KUNNR	CHAR	10	0	IS-H: Patient's Employer	NGPA
50	AGNAM	☐	AGNAM	TEXT30	CHAR	30	0	IS-H: Employer Name
51	AGLAN	☐	AGLAN	LAND1	CHAR	3	0	IS-H: Employer Country	T005
52	AGPLZ	☐	AGPLZ	PSTLZ	CHAR	10	0	IS-H: Employer Postal Code
53	AGORT	☐	AGORT	TEXT25	CHAR	25	0	IS-H: Employer City
54	AGSTR	☐	AGSTR	STRAS	CHAR	30	0	IS-H: Employer Street
55	AGTEL	☐	AGTEL	TEXT16	CHAR	16	0	IS-H: Employer Telephone Number
56	RVNUM	☐	ISH_RVNUM	ISH_SVNUM	CHAR	20	0	IS-H: Social Insurance Number
57	ANNA1	☐	NNAME_ANG	TEXT30	CHAR	30	0	IS-H: Last Name of Person to Be Contacted
58	ANVN1	☐	VNAME_ANG	TEXT30	CHAR	30	0	IS-H: First Name of Person to Be Contacted
59	ANLA1	☐	LAND_ANG	LAND1	CHAR	3	0	Country of the Person to Be Contacted	T005
60	ANPL1	☐	PSTLZ_ANG	PSTLZ	CHAR	10	0	IS-H: Postal Code
61	ANOR1	☐	ORT01_ANG	TEXT25	CHAR	25	0	IS-H: City where Person to Be Contacted Resides
62	ANST1	☐	STRAS_ANG	STRAS	CHAR	30	0	IS-H: Street and House Number of Person to Be Contacted
63	ANTE1	☐	TELF_ANG	TEXT16	CHAR	16	0	IS-H: Telephone Number of Person to Be Contacted
64	ANVV1	☐	VERWVH	VERWVH	CHAR	1	0	IS-H: Relationship	TN17B
65	VMKZ1	☐	VORMUND	XFELD	CHAR	1	0	IS-H: Legal Representative
66	ANNA2	☐	NNAME_ANG	TEXT30	CHAR	30	0	IS-H: Last Name of Person to Be Contacted
67	ANVN2	☐	VNAME_ANG	TEXT30	CHAR	30	0	IS-H: First Name of Person to Be Contacted
68	ANLA2	☐	LAND_ANG	LAND1	CHAR	3	0	Country of the Person to Be Contacted	T005
69	ANPL2	☐	PSTLZ_ANG	PSTLZ	CHAR	10	0	IS-H: Postal Code
70	ANOR2	☐	ORT01_ANG	TEXT25	CHAR	25	0	IS-H: City where Person to Be Contacted Resides
71	ANST2	☐	STRAS_ANG	STRAS	CHAR	30	0	IS-H: Street and House Number of Person to Be Contacted
72	ANTE2	☐	TELF_ANG	TEXT16	CHAR	16	0	IS-H: Telephone Number of Person to Be Contacted
73	ANVV2	☐	VERWVH	VERWVH	CHAR	1	0	IS-H: Relationship	TN17B
74	VMKZ2	☐	VORMUND	XFELD	CHAR	1	0	IS-H: Legal Representative
75	KZTXT	☐	TEXT_PAT	TEXT50	CHAR	50	0	IS-H: Comment on Patient
76	LGTXT	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
77	BEGDT	☐	RI_BEGDT	RI_DATUM	DATS	8	0	IS-H: Valid-From Date of Record
78	ENDDT	☐	RI_ENDDT	RI_DATUM	DATS	8	0	IS-H: Valid-To Date of Record
79	HISTK	☐	RI_HISTK	XFELD	CHAR	1	0	Indicator that History Records Are Available
80	RISKF	☐	ISH_RISIKO	XFELD	CHAR	1	0	IS-H: Risk Information Exists for the Patient
81	TESTP	☐	TESTP	XFELD	CHAR	1	0	Test Patient Status
82	PZIFF	☐	PZIFF_PAT	PZIFF	CHAR	1	0	IS-H: Check Digit for Patient
83	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
84	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
85	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
86	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
87	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
88	STUSR	☐	STORN_USER	USNAM	CHAR	12	0	IS-H: Name of User who Canceled Data Record
89	STDAT	☐	STORN_DAT	RI_DATUM	DATS	8	0	Date of Cancellation
90	GBORT	☐	ISH_GBORT	TEXT25	CHAR	25	0	IS-H: Patient Birthplace
91	HARNR	☐	HARNR	RI_KUNNR	CHAR	10	0	IS-H: Personnel Number of Family Physician	NGPA
92	EARNR	☐	EARNR	RI_KUNNR	CHAR	10	0	IS-H: Personnel Number of Referring Physician	NGPA
93	UARNR	☐	UARNR	RI_KUNNR	CHAR	10	0	IS-H: Personnel Number of Referring Physician	NGPA
94	RACE	☐	ISH_RACE	ISH_RACE	CHAR	2	0	IS-H: Race	TN17R
95	RESID	☐	ISH_RESID	XFELD	CHAR	1	0	IS-H: Indicator that Patient is Non-Resident
96	PASSTY	☐	ISH_PASSTY	ISH_PASSTY	CHAR	2	0	Type of Identification Document	TN17D
97	PASSNR	☐	ISH_PASSNR	ISH_PASSNR	CHAR	15	0	IS-H: Identification Document Number
98	ADRNR	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	NADR
99	ADROB	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
100	ADNAG	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	NADR
101	ADOAG	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
102	ADNN1	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	NADR
103	ADON1	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
104	ADNN2	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	NADR
105	ADON2	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
106	ANEX1	☐	EXTNR_ANG	EXT_PATNR	CHAR	20	0	IS-H: External Identification of Next of Kin/Assoc. Party
107	ANEX2	☐	EXTNR_ANG	EXT_PATNR	CHAR	20	0	IS-H: External Identification of Next of Kin/Assoc. Party
108	ADRN2	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	NADR
109	ADRO2	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
110	INACT	☐	ISH_INACTIVE	XFELD	CHAR	1	0	'Inactive' Indicator
111	USER1	☐	ISH_PATUSER1	ISH_PATUSER1	CHAR	20	0	IS-H: User-Defined Field 1
112	USER2	☐	ISH_PATUSER2	ISH_PATUSER2	CHAR	20	0	IS-H: User-Defined Field 2
113	USER3	☐	ISH_PATUSER3	ISH_PATUSER3	DATS	8	0	IS-H: User-Defined Field 3
114	USER4	☐	ISH_PATUSER4	ISH_PATUSER4	DATS	8	0	IS-H: User-Defined Field 4
115	USER5	☐	ISH_PATUSER5	ISH_PATUSER5	CHAR	50	0	IS-H: User-Defined Field 5
116	USER6	☐	ISH_PATUSER6	ISH_PATUSER6	CHAR	1	0	IS-H: User-Defined Field 6
117	EXTAUFG	☐	EXTAUFG	XFELD	CHAR	1	0	IS-H: Kennzeichen externer Auftraggeber
118	EXTAUFGA	☐	EXTAUFGA	EXTAUFGA	CHAR	2	0	IS-H: EA Externe Auftraggeberart	TNWCHEA16
119	EMPSC	☐	ISH_EMPDAT	RI_DATUM	DATS	8	0	IS-H: Employed Since
120	UNKNOWN_GBDAT	☐	ISH_UNKNOWN_GBDAT	ISH_UNKNOWN_GBDAT	CHAR	1	0	Geburtsdatum nicht genau bekannt
121	INSID	☐	ISH_VERS_NR		CHAR	10	0	DE: Eindeutige Versichertennummer (EGK)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	N1PDSPATM	ADNAG	NADR	ADRNR	REF	1	C
2	N1PDSPATM	ADNN1	NADR	ADRNR	REF	1	C
3	N1PDSPATM	ADNN2	NADR	ADRNR	REF	1	C
4	N1PDSPATM	ADRN2	NADR	ADRNR	REF	1	C
5	N1PDSPATM	ADRNR	NADR	ADRNR	REF	1	C
6	N1PDSPATM	AGLAN	T005	LAND1	REF	1	CN
7	N1PDSPATM	AGNUM	NGPA	GPART	REF	1	CN
8	N1PDSPATM	ANLA1	T005	LAND1	REF	1	CN
9	N1PDSPATM	ANLA2	T005	LAND1	REF	1	CN
10	N1PDSPATM	ANVV1	TN17B	VERVA	REF	1	CN
11	N1PDSPATM	ANVV2	TN17B	VERVA	REF	1	CN
12	N1PDSPATM	BLAND	T005S	BLAND	REF	1	CN
13	N1PDSPATM	EARNR	NGPA	GPART	REF	1	CN
14	N1PDSPATM	EINRI	TN01	EINRI	REF	1	CN
15	N1PDSPATM	EXTAUFGA	TNWCHEA16	EXTAUFGA	KEY	1	CN
16	N1PDSPATM	GLAND	T005	LAND1	REF	1	CN
17	N1PDSPATM	HARNR	NGPA	GPART	REF	1	CN
18	N1PDSPATM	LAND	T005	LAND1	REF	1	CN
19	N1PDSPATM	MANDT	T000	MANDT	KEY	1	CN
20	N1PDSPATM	NATIO	T005	LAND1	REF	1	CN
21	N1PDSPATM	PASSTY	TN17D	PASSTY	REF	1	CN
22	N1PDSPATM	RACE	TN17R	RACE	REF	1	CN
23	N1PDSPATM	SPRAS	T002	SPRAS	REF	1	CN
24	N1PDSPATM	TODUR	TN18A	TODUR	REF	1	CN
25	N1PDSPATM	UARNR	NGPA	GPART	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in