SAP ABAP Table N1PRPAT (IS-H*MED: PATREG: Patientenstammdatentabelle)

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	N1PRPAT	Table Relationship Diagram
Short Description	IS-H*MED: PATREG: Patientenstammdatentabelle

Delivery and Maintenance

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

History

Last changed by/on	SAP	20130529
SAP Release Created in