Sage EasyPay Data Model

Entity IR21Details

Description of Entity IR21Details

IR21 refers to a set of tax forms to be generated for employees leaving Singapore after cessation of employment. The main purpose is tax clearance and it only applies to non-Singaporeans.

In Sage EasyPay, the IR21 can be generated under the following conditions:
- The employee is terminated within the current year
- The current residence status record is "FW" / "EP" / "PR"
- The employee does not have any IR8A, IR8S, Appendix 8A and Appendix 8B records in the current year

List of all Dependencies of the Entity IR21Details

Relation_1701911

Relation_1701911

Reference

List of Attributes of the Entity IR21Details

Supersede Form IR21 Date

SupersedeIR21Date

Date Of Arrival

Date of Departure

DateOfDeparture

Date Resignation Tendered

DateResignationTendered

Reasons Less Than 1 Month

ReasonsLessThan1Mth

Amount of Monies Withheld

AmtOfMoniesWithheld

Date Last Salary Paid

DateLastSalaryPaid

Amount of Last Salary Paid

AmtOfLastSalaryPaid

Period Applicable for Last Salary Paid

PeriodLastSalaryPaid

Reasons Not Withholding

ReasonsNotWithholding

Name of New Employer

NameOfNewEmployer

Tel No of New Employer

TelNoOfNewEmployer

Effective Date of Mailing Address

MailingAddEffDate

Date of Marriage

Unexercised Gains Before

UnexercisedGainsBef

Unexercised Gains After

UnexercisedGainsAft

Spouse Nationality

SpouseNationality

Has Benefits in kind

Entity Attribute PersonalSysId of the Entity IR21Details

Card of Attribute PersonalSysId of the Entity IR21Details

Name	PersonalSysId
Code	PersonalSysId
Data Type	integer
Mandatory	Yes

Description of Attribute PersonalSysId of the Entity IR21Details

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 IR21Type of the Entity IR21Details

Card of Attribute IR21Type of the Entity IR21Details

Name	IR21Type
Code	IR21Type
Data Type	smallint
Mandatory	Yes

Description of Attribute IR21Type of the Entity IR21Details

Shows the type of form for IR21, in a form of radio buttons.
Example: Original / Amended, this supersedes Form IR21 dated

Entity Attribute Supersede Form IR21 Date of the Entity IR21Details

Card of Attribute Supersede Form IR21 Date of the Entity IR21Details

Name	Supersede Form IR21 Date
Code	SupersedeIR21Date
Data Type	date
Mandatory	No

Description of Attribute Supersede Form IR21 Date of the Entity IR21Details

Shows the date of when the form was amended which supersedes the form IR21.
It is in the format: DD-MM-YYYY.

Entity Attribute Date Of Arrival of the Entity IR21Details

Card of Attribute Date Of Arrival of the Entity IR21Details

Name	Date Of Arrival
Code	DateOfArrival
Data Type	date
Mandatory	No

Description of Attribute Date Of Arrival of the Entity IR21Details

Shows the employee's date of arrival.
It is in the format: DD-MM-YYYY.

Entity Attribute Date of Departure of the Entity IR21Details

Card of Attribute Date of Departure of the Entity IR21Details

Name	Date of Departure
Code	DateOfDeparture
Data Type	date
Mandatory	No

Description of Attribute Date of Departure of the Entity IR21Details

Shows the employee's date of departure.
It is in the format: DD-MM-YYYY.

Entity Attribute Date Resignation Tendered of the Entity IR21Details

Card of Attribute Date Resignation Tendered of the Entity IR21Details

Name	Date Resignation Tendered
Code	DateResignationTendered
Data Type	date
Mandatory	No

Description of Attribute Date Resignation Tendered of the Entity IR21Details

Shows the date of resignation tendered for the employee.
It is in the format: DD-MM-YYYY.

Entity Attribute Reasons Less Than 1 Month of the Entity IR21Details

Card of Attribute Reasons Less Than 1 Month of the Entity IR21Details

Name	Reasons Less Than 1 Month
Code	ReasonsLessThan1Mth
Data Type	char(100)
Mandatory	No

Description of Attribute Reasons Less Than 1 Month of the Entity IR21Details

Stores the reason if less than 1 month's notice was given to IRAS before the employee's cessation.

Entity Attribute Amount of Monies Withheld of the Entity IR21Details

Card of Attribute Amount of Monies Withheld of the Entity IR21Details

Name	Amount of Monies Withheld
Code	AmtOfMoniesWithheld
Data Type	double
Mandatory	No

Description of Attribute Amount of Monies Withheld of the Entity IR21Details

Shows the amount of monies being withheld to pend the tax clearance.

