Entity IR21A3Record

Description of Entity IR21A3Record

Details of unexpected or restricted Employee Stock Option (ESOP) plans of unvested or restricted shares under other forms of Employee Share Ownership (ESOW) plans as at date of cessation of employment / departure from Singapore and would be tracked by the employer.


List of all Dependencies of the Entity IR21A3Record

Name

Code

Class Name

Relation_1701913

Relation_1701913

Reference


List of Attributes of the Entity IR21A3Record

Name

Code

PersonalSysId

PersonalSysId

IR21A3SysId

IR21A3SysId

IR21 Appendix3 Stock Option Type

IR21A3StockOptionType

RCB No

RCBNo

Company ID Type

CompanyIDType

Name

CompanyName

Date Stock Granted

DateStockGranted

Exercise Price Stock

ExercisePriceStock

Market Value Stock Grant

MktValueStockGrant

Market Value Exercise Stock

MktValueExerciseStock

Number of Shares Acquired

SharesAcquired

Type Plan Granted

TypePlanGranted

Date of Expiry of Exercise

DateOfExpiryOfExercise


Entity Attribute PersonalSysId of the Entity IR21A3Record

Card of Attribute PersonalSysId of the Entity IR21A3Record

Name

PersonalSysId

Code

PersonalSysId

Data Type

integer

Mandatory

Yes


Description of Attribute PersonalSysId of the Entity IR21A3Record

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 IR21A3SysId of the Entity IR21A3Record

Card of Attribute IR21A3SysId of the Entity IR21A3Record

Name

IR21A3SysId

Code

IR21A3SysId

Data Type

integer

Mandatory

Yes


Description of Attribute IR21A3SysId of the Entity IR21A3Record

A system generated identity. It is blind to the user. This acts as a primary key for the IR21A3Record table.


Entity Attribute IR21 Appendix3 Stock Option Type of the Entity IR21A3Record

Card of Attribute IR21 Appendix3 Stock Option Type of the Entity IR21A3Record

Name

IR21 Appendix3 Stock Option Type

Code

IR21A3StockOptionType

Data Type

char(20)

Mandatory

Yes


Description of Attribute IR21 Appendix3 Stock Option Type of the Entity IR21A3Record

Shows the stock option type for the IR21 Appendix 3. This acts as a primary key for the IR21A3Record table.
Example: ESOP / ESOW


Entity Attribute RCB No of the Entity IR21A3Record

Card of Attribute RCB No of the Entity IR21A3Record

Name

RCB No

Code

RCBNo

Data Type

char(20)

Mandatory

No


Description of Attribute RCB No of the Entity IR21A3Record

Shows the registry of companies and businesses number.


Entity Attribute Company ID Type of the Entity IR21A3Record

Card of Attribute Company ID Type of the Entity IR21A3Record

Name

Company ID Type

Code

CompanyIDType

Data Type

char(20)

Mandatory

No


Description of Attribute Company ID Type of the Entity IR21A3Record

This attribute would record the identity for the company type.
Example: Private / Public / Non-Profit etc


Entity Attribute Name of the Entity IR21A3Record

Card of Attribute Name of the Entity IR21A3Record

Name

Name

Code

CompanyName

Data Type

char(100)

Mandatory

No


Description of Attribute Name of the Entity IR21A3Record

Stores the name of the company.
Example: Sage Software Asia Pte. Ltd.


Entity Attribute Date Stock Granted of the Entity IR21A3Record

Card of Attribute Date Stock Granted of the Entity IR21A3Record

Name

Date Stock Granted

Code

DateStockGranted

Data Type

date

Mandatory

No


Description of Attribute Date Stock Granted of the Entity IR21A3Record

Shows the date of grant of ESOP / Shares under ESOW.
It is in the format: DD-MM-YYYY.


Entity Attribute Exercise Price Stock of the Entity IR21A3Record

Card of Attribute Exercise Price Stock of the Entity IR21A3Record

Name

Exercise Price Stock

Code

ExercisePriceStock

Data Type

double

Mandatory

No


Description of Attribute Exercise Price Stock of the Entity IR21A3Record

Shows the exercise price of ESOP / or Price paid / payable per share under ESOW plan.


Entity Attribute Market Value Stock Grant of the Entity IR21A3Record

Card of Attribute Market Value Stock Grant of the Entity IR21A3Record

Name

Market Value Stock Grant

Code

MktValueStockGrant

Data Type

double

Mandatory

No


Description of Attribute Market Value Stock Grant of the Entity IR21A3Record

States the open market value per share as at the date of grant of ESOP / shares under ESOW plan.


Entity Attribute Market Value Exercise Stock of the Entity IR21A3Record

Card of Attribute Market Value Exercise Stock of the Entity IR21A3Record

Name

Market Value Exercise Stock

Code

MktValueExerciseStock

Data Type

double

Mandatory

No


Description of Attribute Market Value Exercise Stock of the Entity IR21A3Record

States the market value at time of deemed exercise of ESOP or deemed price paid for shares under ESOW plan.


Entity Attribute Number of Shares Acquired of the Entity IR21A3Record

Card of Attribute Number of Shares Acquired of the Entity IR21A3Record

Name

Number of Shares Acquired

Code

SharesAcquired

Data Type

double

Mandatory

No


Description of Attribute Number of Shares Acquired of the Entity IR21A3Record

Shows the number of unexercised ESOP or unvested shares under ESOW plans or ESOP / ESOW plans with moratorium imposed.


Entity Attribute Type Plan Granted of the Entity IR21A3Record

Card of Attribute Type Plan Granted of the Entity IR21A3Record

Name

Type Plan Granted

Code

TypePlanGranted

Data Type

char(20)

Mandatory

No


Description of Attribute Type Plan Granted of the Entity IR21A3Record

Shows the type of plan that is granted.
Example: ESOP / ESOW


Entity Attribute Date of Expiry of Exercise of the Entity IR21A3Record

Card of Attribute Date of Expiry of Exercise of the Entity IR21A3Record

Name

Date of Expiry of Exercise

Code

DateOfExpiryOfExercise

Data Type

date

Mandatory

No


Description of Attribute Date of Expiry of Exercise of the Entity IR21A3Record

Shows the date of expiry of exercise of ESOP or date of vesting of ESOW plan or date is maratorium is lifted, as the case may be.