SAP ABAP Table N1PRTMPPATLOC (IS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal)

Hierarchy

☛ IS-H (Software Component) SAP Healthcare
   ⤷ IS-HMED (Application Component) Clinical System
     ⤷ N1PR (Package) IS-H*MED: Patientenregister

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	N1PRTMPPATLOC	Table Relationship Diagram
Short Description	IS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	TLNRID	☑	N1PRTLNRID	N1PRTLNRID	CHAR	10	0	PATREG: Teilnehmer ID
3	PATNR	☑	N1PRPATID	N1PRPATID	CHAR	10	0	PATREG: Patienten ID
4	GSCHL	☐	GSCHL	GSCHL	CHAR	1	0	IS-H: Sex Indicator - Internal
5	GSCHLE	☐	GSCHLE	GSCHLE	CHAR	1	0	IS-H: Sex Indicator - User-Specific	*
6	GSCHLTXT	☐	TEXT_GES	TEXT10	CHAR	10	0	IS-H: Sex Specification - User-Specific
7	NNAME	☐	NNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient Last Name
8	NNAMS	☐	NNAMES_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Last Name
9	VNAME	☐	VNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient First Name
10	VNAMS	☐	VNAMES_PAT	CHAR30	CHAR	30	0	Standardized First Name
11	TITEL	☐	RI_TITEL	TITEL	CHAR	15	0	IS-H: Title	*
12	NAMZU	☐	RI_NAMZU	TITEL	CHAR	15	0	IS-H: Name Affix	*
13	VORSW	☐	RI_VORSW	TITEL	CHAR	15	0	IS-H: Name Prefix	*
14	NAME2	☐	NAME2_PAT	TEXT30	CHAR	30	0	Pseudonym, Order Name
15	GBDAT	☐	RI_GBDAT	RI_DATUM	DATS	8	0	IS-H: Birthdate
16	GBNAM	☐	GBNAM	TEXT30	CHAR	30	0	IS-H: Birthname
17	GBNAS	☐	GBNAMS_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Birthname
18	GLAND	☐	GLAND	LAND1	CHAR	3	0	IS-H: Country of Birth	*
19	GLANDTXT	☐	LANDX	TEXT15	CHAR	15	0	Country Name
20	TODKZ	☐	PAT_TOD	XFELD	CHAR	1	0	IS-H: Patient Is Deceased
21	TODDT	☐	TODDV	RI_DATUM	DATS	8	0	IS-H: Date of Death From
22	TODZT	☐	TODZV	UHRZT	TIMS	6	0	Time of Death From
23	TODDB	☐	TODDB	RI_DATUM	DATS	8	0	Date of Death To
24	TODZB	☐	TODZB	UHRZT	TIMS	6	0	IS-H: Time of Death To
25	TODUR	☐	TODUR	TODUR	CHAR	3	0	IS-H: Cause of Death	*
26	TODURTXT	☐	TUTXT	TEXT20	CHAR	20	0	IS-H: Cause of Death Text
27	ANRED	☐	RI_ANRDS	RI_ANRDS	CHAR	2	0	IS-H: Form-of-Address Key	*
28	ANREDTXT	☐	RI_ANTXT	TEXT25	CHAR	25	0	IS-H: Form-of-Address Text
29	FAMST	☐	RI_FAMST	RI_FAMST	CHAR	1	0	IS-H: Marital Status
30	FAMSTTXT	☐	FATXT	FATXT	CHAR	6	0	Marital Status
31	KONFE	☐	RI_KONFE	RI_KONFE	CHAR	2	0	IS-H: Religion
32	KONFETXT	☐	KNFTX	TEXT25	CHAR	25	0	Religious Denomination Long Text
33	NATIO	☐	RI_NATIO	LAND1	CHAR	3	0	IS-H: Nationality	*
34	NATIOTXT	☐	NATIO	TEXT15	CHAR	15	0	Nationality
35	SPRAS	☐	SPRAS_PAT	SPRAS	LANG	1	0	Patient Language	*
36	SPRASTXT	☐	SPTXT	SPTXT16	CHAR	16	0	Name of Language
37	LAND	☐	LAND_PAT	LAND1	CHAR	3	0	IS-H: Country of patient's place of residence	*
38	LANDTXT	☐	LANDX	TEXT15	CHAR	15	0	Country Name
39	PSTLZ	☐	PSTLZ_PAT	PSTLZ	CHAR	10	0	IS-H: Patient Postal Code
40	ORT	☐	ISH_CITY1	TEXT40	CHAR	40	0	IS-H: City
41	ORT2	☐	ISH_CITY2	TEXT40	CHAR	40	0	IS-H: District
42	STRAS	☐	ISH_STRASS	TEXT40	CHAR	40	0	IS-H: Street
43	BLAND	☐	ISH_REGION	REGIO	CHAR	3	0	IS-H: Region (Federal State, Province, County)	*
44	BLANDTXT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
45	GEBIE	☐	EINZGEBIET	EINZGEBIET	CHAR	9	0	IS-H: Geographical Area
46	TELF1	☐	ISH_TELNR	CHAR30	CHAR	30	0	IS-H: Telephone Number
47	SPEND	☐	SPENKZ	XFELD	CHAR	1	0	IS-H: Organ Donor Indicator
48	SPENT	☐	SPENTEXT	TEXT50	CHAR	50	0	Explanation for Donor Indicator
49	SPELT	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
50	VIPKZ	☐	VIPKZ	XFELD	CHAR	1	0	IS-H: VIP Indicator
51	STATU	☐	PAT_STATUS	PAT_STATUS	CHAR	1	0	Patient Status
52	EXTNR	☐	EXT_PATNR	EXT_PATNR	CHAR	20	0	IS-H: External Patient Identification
53	NOTAN	☐	NOTAUF	XFELD	CHAR	1	0	IS-H: Emergency Admission Indicator
54	KRZAN	☐	KURZAUF	XFELD	CHAR	1	0	IS-H: Quick Admission Indicator
55	RFPAT	☐	RFPAT	PATNR	CHAR	10	0	Reference to Patient Number in Merging
56	RFZIF	☐	PZIFF_PAT	PZIFF	CHAR	1	0	IS-H: Check Digit for Patient
57	BERUF	☐	BERUF	TEXT25	CHAR	25	0	IS-H: Patient Occupation
58	RVNUM	☐	ISH_RVNUM	ISH_SVNUM	CHAR	20	0	IS-H: Social Insurance Number
59	ANNA1	☐	NNAME_ANG	TEXT30	CHAR	30	0	IS-H: Last Name of Person to Be Contacted
60	ANVN1	☐	VNAME_ANG	TEXT30	CHAR	30	0	IS-H: First Name of Person to Be Contacted
61	ANLA1	☐	LAND_ANG	LAND1	CHAR	3	0	Country of the Person to Be Contacted	*
62	ANLA1TXT	☐	LANDX	TEXT15	CHAR	15	0	Country Name
63	ANPL1	☐	PSTLZ_ANG	PSTLZ	CHAR	10	0	IS-H: Postal Code
64	ANOR1	☐	ISH_CITY1	TEXT40	CHAR	40	0	IS-H: City
65	ANST1	☐	ISH_STRASS	TEXT40	CHAR	40	0	IS-H: Street
66	ANTE1	☐	ISH_TELNR	CHAR30	CHAR	30	0	IS-H: Telephone Number
67	ANVV1	☐	VERWVH	VERWVH	CHAR	1	0	IS-H: Relationship	*
68	ANVV1TXT	☐	TEXT_VER	TEXT15	CHAR	15	0	IS-H: Text for Relationship
69	KZTXT	☐	TEXT_PAT	TEXT50	CHAR	50	0	IS-H: Comment on Patient
70	BEGDT	☐	RI_BEGDT	RI_DATUM	DATS	8	0	IS-H: Valid-From Date of Record
71	ENDDT	☐	RI_ENDDT	RI_DATUM	DATS	8	0	IS-H: Valid-To Date of Record
72	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
73	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
74	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
75	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
76	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
77	STUSR	☐	STORN_USER	USNAM	CHAR	12	0	IS-H: Name of User who Canceled Data Record
78	STDAT	☐	STORN_DAT	RI_DATUM	DATS	8	0	Date of Cancellation
79	GBORT	☐	ISH_GBORT	TEXT25	CHAR	25	0	IS-H: Patient Birthplace
80	RACE	☐	ISH_RACE	ISH_RACE	CHAR	2	0	IS-H: Race	*
81	RACETXT	☐	ISH_RACETX	TEXT15	CHAR	15	0	IS-H: Race text
82	RESID	☐	ISH_RESID	XFELD	CHAR	1	0	IS-H: Indicator that Patient is Non-Resident
83	PASSTY	☐	ISH_PASSTY	ISH_PASSTY	CHAR	2	0	Type of Identification Document	*
84	PASSTYTXT	☐	ISH_PASSTX	TEXT15	CHAR	15	0	Text for Identification Document Type
85	PASSNR	☐	ISH_PASSNR	ISH_PASSNR	CHAR	15	0	IS-H: Identification Document Number
86	PZIFF	☐	PZIFF_PAT	PZIFF	CHAR	1	0	IS-H: Check Digit for Patient

History

Last changed by/on	SAP	20130529
SAP Release Created in