SAP ABAP Table ICL_BW_PARTWC (Extract Structure for Workers Comp: Participant, Addl Info)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	ICL_BW_PARTWC	Table Relationship Diagram
Short Description	Extract Structure for Workers Comp: Participant, Addl Info

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

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in