SAP ABAP Table NBWD_0HC_DIAGNOSES_DELTA (IS-H: Extract Struct.for DataSource Diagn.(Delta-Enabled) BW)

Hierarchy

☛ IS-H (Software Component) SAP Healthcare
   ⤷ IS-H-IS (Application Component) Information System
     ⤷ NBWD (Package) IS-H: Data Sources for Business Information Warehouse

Basic Data

Table Category	INTTAB	Structure
Structure	NBWD_0HC_DIAGNOSES_DELTA	Table Relationship Diagram
Short Description	IS-H: Extract Struct.for DataSource Diagn.(Delta-Enabled) BW

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	GJVAR	☐	RSFISCVAR	RSFISCVAR	CHAR	2	0	Fiscal year variant
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution	*
4	FALNR	☐	FALNR	FALNR	CHAR	10	0	IS-H: Case Number	*
5	LFDNR	☐	LFDDIA	LFDDIA	NUMC	3	0	IS-H: Sequence Number of Diagnosis
6	LFDBEW	☐	LFDBEW	LFDBEW	NUMC	5	0	IS-H: Sequence Number of Movement	*
7	DKAT1	☐	DIAKAT	KATID	CHAR	2	0	IS-H: Identification Key of Diagnosis Coding Catalog
8	DKEY1	☐	DIAID	DIAID	CHAR	30	0	IS-H: Diagnosis Code
9	DKAT2	☐	DIAKAT	KATID	CHAR	2	0	IS-H: Identification Key of Diagnosis Coding Catalog
10	DKEY2	☐	DIAID	DIAID	CHAR	30	0	IS-H: Diagnosis Code
11	DKAT_REF	☐	REF_DIAKAT	KATID	CHAR	2	0	IS-H: Catalog ID of Reference Catalog for Statistics
12	DKEY_REF	☐	REF_DIAID	DIAID	CHAR	30	0	IS-H: Reference Diagnosis Code for Statistics
13	DIADT	☐	DIADT	RI_DATUM	DATS	8	0	IS-H: Date on which Diagnosis Was Created
14	DIAZT	☐	DIAZT	UHRZT	TIMS	6	0	IS-H: Time at which Diagnosis Created
15	DIAPE	☐	DIA_PERS	RI_KUNNR	CHAR	10	0	IS-H: Identification of Diagnosing Person	*
16	ANZOP	☐	ANZOP	NUM02	NUMC	2	0	IS-H: Number of Surgeries Occasioned by Dept. Main Diagnosis
17	EWDIA	☐	KZ_EINWD	XFELD	CHAR	1	0	IS-H: Referral Diagnosis Indicator
18	BHDIA	☐	KZ_BEHLD	XFELD	CHAR	1	0	IS-H: Treatment Diagnosis Indicator
19	AFDIA	☐	KZ_AUFND	XFELD	CHAR	1	0	IS-H: Admission Diagnosis Indicator
20	ENDIA	☐	KZ_ENTLD	XFELD	CHAR	1	0	IS-H: "Discharge Diagnosis" Indicator
21	FHDIA	☐	KZ_FAHPD	XFELD	CHAR	1	0	IS-H: "Department Main Diagnosis" Indicator
22	KHDIA	☐	KZ_KHHPD	XFELD	CHAR	1	0	IS-H: Hospital Main Diagnosis Indicator
23	OPDIA	☐	KZ_OPERD	XFELD	CHAR	1	0	IS-H: Surgery Diagnosis Indicator
24	SPERR	☐	RI_SPERR	XFELD	CHAR	1	0	Blocking Indicator
25	DIASI	☐	DIASI	DIASI	CHAR	1	0	IS-H: Diagnostic Certainty
26	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
27	ERTIM	☐	RI_ERTIM	UHRZT	TIMS	6	0	IS-H: Time Record Created
28	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
29	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
30	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
31	ARDIA	☐	N2_KZARDIA	XFELD	CHAR	1	0	Working Diagnosis Indicator
32	PODIA	☐	N2_KZPODIA	XFELD	CHAR	1	0	Preoperative Diagnosis Indicator
33	TUDIA	☐	N2_KZTUDIA	XFELD	CHAR	1	0	IS-H: Cause of Death Indicator
34	DIABZ	☐	N2_DIABZ	XFELD	CHAR	1	0	Diagnosis Reference
35	DIAPR	☐	N2_DIAPR	N2_DIAPR	CHAR	1	0	Medical Secondary Diagnosis Indicator	*
36	DIAGW	☐	N2_DIASI	N2_DIASI	CHAR	2	0	Diagnostic Certainty	*
37	DIAZS	☐	N2_DIAZS	N2_DIAZS	CHAR	2	0	Diagnostic Suppl.	*
38	DIALO	☐	N2_DIALO	N2_DIALO	CHAR	2	0	IS-H: Localization of Diagnosis	*
39	EXTID	☐	N2_EXTID	N2_EXTID	CHAR	8	0	Internal Identifier of the Diagnosis Coding Tool
40	DIAFP	☐	N2_DIAFP	N2_DIAFP	CHAR	8	0	Flat Rate per Case
41	REFKY	☐	DIA_REFKEY	ISH_REFKY	CHAR	20	0	IS-H: Reference Code of Diagnosis from External System
42	DRG_DIA_SEQNO	☐	ISH_DRG_DIA_NB	LFD_NR_DRG_DIA	NUMC	6	0	IS-H: Consecutive Numbering of DRG Diagnosis
43	DRG_CATEGORY	☐	ISH_DRG_DIA_CATEGORY	ISH_DRG_DIA_CAT_TYPE	CHAR	1	0	IS-H: Category of DRG Diagnosis (Principal, Secondary)
44	DRG_CC	☐	ISH_DRG_DIA_CC	ISH_ON_OFF	CHAR	1	0	IS-H: Comorbidity and Complication (DRG Diagnosis)
45	DRG_RELVANT	☐	ISH_DRG_DIA_RELEVANT	ISH_ON_OFF	CHAR	1	0	IS-H: Used to Determine DRG
46	DTYP1	☐	ISH_ICD10_DIATYP	ISH_DIATYP	CHAR	1	0	Type for ICD-10 Diagnoses
47	DTYP2	☐	ISH_ICD10_DIATYP	ISH_DIATYP	CHAR	1	0	Type for ICD-10 Diagnoses
48	DTYP_REF	☐	ISH_ICD10_DIATYP	ISH_DIATYP	CHAR	1	0	Type for ICD-10 Diagnoses
49	DIA_LINK	☐	ISH_DIA_LINK	LFDDIA	NUMC	3	0	IS-H: Link to Another Diagnosis
50	CCL	☐	ISH_CCL	ISH_CCL_TYPE	NUMC	3	0	IS-H: Complication Level of Diagnoses (for DRGs)
51	COUNTER	☐	ISH_CNT_BW		DEC	17	3	IS-H: Counter for BW Extractors (Without Unit of Measure)
52	STORN	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
53	DRG_DIASEQNO_APX	☐	ISH_DRG_DIA_NB	LFD_NR_DRG_DIA	NUMC	6	0	IS-H: Consecutive Numbering of DRG Diagnosis
54	DRG_CATEGORY_APX	☐	ISH_DRG_DIA_CATEGORY	ISH_DRG_DIA_CAT_TYPE	CHAR	1	0	IS-H: Category of DRG Diagnosis (Principal, Secondary)
55	DRG_RELEVANT_APX	☐	ISH_DRG_DIA_RELEVANT	ISH_ON_OFF	CHAR	1	0	IS-H: Used to Determine DRG
56	CCL_APX	☐	ISH_CCL	ISH_CCL_TYPE	NUMC	3	0	IS-H: Complication Level of Diagnoses (for DRGs)
57	QUALF	☐	ISH_DIA_QUALF	ISH_DIA_QUALF	CHAR	5	0	Diagnosis Qualifier	*
58	DRG_IMPACT	☐	ISH_DIA_DRG_IMPACT	ISH_DRG_IMPACT	CHAR	2	0	Impact of Diagnosis on DRG Determination

History

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