Entity IR21A2Record

Description of Entity IR21A2Record

Details of gains and profits from the employee stock option (ESOP) / other forms of Employee Share Ownership (ESOW) plans exercise / deemed exercised for the year 2013.


List of all Dependencies of the Entity IR21A2Record

Name

Code

Class Name

Relation_1701915

Relation_1701915

Reference


List of Attributes of the Entity IR21A2Record

Name

Code

PersonalSysId

PersonalSysId

IR21A2SysId

IR21A2SysId

IR21 Appendix2 Stock Option Type

IR21A2StockOptionType

RCB No

RCBNo

Company ID Type

CompanyIDType

Name

CompanyName

Date Stock Granted

DateStockGranted

Date Exercise Stock

DateExerciseStock

Exercise Price Stock

ExercisePriceStock

Market Value Stock Grant

MktValueStockGrant

Market Value Exercise Stock

MktValueExerciseStock

Number of Shares Acquired

SharesAcquired

EESOP Tax Exemption

EESOPTaxExempt

CSOP Tax Exemption

CSOPTaxExempt

No Tax Exemption

NoTaxExempt

Stock Gains

StockGains

Type Plan Granted

TypePlanGranted

Granted Before

GrantedBef

Type of Exercise

TypeOfExercise

NSOP Tax Exemption

NSOPTaxExempt


Entity Attribute PersonalSysId of the Entity IR21A2Record

Card of Attribute PersonalSysId of the Entity IR21A2Record

Name

PersonalSysId

Code

PersonalSysId

Data Type

integer

Mandatory

Yes


Description of Attribute PersonalSysId of the Entity IR21A2Record

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 IR21A2SysId of the Entity IR21A2Record

Card of Attribute IR21A2SysId of the Entity IR21A2Record

Name

IR21A2SysId

Code

IR21A2SysId

Data Type

integer

Mandatory

Yes


Description of Attribute IR21A2SysId of the Entity IR21A2Record

A system generated identity. It is blind to the user. This holds the primary key for the IR21A2Record table.


Entity Attribute IR21 Appendix2 Stock Option Type of the Entity IR21A2Record

Card of Attribute IR21 Appendix2 Stock Option Type of the Entity IR21A2Record

Name

IR21 Appendix2 Stock Option Type

Code

IR21A2StockOptionType

Data Type

char(20)

Mandatory

Yes


Description of Attribute IR21 Appendix2 Stock Option Type of the Entity IR21A2Record

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


Entity Attribute RCB No of the Entity IR21A2Record

Card of Attribute RCB No of the Entity IR21A2Record

Name

RCB No

Code

RCBNo

Data Type

char(20)

Mandatory

No


Description of Attribute RCB No of the Entity IR21A2Record

Shows the registry of companies and businesses number.


Entity Attribute Company ID Type of the Entity IR21A2Record

Card of Attribute Company ID Type of the Entity IR21A2Record

Name

Company ID Type

Code

CompanyIDType

Data Type

char(20)

Mandatory

No


Description of Attribute Company ID Type of the Entity IR21A2Record

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


Entity Attribute Name of the Entity IR21A2Record

Card of Attribute Name of the Entity IR21A2Record

Name

Name

Code

CompanyName

Data Type

char(100)

Mandatory

No


Description of Attribute Name of the Entity IR21A2Record

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


Entity Attribute Date Stock Granted of the Entity IR21A2Record

Card of Attribute Date Stock Granted of the Entity IR21A2Record

Name

Date Stock Granted

Code

DateStockGranted

Data Type

date

Mandatory

No


Description of Attribute Date Stock Granted of the Entity IR21A2Record

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


Entity Attribute Date Exercise Stock of the Entity IR21A2Record

Card of Attribute Date Exercise Stock of the Entity IR21A2Record

Name

Date Exercise Stock

Code

DateExerciseStock

Data Type

date

Mandatory

No


Description of Attribute Date Exercise Stock of the Entity IR21A2Record

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


Entity Attribute Exercise Price Stock of the Entity IR21A2Record