Entity Attribute Date Last Salary Paid of the Entity IR21Details

Card of Attribute Date Last Salary Paid of the Entity IR21Details

Name	Date Last Salary Paid
Code	DateLastSalaryPaid
Data Type	date
Mandatory	No

Description of Attribute Date Last Salary Paid of the Entity IR21Details

Shows the date of when the last salary was paid.
It is in the format: DD-MM-YYYY.

Entity Attribute Amount of Last Salary Paid of the Entity IR21Details

Card of Attribute Amount of Last Salary Paid of the Entity IR21Details

Name	Amount of Last Salary Paid
Code	AmtOfLastSalaryPaid
Data Type	double
Mandatory	No

Description of Attribute Amount of Last Salary Paid of the Entity IR21Details

Shows the amount of the last salary paid.

Entity Attribute Period Applicable for Last Salary Paid of the Entity IR21Details

Card of Attribute Period Applicable for Last Salary Paid of the Entity IR21Details

Name	Period Applicable for Last Salary Paid
Code	PeriodLastSalaryPaid
Data Type	char(50)
Mandatory	No

Description of Attribute Period Applicable for Last Salary Paid of the Entity IR21Details

Shows the period of when the last salary was paid.

Entity Attribute Reasons Not Withholding of the Entity IR21Details

Card of Attribute Reasons Not Withholding of the Entity IR21Details

Name	Reasons Not Withholding
Code	ReasonsNotWithholding
Data Type	char(100)
Mandatory	No

Description of Attribute Reasons Not Withholding of the Entity IR21Details

Are these all the monies you can withhold from the date of notification of resignation / terminating / posting overseas?
If no, state your reason.

Entity Attribute Name of New Employer of the Entity IR21Details

Card of Attribute Name of New Employer of the Entity IR21Details

Name	Name of New Employer
Code	NameOfNewEmployer
Data Type	char(50)
Mandatory	No

Description of Attribute Name of New Employer of the Entity IR21Details

Shows the name of the new employer.

Entity Attribute Tel No of New Employer of the Entity IR21Details

Card of Attribute Tel No of New Employer of the Entity IR21Details

Name	Tel No of New Employer
Code	TelNoOfNewEmployer
Data Type	char(30)
Mandatory	No

Description of Attribute Tel No of New Employer of the Entity IR21Details

Shows the telephone number of the new employer.

Entity Attribute Effective Date of Mailing Address of the Entity IR21Details

Card of Attribute Effective Date of Mailing Address of the Entity IR21Details

Name	Effective Date of Mailing Address
Code	MailingAddEffDate
Data Type	date
Mandatory	No

Description of Attribute Effective Date of Mailing Address of the Entity IR21Details

Shows the effective date of the mailing address.
It is in the format: DD-MM-YYYY.

Entity Attribute Date of Marriage of the Entity IR21Details

Card of Attribute Date of Marriage of the Entity IR21Details

Name	Date of Marriage
Code	DateOfMarriage
Data Type	date
Mandatory	No

Description of Attribute Date of Marriage of the Entity IR21Details

Shows the date of marriage.
It is in the format: DD-MM-YYYY.

Entity Attribute Unexercised Gains Before of the Entity IR21Details

Card of Attribute Unexercised Gains Before of the Entity IR21Details

Name	Unexercised Gains Before
Code	UnexercisedGainsBef
Data Type	smallint
Mandatory	No

Description of Attribute Unexercised Gains Before of the Entity IR21Details

Indicates if it is an unexercised ESOP / ESOW granted before 1 January 2003, in a form of a checkbox.

Entity Attribute Unexercised Gains After of the Entity IR21Details

Card of Attribute Unexercised Gains After of the Entity IR21Details

Name	Unexercised Gains After
Code	UnexercisedGainsAft
Data Type	smallint
Mandatory	No

Description of Attribute Unexercised Gains After of the Entity IR21Details

Indicates if it is an unexercised ESOP / ESOW granted on or after 1 January 2003, in a form of a checkbox.

Entity Attribute Spouse Nationality of the Entity IR21Details

Card of Attribute Spouse Nationality of the Entity IR21Details

Name	Spouse Nationality
Code	SpouseNationality
Data Type	char(50)
Mandatory	No

Description of Attribute Spouse Nationality of the Entity IR21Details

Shows the nationality of the spouse.

Entity Attribute Has Benefits in kind of the Entity IR21Details

Card of Attribute Has Benefits in kind of the Entity IR21Details

Name	Has Benefits in kind
Code	MoniesStatus
Data Type	smallint
Mandatory	No

Description of Attribute Has Benefits in kind of the Entity IR21Details

Indicates if the employee has Benefits-In-Kind, in a form of a checkbox.