Effective Date Schedule File
 Previous Top Next


The Effective Date Schedule File  (files with extension sd.csv) contains information related to an individual MPA or Liability grants to track perfomance schedules over time. The data identifies each Grant ID, Tranche ID, Effective Date, Instruments Multiplier, EPS Market Multiplier, EPS Performance Multiplier, Fair Value, Exercise price and Service Period End Date.


The Effective Date Schedule file is used to specify Tranche level values of fields used to perform certain computations for Market and Performance Awards.  These values can vary by an effective date at the Tranche level. The file can also be used to input values for Liability and Non-Employee awards which are marked to market periodically.

An Effective Date Schedule record can be sent to change only one value at a particular effective date, in which case, other values would be applied from other effective dates as applicable.  Null values must be provided for subsequent effective dates to leave prior values in effect.
This is a Specific Assignment or a Reusable Effective Date Schedule at the Tranche level.  There may also be Tranche specific Effective Date Schedule lines attached to the Tranche.


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, TrancheID and Effective Date.

If there is more than one record in the Effective Date Schedule file with the same Grant ID, Tranche ID and Effective 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 single Effect Date Schedule Line, you can add a record in an acceptable .CSV file format that contains only the Grant ID, Tranche ID and Effective Date.

To delete all Effective Date Schedule Records for a Tranche, a single record which only includes the GrantID and TrancheID should be sent.

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
GrantID
P
Alpha-Numeric (40)
1554
Links to Grant information
2
TrancheID
P
Alpha-Numeric(20)
0001
The identifier of the Tranche within the Grant
3
Effective Date
P
Date
 
01/06/2011
The Effective Date of all non-blank values provided in this file. 
4
Instruments Multiplier
 
Numeric (14,4)
Note: enter as decimal not %(1.25 not 125%)
 
1.25
A percentage applied to Base Instruments Granted (Shares Granted) to determine the quantity of target shares to be earned. Decimal value.

.
5
EPS Market Multiplier
 
Numeric (14,4)
 
1.15
A percentage applied to the Base Instruments Granted for purposes of computing EPS Shares Outstanding (EPS SO) when award has a market condition. Decimal value.

.
6
EPS Performance Multiplier
 
Numeric (14,4)
 
1.20
A percentage applied to the Base Instruments Granted for purposes of computing EPS Shares Outstanding
7
Fair Value
 
Numeric(14,4)
6.85
The Fair Value of a Share at the Effective Date
8
Exercise Price
 
 
Numeric(14,4)
5.0
The Exercise Price at the Effective Date
9
Service Period End Date
 
Date
04/25/2014
The Service Period End Date at the Effective Date


Examples
To properly load, fields in each row of the file must be in the following sequence:
GrantID, TrancheID, EffectiveDate, InstrumentsMultiplier, EPSMarketMultiplier, EPSPerformanceMultiplier, FairValue, ExercisePrice, ServicePeriodEndDate


An example of valid lines in an MPA Schedule File are as follows:
Grant004, 0001,1.5,1.6,1.5,10.5,25.50,10/10/2012
Grant005, 0001,,,1.5,12.5,30,04/01/2012