ICSDIAGNOSIS

Diagnoses | #transactional | Component: Claims Management
Column Name Description
CLIENT FK Client
ACTIVE Table entry is active (A) or in suspense (S) Show values
CLAIM FK Number of Claim
PATIENT FK Injured Person
SUBOBJCAT FK Claim Subobject Category
SUBOBJECT Damaged Objects Occurrence Subobject
DIAGNO Sequence Number of Diagnosis Within A Claim
CHANGETIME Changed: Date + Time
Column Name Description
Column Name Description
Column Name Description
ENDDATE End Date
_DATAAGING Data Filter Value for Data Aging
Column Name Description
ACTIVE Table entry is active (A) or in suspense (S) Show values
DELETED Database Line Status (Original, Changed, Deleted) Show values
Column Name Description Domain name
DIAGNOPARENT Diagnosis Number (Numerical) - Obsolete ICL_DIAGNO_OLD
DESCRIPTION Diagnosis Description TEXT50
DIAGSRCID Diagnosis Source ID ICL_DIAGSRCID
DIAGORDER Diagnosis Sequence
USED4CALC Used for Grouping
ASSIGN_GUID UUID of Entry to be Linked SYSUUID_C
Master Data Relations Join Conditions
Catalog Code
  • Catalog Code
  • Client
  • ICSDIAGNOSIS.CATAID1 == TICL350.CATAID
  • ICSDIAGNOSIS.CLIENT == TICL350.CLIENT
Catalog Code
  • Catalog Code
  • Client
  • ICSDIAGNOSIS.CATAID2 == TICL350.CATAID
  • ICSDIAGNOSIS.CLIENT == TICL350.CLIENT
Changed By
  • ICSDIAGNOSIS.CLIENT == USR02.MANDT
  • ICSDIAGNOSIS.CHANGEDBY == USR02.BNAME
Client ICSDIAGNOSIS.CLIENT == T000.MANDT
Department (Key)
  • ICSDIAGNOSIS.CLIENT == TICL364.CLIENT
  • ICSDIAGNOSIS.DEPARTMENT == TICL364.DEPARTMENT
Primary Diagnosis
  • Primary Diagnosis
  • Catalog Code
  • ICSDIAGNOSIS.CLIENT == TICL351.CLIENT
  • ICSDIAGNOSIS.DIAGID1 == TICL351.DIAGID
  • ICSDIAGNOSIS.CATAID1 == TICL351.CATAID
Secondary Diagnosis
  • Secondary Diagnosis
  • Catalog Code
  • ICSDIAGNOSIS.CLIENT == TICL351.CLIENT
  • ICSDIAGNOSIS.DIAGID2 == TICL351.DIAGID
  • ICSDIAGNOSIS.CATAID2 == TICL351.CATAID
Claim Item Grouping Category
  • Claim Item Grouping Category
  • Client
  • ICSDIAGNOSIS.DIAGSRCCAT == TICL138.PDOCCAT
  • ICSDIAGNOSIS.CLIENT == TICL138.CLIENT
Diagnosis Type
  • ICSDIAGNOSIS.CLIENT == TICL360.CLIENT
  • ICSDIAGNOSIS.DIAGTYPE == TICL360.DIAGTYPE
Excoriation
  • ICSDIAGNOSIS.CLIENT == TICL358.CLIENT
  • ICSDIAGNOSIS.EXCORIATION == TICL358.EXCORIATION
Diagnostic Certainty
  • Diagnostic Certainty
  • Client
  • ICSDIAGNOSIS.GUARANTEE == TICL363.GUARANTEE
  • ICSDIAGNOSIS.CLIENT == TICL363.CLIENT
Side Localization of a Diagnosis
  • Side Localization of a Diagnosis
  • Client
  • ICSDIAGNOSIS.LOCALIZATION == TICL352.LOCALIZATION
  • ICSDIAGNOSIS.CLIENT == TICL352.CLIENT
Localization 2
  • Localization 2
  • Client
  • ICSDIAGNOSIS.LOCALIZATION2 == TICL352.LOCALIZATION
  • ICSDIAGNOSIS.CLIENT == TICL352.CLIENT
Morphology
  • ICSDIAGNOSIS.CLIENT == TICL356.CLIENT
  • ICSDIAGNOSIS.MORPHOLOGY == TICL356.MORPHOLOGY
Severity of Diagnosis
  • ICSDIAGNOSIS.CLIENT == TICL354.CLIENT
  • ICSDIAGNOSIS.SEVERITYCODE == TICL354.SEVERITY
Claim Subobject Category
  • Claim Subobject Category
  • Client
  • ?
  • ICSDIAGNOSIS.SUBOBJCAT == TICL013.SUBOBJCAT
  • ICSDIAGNOSIS.CLIENT == TICL013.CLIENT
  • ICSDIAGNOSIS.[column in domain "ICL_PARTOBJCAT"] == TICL013.OBJCAT