Mobility Reporting File
 Previous Top Next
The Mobility Reporting File (files with extension mr.csv) specifies Mobility Allocation information for Optionees. All allocation related updates for Mobility Reporting for Optionees are handled through this file. 




Insertions and Modifications
The upload file can contain both new records, and updates to existing records. The combination of OptioneeID, Effective Date and Optionee Attribute Name provides a unique record.

Whenever this record is provided it will add or replace the information for the unique key.



Deletions

To delete a specific record, the unique key only with no other information should be provided. This would be a record containing OptioneeID, Effective Date and Optionee Attribute Name .



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 Filed
Description
1
OptioneeID
P
Alpha-Numeric (40)
12345
The valid Optionee ID previously defined. 
2
Effective Date
 
P
Alpha-Numeric (40)
1/1/2012
This is the date that this Mobility information is effective.  Unless a later date is provided in this file, the Mobility specification provided in this file is effective for the life of the Grants and the earliest effective date is effective to the Grant Date for all Grants for this OptioneeID
3
Mobility Attribute Name
P
Alpha-Numeric (40)
 
Country
This is the Optionee Attribute Name for the Values and Percentages provided in this record 
4
Attribute Value
 
Alpha-Numeric (40)
USA
A valid Optionee Attribute Value for the Allocation Attribute Name as defined in the User Defined List of valid Values

 
5
Percentage
 
Numeric (14,4)
0.25
The percentage allocation for the Attribute Value

Enter as a whole number, no decimal places allowed:
Example 1 = 100%, .6666 + .4444 would equal 1.

If the Attribute Name is specified as a Percent Allocation Allowed equal to No in the Mobility Attribute Control file, then this field is optional or must be 1, and there cannot be additional allocation fields in this record.
 


Examples
To properly load, fields in each row of the file must be in the following sequence:
OptioneeID, Effective Date, Mobility Attribute Name, Attribute Value, Percentage


An example of valid lines in an Mobility Reporting File are as follows:
OPTIONEE01,1/27/2011,Country,Brazil,.30,USA,.20,Mexico,.10,Canada,.05,United Kingdom,.35