Load Worker Extra information using HDL
Content
Hi all,
I want to load worker extra information using HDL. Now when I download the worker.dat file I don't see worker extra information which I defined in the front end appearing in the HDL So my questions are
1. How to load our specific defined EIT using HDL
2.Can anyone send me a sample version of worker.day which can load my EIT . Also I see some posts which suggest running a query to get some values which need to be supplied to HDL to load the data.
Can someone help answer the above questions.
METADATA|WorkerExtraInfo|FLEX:PER_PERSON_EIT_EFF|EFF_CATEGORY_CODE|_JOIN_PLACE(PER_PERSON_EIT_EFF=HRX_CN_MILITARY_INFO)|_JOIN_DATE(PER_PERSON_EIT_EFF=HRX_CN_MILITARY_INFO)|_APPROVE_DATE_LEAVE(PER_PERSON_EIT_EFF=HRX_CN_MILITARY_INFO)|_APPROVE_UNIT_LEAVE(PER_PERSON_EIT_EFF=HRX_CN_MILITARY_INFO)|_LAST_POSITION(PER_PERSON_EIT_EFF=HRX_CN_MILITARY_INFO)|_LAST_RANK(PER_PERSON_EIT_EFF=HRX_CN_MILITARY_INFO)|_LAST_RANK_Display(PER_PERSON_EIT_EFF=HRX_CN_MILITARY_INFO)|_LAST_LEVEL(PER_PERSON_EIT_EFF=HRX_CN_MILITARY_INFO)|_LAST_LEVEL_Display(PER_PERSON_EIT_EFF=HRX_CN_MILITARY_INFO)|_LAST_PROF_TITLE_LEVEL(PER_PERSON_EIT_EFF=HRX_CN_MILITARY_INFO)|_LAST_SALARY_GRADE(PER_PERSON_EIT_EFF=HRX_CN_MILITARY_INFO)|_RESERVE_OFFICIAL_RESIGNATION(PER_PERSON_EIT_EFF=HRX_CN_MILITARY_INFO)|_RESERVE_OFFICIAL_RESIGNATION_Display(PER_PERSON_EIT_EFF=HRX_CN_MILITARY_INFO)|_WORK_LIFE_START_DATE(PER_PERSON_EIT_EFF=HRX_CN_OTHER_EMPLOYEE_INFO)|_IDENTITY(PER_PERSON_EIT_EFF=HRX_CN_PERSONALITY_INFO)|_IDENTITY_Display(PER_PERSON_EIT_EFF=HRX_CN_PERSONALITY_INFO)|_FILE_NUMBER(PER_PERSON_EIT_EFF=HRX_CN_PERSONAL_FILE_INFO)|_ARCHIVE_FORMAT(PER_PERSON_EIT_EFF=HRX_CN_PERSONAL_FILE_INFO)|_ARCHIVE_FORMAT_Display(PER_PERSON_EIT_EFF=HRX_CN_PERSONAL_FILE_INFO)|_TRANSFER_IN_DATE(PER_PERSON_EIT_EFF=HRX_CN_PERSONAL_FILE_INFO)|_SOURCE_UNIT(PER_PERSON_EIT_EFF=HRX_CN_PERSONAL_FILE_INFO)|_TRANSFER_OUT_DATE(PER_PERSON_EIT_EFF=HRX_CN_PERSONAL_FILE_INFO)|_TARGET_UNIT(PER_PERSON_EIT_EFF=HRX_CN_PERSONAL_FILE_INFO)|_ORIGINAL_COPY_LOCATION(PER_PERSON_EIT_EFF=HRX_CN_PERSONAL_FILE_INFO)|_DUPLICATE_COPY_LOCATION(PER_PERSON_EIT_EFF=HRX_CN_PERSONAL_FILE_INFO)|_PARTY_TYPE(PER_PERSON_EIT_EFF=HRX_CN_POLITICAL_INFO)|_PARTY_TYPE_Display(PER_PERSON_EIT_EFF=HRX_CN_POLITICAL_INFO)|_STATUS(PER_PERSON_EIT_EFF=HRX_CN_POLITICAL_INFO)|_STATUS_Display(PER_PERSON_EIT_EFF=HRX_CN_POLITICAL_INFO)|_INTRODUCER1(PER_PERSON_EIT_EFF=HRX_CN_POLITICAL_INFO)|_INTRODUCER2(PER_PERSON_EIT_EFF=HRX_CN_POLITICAL_INFO)|_JOIN_PLACE(PER_PERSON_EIT_EFF=HRX_CN_POLITICAL_INFO)|_JOIN_UNIT(PER_PERSON_EIT_EFF=HRX_CN_POLITICAL_INFO)|_JOIN_DATE(PER_PERSON_EIT_EFF=HRX_CN_POLITICAL_INFO)|_MEMBER_FROM_DATE(PER_PERSON_EIT_EFF=HRX_CN_POLITICAL_INFO)|_EXCEPTION_DATE(PER_PERSON_EIT_EFF=HRX_CN_POLITICAL_INFO)|_EXCEPTION_TYPE(PER_PERSON_EIT_EFF=HRX_CN_POLITICAL_INFO)|_EXCEPTION_TYPE_Display(PER_PERSON_EIT_EFF=HRX_CN_POLITICAL_INFO)|_EXCEPTION_REASON(PER_PERSON_EIT_EFF=HRX_CN_POLITICAL_INFO)|_COMMUNITY(PER_PERSON_EIT_EFF=HRX_IN_MISCELLANEOUS)|_COMMUNITY_DisplayValue(PER_PERSON_EIT_EFF=HRX_IN_MISCELLANEOUS)|_CASTE(PER_PERSON_EIT_EFF=HRX_IN_MISCELLANEOUS)|_HEIGHT(PER_PERSON_EIT_EFF=HRX_IN_MISCELLANEOUS)|_WEIGHT(PER_PERSON_EIT_EFF=HRX_IN_MISCELLANEOUS)|_EX_SERVICE_PERSON(PER_PERSON_EIT_EFF=HRX_IN_MISCELLANEOUS)|_RESIDENTIAL_STATUS(PER_PERSON_EIT_EFF=HRX_IN_MISCELLANEOUS)|_RESIDENTIAL_STATUS_Display(PER_PERSON_EIT_EFF=HRX_IN_MISCELLANEOUS)|_PAN_APPLIED(PER_PERSON_EIT_EFF=HRX_IN_MISCELLANEOUS)|_PAN_REFERENCE_NUMBER(PER_PERSON_EIT_EFF=HRX_IN_MISCELLANEOUS)|_SEQUENCE_NUMBER(PER_PERSON_EIT_EFF=HRX_IN_NOMINATION)|_BENEFIT_TYPE(PER_PERSON_EIT_EFF=HRX_IN_NOMINATION)|_BENEFIT_TYPE_Display(PER_PERSON_EIT_EFF=HRX_IN_NOMINATION)|_CONTACT_PERSON(PER_PERSON_EIT_EFF=HRX_IN_NOMINATION)|_CONTACT_PERSON_Display(PER_PERSON_EIT_EFF=HRX_IN_NOMINATION)|_PERCENT_SHARE(PER_PERSON_EIT_EFF=HRX_IN_NOMINATION)|_NOMINATION_END_REASON(PER_PERSON_EIT_EFF=HRX_IN_NOMINATION)|numberofdependents(PER_PERSON_EIT_EFF=ORA_GPY_PER_DTLS)|distanceinkilometers(PER_PERSON_EIT_EFF=ORA_GPY_PER_DTLS)|oraHrxCaDgAboriginal(PER_PERSON_EIT_EFF=ORA_HRX_CA_DESIGNATED_GROUPS)|oraHrxCaDgDisabled(PER_PERSON_EIT_EFF=ORA_HRX_CA_DESIGNATED_GROUPS)|oraHrxCaDgVisibleMinority(PER_PERSON_EIT_EFF=ORA_HRX_CA_DESIGNATED_GROUPS)|PersonExtraInfoId|EffectiveStartDate|EffectiveEndDate|PersonId|PersonNumber|InformationType|PeiInformationCategory|SourceSystemOwner|SourceSystemId|GUID|CategoryCode|SourceRefTableName=<source-table-name>|SourceRef001=<source-column-001>|SourceRef002=<source-column-002>|SourceRef003=<source-column-003>|SourceRef004=<source-column-004>|SourceRef005=<source-column-005>|SourceRef006=<source-column-006>|SourceRef007=<source-column-007>|SourceRef008=<source-column-008>|SourceRef009=<source-column-009>|SourceRef010=<source-column-010>