SAP ABAP Table RNPRQ_VISCRE (IS-H: BAdI ISH_API_PREREQUISITS - Create Visit)

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

Table Category	INTTAB	Structure
Structure	RNPRQ_VISCRE	Table Relationship Diagram
Short Description	IS-H: BAdI ISH_API_PREREQUISITS - Create Visit

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 Create Structure for Outpatient Visit and Change Case
2	CASETYPE_EXT	☐	FALLARTE	FALLARTE	CHAR	1	0	IS-H: Case Type - User-Specific	*
3	CASETYPE_EXTX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
4	CASE_COMMENT	☐	TEXT_NFAL	RI_BEMERK	CHAR	30	0	IS-H: Comment on Case
5	CASE_COMMENTX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
6	CASE_CATEGORY	☐	ISH_CASETYPE	ISH_CASETYPE	CHAR	2	0	Case Category	TN15C
7	CASE_CATEGORYX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
8	FOREIGN_CASE	☐	ISH_FOREIG	XFELD	CHAR	1	0	IS-H: Foreign Case
9	FOREIGN_CASEX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
10	NON_RESIDENT	☐	ISH_RESID	XFELD	CHAR	1	0	IS-H: Indicator that Patient is Non-Resident
11	NON_RESIDENTX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
12	GEOGR_AREA	☐	EINZGEBIET	EINZGEBIET	CHAR	9	0	IS-H: Geographical Area
13	GEOGR_AREAX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
14	EMERG_ADM	☐	NOTAUF	XFELD	CHAR	1	0	IS-H: Emergency Admission Indicator
15	EMERG_ADMX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
16	QUICK_ADM	☐	KURZAUF	XFELD	CHAR	1	0	IS-H: Quick Admission Indicator
17	QUICK_ADMX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
18	START_DATE	☐	BEGDT_FAL	RI_DATUM	DATS	8	0	IS-H: Start Date of Case
19	START_DATEX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
20	END_DATE	☐	ENDDT_FAL	RI_DATUM	DATS	8	0	IS-H: End Date of Case
21	END_DATEX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
22	CASEENDTYPE	☐	ISH_CASEEND	ISH_CASEEND	CHAR	2	0	IS-H: Type of Case End	TN15D
23	CASEENDTYPEX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
24	WORK_INCAPACITY	☐	ARBUN	RI_DATUM	DATS	8	0	IS-H: Work Incapacity To-Date
25	WORK_INCAPACITYX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
26	BILL_BLOCK	☐	FSPER	ISH_FSPER	CHAR	1	0	IS-H: Billing Block for Case
27	BILL_BLOCKX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
28	STATSTC_BLOCK	☐	ISH_STASP	XFELD	CHAR	1	0	IS-H: Indicator for Admission Type "Statistics Block"
29	STATSTC_BLOCKX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
30	PPA_RELEV	☐	ISH_KV_KZ	XFELD	CHAR	1	0	IS-H: Relevant for Panel Physician Association Billing
31	PPA_RELEVX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
32	REC_ORDER	☐	ISH_EAUFN	AUFNR	CHAR	12	0	IS-HCO: Receiver (Order)	AUFK
33	REC_ORDERX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
34	CHILDREN	☐	ISH_CHILD	ISH_CHILD	CHAR	2	0	IS-H: Number of Children
35	CHILDRENX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
36	EMPLOYEE_TYPE	☐	ISH_EMTYPE	ISH_EMTYPE	CHAR	2	0	IS-H: Employee Type	TN15G
37	EMPLOYEE_TYPEX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
38	CANTON_TARIFF	☐	NCH_TARCDE	NCH_TARCDE	CHAR	3	0	IS-H CH: Canton Tariff	TNCH12
39	CANTON_TARIFFX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
40	CANTON_CONVTN	☐	NCH_AGREEMENT	NCH_AGREEMENT	CHAR	3	0	IS-H CH: Convention (Hospital <-> Canton)	TNCH13
41	CANTON_CONVTNX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
42	APPLSTATUS	☐	ISH_APSTATE	ISH_APSTATE	CHAR	2	0	IS-H: Application Status	TNC301SA
43	APPLSTATUSX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
44	SPECIALTY	☐	FACHRTY7	ISH_FACHR	CHAR	4	0	IS-H: Specialty for Organizational Unit	*
45	SPECIALTYX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
46	MOVEMNT_TYPE	☐	RI_BWART	RI_BWART	CHAR	2	0	IS-H: Movement Type	TN14B
47	MOVEMNT_DATE	☐	BWIDT	RI_DATUM	DATS	8	0	IS-H: Date of Movement
48	MOVEMNT_TIME	☐	BWIZT	UHRZT	TIMS	6	0	IS-H: Time of Movement
49	MOVEMNT_REAS1	☐	ISH_BWGR1	ISH_BGRUND	CHAR	2	0	Movement Reason - 1st and 2nd Positions	TN14G
50	MOVEMNT_REAS2	☐	ISH_BWGR2	ISH_BGRUND	CHAR	2	0	Movement Reason - 3rd and 4th Positions	TN14G
51	EXT_VISIT_STAT	☐	ISH_ABSTEX	ISH_ABSTEX	CHAR	2	0	IS-H: External Status of Outpatient Visit	TN14E
52	MOVEMNT_ENDDATE	☐	BWEDT	RI_DATUM	DATS	8	0	IS-H: Movement End Date, Start Date of Subsequent Movement
53	MOVEMNT_ENDTIME	☐	BWEZT	UHRZT	TIMS	6	0	IS-H: Movement End Time, Start Time of Subsequent Movement
54	EMERG_CASE	☐	RI_NOTKZ	XFELD	CHAR	1	0	IS-H: Emergency Case Indicator
55	ACCIDENT	☐	UNFART	UNFART	CHAR	3	0	IS-H: Accident Type	TN14C
56	ACCIDENT_NO	☐	UNFNR	UNFNR	CHAR	12	0	IS-H: File Number / Processing Number for Accident
57	ACCIDENT_LOC	☐	ORT01_UNF	TEXT25	CHAR	25	0	IS-H: Accident Location
58	ACCIDENT_TIME	☐	UNFZT	UHRZT	TIMS	6	0	IS-H: Time of Accident
59	ACCIDENT_DATE	☐	UNFDT	RI_DATUM	DATS	8	0	IS-H: Accident date
60	ACCIDENT_EMSTYP	☐	ISH_RESCTY	ISH_RESCTY	CHAR	4	0	IS-H: Emergency Services	TN14I
61	ACCIDENT_EMSVCE	☐	ISH_RETTNR	ISH_RETTNR	CHAR	15	0	IS-H: Number of the Emergency Service for Accident
62	ACCIDENT_3RDPTY	☐	N1FVS	XFELD	CHAR	1	0	IS-H: Third-Party Responsibility
63	LATEST_ADM	☐	AUFDT_LAST	RI_DATUM	DATS	8	0	IS-H: Latest Admission Date
64	SPECIALTY_VISIT	☐	FACHRTY5	ISH_FACHR	CHAR	4	0	IS-H: Physician Specialty	TNKFA
65	DEPARTMENT	☐	NZUWFA	ORGID	CHAR	8	0	IS-H: OU with Departmental Responsibility for Case	NORG
66	NURS_TREAT_OU	☐	NZUWPF	ORGID	CHAR	8	0	Organizational Unit Assigned to Case	NORG
67	ROOM	☐	ISH_ZIMMID	BAUID	CHAR	8	0	IS-H: Building ID of Room	NBAU
68	BED	☐	BETTID	BAUID	CHAR	8	0	IS-H: Building ID of Bed Location	NBAU
69	LENGTH_OF_STAY	☐	ISH_DAUER	NUMC5	NUMC	5	0	IS-H: Estimated Length of Stay or Treatment
70	REF_HOSPITAL	☐	EXTKH	RI_KUNNR	CHAR	10	0	IS-H: Identification of an External Hospital	NGPA
71	ADMITT_DEPT	☐	ORGAU	ORGID	CHAR	8	0	IS-H: Org. ID of Admitting Facility	NORG
72	TREATMCATEGORY	☐	BEKAT	BEHKATEG	CHAR	6	0	Treatment Category	TN24
73	CLASS	☐	ISH_PAYCL	ISH_PAYCL	CHAR	4	0	IS-H: Patient Class	TNP01
74	REF_PSTTRT_TYPE	☐	ISH_REFSRC	ISH_REFSRC	CHAR	2	0	IS-H: Referral, Postdischarge Treatment Type	TN14H
75	ARRIVAL_MODE	☐	ISH_ARRIVE	ISH_ARRIVE	CHAR	2	0	IS-H: Mode of Arrival	TN14K
76	WAITLIST_PRIO	☐	WLPRI	WLPRI	CHAR	2	0	IS-H: Priority for Preregistration/Waiting List Management	TN14P
77	WAITLIST_TYPE	☐	ISH_WLTYPE	CHAR6	CHAR	6	0	IS-H: Waiting List	TN42A
78	WAITLIST_STATUS	☐	ISH_WLSTATUS	CHAR2	CHAR	2	0	IS-H: Preregistration/Waiting List Status	TN42C
79	WAITLIST_HOSP	☐	ISH_WLHOSP	RI_KUNNR	CHAR	10	0	IS-H: Waiting List Postdischarge Hospital	NGPA
80	WAITLIST_INCLON	☐	ISH_WLADAT	DATUM	DATS	8	0	IS-H: Date when Patient Added to Waiting List
81	WAITLIST_DELDAT	☐	ISH_WLRDAT	DATUM	DATS	8	0	IS-H: Date when Movement Removed From Waiting List
82	WAITLIST_DELREAS	☐	ISH_WLRRSN	CHAR3	CHAR	3	0	IS-H: Reason for Removal from Waiting List	TN42B
83	CREATION_DATE	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
84	CREATION_USER	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
85	DOC_TYPE	☐	ISH_PASSTY	ISH_PASSTY	CHAR	2	0	Type of Identification Document	TN17D
86	DOC_TYPEX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
87	DOC_NO	☐	ISH_PASSNR	ISH_PASSNR	CHAR	15	0	IS-H: Identification Document Number
88	DOC_NOX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
89	CHOICE_CL	☐	ISH_WKAT	ISH_WKAT	CHAR	1	0	IS-H: Choice of Ward Class	*
90	CHOICE_CLX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
91	PAT_WEIGHT	☐	ISH_PATGEW	ISH_GEWICH	QUAN	7	3	IS-H: Weight of Patient at Admission
92	PAT_WEIGHTX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
93	WEIGHT_UNIT	☐	ISH_EINGEW	MEINS	UNIT	3	0	IS-H: Unit of Measurement for Patient Weight	*
94	WEIGHT_UNIT_ISO	☐	ISH_EINGEW_ISO	ISOCD_UNIT	CHAR	3	0	IS-H: ISO Unit of Measurement for Patient Weight	*
95	WEIGHT_UNITX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
96	PAT_HEIGHT	☐	ISH_PATGRO	ISH_GROESS	QUAN	5	2	IS-H: Height of Patient at Admission
97	PAT_HEIGHTX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
98	HEIGHT_UNIT	☐	ISH_EINGRO	MEINS	UNIT	3	0	IS-H: Unit of Measurement for Patient Size	*
99	HEIGHT_UNIT_ISO	☐	ISH_EINGRO_ISO	ISOCD_UNIT	CHAR	3	0	IS-H: ISO Unit of Measurement for Patient Height (Size)	*
100	HEIGHT_UNITX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
101	DOC_REF_FL	☐	ISH_DOCWKZ	XFELD	CHAR	1	0	IS-H: Named Referral Indicator
102	DOC_REF_FLX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
103	PAT_REF_FL	☐	ISH_PATWKZ	XFELD	CHAR	1	0	IS-H: Patient Requested Referral Indicator
104	PAT_REF_FLX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
105	TREAT_CODE	☐	ISH_BCODE	ISH_BCODE	CHAR	1	0	IS-H: Treatment Program	TN14M
106	CREATION_TIME	☐	RI_ERTIM	UHRZT	TIMS	6	0	IS-H: Time Record Created
107	RESPIRATION	☐	ISH_RESPIRATION	NUM5	NUMC	5	0	IS-H: Duration of Mechanical Ventilation in Hours
108	RESPIRATIONX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
109	EXT_CASE_ID	☐	ISH_EXTNR_FAL	ISH_EXTNR_FAL	CHAR	20	0	IS-H: External Case Identification
110	EXT_CASE_IDX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
111	EXT_MOVEMENT_ID	☐	ISH_EXTNR_BEW	ISH_EXTNR_BEW	CHAR	20	0	IS-H: External Movement Identification
112	REF_PHYS2	☐	UARNR	RI_KUNNR	CHAR	10	0	IS-H: Personnel Number of Referring Physician	*
113	FAM_PHYS	☐	HARNR	RI_KUNNR	CHAR	10	0	IS-H: Personnel Number of Family Physician	*
114	ATT_PHYS	☐	BARNR	RI_KUNNR	CHAR	10	0	IS-H: Personnel Number of Attending Physician	*
115	OP_PHYS	☐	OARNR	RI_KUNNR	CHAR	10	0	IS-H: Personnel Number of Operating Surgeon	*
116	ANAE_PHYS	☐	ISH_AARNR	RI_KUNNR	CHAR	10	0	IS-H: Pesonnel Number of Anesthetist	*
117	REF_PHYS_BSNR	☐	ISH_BSNR_EDOC	ISH_BSNR	CHAR	9	0	Betriebsstättennummer des ein-/überweisenden Arztes
118	REF_PHYS_LANR	☐	ISH_LANR_EDOC	ISH_LANR	CHAR	9	0	Lebenslange Arztnummer des ein-/überweisenden Arztes
119	ATT_PHYS_LANR	☐	ISH_LANR_BA	ISH_LANR	CHAR	9	0	Lebenslange Arztnummer des behandelnden Arztes
120	REF_HOSPITAL_NAME2	☐	ISH_EXTHOSP_NAME2_EHP_5	NAME	CHAR	35	0	This Field Is Not Supported Until IS-H 6.05 (EHP5)
121	REF_HOSPITAL_NAME3	☐	ISH_EXTHOSP_NAME3_EHP_5	NAME	CHAR	35	0	This Field Is Not Supported Until IS-H 6.05 (EHP5)
122	MENTAL_HEALTH_LEGAL_STATUS	☐	ISH_MHLS	ISH_MHLS	CHAR	1	0	Mental Health Legal Status
123	MENTAL_HEALTH_LEGAL_STATUSX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
124	POST_DIS_PHYS	☐	NARNR	RI_KUNNR	CHAR	10	0	IS-H: Number of Postdischarge Physician	*
125	P115_SFA_PHYS	☐	ISH_P115B_VA	RI_KUNNR	CHAR	10	0	Personalnummer kooperierender Vertragsarzt (§115b SGB V)	*
126	P115_SFA_PHYS_LANR	☐	ISH_LANR_P115B	ISH_LANR	CHAR	9	0	Lebenslange Arztnummer eines §115b SGB V Arztes
127	P115_SFA_PHYS_2	☐	ISH_P115B_VA_2	RI_KUNNR	CHAR	10	0	Personalnummer 2. kooperierender Vertragsarzt (§115b SGB V)	*
128	P115_SFA_PHYS_2_LANR	☐	ISH_LANR_P115B	ISH_LANR	CHAR	9	0	Lebenslange Arztnummer eines §115b SGB V Arztes
129	P115_EXT_PHYS	☐	ISH_P115B_BA	RI_KUNNR	CHAR	10	0	Personalnummer Belegarzt (§115b SGB V)	*
130	P115_EXT_PHYS_LANR	☐	ISH_LANR_P115B	ISH_LANR	CHAR	9	0	Lebenslange Arztnummer eines §115b SGB V Arztes
131	P115_EXT_PHYS_2	☐	ISH_P115B_BA_2	RI_KUNNR	CHAR	10	0	Personalnummer 2. Belegarzt (§115b SGB V)	*
132	P115_EXT_PHYS_2_LANR	☐	ISH_LANR_P115B	ISH_LANR	CHAR	9	0	Lebenslange Arztnummer eines §115b SGB V Arztes
133	PIR_CONSENT	☐	ISH_CONSENT	XFELD	CHAR	1	0	PKV P301: Einwilligung zur elektronischen Datenübertragung
134	PIR_CONSENTX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RNPRQ_VISCRE	ACCIDENT	TN14C	UNFAR	KEY	1	CN
2	RNPRQ_VISCRE	ACCIDENT_EMSTYP	TN14I	RESCTY	KEY	1	CN
3	RNPRQ_VISCRE	ADMITT_DEPT	NORG	ORGID	REF	1	CN
4	RNPRQ_VISCRE	APPLSTATUS	TNC301SA	APSTATE	KEY	1	CN
5	RNPRQ_VISCRE	ARRIVAL_MODE	TN14K	ARRIVE	KEY	1	CN
6	RNPRQ_VISCRE	BED	NBAU	BAUID		1	CN
7	RNPRQ_VISCRE	CANTON_CONVTN	TNCH13	AGREEMENT	KEY	1	CN
8	RNPRQ_VISCRE	CANTON_TARIFF	TNCH12	TARCDE	KEY	1	CN
9	RNPRQ_VISCRE	CASEENDTYPE	TN15D	ENDTYP	KEY	1	CN
10	RNPRQ_VISCRE	CASE_CATEGORY	TN15C	CASETY	KEY	1	CN
11	RNPRQ_VISCRE	CLASS	TNP01	CLASS	REF	1	CN
12	RNPRQ_VISCRE	DEPARTMENT	NORG	ORGID	REF	1	CN
13	RNPRQ_VISCRE	DOC_TYPE	TN17D	PASSTY	REF	1	CN
14	RNPRQ_VISCRE	EMPLOYEE_TYPE	TN15G	EMTYP	KEY	1	CN
15	RNPRQ_VISCRE	EXT_VISIT_STAT	TN14E	STATUS_EX	REF	1	CN
16	RNPRQ_VISCRE	MOVEMNT_REAS1	TN14G	GRUND	KEY	1	CN
17	RNPRQ_VISCRE	MOVEMNT_REAS2	TN14G	GRUND	KEY	1	CN
18	RNPRQ_VISCRE	MOVEMNT_TYPE	TN14B	BWART	KEY	1	CN
19	RNPRQ_VISCRE	NURS_TREAT_OU	NORG	ORGID	REF	1	CN
20	RNPRQ_VISCRE	REC_ORDER	AUFK	AUFNR	KEY	1	CN
21	RNPRQ_VISCRE	REF_HOSPITAL	NGPA	GPART	KEY	1	CN
22	RNPRQ_VISCRE	REF_PSTTRT_TYPE	TN14H	REFSRC	KEY	1	CN
23	RNPRQ_VISCRE	ROOM	NBAU	BAUID	KEY	1	CN
24	RNPRQ_VISCRE	SPECIALTY_VISIT	TNKFA	FACHR	KEY	1	CN
25	RNPRQ_VISCRE	TREATMCATEGORY	TN24	BEKAT	KEY	1	CN
26	RNPRQ_VISCRE	TREAT_CODE	TN14M	BCODE	REF	1	CN
27	RNPRQ_VISCRE	WAITLIST_DELREAS	TN42B	WLRRN	REF	1	CN
28	RNPRQ_VISCRE	WAITLIST_HOSP	NGPA	GPART	KEY	1	CN
29	RNPRQ_VISCRE	WAITLIST_PRIO	TN14P	WLPRI	KEY	1	CN
30	RNPRQ_VISCRE	WAITLIST_STATUS	TN42C	WLSTA	REF	1	CN
31	RNPRQ_VISCRE	WAITLIST_TYPE	TN42A	WLTYP	REF	1	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in