Merge Code for Employee Master

for Mail Merge Word/Excel Documents and Mail Merge Word Document functions.

[EE_NO]

[AUTHORIZED]

[BADGE_NO]

[CERT_NO]

[CHI_NAME]

[SURNAME]

[OTHERNAME]

[SURNAME_PROPERCASE]

[OTHERNAME_PROPERCASE]

[CALL_NAME]

[FULLNAME]

[SALUTATION]

[HKID]

[PASSPORT]

[SEX]

[HIS_HER]

[MR_MISS]

[HIM_HER]

[HE_SHE]

[MAN_WOMAN]

[BIRTHDATE]

[MARITAL]

[PHONE]

[E_MAIL]

[PERSONAL_EMAIL]

[MOBILE]

[HOME_PHONE]

[FAX]

[POSITION]

[DEPT_CODE]

[DEPT_NAME]

[DIVISION_CODE]

[DIVISION_NAME]

[EE_CLASS]

[EE_CLASS_NAME]

[SP_SNAME]

[SP_ONAME]

[SP_HKID]

[NATIONALITY]

[SP_PASSPT]

[RES_ADDRESS]

[AREA_CODE]

[COR_ADDRESS]

[OT_TYPE]

[OT_TYPE2]

[OT_TYPE3]

[OT_TYPE4]

[OT_TYPE5]

[OT_TYPE6]

[OT_TYPE7]

[OT_TYPE8]

[DEDUCTION_TYPE]

[WORK_HRS_TYPE]

[ROSTER_CODE]

[COST_CENTRE]

[JOIN_DATE_LONG]

[JOIN_DATE]

[PROBATION_END_DATE_LONG]

[PROBATION_END_DATE]

[CONTRACT_END_DATE_LONG]

[CONTRACT_END_DATE]

[PF_DATE_LONG]

[PF_DATE]

[TERMN_DATE_LONG]

[TERMN_DATE]

[REASON_CODE]

[TERMN_REASON]

[LAST_WORKING_DATE_LONG]

[LAST_WORKING_DATE]

[RESIGNATION_DATE_LONG]

[RESIGNATION_DATE]

[WORK_LOCATION]

[LAST_APPRAISAL_DATE_LONG]

[LAST_APPRAISAL_DATE]

[NEXT_APPRAISAL_DATE_LONG]

[NEXT_APPRAISAL_DATE]

[REPORT_TO]

[EMERGENCY_CONTACT_NAME]

[EMERGENCY_CONTACT_RELATION]

[EMERGENCY_CONTACT_PHONE]

[EMERGENCY_CONTACT_MOBILE]

[PRINT_IR56E]

[BANK_CODE]

[BANK_AC]

[PAYEE_NAME]

[MPF_SP_CODE]

[SALARY_BY]

[AUTOPAY]

[DECRYPT_BASIC_SAL]

[DECRYPT_ALLOWANCE]

[DECRYPT_ALLOWANCE2]

[DECRYPT_BONUS]

[PAY_TYPE1_AMT_FORMULA]

[PAY_TYPE2_AMT_FORMULA]

[PAY_TYPE3_AMT_FORMULA]

[PAY_TYPE4_AMT_FORMULA]

[PAY_TYPE5_AMT_FORMULA]

[PAY_TYPE6_AMT_FORMULA]

[PAY_TYPE7_AMT_FORMULA]

[PAY_TYPE8_AMT_FORMULA]

[PAY_TYPE9_AMT_FORMULA]

[PAY_TYPE10_AMT_FORMULA]

[PAY_TYPE11_AMT_FORMULA]

[PAY_TYPE12_AMT_FORMULA]

[PAY_TYPE13_AMT_FORMULA]

[PAY_TYPE14_AMT_FORMULA]

[PAY_TYPE15_AMT_FORMULA]

[DECRYPT_PAY_TYPE1_AMT]

[DECRYPT_PAY_TYPE2_AMT]

[DECRYPT_PAY_TYPE3_AMT]

[DECRYPT_PAY_TYPE4_AMT]

[DECRYPT_PAY_TYPE5_AMT]

[DECRYPT_PAY_TYPE6_AMT]

[DECRYPT_PAY_TYPE7_AMT]

[DECRYPT_PAY_TYPE8_AMT]

[DECRYPT_PAY_TYPE9_AMT]

[DECRYPT_PAY_TYPE10_AMT]

[DECRYPT_PAY_TYPE11_AMT]

[DECRYPT_PAY_TYPE12_AMT]

[DECRYPT_PAY_TYPE13_AMT]

[DECRYPT_PAY_TYPE14_AMT]

[DECRYPT_PAY_TYPE15_AMT]

[DECRYPT_HOURLY_RATE1]

[DECRYPT_HOURLY_RATE2]

[DECRYPT_HOURLY_RATE3]

[DECRYPT_HOURLY_RATE4]

[DECRYPT_HOURLY_RATE5]

[DECRYPT_HOURLY_RATE6]

[SICK_RATE]

[SICK_RATE2]

[MATERNITYLEAVE_RATE]

[PFUND_TYPE]

[PFUND_EE]

[PFUND_ER]

[Voluntary_EE]

[Voluntary_ER]

[PF_PLAN_NO]

[PF_BENEFIT_PLAN_NO]

[PF_CERT_NO]

[IRD_TAX_FILE_NO]

[IRD_REMARKS]

[QUARTER]

[QUAR_ADDRESS]

[QUAR_NAT]

[QUAR_FM]

[QUAR_TO]

[DECRYPT_QUAR_RENT1]

[DECRYPT_QUAR_RENT2]

[DECRYPT_QUAR_RENT3]

