SAP ABAP View BW_HC_DRG (IS-H: View for BW Insurance Provider per Service)

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

View Type	D	Database View
Database View	BW_HC_DRG
Short Description	IS-H: View for BW Insurance Provider per Service
Root table	NDRG	IS-H: Table Containing Case-Related DRGs

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	NDRG	NDRG

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	NDRG	CLIENT		☐	MANDT	☐	Client
2	INSTITUTION	NDRG	INSTITUTION		☐	EINRI	☐	IS-H: Institution
3	PATCASEID	NDRG	PATCASEID		☐	FALNR	☐	IS-H: Case Number
4	DRG_CODE	NDRG	DRG_CODE		☐	ISH_DRG_CODE	☐	IS-H: DRG Code
5	MDC_CODE	NDRG	MDC_CODE		☐	ISH_MDC_CODE	☐	IS-H: Code of Major Diagnostic Category (MDC)
6	DRG_CAT	NDRG	DRG_CAT		☐	ISH_DRG_CAT	☐	IS-H: DRG Catalog Used for Coding
7	SOI	NDRG	SOI		☐	ISH_DRG_SOI	☐	IS-H: Severity of Illness (for DRG Purposes)
8	DRG_REGROUP	NDRG	DRG_REGROUP		☐	ISH_DRG_REGROUP_ADVISE	☐	IS-H: Regrouping Advised
9	DRG_CREAT_DATE	NDRG	DRG_CREAT_DATE		☐	ISH_DRG_DATE	☐	Date when DRG Was Determined
10	DRG_CREAT_TIME	NDRG	DRG_CREAT_TIME		☐	ISH_DRG_TIME	☐	Time when DRG Was Determined
11	GROUPING_USER	NDRG	GROUPING_USER		☐	ISH_GROUPING_USER	☐	IS-H: Information on Operation of DRG System
12	CREATION_DATE	NDRG	CREATION_DATE		☐	RI_ERDAT	☐	IS-H: Date when Record Created
13	CREATION_TIME	NDRG	CREATION_TIME		☐	ISH_ERTIM	☐	IS-H: Time when Data Record Created
14	CREATION_USER	NDRG	CREATION_USER		☐	RI_ERNAM	☐	IS-H: Name of Employee who Created Record
15	UPDATE_DATE	NDRG	UPDATE_DATE		☐	RI_UPDAT	☐	IS-H: Date of Last Change
16	UPDATE_TIME	NDRG	UPDATE_TIME		☐	ISH_UPTIM	☐	IS-H: Time Data Record was Last Changed
17	UPDATE_USER	NDRG	UPDATE_USER		☐	RI_UPNAM	☐	IS-H: Name of Person who Last Changed Data
18	MDC_CAT	NDRG	MDC_CAT		☐	ISH_MDC_CAT	☐	IS-H: Catalog for Major Diagnostic Category (MDC)
19	COST_WEIGHT	NDRG	COST_WEIGHT		☐	ISH_COST_WEIGHT	☐	IS-H: Cost Weight for DRGs

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

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