|
Assumed Grant Vesting File
|
Previous Top Next |
Insertions and Modifications
In an effort to keep Assumed Grant data distinct from normal grant data, assumed grant vesting should be loaded via the Assumed Grant Vesting file even if that vesting data is grant date related as opposed to Acquisition Date vesting. Therefore, we end up with Grant/Grant Vesting data AND Assumed Grant/Assumed Grant Vesting data.
Users should always upload the original vesting schedule for a specific grant, and then incorporate any modifications to that vesting schedule separately and through the Acceleration and Retirement-Eligibility and/or Grant Modification and Grant Modified Vesting files.
If there is more than one record in the Assumed Grant Vesting File with the same Grant ID and Vest Date, the system will assume that the last record is supposed to update the previous record(s). The previous record(s) will be lost and no validation error will be reported.
If the referenced GrantID is not an assumed grant, an error should be reported.
To delete all vesting activity associated with an assumed grant, the user will add a record into an uploadable Assumed Grant Vesting file that contains only the Grant ID. Deletion records can be in the same file as insert and update records. Note only a single vesting delete row is needed to delete all the vesting rows for the grant.
If the referenced GrantID is not an assumed grant, an error should be reported.
|
#
|
Field Name
P=Required
|
Field Type
|
Sample
Field
|
Description
| |
|
1
|
GrantID
|
P
|
Alpha-Numeric (40)
|
2001EAH
|
Unique identifier for each grant.
Links to grant file and grant
information
|
|
2
|
VestDate
|
P
|
Date is in
MM/DD/YYYY or
MM/DD/YY format
|
06/28/2005
|
Vest date for each tranche.
|
|
3
|
VestShares
|
P
|
Numeric (14.4)
|
1,500
|
The number of shares in the vesting
schedule that vest on vesting date.
|
|
4
|
Fair Value
before
Acquisition
Date
|
|
Numeric (14.4)
|
4.542
|
Tranche Level Fair Value of the
assumed awards immediately
before the Acquisition Date (close
date) of the business combination
|
|
5
|
Fair Value
on/after
Acquisition
Date
|
|
Numeric (14.4)
|
4.124
|
Tranche Level Fair Value of the
assumed awards immediately after
the Acquisition Date (close date) of
the business combination. This also
represents the fair value on the
Acquisition Date
|
|
6
|
Fair Value on
Announcement Date
|
|
Numeric (14.4)
|
4.344
|
Tranche level Option Value of the
assumed awards on the
announcement date of the business
combination
|
|
|
|
|
|
|
The following fields (7-9) are
included for MPA Awards (PI, PN,
PR, PS, PU) and are optional for all
other awards.
|
|
7
|
Tranche ID
|
M
|
Alpha-Numeric (20)
|
01
|
Unique identifier for each Tranche
underlying a Grant
|
|
8
|
Condition
Description
|
|
Alpha-Numeric (40)
|
EPS
Growth
|
Free-form text description of the
condition(s) associated with the
award.
|
|
9
|
Vest Start
Date
|
|
Date
|
5/1/2009
|
This date constitutes the beginning
of the period over which the
employee renders service (service
inception date)
|
|
10
|
Shares
Assumed
|
|
Numeric (14.4)
|
1000
|
This is the total number of
instruments/shares assumed by the
acquiring company.
|
|
11
|
Shares
Hypothetically
Earned
|
|
Numeric (14.4)
|
954
|
The number of shares assumed to
be hypothetically vested on the
acquisition date.
|
The data would be loaded in the following sequence:
GrantID, VestDate, VestShares, FV immediately before Acquisition Date, FV on/after Acquisition Date, FV on Announcement Date, Tranche ID, Condition Description, Vest Start Date, Shares Assumed, Shares Hypothetically Earned.
An example of valid lines in an assumed vesting file is as follows (note the extra comma used to identify the missing optional Option Value field in the third example):
Grant1, 1/1/2003, 730, 3.5, 3.7, 3.4
Grant1, 10/21/2004, 500, 6.7, 7.3, 7.1
Grant 2, , 12/11/2005, 200,2.4, 2.7, 2.1