User Guide‎ > ‎

Import Fields for Employee Master

[EE_NO]*
[DEPT_CODE]*
[DIVISION_CODE]
[BIRTHDATE]
[PAYEE_NAME]*
[OT_TYPE]*
[JOIN_DATE]*
[GROUP_JOIN_DATE]
[ENTITLEMENT_CODE]*
[WORK_HRS_TYPE]
[BADGE_NO]
[CHI_NAME]
[SURNAME]*
[OTHERNAME]*
[CALL_NAME]
[SALUTATION]
[HKID]
[PASSPORT]
[SEX] (M/F)
[MARITAL]  (1=Single/Widowed/Divorced/Separated, 2=Married)
[PHONE]
[EMAIL]
[PERSONAL_EMAIL]
[MOBILE]
[POSITION]
[EE_CLASS]
[AUTOPAY_CLASS]
[SP_SNAME]
[SP_ONAME]
[SP_HKID]
[NATIONALITY]
[SP_PASSPT]
[RES_ADDRESS]
[AREA_CODE] (H=Hong Kong, K=Kowloon, N=N.T.)
[COR_ADDRESS]
[HOME_PHONE]
[OT_TYPE2]
[OT_TYPE3]
[OT_TYPE4]
[OT_TYPE5]
[OT_TYPE6]
[OT_TYPE7]
[OT_TYPE8]
[DEDUCTION_TYPE]
[ROSTER_CODE]
[COST_CENTRE]
[PF_DATE]
[PROBATION_END_DATE]
[CONTRACT_END_DATE]
[TERMN_DATE]
[REASON_CODE]
[TERMN_REASON]
[WORK_LOCATION]
[LAST_APPRAISAL_DATE]
[NEXT_APPRAISAL_DATE]
[REPORT_TO]
[EMERGENCY_CONTACT_NAME]
[EMERGENCY_CONTACT_RELATION]
[EMERGENCY_CONTACT_PHONE]
[EMERGENCY_CONTACT_MOBILE]
[PRINT_IR56E] (Y/N)
[PRINT_IR56FG] (Y/N)
[AUTOPAY] (Y=Autopay, H=Cash,N=Cheque/Others)
[BANK_CODE]
[BANK_AC]
[MPF_SP_CODE]
[SALARY_BY] (M=Monthly,D=Daily,H=Hourly, DD=Daily by Day Type, HD=Hourly by Day Type)
[BASIC_SAL]
[ALLOWANCE]
[ALLOWANCE2]
[BONUS]
[PAY_TYPE1_AMT]
[PAY_TYPE2_AMT]
[PAY_TYPE3_AMT]
[PAY_TYPE4_AMT]
[PAY_TYPE5_AMT]
[PAY_TYPE6_AMT]
[PAY_TYPE7_AMT]
[PAY_TYPE8_AMT]
[PAY_TYPE9_AMT]
[PAY_TYPE10_AMT]
[PAY_TYPE11_AMT]
[PAY_TYPE12_AMT]
[PAY_TYPE13_AMT]
[PAY_TYPE14_AMT]
[PAY_TYPE15_AMT]
[PAY_TYPE1_DESC]
[PAY_TYPE2_DESC]
[PAY_TYPE3_DESC]
[PAY_TYPE4_DESC]
[PAY_TYPE5_DESC]
[PAY_TYPE6_DESC]
[PAY_TYPE7_DESC]
[PAY_TYPE8_DESC]
[PAY_TYPE9_DESC]
[PAY_TYPE10_DESC]
[PAY_TYPE11_DESC]
[PAY_TYPE12_DESC]
[PAY_TYPE13_DESC]
[PAY_TYPE14_DESC]
[PAY_TYPE15_DESC]
[HOURLY_RATE1]
[HOURLY_RATE2]
[HOURLY_RATE3]
[HOURLY_RATE4]
[HOURLY_RATE5]
[HOURLY_RATE6]
[SICK_RATE]
[SICK_RATE2]
[MATERNITYLEAVE_RATE]
[PFUND_TYPE]
[PFUND_EE]
[PFUND_ER]
[Voluntary_EE]
[Voluntary_ER]
[EEVC_SIGN] ($/%)
[ERVC_SIGN] ($/%)
[PF_PLAN_NO]
[PF_BENEFIT_PLAN_NO]
[PF_CERT_NO]
[IRD_TAX_FILE_NO]
[IRD_REMARKS]
[MAIN_ER]
[QUARTER] (Y/N)
[QUAR_ADDRESS]
[QUAR_NAT]
[QUAR_FM]
[QUAR_TO]
[QUAR_RENT1]
[QUAR_RENT2]
[QUAR_RENT3]
[QUAR_RENT4]
[Q2_ADDRESS]
[Q2_NAT]
[Q2_FM]
[Q2_TO]
[Q2_RENT1]
[Q2_RENT2]
[Q2_RENT3]
[Q2_RENT4]
[PREVIOUS_EMPLOYER]
[OSEA_PAIDBY] (Y/N)
[OSEA_NAME]
[OSEA_ADD]
[OSEA_AMT]
[SHARE_OPTION] (0/1)
[IS_NON_EMPLOYEE_IR56M] (0/1)
[IR56M_COMPANY_NAME]
[IR56M_COMPANY_CHINESE_NAME]
[IR56M_BR_NO]
[INS_PLAN]
[INS_GRADE]
[HOLIDAY_TYPE] (P=Public Holiday, S=Statutory Holiday, N=N/A)
[MEMO]
[USER01]
[USER02]
[USER03]
[USER04]
[USER05]
[USER06]
[USER07]
[USER08]
[USER09]
[USER10]
[USER11]
[USER12]
[USER13]
[USER14]
[USER15]
[USER16] (0/1)
[USER17] (0/1)
[USER18] (0/1)
[USER19] (0/1)
[USER20] (0/1)
[USER21]
[USER22]
[USER23]
[USER24]
[USER25]
[EP_PASSWORD]
[EP_APPROVER_NO1]
[EP_APPROVER_NO2]
[EP_APPROVER_NO3]
[EP_DELEGATED_TO]
[EP_DELEGATED_START_DATE]
[EP_DELEGATED_END_DATE]
[EP_LOGIN] (0/1)
[EP_NOTICEBOARD_ADMIN] (0/1)
[EP_NOTICEBOARD_ADMIN_OWN_DEPT_ONLY] (0/1)
[EP_SHOW_ON_PHONE_LIST] (0/1)
[EP_SHOW_MOBILE_PHONE] (0/1)
[EP_SHOW_COMPANY_CALENDAR] (0/1)
[EP_COMPANY_CALENDAR_OWN_DEPT_ONLY] (0/1)
[EP_SHOW_UPDATE_ROSTER] (0/1)
[EP_SHOW_SUBORDINATE_PROFILE] (0/1)
[EP_ENABLE_CL_ENTITLEMENT_APPLICATION] (0/1)
[EP_DISABLE_SALARY_HISTORY] (0/1)
[EP_ALLOW_ON_BEHALF_APPPLICATION] (0/1)
[EP_ALLOW_ON_BEHALF_APPPLICATION_OWN_DEPT_ONLY] (0/1)
[EP_SHOW_DIRECTORY] (0/1)
[EP_DIRECTORY_OWN_DEPT_ONLY] (0/1)
[EP_ENABLE_WEBLEAVE] (0/1)
[EP_ENABLE_LEAVE_APPLICATION] (0/1)
[EP_ALLOW_MASS_APPROVAL] (0/1)
[EP_SUPPRESS_APPROVER_EMAIL_NOTIFICATION] (0/1)
[EP_CALENDAR_SHOW_BIRTHDAY] (0/1)
[EP_DISALLOW_VIEW_SALARY_IN_SUBORDINATE_PROFILE] (0/1)
[EP_APPROVED_EMAIL_CC_LIST]
[EP_IS_LOGOUT_RETURN_HOME_PAGE] (0/1)
[EP_APPROVAL_WORKFLOW] (-1 = Default, 0 = Any Approver, 1 = All Approver, 2 = By Level)
[HK_INCOME_TAX] (0/1)
[EMAIL_PAYSLIP] (0/1)
[NO_PREPAID_PAYROLL] (0/1)
[USE_PERSONAL_EMAIL_FOR_PAYSLIP] (0/1)
[USE_PERSONAL_EMAIL_FOR_IR_FORMS_REPORTS] (0/1)
[NON_CONTINUOUS_CONTRACT_EE] (0/1)
[PART_TIME_EMPLOYEE] (0/1)
[CASUAL_EMPLOYEE] (0/1)
[CASUAL_EMPLOYEE_UNDER_MASTER_TRUST_SCHEME] (0/1)
[OVERSEAS_EMPLOYEE] (0/1)
[VISA_START_DATE]
[ENABLE_ATTENDANCE_RECORD] (0/1)
[WEBLEAVE_SHOW_ATTENDANCE] (0/1)
[WEBLEAVE_SHOW_LEAVE_BALANCE] (0/1)
[EA02007_EXCEMPTION] (0/1)
[ENABLE_SHIFT_DIFFERENTIAL_PAY] (0/1)
[ENABLE_TIMESHEET_WITHOUT_TIME_CLOCK_INFO] (0/1)
[INTRODUCE_BY]
[IS_NEW_STAFF_REFERRAL_BONUS_PAID] (0/1)
[IS_INTRODUCER_REFERRAL_BONUS_PAID] (0/1)
[REFERRAL_BONUS_BATCH_NO]

[START_DATE] - The start Date in Appointment History

* - Mandatory fields when create

To get the full list of fields of employee master of your version, press the Export button from Employee Master  to export a full list of fields of employee master that match your version.

See also