The Batch Form allows you to do Batch Loading of data, loading of corrected data, Statistical analysis of preproduction data and posting of data for public access. You can also generate Batch Reports (reports of the status of batch processes). You can retrieve, edit, review statistics and reports and batch jobs that are available to them based on their Screening Group.
Batch Load
This form allows the user to transfer a file to the central AQS computer, using CDX
The Batch form has two major sections or blocks.
· · The top portion of the form displays all files currently available for loading that have been delivered by CDX. The Refresh CDX button will refresh this display. (There is no automatic update of the display when CDX delivers a new file.) The currently highlighted line in this section will be the file used when the Load File button at the bottom of the form is clicked. The files listed here are accessible only by you and have been transferred by you at your request
· · The bottom block of the form displays all activities of all users in the currently active Screening Group. The Refresh button will refresh the status display. There is no automatic update of session status.
The user can submit the file as a batch job to be loaded into the AQS database. The user can also submit batch jobs to Submit Correct Data, perform Critical Review and Post data.
The StatCR and Post batch actions only apply to raw data (All other data loaded is set to Production status once it passes completeness tests). ALL raw data must have StatCR and Post run on them regardless of the method of data input (raw data can be entered through the Maintain Raw Data form, the Correct Raw Data form as well as through Batch).
Batch buttons:
· · CDX will start up the CDX application which is used by the EPA to transfer files between your computer and the AQS server (named "canyon"). The Refresh CDX button is used to update the view of the currently available files transported by CDX
· · Load File will open the file highlighted in the upper block of the form and attempt to load the data it contains into AQS. This appears as a FILE job type in the lower section of the form and while it is running the Session Status will be ACTIVE. The Refresh button will update the view. There is no automatic notification of the completion of the Load job. Load jobs that have errors will be indicated by a status of ERROR. Error data is stored in Staging Tables and is accessible from the Correct forms.
· · Submit Correct Data will attempt to load ALL data associated with the current Screening Group that is stored in the Staging Tables. Note that this is not user specific.
· · Stats CR will do statistical evaluations of all new raw data. This reviews the data to look for statistical abnormalities in the data. Reports of findings are accessed as described below. Anomalies found do not necessarily indicate an error.
· · Post will make all data previously analyzed by Stats CR available for public access. This also calculates or recalculates all summaries (daily, quarterly, annual) affected by the newly posted data.
All jobs executed will automatically email a log of the job to the user. This is the only "automatic" notification of job completion. This email may contain error messages not found in any report.
Batch Reports Buttons
Reports are run against the highlighted line in the Session Status section of the form. Only reports available for the particular action will have their button highlighted
When the report is run, the form displays the Session Date, Oracle User ID and File Name for the given Screening Group.
Edit Error Detail reports every failed line of a Load or Submit Correct Data. Often, but not always, a duplicate of the Emailed log of the job. This report is only available for the most recent load job.
Edit/Load Summary reports numbers of successes and failures of the highlighted batch job.
Raw Data Inventory reports updates made by the highlighted Post job
Statistical Evaluation reports findings of the highlighted Stats CR job
Scan reports findings of the highlighted Stats CR job
Note: The user may need to use the 'refresh' button on these forms to get the most up to the minute information on their jobs.