Cancellation File
 Previous Top Next
 
The Cancellation File (files with extension cn.csv) contains information related to the cancellation of option grants. There is a distinction between cancellations prior to option vesting (i.e., forfeitures), and cancellations after the option has vested. The pre-vesting cancellation data is used to determine the forfeiture adjustment to the option expense. 

For each grant you may upload both pre-and post-vesting cancellation information.
Only one pre-vest and one post-vest Cancel Type record will be accepted per grant.

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, Cancel Date and Cancel Type.

If there is more than one record in the Cancellation file with the same Grant ID, Cancel Date, and Cancel 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
Field Type

Sample Field
Description
1
Grant ID
P
Alpha-Numeric (40)
2001EAH
Links to Grant information
2
Cancel Date
P
Date
06/28/2010
The Date the Shares are Cancelled.
3
Shares Cancelled
P
Numeric (14.4)
 
1,500
Represents the number of shares that were cancelled due to a forfeiture of shares (Pre-Vest cancel) or an expiration or definite non-exercise of shares (Post-Vest Cancel).

For MPA Awards the amount is in Base Instruments when Cancel Type is Pre-Vest

This is the actual shares cancelled when Cancel Type is Post-Vest.
4
Cancel Type
P
List Selection (Enumeration)
PRE-VEST
This must be unique per Grand ID.

CancelType =  PRE-VEST OR  POST-VEST

 No quotation marks allowed

Both upper and lower case allowed
5
Cancel Reason
 
Alpha-Numeric (40)
 
Reason the shares were cancelled
Default = Null
 
 
 
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 5 field format and 6 field format records are acceptable in this file at the same time.
6
Tranche ID
 
Alpha-Numeric(20)
01
Identifies the specific Tranche from which the cancel applies.
For an MPA Award, when the TrancheID is not identified, the cancellation  will be applied as follows:
Pre-vest: FIFO relevant to the Service Period End Date.
Post-vest: LIFO relevant to the Conditions Achieved Date.
7
Entry Date
 
Date
5/1/2009
This date constitutes the date upon which the record was added to the database. The date is for record adds and does not change if the existing record is updated.

Examples

To properly load, fields in each row of the file must be in the following sequence:

GrantID, CancelDate, OptionsCancelled, CancelType, CancelReason, TrancheID, EntryDate



An example of valid lines in a cancellation file are as follows (note the missing optional Cancel Reason field in the second example):

Non-MPA Award
Grant1, 1/1/2010, 250, PRE-VEST, Terminated,,/15/2010

MPA Award
Grant2, 12/11/2010, 350, POST-VEST, Layoff, 2,12/11/2010