I_HCM_ESSFAMILYMEMBER

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.

-- My Family Members
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_HCM_ESSFAMILYMEMBER (
    ENDDATE,
    HCMDRAFTSEQUENTIALNUMBER,
    HCMOBJECTIDENTIFICATION,
    HCMPERSONNELNUMBER,
    HCMRECORDISLOCKED,
    HCMSEQUENTIALNUMBER,
    HCMSUBTYPE,
    STARTDATE,
    _CONTRACT,
    HCMDEFAULTDATE,
    HCMETAG,
    HCMFAMILYMEMBER2NDNAME,
    HCMFAMILYMEMBER2NDNATLTYCODE,
    HCMFAMILYMEMBER2NDTITLECODE,
    HCMFAMILYMEMBER3RDNATLTYCODE,
    HCMFAMILYMEMBERAUTHZNNMBRCODE,
    HCMFAMILYMEMBERBIRTHDATE,
    HCMFAMILYMEMBERBIRTHNAME,
    HCMFAMILYMEMBERCHILDBONUSCODE,
    HCMFAMILYMEMBERCHILDTYPECODE,
    HCMFAMILYMEMBERCNTRYOFBRTHCODE,
    HCMFAMILYMEMBERCOMPLETENAME,
    HCMFAMILYMEMBEREMPLOYERCODE,
    HCMFAMILYMEMBERFIRSTNAME,
    HCMFAMILYMEMBERGENDERCODE,
    HCMFAMILYMEMBERINITIALS,
    HCMFAMILYMEMBERINSURANCENUMBER,
    HCMFAMILYMEMBERLASTNAME,
    HCMFAMILYMEMBERNAMEFORMATCODE,
    HCMFAMILYMEMBERNAMEPREFIXCODE,
    HCMFAMILYMEMBERNATIONALITYCODE,
    HCMFAMILYMEMBEROTHERTITLECODE,
    HCMFAMILYMEMBERPLACEOFBRTHNAME,
    HCMFAMILYMEMBERSCHOOLTYPECODE,
    HCMFAMILYMEMBERSTATEOFBRTHCODE,
    HCMFAMILYMEMBERTITLECODE,
    HCMFAMILYMEMBERTYPECODE,
    HCMFAMMBRADDRESSOFCHILDCODE,
    HCMFAMMBRALLWNCAUTHZNCODE,
    HCMFAMMBRCHILDALLOWANCECODE,
    HCMFAMMBRCHILDALLWNCENTLMNT,
    HCMFAMMBREDUCINSTITUTENAME,
    HCMFAMMBRISEMERGENCYCONTACT,
    HCMFAMMBRREFPERSNWORKAGREEMENT,
    HCMFAMMBRRELSHPTOCHILDCODE,
    HCMFAMMBRSICKNESSCERTAUTHZN,
    HCMFAMMBRSOCLINSURNMBR1STPRT,
    HCMFAMMBRSOCLINSURNMBR2NDPRT,
    HCMFAMMEMBER2NDNAMEPREFIXCODE,
    HCMFAMMEMBEREDUCATIONENDDATE,
    HCMINFOTYPERECORDHASTEXT,
    HCMINFOTYPERECORDISHISTORICAL,
    HCMINFOTYPERECORDSCREENCTRL,
    HCMMASTERDATACHANGEREASON,
    HCMRECORDISSTOREDINDATABASE,
    HCMSUBTYPETEXT,
    HCMVALIDITYENDDATE,
    HCMVALIDITYSTARTDATE,
    HCMVALIDITYSTARTDATEFIELDCTRL,
    LASTCHANGEDBYUSER,
    LASTCHANGEDDATE,
    PRIMARY KEY (ENDDATE, HCMDRAFTSEQUENTIALNUMBER, HCMOBJECTIDENTIFICATION, HCMPERSONNELNUMBER, HCMRECORDISLOCKED, HCMSEQUENTIALNUMBER, HCMSUBTYPE, STARTDATE)
);