ICLPARTWC SAP table for – Participant, Additional Info.: Workers Compensation

Here we would like to draw your attention to ICLPARTWC 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). ICLPARTWC is a SAP standard transp table used for storing Participant, Additional Info.: Workers Compensation related data in SAP. It comes under the package ICL_CDC.

SAP ICLPARTWC table

Table ICLPARTWC technical data

TableICLPARTWC
Data storingParticipant, Additional Info.: Workers Compensation
ModuleFS
Sub ModuleFS-CM
SAP PackageICL_CDC
Delivery ClassA – Application table (master and transaction data)
ComponentINSURANCE
Table CategoryTRANSP

SAP ICLPARTWC 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 ICLPARTWC 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
  • PARTNER : Claim Participant
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • ROLE : Participant Role Key
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : Shadow Tables Versioning: Include for Original Table
  • CHANGETIME : Changed: UTC Date+Time
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • 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 : Workers Compensation: Additional Info on Claim Participants
  • EMP_PAYROLL : Employer Payroll
    Its data type is CHAR (Character String) with field length 2
  • EMP_INDUSTRYCODE : Industry Code
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • EMP_UINUMBER : Employer Unemployment Insurance Number
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • EMP_NATOFBUS : Nature of Business
    Its data type is CHAR (Character String) with field length 6
  • EMP_LOCNUM : Insured Location Number of Employer
    Its data type is CHAR (Character String) with field length 15
  • EMP_DATEREPTO : Date on Which Injury Reported to Employer
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • EMP_LOSSCOND_ACT : Loss Conditions: Type of Transaction (NCCI)
    Its data type is CHAR (Character String) with field length 2
  • EMP_LOSS_TYPE : Loss Conditions: Type of Loss (NCCI)
    Its data type is CHAR (Character String) with field length 2
  • EMP_RECOVER_TYPE : Loss Conditions: Type of Recovery
    Its data type is CHAR (Character String) with field length 2
  • EMP_COVERAG_TYPE : Loss Condition: Type of Coverage
    Its data type is CHAR (Character String) with field length 2
  • EMP_SETTLE_TYPE : Loss Conditions: Settlement Type
    Its data type is CHAR (Character String) with field length 2
  • EMPE_EMP_STATUS : Employment Status
    Its data type is CHAR (Character String) with field length 2
  • EMPE_WAGEBASIS : Employee Wage Basis
    Its data type is CHAR (Character String) with field length 2
  • EMPE_WORKDAYS : Number of Days Regularly Worked per Week
    Its data type is CHAR (Character String) with field length 1
  • EMPE_NOOFDEP : Employee Number of Dependents
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • EMPE_NOOFENTEXEM : Employee Number of Entitled Exemptions
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • EMPE_NOOFWHEXEM : Employee Number of Withholding Exemptions
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • EMPE_AWW : Pre-Injury Average Weekly Wage
    Its data type is CURR (Currency Field) with field length 15
  • EMPE_OTHR_PAY : Other Weekly Payments
    Its data type is CURR (Currency Field) with field length 15
  • EMPE_DISCFB : Discontinued Fringe Benefits
    Its data type is CURR (Currency Field) with field length 15
  • EMPE_LDW : Initial Date Last Day Worked
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • EMPE_RTW : Initial Return to Work Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • EMPE_MMI_DATE : Date of Maximum Medical Improvement
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • EMPE_WORKTIME : Time Employee Began Work Before Accident
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • CURRENCY : Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • EMPE_HIREDATE : Employee Date of Hire
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • EMPE_OCC_CODE : Employee Occupation Code
    Its data type is CHAR (Character String) with field length 2
  • EMPE_MC_CODE : Manual Classification Code
    Its data type is CHAR (Character String) with field length 4
  • EMPE_OBJINJ : Object or Substance That Directly Injured the Employee
    Its data type is CHAR (Character String) with field length 6
  • EMPE_INITTRMNTCO : Initial Treatment Code
    Its data type is CHAR (Character String) with field length 1
  • EMPE_NOI : Nature of Injury
    Its data type is CHAR (Character String) with field length 2
  • EMPE_COI : Cause of Injury
    Its data type is CHAR (Character String) with field length 2
  • EMP_PREPAREDDATE : Date Prepared
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CLADMN_DATEREPTO : Date of Report of Injury to Claim Administrator
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • XINITIALPROVIDER : WComp: Initial Medical Service Provider
    Its data type is CHAR (Character String) with field length 1
  • LAWY_STARTDATE : Date Attorney Started Working for Claimant
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LAWY_DISCLOSURE : Disclosure Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • OSHA_CASE_NUM : Occupational Safety & Health Administration (OSHA) Case No.
    Its data type is CHAR (Character String) with field length 15
  • BODY_PART_CODE : Code for Injured Body Part
    Its data type is CHAR (Character String) with field length 2
  • EMPE_DEATHDATE : Date of Death of Employee
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ASSIGN_GUID : UUID of Entry to be Linked
    Its data type is CHAR (Character String) with field length 32
  • MCO_IDNUM : Managed Care Organization (MCO) ID Number
    Its data type is CHAR (Character String) with field length 9