In the Transfer FAS 161 Average Volume Data - Batch panel, you can preprocess report data used by the FAS 161 Average Volume report. This global process populates the FAS161_AVG_VOL table to improve report performancein the ESTAR database, Use of the preprocess enables allows the FAS 161 Average Volume report to only perform calculations, such as the aggregate and average calculations, by using . Because the report can use the data from in the FAS161_AVG_VOL table. The FAS 161 Average Volume report returns a volume of derivative activity across a user-provided date range, namely daily, monthly, quarterly, and yearly or any user-defined date range as allowed. , it does not need to create temporary tables to retrieve data needed for its calculations. This improves the report performance
You can run the preprocess manually using the Transfer FAS 161 Average Volume Data - Batch panel, or and can schedule the preprocess to run automatically on a regular basis. The first time you use the preprocess, the initial process can take some time. Running the preprocess periodically enhances the performance of To populate the FAS161_AVG_VOL table, you run an initial preprocess where you input the initial begin date and current date, thereby retrieving all historical data. When you run the preprocess manually, the system deletes and inserts data in the FAS161_AVG_VOL table, clearing and repopulating the table, You can then schedule the preprocess periodically. In essence, you schedule the preprocess as if you were running the FAS 161 Average Volume report for one day.
To generate transfer FAS 161 Average Volume report data:
In Accounting Center, in the left navigation pane,
...
click Processing & Exceptions
...
> Global Processes > FAS 161 Average Volume
...
> Transfer FAS 161 Average Volume Data - Batch.
You see the Transfer FAS 161 Average Volume Data - Batch panel.Complete the options on the Transfer FAS 161 Average Volume Data - Batch panel.
...
Click Submit.
...
Each time you generate results manually, the system deletes the original results data. It stores only new data in the table
...
for use in the FAS 161 Average Volume report.
Transfer FAS 161 Average Volume Data - Batch Panel Options
A definition of the options on the Transfer FAS 161 Average Volume Data - Batch panel follows.
Option | Tag | Description |
---|---|---|
Entity Parameters | ||
Entity ID | 1163 | Specifies the unique identifier of the entity. You can select a portfolio, sector portfolio, composite portfolio, or Master Fund. |
Entity Name | 1164 | Specifies the name of the entity. You can select a portfolio, sector portfolio, composite portfolio, or Master Fund. |
Accounting Basis | 21 | Specifies the accounting basis for the entity. For example, USTAX, GAAP, or IFRS. |
Run Options | ||
Event Type | 55 | Displays the business intent of the event. For example, GEN_FAS161_AVG_VOL. |
Transfer Type | 991 | Identifies |
whether you are transferring data for a single date or for a date range. Options include:
| ||
Start Date | 220 | Defines the start date. This field appears if you set the Transfer Type field to a value of Transfer Date Range. |
End Date | 221 | Defines the end date. |