SAP ABAP Table ISH_RNDIA_SORT (IS-H: Diagnosis Sorting Structure)

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_RNDIA_SORT	Table Relationship Diagram
Short Description	IS-H: Diagnosis Sorting Structure

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

Foreign Keys

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

History

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