ICSPROCURE

Claim Item Groupings | #transactional | Component: Claims Management
Column Name Description
CLIENT Client
ACTIVE Table entry is active (A) or in suspense (S) Show values
CLAIM Number of Claim
SUBCLAIM Subclaim of Payment
PROCUREMENT ID of Claim Item Grouping
CHANGETIME Changed: Date + Time
Column Name Description
💲 Currency (ICLPROCURE.CURRENCY):
AMOUNT1 General Amount Field
DISCOUNTAMOUNT Discount on Invoice Amount
FEE Fee
MATLABCOST Material and Laboratory Costs
MATLABCOSTINT will be deleted.
ADDCOST Other Costs
SUBSIDYAMOUNT Subsidy Amount
Column Name Description
Column Name Description
ISSUEDATE Date Created
RECEIVEDATE Date Received
DATEFROM Start Date of Period
TIMEFROM Start Time of Claim Item Group
DATETO End Date of Period
TIMETO End Time of Claim Item Group
ISSUEDATE_PRESCR Date Prescription Created Acc. to Invoice
ACQUISITIONDATE Date Entered
DUEDATE Due Date
DUEDATE_ORIG Origin of Due Date
SETORDERDATE Set Order Date
COMPLETIONDATE Completion Date
COMPPER_DATEFROM Comparision Period From
COMPPER_DATETO Comparison Period To
_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
SENT_BY_DME Sent via External Interface (Not Yet Used) Show values
RECEIPT_BY_DME Receipt via External Interface Show values
CANCEL Status "Cancelled" Show values
REJECTED Status "Rejected" Show values
INSUSPENSE Status "Pending" Show values
INPROCESS Status "In Process" Show values
RELEASED Status "Released" Show values
XFINISHED Complete/Approved/Finished Show values
ORDERED Status "Commissioned" Show values
TRANSFERRED Status "Reassigned" Show values
TOBEAPPROVED Status "To Be Approved" Show values
XCLINICCARD Flag: Clinic Card Show values
XREQUEST Indicator: Receivable Show values
PAYOUT_SCENARIO Repetitive Payment Scenario Show values
Column Name Description Domain name
CREATETIME Created: Date + Time ICL_TIMESTAMP
EXTERNALREF External Reference of Claim Item Grouping ICL_EXTERNALREF
EXTDOCUMENT External Document Number ICL_EXTDOCUMENT
EXTCASENO Hospital-Internal ID ICLH_EXTCASENO
EXTFILENO HI: External Data Set Identification ICLH_EXTFILENO
PROC_REF Reference to Claim Item Grouping ICL_PROCUREMENT
DISCOUNTPERCENT Discount on Total Invoice Amount in Percent ICL_PERCENT
STATUS Status of a Claim Item Grouping ICL_STATUS
OWNCONTRIB Copayment NUMC03
CAUSE Specification of Reason for Creating Claim Item Grouping ICLH_CAUSE
SUBCL_ORIG Original Subclaim Multiple Prescription/Curr.Subclm Appraisl ICL_SUBCL
PROC_ORIG Original Claim Item Grouping of Multiple Prescription ICL_PROCUREMENT
VALPERUNIT Value per Unit of Benefits Catalog Item ICL_SERVCAT_POS_VALPERUNIT
SUBSIDYPERCENT Subsidy in Percent (%) ICL_PERCENT
SENTUTC Sent: Date and Time ICL_TIMESTAMP
ASSIGN_GUID UUID of Entry to be Linked SYSUUID_C
REASONREJ Rejection Reasons for Payments and Reserves ICL_REASONREJ
METHOD Payment Method PYMET_KK
ADDRNUMBER Address Number for Checks AD_ADDRNUM
BKID Bank Details ID CHAR4
Master Data Relations Join Conditions
Accident or Other Reason for Possible Recovery
  • Accident or Other Reason for Possible Recovery
  • Client
  • ICSPROCURE.ACCIDENT == TICL158.ACCIDENT
  • ICSPROCURE.CLIENT == TICL158.CLIENT
Changed By
  • ICSPROCURE.CLIENT == USR02.MANDT
  • ICSPROCURE.CHANGEDBY == USR02.BNAME
Created By
  • ICSPROCURE.CLIENT == USR02.MANDT
  • ICSPROCURE.CREATEDBY == USR02.BNAME
Currency
  • ICSPROCURE.CLIENT == TCURC.MANDT
  • ICSPROCURE.CURRENCY == TCURC.WAERS
Data Origin
  • ICSPROCURE.CLIENT == TICL136.CLIENT
  • ICSPROCURE.DATASOURCE == TICL136.DATASOURCE
Payment Frequency of a Repetitive Payment
  • ICSPROCURE.CLIENT == TVS010B.MANDT
  • ICSPROCURE.PAYFREQPLAN == TVS010B.PKEY
Claim Item Grouping Category
  • Claim Item Grouping Category
  • Client
  • ICSPROCURE.PDOCCAT == TICL138.PDOCCAT
  • ICSPROCURE.CLIENT == TICL138.CLIENT
Type of Claim Item Grouping Category
  • Type of Claim Item Grouping Category
  • Client
  • ICSPROCURE.PDOCCATTYPE == TICL153.PDOCCATTYPE
  • ICSPROCURE.CLIENT == TICL153.CLIENT
Reason for Creating a Claim Item Grouping
  • Reason for Creating a Claim Item Grouping
  • Client
  • ICSPROCURE.REASON == TICL152.REASON
  • ICSPROCURE.CLIENT == TICL152.CLIENT
Reason for Changing the Status
  • ICSPROCURE.CLIENT == TICL018.CLIENT
  • ICSPROCURE.STATREASON == TICL018.FORMOFSET
Indication Whether Recovery Claim Might Be Involved
  • ICSPROCURE.CLIENT == TICL157.CLIENT
  • ICSPROCURE.SUBROGATION == TICL157.SUBROGATION