Grant Modification File
 Previous Top Next


The Grant Modification File (files with extension mg.csv) contains information related to the modification of grant data. There are five data items that can be modified using this file: Vesting Schedule (requires the Modified Grant Vesting File), Expiration Date, Exercise Price, Options Granted, and Grace Period.

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 and Modification Date.

If there is more than one record in the Grant Modification file with the same Grant ID and Modification 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.


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.  Note: only one delete record (that is a record that contains only the Grant ID) is necessary to delete all modification data associated to a specific grant.

FILE FORMAT
#
Field Name
P =Required
Field Type
Sample Field
Description
1
Grant ID
P
Alpha-Numeric (40)
20XX01
 
Unique identifier for each grant. Only one record is allowed per grant
2
Modification Date
P
MM/DD/YYYY or MM/DD/YY
 
01/01/2008
 
The date when a modification becomes effective.                        
2a
ASC 718 Modification Flag
 
List Selection (Enumeration)
 
1
Signifies if the grant is to have ASC 718 modification accounting rules/calculations applied.
Default = 0.
 
3
Modification Date FMV
 
Numeric (14.4)
 
5.258
 
Fair market value (stock price) of the grant on the modification date
4
Modification Description
 
Text
 
Description of modification
5
Modification Type
 
Numeric
 
1/3
 
Modification Type refers to the probability of vesting. Modification Type:
Type 1- Probable to probable. Type 3 - Improbable to probable.
Default is Type 1                                                                                                                                                                                                                                                          
6
Option Value immediately before modification
 
Numeric (14.4)
 
2.35
.
7
Option Value Immediately after Modification
 
Numeric (14.4)
 
2.48
 
8
Change in Vesting Schedule
 
List Selection (0 or 1)
 
0/1
Default =0,
Flag is set to 1 to indicate the change in vesting schedule.
9
Change in Expiration Date
 
List Selection (0 or 1)
 
0/1
Default =0,
Flag is set to 1 to indicate the Change in Expiration Date.
10
Change in Exercise Price
 
List Selection (0 or 1)
 
0/1
Default =0,
Flag is set to 1 to indicate the change in Exercise Price.
11
Change in Number of Award Granted
 
List Selection (0 or 1)
 
0/1
Default =0,
Flag is set to 1 to indicate the change in Number of Award Granted.
12
Change in Grace Period
 
 
List Selection (0 or 1)
 
0/1
Default =0,
Flag is set to 1 to indicate the Change in Grace Period.
13
Previous Expiration Date
 
MM/DD/YYYY or MM/DD/YY
 
01/01/2008
 
Previous date the grant expires (end of life for the grant).

 
14
Modified Expiration Date
 
MM/DD/YYYY or MM/DD/YY
 
01/01/2008
 
Modified Date the grant expires (end of life for the grant). 
 
15
Previous Exercise Price
 
Numeric (14.4)
 
5.258
 
The exercise price before modification date. 

.
16
Modified Exercise Price
 
Numeric (14.4)
 
5.258
 
The exercise price on modification date. 

 
17
Previous Options Granted
 
Numeric (14.4)
 
1000
 Original number of options in the grant.
 
18
Modified Options Granted
 
Numeric (14.4)
 
1000
Modified Number of options in the grant. 

 
 
19
Previous Grace Period
 
Numeric (14.4)
 
1
The number of days AFTER expiration or termination the Optionee has to exercise his rights.
 
20
Modified Grace Period
 
Numeric (14.4)
 
30
The number of days AFTER expiration or termination the Optionee has to exercise his rights.
 


EXAMPLES:

The fields in each row must be in the following sequence to load correctly assuming all 5 modifiable fields are being modified.  However, any combination of the 5 modifiable fields can be modified without affecting the non-modified fields (i.e. can modify Exercise Date and Exercise Price, but not the other fields and the other fields will remain unaltered on the DB). 

GrantID, ModificationDate, Modification Date FMV, Modification Description, Modification Type, Option Value immediately before modification, Option Value Immediately after Modification, Change in Vesting Schedule, Change in Expiration Date, Change in Exercise Price, Change in Number of award granted, Change in Grace Period, Previous Expiration Date, Modified Expiration Date, Previous Exercise Price, Modified Exercise Price, Previous Options Granted, Modified Options Granted, Previous Grace Period, Modified Grace Period

An example of valid lines in a grant file is as follows (note the extra comma used to identify the missing optional fields in the examples):



 194000,01/21/2007, 5.36,EX1,1,5.82,5.83,1,0,0,0,0,,,,,,,,

 Change in Vesting Schedule  Other fields remain unaltered

  194000,01/21/2007,5.36,EX2,1,5.82,5.83,0,1,0,0,0,01/01/2010,01/01/2011,,,,,,

Change in Expiration Date  Other fields remain unaltered


194000,01/21/2007, 5.36,EX3,1,5.82,5.83,0,0,1,0,0,,,11.11,10.10,,,,

Change in Exercise Price  Other fields remain unaltered

194000,01/21/2007, 5.36,EX4,1,5.82,5.83,0,0,0,1,0,,,,,1111,1000,,

Change in Number of Award Granted  Other fields remain unaltered

194000,01/21/2007, 5.36,EX5,1,5.82,5.83,0,0,0,0,1,,,,,,,99,90

Change in Grace Period  Other fields remain unaltered