ICLPARTWC

Transparent Table Application Table
50 Fields 1 CDS Views

Participant, Additional Info.: Workers Compensation

ICLPARTWC is an SAP database table in S/4HANA. Participant, Additional Info.: Workers Compensation. It contains 50 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_InsurClmPrtcpntWrkrsCompn view from BASIC Beteiligter: Workers compensation

Fields (50)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY active ICL_ACTIVE Active/Suspense
KEY claim ICL_CLAIM Claim Number
KEY partner ICL_PART Participant
KEY role ICL_ROLE ParticipantRole
changetime ICL_CHANGEUTC1 Changed On
changedby ICL_CHANGEDBY Changed By
deleted ICL_RECSTATUS Status
emp_payroll ICL_EMP_PAYROLL EmployerPayroll
emp_industrycode ICL_EMP_INDUSTRYCODE Industry Code
emp_uinumber ICL_EMP_UINUM Employer UI No.
emp_natofbus ICL_EMP_NATOFBUS Nature of Bus.
emp_locnum ICL_EMP_LOCNUM InsuredLocNum
emp_daterepto ICL_EMP_DATEREPTOEMPL DateRepToEmpl
emp_losscond_act ICL_EMP_LOSS_COND_ACT LossCond-TrnTyp
emp_loss_type ICL_EMP_LOSS_COND_LOSS_TYPE LossCond-LosTyp
emp_recover_type ICL_EMP_LOSS_COND_RECOVER_TYPE LossCond-RecTyp
emp_coverag_type ICL_EMP_LOSS_COND_COVERAG_TYPE LossCond-CovTyp
emp_settle_type ICL_EMP_LOSS_COND_SETTLE_TYPE LossCond-StlTyp
empe_emp_status ICL_EMP_STATUS EmploymntStatus
empe_wagebasis ICL_EMP_WAGEBASIS WageBasis
empe_workdays ICL_EMP_WORKDAYS Work Days/Week
empe_noofdep ICL_EMP_NUMOFDEPENDENTS No.ofDependents
empe_noofentexem ICL_EMP_NUMOFENTEXEMPTIONS Entitled Exmpts
empe_noofwhexem ICL_EMP_NUMOFWHDEXEMPTIONS WHD Exemptions
empe_aww ICL_EMP_PREINJURY_AWW Preinjury AWW
empe_othr_pay ICL_EMP_OTHER_WEEKLY_PAY Other Payments
empe_discfb ICL_EMP_WDFB Disc.FringeBen
empe_ldw ICL_EMP_INTDATELDW LastDayWorked
empe_rtw ICL_EMP_INITIALRTW Return To Work
empe_mmi_date ICL_EMP_MMI_DATE MMI Date
empe_worktime ICL_EMP_WORKBEGINTIME Time Began Work
currency ICL_CURRENCY Currency
empe_hiredate ICL_EMP_HIREDATE Date of Hire
empe_occ_code ICL_EMP_OCC_CODE Occupation Code
empe_mc_code ICL_EMP_MC_CODE ManClassifCode
empe_objinj ICL_EMP_OBJINJ EmplInjByObj
empe_inittrmntco ICL_EMP_INITTRMNTCODE InitTrmntCode
empe_noi ICL_EMP_NOI NatureOfInjury
empe_coi ICL_EMP_COI Cause of Injury
emp_prepareddate ICL_EMP_PREPAREDDATE Date Prepared
cladmn_daterepto ICL_EMP_DATEREPTOCLADM DateRepToClmAdm
xinitialprovider ICL_PARTOCC02 InitialMedProv
lawy_startdate ICL_EMP_ATTORNEYSTARTDATE DateAttrnyStrtd
lawy_disclosure ICL_EMP_DISCLOSUREDATE Disclosure Date
osha_case_num ICL_OSHA_CASE_NUM OSHA Case No.
body_part_code ICL_BODY_PART_CODE Body Part Code
empe_deathdate EMPE_DATE_OF_DEATH Death Date
assign_guid ICL_ASSIGN_GUID Link UUID
mco_idnum ICL_EMP_MCO_IDNUM MCO ID Number

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Participant, Additional Info.: Workers Compensation
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICLPARTWC (
    CLIENT,            -- Client [MANDT]
    ACTIVE,            -- Active/Suspense [ICL_ACTIVE]
    CLAIM,             -- Claim Number [ICL_CLAIM]
    PARTNER,           -- Participant [ICL_PART]
    ROLE,              -- ParticipantRole [ICL_ROLE]
    CHANGETIME,        -- Changed On [ICL_CHANGEUTC1]
    CHANGEDBY,         -- Changed By [ICL_CHANGEDBY]
    DELETED,           -- Status [ICL_RECSTATUS]
    EMP_PAYROLL,       -- EmployerPayroll [ICL_EMP_PAYROLL]
    EMP_INDUSTRYCODE,  -- Industry Code [ICL_EMP_INDUSTRYCODE]
    EMP_UINUMBER,      -- Employer UI No. [ICL_EMP_UINUM]
    EMP_NATOFBUS,      -- Nature of Bus. [ICL_EMP_NATOFBUS]
    EMP_LOCNUM,        -- InsuredLocNum [ICL_EMP_LOCNUM]
    EMP_DATEREPTO,     -- DateRepToEmpl [ICL_EMP_DATEREPTOEMPL]
    EMP_LOSSCOND_ACT,  -- LossCond-TrnTyp [ICL_EMP_LOSS_COND_ACT]
    EMP_LOSS_TYPE,     -- LossCond-LosTyp [ICL_EMP_LOSS_COND_LOSS_TYPE]
    EMP_RECOVER_TYPE,  -- LossCond-RecTyp [ICL_EMP_LOSS_COND_RECOVER_TYPE]
    EMP_COVERAG_TYPE,  -- LossCond-CovTyp [ICL_EMP_LOSS_COND_COVERAG_TYPE]
    EMP_SETTLE_TYPE,   -- LossCond-StlTyp [ICL_EMP_LOSS_COND_SETTLE_TYPE]
    EMPE_EMP_STATUS,   -- EmploymntStatus [ICL_EMP_STATUS]
    EMPE_WAGEBASIS,    -- WageBasis [ICL_EMP_WAGEBASIS]
    EMPE_WORKDAYS,     -- Work Days/Week [ICL_EMP_WORKDAYS]
    EMPE_NOOFDEP,      -- No.ofDependents [ICL_EMP_NUMOFDEPENDENTS]
    EMPE_NOOFENTEXEM,  -- Entitled Exmpts [ICL_EMP_NUMOFENTEXEMPTIONS]
    EMPE_NOOFWHEXEM,   -- WHD Exemptions [ICL_EMP_NUMOFWHDEXEMPTIONS]
    EMPE_AWW,          -- Preinjury AWW [ICL_EMP_PREINJURY_AWW]
    EMPE_OTHR_PAY,     -- Other Payments [ICL_EMP_OTHER_WEEKLY_PAY]
    EMPE_DISCFB,       -- Disc.FringeBen [ICL_EMP_WDFB]
    EMPE_LDW,          -- LastDayWorked [ICL_EMP_INTDATELDW]
    EMPE_RTW,          -- Return To Work [ICL_EMP_INITIALRTW]
    EMPE_MMI_DATE,     -- MMI Date [ICL_EMP_MMI_DATE]
    EMPE_WORKTIME,     -- Time Began Work [ICL_EMP_WORKBEGINTIME]
    CURRENCY,          -- Currency [ICL_CURRENCY]
    EMPE_HIREDATE,     -- Date of Hire [ICL_EMP_HIREDATE]
    EMPE_OCC_CODE,     -- Occupation Code [ICL_EMP_OCC_CODE]
    EMPE_MC_CODE,      -- ManClassifCode [ICL_EMP_MC_CODE]
    EMPE_OBJINJ,       -- EmplInjByObj [ICL_EMP_OBJINJ]
    EMPE_INITTRMNTCO,  -- InitTrmntCode [ICL_EMP_INITTRMNTCODE]
    EMPE_NOI,          -- NatureOfInjury [ICL_EMP_NOI]
    EMPE_COI,          -- Cause of Injury [ICL_EMP_COI]
    EMP_PREPAREDDATE,  -- Date Prepared [ICL_EMP_PREPAREDDATE]
    CLADMN_DATEREPTO,  -- DateRepToClmAdm [ICL_EMP_DATEREPTOCLADM]
    XINITIALPROVIDER,  -- InitialMedProv [ICL_PARTOCC02]
    LAWY_STARTDATE,    -- DateAttrnyStrtd [ICL_EMP_ATTORNEYSTARTDATE]
    LAWY_DISCLOSURE,   -- Disclosure Date [ICL_EMP_DISCLOSUREDATE]
    OSHA_CASE_NUM,     -- OSHA Case No. [ICL_OSHA_CASE_NUM]
    BODY_PART_CODE,    -- Body Part Code [ICL_BODY_PART_CODE]
    EMPE_DEATHDATE,    -- Death Date [EMPE_DATE_OF_DEATH]
    ASSIGN_GUID,       -- Link UUID [ICL_ASSIGN_GUID]
    MCO_IDNUM,         -- MCO ID Number [ICL_EMP_MCO_IDNUM]
    PRIMARY KEY (CLIENT, ACTIVE, CLAIM, PARTNER, ROLE)
);

Learn More