1.5. Employee Family

1.5. Employee Family

How to fill up the employee family template file for data migration?
  1. Download the Employee Family template file as per attached or download at Home -> HRIS -> General Main -> Employee List ->  Edit Employee -> Personal (Family) -> Click on  Export button -> Click on Data Export button.
  2. Open with Microsoft Excel 2003 & above.
  3. Fill data for each column and further explanation for each column as below:
Column Name
Description
Remark
Employee Number
Employee Identified Number
Compulsory.
Employee Name
Employee Name
Compulsory.
Family Member Name
Employee Family Member Name
Compulsory.
Date of Birth
Employee Family Member's Date of Birth
Optional. Date format in dd/MMM/yyyy.
Relationship Description
Employee Family Member's Relationship
Compulsory.
New IC Number
Employee Family Member's New IC Number
Compulsory.
Old IC Number
Employee Family Member's Old IC Number
Optional.
Birth Certificate Number
Employee Family Member's Birth Certificate Number
Optional.
Occupation Title
Employee Family Member's Occupation
Optional.
Gender Description
Employee Family Member's Gender
Optional.
Telephone Number
Employee Family Member's Telephone Number
Optional.
Fax Number
Employee Family Member's Fax Number
Optional.
Address 1
Employee Family Member's Address
Optional.
Address 2
Employee Family Member's Address
Optional.
Address 3
Employee Family Member's Address
Optional.
Post Code
Employee Family Member's Address Post Code
Optional.
Country Description
Employee Family Member's Address Country
Optional.
State Description
Employee Family Member's Address State
Optional.
Email Address
Employee Family Member's Email Address
Optional.
Marital Certificate Number
Employee's Marital Certificate Number
Optional. It is only applicable to husband/wife.
Marital Certificate Date
Employee's Marital Certificate Date
Optional. Date format in dd/MMM/yyyy. It is only applicable to husband/wife.
Remark
Remark
Optional.
Working?
Employee Family Member's Working Status
Optional.
Income Tax Number
Employee Family Member's Income Tax Number
Optional. It is only applicable to husband/wife.
Tax Branch Description
Employee Family Member's Income Tax Branch
Optional. It is only applicable to husband/wife.
Deceased Date
Employee Family Member's Deceased Date
Optional. Date format in dd/MMM/yyyy.
Nationality Description
Employee Family Member's Nationality
Optional.
Passport Number
Employee Family Member's Passport Number
Optional.
Passport Expiry Date
Employee Family Member's Passport Expiry Date
Optional. Date format in dd/MMM/yyyy.
Immigration Number
Employee Family Member's Immigration Number
Optional.
Immigration Expiry Date
Employee Family Member's Immigration Expiry Date
Optional. Date format in dd/MMM/yyyy.
Include In Expense Claim?
Show in Expense Claim for Medical claim purpose.
Optional. It only applicable for Claim Module.

4. Save the migration file as per default Microsoft Excel (*.xls/ xlsx) format. 

5. Click on Import button -> Click on Select File button to browse and to upload the completed file.

    • Related Articles

    • I could not select family member from expense application, why?

      Question:  I had created the Expense Layout with "Family" item. However, when I try to apply for expense claim I could not select any family member from the "Family" field which I had updated my family member in the system. Answer:  This is caused by ...

    • 1.1. Employee Details

      1. Employee Details This section is guide you on how to migrate employee details and how to verify employee details. After data migration is complete, there is a must to have data verification process in place to check the accuracy of data. iWoWHR ...

    • 5. Employee Information Update

      Here's how you can update your personal information. Follow these 8 simple steps. STEP 1 : Login to iWoW HRMS as Employee. STEP 2 : Go to Employee > Personal > Personal Detail. STEP 3 : At the Employee Personal Detail screen, update on the changes ...

    • 3.2 How to submit employee information or HR information changes?

      User are able to amend their personal information such as personal details, emergency contact, employee miscellaneous, education, family, skill, working history and statutory account using iWoWHRMS. All the changes performed by the user will be ...

    • 3.10. How to use export & import features to migrate employee informations to new company?

      iWoWHRMS provide the export/import feature which enables the user to ease the task of create employee records or migrate employee information. In order to migrate some of employees information to a new company, user are able to use advanced search to ...