ICLDRGITEM

DRG Item | #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
SUBCLAIM FK Subclaim
ITEM Claim Item
Column Name Description
💲 Currency of Evaluated Amount (CURR):
AMOUNT DRG Amount
ADDITIONALAMOUNT Additional DRG Amount
Column Name Description
📏 Unit of Mechanical Ventilation Duration (EVQUANUNIT):
EVQUANTITY Duration of Mechanical Ventilation
Column Name Description
Column Name Description
ACTIVE Table entry is active (A) or in suspense (S) Show values
DELETED Database Line Status (Original, Changed, Deleted) Show values
XWAITPERIOD Probationary Periods Ignored Show values
STATUS Status of Claim Item Show values
MODIFIED Modified Show values
PROCURED Ordered Show values
CALCULATED Calculated Show values
Column Name Description Domain name
CHANGETIME Changed: Date + Time ICL_TIMESTAMP
COVTYPE Coverage Type ICL_COVTYPE
BENTYPE Benefit Type ICL_BENTYPE
RCOVTYPE Benefit Coverage Type ICL_COVTYPE
COVERAGE Coverage ICL_POLM
SCPOSID_INT Internal ID of Benefits Catalog Item SYSUUID_C
SCPOSID_EXT Item in Catalog of Diagnosis Related Group (DRG) ICL_SERVCAT_POSID
REJREASON Claim Item Rejection Reason ICL_REJREASON
NOTE Note for Diagnosis Related Groups
AMOUNTDAYS Number of Days for DRG Calculation (Markdown/Markup) ICL_DRG_AMOUNTDAYS_D_PE
ITEM_REF Claim Item ICL_SCLITEM
Master Data Relations Join Conditions
Catalog of Major Diagnostic Category (MDC)
  • Catalog of Major Diagnostic Category (MDC)
  • Client
  • ICLDRGITEM.CATAID == TICL350.CATAID
  • ICLDRGITEM.CLIENT == TICL350.CLIENT
Changed By
  • ICLDRGITEM.CLIENT == USR02.MANDT
  • ICLDRGITEM.CHANGEDBY == USR02.BNAME
Client ICLDRGITEM.CLIENT == T000.MANDT
Currency of Evaluated Amount
  • ICLDRGITEM.CLIENT == TCURC.MANDT
  • ICLDRGITEM.CURR == TCURC.WAERS
Catalog Item of Major Diagnostic Category (MDC)
  • Catalog Item of Major Diagnostic Category (MDC)
  • Catalog of Major Diagnostic Category (MDC)
  • ICLDRGITEM.CLIENT == TICL351.CLIENT
  • ICLDRGITEM.DIAGID == TICL351.DIAGID
  • ICLDRGITEM.CATAID == TICL351.CATAID
Remuneration Category
Remuneration Category
Catalog of Diagnosis Related Group (DRG)
  • Catalog of Diagnosis Related Group (DRG)
  • Client
  • ICLDRGITEM.SERVCAT == TICL401.SERVCATID
  • ICLDRGITEM.CLIENT == TICL401.CLIENT