SAP ABAP Table RNWP_MEDCONTROL_LIST (IS-H: Medical Controlling for Care Unit Work Station)

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	RNWP_MEDCONTROL_LIST	Table Relationship Diagram
Short Description	IS-H: Medical Controlling for Care Unit Work Station

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: Medical Controlling - Patient / Movement Information
2	ZIMMERKB	☐	NZIKURZ	CHAR8	CHAR	8	0	IS-H: Room Identifier
3	BETTKB	☐	BEKURZ	CHAR8	CHAR	8	0	IS-H: Bed Identifier
4	PNAMEC	☐	ISH_PNAMEC	TEXT50	CHAR	50	0	IS-H: Compound Patient Name
5	PNAMEC1	☐	ISH_NAME_SEX_AGE	TEXT50	CHAR	50	0	IS-H: Output String 'Patient Name, Sex and Age'
6	GSCHLE	☐	GSCHLE	GSCHLE	CHAR	1	0	IS-H: Sex Indicator - User-Specific	*
7	AGEPAT	☐	ISH_AGE	ISH_AGE	INT2	5	0	IS-H: Patient Age
8	BEKAT	☐	BEKAT	BEHKATEG	CHAR	6	0	Treatment Category	*
9	PATGRP	☐	PGRKB	TEXT12	CHAR	12	0	IS-H: Short Text for Patient Group
10	PATNR	☐	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number
11	PZIFF	☐	PZIFF_PAT	PZIFF	CHAR	1	0	IS-H: Check Digit for Patient
12	FALNR	☐	FALNR	FALNR	CHAR	10	0	IS-H: Case Number	*
13	FZIFF	☐	PZIFF_FALL	PZIFF	CHAR	1	0	IS-H: Check Digit for Case
14	FALAR	☐	FALLART	FALLART	CHAR	1	0	IS-H: Case Type
15	FALARE	☐	FALLARTE	FALLARTE	CHAR	1	0	IS-H: Case Type - User-Specific	*
16	FATYP	☐	ISH_CASETYPE	ISH_CASETYPE	CHAR	2	0	Case Category	*
17	FATYPTXT	☐	ISH_CASETYPETXT	TEXT25	CHAR	25	0	IS-H: Text for Case Category
18	NNAME	☐	NNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient Last Name
19	VNAME	☐	VNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient First Name
20	NNAMS	☐	NNAMES_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Last Name
21	VNAMS	☐	VNAMES_PAT	CHAR30	CHAR	30	0	Standardized First Name
22	GBNAM	☐	GBNAM	TEXT30	CHAR	30	0	IS-H: Birthname
23	GBNAMS	☐	GBNAMS_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Birthname
24	GBDAT	☐	RI_GBDAT	RI_DATUM	DATS	8	0	IS-H: Birthdate
25	TELNR	☐	TELF_INT	TEXT16	CHAR	16	0	IS-H: Telephone Number of Patient in Institution
26	PRIVPAT	☐	ISH_PRIVP	CHAR1	CHAR	1	0	IS-H: Private Patient
27	INFKZ	☐	INFKZ	XFELD	CHAR	1	0	IS-H: Infectious Disease Indicator
28	RISKPAT	☐	ISH_RISIKO	XFELD	CHAR	1	0	IS-H: Risk Information Exists for the Patient
29	ABWPAT	☐	ISH_ABWKZ	XFELD	CHAR	1	0	IS-H: Indicator that Absences Exist for Case
30	BEGLPAT	☐	N1BEGLKZ	N1BEGLKZ	CHAR	1	0	IS-H: Companion Indicator for Care Unit List
31	PRIVP_ICON	☐	ISH_PRIVP_ICON	TEXT50	CHAR	50	0	IS-H: "Private Patient" Icon
32	INFKZ_ICON	☐	ISH_INFKZ_ICON	CHAR04	CHAR	4	0	IS-H: Icon 'Infectious Disease'
33	RISKP_ICON	☐	ISH_RISIKO_ICON	TEXT50	CHAR	50	0	IS-H: Icon 'Risk Information Exists for Patient'
34	ABWP_ICON	☐	ISH_ABWPAT_ICON	TEXT50	CHAR	50	0	IS-H: Icon 'Patient is Absent'
35	BEGLP_ICON	☐	ISH_BEGLKZ_ICON	TEXT50	CHAR	50	0	IS-H: Icon 'Companion'
36	LFDNR	☐	LFDBEW	LFDBEW	NUMC	5	0	IS-H: Sequence Number of Movement	*
37	DAUER	☐	ISH_DAUER	NUMC5	NUMC	5	0	IS-H: Estimated Length of Stay or Treatment
38	NOTAN	☐	NOTAUF	XFELD	CHAR	1	0	IS-H: Emergency Admission Indicator
39	NOTAN_ICON	☐	N1WPV007_NOTAUFNAHME	TEXT50	CHAR	50	0	IS-H: Outp. Clinic/Svce Fclty - Emergency Admission
40	KRZAN	☐	KURZAUF	XFELD	CHAR	1	0	IS-H: Quick Admission Indicator
41	ORGFA	☐	NZUWFA	ORGID	CHAR	8	0	IS-H: OU with Departmental Responsibility for Case	*
42	ORGFAKB	☐	ISH_PATOKF	TEXT12	CHAR	12	0	IS-H: Short Text for Patient's Current Dept. Org. Unit
43	ORGPF	☐	NZUWPF	ORGID	CHAR	8	0	Organizational Unit Assigned to Case	*
44	ORGPFKB	☐	ISH_PATOKP	TEXT12	CHAR	12	0	Short Text for Patient's Current Nursing Org. Unit
45	PLANB	☐	PLANB	ISH_PLAN	CHAR	1	0	IS-H: Planned Indicator for Date of Movement
46	BWIDT	☐	BWIDT	RI_DATUM	DATS	8	0	IS-H: Date of Movement
47	BWIZT	☐	BWIZT	UHRZT	TIMS	6	0	IS-H: Time of Movement
48	PLANE	☐	PLANE	ISH_PLAN	CHAR	1	0	IS-H: Planned Indicator for End Date of Movement
49	BWEDT	☐	BWEDT	RI_DATUM	DATS	8	0	IS-H: Movement End Date, Start Date of Subsequent Movement
50	BWEZT	☐	BWEZT	UHRZT	TIMS	6	0	IS-H: Movement End Time, Start Time of Subsequent Movement
51	PLANR	☐	ISH_PLANR	ISH_PLAN	CHAR	1	0	IS-H: Planned Indicator for Room Assignment
52	ZIMMR	☐	ISH_ZIMMID	BAUID	CHAR	8	0	IS-H: Building ID of Room	*
53	BETT	☐	BETTID	BAUID	CHAR	8	0	IS-H: Building ID of Bed Location	*
54	BLOCK_ICON	☐	ISH_BU_BLOCK_ICON	TEXT50	CHAR	50	0	IS-H: Icon 'Room/Bed is Blocked'
55	BLOCKB	☐	ISH_SPERRV	RI_DATUM	DATS	8	0	IS-H: Blocking Date from (Entry Block)
56	BLOCKE	☐	ISH_SPERRB	RI_DATUM	DATS	8	0	IS-H: Blocking Date To (Entry Block To)
57	BLOCKR	☐	SPERG	SPERG	CHAR	4	0	Blocking Reason	*
58	BLOCKRT	☐	SPERTXT	TEXT15	CHAR	15	0	Blocking Reason Text Building Unit
59	BEWTY	☐	BEWTY	BEWTY	CHAR	1	0	IS-H: Movement Category
60	BWART	☐	RI_BWART	RI_BWART	CHAR	2	0	IS-H: Movement Type	*
61	BWATX	☐	BEWARTXT	TEXT15	CHAR	15	0	IS-H: Text for Movement Type
62	BWGR1	☐	ISH_BWGR1	ISH_BGRUND	CHAR	2	0	Movement Reason - 1st and 2nd Positions	*
63	BWGR2	☐	ISH_BWGR2	ISH_BGRUND	CHAR	2	0	Movement Reason - 3rd and 4th Positions	*
64	BWGTX	☐	ISH_BGTXTL	TEXT30	CHAR	30	0	Long Text for Movement Reason
65	DRGCMPL_ICON	☐	ISH_DRGCMPL_ICON	TEXT50	CHAR	50	0	IS-H: "Possible Readmission Due to Complications" Icon
66	BEKTX	☐	BK_BKTXT	TEXT15	CHAR	15	0	IS-H: Short Text for Treatment Category
67	CLASS	☐	ISH_PAYCL	ISH_PAYCL	CHAR	4	0	IS-H: Patient Class
68	CLKTXT	☐	ISH_CKTXT	TEXT15	CHAR	15	0	IS-H: Short Text for Patient Class
69	KZTXT	☐	TEXT_BEW	TEXT50	CHAR	50	0	Comment on Case Movement
70	AUFDT_DAYS	☐	ISH_AUFDT_DAYS	NUMC4	NUMC	4	0	IS-H: Days Since Admission
71	GOS_ATTA_ICON	☐	ISH_GOS_CASE_ATTA_ICON	TEXT50	CHAR	50	0	IS-H: Icon "Attachments Exist for Case"
72	LABDOK_ICON	☐	N1LABDOKV_ICON	TEXT50	CHAR	50	0	Laboratory Document Exists (Icon)
73	CT	☐	LVC_T_DRDR		TTYP	0	0
74	CC	☐	LVC_T_SCOL		TTYP	0	0
75	READM	☐	ISH_READM	ISH_ON_OFF	CHAR	1	0	Indicator for Possible Readmission Case
76	NO_TC_ICON	☐	ISH_NO_TC_ICON	TEXT50	CHAR	50	0	Symbol 'Treatment Authorization Not Issued for Patient/Case'
77	.INCLUDE	☐				0	0	IS-H: Coding Analyses - Diagnosis Information
78	NO_EWDIA	☐	ISH_NO_EWDIA	XFELD	CHAR	1	0	IS-H: All Cases Without Referral Diagnosis
79	EWDIA_ICON	☐	ISH_NO_EINWD_ICON	TEXT50	CHAR	50	0	IS-H: "Referral Diagnosis Missing" Icon
80	NO_AFDIA	☐	ISH_NO_AFDIA	XFELD	CHAR	1	0	IS-H: All Cases Without Admission Diagnosis
81	AFDIA_ICON	☐	ISH_NO_AUFND_ICON	TEXT50	CHAR	50	0	IS-H: "Admission Diagnosis Missing" Icon
82	NO_AFDIAOU	☐	ISH_NO_AFDIAOU	XFELD	CHAR	1	0	IS-H: All Cases Without Admission Diagnosis in OU
83	AFDIAOU_ICON	☐	ISH_NO_AFDIAOU_ICON	TEXT50	CHAR	50	0	IS-H: "Admission Diagnosis Missing in OU" Icon
84	NO_ENDIA	☐	ISH_NO_ENDIA	XFELD	CHAR	1	0	IS-H: All Cases Without Discharge Diagnosis
85	ENDIA_ICON	☐	ISH_NO_ENTLD_ICON	TEXT50	CHAR	50	0	IS-H: "Discharge Diagnosis Missing" Icon
86	NO_ENDIAOU	☐	ISH_NO_ENDIAOU	XFELD	CHAR	1	0	IS-H: All Cases Without Discharge Diagnosis in OU
87	ENDIAOU_ICON	☐	ISH_NO_ENDIAOU_ICON	TEXT50	CHAR	50	0	IS-H: "Discharge Diagnosis Is Missing in OU" Indicator
88	OPDIA	☐	ISH_NO_OPERD	XFELD	CHAR	1	0	IS-H: All Cases Without Surgery Diagnosis
89	OPDIA_ICON	☐	ISH_NO_OPERD_ICON	TEXT50	CHAR	50	0	IS-H: "Surgery Diagnosis Missing" Icon
90	OPDIA_M_ICON	☐	ISH_NO_OPERD_M_ICON	TEXT50	CHAR	50	0	IS-H: Icon "Surgery Diagnosis Missing for Movement"
91	NO_FHDIA	☐	ISH_NO_FHDIA	XFELD	CHAR	1	0	IS-H: All Cases Without Department Main Diagnosis
92	FHDIA_ICON	☐	ISH_NO_FAHPD_ICON	TEXT50	CHAR	50	0	IS-H: "Department Main Diagnosis Missing" Icon
93	NO_FHDIAOU	☐	NO_FHDIAOU	XFELD	CHAR	1	0	IS-H: All Cases w/o Department Main Diagnosis for OU
94	FAHPDOU_ICON	☐	ISH_NO_FAHPDOU_ICON	TEXT50	CHAR	50	0	IS-H: "Department Main Diagnosis in OU Missing" Icon
95	NO_KHDIA	☐	ISH_NO_KHDIA	XFELD	CHAR	1	0	IS-H: All Cases Without Hospital Main Diagnosis
96	KHDIA_ICON	☐	ISH_NO_KHHPD_ICON	TEXT50	CHAR	50	0	IS-H: "Hospital Main Diagnosis Missing" Icon
97	HDIAZ	☐	ISH_KEZA_HDIAZ	ISH_KENNZAHL_KURZ_INT	INT4	10	0	IS-H: Key Figure Number of DRG Principal Diagnoses
98	NO_DRGDIA_ICON	☐	ISH_NO_DRGDIA_ICON	TEXT50	CHAR	50	0	IS-H: "DRG Principal Diagnosis Missing" Icon
99	UHDFZ	☐	ISH_KEZA_UHDFZ	ISH_KENNZAHL_KURZ_INT	INT4	10	0	IS-H: Key Figure Number of Non-Spec. DRG Principal Diagnoses
100	UHDFZ_ICON	☐	ISH_UHDFZ_ICON	TEXT50	CHAR	50	0	IS-H: "Non-Specific DRG Principal Diagnosis Exists" Icon
101	NO_KEYDIA	☐	ISH_FTDIA	XFELD	CHAR	1	0	IS-H: All Cases w/o Coding for User-Defined Diagn. Texts
102	NO_KEYDIA_ICON	☐	ISH_NO_KEYDIA_ICON	TEXT50	CHAR	50	0	IS-H: "Non-Coded Diagnosis Exists" Icon
103	DRGHDFA	☐	KZ_DRGHDFA	XFELD	CHAR	1	0	IS-H: "DRG Principal Diagnosis in Department" Indicator
104	DRG_DKAT	☐	ISH_DRG_DIAKAT	KATID	CHAR	2	0	IS-H: Diagnosis Catalog of DRG Diagnosis
105	DRG_DKEY	☐	ISH_DRG_DKEYP	DIAID	CHAR	30	0	IS-H: Diagnosis Code of a DRG Principal Diagnosis
106	DRG_DTEXT	☐	ISH_DIATXT_CONC	TEXT120	CHAR	120	0	IS-H: Concatenated Diagnosis Text from Diagnosis Catalog
107	DIAGWA	☐	N2_DIASI_REFA	N2_DIASI_REFA	CHAR	1	0	IS-H: Reference for Diagnostic Certainty for ICD-10 Diagn.
108	DIAGWV	☐	N2_DIASI_REFV	N2_DIASI_REFV	CHAR	1	0	IS-H: Reference for Diagnostic Certainty for ICD-10 Diagn.
109	DIAGWZ	☐	N2_DIASI_REFZ	N2_DIASI_REFZ	CHAR	1	0	IS-H: Reference for Diagnostic Certainty for ICD-10 Diagn.
110	EADKZ	☐	ISH_KEZA_EADKZ	ISH_KENNZAHL_KURZ_INT	INT4	10	0	IS-H: "Without Expected Number of Diagnoses" Indicator
111	DIAANZ_ICON	☐	ISH_DIAANZ_ICON	TEXT50	CHAR	50	0	IS-H: "Number of Diagnoses Below Comparison Value" Icon
112	DIAAGE_ICON	☐	ISH_DIAAGE_ICON	TEXT50	CHAR	50	0	IS-H: "No. of Diagnoses < Age/10" Icon
113	DIAAZ	☐	ISH_KEZA_DIAAZ	ISH_KENNZAHL_KURZ_INT	INT4	10	0	IS-H: Key Figure Number of Diagnoses
114	KDIAZ	☐	ISH_KEZA_KDIAZ	ISH_KENNZAHL_KURZ_INT	INT4	10	0	IS-H: Key Figure Number of Hospital Main Diagnoses
115	NDIAZ	☐	ISH_KEZA_NDIAZ	ISH_KENNZAHL_KURZ_INT	INT4	10	0	IS-H: Key Figure Number of DRG Secondary Diagnoses
116	UNDFZ	☐	ISH_KEZA_UNDFZ	ISH_KENNZAHL_KURZ_INT	INT4	10	0	IS-H: Key Figure No. of Non-Specific DRG Secondary Diagnoses
117	NO_DART	☐	NO_DIAGART	XFIELD	CHAR	1	0	IS-H: All Cases Without Restrictions on Diagnosis Type
118	NEUGB	☐	ISH_NGBDIA	XFELD	CHAR	1	0	IS-H: Include Diagnoses of Healthy Newborns
119	.INCLUDE	☐				0	0	IS-H: Medical Controlling - Information on Procedures
120	DRG_ICPMK	☐	ISH_DRG_ICPMK	TARID	CHAR	2	0	IS-H: Surgical Procedure Catalog of a DRG SP Code	*
121	DRG_ICPML	☐	ISH_DRG_ICPMLP	TARLS	CHAR	10	0	IS-H: ID of a DRG Principal Surgical Procedure Code	*
122	DRG_ICPMTEXT	☐	KTXTCONC	TEXT120	CHAR	120	0	IS-H: Service Short Text 120-Char. STXT1 + STXT2 + STXT3
123	FAICP	☐	KZ_FALLP	XFELD	CHAR	1	0	IS-H: 'Case-Related' Procedure Indicator
124	FAICP_ICON	☐	ISH_FALLP_ICON	TEXT50	CHAR	50	0	Is-H: "Case-Related Procedure" Icon
125	NO_OPDRG	☐	ISH_NO_OPDRG	XFELD	CHAR	1	0	IS-H: All Cases Without Surgical DRG
126	OPDRG_ICON	☐	ISH_NO_OPDRG_ICON	TEXT50	CHAR	50	0	IS-H: "Surgical DRG Missing" Icon
127	PROAZ	☐	ISH_KEZA_PROAZ	ISH_KENNZAHL_KURZ_INT	INT4	10	0	IS-H: Key Figure Number of Procedures
128	ICPM_ICON	☐	ISH_NO_ICPM_ICON	TEXT50	CHAR	50	0	IS-H: "Procedure Missing" Icon
129	ICPM_M_ICON	☐	ISH_NO_ICPM_M_ICON	TEXT50	CHAR	50	0	IS-H: Icon "Procedure Missing for Surgery Movement"
130	O5PKZ	☐	ISH_KEZA_O5PKZ	ISH_KENNZAHL_KURZ_INT	INT4	10	0	IS-H: Key Figure Surgery Mvmt w/o Existing "5-" Procedure
131	O5PKZ_ICON	☐	ISH_NO_O5PKZ_ICON	TEXT50	CHAR	50	0	IS-H: "Surgical Procedure Missing" Icon
132	UPRAZ	☐	ISH_KEZA_UPRAZ	ISH_KENNZAHL_KURZ_INT	INT4	10	0	IS-H: Key Figure Number of Non-Specific Procedures
133	YICPM_ICON	☐	ISH_YICPM_ICON	TEXT50	CHAR	50	0	IS-H: "Non-Specific Procedure" Icon
134	DRGHICP	☐	ISH_NO_DRGHICP	XFELD	CHAR	1	0	IS-H: All Cases Without DRG Principal Procedure
135	DRGICP_ICON	☐	ISH_NO_DRGICP_ICON	TEXT50	CHAR	50	0	IS-H: "DRG Principal Procedure Missing" Icon
136	ICPHC	☐	ISH_NO_ICPMHC	XFELD	CHAR	1	0	IS-H: All Cases Without Surgical Procedure Main Code
137	ICPMHC_ICON	☐	ISH_NO_ICPMHC_ICON	TEXT50	CHAR	50	0	IS-H: "Procedure Main Code Missing" Icon
138	OPBFZ	☐	ISH_KEZA_OPBFZ	ISH_KENNZAHL_KURZ_INT	INT4	10	0	IS-H: Key Figure Number of Surgery Movements
139	ICPMRESPI_ICON	☐	ISH_NO_ICPMRESPI_ICON	TEXT50	CHAR	50	0	IS-H: "Mechanical Ventilation Procedure Missing" Icon
140	.INCLUDE	☐				0	0	IS-H: Medical Controlling - DRG Information
141	DRGERR_ICON	☐	ISH_DRGERR_ICON	TEXT50	CHAR	50	0	IS-H: "Error DRG" Icon
142	DRGUPG_ICON	☐	ISH_DRGUPG_ICON	TEXT50	CHAR	50	0	IS-H: "DRG Higher Grouping" Icon
143	DRG_CODE	☐	ISH_DRG_CODE	TARLS	CHAR	10	0	IS-H: DRG Code	*
144	DRG_CODE_TXT	☐	ISH_DRG_CODE_TXT	TEXT120	CHAR	120	0	IS-H: Text for DRG Code
145	DRG_COMMENT	☐	ISH_DRG_COMMENT	TEXT50	CHAR	50	0	IS-H: Comment on DRG
146	DRG_CAT	☐	ISH_DRG_CAT	TARID	CHAR	2	0	IS-H: DRG Catalog Used for Coding	*
147	MDC_CODE	☐	ISH_MDC_CODE	DIAID	CHAR	30	0	IS-H: Code of Major Diagnostic Category (MDC)
148	MDC_CODE_TXT	☐	ISH_MDC_CODE_TXT	TEXT120	CHAR	120	0	IS-H: Text for MDC Code
149	MDC_CAT	☐	ISH_MDC_CAT	KATID	CHAR	2	0	IS-H: Catalog for Major Diagnostic Category (MDC)
150	PATGEW	☐	ISH_PATGEW	ISH_GEWICH	QUAN	7	3	IS-H: Weight of Patient at Admission
151	GWEIN	☐	ISH_EINGEW	MEINS	UNIT	3	0	IS-H: Unit of Measurement for Patient Weight	T006
152	PATGEW_ICON	☐	ISH_NO_PATGEW_ICON	TEXT50	CHAR	50	0	IS-H: "Patient Weight at Admission Missing" Icon
153	GBGEW	☐	GBGEW	ISH_GEWICH	QUAN	7	3	Birth Weight
154	GBGWEIN	☐	ISH_EINGEW	MEINS	UNIT	3	0	IS-H: Unit of Measurement for Patient Weight	*
155	GBGEW_ICON	☐	ISH_NO_GBGEW_ICON	TEXT50	CHAR	50	0	IS-H: "Weight at Birth Missing" Icon
156	RESPI	☐	ISH_RESPIRATION	NUM5	NUMC	5	0	IS-H: Duration of Mechanical Ventilation in Hours
157	RESPI_ICON	☐	ISH_NO_RESPI_ICON	TEXT50	CHAR	50	0	IS-H: "Mechanical Ventilation Duration Missing" Icon
158	FPEDT	☐	ISH_FPEDT	ISH_FPEDT	DATS	8	0	IS-H: Date of Wound Healing
159	ROM	☐	ISH_DRG_ROM	ISH_DRG_ROM_TYPE	CHAR	1	0	IS-H: Risk of Mortality (for DRG Purposes)	*
160	SOI	☐	ISH_DRG_SOI	ISH_DRG_SOI_TYPE	CHAR	1	0	IS-H: Severity of Illness (for DRG Purposes)	*
161	COST_WEIGHT	☐	ISH_COST_WEIGHT	DEC4_5	DEC	9	5	IS-H: Cost Weight for DRGs
162	DRG_NOGROUP	☐	ISH_DRG_NOGROUP_EXIST	ISH_ON_OFF	CHAR	1	0	IS-H: DRG Is Missing
163	DRG_NOGROUP_ICON	☐	ISH_DRG_NOGROUP_ICON	TEXT50	CHAR	50	0	IS-H: "DRG Missing" Icon
164	DRG_REGROUP	☐	ISH_DRG_REGROUP_ADVISE	ISH_ON_OFF	CHAR	1	0	IS-H: Regrouping Advised
165	DRG_REGROUP_ICON	☐	ISH_DRG_REGROUP_ICON	TEXT50	CHAR	50	0	IS-H: "Regrouping Advised" Icon
166	DRDAZ	☐	ISH_KEZA_DRDAZ	ISH_KENNZAHL_KURZ_INT	INT4	10	0	IS-H: Key Figure Number of DRG-Relevant Diagnoses
167	DRDPZ	☐	ISH_KEZA_DRDPZ	ISH_PROZENT_KENNZAHL	DEC	5	0	IS-H: Key Figure Percentage DRG-Relevant Diagnoses
168	COSTW	☐	ISH_KEZA_COSTW	ISH_DEC31_5	DEC	31	5	IS-H: Key Figure Cost Weight for DRGs
169	DRG	☐	ISH_DRG_CODE	TARLS	CHAR	10	0	IS-H: DRG Code	*
170	MDC	☐	ISH_MDC_CODE	DIAID	CHAR	30	0	IS-H: Code of Major Diagnostic Category (MDC)
171	ENDDT	☐	ENDDT_FAL	RI_DATUM	DATS	8	0	IS-H: End Date of Case
172	.INCLUDE	☐				0	0	IS-H: Medical Controlling - Case-Rel. Key Figures Med. Doc.
173	ABRKZ	☐	ABRKZ_FALL	ABRKZ_FALL	CHAR	1	0	IS-H: Billing Indicator for Case
174	AUFDT	☐	ISH_KEZA_AUFDT	RI_DATUM	DATS	8	0	IS-H: Key Figure Admission Date
175	AUFZT	☐	ISH_KEZA_AUFZT	UHRZT	TIMS	6	0	IS-H: Key Figure Admission Time
176	ENTDT	☐	ISH_KEZA_ENTDT	RI_DATUM	DATS	8	0	Key Figure Discharge Date
177	ENTZT	☐	ISH_KEZA_ENTZT	UHRZT	TIMS	6	0	IS-H: Key Figure Discharge Time
178	AUFFA	☐	ISH_KEZA_AUFFA	ORGID	CHAR	8	0	IS-H: Key Figure Admitting Departmental OU	*
179	AUFPF	☐	ISH_KEZA_AUFPF	ORGID	CHAR	8	0	IS-H: Key Figure Admitting Nursing OU	*
180	ENTFA	☐	ISH_KEZA_ENTFA	ORGID	CHAR	8	0	IS-H: Key Figure Discharging Departmental OU	*
181	ENTPF	☐	ISH_KEZA_ENTPF	ORGID	CHAR	8	0	IS-H: Key Figure Discharging Nursing OU	*
182	AUFBWART	☐	RI_BWART	RI_BWART	CHAR	2	0	IS-H: Movement Type	*
183	AUFBWATX	☐	BEWARTXT	TEXT15	CHAR	15	0	IS-H: Text for Movement Type
184	ENTBWART	☐	RI_BWART	RI_BWART	CHAR	2	0	IS-H: Movement Type	*
185	ENTBWATX	☐	BEWARTXT	TEXT15	CHAR	15	0	IS-H: Text for Movement Type
186	ALTPA	☐	ISH_KEZA_ALTER	ISH_ALTER	CHAR	3	0	IS-H: Key Figure Patient Age
187	WFAAZ	☐	ISH_KEZA_WFAAZ	ISH_KENNZAHL_KURZ_INT	INT4	10	0	IS-H: Key Figure Number of Department Changes
188	EAUDF	☐	ISH_KEZA_EAUFD	ISH_DEC31_2	DEC	31	2	IS-H: Key Figure Average Entry Duration Admiss. Diagn.(Days)
189	EENDF	☐	ISH_KEZA_EENTD	ISH_DEC31_2	DEC	31	2	IS-H: Key Figure Average Entry Duration Disch. Diagn. (Days)
190	FANAM	☐	FANAM	TEXT40	CHAR	40	0	IS-H: Last name and first name of the admitting physician
191	DANAM	☐	DANAM	TEXT40	CHAR	40	0	IS-H: First and Last Name of Discharge Physician
192	DAUER_ICON	☐	ISH_NO_DAUER_ICON	TEXT50	CHAR	50	0	IS-H: "Length of Stay/Treatment Missing" Icon
193	LOS	☐	ISH_LOS	ISH_LOS	NUMC	5	0	IS-H: Length of Stay (Actual, Calculated)
194	LOS_BILL	☐	ISH_LOS_BILL	ISH_LOS	NUMC	5	0	Reduced DRG-Relevant Length of Stay for Case in Days
195	LOSVGL_ICON	☐	ISH_LOSVGL_ICON	TEXT50	CHAR	50	0	IS-H: "Length of Stay Exceeded" Icon
196	LOSDAUER_ICON	☐	ISH_LOSDAUER_ICON	TEXT50	CHAR	50	0	IS-H: "Estimated Length of Stay Exceeded" Icon
197	TOB	☐	ISH_TOB		NUMC	3	0	IS-H: Days Without Calculation
198	.INCLUDE	☐				0	0	IS-H: Coding Analyses - Length of Stay (Max./Min.) Info.
199	TARIF	☐	TARID	TARID	CHAR	2	0	IS-H: Service Catalog Identification Key	*
200	TARLS	☐	TARLS	TARLS	CHAR	10	0	IS-H: Service in Service Catalog	*
201	KTXTCONC	☐	KTXTCONC	TEXT120	CHAR	120	0	IS-H: Service Short Text 120-Char. STXT1 + STXT2 + STXT3
202	CASE_VWD	☐	ISH_CASE_VWD		NUMC	5	0	IS-H: Length of Stay of a Case in Days
203	MGVD	☐	ISH_MVD		DEC	4	2	IS-H: DRG Average LOS Main/External Phy. Dept in Days
204	OGVD	☐	ISH_OGVD	GRVER	NUMC	3	0	IS-H: DRG Max. LOS Main/External Phy. Dept in Days
205	UGVD	☐	ISH_UGVD	GRVER	NUMC	3	0	IS-H: DRG Minimum LOS Main/External Phy. Dept in Days
206	DAYS_OGVD	☐	ISH_DAYS_OGVD	GRVER	NUMC	3	0	IS-H: Maximum Length of Stay Overrun in Days
207	DAYS_OGVD_ICON	☐	ISH_OGVD_ICON	TEXT50	CHAR	50	0	IS-H: "Maximum Length of Stay Overrun" Icon
208	DAYS_UGVD	☐	ISH_DAYS_UGVD	GRVER	NUMC	3	0	IS-H: Minimum Length of Stay Shortfall in Days
209	DAYS_UGVD_ICON	☐	ISH_UGVD_ICON	TEXT50	CHAR	50	0	IS-H: "Minimum Length of Stay Shortfall" Icon
210	DAYS_MGVD	☐	ISH_DAYS_MGVD	GRVER	NUMC	3	0	IS-H: Average Length of Stay Shortfall in Days
211	DAYS_MGVD_ICON	☐	ISH_MGVD_ICON	TEXT50	CHAR	50	0	IS-H: "Average Length of Stay Shortfall" Icon
212	REL_OGVD	☐	ISH_REL_OGVD	DEC4_5	DEC	9	5	IS-H: Cost Weight for DRGs Maximum LOS
213	REL_UGVD	☐	ISH_REL_UGVD	DEC4_5	DEC	9	5	IS-H: Cost Weight for DRGs Minimum Length of Stay
214	REL_MGVD	☐	ISH_REL_MGVD	DEC4_5	DEC	9	5	IS-H: Cost Weight for DRGs Average LOS Shortfall
215	DAYS_TO_OGVD	☐	ISH_DAYS_TO_OGVD	GRVER	NUMC	3	0	IS-H: Maximum Length of Stay in Days Reached
216	OGVD_DAT	☐	ISH_DRGCKF_OGVD_DAT	DATE	DATS	8	0	IS-H DE: Obere Grenzverweildauer - Datum
217	UGVD_DAT	☐	ISH_DRGCKF_UGVD_DAT	DATE	DATS	8	0	IS-H DE: Untere Grenzverweildauer - Datum
218	MVWD_DAT	☐	ISH_DRGCKF_MVWD_DAT	DATE	DATS	8	0	IS-H DE: Mittlere Verweildauer - Datum
219	VWD_H	☐	ISH_DRGCKF_VWD_H	ISH_DRGCKF_VWD_H	DEC	4	2	IS-H DE: Verweildauer in Stunden
220	MINDEST_VWD	☐	ISH_DRGCKF_MINDEST_VWD		NUMC	2	0	IS-H DE: DRG Mindestverweildauer in Stunden
221	BWREL	☐	ISH_DRGCKF_BWREL	ISH_DRGCKF_BWREL_KAT	DEC	6	3	IS-H DE: Bewertungsrelation
222	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
223	ENZKY	☐	NZUSKEY	NZUSKEY	CHAR	1	0	IS-H: Add. Key for Charge Type for FR/Case, Proc.Surcharges
224	ENZKY_TXT	☐	NZUSKEY_TXT	ISH_TEXT30	CHAR	30	0	IS-H: Text Additional Key for Charge Type FR, PS
225	EFFBWR	☐	ISH_DRGCKF_EFFBWR	ISH_DRGCKF_BWREL_CALC	DEC	8	3	IS-H DE: Effektive Bewertungsrelation
226	GRUNDPREIS	☐	ISH_DRGCKF_GRUNDPREIS	ISH_DRGCKF_BETRAG_OHNE_VZ	CURR	9	2	IS-H DE: DRG Grundpreis
227	DRG_ENTGELT	☐	ISH_DRGCKF_DRG_ENTGELT	ISH_DRGCKF_BETRAG_OHNE_VZ	CURR	9	2	IS-H DE: DRG-Entgelt
228	ZUABSCHL_KZ	☐	ISH_DRGCKF_ZUABSCHL_KZ	ISH_DRGCKF_ZUABSCHL_KZ	CHAR	2	0	IS-H DE: Kennzeichen DRG Zu-/Abschlag
229	ZUABSCHL_KZ_TXT	☐	ISH_DRGCKF_ZUABSCHL_KZ_TXT	ISH_TEXT30	CHAR	30	0	IS-H DE: Text für Kennzeichen DRG Zu-/Abschlag
230	ZUABSCHL_RELAT_KAT	☐	ISH_RSURDIS	ISH_DRGCKF_BWREL_KAT	DEC	6	3	IS-H DE: DRG Valuation Relation of Surcharge/Discount
231	ZUABSCHL_TAGE	☐	ISH_SUR_DIS_DAYS	ISH_DRG_DAYS	INT4	10	0	IS-H DE: Number of Days Surcharge or Discount for DRG Svce
232	ZUABSCHL_RELAT	☐	ISH_DRGCKF_ZUABSCHL_RELAT	ISH_DRGCKF_BWREL_CALC	DEC	8	3	IS-H DE: Zu- bzw. Abschlagsrelation (Tage x Zu/Abschl. Rel.)
233	ZUABSCHL_BETRAG_KAT	☐	ISH_SURDIS_AMT_DAY	ISH_DRG_AMOUNT_WITH_SIGN	CURR	9	2	IS-H DE: Amount of DRG Surcharge or Discount per Day
234	ZUABSCHL_BETRAG	☐	ISH_SUR_DIS_AMOUNT	ISH_DRG_AMOUNT_WITH_SIGN	CURR	9	2	IS-H DE: Total Amount of DRG Surcharge or Discount
235	BPFLV_FALL	☐	ISH_DRGCKF_BPFLV_FALL	XFELD	CHAR	1	0	IS-H DE: BPflV-Fall
236	WIEDERKEHRER_FALL	☐	ISH_DRGCKF_WIEDERKEHRER_FALL	XFELD	CHAR	1	0	IS-H DE: KFPV 2003: Wiederkehrerfall
237	VORGAENGER_FALL	☐	ISH_DRGCKF_VORGAENGER_FALL	XFELD	CHAR	1	0	IS-H DE: KFPV 2003: Vorgängerfall
238	WIEDERKEHRER_FALNR	☐	ISH_DRGCKF_WIEDERKEHRER_FALNR	FALNR	CHAR	10	0	IS-H: KFPV 2003: Fallnr. d. Wied.k.falls, wenn akt. Fall ein	*
239	.INCLUDE	☐				0	0	IS-H DE: Anzeigeattribute zu einem Wiederkehrerfall
240	UNIRETCASE_STATUS	☐	ISH_UNIRETCASE_STATUS	CHAR2	CHAR	2	0	IS-H: Wiederkehrerstatus
241	UNIRETCASE_STATUS_ICON	☐	ISH_UNIRETCASE_STATUS_ICON	TYPE_ICON	CHAR	132	0	IS-H: Symbol 'Wiederkehrerstatus'
242	UNIRETCASE_FALNR_LEAD	☐	ISH_UNIRETCASE_FALNR_LEAD	FALNR	CHAR	10	0	IS-H: Führender Fall bei Wiederkehrer	*
243	.INCLUDE	☐				0	0	IS-H: Coding Analyses - PEPP Information
244	PEPP_FALL	☐	ISH_PSY_FALL	XFELD	CHAR	1	0	IS-H DE: PEPP-Fall (Psychiatrie/Psychosomatik)
245	PEPP_BWREL	☐	ISH_PEPP_CW		DEC	9	5	IS-H: PEPP Cost Weight
246	PEPP_STEP	☐	ISH_PEPP_STEP		INT1	3	0	IS-H: PEPP-Vergütungsstufe
247	PEPP_VWDFROM	☐	ISH_VWD_FROM	PEPP_GRVER	NUMC	5	0	IS-H: PEPP Low Trim Point in Days
248	PEPP_VWDTO	☐	ISH_VWD_TO	PEPP_GRVER	NUMC	5	0	IS-H: PEPP High Trim Point in Days
249	PEPP_VWDREL	☐	ISH_PEPP_CW		DEC	9	5	IS-H: PEPP Cost Weight
250	PEPP_BASENT	☐	ISH_BASENT	ISH_BASENT	CURR	8	2	IS-H: Base Charge Value for PEPP Billing
251	.INCLUDE	☐				0	0	IS-H: Medical Status Data for Views in Clinical Work Station
252	MDSTA	☐	N_MD_STATUS_TXT04	TEXT4	CHAR	4	0	IS-H: Key of Basic Medical Documentation Status
253	MDSTATXT	☐	N_MD_STATUS_TXT30	TEXT30	CHAR	30	0	IS-H: Text of Status for Medical Basic Documentation
254	MDFASTXT	☐	N_MD_DEP_OPEN	CHAR120	CHAR	120	0	IS-H: Open Department Statuses
255	MDFAS_CASE_ICON	☐	ISH_MDFAS_CASE_ICON	TEXT50	CHAR	50	0	IS-H: Icon "Open Department Status Exists for Case"
256	MDFAS_OU_ICON	☐	ISH_MDFAS_OU_ICON	TEXT50	CHAR	50	0	IS-H: Icon "Open Department Status Exists for OU"
257	.INCLUDE	☐				0	0	IS-H*MED: Data on Patient Pathway for Views in Clin. WS
258	PATHWAY_STATE	☐	N2GL_PATHWAY_STATE	N2GL_PATHWAY_STATE	CHAR	6	0	Patient Path Status
259	PATHWAY_STATE_TXT	☐	N2GL_PATHWAY_STATE_TXT60	CHAR60	CHAR	60	0	Text of Status for Patient Pathway
260	PATHWAY_STATE_ICON	☐	N2GL_PATHWAY_STATE_ICON	TEXT50	CHAR	50	0	'Patient Pathway Status' Icon
261	PROFESSIONS	☐	N2GL_PROFESSIONS	TEXT100	CHAR	100	0	Occupational Groups which Have Open Steps
262	PATHWAY_PROPOSAL_ICON	☐	N2GL_PATHWAY_PROPOSAL_ICON	TEXT50	CHAR	50	0	Icon 'Pathway Proposal Available'
263	.INCLUDE	☐				0	0	IS-H NL: Daten zur DBC für Sichten im KLAP
264	DBC	☐	ISH_NL_DBC	ISH_NL_DBC	CHAR	30	0	ISH_NL: DBC
265	DBC_ICON	☐	ISH_NL_DBC_ICON	TEXT50	CHAR	50	0	IS-H NL: Symbol DBC registriert
266	AFGESL	☐	ISH_NL_AFGSL	ISH_NL_AFGSL	CHAR	1	0	ISH_NL: DBC abgeschloßen
267	BSNNR	☐	ISH_NL_BSNNR	ISH_LNCARD	NUMC	10	0	Burger service nummer BSN nummer
268	BSN_STAT	☐	ISH_NL_BSN_ICON	SYCHAR132	CHAR	132	0	BSN Status symbol
269	WID_STAT	☐	ISH_NL_WID_ICON	SYCHAR132	CHAR	132	0	WID Status symbol
270	.INCLUDE	☐				0	0	Suchkriterien LV Schweiz (u.a. Filterfunktion
271	SDRG_USER	☐	NWCH_SDRG_USER	USNAM	CHAR	12	0	Swiss DRG - letzter Bearbeiter der DRG

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RNWP_MEDCONTROL_LIST	GWEIN	T006	MSEHI	REF	1	CN

History

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