Vesting Modifications File
 Previous Top Next

The Acceleration and Retirement-Eligibility File (files with extension md.csv) contains information related to the modified vesting schedule of option grants. The vesting modifications data is used to properly record the associated compensation expense over a vesting schedule that is modified from the contractual or administrative vesting schedule, due to a generic Acceleration or due to Retiree-Eligibility provisions.

When a single zipped file contains a Cancellation File and a Acceleration and Retirement-Eligibility File, the Cancellation Date will override the Vesting Modification Date.

Please note that only one Retiree Eligible record is accepted for a Grant ID. Acceleration can be for multiple Modification Dates.

Insertions and Modifications
Upload file can contain both new records, and updates to existing records.
A row is uniquely identified by a combination of the Grant ID, Vesting Modification Date and Vesting Modification Type.

If there is more than one record in the Acceleration and Retirement-Eligibility file with the same Grant Id, Vesting Modification Date and Vesting Modification Type, 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.


Deletions
To delete a record, you can add a record in an acceptable .CSV file format that contains only the Grant ID. Deletion records can be in the same file as insertion and modification records. 


File Format
#
Field Name
P =Required M = required MPA
Field Type


Sample Field
Description
1
Grant ID
P
Alpha-Numeric (40)
2001EAH
Links to Grant information
2
Vesting Modification Type
P
List Selection (Enumeration)
RETIREE
The type of Vesting Modification is either an Acceleration or Retiree Eligible.
Must be ALL CAPS 
Accelerations are not supported for MPA thru this file as the Service Period End Date and/or Conditions Achieved Date serves as an acceleration indicator.
3
Vesting Modification Date
P
Date
06/28/2010
The date on which the modification occurred; either the Acceleration Date or the Retirement Eligibility date.
This is the Acceleration Date for Acceleration records.
This is the Retirement-Eligibility Date for Retirement-Eligibility records (can be blank for Tranche level record)
4
Vesting Modification Shares
 
Numeric(14.4)
1000
The number of Shares applicable for the Modification.

This is Shares Accelerated for Acceleration records.

This is Retirement-Eligibility Shares for Retirement-Eligibility records.
 
 
 
Note:
 
The following field is included for MPA Awards and is optional.  A place holder for an empty field is not required, providing backward compatibility with the prior format. Both the 4 field format and 5 field format records are acceptable in this file at the same time.
5
Tranche ID
 
Alpha-Numeric(20)
 
Identifies the specific Tranche for which the Retirement Eligibility date applies.

Since TrancheID is optional, care must be taken to not provide an invalid TracheID, because a warning message is generated, the TrancheID is set to blank, and the Grant Level Retirement Eligible date is updated.


Examples

To properly load, fields in each row of the file must be in the following sequence:
GrantID, VestingModificationType, VestingModificationDate, VestingModificationShares, TrancheID


An example of valid lines in a vesting modification file are as follows
Non-MPA Awards
Grant1, RETIREE, 10/18/2011, 1000
“Grant 2”, ACCELERATION, 05/20/2010

MPA Awards
Grant 3, RETIREE, 05/20/2010, , 2