Assumed Grant File
 Previous Top Next


The Assumed Grant File (files with extension ag.csv) contains information related to assumed grants, that is grants acquired through acquisition or merger.

Insertions and Modifications

Upload file can contain both new records, and updates to existing records.
A row is uniquely identified by Grant ID.

If the Optionee ID field has a value, the system will interrogate the Optionee table. If no Optionee is found with that Optionee ID then a row will be added to the Optionee table with that Optionee ID but no attribute information.

If there is more than one record in the Assumed Grant File with the same Grant ID, 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.

Deletions

The deletion of an Assumed grant not only removes the grant information from the Grant file, but also removes all other data in Option Navigator associated with that grant. The one exception is that if an Optionee is referenced in the Grant, that Optionee row is not removed. It is perfectly acceptable to have an Optionee in the database without any assigned grants.

To delete an Assumed grant, the user will add a record into an uploadable Assumed Grant file that contains only the Grant ID.  Deletion records can be in the same file as insert and update records.

If the referenced GrantID is not an assumed grant, an error should be reported.


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
Grant Number
 
Alpha-Numeric (40)
GR1234
 
User defined string. Default = GrantID. Default means that if the attribute is not provided then ON will supply a default value.  This is a legacy field type and should always be left blank
3
Optionee ID
 
Alpha-Numeric (40)
 
8776
Links to optionee information and the optionee upload data file. Default = Null
4
Plan Name
  P
Alpha-Numeric (40)
Award Plan 20XX
 
Name of plan associated with the grant
 
5
Award Type
P
List Selection (Enumeration)
 
NQ
The award type award for the grant.  Award Type = NQ,ISO, SAR, RSA, RSU (only these values are allowed)
6
Award Sub Type
 
Alpha-Numeric (40)
General Award
 
Award sub-classification. A free form description. 
 
7
Grant Date
P
MM/DD/YYYY or MM/DD/YY                 
01/01/2008
 
The date the terms of the grant are agreed on by all parties.
8
Vest Start Date
P
MM/DD/YYYY or MM/DD/YY
 
01/01/2008
 
Date the grant began vesting in the target company.  The service inception date for the first tranche.
 
9
Expire Date
P
MM/DD/YYYY or MM/DD/YY
 
01/01/2008
 
Date the grant expires. 
 
10
Grace Period
 
Numeric (14.4)
30
Number of days after the grant expiration date that options can be exercised. Default = 0.  If the field contains  a decimal, ON will round to the nearest smaller whole number.
11
Options Granted
P
Numeric (14.4)
30
Original number of options in the grant. If no forfeiture activity is supplied, this number should be equal to Number of Shares Assumed.  If Forfeiture activity is supplied, the Number of Shares Assumed will equal Options Granted - Sum of Forfeiture activity.
 
12
Exercise Price
P
Numeric (14.4)
30
Exercise price for the grant on Acquisition Date.
13
Tax Election
 
List Selection (Enumeration)
 
0
Signifies if the grant has an 83b Tax Election.  0 = No. 1 = Yes. Default = 0. Valid values for “Yes” are true, yes, y, 1.  Valid values for “No” are false, no, n, and 0.  This field is not case sensitive   
 
14
Vest Name
 
Alpha-Numeric (40)
 
Name of vesting schedule
15
Acquired Company Name
 
P
Alpha-Numeric
Coca cola
 
16
Acquisition Date
 
P
MM/DD/YYYY or MM/DD/YY                 
01/01/2008
 
The date a business combination closes – this is the same as the Close Date for business combinations under FAS 141
17
Acquisition Date
FMV
 
Numeric (14.4)
9.5
The Parent company’s stock price on the close date of the business combination
18
O.V. before Acquisition Date
 
 
Numeric (14.4)
3.7
The Fair Value of the assumed awards immediately before the Acquisition Date (close date) of the business combination
19
O.V after Acquisition Date
 
 
Numeric (14.4)
3.9
The 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
20
Announcement Date
 
 
MM/DD/YYYY or MM/DD/YY
09/28/2007
 
The Date of announcement of business combination
21
Announcement Date FMV
 
 
Numeric (14.4)
9.7
The Parent company’s stock price as of announcement date.
22
O.V on Announcement Date
 
 
Numeric (14.4)
3.25
The Option Value of the assumed awards on the announcement date of the business combination
23
Number of shares assumed
 
 
Numeric (14.4)
1000
The number of shares of target company acquired by the acquiring company. If Forfeiture activity is supplied, the Number of Shares Assumed will equal Options Granted - Sum of Forfeiture activity. If no forfeiture activity is supplied, this should be the same as Options Granted.
 
24
Hypothetically earned shares
 
 
Numeric (14.4)
349
The number of unvested shares before the close date assumed to be hypothetically earned.
25
MPA Condition
M
List Enumeration
MP
Indicates if the award is subject to a Market, Performance, or a Market and Performance Condition
26
Settlement Type
 
List Selection
(Enumeration)
Cash, Stock, CashOrStock
This specifies the ways that the Grant can be settled which is for Cash, Stock or Cash and Stock.
The Accounting Classification is defaulted when a Grant is initially uploaded.  When this field is Cash the Accounting Classification is set to Liability.
27
Entry Date
 
Date
5/1/2009
This dates constitutes the date upon which the assumed grant was entered into the databse. The date is for record adds and does not change if the existing record is updated.
 





EXAMPLES:

The fields in each row must be in the following sequence to load correctly:

GrantID, Grant Number, Optionee ID, Plan Name, Award Type, Award Sub        Type, Grant Date, Vest Start Date, Expire Date, Grace Period, Options Granted, Exercise Price, Tax Election, Vest Name, Acquired Company Name, Acquisition Date, Acquisition Date FMV, O.V. before Acquisition Date, O.V after Acquisition Date, Announcement Date, Announcement Date FMV, O.V on Announcement Date, Number of shares assumed, Hypothetically earned shares, Settlement Type.


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


194000,19400,1234,Plan1,NQ,SUB1,01/01/2007,01/01/2007,12/31/2015,90,1000,50.00,0,Vest,AcquiredCo.,06/30/2007,55.00,47.00,48.00,06/01/2007,53.00,46.00,47.00,1000,200, Cash,01/01/2007

In the above example all data fields are present


194000,19400,1234,Plan1,NQ,,01/01/2007,01/01/2007,12/31/2015,90,1000,50.00,0,Vest,Acquired Co.,06/30/2007,55.00,47.00,48.00,06/01/2007,53.00,46.00,47.00,1000,Stock

In the above example Award Sub Type and Hypothetically Earned Shares are not supplied and are replaced by a , (comma representing “not supplied data”).