There are three sections of the General Reports page. The first section is the Data
Validation Reports, the second section is the Data View Reports and the third
section is the Reports Manager. Each section is grouped within a shaded border.
The Generate Report button, while placed inside the Data View Report section, is
used for all reports.
None of the reports under the Reports Module are immediately generated. A report
request is submitted. The Reports Manager is available at the bottom of all report
pages allowing you to view the status of a report request. Refer to Reports
Manager for information regarding the management of your report requests.
All reports are created as a comma separated file (.csv format).
To submit a Data Validation Report request:
1. If desired, enter a Begin Date and End Date. Or click on the Calendar
Icon and select a date from the Calendar.
2. Check the check box to the left of the report name. Multiple reports may
be selected.
3. Click the Generate Report button. At least one report must be selected
before the Generate Report button is enabled.
Control Totals Summary: Displays the total number of records, total number
of shares, minimum grant date, and maximum grant for grant, vesting,
exercise, and cancellation files. The report is grouped by award type. This
information can be compared against the data stored in the user’s
administration system to identify any discrepancies that may exist.
Valuations Data Check -There are 8 Valuation Data Check Reports:
1. Missing Option Values For Granted Awards: Displays grants that do
not have an option value. Report results are derived by checking
grant information at both the grant and vesting tranche level for
option values that are missing. The report can be used to audit
stored valuation data.
2. Missing Option Values For Assumed Awards: Displays assumed
grants that do not have an option value. Report results are derived by
checking assumed grant information at both the grant and vesting tranche
level for option values that are missing. The report can be used to audit
stored valuation data.
3. Missing Option Values for Modifications: Displays modified grants
that do not have an option value. Report results are derived by checking
modified grant information at both the grant and vesting tranche level for
option values that are missing. The report can be used to audit stored
valuation data.
4. Missing Data for Modifications: Displays modified grants that have
missing data.
5. Missing Data For Assumed Awards: Displays assumed grants that
have missing data.
6. Missing Vesting Data for Assumed Awards: Displays assumed grants
that have missing vesting data.
7. Missing Vesting Data for Granted Awards: Displays grants that have
missing vesting data.
8. Missing Vesting Data for Modification: Displays modified grants that
have missing vesting data.
Valuation Detail Report: Provides an audit record for the option values that
are calculated and saved on the system. The report is divided into separate
tabs for each Group (if applicable), including a Totals tab.
To submit a Data View Report request:
1. Check the check box to the left of the report name. Multiple reports may
be selected.
2. Click the Generate Report button. At least one report must be selected
before the Generate Report button is enabled.
Amortization Method Settings: Displays grant-specific amortization method
settings that were uploaded and/or the default amortization method that was
set for particular Effective Dates through the Amortization Method page
under
the Configure section.
Cancellation File: Displays the cancellation data from the Cancellation File as
uploaded.
Classification File: Displays the classifications data from the Classification File
as uploaded.
Conditions Achieved File (MPA Awards only): Displays data from the
Conditions Achieved File as uploaded.
Exercise File: Displays the exercise data from the Exercise File as uploaded.
Extended Grant Settings File: Displays the exercise data from the Extended
Grant Settings File as uploaded.
Forfeiture Rate Schedule: Displays grant-specific forfeiture rate settings that
were uploaded and/or the default forfeiture rate schedule that was set through
the Forfeiture Rate Schedule page of the Configure Module.
There are five user fields in the Classification File. If only one user field has
been used, the other four user fields will be empty on the report. For each grant, the Optionee and User Defined List data is also displayed. The
User Defined List columns are dynamically built depending up the contents of
the User Defined Lists File.
Grant File: Displays grant data from the Grant File as uploaded, and
incorporates the option values you created and saved in the system.
Grant Level Attribute File: Displays the attribute values by grant as uploaded
in the Grant Attributes File as uploaded.
Mobility Attribute Control File: Provides the definition of the Mobility
Attribute Names that are available for Mobility Reporting as uploaded in the
Mobility Attribute Control File.
Mobility Reporting File: This file accommodates Mobility Allocation
information for Optionees. The data is Effective-date driven and includes the
Mobility Attribute Name, Value and the Percentage Allocation for each Attribute
Value.
Mobility Tax Benefit Allocation File: This file can be used when a Tax Event
occurs for a Grant where the user wishes to provide a Custom Tax Event Gain
and/or Tax Benefit Allocation outside of the standard calculations. This is where
Custom Tax Benefit Allocations can be provided.
Mobility Tax File: This file provides the ability to assign a Tax Benefit
Allocation Type to each Tax Attribute Value or jurisdiction. For example, for one
jurisdiction the Tax Benefit Allocation may be measured from Grant to Vest
Date while another jurisdiction may measure it from Grant to Exercise. This file
also allows for a Reusable Tax Schedule to be assigned to each Attribute Value
or jurisdiction specifically for Mobility Reporting.
Modified Grant Vesting File: Displays data from the Grant Modified Vesting
File as uploaded.
Schedule Assignment File:
Displays data from the MPA Schedule Assignment
File as uploaded.
Effective Date Schedule File: Displays data from the MPA Schedule File as
uploaded.
Optionee Level Attribute File: Displays the optionee data from the Optionee
File as uploaded.
Optionee Master File: Displays the optionee data from the Optionee File as
uploaded.
Tax Rate Schedule: Displays the tax rate data from the Tax Rate File as
uploaded; as well as tax rate schedule set through Tax Rate under
the
Configure section.
Valuation Assumptions File: Displays the Vesting Assumptions Valuations
Assumptions File as uploaded.
Vesting File: Displays vesting data from the Vesting File as uploaded, and
incorporates the option values you created and saved in the system.