ICLPARTWC - Participant, Additional Info.: Workers Compensation

Participant, Additional Info.: Workers Compensation information is stored in SAP table ICLPARTWC.
It is part of development package ICL_CDC in software component FS-CM. This development package consists of objects that can be grouped under "FS-CM: Data Capture".

Fields for table ICLPARTWC

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
CLIENT	Client	X	MANDT	CLNT	6	T000
ACTIVE	Table entry is active (A) or in suspense (S)	X	ICL_ACTIVE	CHAR	2
CLAIM	Number of Claim	X	ICL_CLAIM	CHAR	34	ICLCLAIM
PARTNER	Claim Participant	X	ICL_PART	CHAR	20	*
ROLE	Participant Role Key	X	ICL_ROLE	CHAR	8	TICL301
.INCLUDE				ICL_INCL_VER5	0
CHANGETIME	Changed: Date + Time		ICL_CHANGEUTC1	DEC	8
CHANGEDBY	Changed By		ICL_CHANGEDBY	CHAR	24	USR02
DELETED	Database Line Status (Original, Changed, Deleted)		ICL_RECSTATUS	CHAR	2
.INCLUDE				ICS_PARTWC	0
EMP_PAYROLL	Employer Payroll		ICL_EMP_PAYROLL	CHAR	4	TICL380
EMP_INDUSTRYCODE	Industry Code		ICL_EMP_INDUSTRYCODE	NUMC	12	TICL381
EMP_UINUMBER	Employer Unemployment Insurance Number		ICL_EMP_UINUM	NUMC	18
EMP_NATOFBUS	Nature of Business		ICL_EMP_NATOFBUS	CHAR	12	TICL387
EMP_LOCNUM	Insured Location Number of Employer		ICL_EMP_LOCNUM	CHAR	30
EMP_DATEREPTO	Date on Which Injury Reported to Employer		ICL_EMP_DATEREPTOEMPL	DATS	16
EMP_LOSSCOND_ACT	Loss Conditions: Type of Transaction (NCCI)		ICL_EMP_LOSS_COND_ACT	CHAR	4	TICL389
EMP_LOSS_TYPE	Loss Conditions: Type of Loss (NCCI)		ICL_EMP_LOSS_COND_LOSS_TYPE	CHAR	4	TICL390
EMP_RECOVER_TYPE	Loss Conditions: Type of Recovery		ICL_EMP_LOSS_COND_RECOVER_TYPE	CHAR	4	TICL391
EMP_COVERAG_TYPE	Loss Condition: Type of Coverage		ICL_EMP_LOSS_COND_COVERAG_TYPE	CHAR	4	TICL392
EMP_SETTLE_TYPE	Loss Conditions: Settlement Type		ICL_EMP_LOSS_COND_SETTLE_TYPE	CHAR	4	TICL393
EMPE_EMP_STATUS	Employment Status		ICL_EMP_STATUS	CHAR	4	TICL382
EMPE_WAGEBASIS	Employee Wage Basis		ICL_EMP_WAGEBASIS	CHAR	4	TICL384
EMPE_WORKDAYS	Number of Days Regularly Worked per Week		ICL_EMP_WORKDAYS	CHAR	2
EMPE_NOOFDEP	Employee Number of Dependents		ICL_EMP_NUMOFDEPENDENTS	NUMC	4
EMPE_NOOFENTEXEM	Employee Number of Entitled Exemptions		ICL_EMP_NUMOFENTEXEMPTIONS	NUMC	4
EMPE_NOOFWHEXEM	Employee Number of Withholding Exemptions		ICL_EMP_NUMOFWHDEXEMPTIONS	NUMC	4
EMPE_AWW	Pre-Injury Average Weekly Wage		ICL_EMP_PREINJURY_AWW	CURR	8
EMPE_OTHR_PAY	Other Weekly Payments		ICL_EMP_OTHER_WEEKLY_PAY	CURR	8
EMPE_DISCFB	Discontinued Fringe Benefits		ICL_EMP_WDFB	CURR	8
EMPE_LDW	Initial Date Last Day Worked		ICL_EMP_INTDATELDW	DATS	16
EMPE_RTW	Initial Return to Work Date		ICL_EMP_INITIALRTW	DATS	16
EMPE_MMI_DATE	Date of Maximum Medical Improvement		ICL_EMP_MMI_DATE	DATS	16
EMPE_WORKTIME	Time Employee Began Work Before Accident		ICL_EMP_WORKBEGINTIME	TIMS	12
CURRENCY	Currency		ICL_CURRENCY	CUKY	10	TCURC
EMPE_HIREDATE	Employee Date of Hire		ICL_EMP_HIREDATE	DATS	16
EMPE_OCC_CODE	Employee Occupation Code		ICL_EMP_OCC_CODE	CHAR	4	TICL394
EMPE_MC_CODE	Manual Classification Code		ICL_EMP_MC_CODE	CHAR	8	TICL395
EMPE_OBJINJ	Object or Substance That Directly Injured the Employee		ICL_EMP_OBJINJ	CHAR	12	TICL396
EMPE_INITTRMNTCO	Initial Treatment Code		ICL_EMP_INITTRMNTCODE	CHAR	2	TICL388
EMPE_NOI	Nature of Injury		ICL_EMP_NOI	CHAR	4	TICL385
EMPE_COI	Cause of Injury		ICL_EMP_COI	CHAR	4	TICL386
EMP_PREPAREDDATE	Date Prepared		ICL_EMP_PREPAREDDATE	DATS	16
CLADMN_DATEREPTO	Date of Report of Injury to Claim Administrator		ICL_EMP_DATEREPTOCLADM	DATS	16
XINITIALPROVIDER	WComp: Initial Medical Service Provider		ICL_PARTOCC02	CHAR	2
LAWY_STARTDATE	Date Attorney Started Working for Claimant		ICL_EMP_ATTORNEYSTARTDATE	DATS	16
LAWY_DISCLOSURE	Disclosure Date		ICL_EMP_DISCLOSUREDATE	DATS	16
OSHA_CASE_NUM	Occupational Safety & Health Administration (OSHA) Case No.		ICL_OSHA_CASE_NUM	CHAR	30
BODY_PART_CODE	Code for Injured Body Part		ICL_BODY_PART_CODE	CHAR	4
EMPE_DEATHDATE	Employee Date of Death		EMPE_DATE_OF_DEATH	DATS	16
ASSIGN_GUID	UUID of Entry to be Linked		ICL_ASSIGN_GUID	CHAR	64
MCO_IDNUM	Managed Care Organization (MCO) ID Number		ICL_EMP_MCO_IDNUM	CHAR	18