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
⤷ 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 |