SAP ABAP Table ICL_DRGITEM_S_UI (DRG)

Hierarchy

☛ INSURANCE (Software Component) SAP Insurance
   ⤷ FS-CM (Application Component) Claims Management
     ⤷ ICL_HEALTH (Package) FS-CM: Health Line of Insurance

Basic Data

Table Category	INTTAB	Structure
Structure	ICL_DRGITEM_S_UI	Table Relationship Diagram
Short Description	DRG

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	DRG
2	.INCLUDE	☐				0	0	DRG
3	.INCLUDE	☐				0	0	DRG Item
4	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
5	ACTIVE	☐	ICL_ACTIVE	ICL_ACTIVE	CHAR	1	0	Table entry is active (A) or in suspense (S)
6	CLAIM	☐	ICL_CLAIM	ICL_CLAIM	CHAR	17	0	Number of Claim	ICLCLAIM
7	SUBCLAIM	☐	ICL_SUBCL	ICL_SUBCL	CHAR	3	0	Subclaim	ICLSUBCL
8	ITEM	☐	ICL_SCLITEM	ICL_SCLITEM	CHAR	4	0	Claim Item	*
9	.INCLUDE	☐				0	0	Shadow Tables Versioning: Include for Original Table
10	CHANGETIME	☐	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
11	CHANGEDBY	☐	ICL_CHANGEDBY	XUBNAME	CHAR	12	0	Changed By	USR02
12	DELETED	☐	ICL_RECSTATUS	ICL_RECSTATUS	CHAR	1	0	Database Line Status (Original, Changed, Deleted)
13	.INCLUDE	☐				0	0	Attributes of ICLDRGITEM
14	.INCLUDE	☐				0	0	Claim Item - Fields for Coverage Check
15	COVTYPE	☐	ICL_COVTYPE	ICL_COVTYPE	CHAR	10	0	Coverage Type	*
16	BENTYPE	☐	ICL_BENTYPE	ICL_BENTYPE	CHAR	10	0	Benefit Type	*
17	RCOVTYPE	☐	ICL_RCOVTYPE	ICL_COVTYPE	CHAR	10	0	Benefit Coverage Type	*
18	XWAITPERIOD	☐	ICL_XWAITPERIOD	XFELD	CHAR	1	0	Probationary Periods Ignored
19	COVERAGE	☐	ICL_POLM	ICL_POLM	CHAR	4	0	Coverage	*
20	.INCLUDE	☐				0	0	FS-CM: Benefits/Services/Fees Catalogs in ICLITEM
21	SCPOSID_INT	☐	ICL_SERVCAT_POSID_INT	SYSUUID_C	CHAR	32	0	Internal ID of Benefits Catalog Item
22	SERVCAT	☐	ICL_SERVCATID_DRG	ICL_SERVCATID	CHAR	10	0	Catalog of Diagnosis Related Group (DRG)	TICL401
23	SCPOSID_EXT	☐	ICL_SERVCAT_POSID_DRG	ICL_SERVCAT_POSID	CHAR	20	0	Item in Catalog of Diagnosis Related Group (DRG)
24	.INCLUDE	☐				0	0	Claim Items - Status Fields
25	STATUS	☐	ICL_SCLITEMS	ICL_SCLITEMS	CHAR	2	0	Status of Claim Item
26	REJREASON	☐	ICL_REJREASON	ICL_REJREASON	CHAR	2	0	Claim Item Rejection Reason	*
27	MODIFIED	☐	ICL_MODIFIED	XFELD	CHAR	1	0	Modified
28	PROCURED	☐	ICL_PROCURED	XFELD	CHAR	1	0	Ordered
29	CALCULATED	☐	ICL_CALCULATED	XFELD	CHAR	1	0	Calculated
30	CATAID	☐	ICL_MDCCATAID	ICL_CATAID	CHAR	4	0	Catalog of Major Diagnostic Category (MDC)	TICL350
31	DIAGID	☐	ICL_MDCPOSID	ICL_DIAGID	CHAR	10	0	Catalog Item of Major Diagnostic Category (MDC)	TICL351
32	SEVERITY_CODE	☐	ICL_DRG_SEVERITYCODE	ICL_DRG_SEVERITYCODE_D_PE	CHAR	1	0	Severity of Diagnosis Related Group (DRG)	*
33	NOTE	☐	ICL_DRG_NOTE		CHAR	80	0	Note for Diagnosis Related Groups
34	REMUN_TYPE_AM	☐	ICL_REMUN_TYPE_D_PE	ICL_REMUN_TYPE_D_PE	CHAR	4	0	Remuneration Category	ICL_CREMUNTYPE
35	AMOUNT	☐	ICL_DRGAMOUNT_D_PE	ICL_ITAMT	CURR	15	2	DRG Amount
36	REMUN_TYPE_ADDAM	☐	ICL_REMUN_TYPE_D_PE	ICL_REMUN_TYPE_D_PE	CHAR	4	0	Remuneration Category	ICL_CREMUNTYPE
37	ADDITIONALAMOUNT	☐	ICL_DRGADDAMOUNT_D_PE	ICL_ITAMT	CURR	15	2	Additional DRG Amount
38	CURR	☐	ICL_EVCURR	WAERS	CUKY	5	0	Currency of Evaluated Amount	TCURC
39	AMOUNTDAYS	☐	ICL_DRG_AMOUNTDAYS_D_PE	ICL_DRG_AMOUNTDAYS_D_PE	NUMC	3	0	Number of Days for DRG Calculation (Markdown/Markup)
40	ITEM_REF	☐	ICL_SCLITEM	ICL_SCLITEM	CHAR	4	0	Claim Item	*
41	PROCUREMENT	☐	ICL_PROCUREMENT	ICL_PROCUREMENT	NUMC	4	0	ID of Claim Item Grouping	ICLPROCURE
42	.INCLUDE	☐				0	0	Mechanical Ventilation Duration
43	EVQUANTITY	☐	ICL_BREATHINGTIME_D_PE	ICL_LIMAMT	QUAN	10	3	Duration of Mechanical Ventilation
44	EVQUANUNIT	☐	ICL_BREATHINGUNIT_D_PE	MEINS	UNIT	3	0	Unit of Mechanical Ventilation Duration	*
45	SEVERITY_NAME	☐	ICL_DRG_NAMESEVERITY	ICL_DRG_NAMESEVERITY	CHAR	30	0	Name of Severity
46	.INCLUDE	☐				0	0	DRG: Benefits Catalog Texts
47	SERVCATIDSN	☐	ICL_SERVCATNAME_SHORT	TEXT10	CHAR	10	0	Short Name of a Benefits/Services/Fees Catalog
48	SERVCATIDLN	☐	ICL_SERVCATNAME	TEXT30	CHAR	30	0	Name of Benefits/Services/Fee Catalog
49	SCPOSN	☐	ICL_SERVCAT_POS_SHORTNAME	TEXT30	CHAR	30	0	Short Text of a Benefits Catalog Item
50	SCPOSLN	☐	ICL_SERVCAT_POS_NAME	TEXT100	CHAR	100	0	Long Text of Benefits Catalog Item
51	SEASCPOSN	☐	ICL_SERVCAT_POS_SEASHORTNAME	CHAR30	CHAR	30	0	Short Text for Search of a Benefits Catalog Item
52	SEASCPOSLN	☐	ICL_SERVCAT_POS_SEANAME	CHAR100	CHAR	100	0	Long Text for Search for Benefits Catalog Item
53	.INCLUDE	☐				0	0	DRG: Diagnosis Catalog -> MDC Catalog
54	CATANAME_SHORT	☐	ICL_CATANAME_SHORT	TEXT10	CHAR	10	0	Description of Diagnosis Catalog
55	CATANAME	☐	ICL_CATANAME	TEXT40	CHAR	40	0	Long Name of a Diagnosis Catalog
56	DIAGNAME	☐	ICL_DIAGNAME_SHORT	TEXT30	CHAR	30	0	Short Name for Diagnosis in Diagnosis Catalog
57	DIAGNAME_MEDIUM	☐	ICL_DIAGNAME_MEDIUM	TEXT60	CHAR	60	0	Medium-Length Name of Diagnosis in Diagnosis Catalog
58	DIAGNAME_LONG	☐	ICL_DIAGNAME	TEXT240	CHAR	240	0	Long Name of Diagnosis in Diagnosis Catalog

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICL_DRGITEM_S_UI	CATAID	TICL350	CATAID		1	CN
2	ICL_DRGITEM_S_UI	CHANGEDBY	USR02	BNAME
3	ICL_DRGITEM_S_UI	CLAIM	ICLCLAIM	CLAIM
4	ICL_DRGITEM_S_UI	CLIENT	T000	MANDT	KEY	1	CN
5	ICL_DRGITEM_S_UI	CURR	TCURC	WAERS
6	ICL_DRGITEM_S_UI	DIAGID	TICL351	DIAGID		1	CN
7	ICL_DRGITEM_S_UI	PROCUREMENT	ICLPROCURE	PROCUREMENT
8	ICL_DRGITEM_S_UI	REMUN_TYPE_ADDAM	ICL_CREMUNTYPE	REMUN_TYPE	KEY	1	CN
9	ICL_DRGITEM_S_UI	REMUN_TYPE_AM	ICL_CREMUNTYPE	REMUN_TYPE	KEY	1	CN
10	ICL_DRGITEM_S_UI	SERVCAT	TICL401	SERVCATID		1	CN
11	ICL_DRGITEM_S_UI	SUBCLAIM	ICLSUBCL	SUBCLAIM

History

Last changed by/on	SAP	20110901
SAP Release Created in	700