SAP ABAP Table VNAPX_DRG (IS-H: Verbuchungsstruktur Appendix - DRG-Daten)

Hierarchy

☛ IS-H (Software Component) SAP Healthcare
   ⤷ IS-H (Application Component) SAP Healthcare - Industry-Specific Components for Hospitals
     ⤷ NDE1 (Package) IS-H: Landesversion Deutschland

Basic Data

Table Category	INTTAB	Structure
Structure	VNAPX_DRG	Table Relationship Diagram
Short Description	IS-H: Verbuchungsstruktur Appendix - DRG-Daten

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: Appendix DRG-Tabelle
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	APXNR	☐	APXNR	APXNR	CHAR	10	0	IS-H: Appendixnummer	NAPX
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)
7	DRG_CAT	☐	ISH_DRG_CAT	TARID	CHAR	2	0	IS-H: DRG Catalog Used for Coding	*
8	SOI	☐	ISH_DRG_SOI	ISH_DRG_SOI_TYPE	CHAR	1	0	IS-H: Severity of Illness (for DRG Purposes)	*
9	ROM	☐	ISH_DRG_ROM	ISH_DRG_ROM_TYPE	CHAR	1	0	IS-H: Risk of Mortality (for DRG Purposes)	*
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)
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	COSTW_TYPE	☐	ISH_COSTW_TYPE	ISH_COSTW_TYPE	NUMC	2	0	Category for Calculating Effective Cost Weight
30	.INCLUDE	☐				0	0	Structures for generating change document update programs
31	KZ	☐	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VNAPX_DRG	APXNR	NAPX	APXNR	KEY	1	CN

History

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