SAP ABAP Table RNWATSCO_DIA (IS-H AT: Struktur fürs Online-Scoring (Diagnosen))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ NAT1 (Package) Application development Hospital System Austria

Basic Data

Table Category	INTTAB	Structure
Structure	RNWATSCO_DIA	Table Relationship Diagram
Short Description	IS-H AT: Struktur fürs Online-Scoring (Diagnosen)

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	Änderungsbelegstruktur; generiert durch RSSCD000
2	.INCLUDE	☐				0	0	IS-H: Diagnoses
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution	TN01
5	FALNR	☐	FALNR	FALNR	CHAR	10	0	IS-H: Case Number	NFAL
6	LFDNR	☐	LFDDIA	LFDDIA	NUMC	3	0	IS-H: Sequence Number of Diagnosis
7	LFDBEW	☐	LFDBEW	LFDBEW	NUMC	5	0	IS-H: Sequence Number of Movement	NBEW
8	BELNR	☐	KS_BELNR	KS_BELNR	CHAR	10	0	IS-H: Document Number of IV Document/Treatment Certificate	NKSK
9	DKAT1	☐	DIAKAT	KATID	CHAR	2	0	IS-H: Identification Key of Diagnosis Coding Catalog	TNK00
10	DKEY1	☐	DIAID	DIAID	CHAR	30	0	IS-H: Diagnosis Code	NKDI
11	DKAT2	☐	DIAKAT	KATID	CHAR	2	0	IS-H: Identification Key of Diagnosis Coding Catalog	TNK00
12	DKEY2	☐	DIAID	DIAID	CHAR	30	0	IS-H: Diagnosis Code	NKDI
13	DKAT_REF	☐	REF_DIAKAT	KATID	CHAR	2	0	IS-H: Catalog ID of Reference Catalog for Statistics	TNK00
14	DKEY_REF	☐	REF_DIAID	DIAID	CHAR	30	0	IS-H: Reference Diagnosis Code for Statistics	NKDI
15	DITXT	☐	ISH_DITEXT	TEXT50	CHAR	50	0	IS-H: Free-Text Diagnosis
16	DILTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
17	DIADT	☐	DIADT	RI_DATUM	DATS	8	0	IS-H: Date on which Diagnosis Was Created
18	DIAZT	☐	DIAZT	UHRZT	TIMS	6	0	IS-H: Time at which Diagnosis Created
19	DIAPE	☐	DIA_PERS	RI_KUNNR	CHAR	10	0	IS-H: Identification of Diagnosing Person	NGPA
20	ANZOP	☐	ANZOP	NUM02	NUMC	2	0	IS-H: Number of Surgeries Occasioned by Dept. Main Diagnosis
21	EWDIA	☐	KZ_EINWD	XFELD	CHAR	1	0	IS-H: Referral Diagnosis Indicator
22	BHDIA	☐	KZ_BEHLD	XFELD	CHAR	1	0	IS-H: Treatment Diagnosis Indicator
23	AFDIA	☐	KZ_AUFND	XFELD	CHAR	1	0	IS-H: Admission Diagnosis Indicator
24	ENDIA	☐	KZ_ENTLD	XFELD	CHAR	1	0	IS-H: "Discharge Diagnosis" Indicator
25	FHDIA	☐	KZ_FAHPD	XFELD	CHAR	1	0	IS-H: "Department Main Diagnosis" Indicator
26	KHDIA	☐	KZ_KHHPD	XFELD	CHAR	1	0	IS-H: Hospital Main Diagnosis Indicator
27	OPDIA	☐	KZ_OPERD	XFELD	CHAR	1	0	IS-H: Surgery Diagnosis Indicator
28	SPERR	☐	RI_SPERR	XFELD	CHAR	1	0	Blocking Indicator
29	KZTXT	☐	TEXT_DIA	TEXT50	CHAR	50	0	IS-H: Comment on Diagnosis
30	LGTXT	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
31	DIASI	☐	DIASI	DIASI	CHAR	1	0	IS-H: Diagnostic Certainty
32	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
33	ERTIM	☐	RI_ERTIM	UHRZT	TIMS	6	0	IS-H: Time Record Created
34	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
35	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
36	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
37	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
38	STUSR	☐	STORN_USER	USNAM	CHAR	12	0	IS-H: Name of User who Canceled Data Record
39	STDAT	☐	STORN_DAT	RI_DATUM	DATS	8	0	Date of Cancellation
40	ARDIA	☐	N2_KZARDIA	XFELD	CHAR	1	0	Working Diagnosis Indicator
41	PODIA	☐	N2_KZPODIA	XFELD	CHAR	1	0	Preoperative Diagnosis Indicator
42	TUDIA	☐	N2_KZTUDIA	XFELD	CHAR	1	0	IS-H: Cause of Death Indicator
43	DIABZ	☐	N2_DIABZ	XFELD	CHAR	1	0	Diagnosis Reference
44	DIAPR	☐	N2_DIAPR	N2_DIAPR	CHAR	1	0	Medical Secondary Diagnosis Indicator	TN26B
45	DIAGW	☐	N2_DIASI	N2_DIASI	CHAR	2	0	Diagnostic Certainty	TN26C
46	DIAZS	☐	N2_DIAZS	N2_DIAZS	CHAR	2	0	Diagnostic Suppl.	TN26D
47	DIALO	☐	N2_DIALO	N2_DIALO	CHAR	2	0	IS-H: Localization of Diagnosis	TN26E
48	EXTID	☐	N2_EXTID	N2_EXTID	CHAR	8	0	Internal Identifier of the Diagnosis Coding Tool
49	DIAFP	☐	N2_DIAFP	N2_DIAFP	CHAR	8	0	Flat Rate per Case
50	REFKY	☐	DIA_REFKEY	ISH_REFKY	CHAR	20	0	IS-H: Reference Code of Diagnosis from External System
51	DRG_DIA_SEQNO	☐	ISH_DRG_DIA_NB	LFD_NR_DRG_DIA	NUMC	6	0	IS-H: Consecutive Numbering of DRG Diagnosis
52	DRG_CATEGORY	☐	ISH_DRG_DIA_CATEGORY	ISH_DRG_DIA_CAT_TYPE	CHAR	1	0	IS-H: Category of DRG Diagnosis (Principal, Secondary)
53	DRG_CC	☐	ISH_DRG_DIA_CC	ISH_ON_OFF	CHAR	1	0	IS-H: Comorbidity and Complication (DRG Diagnosis)
54	DRG_RELVANT	☐	ISH_DRG_DIA_RELEVANT	ISH_ON_OFF	CHAR	1	0	IS-H: Used to Determine DRG
55	DTYP1	☐	ISH_ICD10_DIATYP	ISH_DIATYP	CHAR	1	0	Type for ICD-10 Diagnoses
56	DTYP2	☐	ISH_ICD10_DIATYP	ISH_DIATYP	CHAR	1	0	Type for ICD-10 Diagnoses
57	DTYP_REF	☐	ISH_ICD10_DIATYP	ISH_DIATYP	CHAR	1	0	Type for ICD-10 Diagnoses
58	ALTERN_DIATXT	☐	ISH_ALTERN_DIATXT	TXT132	CHAR	132	0	IS-H: Alternative Diagnosis Text (from External System)
59	TCODE	☐	ISH_TCODE	TCODE	CHAR	20	0	IS-H: Report Control: Transaction Code for Application	*
60	DIA_LINK	☐	ISH_DIA_LINK	LFDDIA	NUMC	3	0	IS-H: Link to Another Diagnosis
61	CCL	☐	ISH_CCL	ISH_CCL_TYPE	NUMC	3	0	IS-H: Complication Level of Diagnoses (for DRGs)
62	TIMESTAMP	☐	ISH_TIMESTAMP	TZNTSTMPS	DEC	15	0	IS-H: Time Stamp in Short Form (YYYYMMDDhhmmss)
63	DIAG_EXCF	☐	ISH_DIA_EXCEPTION_FACTS	TEXT240	CHAR	240	0	IS-H: Diagnosenausnahmetatbestand
64	QUALF	☐	ISH_DIA_QUALF	ISH_DIA_QUALF	CHAR	5	0	Diagnosis Qualifier	*
65	DRG_IMPACT	☐	ISH_DIA_DRG_IMPACT	ISH_DRG_IMPACT	CHAR	2	0	Impact of Diagnosis on DRG Determination
66	.INCLUDE	☐				0	0	Structures for generating change document update programs
67	KZ	☐	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)
68	DTEXT1	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
69	DTEXT2	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
70	DTEXT3	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
71	DTEXTCONC	☐	DIASTTXT	CHAR150	CHAR	150	0	Standardized Short Text for Diagnoses
72	.INCLUDE	☐				0	0	IS-H AT: Outputstruktur Scoringdaten
73	GRP	☐	NAGRP	N1C009	CHAR	9	0	IS-H AT: Scoring - HDG/MEL-Gruppe
74	KNO	☐	NAKNO	CHAR02	CHAR	2	0	IS-H AT: Scoring - Knoten
75	BDU	☐	NABDU	CHAR7	CHAR	7	0	IS-H AT: Scoring - Untere Belagsdauer-Grenze
76	BDO	☐	NABDO	CHAR7	CHAR	7	0	IS-H AT: Scoring - Obere Belagsdauer-Grenze
77	BDM	☐	NABDM	CHAR7	CHAR	7	0	IS-H AT: Scoring - Mittlere Belagsdauer-Grenze
78	LDFPTK	☐	NALDFPTK	NUMC08	NUMC	8	0	IS-H AT: Scoring - Tagesanteil der LDF-Punkte
79	LDFPLK	☐	NALDFPLK	NUMC08	NUMC	8	0	IS-H AT: Scoring - Leistungsanteil der LDF-Punkte
80	SCUTK	☐	NASCUTK	NUMC08	NUMC	8	0	IS-H AT: Scoring - Belagsdauer-Ausreißer unten, Tagesanteil
81	SCULK	☐	NASCULK	NUMC08	NUMC	8	0	IS-H AT: Scoring- Bel.dauer-Ausreißer unten Leistungsanteil
82	BDZU	☐	NABDZU	NUMC08	NUMC	8	0	IS-H AT: Scoring - Belagsdauer-Ausreißer oben, Zuschläge
83	INTZU	☐	NAINTZU	NUMC08	NUMC	8	0	IS-H AT: Scoring - Intensiv-Zuschläge
84	MELZU	☐	NAMELZU	NUMC08	NUMC	8	0	IS-H AT: Scoring - Mehrleistungs-Zuschläge
85	SCSPEZ	☐	NASCSPEZ	NUMC08	NUMC	8	0	IS-H AT: Scoring - Punkte für sonstige Spezialbereiche
86	SCGES	☐	NASCGES	NUMC08	NUMC	8	0	IS-H AT: Scoring - Gesamtpunkte
87	GESBD	☐	NAGESBD	NUMC08	NUMC	8	0	IS-H AT: Scoring - Gesamt-Belagsdauer
88	HD	☐	NAHD	N1C010	CHAR	10	0	IS-H AT: Scoring - Hauptdiagnose
89	AUFNR	☐	FALNR	FALNR	CHAR	10	0	IS-H: Case Number	*
90	GRPBEZ	☐	NAGRBEZ	N1C040	CHAR	40	0	IS-H AT: Scoring - Bezeichnung Gruppencode
91	BDG	☐	NABDG	N1C030	CHAR	30	0	IS-H AT: Scoring - Belagsdauer-Grenze
92	BDA	☐	NABDA	N1C030	CHAR	30	0	IS-H AT: Scoring - Belagsdauer-Ausreißer
93	KHDIA_NEW	☐	KZ_KHHPD	XFELD	CHAR	1	0	IS-H: Hospital Main Diagnosis Indicator
94	ORGFA	☐	ISH_ORGFA	ORGID	CHAR	8	0	IS-H: Org. Unit with Departmental Assignment Authority	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RNWATSCO_DIA	BELNR	NKSK	BELNR
2	RNWATSCO_DIA	DIAGW	TN26C	DIASI
3	RNWATSCO_DIA	DIALO	TN26E	DIALO
4	RNWATSCO_DIA	DIAPE	NGPA	GPART
5	RNWATSCO_DIA	DIAPR	TN26B	DIAPR
6	RNWATSCO_DIA	DIAZS	TN26D	DIAZS
7	RNWATSCO_DIA	DKAT1	TNK00	KATID
8	RNWATSCO_DIA	DKAT2	TNK00	KATID
9	RNWATSCO_DIA	DKAT_REF	TNK00	KATID
10	RNWATSCO_DIA	DKEY1	NKDI	DKEY
11	RNWATSCO_DIA	DKEY2	NKDI	DKEY
12	RNWATSCO_DIA	DKEY_REF	NKDI	DKEY
13	RNWATSCO_DIA	EINRI	TN01	EINRI
14	RNWATSCO_DIA	FALNR	NFAL	FALNR
15	RNWATSCO_DIA	LFDBEW	NBEW	LFDNR
16	RNWATSCO_DIA	MANDT	T000	MANDT

History

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