SAP ABAP Table ISH_DIAGNOSIS_OVERVIEW (IS-H: Diagnoses - Overview Screen)

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	ISH_DIAGNOSIS_OVERVIEW	Table Relationship Diagram
Short Description	IS-H: Diagnoses - Overview Screen

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	EXPAND_F	☐	ISH_DIA_OV_EXPAND_F	CHAR1	CHAR	1	0	IS-H: Diagnosis Overview - Expand TECH
2	INVISIBLE_F	☐	ISH_DIA_OV_INVISIBLE	CHAR1	CHAR	1	0	IS-H: Diagnosis Overview TECH
3	COLOR_F	☐			CHAR	4	0
4	DD_BEHAVIOUR	☐	LVC_T_DRDR		TTYP	0	0
5	DOCVIEW_PATIENT	☐	OBJECT		REF	0	0
6	DOCVIEW_IF	☐	IF_ISH_DIAGNOSIS_DOCVIEW		REF	0	0
7	DIAGNOSIS	☐	IF_ISH_CASEDIAGNOSIS		REF	0	0
8	SORTSCT	☐	ISH_DIAGNOSIS_SORTSCT	NUMC5	NUMC	5	0	IS-H: Diagnosis Overview - Sort by Departments
9	EXPAND_S	☐	ISH_DIA_OV_EXPAND	CHAR30	CHAR	30	0	IS-H: Diagnosis Overview - Expand/Collapse Icon
10	OV_KEY1	☐	ISH_DIA_OV_KEY1	TEXT40	CHAR	40	0	IS-H: Diagnosis Overview - Dept. OU/Diagnosis Code 1
11	OV_KEY2	☐	ISH_DIA_OV_KEY2	TEXT40	CHAR	40	0	IS-H: Diagnosis Overview - Nursing OU/Diagnosis Code 2
12	OV_VAL	☐	ISH_DIA_OV_VAL	TEXT40	CHAR	40	0	IS-H: Diagnosis Overview - Movement/Text
13	LTEXT_DIAGNOSIS_S	☐	ISH_DIA_OV_DITXT	CHAR30	CHAR	30	0	IS-H: Diagnosis Overview - Long Text for Icons
14	LTEXT_REMARK_S	☐	ISH_DIA_OV_REMARK	CHAR30	CHAR	30	0	IS-H: Diagnosis Overview - Comment Icon
15	OV_DATE	☐	ISH_DIA_OV_DATE	DATS	DATS	8	0	IS-H: Diagnosis Overview - Date - Department/Diagnosis
16	OV_TIME	☐	ISH_DIA_OV_TIME	TIME	TIMS	6	0	IS-H: Diagnosis Overview - Time - Department/Diagnosis
17	OV_DATETIME	☐	ISH_DIA_OV_DATETIME	TEXT19	CHAR	19	0	IS-H: Diagnosis Overview Date/Time - Department/Diagnosis
18	PATDIA_FALNR	☐	FALNR	FALNR	CHAR	10	0	IS-H: Case Number	*
19	OV_DIALO_E	☐	ISH_DIA_OV_DIALO	N2_LOTEXT	CHAR	20	0	Text for Medical Localization
20	OV_DIAGW_E	☐	ISH_DIA_OV_DIAGW	N2_SITEXT	CHAR	50	0	Text for Diagnostic Certainty
21	OV_DRG_CATEGORY_E	☐	ISH_DIA_OV_DRG_CATEGORY	DDTEXT	CHAR	60	0	Text for DRG Diagnosis Category
22	.INCLUDE	☐				0	0	IS-H: Diagnoses - Overview Screen - Icons for Classes
23	EWDIA_S	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
24	BHDIA_S	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
25	AFDIA_S	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
26	ENDIA_S	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
27	ARDIA_S	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
28	PODIA_S	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
29	OPDIA_S	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
30	TUDIA_S	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
31	FHDIA_S	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
32	KHDIA_S	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
33	DRG_S	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
34	DIABZ_S	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
35	SPERR_S	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
36	.INCLUDE	☐				0	0	IS-H: Diagnosis Entry Screen Fields
37	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution	*
38	FALNR	☐	FALNR	FALNR	CHAR	10	0	IS-H: Case Number	*
39	LFDNR	☐	LFDDIA	LFDDIA	NUMC	3	0	IS-H: Sequence Number of Diagnosis
40	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator
41	REFKY	☐	DIA_REFKEY	ISH_REFKY	CHAR	20	0	IS-H: Reference Code of Diagnosis from External System
42	LFDBEW	☐	LFDBEW	LFDBEW	NUMC	5	0	IS-H: Sequence Number of Movement	*
43	EWDIA	☐	KZ_EINWD	XFELD	CHAR	1	0	IS-H: Referral Diagnosis Indicator
44	BHDIA	☐	KZ_BEHLD	XFELD	CHAR	1	0	IS-H: Treatment Diagnosis Indicator
45	AFDIA	☐	KZ_AUFND	XFELD	CHAR	1	0	IS-H: Admission Diagnosis Indicator
46	ENDIA	☐	KZ_ENTLD	XFELD	CHAR	1	0	IS-H: "Discharge Diagnosis" Indicator
47	BSDIA	☐	KZ_BHSD	XFELD	CHAR	1	0	IS-H: "Treatment Certificate Diagnosis" Indicator
48	OPDIA	☐	KZ_OPERD	XFELD	CHAR	1	0	IS-H: Surgery Diagnosis Indicator
49	FHDIA	☐	KZ_FAHPD	XFELD	CHAR	1	0	IS-H: "Department Main Diagnosis" Indicator
50	KHDIA	☐	KZ_KHHPD	XFELD	CHAR	1	0	IS-H: Hospital Main Diagnosis Indicator
51	DTYP	☐	DIATYP	DIATYP	CHAR	1	0	IS-H: Diagnosis Category (Referral, Treatment Diagnosis)
52	DKAT1	☐	DIAKAT	KATID	CHAR	2	0	IS-H: Identification Key of Diagnosis Coding Catalog	TNK00
53	DKATKB1	☐	KATKB	TEXT10	CHAR	10	0	IS-H: Short Text for Catalog
54	DKEY1	☐	DIAID	DIAID	CHAR	30	0	IS-H: Diagnosis Code
55	D1TXT1	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
56	D1TXT2	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
57	D1TXT3	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
58	DKAT2	☐	DIAKAT	KATID	CHAR	2	0	IS-H: Identification Key of Diagnosis Coding Catalog	TNK00
59	DKATKB2	☐	KATKB	TEXT10	CHAR	10	0	IS-H: Short Text for Catalog
60	DKEY2	☐	DIAID	DIAID	CHAR	30	0	IS-H: Diagnosis Code
61	D2TXT1	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
62	D2TXT2	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
63	D2TXT3	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
64	DITXT	☐	ISH_DITEXT	TEXT50	CHAR	50	0	IS-H: Free-Text Diagnosis
65	DILTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
66	LGTX1	☐	ISH_LGTX03	ISH_ICON	CHAR	30	0	Screen Field for Displaying Dynamic Icon
67	KZTXT	☐	TEXT_DIA	TEXT50	CHAR	50	0	IS-H: Comment on Diagnosis
68	LGTXT	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
69	LGTX2	☐	ISH_LGTX03	ISH_ICON	CHAR	30	0	Screen Field for Displaying Dynamic Icon
70	DKAT_REF	☐	REF_DIAKAT	KATID	CHAR	2	0	IS-H: Catalog ID of Reference Catalog for Statistics	TNK00
71	DKEY_REF	☐	REF_DIAID	DIAID	CHAR	30	0	IS-H: Reference Diagnosis Code for Statistics
72	ANZOP	☐	ANZOP	NUM02	NUMC	2	0	IS-H: Number of Surgeries Occasioned by Dept. Main Diagnosis
73	SPERR	☐	RI_SPERR	XFELD	CHAR	1	0	Blocking Indicator
74	DIADT	☐	DIADT	RI_DATUM	DATS	8	0	IS-H: Date on which Diagnosis Was Created
75	DIAZT	☐	DIAZT	UHRZT	TIMS	6	0	IS-H: Time at which Diagnosis Created
76	DIAPE	☐	DIA_PERS	RI_KUNNR	CHAR	10	0	IS-H: Identification of Diagnosing Person	*
77	ANAME	☐	ARZT_NAME	TEXT30	CHAR	30	0	IS-H: Name of Physician / Employee
78	ORGID	☐	NZUWFA	ORGID	CHAR	8	0	IS-H: OU with Departmental Responsibility for Case	*
79	ORGKB	☐	ORGKB	TEXT12	CHAR	12	0	IS-H: Organizational Unit Short Text
80	AUFDT	☐	FA_AUFDT	RI_DATUM	DATS	8	0	IS-H: Date of Admission to Departmental Org. Unit
81	AUFZT	☐	FA_AUFZT	UHRZT	TIMS	6	0	IS-H: Time of Admission to Department
82	ENTDT	☐	FA_ENTDT	RI_DATUM	DATS	8	0	IS-H: Date of Discharge from Departmental Org. Unit
83	ENTLASSEN	☐	ISH_PATENTL	XFELD	CHAR	1	0	IS-H: Missing Diagnoses for Discharged Patient
84	PATFAW	☐	ISH_PATFAW	XFELD	CHAR	1	0	IS-H: Missing Diagnoses for Patient with Change of Dept.
85	SELDT	☐	FA_SELDT	RI_DATUM	DATS	8	0	IS-H: Key Date for Movements to/from Organizational Units
86	BEWIN	☐	FA_BEWIN	XFELD	CHAR	1	0	IS-H: Indicator for Admission/Transfer/Visit to Dept. OU
87	BEWAUS	☐	FA_BEWAUS	XFELD	CHAR	1	0	IS-H: Indicator for Transfer/Discharge From Dept. OU
88	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
89	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
90	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
91	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
92	MARK	☐	MARK	XFELD	CHAR	1	0	Indicator: posting line selected?
93	VCODE	☐	ISH_VCODE	ISH_VCODE	CHAR	3	0	IS-H: Processing Mode
94	STATIONAER	☐	ISH_STAT	XFELD	CHAR	1	0	IS-H: 'Inpatient Area' Indicator
95	AMBULANT	☐	ISH_AMB	XFELD	CHAR	1	0	IS-H: 'Outpatient Area' Indicator
96	DTDIAG	☐	ISH_DTDIAG	RI_DATUM	DATS	8	0	IS-H: Diagnosis Validity Date
97	ZTDIAG	☐	ISH_ZTDIAG	UHRZT	TIMS	6	0	IS-H: Diagnosis Validity Time
98	NO_EWDIA	☐	NO_EWDIA	XFELD	CHAR	1	0	IS-H: All Cases Without Referral Diagnosis
99	NO_AFDIA	☐	NO_AFDIA	XFELD	CHAR	1	0	IS-H: All Cases Without Admission Diagnosis
100	NO_ENDIA	☐	NO_ENDIA	XFELD	CHAR	1	0	IS-H: All Cases Without Discharge Diagnosis
101	NO_FHDIA	☐	NO_FHDIA	XFELD	CHAR	1	0	IS-H: All Cases Without Department Main Diagnosis
102	NO_KHDIA	☐	NO_KHDIA	XFELD	CHAR	1	0	IS-H: All Cases Without Hospital Main Diagnosis
103	NO_DART	☐	NO_DIAGART	XFIELD	CHAR	1	0	IS-H: All Cases Without Restrictions on Diagnosis Type
104	NO_KEYDIA	☐	ISH_FTDIA	XFELD	CHAR	1	0	IS-H: All Cases w/o Coding for User-Defined Diagn. Texts
105	SW_ENTL_BS	☐	SW_ENTL_BS	CHAR20	CHAR	20	0	IS-H: "Discharge/Treatment Certificate Diagnosis" Indicator
106	DAUER	☐	ISH_DAUER	NUMC5	NUMC	5	0	IS-H: Estimated Length of Stay or Treatment
107	BWGR1	☐	ISH_BWGR1	ISH_BGRUND	CHAR	2	0	Movement Reason - 1st and 2nd Positions	TN14G
108	BWGR2	☐	ISH_BWGR2	ISH_BGRUND	CHAR	2	0	Movement Reason - 3rd and 4th Positions	TN14G
109	BGTXT	☐	ISH_BGTXTL	TEXT30	CHAR	30	0	Long Text for Movement Reason
110	ENTLGR1	☐	ISH_BWGR1	ISH_BGRUND	CHAR	2	0	Movement Reason - 1st and 2nd Positions	TN14G
111	ENTLGR2	☐	ISH_BWGR2	ISH_BGRUND	CHAR	2	0	Movement Reason - 3rd and 4th Positions	TN14G
112	ENTLGTXT	☐	ISH_BGTXTL	TEXT30	CHAR	30	0	Long Text for Movement Reason
113	ARDIA	☐	N2_KZARDIA	XFELD	CHAR	1	0	Working Diagnosis Indicator
114	PODIA	☐	N2_KZPODIA	XFELD	CHAR	1	0	Preoperative Diagnosis Indicator
115	TUDIA	☐	N2_KZTUDIA	XFELD	CHAR	1	0	IS-H: Cause of Death Indicator
116	DIABZ	☐	N2_DIABZ	XFELD	CHAR	1	0	Diagnosis Reference
117	DIAPR	☐	N2_DIAPR	N2_DIAPR	CHAR	1	0	Medical Secondary Diagnosis Indicator	TN26B
118	DIAGW	☐	N2_DIASI	N2_DIASI	CHAR	2	0	Diagnostic Certainty	TN26C
119	DIAZS	☐	N2_DIAZS	N2_DIAZS	CHAR	2	0	Diagnostic Suppl.	TN26D
120	DIALO	☐	N2_DIALO	N2_DIALO	CHAR	2	0	IS-H: Localization of Diagnosis	TN26E
121	EXTID	☐	N2_EXTID	N2_EXTID	CHAR	8	0	Internal Identifier of the Diagnosis Coding Tool
122	DIAFP	☐	N2_DIAFP	N2_DIAFP	CHAR	8	0	Flat Rate per Case
123	DIAPRTEXT	☐	N2_PRTEXT	N2_PRTEXT	CHAR	20	0	Text for Diagnosis Priority
124	DIASITEXT	☐	N2_SITEXT	N2_SITEXT	CHAR	50	0	Text for Diagnostic Certainty
125	DIAZSTEXT	☐	N2_ZSTEXT	N2_ZSTEXT	CHAR	50	0	Text for Diagnosis Addition
126	DIALOTEXT	☐	N2_LOTEXT	N2_LOTEXT	CHAR	20	0	IS-H: Text for Medical Localization
127	DIAGPERS	☐	DIA_PERS	RI_KUNNR	CHAR	10	0	IS-H: Identification of Diagnosing Person	*
128	DIAGNAME	☐	ARZT_NAME	TEXT30	CHAR	30	0	IS-H: Name of Physician / Employee
129	DIAGDAT	☐	DIADT	RI_DATUM	DATS	8	0	IS-H: Date on which Diagnosis Was Created
130	FACHR7	☐	FACHRTY7	ISH_FACHR	CHAR	4	0	IS-H: Specialty for Organizational Unit	TNKFA
131	NEUGB	☐	ISH_NGBDIA	XFELD	CHAR	1	0	IS-H: Include Diagnoses of Healthy Newborns
132	DTYP1	☐	ISH_ICD10_DIATYP	ISH_DIATYP	CHAR	1	0	Type for ICD-10 Diagnoses
133	DTYP2	☐	ISH_ICD10_DIATYP	ISH_DIATYP	CHAR	1	0	Type for ICD-10 Diagnoses
134	DTYP_REF	☐	ISH_ICD10_DIATYP	ISH_DIATYP	CHAR	1	0	Type for ICD-10 Diagnoses
135	DRG_DIA_SEQNO	☐	ISH_DRG_DIA_NB	LFD_NR_DRG_DIA	NUMC	6	0	IS-H: Consecutive Numbering of DRG Diagnosis
136	DRG_CATEGORY	☐	ISH_DRG_DIA_CATEGORY	ISH_DRG_DIA_CAT_TYPE	CHAR	1	0	IS-H: Category of DRG Diagnosis (Principal, Secondary)
137	DRG_CC	☐	ISH_DRG_DIA_CC	ISH_ON_OFF	CHAR	1	0	IS-H: Comorbidity and Complication (DRG Diagnosis)
138	DRG_RELVANT	☐	ISH_DRG_DIA_RELEVANT	ISH_ON_OFF	CHAR	1	0	IS-H: Used to Determine DRG
139	ALTERN_DIATXT	☐	ISH_ALTERN_DIATXT	TXT132	CHAR	132	0	IS-H: Alternative Diagnosis Text (from External System)
140	TCODE	☐	ISH_TCODE	TCODE	CHAR	20	0	IS-H: Report Control: Transaction Code for Application	*
141	DIA_LINK	☐	ISH_DIA_LINK	LFDDIA	NUMC	3	0	IS-H: Link to Another Diagnosis
142	CCL	☐	ISH_CCL	ISH_CCL_TYPE	NUMC	3	0	IS-H: Complication Level of Diagnoses (for DRGs)
143	D1TXT_CONC	☐	ISH_DIATXT_CONC	TEXT120	CHAR	120	0	IS-H: Concatenated Diagnosis Text from Diagnosis Catalog
144	D2TXT_CONC	☐	ISH_DIATXT_CONC	TEXT120	CHAR	120	0	IS-H: Concatenated Diagnosis Text from Diagnosis Catalog
145	ICD_INFO	☐	ISH_ICD10_INFO	TEXT50	CHAR	50	0	IS-H: Output Field for Identifying Linked Diagnoses
146	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
147	DOCVIEW	☐	ISH_SECTION_HANDLE	NUMC4	NUMC	4	0	IS-H: Department Diagnosis
148	DIASOB	☐	ISH_OBJECT_HANDLE	NUMC4	NUMC	4	0	IS-H: Integer Handle on Object
149	BEWTY	☐	BEWTY	BEWTY	CHAR	1	0	IS-H: Movement Category
150	BWART	☐	RI_BWART	RI_BWART	CHAR	2	0	IS-H: Movement Type	*
151	SORTDEF	☐	ISH_DIAGNOSIS_SORTDEF	NUMC5	NUMC	5	0	IS-H: Diagnoses - Standard Sort Order
152	DKATKB_REF	☐	KATKB	TEXT10	CHAR	10	0	IS-H: Short Text for Catalog
153	DRTXT1	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
154	DRTXT2	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
155	DRTXT3	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
156	DRTXT_CONC	☐	ISH_DIATXT_CONC	TEXT120	CHAR	120	0	IS-H: Concatenated Diagnosis Text from Diagnosis Catalog
157	DIAG_EXCF	☐	ISH_DIA_EXCEPTION_FACTS	TEXT240	CHAR	240	0	IS-H: Diagnosenausnahmetatbestand
158	DOCVIEW_SHLP	☐	ISH_SECTION_HANDLE	NUMC4	NUMC	4	0	IS-H: Department Diagnosis
159	QUALF	☐	ISH_DIA_QUALF	ISH_DIA_QUALF	CHAR	5	0	Diagnosis Qualifier	TN26Y
160	DRG_IMPACT	☐	ISH_DIA_DRG_IMPACT	ISH_DRG_IMPACT	CHAR	2	0	Impact of Diagnosis on DRG Determination
161	CELLTAB	☐	LVC_T_STYL		TTYP	0	0
162	DROP_DOWN_DIALO_E	☐	INT4	INT4	INT4	10	0	Natural number
163	DROP_DOWN_DIAGW_E	☐	INT4	INT4	INT4	10	0	Natural number
164	DROP_DOWN_DRG_CATEGORY_E	☐	INT4	INT4	INT4	10	0	Natural number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ISH_DIAGNOSIS_OVERVIEW	BWGR1	TN14G	GRUND		1	CN
2	ISH_DIAGNOSIS_OVERVIEW	BWGR2	TN14G	GRUND		1	CN
3	ISH_DIAGNOSIS_OVERVIEW	DIAGW	TN26C	DIASI
4	ISH_DIAGNOSIS_OVERVIEW	DIALO	TN26E	DIALO
5	ISH_DIAGNOSIS_OVERVIEW	DIAPR	TN26B	DIAPR
6	ISH_DIAGNOSIS_OVERVIEW	DIAZS	TN26D	DIAZS
7	ISH_DIAGNOSIS_OVERVIEW	DKAT1	TNK00	KATID
8	ISH_DIAGNOSIS_OVERVIEW	DKAT2	TNK00	KATID
9	ISH_DIAGNOSIS_OVERVIEW	DKAT_REF	TNK00	KATID
10	ISH_DIAGNOSIS_OVERVIEW	ENTLGR1	TN14G	GRUND
11	ISH_DIAGNOSIS_OVERVIEW	ENTLGR2	TN14G	GRUND		1	CN
12	ISH_DIAGNOSIS_OVERVIEW	FACHR7	TNKFA	FACHR	REF	1	CN
13	ISH_DIAGNOSIS_OVERVIEW	QUALF	TN26Y	QUALF

History

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