ICSDRGITEM SAP table for – DRG Item

Here we would like to draw your attention to ICSDRGITEM table in SAP. As we know it is being mainly used with the SAP FS-CM (Claims Management in FS) component which is coming under FS module (Financial Services). ICSDRGITEM is a SAP standard transp table used for storing DRG Item related data in SAP. It comes under the package ICL_HEALTH.

SAP ICSDRGITEM table

Table ICSDRGITEM technical data

TableICSDRGITEM
Data storingDRG Item
ModuleFS
Sub ModuleFS-CM
SAP PackageICL_HEALTH
Delivery ClassA – Application table (master and transaction data)
ComponentINSURANCE
Table CategoryTRANSP

SAP ICSDRGITEM Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in ICSDRGITEM table.

  • CLIENT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • ACTIVE : Table entry is active (A) or in suspense (S)
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • CLAIM : Number of Claim
    Its a key field. Its data type is CHAR (Character String) with field length 17
  • SUBCLAIM : Subclaim
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • ITEM : Claim Item
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • CHANGETIME : Changed: UTC Date+Time
    Its a key field. Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • .INCLUDE : Shadow Tables Versioning: Include for Shade Table
  • CHANGEDBY : Changed By
    Its data type is CHAR (Character String) with field length 12
  • DELETED : Database Line Status (Original, Changed, Deleted)
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Attributes of ICLDRGITEM
  • .INCLUDE : Claim Item – Fields for Coverage Check
  • COVTYPE : Coverage Type
    Its data type is CHAR (Character String) with field length 10
  • BENTYPE : Benefit Type
    Its data type is CHAR (Character String) with field length 10
  • RCOVTYPE : Benefit Coverage Type
    Its data type is CHAR (Character String) with field length 10
  • XWAITPERIOD : Probationary Periods Ignored
    Its data type is CHAR (Character String) with field length 1
  • COVERAGE : Coverage
    Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : FS-CM: Benefits/Services/Fees Catalogs in ICLITEM
  • SCPOSID_INT : Internal ID of Benefits Catalog Item
    Its data type is CHAR (Character String) with field length 32
  • SERVCAT : Catalog of Diagnosis Related Group (DRG)
    Its data type is CHAR (Character String) with field length 10
  • SCPOSID_EXT : Item in Catalog of Diagnosis Related Group (DRG)
    Its data type is CHAR (Character String) with field length 20
  • .INCLUDE : Claim Items – Status Fields
  • STATUS : Status of Claim Item
    Its data type is CHAR (Character String) with field length 2
  • REJREASON : Claim Item Rejection Reason
    Its data type is CHAR (Character String) with field length 2
  • MODIFIED : Modified
    Its data type is CHAR (Character String) with field length 1
  • PROCURED : Ordered
    Its data type is CHAR (Character String) with field length 1
  • CALCULATED : Calculated
    Its data type is CHAR (Character String) with field length 1
  • CATAID : Catalog of Major Diagnostic Category (MDC)
    Its data type is CHAR (Character String) with field length 4
  • DIAGID : Catalog Item of Major Diagnostic Category (MDC)
    Its data type is CHAR (Character String) with field length 10
  • SEVERITY_CODE : Severity of Diagnosis Related Group (DRG)
    Its data type is CHAR (Character String) with field length 1
  • NOTE : Note for Diagnosis Related Groups
    Its data type is CHAR (Character String) with field length 80
  • REMUN_TYPE_AM : Remuneration Category
    Its data type is CHAR (Character String) with field length 4
  • AMOUNT : DRG Amount
    Its data type is CURR (Currency Field) with field length 15
  • REMUN_TYPE_ADDAM : Remuneration Category
    Its data type is CHAR (Character String) with field length 4
  • ADDITIONALAMOUNT : Additional DRG Amount
    Its data type is CURR (Currency Field) with field length 15
  • CURR : Currency of Evaluated Amount
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • AMOUNTDAYS : Number of Days for DRG Calculation (Markdown/Markup)
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • ITEM_REF : Claim Item
    Its data type is CHAR (Character String) with field length 4
  • PROCUREMENT : ID of Claim Item Grouping
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • .INCLUDE : Mechanical Ventilation Duration
  • EVQUANTITY : Duration of Mechanical Ventilation
    Its data type is QUAN (Quantity field) with field length 10
  • EVQUANUNIT : Unit of Mechanical Ventilation Duration
    Its data type is UNIT (Unit key for a Quantity field) with field length 3