SAP ABAP Table NDRG (IS-H: Table Containing Case-Related DRGs)

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	TRANSP	Transparent table
Transparent table	NDRG	Table Relationship Diagram
Short Description	IS-H: Table Containing Case-Related DRGs

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	INSTITUTION	☑	EINRI	EINRI	CHAR	4	0	IS-H: Institution	TN01
3	PATCASEID	☑	FALNR	FALNR	CHAR	10	0	IS-H: Case Number	NFAL
4	DRG_SEQNO	☑	ISH_DRG_SEQ_NB	ISH_DRG_NB_TYPE	NUMC	3	0	Sequence Number of a Case-Related DRG
5	DRG_CODE	☐	ISH_DRG_CODE	TARLS	CHAR	10	0	IS-H: DRG Code	*
6	MDC_CODE	☐	ISH_MDC_CODE	DIAID	CHAR	30	0	IS-H: Code of Major Diagnostic Category (MDC)	NKDI
7	DRG_CAT	☐	ISH_DRG_CAT	TARID	CHAR	2	0	IS-H: DRG Catalog Used for Coding	TNK01
8	SOI	☐	ISH_DRG_SOI	ISH_DRG_SOI_TYPE	CHAR	1	0	IS-H: Severity of Illness (for DRG Purposes)	TN15I
9	ROM	☐	ISH_DRG_ROM	ISH_DRG_ROM_TYPE	CHAR	1	0	IS-H: Risk of Mortality (for DRG Purposes)	TN15J
10	DRG_COMMENT	☐	ISH_DRG_COMMENT	TEXT50	CHAR	50	0	IS-H: Comment on DRG
11	DRG_REGROUP	☐	ISH_DRG_REGROUP_ADVISE	ISH_ON_OFF	CHAR	1	0	IS-H: Regrouping Advised
12	DRG_CREAT_DATE	☐	ISH_DRG_DATE	RI_DATUM	DATS	8	0	Date when DRG Was Determined
13	DRG_CREAT_TIME	☐	ISH_DRG_TIME	UHRZT	TIMS	6	0	Time when DRG Was Determined
14	GROUPING_USER	☐	ISH_GROUPING_USER	TEXT50	CHAR	50	0	IS-H: Information on Operation of DRG System
15	CREATION_DATE	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
16	CREATION_TIME	☐	ISH_ERTIM	UHRZT	TIMS	6	0	IS-H: Time when Data Record Created
17	CREATION_USER	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
18	UPDATE_DATE	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
19	UPDATE_TIME	☐	ISH_UPTIM	UHRZT	TIMS	6	0	IS-H: Time Data Record was Last Changed
20	UPDATE_USER	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
21	CANCEL_DATE	☐	STORNO_DAT	RI_DATUM	DATS	8	0	IS-H: Cancellation Date
22	CANCEL_TIME	☐	ISH_CANTIM	UHRZT	TIMS	6	0	IS-H: Time Data Record Canceled
23	CANCEL_USER	☐	STORN_USER	USNAM	CHAR	12	0	IS-H: Name of User who Canceled Data Record
24	CANCEL_REASON	☐	ISH_CANREASON	ISH_CANREASON_TYPE	CHAR	2	0	IS-H: Reason for Cancellation
25	CANCEL_FLAG	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
26	MDC_CAT	☐	ISH_MDC_CAT	KATID	CHAR	2	0	IS-H: Catalog for Major Diagnostic Category (MDC)	TNK00
27	COST_WEIGHT	☐	ISH_COST_WEIGHT	DEC4_5	DEC	9	5	IS-H: Cost Weight for DRGs
28	TIMESTAMP	☐	ISH_TIMESTAMP	TZNTSTMPS	DEC	15	0	IS-H: Time Stamp in Short Form (YYYYMMDDhhmmss)
29	DRG_CREAT_USER	☐	ISH_DRG_USER	USNAM	CHAR	12	0	User who Created the Current DRG
30	CHARGE_CATEGORY	☐			CHAR	2	0
31	DRG_REGROUP_RS	☐	ISH_DRG_REGROUP_REASON	ISH_DRG_REGROUP_REASON	CHAR	2	0	Reason for Reclassification
32	COSTW_TYPE	☐	ISH_COSTW_TYPE	ISH_COSTW_TYPE	NUMC	2	0	Category for Calculating Effective Cost Weight
33	SPLG_CODE	☐	ISH_SPLG_CODE	DIAID	CHAR	30	0	Code of a Hospital Planning Service Group (HPSG)	NKDI
34	SPLG_CAT	☐	ISH_SPLG_CAT	KATID	CHAR	2	0	Catalog of a Hospital Planning Service Group	TNK00

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	NDRG	CLIENT	T000	MANDT
2	NDRG	DRG_CAT	TNK01	KATID
3	NDRG	INSTITUTION	TN01	EINRI
4	NDRG	MDC_CAT	TNK00	KATID
5	NDRG	MDC_CODE	NKDI	DKEY
6	NDRG	PATCASEID	NFAL	FALNR
7	NDRG	ROM	TN15J	ROM
8	NDRG	SOI	TN15I	SOI
9	NDRG	SPLG_CAT	TNK00	KATID
10	NDRG	SPLG_CODE	NKDI	DKEY

History

Last changed by/on	SAP	20131127
SAP Release Created in