[DECRYPT_QUAR_RENT4]

[OSEA_PAIDBY]

[OSEA_NAME]

[OSEA_ADD]

[OSEA_AMT]

[SHARE_OPTION]

[INS_PLAN]

[INS_GRADE]

[HOLIDAY_TYPE]

[PHOTO]1

[MEMO]

[USER01]

[USER02]

[USER03]

[USER04]

[USER05]

[USER06]

[USER07]

[USER08]

[USER09]

[USER10]

[USER11]

[USER12]

[USER13]

[USER14]

[USER15]

[USER16]

[USER17]

[USER18]

[USER19]

[USER20]

[USER21]

[USER22]

[USER23]

[USER24]

[USER25]

[EP_APPROVER_NO1]

[EP_APPROVER_NO2]

[EP_APPROVER_NO3]

[EP_APPROVER_NAME1]

[EP_APPROVER_NAME2]

[EP_APPROVER_NAME3]

[ENTITLEMENT_CODE]

[ENTITLEMENT_CODE_DESCRIPTION]

[YRS_OF_SERVICE]

[YR_OF_ENTITLEMENT]

[ENTITLED_DATE_LONG]

[ENTITLED_DATE]

[ANNUAL_LEAVE_CURRENT_YEAR_BROUGHT_FORWARD]

[ANNUAL_LEAVE_CURRENT_YEAR_ENTITLE]

[ANNUAL_LEAVE_CURRENT_YEAR_TAKEN]

[ANNUAL_LEAVE_CURRENT_YEAR_ADJUSTMENT]

[ANNUAL_LEAVE_CURRENT_BALANCE]

[ANNUAL_LEAVE_FUTURE_APPROVED]

[ANNUAL_LEAVE_FUTURE_ADJUSTMENT]

[ANNUAL_LEAVE_FUTURE_BALANCE]

[COM_LEAVE_ADJUSTMENT]

[COM_LEAVE_TAKEN]

[COM_LEAVE_BALANCE]

[SICK_LEAVE_TAKEN]

[SICK_LEAVE_BALANCE]

[FULLPAY_SICK_LEAVE_ENTITLE]

[FULLPAY_SICK_LEAVE_TAKEN]

[FULLPAY_SICK_LEAVE_BALANCE]

[DECRYPT_LAST_BASIC_SAL]

[NEW_SALARY_START_DATE_LONG]

[NEW_SALARY_START_DATE]

[EDUCATION_HISTORY]

[EDUCATION_TABLE]

[QUALIFICATION_TABLE]

[EMPLOYMENT_HISTORY]

[EMPLOYMENT_TABLE]

[PREVIOUS_EMPLOYER1]

[POSITION1]

[PROJECT1]

[PROJECT_DESCRIPTION1]

[ENDING_SALARY1]

[WORKED_PERIOD1]

[REASON_FOR_LEAVING1]

[PREVIOUS_EMPLOYER2]

[POSITION2]

[PROJECT2]

[PROJECT_DESCRIPTION2]

[ENDING_SALARY2]

[WORKED_PERIOD2]

[REASON_FOR_LEAVING2]

[PREVIOUS_EMPLOYER3]

[POSITION3]

[PROJECT3]

[PROJECT_DESCRIPTION3]

[ENDING_SALARY3]

[WORKED_PERIOD3]

[REASON_FOR_LEAVING3]

[PREVIOUS_EMPLOYER4]

[POSITION4]

[PROJECT4]

[PROJECT_DESCRIPTION4]

[ENDING_SALARY4]

[WORKED_PERIOD4]

[REASON_FOR_LEAVING4]

[PREVIOUS_EMPLOYER5]

[POSITION5]

[PROJECT5]

[PROJECT_DESCRIPTION5]

[ENDING_SALARY5]

[WORKED_PERIOD5]

[REASON_FOR_LEAVING5]

[PREVIOUS_EMPLOYER6]

[POSITION6]

[PROJECT6]

[PROJECT_DESCRIPTION6]

[ENDING_SALARY6]

[WORKED_PERIOD6]

[REASON_FOR_LEAVING6]

[PREVIOUS_EMPLOYER7]

[POSITION7]

[PROJECT7]

[PROJECT_DESCRIPTION7]

[ENDING_SALARY7]

[WORKED_PERIOD7]

[REASON_FOR_LEAVING7]

[PREVIOUS_EMPLOYER8]

[POSITION8]

[PROJECT8]

[PROJECT_DESCRIPTION8]

[ENDING_SALARY8]

[WORKED_PERIOD8]

[REASON_FOR_LEAVING8]

[PREVIOUS_EMPLOYER9]

[POSITION9]

[PROJECT9]

[PROJECT_DESCRIPTION9]

[ENDING_SALARY9]

[WORKED_PERIOD9]

[REASON_FOR_LEAVING9]

[PREVIOUS_EMPLOYER10]

[POSITION10]

[PROJECT10]

[PROJECT_DESCRIPTION10]

[ENDING_SALARY10]

[WORKED_PERIOD10]

[REASON_FOR_LEAVING10]

[CREATE_BY]

[CREATE_DATE_LONG]

[CREATE_DATE]

[LAST_UPDATE_BY]

[LAST_UPDATE_DATE_LONG]

[LAST_UPDATE_DATE]

1To adjust the size of [PHOTO], you can put these two lines into HRPro.config

<add key="PLFEE_PHOTO_Width" value="1292000"/>

<add key="PLFEE_PHOTO_Height" value="1723000"/>

where the unit of the size is EMUs (English Metric Units, One inch equates to 914400 EMUs and one centimeter is 360000).