Correct function
This presentation is the property of its rightful owner.
Sponsored Links
1 / 11

Correct Function PowerPoint PPT Presentation


  • 63 Views
  • Uploaded on
  • Presentation posted in: General

Correct Function. AQS Batch Data Input Flowchart. Staging Tables. CDX. Load File. Submit Correct Data. Edit/Load Summary. Edit Error Detail. Correct. Y. Errors. N. Production Tables - Preproduction Status. 1. 2. 3. 6. 12. 60. 16. 72. Legend. Batch. Report. Online.

Download Presentation

Correct Function

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Correct function

Correct Function


Batch load error process

AQS Batch Data Input Flowchart

Staging Tables

CDX

Load

File

Submit

Correct

Data

Edit/Load

Summary

Edit Error

Detail

Correct

Y

Errors

N

Production Tables - Preproduction Status

1

2

3

6

12

60

16

72

Legend

Batch

Report

Online

Production Tables – Production Status

Batch load: Error Process

Result of Load

  • Load with ERROR

    • Reports successes and failures

Correct

2


Correct process

Correct Process

  • CORRECT is a Type of On-Line Editor That Works Against the “Staging Tables”

  • Staging Tables are in the format of the Pipe-Delimited Transactions and are Not the “Real” Table (Because There is an Error that Prevents Them From Getting to the “Real” Table)

Correct

3


Batch load correct forms

AQS Batch Data Input Flowchart

Staging Tables

CDX

Load

File

Submit

Correct

Data

Edit/Load

Summary

Edit Error

Detail

Correct

Y

Errors

N

Production Tables - Preproduction Status

1

2

3

6

12

60

16

72

Legend

Batch

Report

Online

Production Tables – Production Status

Batch load: Correct Forms

There is a form for correcting every type of data input record

Correct

4


Batch load using correct forms

4

1

3

2

Batch load: Using Correct Forms

Execute Query

This will load all of this type of data in the Staging tables for your Screening Group.

If you want to limit selection you must put in selection values before the execute query.

Save

Read the error message(s)

Error messages are the same as in the error details report

Many chose to go straight to the Correct screens rather than run a report.

The column name is sometimes informative.

Find, Analyze and fix the data

Fixing the data often requires knowledge of the nature of the data and may require going back to data sources.

Exclude unfixed data

Excluding unfixed data will keep it from raising error flags during load.

Correct

5


Batch load using correct forms deleting data cont

Batch load: Using Correct FormsDeleting Data (cont.)

The highlighted record can be deleted from the form.

The record will be deleted from the Staging Table database only after a SAVE.

?!

All selected records will be deleted.

The records will be deleted from the Staging Table database when the button is clicked.

Correct

6


Batch load using correct forms deleting data cont1

Batch load: Using Correct FormsDeleting Data (cont.)

  • Delete by Screening group

Delete By Screening Group will completely clear ALL records owned by the Screening Group in the Staging Tables.

Correct

7


Search replace

Search & Replace

  • Not “Search & Replace” as you may know it!

  • Replaces ALL Queried Values in a given column Regardless of the “Current Value”

Correct

8


Correct features

Correct Features

  • New transactions may be entered using Correct forms

  • After making changes/additions on Correct screen, SAVE changes

  • “Delete All Selected” button will delete according to “Execute Query” selection criteria for the form; it will ignore subsequent changes.

  • Can use “Delete by screening group” to completely eliminate all records in staging tables for your screening group

Be sure this is what you want to do. It works quickly and it deletes EVERYTHING for the screening group, including data entered by other users in your screening group.

Correct

9


Batch load submit correct data

AQS Batch Data Input Flowchart

Staging Tables

CDX

Load

File

Submit

Correct

Data

Edit/Load

Summary

Edit Error

Detail

Correct

Y

Errors

N

Production Tables - Preproduction Status

Legend

Batch

Report

Online

Production Tables – Production Status

Batch load: Submit Correct Data

  • Once data is corrected

    • Submit correct data

    • Recheck for errors

    • Correct residual errors

    • Repeat until no errors occur

Correct

10


Put it into practice exercise 2 3

Put it into Practice: Exercise 2.3

  • Analyze and correct the following Batch load error types

    • Site/monitor does not exist

    • Overlapping data

    • Inactive monitor on date of entry

    • Value not found in reference table

Correct

11


  • Login