SAP ABAP Table RNPRQ_TRACRE (IS-H: BAdI ISH_API_PREREQUISITS - Create Transfer)

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_TRACRE	Table Relationship Diagram
Short Description	IS-H: BAdI ISH_API_PREREQUISITS - Create Transfer

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 BAPI Creation Structure Transfer 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	HEALED_DATE	☐	ISH_FPEDT	ISH_FPEDT	DATS	8	0	IS-H: Date of Wound Healing
25	HEALED_DATEX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
26	RESTRICTED	☐	SICHV	XFELD	CHAR	1	0	IS-H: Indicator for Restricted Patient
27	RESTRICTEDX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
28	BILL_BLOCK	☐	FSPER	ISH_FSPER	CHAR	1	0	IS-H: Billing Block for Case
29	BILL_BLOCKX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
30	STATSTC_BLOCK	☐	ISH_STASP	XFELD	CHAR	1	0	IS-H: Indicator for Admission Type "Statistics Block"
31	STATSTC_BLOCKX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
32	PPA_RELEV	☐	ISH_KV_KZ	XFELD	CHAR	1	0	IS-H: Relevant for Panel Physician Association Billing
33	PPA_RELEVX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
34	REC_ORDER	☐	ISH_EAUFN	AUFNR	CHAR	12	0	IS-HCO: Receiver (Order)	AUFK
35	REC_ORDERX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
36	PREVIOUS_DAYS	☐	VOR_GRVER	GRVER	NUMC	3	0	IS-H: Previous Days to Be Deducted from Max. Length of Stay
37	PREVIOUS_DAYSX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
38	CHILDREN	☐	ISH_CHILD	ISH_CHILD	CHAR	2	0	IS-H: Number of Children
39	CHILDRENX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
40	EMPLOYEE_TYPE	☐	ISH_EMTYPE	ISH_EMTYPE	CHAR	2	0	IS-H: Employee Type	TN15G
41	EMPLOYEE_TYPEX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
42	CANTON_TARIFF	☐	NCH_TARCDE	NCH_TARCDE	CHAR	3	0	IS-H CH: Canton Tariff	TNCH12
43	CANTON_TARIFFX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
44	CANTON_CONVTN	☐	NCH_AGREEMENT	NCH_AGREEMENT	CHAR	3	0	IS-H CH: Convention (Hospital <-> Canton)	TNCH13
45	CANTON_CONVTNX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
46	APPLSTATUS	☐	ISH_APSTATE	ISH_APSTATE	CHAR	2	0	IS-H: Application Status	TNC301SA
47	APPLSTATUSX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
48	SPECIALTY	☐	FACHRTY7	ISH_FACHR	CHAR	4	0	IS-H: Specialty for Organizational Unit	*
49	SPECIALTYX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
50	MOVEMNT_TYPE	☐	RI_BWART	RI_BWART	CHAR	2	0	IS-H: Movement Type	TN14B
51	MOVEMNT_DATE	☐	BWIDT	RI_DATUM	DATS	8	0	IS-H: Date of Movement
52	MOVEMNT_TIME	☐	BWIZT	UHRZT	TIMS	6	0	IS-H: Time of Movement
53	STATUS_IND	☐	PLANB	ISH_PLAN	CHAR	1	0	IS-H: Planned Indicator for Date of Movement
54	PHONENO	☐	TELF_INT	TEXT16	CHAR	16	0	IS-H: Telephone Number of Patient in Institution
55	TV	☐	TVKZ	XFELD	CHAR	1	0	IS-H: TV Indicator
56	DEPARTMENT	☐	NZUWFA	ORGID	CHAR	8	0	IS-H: OU with Departmental Responsibility for Case	NORG
57	NURS_TREAT_OU	☐	NZUWPF	ORGID	CHAR	8	0	Organizational Unit Assigned to Case	NORG
58	ROOM	☐	ISH_ZIMMID	BAUID	CHAR	8	0	IS-H: Building ID of Room	NBAU
59	BED	☐	BETTID	BAUID	CHAR	8	0	IS-H: Building ID of Bed Location	NBAU
60	ROOM_STATUS_IND	☐	ISH_PLANR	ISH_PLAN	CHAR	1	0	IS-H: Planned Indicator for Room Assignment
61	TREATMCATEGORY	☐	BEKAT	BEHKATEG	CHAR	6	0	Treatment Category	TN24
62	CLASS	☐	ISH_PAYCL	ISH_PAYCL	CHAR	4	0	IS-H: Patient Class	TNP01
63	CREATION_DATE	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
64	CREATION_USER	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
65	DOC_TYPE	☐	ISH_PASSTY	ISH_PASSTY	CHAR	2	0	Type of Identification Document	TN17D
66	DOC_TYPEX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
67	DOC_NO	☐	ISH_PASSNR	ISH_PASSNR	CHAR	15	0	IS-H: Identification Document Number
68	DOC_NOX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
69	CHOICE_CL	☐	ISH_WKAT	ISH_WKAT	CHAR	1	0	IS-H: Choice of Ward Class	*
70	CHOICE_CLX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
71	PAT_WEIGHT	☐	ISH_PATGEW	ISH_GEWICH	QUAN	7	3	IS-H: Weight of Patient at Admission
72	PAT_WEIGHTX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
73	WEIGHT_UNIT	☐	ISH_EINGEW	MEINS	UNIT	3	0	IS-H: Unit of Measurement for Patient Weight	*
74	WEIGHT_UNIT_ISO	☐	ISH_EINGEW_ISO	ISOCD_UNIT	CHAR	3	0	IS-H: ISO Unit of Measurement for Patient Weight	*
75	WEIGHT_UNITX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
76	PAT_HEIGHT	☐	ISH_PATGRO	ISH_GROESS	QUAN	5	2	IS-H: Height of Patient at Admission
77	PAT_HEIGHTX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
78	HEIGHT_UNIT	☐	ISH_EINGRO	MEINS	UNIT	3	0	IS-H: Unit of Measurement for Patient Size	*
79	HEIGHT_UNIT_ISO	☐	ISH_EINGRO_ISO	ISOCD_UNIT	CHAR	3	0	IS-H: ISO Unit of Measurement for Patient Height (Size)	*
80	HEIGHT_UNITX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
81	SPECIALTY_TRANSFER	☐	FACHRTY5	ISH_FACHR	CHAR	4	0	IS-H: Physician Specialty	TNKFA
82	CREATION_TIME	☐	RI_ERTIM	UHRZT	TIMS	6	0	IS-H: Time Record Created
83	RESPIRATION	☐	ISH_RESPIRATION	NUM5	NUMC	5	0	IS-H: Duration of Mechanical Ventilation in Hours
84	RESPIRATIONX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
85	EXT_CASE_ID	☐	ISH_EXTNR_FAL	ISH_EXTNR_FAL	CHAR	20	0	IS-H: External Case Identification
86	EXT_CASE_IDX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
87	EXT_MOVEMENT_ID	☐	ISH_EXTNR_BEW	ISH_EXTNR_BEW	CHAR	20	0	IS-H: External Movement Identification
88	ATT_PHYS	☐	BARNR	RI_KUNNR	CHAR	10	0	IS-H: Personnel Number of Attending Physician	*
89	NOBILL_DAYS	☐	ISH_TOB		NUMC	3	0	IS-H: Days Without Calculation
90	NOBILL_DAYSX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
91	ATT_PHYS_LANR	☐	ISH_LANR_BA	ISH_LANR	CHAR	9	0	Lebenslange Arztnummer des behandelnden Arztes
92	MOVEMENT_TEXT	☐	ISH_T_TLINE		TTYP	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RNPRQ_TRACRE	APPLSTATUS	TNC301SA	APSTATE	KEY	1	CN
2	RNPRQ_TRACRE	BED	NBAU	BAUID		1	CN
3	RNPRQ_TRACRE	CANTON_CONVTN	TNCH13	AGREEMENT	KEY	1	CN
4	RNPRQ_TRACRE	CANTON_TARIFF	TNCH12	TARCDE	KEY	1	CN
5	RNPRQ_TRACRE	CASEENDTYPE	TN15D	ENDTYP	KEY	1	CN
6	RNPRQ_TRACRE	CASE_CATEGORY	TN15C	CASETY	KEY	1	CN
7	RNPRQ_TRACRE	CLASS	TNP01	CLASS	REF	1	CN
8	RNPRQ_TRACRE	DEPARTMENT	NORG	ORGID	REF	1	CN
9	RNPRQ_TRACRE	DOC_TYPE	TN17D	PASSTY	REF	1	CN
10	RNPRQ_TRACRE	EMPLOYEE_TYPE	TN15G	EMTYP	KEY	1	CN
11	RNPRQ_TRACRE	MOVEMNT_TYPE	TN14B	BWART	KEY	1	CN
12	RNPRQ_TRACRE	NURS_TREAT_OU	NORG	ORGID	REF	1	CN
13	RNPRQ_TRACRE	REC_ORDER	AUFK	AUFNR	KEY	1	CN
14	RNPRQ_TRACRE	ROOM	NBAU	BAUID	KEY	1	CN
15	RNPRQ_TRACRE	SPECIALTY_TRANSFER	TNKFA	FACHR	KEY	1	CN
16	RNPRQ_TRACRE	TREATMCATEGORY	TN24	BEKAT	KEY	1	CN

History

Last changed by/on	SAP	20110809
SAP Release Created in