The family module is used to store details on the family member of an employee. Quite often, the number of dependents has an impact on tax relief calculation. This feature is divided into 3 sections: General (Family), Education (FamilyEduRec) and Attachment (FamilyAttachment).

This attribute is the system generated identifier. It is blind to the user. It also holds the primary key for the Personal table.

A system generated identifier. It is blind to the user. It also holds the primary key for the Family table.

Shows the person's name.

Shows the gender of the family member.
Example: Male = "1". Female = "0".

Shows the identity number of the person.

Stores the date of birth of the person.
It is in the format DD-MM-YYYY.

Stores the contact number.

Stores a second contact number.

Stores the email address.

Stores the address of this family member. This excludes the country, state, city and postal code.

Stores the country of the person's / organisation's address.

Stores the state of the person's / organisation's address.

Stores the city of the person's / organisation's address.

Stores the postal code of the person's address.

Stores the contact order of the person, i.e. 1 means to contact that family member first.

Shows the name of the person's workplace.

Indicates if the family member is handicapped or not, in a form of a checkbox.

Shows the marital status of this person.

Shows the country in which the passport was issued.

Shows the check digit for the identity number, i.e. the alphabet at the end of the identity number. This is to prevent anyone from entering Singapore with an illegal identity number.

Shows if the person had used childcare leave during the first year.