SAP ABAP Table ICS_PARTWC (Workers Compensation: Additional Info on Claim Participants)

Hierarchy

☛ INSURANCE (Software Component) SAP Insurance
   ⤷ FS-CM (Application Component) Claims Management
     ⤷ ICL_CDC (Package) FS-CM: Data Capture

Basic Data

Table Category	INTTAB	Structure
Structure	ICS_PARTWC	Table Relationship Diagram
Short Description	Workers Compensation: Additional Info on Claim Participants

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	EMP_PAYROLL	☐	ICL_EMP_PAYROLL	ICL_PAYROLL	CHAR	2	0	Employer Payroll	TICL380
2	EMP_INDUSTRYCODE	☐	ICL_EMP_INDUSTRYCODE	ICL_INDUSTRYCODE	NUMC	6	0	Industry Code	TICL381
3	EMP_UINUMBER	☐	ICL_EMP_UINUM	ICL_EMP_UINUM	NUMC	9	0	Employer Unemployment Insurance Number
4	EMP_NATOFBUS	☐	ICL_EMP_NATOFBUS	ICL_NATURE_OF_BUSINESS	CHAR	6	0	Nature of Business	TICL387
5	EMP_LOCNUM	☐	ICL_EMP_LOCNUM	ICL_LOCNUM	CHAR	15	0	Insured Location Number of Employer
6	EMP_DATEREPTO	☐	ICL_EMP_DATEREPTOEMPL	ICL_DATEREPTOEMPL	DATS	8	0	Date on Which Injury Reported to Employer
7	EMP_LOSSCOND_ACT	☐	ICL_EMP_LOSS_COND_ACT	ICL_LOSS_COND_ACT	CHAR	2	0	Loss Conditions: Type of Transaction (NCCI)	TICL389
8	EMP_LOSS_TYPE	☐	ICL_EMP_LOSS_COND_LOSS_TYPE	ICL_LOSS_COND_LOSS_TYPE	CHAR	2	0	Loss Conditions: Type of Loss (NCCI)	TICL390
9	EMP_RECOVER_TYPE	☐	ICL_EMP_LOSS_COND_RECOVER_TYPE	ICL_LOSS_COND_RECOVERY_TYPE	CHAR	2	0	Loss Conditions: Type of Recovery	TICL391
10	EMP_COVERAG_TYPE	☐	ICL_EMP_LOSS_COND_COVERAG_TYPE	ICL_LOSS_COND_COVERAGAE_TYPE	CHAR	2	0	Loss Condition: Type of Coverage	TICL392
11	EMP_SETTLE_TYPE	☐	ICL_EMP_LOSS_COND_SETTLE_TYPE	ICL_LOSS_COND_SETTLEMENT_TYPE	CHAR	2	0	Loss Conditions: Settlement Type	TICL393
12	EMPE_EMP_STATUS	☐	ICL_EMP_STATUS	ICL_EMP_STATUS	CHAR	2	0	Employment Status	TICL382
13	EMPE_WAGEBASIS	☐	ICL_EMP_WAGEBASIS	ICL_WAGEBASIS	CHAR	2	0	Employee Wage Basis	TICL384
14	EMPE_WORKDAYS	☐	ICL_EMP_WORKDAYS	ICL_WORKDAYS	CHAR	1	0	Number of Days Regularly Worked per Week
15	EMPE_NOOFDEP	☐	ICL_EMP_NUMOFDEPENDENTS	NUM2	NUMC	2	0	Employee Number of Dependents
16	EMPE_NOOFENTEXEM	☐	ICL_EMP_NUMOFENTEXEMPTIONS	NUM2	NUMC	2	0	Employee Number of Entitled Exemptions
17	EMPE_NOOFWHEXEM	☐	ICL_EMP_NUMOFWHDEXEMPTIONS	NUM2	NUMC	2	0	Employee Number of Withholding Exemptions
18	EMPE_AWW	☐	ICL_EMP_PREINJURY_AWW	ICL_RESAMOUNT	CURR	15	2	Pre-Injury Average Weekly Wage
19	EMPE_OTHR_PAY	☐	ICL_EMP_OTHER_WEEKLY_PAY	ICL_RESAMOUNT	CURR	15	2	Other Weekly Payments
20	EMPE_DISCFB	☐	ICL_EMP_WDFB	ICL_RESAMOUNT	CURR	15	2	Discontinued Fringe Benefits
21	EMPE_LDW	☐	ICL_EMP_INTDATELDW	ICL_INTDATELDW	DATS	8	0	Initial Date Last Day Worked
22	EMPE_RTW	☐	ICL_EMP_INITIALRTW	ICL_INITIALRTW	DATS	8	0	Initial Return to Work Date
23	EMPE_MMI_DATE	☐	ICL_EMP_MMI_DATE	ICL_MMI_DATE	DATS	8	0	Date of Maximum Medical Improvement
24	EMPE_WORKTIME	☐	ICL_EMP_WORKBEGINTIME	TIME	TIMS	6	0	Time Employee Began Work Before Accident
25	CURRENCY	☐	ICL_CURRENCY	WAERS	CUKY	5	0	Currency	TCURC
26	EMPE_HIREDATE	☐	ICL_EMP_HIREDATE	ICL_HIREDATE	DATS	8	0	Employee Date of Hire
27	EMPE_OCC_CODE	☐	ICL_EMP_OCC_CODE	ICL_OCC_CODE	CHAR	2	0	Employee Occupation Code	TICL394
28	EMPE_MC_CODE	☐	ICL_EMP_MC_CODE	ICL_MANUAL_CLASS_CODE	CHAR	4	0	Manual Classification Code	TICL395
29	EMPE_OBJINJ	☐	ICL_EMP_OBJINJ	ICL_EMP_OBJINJ	CHAR	6	0	Object or Substance That Directly Injured the Employee	TICL396
30	EMPE_INITTRMNTCO	☐	ICL_EMP_INITTRMNTCODE	ICL_INITTRMNTCODE	CHAR	1	0	Initial Treatment Code	TICL388
31	EMPE_NOI	☐	ICL_EMP_NOI	ICL_NATURE_OF_INJURY	CHAR	2	0	Nature of Injury	TICL385
32	EMPE_COI	☐	ICL_EMP_COI	ICL_CAUSE_OF_INJUEY	CHAR	2	0	Cause of Injury	TICL386
33	EMP_PREPAREDDATE	☐	ICL_EMP_PREPAREDDATE	ICL_PREPARED_DATE	DATS	8	0	Date Prepared
34	CLADMN_DATEREPTO	☐	ICL_EMP_DATEREPTOCLADM	ICL_DATEREPTOCLADM	DATS	8	0	Date of Report of Injury to Claim Administrator
35	XINITIALPROVIDER	☐	ICL_PARTOCC02	XFELD	CHAR	1	0	WComp: Initial Medical Service Provider
36	LAWY_STARTDATE	☐	ICL_EMP_ATTORNEYSTARTDATE	ICL_ATTORNEYSTART_DATE	DATS	8	0	Date Attorney Started Working for Claimant
37	LAWY_DISCLOSURE	☐	ICL_EMP_DISCLOSUREDATE	ICL_DISCLOSURE_DATE	DATS	8	0	Disclosure Date
38	OSHA_CASE_NUM	☐	ICL_OSHA_CASE_NUM	ICL_OSHA_CASE_NUM	CHAR	15	0	Occupational Safety & Health Administration (OSHA) Case No.
39	BODY_PART_CODE	☐	ICL_BODY_PART_CODE	ICL_BODY_PART_CODE	CHAR	2	0	Code for Injured Body Part
40	EMPE_DEATHDATE	☐	EMPE_DATE_OF_DEATH	ICL_EMPE_DATE_OF_DEATH	DATS	8	0	Date of Death of Employee
41	ASSIGN_GUID	☐	ICL_ASSIGN_GUID	SYSUUID_C	CHAR	32	0	UUID of Entry to be Linked
42	MCO_IDNUM	☐	ICL_EMP_MCO_IDNUM	ICL_MCO_IDNUM	CHAR	9	0	Managed Care Organization (MCO) ID Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICS_PARTWC	CURRENCY	TCURC	WAERS
2	ICS_PARTWC	EMPE_COI	TICL386	EMP_COI
3	ICS_PARTWC	EMPE_EMP_STATUS	TICL382	EMP_STATUS
4	ICS_PARTWC	EMPE_INITTRMNTCO	TICL388	EMP_INITTRMNTCO
5	ICS_PARTWC	EMPE_MC_CODE	TICL395	EMP_MC_CODE
6	ICS_PARTWC	EMPE_NOI	TICL385	EMP_NOI
7	ICS_PARTWC	EMPE_OBJINJ	TICL396	EMPE_OBJINJ
8	ICS_PARTWC	EMPE_OCC_CODE	TICL394	EMP_OCC_CODE
9	ICS_PARTWC	EMPE_WAGEBASIS	TICL384	EMP_WAGEBASIS
10	ICS_PARTWC	EMP_COVERAG_TYPE	TICL392	EMP_COVERAG_TYPE
11	ICS_PARTWC	EMP_INDUSTRYCODE	TICL381	EMP_INDUSTRYCODE
12	ICS_PARTWC	EMP_LOSSCOND_ACT	TICL389	EMP_LOSSCOND_ACT
13	ICS_PARTWC	EMP_LOSS_TYPE	TICL390	EMP_LOSS_TYPE
14	ICS_PARTWC	EMP_NATOFBUS	TICL387	EMP_NATOFBUS
15	ICS_PARTWC	EMP_PAYROLL	TICL380	EMP_PAYROLL
16	ICS_PARTWC	EMP_RECOVER_TYPE	TICL391	EMP_RECOVER_TYPE
17	ICS_PARTWC	EMP_SETTLE_TYPE	TICL393	EMP_SETTLE_TYPE

History

Last changed by/on	SAP	20110901
SAP Release Created in	472