Card of Attribute Exercise Price Stock of the Entity IR21A2Record

Name

Exercise Price Stock

Code

ExercisePriceStock

Data Type

double

Mandatory

No


Description of Attribute Exercise Price Stock of the Entity IR21A2Record

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


Entity Attribute Market Value Stock Grant of the Entity IR21A2Record

Card of Attribute Market Value Stock Grant of the Entity IR21A2Record

Name

Market Value Stock Grant

Code

MktValueStockGrant

Data Type

double

Mandatory

No


Description of Attribute Market Value Stock Grant of the Entity IR21A2Record

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 IR21A2Record

Card of Attribute Market Value Exercise Stock of the Entity IR21A2Record

Name

Market Value Exercise Stock

Code

MktValueExerciseStock

Data Type

double

Mandatory

No


Description of Attribute Market Value Exercise Stock of the Entity IR21A2Record

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 IR21A2Record

Card of Attribute Number of Shares Acquired of the Entity IR21A2Record

Name

Number of Shares Acquired

Code

SharesAcquired

Data Type

double

Mandatory

No


Description of Attribute Number of Shares Acquired of the Entity IR21A2Record

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


Entity Attribute EESOP Tax Exemption of the Entity IR21A2Record

Card of Attribute EESOP Tax Exemption of the Entity IR21A2Record

Name

EESOP Tax Exemption

Code

EESOPTaxExempt

Data Type

double

Mandatory

No


Description of Attribute EESOP Tax Exemption of the Entity IR21A2Record

Shows the entrepreneurial employee stock options plan with the exemption of tax.


Entity Attribute CSOP Tax Exemption of the Entity IR21A2Record

Card of Attribute CSOP Tax Exemption of the Entity IR21A2Record

Name

CSOP Tax Exemption

Code

CSOPTaxExempt

Data Type

double

Mandatory

No


Description of Attribute CSOP Tax Exemption of the Entity IR21A2Record

Shows the company stock options plan with the exemption of tax.


Entity Attribute No Tax Exemption of the Entity IR21A2Record

Card of Attribute No Tax Exemption of the Entity IR21A2Record

Name

No Tax Exemption

Code

NoTaxExempt

Data Type

double

Mandatory

No


Description of Attribute No Tax Exemption of the Entity IR21A2Record

States that there is no tax exemption, i.e. includes tax.


Entity Attribute Stock Gains of the Entity IR21A2Record

Card of Attribute Stock Gains of the Entity IR21A2Record

Name

Stock Gains

Code

StockGains

Data Type

double

Mandatory

No


Description of Attribute Stock Gains of the Entity IR21A2Record

Shows the stock gains.


Entity Attribute Type Plan Granted of the Entity IR21A2Record

Card of Attribute Type Plan Granted of the Entity IR21A2Record

Name

Type Plan Granted

Code

TypePlanGranted

Data Type

char(20)

Mandatory

No


Description of Attribute Type Plan Granted of the Entity IR21A2Record

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


Entity Attribute Granted Before of the Entity IR21A2Record

Card of Attribute Granted Before of the Entity IR21A2Record

Name

Granted Before

Code

GrantedBef

Data Type

smallint

Mandatory

No


Description of Attribute Granted Before of the Entity IR21A2Record

Indicates if it was granted and if so, before what time period.


Entity Attribute Type of Exercise of the Entity IR21A2Record

Card of Attribute Type of Exercise of the Entity IR21A2Record

Name

Type of Exercise

Code

TypeOfExercise

Data Type

char(20)

Mandatory

No


Description of Attribute Type of Exercise of the Entity IR21A2Record

Shows the type of exercise.
Example: Actual / Deemed


Entity Attribute NSOP Tax Exemption of the Entity IR21A2Record

Card of Attribute NSOP Tax Exemption of the Entity IR21A2Record

Name

NSOP Tax Exemption

Code

NSOPTaxExempt

Data Type

double

Mandatory

No


Description of Attribute NSOP Tax Exemption of the Entity IR21A2Record

Shows the non-qualified stock options plan with an exemption of tax.