SAP ABAP Table ICL_DIAGNOSIS (Used for Processing Individual Diagnoses)

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_DIAGNOSIS	Table Relationship Diagram
Short Description	Used for Processing Individual Diagnoses

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	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	ACTIVE	☐	ICL_ACTIVE	ICL_ACTIVE	CHAR	1	0	Table entry is active (A) or in suspense (S)
3	CLAIM	☐	ICL_CLAIM	ICL_CLAIM	CHAR	17	0	Number of Claim	*
4	PATIENT	☑	ICL_DAMOBJBI	ICL_DAMOBJ	NUMC	4	0	Injured Person	*
5	SUBOBJCAT	☐	ICL_SUBOBJCAT	ICL_SUBOBJCAT	CHAR	2	0	Claim Subobject Category	*
6	SUBOBJECT	☐	ICL_SUBOBJECTD	ICL_SUBOBJECTD	CHAR	3	0	Damaged Objects Occurrence Subobject
7	DIAGNO	☑	ICL_DIAGNO	ICL_DIAGNO	CHAR	3	0	Sequence Number of Diagnosis Within A Case
8	.INCLUDE	☐				0	0	Shadow Tables Versioning: Include for Original Table
9	CHANGETIME	☐	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
10	CHANGEDBY	☐	ICL_CHANGEDBY	XUBNAME	CHAR	12	0	Changed By	USR02
11	DELETED	☐	ICL_RECSTATUS	ICL_RECSTATUS	CHAR	1	0	Database Line Status (Original, Changed, Deleted)
12	CATANAME1	☐	ICL_CATANAME	TEXT40	CHAR	40	0	Long Name of a Diagnosis Catalog
13	CATAID1	☐	ICL_CATAID	ICL_CATAID	CHAR	4	0	Catalog Code	*
14	DIAGNAME1	☐	ICL_DIAGNAME_SHORT	TEXT30	CHAR	30	0	Short Name for Diagnosis in Diagnosis Catalog
15	DIAGID1	☐	ICL_PRIMDIAGID	ICL_DIAGID	CHAR	10	0	Primary Diagnosis	*
16	DIAGNAME1_MEDIUM	☐	ICL_DIAGNAME_MEDIUM	TEXT60	CHAR	60	0	Medium-Length Name of Diagnosis in Diagnosis Catalog
17	DIAGNAME1_LONG	☐	ICL_DIAGNAME	TEXT240	CHAR	240	0	Long Name of Diagnosis in Diagnosis Catalog
18	CATANAME2	☐	ICL_CATANAME	TEXT40	CHAR	40	0	Long Name of a Diagnosis Catalog
19	CATAID2	☐	ICL_CATAID	ICL_CATAID	CHAR	4	0	Catalog Code	*
20	DIAGNAME2	☐	ICL_DIAGNAME_SHORT	TEXT30	CHAR	30	0	Short Name for Diagnosis in Diagnosis Catalog
21	DIAGID2	☐	ICL_SECDIAGID	ICL_DIAGID	CHAR	10	0	Secondary Diagnosis	*
22	DIAGNAME2_MEDIUM	☐	ICL_DIAGNAME_MEDIUM	TEXT60	CHAR	60	0	Medium-Length Name of Diagnosis in Diagnosis Catalog
23	DIAGNAME2_LONG	☐	ICL_DIAGNAME	TEXT240	CHAR	240	0	Long Name of Diagnosis in Diagnosis Catalog
24	DESCRIPTION	☐	ICL_DESCRIPTION	TEXT50	CHAR	50	0	Diagnosis Description
25	ENDDATE	☐	ICL_ENDDATE	DATUM	DATS	8	0	End Date
26	DIAGSRCCAT	☐	ICL_PDOCCAT	ICL_PDOCCAT	CHAR	2	0	Claim Item Grouping Category	*
27	DIAGSRCID	☐	ICL_DIAGSRCID	ICL_DIAGSRCID	CHAR	20	0	Diagnosis Source ID	*
28	DIAGTYPE	☐	ICL_DIAGTYPE	ICL_DIAGTYPE	CHAR	2	0	Diagnosis Type	*
29	DIAGTYPEN	☐	ICL_DIAGTYPENAME	TEXT40	CHAR	40	0	Name of Diagnosis Type
30	LOCNAME	☐	ICL_LOCNAME	TEXT20	CHAR	20	0	Name of Side Localization of a Diagnosis
31	LOCALIZATION	☐	ICL_LOCALIZATION	ICL_LOCALIZATION	CHAR	1	0	Side Localization of a Diagnosis	*
32	SEVERITY	☐	ICL_SEVERITYCODE	ICL_SEVERITYCODE	CHAR	1	0	Severity of Diagnosis	*
33	SEVNAME	☐	ICL_NAMESEVERITY	TEXT30	CHAR	30	0	Severity Name
34	MORPHOLOGY	☐	ICL_MORPHOLOGY	ICL_MORPHOLOGY	CHAR	7	0	Morphology	*
35	MORPHNAME	☐	ICL_MORPHNAME	TEXT50	CHAR	50	0	Morphology Name
36	EXCORIATION	☐	ICL_EXCORIATION	ICL_EXCORIATION	CHAR	5	0	Excoriation	*
37	EXCORINAME	☐	ICL_EXCORINAME	TEXT30	CHAR	30	0	Name for Excoriation
38	GUARANTEE	☐	ICL_GUARANTEE	ICL_GUARANTEE	CHAR	1	0	Diagnostic Certainty	*
39	GUARANAME	☐	ICL_GUARANAME	TEXT60	CHAR	60	0	Name of Diagnostic Certainty
40	DEPARTMENT	☐	ICL_DEPARTMENT	ICL_DEPARTMENT	CHAR	4	0	Department (Key)	*
41	DEPARTNAME	☐	ICL_DEPARTNAME	TEXT60	CHAR	60	0	Name of Department
42	DIAGGROUPID	☐	ICL_DIAGGROUPID	ICL_DIAGGROUPID	CHAR	10	0	Diagnosis Group	*
43	DIAGGROUPNAME	☐	ICL_DIAGGROUPNAME	TEXT50	CHAR	50	0	Name of Diagnosis Group
44	DIAGORDER	☐	ICL_DIAGORDER		NUMC	3	0	Sequence of Diagnoses
45	LOCALIZATION2	☐	ICL_LOCALIZATION2	ICL_LOCALIZATION	CHAR	1	0	Localization 2	TICL352
46	LOCNAME2	☐	ICL_LOCNAME2	TEXT20	CHAR	20	0	Name of Side Localization of Diagnosis 2
47	USED4CALC	☐	ICL_USED4CALC		CHAR	1	0	Used for Grouping
48	ASSIGN_GUID	☐	ICL_ASSIGN_GUID	SYSUUID_C	CHAR	32	0	UUID of Entry to be Linked

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICL_DIAGNOSIS	CHANGEDBY	USR02	BNAME
2	ICL_DIAGNOSIS	LOCALIZATION2	TICL352	LOCALIZATION	KEY	1	CN

History

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