CREATE ETC REPORT TABLES

Use this screen to create the tables used for the ETC reports and inquiries. This process uses the information you entered in the ETC maintenance screens, and the amounts and hours you entered for project total budgets.

You must run this screen to print ETC reports or view ETC inquiries. Before running this process, you should review and finalize the ETC amounts and hours for the period reflected on the reports.

Select Project

Use this group box to limit which projects will have tables created for them.

Range Option

Select the range of projects that you want to include in the report table. The available selections are:

• All

• One

• Range

• From Beginning

• To End

From

Enter, or use to select, the starting value for the range you want to include. If you select All or From Beginning in the Range Option field, this field will be inactive.

To

Enter, or use to select, the ending value for the range you want to include. If you select All, One, or To End in the Range Option field, this field will be inactive.

Create Data For

You must select at least one of the check boxes in this group box. For each type of data you want to include in the report tables, select the appropriate check box.

ETC Amounts

Select this check box to create the report table to run ETC reports for amounts. The name of the table created is RPT_ETC_AMT.

ETC PLC Hours

Select this check box to create the report table to run ETC reports for hours by PLC. The name of the table created is RPT_ETC_PLC.

ETC GLC Hours

Select this check box to create the report table to run ETC reports for hours by GLC. The name of the table created is RPT_ETC_GLC.

Create report table(s)

Once you have made your selection, click this icon on the toolbar to start the Create ETC Report Tables process.