SAP ABAP Table N_PAT_PIX (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	N_PAT_PIX	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	NNAMS	☑	NNAMES_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Last Name
3	PATNR	☑	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number	NPAT
4	NNAME	☐	NNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient Last Name
5	CH_NAME	☐	CH_NAME	XFELD	CHAR	1	0	IS-H: Indicator for changed last name
6	VNAMS	☐	VNAMES_PAT	CHAR30	CHAR	30	0	Standardized First Name
7	PZIFF	☐	PZIFF_PAT	PZIFF	CHAR	1	0	IS-H: Check Digit for Patient
8	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution	TN01
9	GSCHL	☐	GSCHL	GSCHL	CHAR	1	0	IS-H: Sex Indicator - Internal
10	STANDNAM	☐	NNAMES_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Last Name
11	VNAME	☐	VNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient First Name
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	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	PSTLZ	☐	PSTLZ_PAT	PSTLZ	CHAR	10	0	IS-H: Patient Postal Code
18	ORT	☐	ORT01_PAT	TEXT25	CHAR	25	0	IS-H: City where Patient Resides
19	ORT2	☐	ORT02_PAT	TEXT25	CHAR	25	0	Patient District
20	STRAS	☐	STRAS_PAT	STRAS	CHAR	30	0	IS-H: Street and House Number of Patient
21	TELF1	☐	TELF_PAT	TEXT16	CHAR	16	0	IS-H: Patient Telephone Number
22	STATU	☐	PAT_STATUS	PAT_STATUS	CHAR	1	0	Patient Status
23	NOTAN	☐	NOTAUF	XFELD	CHAR	1	0	IS-H: Emergency Admission Indicator
24	KRZAN	☐	KURZAUF	XFELD	CHAR	1	0	IS-H: Quick Admission Indicator
25	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
26	TODKZ	☐	PAT_TOD	XFELD	CHAR	1	0	IS-H: Patient Is Deceased
27	LAND	☐	LAND_PAT	LAND1	CHAR	3	0	IS-H: Country of patient's place of residence	T005
28	NNAMP	☐	NNAME_PHON	CHAR30	CHAR	30	0	IS-H: Phonetic last name
29	EXTNR	☐	EXT_PATNR	EXT_PATNR	CHAR	20	0	IS-H: External Patient Identification
30	RVNUM	☐	ISH_RVNUM	ISH_SVNUM	CHAR	20	0	IS-H: Social Insurance Number
31	RFPAT	☐	RFPAT	PATNR	CHAR	10	0	Reference to Patient Number in Merging
32	ADRNR	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	NADR
33	ADROB	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
34	TITEL	☐	RI_TITEL	TITEL	CHAR	15	0	IS-H: Title
35	PASSTY	☐	ISH_PASSTY	ISH_PASSTY	CHAR	2	0	Type of Identification Document	TN17D
36	PASSNR	☐	ISH_PASSNR	ISH_PASSNR	CHAR	15	0	IS-H: Identification Document Number
37	RESID	☐	ISH_RESID	XFELD	CHAR	1	0	IS-H: Indicator that Patient is Non-Resident
38	ADRN2	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	NADR
39	ADRO2	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
40	VIPKZ	☐	VIPKZ	XFELD	CHAR	1	0	IS-H: VIP Indicator
41	INACT	☐	ISH_INACTIVE	XFELD	CHAR	1	0	'Inactive' Indicator
42	NAME2	☐	NAME2_PAT	TEXT30	CHAR	30	0	Pseudonym, Order Name
43	TODUR	☐	TODUR	TODUR	CHAR	3	0	IS-H: Cause of Death	TN18A
44	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	N_PAT_PIX	ADRN2	NADR	ADRNR	REF	1	C
2	N_PAT_PIX	ADRNR	NADR	ADRNR	REF	1	C
3	N_PAT_PIX	EINRI	TN01	EINRI	REF	1	CN
4	N_PAT_PIX	LAND	T005	LAND1	REF	1	CN
5	N_PAT_PIX	MANDT	T000	MANDT	KEY	1	CN
6	N_PAT_PIX	PASSTY	TN17D	PASSTY	REF	1	CN
7	N_PAT_PIX	PATNR	NPAT	PATNR	KEY	1	CN
8	N_PAT_PIX	TODUR	TN18A	TODUR	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in