Entity ResidenceStatusRecord

Description of Entity ResidenceStatusRecord

Each employee can have multiple residency status record, of which only one will be used in the tax and statutory contributions calculation. The first record is created when the personal record is created. If there is a change in residency status, use this feature to create additional records.

This entity would record the change of residence status of the person. To check for the latest status for a particular person, the system has to compare the status change date with the system date.


List of all Dependencies of the Entity ResidenceStatusRecord

Name

Code

Class Name

Relation_21767

Relation_21767

Reference

Relation_20382

Relation_20382

Reference


List of Attributes of the Entity ResidenceStatusRecord

Name

Code

PersonalSysId

PersonalSysId

Effective Date

ResStatusEffectiveDate

Career Code

ResStatusCareerId

Marked as Current

ResStatusCurrent

Remarks

ResStatusRemarks


Entity Attribute PersonalSysId of the Entity ResidenceStatusRecord

Card of Attribute PersonalSysId of the Entity ResidenceStatusRecord

Name

PersonalSysId

Code

PersonalSysId

Data Type

integer

Mandatory

Yes


Description of Attribute PersonalSysId of the Entity ResidenceStatusRecord

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


Entity Attribute Effective Date of the Entity ResidenceStatusRecord

Card of Attribute Effective Date of the Entity ResidenceStatusRecord

Name

Effective Date

Code

ResStatusEffectiveDate

Data Type

date

Mandatory

Yes


Description of Attribute Effective Date of the Entity ResidenceStatusRecord

Shows the effective date of the residence status. It also holds the primary key for the ResidenceStatusRecord table.
It is usually in the format: DD-MM-YYYY.
For locals, this is usually their birth date. For permanent residents, it would be the date that they received their permanent residency status. For those on work or employment passes, it is the issue date of the pass.


Entity Attribute Career Code of the Entity ResidenceStatusRecord

Card of Attribute Career Code of the Entity ResidenceStatusRecord

Name

Career Code

Code

ResStatusCareerId

Data Type

char(20)

Mandatory

No


Description of Attribute Career Code of the Entity ResidenceStatusRecord

Shows the identity of the career for the employee. This is used to differentiate and highlight a progression of residency status. It can be that an employee is on a work or employment pass and then he / she receives permanent residency status.
Example: FirstRecord / Transfer / Promotion / SalaryAdjust etc


Entity Attribute Marked as Current of the Entity ResidenceStatusRecord

Card of Attribute Marked as Current of the Entity ResidenceStatusRecord

Name

Marked as Current

Code

ResStatusCurrent

Data Type

smallint

Mandatory

No


Description of Attribute Marked as Current of the Entity ResidenceStatusRecord

Indicates if the employee is currently employed in the company, in a form of a checkbox.


Entity Attribute Remarks of the Entity ResidenceStatusRecord

Card of Attribute Remarks of the Entity ResidenceStatusRecord

Name

Remarks

Code

ResStatusRemarks

Data Type

char(100)

Mandatory

No


Description of Attribute Remarks of the Entity ResidenceStatusRecord

Stores any remarks about the residence status record.