User Guide‎ > ‎

Merge Code for Employee Master


[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]
[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).


See also: