ICLPARTWC

Participant, Additional Info.: Workers Compensation | #masterdata | 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
PARTNER Claim Participant
ROLE FK Participant Role Key
Column Name Description
💲 Currency (CURRENCY):
EMPE_AWW Pre-Injury Average Weekly Wage
EMPE_OTHR_PAY Other Weekly Payments
EMPE_DISCFB Discontinued Fringe Benefits
Column Name Description
Column Name Description
EMP_DATEREPTO Date on Which Injury Reported to Employer
EMPE_LDW Initial Date Last Day Worked
EMPE_RTW Initial Return to Work Date
EMPE_MMI_DATE Date of Maximum Medical Improvement
EMPE_WORKTIME Time Employee Began Work Before Accident
EMPE_HIREDATE Employee Date of Hire
EMP_PREPAREDDATE Date Prepared
CLADMN_DATEREPTO Date of Report of Injury to Claim Administrator
LAWY_STARTDATE Date Attorney Started Working for Claimant
LAWY_DISCLOSURE Disclosure Date
EMPE_DEATHDATE Employee Date of Death
Column Name Description
ACTIVE Table entry is active (A) or in suspense (S) Show values
DELETED Database Line Status (Original, Changed, Deleted) Show values
XINITIALPROVIDER WComp: Initial Medical Service Provider Show values
Column Name Description Domain name
CHANGETIME Changed: Date + Time ICL_TIMESTAMP
EMP_UINUMBER Employer Unemployment Insurance Number ICL_EMP_UINUM
EMP_LOCNUM Insured Location Number of Employer ICL_LOCNUM
EMPE_WORKDAYS Number of Days Regularly Worked per Week ICL_WORKDAYS
EMPE_NOOFDEP Employee Number of Dependents NUM2
EMPE_NOOFENTEXEM Employee Number of Entitled Exemptions NUM2
EMPE_NOOFWHEXEM Employee Number of Withholding Exemptions NUM2
OSHA_CASE_NUM Occupational Safety & Health Administration (OSHA) Case No. ICL_OSHA_CASE_NUM
BODY_PART_CODE Code for Injured Body Part ICL_BODY_PART_CODE
ASSIGN_GUID UUID of Entry to be Linked SYSUUID_C
MCO_IDNUM Managed Care Organization (MCO) ID Number ICL_MCO_IDNUM
Master Data Relations Join Conditions
Changed By
  • ICLPARTWC.CLIENT == USR02.MANDT
  • ICLPARTWC.CHANGEDBY == USR02.BNAME
Client ICLPARTWC.CLIENT == T000.MANDT
Currency
  • ICLPARTWC.CLIENT == TCURC.MANDT
  • ICLPARTWC.CURRENCY == TCURC.WAERS
Cause of Injury
  • Cause of Injury
  • Client
  • ICLPARTWC.EMPE_COI == TICL386.EMP_COI
  • ICLPARTWC.CLIENT == TICL386.CLIENT
Employment Status
  • ICLPARTWC.CLIENT == TICL382.CLIENT
  • ICLPARTWC.EMPE_EMP_STATUS == TICL382.EMP_STATUS
Initial Treatment Code
  • Initial Treatment Code
  • Client
  • ICLPARTWC.EMPE_INITTRMNTCO == TICL388.EMP_INITTRMNTCO
  • ICLPARTWC.CLIENT == TICL388.CLIENT
Manual Classification Code
  • Manual Classification Code
  • Client
  • ICLPARTWC.EMPE_MC_CODE == TICL395.EMP_MC_CODE
  • ICLPARTWC.CLIENT == TICL395.CLIENT
Nature of Injury
  • ICLPARTWC.CLIENT == TICL385.CLIENT
  • ICLPARTWC.EMPE_NOI == TICL385.EMP_NOI
Object or Substance That Directly Injured the Employee
  • ICLPARTWC.CLIENT == TICL396.CLIENT
  • ICLPARTWC.EMPE_OBJINJ == TICL396.EMPE_OBJINJ
Employee Occupation Code
  • ICLPARTWC.CLIENT == TICL394.CLIENT
  • ICLPARTWC.EMPE_OCC_CODE == TICL394.EMP_OCC_CODE
Employee Wage Basis
  • Employee Wage Basis
  • Client
  • ICLPARTWC.EMPE_WAGEBASIS == TICL384.EMP_WAGEBASIS
  • ICLPARTWC.CLIENT == TICL384.CLIENT
Loss Condition: Type of Coverage
  • ICLPARTWC.CLIENT == TICL392.CLIENT
  • ICLPARTWC.EMP_COVERAG_TYPE == TICL392.EMP_COVERAG_TYPE
Industry Code
  • ICLPARTWC.CLIENT == TICL381.CLIENT
  • ICLPARTWC.EMP_INDUSTRYCODE == TICL381.EMP_INDUSTRYCODE
Loss Conditions: Type of Transaction (NCCI)
  • Loss Conditions: Type of Transaction (NCCI)
  • Client
  • ICLPARTWC.EMP_LOSSCOND_ACT == TICL389.EMP_LOSSCOND_ACT
  • ICLPARTWC.CLIENT == TICL389.CLIENT
Loss Conditions: Type of Loss (NCCI)
  • ICLPARTWC.CLIENT == TICL390.CLIENT
  • ICLPARTWC.EMP_LOSS_TYPE == TICL390.EMP_LOSS_TYPE
Nature of Business
  • ICLPARTWC.CLIENT == TICL387.CLIENT
  • ICLPARTWC.EMP_NATOFBUS == TICL387.EMP_NATOFBUS
Employer Payroll
  • Employer Payroll
  • Client
  • ICLPARTWC.EMP_PAYROLL == TICL380.EMP_PAYROLL
  • ICLPARTWC.CLIENT == TICL380.CLIENT
Loss Conditions: Type of Recovery
  • ICLPARTWC.CLIENT == TICL391.CLIENT
  • ICLPARTWC.EMP_RECOVER_TYPE == TICL391.EMP_RECOVER_TYPE
Loss Conditions: Settlement Type
  • Loss Conditions: Settlement Type
  • Client
  • ICLPARTWC.EMP_SETTLE_TYPE == TICL393.EMP_SETTLE_TYPE
  • ICLPARTWC.CLIENT == TICL393.CLIENT
Participant Role Key