ICLPROCURE

Claim Item Groupings | #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 of Payment
PROCUREMENT ID of Claim Item Grouping
Column Name Description
💲 Currency (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
CHANGETIME Changed: Date + Time ICL_TIMESTAMP
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
DISCOUNTPERCENT Discount on Total Invoice Amount in Percent ICL_PERCENT
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
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
  • ICLPROCURE.ACCIDENT == TICL158.ACCIDENT
  • ICLPROCURE.CLIENT == TICL158.CLIENT
Changed By
  • ICLPROCURE.CLIENT == USR02.MANDT
  • ICLPROCURE.CHANGEDBY == USR02.BNAME
Client ICLPROCURE.CLIENT == T000.MANDT
Created By
  • ICLPROCURE.CLIENT == USR02.MANDT
  • ICLPROCURE.CREATEDBY == USR02.BNAME
Currency
  • ICLPROCURE.CLIENT == TCURC.MANDT
  • ICLPROCURE.CURRENCY == TCURC.WAERS
Data Origin
  • ICLPROCURE.CLIENT == TICL136.CLIENT
  • ICLPROCURE.DATASOURCE == TICL136.DATASOURCE
Payment Frequency of a Repetitive Payment
  • ICLPROCURE.CLIENT == TVS010B.MANDT
  • ICLPROCURE.PAYFREQPLAN == TVS010B.PKEY
Claim Item Grouping Category
  • Claim Item Grouping Category
  • Client
  • ICLPROCURE.PDOCCAT == TICL138.PDOCCAT
  • ICLPROCURE.CLIENT == TICL138.CLIENT
Type of Claim Item Grouping Category
  • Type of Claim Item Grouping Category
  • Client
  • ICLPROCURE.PDOCCATTYPE == TICL153.PDOCCATTYPE
  • ICLPROCURE.CLIENT == TICL153.CLIENT
Reason for Creating a Claim Item Grouping
  • Reason for Creating a Claim Item Grouping
  • Client
  • ICLPROCURE.REASON == TICL152.REASON
  • ICLPROCURE.CLIENT == TICL152.CLIENT
Reason for Changing the Status
  • ICLPROCURE.CLIENT == TICL018.CLIENT
  • ICLPROCURE.STATREASON == TICL018.FORMOFSET
Status of a Claim Item Grouping
  • Status of a Claim Item Grouping
  • Client
  • ICLPROCURE.STATUS == TICL140.STATUS
  • ICLPROCURE.CLIENT == TICL140.CLIENT
Indication Whether Recovery Claim Might Be Involved
  • ICLPROCURE.CLIENT == TICL157.CLIENT
  • ICLPROCURE.SUBROGATION == TICL157.SUBROGATION