Transfer FAS 161 Average Volume Report Data

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 in the ESTAR database, Use of the preprocess allows the FAS 161 Average Volume report to only perform calculations, such as the aggregate and average calculations. Because the report can use the data in the FAS161_AVG_VOL table, 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, and can schedule the preprocess to run automatically on a regular basis. 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 transfer FAS 161 Average Volume report data:

1. 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.

2. Complete the options on the Transfer FAS 161 Average Volume Data - Batch panel.

3. 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.