SAP ABAP Table ICL_PARTWC (Claim Participant, Additional Info.: Workers Compensation)

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	ICL_PARTWC	Table Relationship Diagram
Short Description	Claim Participant, Additional Info.: Workers Compensation

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	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
2	ROLE	☐	ICL_ROLE	ICL_ROLE	CHAR	4	0	Participant Role Key	*
3	.INCLUDE	☐				0	0	Shadow Tables Versioning: Include for Original Table
4	CHANGETIME	☐	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
5	CHANGEDBY	☐	ICL_CHANGEDBY	XUBNAME	CHAR	12	0	Changed By	USR02
6	DELETED	☐	ICL_RECSTATUS	ICL_RECSTATUS	CHAR	1	0	Database Line Status (Original, Changed, Deleted)
7	.INCLUDE	☐				0	0	Workers Compensation: Additional Info on Claim Participants
8	EMP_PAYROLL	☐	ICL_EMP_PAYROLL	ICL_PAYROLL	CHAR	2	0	Employer Payroll	*
9	EMP_INDUSTRYCODE	☐	ICL_EMP_INDUSTRYCODE	ICL_INDUSTRYCODE	NUMC	6	0	Industry Code	*
10	EMP_UINUMBER	☐	ICL_EMP_UINUM	ICL_EMP_UINUM	NUMC	9	0	Employer Unemployment Insurance Number
11	EMP_NATOFBUS	☐	ICL_EMP_NATOFBUS	ICL_NATURE_OF_BUSINESS	CHAR	6	0	Nature of Business	TICL387
12	EMP_LOCNUM	☐	ICL_EMP_LOCNUM	ICL_LOCNUM	CHAR	15	0	Insured Location Number of Employer
13	EMP_DATEREPTO	☐	ICL_EMP_DATEREPTOEMPL	ICL_DATEREPTOEMPL	DATS	8	0	Date on Which Injury Reported to Employer
14	EMP_LOSSCOND_ACT	☐	ICL_EMP_LOSS_COND_ACT	ICL_LOSS_COND_ACT	CHAR	2	0	Loss Conditions: Type of Transaction (NCCI)	TICL389
15	EMP_LOSS_TYPE	☐	ICL_EMP_LOSS_COND_LOSS_TYPE	ICL_LOSS_COND_LOSS_TYPE	CHAR	2	0	Loss Conditions: Type of Loss (NCCI)	TICL390
16	EMP_RECOVER_TYPE	☐	ICL_EMP_LOSS_COND_RECOVER_TYPE	ICL_LOSS_COND_RECOVERY_TYPE	CHAR	2	0	Loss Conditions: Type of Recovery	TICL391
17	EMP_COVERAG_TYPE	☐	ICL_EMP_LOSS_COND_COVERAG_TYPE	ICL_LOSS_COND_COVERAGAE_TYPE	CHAR	2	0	Loss Condition: Type of Coverage	TICL392
18	EMP_SETTLE_TYPE	☐	ICL_EMP_LOSS_COND_SETTLE_TYPE	ICL_LOSS_COND_SETTLEMENT_TYPE	CHAR	2	0	Loss Conditions: Settlement Type	TICL393
19	EMPE_EMP_STATUS	☐	ICL_EMP_STATUS	ICL_EMP_STATUS	CHAR	2	0	Employment Status	TICL382
20	EMPE_WAGEBASIS	☐	ICL_EMP_WAGEBASIS	ICL_WAGEBASIS	CHAR	2	0	Employee Wage Basis	TICL384
21	EMPE_WORKDAYS	☐	ICL_EMP_WORKDAYS	ICL_WORKDAYS	CHAR	1	0	Number of Days Regularly Worked per Week
22	EMPE_NOOFDEP	☐	ICL_EMP_NUMOFDEPENDENTS	NUM2	NUMC	2	0	Employee Number of Dependents
23	EMPE_NOOFENTEXEM	☐	ICL_EMP_NUMOFENTEXEMPTIONS	NUM2	NUMC	2	0	Employee Number of Entitled Exemptions
24	EMPE_NOOFWHEXEM	☐	ICL_EMP_NUMOFWHDEXEMPTIONS	NUM2	NUMC	2	0	Employee Number of Withholding Exemptions
25	EMPE_AWW	☐	ICL_EMP_PREINJURY_AWW	ICL_RESAMOUNT	CURR	15	2	Pre-Injury Average Weekly Wage
26	EMPE_OTHR_PAY	☐	ICL_EMP_OTHER_WEEKLY_PAY	ICL_RESAMOUNT	CURR	15	2	Other Weekly Payments
27	EMPE_DISCFB	☐	ICL_EMP_WDFB	ICL_RESAMOUNT	CURR	15	2	Discontinued Fringe Benefits
28	EMPE_LDW	☐	ICL_EMP_INTDATELDW	ICL_INTDATELDW	DATS	8	0	Initial Date Last Day Worked
29	EMPE_RTW	☐	ICL_EMP_INITIALRTW	ICL_INITIALRTW	DATS	8	0	Initial Return to Work Date
30	EMPE_MMI_DATE	☐	ICL_EMP_MMI_DATE	ICL_MMI_DATE	DATS	8	0	Date of Maximum Medical Improvement
31	EMPE_WORKTIME	☐	ICL_EMP_WORKBEGINTIME	TIME	TIMS	6	0	Time Employee Began Work Before Accident
32	CURRENCY	☐	ICL_CURRENCY	WAERS	CUKY	5	0	Currency	TCURC
33	EMPE_HIREDATE	☐	ICL_EMP_HIREDATE	ICL_HIREDATE	DATS	8	0	Employee Date of Hire
34	EMPE_OCC_CODE	☐	ICL_EMP_OCC_CODE	ICL_OCC_CODE	CHAR	2	0	Employee Occupation Code	TICL394
35	EMPE_MC_CODE	☐	ICL_EMP_MC_CODE	ICL_MANUAL_CLASS_CODE	CHAR	4	0	Manual Classification Code	TICL395
36	EMPE_OBJINJ	☐	ICL_EMP_OBJINJ	ICL_EMP_OBJINJ	CHAR	6	0	Object or Substance That Directly Injured the Employee	TICL396
37	EMPE_INITTRMNTCO	☐	ICL_EMP_INITTRMNTCODE	ICL_INITTRMNTCODE	CHAR	1	0	Initial Treatment Code	TICL388
38	EMPE_NOI	☐	ICL_EMP_NOI	ICL_NATURE_OF_INJURY	CHAR	2	0	Nature of Injury	TICL385
39	EMPE_COI	☐	ICL_EMP_COI	ICL_CAUSE_OF_INJUEY	CHAR	2	0	Cause of Injury	TICL386
40	EMP_PREPAREDDATE	☐	ICL_EMP_PREPAREDDATE	ICL_PREPARED_DATE	DATS	8	0	Date Prepared
41	CLADMN_DATEREPTO	☐	ICL_EMP_DATEREPTOCLADM	ICL_DATEREPTOCLADM	DATS	8	0	Date of Report of Injury to Claim Administrator
42	XINITIALPROVIDER	☐	ICL_PARTOCC02	XFELD	CHAR	1	0	WComp: Initial Medical Service Provider
43	LAWY_STARTDATE	☐	ICL_EMP_ATTORNEYSTARTDATE	ICL_ATTORNEYSTART_DATE	DATS	8	0	Date Attorney Started Working for Claimant
44	LAWY_DISCLOSURE	☐	ICL_EMP_DISCLOSUREDATE	ICL_DISCLOSURE_DATE	DATS	8	0	Disclosure Date
45	OSHA_CASE_NUM	☐	ICL_OSHA_CASE_NUM	ICL_OSHA_CASE_NUM	CHAR	15	0	Occupational Safety & Health Administration (OSHA) Case No.
46	BODY_PART_CODE	☐	ICL_BODY_PART_CODE	ICL_BODY_PART_CODE	CHAR	2	0	Code for Injured Body Part
47	EMPE_DEATHDATE	☐	EMPE_DATE_OF_DEATH	ICL_EMPE_DATE_OF_DEATH	DATS	8	0	Date of Death of Employee
48	ASSIGN_GUID	☐	ICL_ASSIGN_GUID	SYSUUID_C	CHAR	32	0	UUID of Entry to be Linked
49	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	ICL_PARTWC	CHANGEDBY	USR02	BNAME
2	ICL_PARTWC	CURRENCY	TCURC	WAERS
3	ICL_PARTWC	EMPE_COI	TICL386	EMP_COI
4	ICL_PARTWC	EMPE_EMP_STATUS	TICL382	EMP_STATUS
5	ICL_PARTWC	EMPE_INITTRMNTCO	TICL388	EMP_INITTRMNTCO
6	ICL_PARTWC	EMPE_MC_CODE	TICL395	EMP_MC_CODE
7	ICL_PARTWC	EMPE_NOI	TICL385	EMP_NOI
8	ICL_PARTWC	EMPE_OBJINJ	TICL396	EMPE_OBJINJ
9	ICL_PARTWC	EMPE_OCC_CODE	TICL394	EMP_OCC_CODE
10	ICL_PARTWC	EMPE_WAGEBASIS	TICL384	EMP_WAGEBASIS
11	ICL_PARTWC	EMP_COVERAG_TYPE	TICL392	EMP_COVERAG_TYPE
12	ICL_PARTWC	EMP_LOSSCOND_ACT	TICL389	EMP_LOSSCOND_ACT
13	ICL_PARTWC	EMP_LOSS_TYPE	TICL390	EMP_LOSS_TYPE
14	ICL_PARTWC	EMP_NATOFBUS	TICL387	EMP_NATOFBUS
15	ICL_PARTWC	EMP_RECOVER_TYPE	TICL391	EMP_RECOVER_TYPE
16	ICL_PARTWC	EMP_SETTLE_TYPE	TICL393	EMP_SETTLE_TYPE

History

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