SAP ABAP View N_VPREREG_PROV (IS-H: Preregistration Recs for Patients with Prel.Mast.Data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ NPVS (Package) Application development patient management system

Basic Data

View Type	D	Database View
Database View	N_VPREREG_PROV
Short Description	IS-H: Preregistration Recs for Patients with Prel.Mast.Data
Root table	N1VKG	IS-H: Item of Clinical Order (Preregistration)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	N1VKG	N1VKG
2	NPAP

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	NPAP	MANDT	JL	EQ				0	0
2	N1VKG	MANDT	JR	EQ			AND	0	0
3	NPAP	PAPID	JL	EQ				0	0
4	N1VKG	PAPID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	N1VKG	MANDT		☐	MANDT	☐	Client
2	VKGID	N1VKG	VKGID		☐	N1VKGID	☐	IS-H: CORD/PREG: ID of an Order Item (Preregistration)
3	PRGNR	N1VKG	PRGNR		☐	NPRGNR	☐	IS-H: Preregistration Number
4	PRTID	N1VKG	PRTID		☐	NPRTID	☐	IS-H: Preregistration Type Identification
5	VKGST	N1VKG	WLSTA		☐	ISH_WLSTATUS	☐	IS-H: Preregistration/Waiting List Status
6	EINRI	N1VKG	EINRI		☐	EINRI	☐	IS-H: Institution
7	ORGFA	N1VKG	ORGFA		☐	N1VKGFA	☐	IS-H: Departmental Org. Unit in Preregistration
8	ORGID	N1VKG	ORGID		☐	N1PRGTROU	☐	Treatment Unit in Preregistration
9	ETRBY	N1VKG	ETRBY		☐	NPRGETRBY	☐	IS-H: Preregistration Initiated By
10	ETROE	N1VKG	ETROE		☐	N1ETROE	☐	Initiating Organizational Unit
11	ETRMA	N1VKG	ETRGP		☐	NPRGETRGP	☐	IS-H: Initiating Employee/Business Partner
12	PATNR	N1VKG	PATNR		☐	PATNR	☐	IS-H: Patient Number
13	EXTNR	NPAP	EXTNR		☐	EXT_PATNR	☐	IS-H: External Patient Identification
14	PAPID	N1VKG	PAPID		☐	ISH_PAPID	☐	IS-H: Provisional Patient Number
15	FALNR	N1VKG	FALNR		☐	FALNR	☐	IS-H: Case Number
16	NNAME	NPAP	NNAME		☐	NNAME_PAT	☐	IS-H: Patient Last Name
17	NNAMS	NPAP	NNAMS		☐	NNAMES_PAT	☐	IS-H: Standardized Last Name
18	VNAME	NPAP	VNAME		☐	VNAME_PAT	☐	IS-H: Patient First Name
19	VNAMS	NPAP	VNAMS		☐	VNAMES_PAT	☐	Standardized First Name
20	GBNAM	NPAP	GBNAM		☐	GBNAM	☐	IS-H: Birthname
21	GBNAMS	NPAP	GBNAS		☐	GBNAMS_PAT	☐	IS-H: Standardized Birthname
22	GBDAT	NPAP	GBDAT		☐	RI_GBDAT	☐	IS-H: Birthdate
23	GSCHL	NPAP	GSCHL		☐	GSCHL	☐	IS-H: Sex Indicator - Internal
24	TITEL	NPAP	TITEL		☐	RI_TITEL	☐	IS-H: Title
25	NAMZU	NPAP	NAMZU		☐	RI_NAMZU	☐	IS-H: Name Affix
26	VORSW	NPAP	VORSW		☐	RI_VORSW	☐	IS-H: Name Prefix
27	ADRNR	NPAP	ADRNR		☐	ISH_ADRNR	☐	IS-H: Address Number
28	ADROB	NPAP	ADROB		☐	ISH_ADROBJ	☐	IS-H: Address Object
29	KANAM	N1VKG	KANAM		☐	N1VKANAM	☐	IS-H: CORD/PREG: Short Anamnesis in Clinical Order
30	KALTX	N1VKG	KALTX		☐	RI_LGTXT	☐	Indicator that Long Text Exists
31	DITXT	N1VKG	DITXT		☐	N1VKDIA	☐	IS-H: Preregistration Diagnosis
32	DILTX	N1VKG	DILTX		☐	RI_LGTXT	☐	Indicator that Long Text Exists
33	EARNR	N1VKG	EARNR		☐	N1EARNR	☐	IS-H: Referring Physician
34	WUZPI	N1VKG	WUZPI		☐	N1ZPI_INT	☐	Time Interpretation - Internal Format
35	WUMNT	N1VKG	WUMNT		☐	N1WUMNT	☐	Desired Time (Month)
36	WUJHR	N1VKG	WUJHR		☐	N1WUJHR	☐	Desired Time (Year)
37	BMVKG	N1VKG	BMVKG		☐	N1BMVKG	☐	IS-H: Comment for Preregistration
38	BMLTX	N1VKG	BMLTX		☐	RI_LGTXT	☐	Indicator that Long Text Exists
39	WLPRI	N1VKG	WLPRI		☐	WLPRI	☐	IS-H: Priority for Preregistration/Waiting List Management
40	PVPAT	N1VKG	PVPAT		☐	N1PVPAT	☐	IS-H: Preregistered as Private Patient
41	WLTYP	N1VKG	WLTYP		☐	ISH_WLTYPE	☐	IS-H: Waiting List
42	WLRDT	N1VKG	WLRDT		☐	ISH_WLRDAT	☐	IS-H: Date when Movement Removed From Waiting List
43	WLRRN	N1VKG	WLRRN		☐	ISH_WLRRSN	☐	IS-H: Reason for Removal from Waiting List
44	WLHSP	N1VKG	WLHSP		☐	ISH_WLHOSP	☐	IS-H: Waiting List Postdischarge Hospital
45	WLADT	N1VKG	WLADT		☐	ISH_WLADAT	☐	IS-H: Date when Patient Added to Waiting List
46	ERDAT	N1VKG	ERDAT		☐	RI_ERDAT	☐	IS-H: Date when Record Created
47	ERUSR	N1VKG	ERUSR		☐	RI_ERNAM	☐	IS-H: Name of Employee who Created Record
48	UPDAT	N1VKG	UPDAT		☐	RI_UPDAT	☐	IS-H: Date of Last Change
49	UPUSR	N1VKG	UPUSR		☐	RI_UPNAM	☐	IS-H: Name of Person who Last Changed Data
50	FALAR	N1VKG	FALAR		☐	FALLART	☐	IS-H: Case Type
51	EXTKH	N1VKG	EXTKH		☐	N1EXTKH	☐	IS-H: Referring Hospital
52	UARNR	N1VKG	UARNR		☐	N1UARNR	☐	IS-H: Referring Physician (Outpatients)
53	HARNR	N1VKG	HARNR		☐	N1HARNR	☐	IS-H: Family Physician
54	BWART	N1VKG	BEWAR		☐	RI_BWART	☐	IS-H: Movement Type
55	BEKAT	N1VKG	BEKAT		☐	BEKAT	☐	Treatment Category
56	AUFDS	N1VKG	AUFDS		☐	AUFDT_LAST	☐	IS-H: Latest Admission Date
57	RFSRC	N1VKG	RFSRC		☐	ISH_REFSRC	☐	IS-H: Referral, Postdischarge Treatment Type
58	USER1	N1VKG	USER1		☐	ISH_PREGUSER1	☐	IS-H: User-Defined Field 1
59	USER2	N1VKG	USER2		☐	ISH_PREGUSER2	☐	IS-H: User-Defined Field 2
60	USER3	N1VKG	USER3		☐	ISH_PREGUSER3	☐	IS-H: User-Defined Field 3
61	USER4	N1VKG	USER4		☐	ISH_PREGUSER4	☐	IS-H: User-Defined Field 4
62	USER5	N1VKG	USER5		☐	ISH_PREGUSER5	☐	IS-H: User-Defined Field 5
63	USER6	N1VKG	USER6		☐	ISH_PREGUSER6	☐	IS-H: User-Defined Field 6
64	USER7	N1VKG	USER7		☐	ISH_PREGUSER7	☐	IS-H: User-Defined Field 7
65	STORN	N1VKG	STORN		☐	RI_STORN	☐	IS-H: Cancellation Indicator

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in	463B