ICL_WCMPH

Workers Comp - Header Data | #header | Component: Claims Management

🔑 Keys (5)
💰 Amounts (3)
∑ Quantities
📅 Dates (5)
☰ Categorical (4)
Other (5)
🔗 Relations (4)

Column Name	Description
CLIENT	Client
ACTIVE	Table entry is active (A) or in suspense (S)	Show values
CLAIM	Number of Claim
SUBCLAIM	Subclaim
WCMPH_SEQNUM	Sequence Number of Header Data

Column Name	Description
💲 Currency (CURRENCY):
AWW	Pre-Injury Average Weekly Wage
POST_AWW	Average Weekly Wage After Injury
BENEFIT_OFFSET	Amount Offset

Column Name	Description

Column Name	Description
LOSSDATE	Date of Loss/Claim
STARTDATE	Last Day Worked
EXPENDDATE	Expected Date of Return to Work (YYYYMMDD)
ENDDATE	Initial Return to Work Date
MMI_DATE	Date of Maximum Medical Improvement

Column Name	Description
ACTIVE	Table entry is active (A) or in suspense (S)	Show values
DELETED	Database Line Status (Original, Changed, Deleted)	Show values
MARITAL_STATUS	Marital Status	Show values
PAID_FOR_DOI	Paid for Day of Injury	Show values

Column Name	Description	Domain name
CHANGETIME	Changed: Date + Time	ICL_TIMESTAMP
NUM_EXEMPT	Employee Number of Entitled Exemptions	NUM2
NUMOFWHDEXEMPTIO	Employee Number of Withholding Exemptions	NUM2
SERVCAT	Internal ID of Benefits Catalog Item	SYSUUID_C
NUM_DEPENDANTS	Employee Number of Dependents	NUM2

Master Data Relations	Join Conditions
Changed By	`ICL_WCMPH.CLIENT == USR02.MANDT` `ICL_WCMPH.CHANGEDBY == USR02.BNAME`
Country/Region of Jurisdiction Country/Region of Jurisdiction Client	`ICL_WCMPH.COUNTRY == T005.LAND1` `ICL_WCMPH.CLIENT == T005.MANDT`
Disability Class Disability Class Client	`ICL_WCMPH.DISABILITY_CLASS == TICL460.DISABILITY_CLASS` `ICL_WCMPH.CLIENT == TICL460.CLIENT`
Jurisdiction Region Country/Region of Jurisdiction Jurisdiction Region	`ICL_WCMPH.CLIENT == T005S.MANDT` `ICL_WCMPH.COUNTRY == T005S.LAND1` `ICL_WCMPH.REGION == T005S.BLAND`