...
The Report Sheet for Performance Calculation reports is a replica of your Performance Calculation results and is sorted and grouped the same way as the normal Performance Calculation report.
The first open cell in the Results worksheet contains the begin date and end date of the report period in an international date format. The security level results for all columns in the Report Sheet include hyperlinks. Clicking the security name link takes you to the Security worksheet for that security. See the following figure.
Anchor |
---|
| RTF370032003000330031003a00 |
---|
| RTF370032003000330031003a00 |
---|
|
Anchor |
---|
| _Toc337537744 |
---|
| _Toc337537744 |
---|
|
Anchor |
---|
| _Toc361231339 |
---|
| _Toc361231339 |
---|
|
Report Sheet Example Anchor |
---|
| _Toc521324245 |
---|
| _Toc521324245 |
---|
|
Business Calendar Sheet
...
The Commit Source section of the Commit sheet identifies the performance source used as the commit source when you ran the report. This data source was used to commit the performance data to the PERFORM database.
Anchor |
---|
| _Toc521324255 |
---|
| _Toc521324255 |
---|
|
Commit Map Summary
...
The All Cash Activity section of the Cash Activity sheet displays all the cash activity records used in processing the report. Each row has a column for each field used in processing the report, including flows and fields such as ORIG_TRANS_NUMB and PERF_FLOW_DESCR.
The rows in this section appear in order of Security Alias, followed by Effective Date, and then by Perf Flow Descriptor. You can click the Security Alias for each row to view that security in the Securities worksheet, where you can click another link for the security to jump to the Positions worksheet. See the following figure.
Anchor |
---|
| RTF330033003700350031003a00 |
---|
| RTF330033003700350031003a00 |
---|
|
Anchor |
---|
| _Toc337537759 |
---|
| _Toc337537759 |
---|
|
Anchor |
---|
| _Toc361231353 |
---|
| _Toc361231353 |
---|
|
Cash Activity Sheet Example - All Cash Activity Section Anchor |
---|
| _Toc521324265 |
---|
| _Toc521324265 |
---|
|
SCF Sheet
...
The SCF section of the SCF sheet displays the SCF settings used if you enabled Significant Cash Flow (SCF) processing when you ran the report. For more information about the options in the report profile's Significant Cash Flow Processing dialog box, see "Chapter 4: Processing Significant Cash Flows (SCF)." See the following figure.
Anchor |
---|
| RTF360039003900370032003a00 |
---|
| RTF360039003900370032003a00 |
---|
|
Anchor |
---|
| _Toc337537760 |
---|
| _Toc337537760 |
---|
|
Anchor |
---|
| _Toc361231354 |
---|
| _Toc361231354 |
---|
|
SCF Sheet Example - Report Parameters Section Anchor |
---|
| _Toc521324268 |
---|
| _Toc521324268 |
---|
|
Inputs Section
The Inputs section of the SCF sheet displays any subperiod frequency performance data retrieved to complete the monthly frequency Performance Calculation report.
The Inputs section contains the columns: Group, Group Hierarchy, Rollup Returns ID, Security Alias, End Effective Date, Source, Frequency, Status (Preliminary or Final) and the input columns. Rolled up returns are first sorted by Rollup Returns ID, followed by Security level returns which are sorted by Security Alias.
Note: | If ALL columns are null on a particular effective date, the report does not show any rows or data in the Inputs section for that effective date. |
See the following figure.
Anchor |
---|
| RTF390036003700390035003a00 |
---|
| RTF390036003700390035003a00 |
---|
|
Anchor |
---|
| _Toc337537761 |
---|
| _Toc337537761 |
---|
|
Anchor |
---|
| _Toc361231355 |
---|
| _Toc361231355 |
---|
|
SCF Sheet Example - Inputs Section Anchor |
---|
| _Toc521324269 |
---|
| _Toc521324269 |
---|
|
FX Rates Sheet
...
The Currency Conversion Parameters section displays the parameters and sources related to currency conversion used when you ran the Performance Calculation report profile. See the following figure.
Anchor |
---|
| _Toc361231356 |
---|
| _Toc361231356 |
---|
|
FX Rates Sheet – Currency Conversion Parameters Section ExampleThe following table describes each item in this section.
Item | Description |
---|
FX Rate Source(s) | Displays each FX Rate source specified in the underlying Source Rule when you submitted the report. |
Cross Currency Calculation | Identifies whether you configured the system for cross currency calculations, along with the currency code used for FX cross rate calculations. Displays either: - Cross currency process is ON using currency XXX
- Cross currency process is OFF
For more information, see "Setting Up the Performance Calculation Report for Multicurrency Conversion."
|
Anchor |
---|
| _Toc521324271 |
---|
| _Toc521324271 |
---|
|
Entity Base Currency Section
...
The Inputs section displays all FX Rate data values used in the generation of the report results. FX Rates appear in order of From Security, To Security, and then Effective Date. See the following figure.
Anchor |
---|
| _Toc361231358 |
---|
| _Toc361231358 |
---|
|
FX Rates Sheet – Inputs Section ExampleEach line in this section provides information about an FX rate used in the report. The following table describes each column in this section.
Item | Description |
---|
From Security | The Primary Asset ID of the cash security you are converting from. |
To Security | The Primary Asset ID of the cash security you are converting to. |
Effective Date | The effective date of the FX rate. |
Source | The source interface instance of the FX rate. |
Spot Rate | The spot rate of the FX rate. |
From Security Alias | The security alias of the cash security you are converting from. |
To Security Alias | The security alias of the cash security you are converting to. |
Anchor |
---|
| _Toc521324273 |
---|
| _Toc521324273 |
---|
|
Field Sheets
...
The Report Parameters section of the Field sheet displays the parameters of the Performance Calculation report profile run. See the following figure.
Anchor |
---|
| RTF310039003500370031003a00 |
---|
| RTF310039003500370031003a00 |
---|
|
Anchor |
---|
| _Toc337537762 |
---|
| _Toc337537762 |
---|
|
Anchor |
---|
| _Toc361231359 |
---|
| _Toc361231359 |
---|
|
Field Sheet - Report Parameters Section Example Anchor |
---|
| _Toc521324275 |
---|
| _Toc521324275 |
---|
|
Field Parameters Section
...
The Analysis Highlights section of the Field sheet displays the highest and lowest five values from all grouping levels, as well any null values for all the input fields. For the highest and lowest five values, the actual value displays while for the null values, the effective date displays. All the Highlights include links to the actual value within the Inputs section. See the following figure.
Note: | If ALL columns are null on a particular effective date, the report does not show these effective dates in the Null Values section of the Analysis Highlights section. |
Anchor |
---|
| RTF330038003900310030003a00 |
---|
| RTF330038003900310030003a00 |
---|
|
Anchor |
---|
| _Toc337537764 |
---|
| _Toc337537764 |
---|
|
Anchor |
---|
| _Toc361231361 |
---|
| _Toc361231361 |
---|
|
Field Sheet - Analysis Highlights Section...
The Inputs section of the Field sheet displays all data values used in the generation of the report results. See the following figure. The Inputs section contains the columns: Group, Rollup Returns ID, Security Alias, End Effective Date, Source, Frequency, Status (Preliminary or Final) and the input columns (specified in the Field Parameters section in Figure 163). Rolled up returns are first sorted by Rollup Returns ID, followed by Security level returns which are sorted by Security Alias.
Note: | If ALL columns are null on a particular effective date, the report does not show any rows or data in the Inputs section for that effective date. |
See the following figure.
Anchor |
---|
| RTF320030003200330033003a00 |
---|
| RTF320030003200330033003a00 |
---|
|
Anchor |
---|
| _Toc337537765 |
---|
| _Toc337537765 |
---|
|
Anchor |
---|
| _Toc361231362 |
---|
| _Toc361231362 |
---|
|
Field Sheet - Inputs Section ExamplePurge EagleEye Files
Your EagleEye files are stored in the customer attachments table in the PACE_MASTER database. Using the Data Archive Policy, you can purge built up EagleEye files or move them to another table.