database instructions

database instructions.pdf

Brucellosis Program

database instructions

OMB: 0579-0047

⚠️ Notice: This form may be outdated. More recent filings and information on OMB 0579-0047 can be found here:

Document [pdf]

Download: pdf | pdf

Chapter 1:
Overview of the AWBDS Process
This chapter introduces the new Automated Web-Based Data-Submission (AWBDS) process which States can
use to submit, review, and approve their monthly/quarterly animal disease program data for inclusion in the
Veterinary Services (VS) National Reports.
• Non-GDB States (those that do not have their own local Generic Data Base setup) will need to use all of the
AWBDS submission, review, update, and approval features. These AWBDS features together completely
replace the Lotus 1-2-3 spreadsheet/ transmission file method that these States formerly used.
• States that do have a Local GDB setup will use only some of the AWBDS features. These States will still use
the GDB for their data-submission work. Once their program data is stored in the GDB, these States can then
use the AWBDS review, update, and approval features.
• Some States may have only a partial GDB implementation. These States will need to use the two approaches
described above accordingly.
The distinctions on using the AWBDS process between Non-GDB States and GDB States is further explained in the
next section of this chapter.

The topics in this chapter appear below:
Topic

See Page

Major Features of the AWBDS Process

1.2

The AWBDS Process for Non-GDB States

1.3

The AWBDS Process for GDB-Using States

1.5

The AWBDS Web Site

1.7

Working in the AWBDS Webforms

1.8

Installing the Jinitiator Plug-In Utility

1.11

Logging into the AWBDS Web Site

1.13

Where To Go In This Manual

1.15

1.1

Draft – 1 Dec 2004

Major Features of the AWBDS Process

Web-Based Application and Report-Specific Webforms
The AWBDS process is an application that runs at a dedicated web site, available via a normal Internet connection.
Once a State logs into this web site, it can then choose and use a variety of electronic forms (referred to hereafter as
"webforms") that have been customized for the TB6-2, PRV-190, and SPR national reports. For each of these three
Headquarter reports, the AWBDS provides a set of data-submission, query, and approval webforms.

Quality Assurance and Quality Control
The AWBDS process simplifies the reporting process and implements Quality Assurance (QA) and Quality Control
(QC) measures in order to minimize errors in the data reported to the National Animal Health Program Staff
(NAHPS). Each state’s Area-Veterinarian-In-Charge (AVIC) identified a QA list of one to five persons whose role
is to receive the PDF version of the report via email, review the report for accuracy, and report to the QC person
when the report is ready for final approval. The AVIC also identified a QC person for each disease program whose
role is to approve the report. When the reports are approved as correct, the approver’s userid and the date and time
of approval will be recorded in the database.

Treatment of Each Section in a Report as an Individual Function
The AWBDS process will consider and treat each section of each program report as a separate report function. For
example, your State has two animal disease programs: Tuberculosis for Bovines, Caprines, Cervids, and Other
Species; and Pseudorabies for Swine. Your State will use the AWBDS process to approve and submit the following
17 reports:
TB6-2 for Bovines…Section A
TB6-2 for Bovines…Section B
TB6-2 for Bovines…Section C
TB6-2 for Caprines…Section A
TB6-2 for Caprines…Section B
TB6-2 for Caprines…Section C
TB6-2 for Cervids…Section A
TB6-2 for Cervids…Section B
TB6-2 for Cervids…Section C

TB6-2 for Other Species…Section A
TB6-2 for Other Species …Section B
TB6-2 for Other Species …Section C
PRV-190 for Swine…Section A
PRV-190 for Swine…Section B
PRV-190 for Swine…Section C
PRV-190 for Swine…Section E
PRV-190 for Swine…Section F

1.2

Draft – 1 Dec 2004

The AWBDS Process for Non-GDB States
Current Process
A non-GDB-using State previously had to submit its program data to NAHPS at VS Headquarters by performing
the following tasks:
1.
2.
3.
4.

Enter the program data manually into a Lotus 1-2-3 spreadsheet.
Use a macro or script to convert each spreadsheet into a transmission file.
Use a compression utility to reduce the size of each transmission file.
E-mail the transmission files to VS Headquarters.

New Process
The AWBDS web-based application gives non-GDB States the ability to enter their monthly summary data into new
web-based forms for each program disease for which they are responsible to report. When a non-GDB State enters
its monthly summary data into the web-based form and saves the records, the monthly summary data will be stored
into the same temporary holding tables used by the GDB using states.
On the 5th day of each month, the AWBDS's automated process will trigger the automated scheduler application to
run the monthly program report(s) from data the state has been entered into the web-based forms and saved in
temporary holding tables. The process will then send a PDF copy of the monthly report for each report section via
an e-mail message to the 1-5 designated QA person(s) designated by the AVIC. If the state has not yet entered its
data into the web-based forms by the 5th of the month, the state will receive a PDF copy of the report reflecting
zeros for the monthly data entry values. The state will then have approximately 40 days to log into the web-based
application to enter/correct the appropriate summary data for that month. The state’s monthly summary data will
remain in the temporary holding tables until the QC process is completed as described above.
The QA process allows the 1-5 QA person(s) who receive the PDF reports to review the section reports for accuracy
and to report to their designated state QC person on the accuracy of the monthly report data. The automated process
will allow a QC person (per disease program) to approve the monthly data as accurate. To do this, the QC person
will log into a new web-based application system and respond that they have reviewed the data with the QA
person(s) and that they are approving the monthly report on behalf of the state. If the monthly report data is not yet
ready for approval (i.e., the monthly data is not correct or for another reason the monthly report needs to be re-run),
the process allows the QC person to indicate the status of the data. If the data needs to be corrected, the process
allows the data entered for the report to be corrected by the state. After the data is corrected in the report using the
webforms, the QC person will log into the new web-based system and request that the section report be re-run.
Every four hours, the automated scheduler will look for reports that have been approved or that need to be re-run.
Each section of each report is handled as an independent report; therefore, certain sections can be approved and
others disapproved. Only those that are not approved will be re-run and notification sent for review. For reports
that need to be re-run, the automated scheduler application will re-run the report(s) so they contain the corrected
data, and the process will loop through the same dissemination process for review and approval. When the report is
accurate, the QC person finally approves the monthly report. When a positive confirmation is received from the
designated QC person that the data is verified and approved as correct, the State's summary data for that month will
be transferred from the temporary holding tables to the production National Reports Database tables and be made
available for historical reporting purposes.
On the next page, Figure 1.1 illustrates the milestones of the AWBDS process for non-GDB States.

1.3

Draft – 1 Dec 2004

KEY
1. Each month/quarter, the data-entry staff for a State will enter its TB6-2, PRV-190, or SPR data manually into the appropriate
submission webforms at the AWBDS web site. This submission data is then stored in the tables of the Temporary Holding
Database.
th
2. On the 5 day of each month, the Auto-Scheduler application (installed on the CEAH Server) will do two tasks: (a) run the
report(s) and (b) send a PDF copy of each report section, via e-mail message, to 1-5 Quality Assurance (QA) representatives
assigned to the State's disease program.
3. Each QA representative reviews the data for accuracy and completeness. If the data in a report section:
-- is not accurate, the QA representative notifies the State (Step E1). The State corrects its data and updates the appropriate
submission webforms at the AWBDS web site (Step E2). The State's Quality Control (QC) representative for the disease
program then requests that the report be re-run. Using the corrected data, this re-run command alerts the Auto-Scheduler
to re-send the revised PDF file(s) to the 1-5 QA representatives for another review.
-- is accurate, the QA representative notifies the QC representative.
4. The QC representative records his/her approval of each report section at the AWBDS web site.
5. Once a report section's data has been approved, the AWBDS web site notifies the Temporary Holding Database.
6. The approved data is then moved from the Temporary Holding Database into the National Reports Database. This data is now
available for data-retrieval and data-analysis work by VS Disease Program Managers and VS Epidemiologists.
Version 2.0 – 1Dec2004

Figure 1-1. AWBDS Process Flow for Non-GDB States

1.4

Draft – 1 Dec 2004

The AWBDS Process for GDB-Using States
Current Process
Many states enter data directly into the GDB application for managing their TB, PRV, BR and JOH domestic
surveillance programs. For the states that choose to use the GDB, the required program monthly headquarter
reports (including: TB6-2, the PRV-190, the Standard Program reports for sections A-L, and the Sections M and N
for Johnes) have been directly produced from the GDB by MANUALLY selecting the desired report(s) from the
GDB program menu. The summary data contained in the output of these reports is then placed into the Headquarter
Reports Database currently housed at Riverdale. From these database tables, the Program Managers and
Epidemiologists currently have the capability to run headquarters reports by month, year, event type etc. for any of
these domestic programs.

New Process
GDB States will continue to enter their program data directly into the GDB application as is done under the current
process described above. Once the data is in the GDB, however, these States can then begin using the AWBDS
process.
The AWBDS process will automatically run the report(s) via an automated scheduler program. On the 5th day of
each month, the automated process will trigger an automated scheduler application to log into a state's local GDB
database, run the report, and save the monthly summary data into temporary storage tables. It is from these
temporary tables that the automated scheduler program will run the monthly program report(s), send a PDF copy of
each report section of the monthly report via e-mail messages to the 1-5 designated QA person(s) designated by the
AVIC. The state’s monthly summary data will remain in the temporary holding tables until the QC process is
completed. Once the data is saved into the temporary storage tables, the states using GDB will have approximately
40 days to review and approve their monthly reporting data.
The QA process allows the 1-5 QA person(s) who receive the PDF reports to review the section reports for accuracy
and to report to their designated state QC person on the accuracy of the monthly report data. The automated process
will allow a QC person (per disease program) to approve the monthly data as accurate. To do this, the QC person
will log into a new web-based application system and respond that they have reviewed the data with the QA
person(s) and that they are approving the monthly report on behalf of the state. If the monthly report data is not yet
ready for approval (i.e., the monthly data is not correct or for another reason the monthly report needs to be re-run),
the process allows the QC person to indicate the status of the data. If the data needs to be corrected, the process
allows the data entered for the report to be corrected by the state. After the data is corrected in the state’s local
GDB, the QC person will log into the new web-based system and request that the section report be re-run. Every
four hours, the automated scheduler will look for reports that have been approved or that need to be re-run. Each
section of each report is handled as an independent report; therefore, certain sections can be approved and others
disapproved. Only those that are not approved will be re-run and notification sent for review. For reports that need
to be re-run, the automated scheduler application will re-run the report(s) so they contain the corrected data, and the
process will loop through the same dissemination process for review and approval. When the report is accurate, the
QC person finally approves the monthly report. When a positive confirmation is received from the designated QC
person that the data is verified and approved as correct, the State's summary data for that month will be transferred
from the temporary holding tables to the production National Reports Database tables and be made available for
historical reporting purposes.
On the next page, Figure 1.2 illustrates the milestones of the AWBDS process for GDB-using States.

1.5

Draft – 1 Dec 2004

KEY
1. Each month/quarter, the data-entry staff for a State will enter its TB6-2, PRV-190, or SPR data manually into its Local GDB.
The Local GDB then pushes this submission data automatically into the tables of the Temporary Holding Database.
th
2. On the 5 day of each month, the Auto-Scheduler application (installed on the CEAH Server) will do two tasks: (a) run the
report(s) and (b) send a PDF copy of each report section, via e-mail message, to 1-5 Quality Assurance (QA) representatives
assigned to the State's disease program.
3. Each QA representative reviews the data for accuracy and completeness. If the data in a report section:
-- is not accurate, the QA representative notifies the State (Step E1). The State corrects its data and updates it within that
State's Local GDB (Step E2). The State's Quality Control (QC) representative for the disease program then requests that
the report be re-run. Using the corrected data, this re-run command alerts the
Auto-Scheduler to re-send the revised PDF file(s) to the 1-5 QA representatives for another review.
-- is accurate, the QA representative notifies the QC representative.
4. The QC representative records his/her approval of each report section at the AWBDS web site.
5. Once a report section's data has been approved, the AWBDS web site notifies the Temporary Holding Database.
6. The approved data is then moved from the Temporary Holding Database into the National Reports Database. This data is now
available for data-retrieval and data-analysis work by VS Disease Program Managers and VS Epidemiologists.
Version 2.0 – 1Dec2004

Figure 1-2. AWBDS Process Flow for GDB-Using States

1.6

Draft – 1 Dec 2004

The AWBDS Web Site
In the previous section, you learned about the AWBDS process. You will be doing all of the work in this process at
the AWDBDS web site.
Below is a chart that illustrates the contents of the AWBDS web site. The pages in this web site are grouped into
three task-oriented areas:
• Task 1: Entering and submitting your State's animal disease management program data.
• Task 2: (Done by QA and QC personnel only)… Reviewing and approving the data submitted by a State.
• Task 3: Running (generating) new VS National Surveillance Program Reports, which will now include the
data submitted by your State.

Figure 1-3. Site Map for the AWBDS Web Site

1.7

Draft – 1 Dec 2004

Working in the AWBDS Webforms
All of your data-entry work will be done within the webforms found at the AWBDS web site. While their contents
and labels may differ, all of these forms have the same general "look and feel". An example of the data-submission
form that you would use to submit your State's TB6-2 summary data appears below.
Menu Bar
Toolbar
Title Bar
Report
Parameters
Block
L button –
displays a List
of Values

Report Section
Tabs

Field Label
Data Field

Report Data
Block

Command Buttons

Figure 1-4. Typical Features on an AWBDS Webform
Note how this form is divided into three sections:
• the area above the dark blue Title Bar at the very top contains the Menu Bar and Toolbar, whose commands
you can use to speed up your data-entry work within each webform.
• the yellow block just beneath the Title Bar is where you specify the parameters (such as the animal species and
disease program) for the report you want to generate.
• the bottom light blue block contains tabbed pages for each individual section of the TB6-2 report. On these
tabbed pages, you will enter premises- and animal-related data that will be used to generate the national
Tuberculosis Eradication Program Activities reports.
Another feature to note are the data fields on the form that have an ! or L button next to them (see the Report
Section Letter and Stage fields above). This kind of data field does not let you enter any data you wish -- instead,
you must choose from a List of Values associated with that field. However, you can enter your choice into this kind
of data field in any of several ways:
• Click on the ! or L button to display the field's List of Values, highlight your choice in the list, then click
OK.
• Type the first letter of your choice, and then press ENTER. The web site will automatically finish spelling
your choice for you.
• Double-click over the data field that has an L button next to it.

1.8

Draft – 1 Dec 2004

• Search for the appropriate choice by spelling as much of it as you do know. Then insert the % symbol (the per
cent sign, which acts as a wildcard variable) for the letters you are not sure of. Press ENTER. The website
will search for all possible values that match your search criteria and display these matches in a popup window
for you to choose from.
To search for:
all program stages starting
with A
all data-collection locations
or States whose code
includes the letter N

Type this:
A%
%N

To Get These Kinds of Results:
A1
A2
CN
Canada
IN
Indiana
MN
Minnesota
N1
New York Animal Import Center
NC
North Carolina
NE
Nebraska

Let's return to the Menu Bar and Toolbar features on the forms.
• The Menu Bar contains eight menus. When you click on a Menu Item, (such as Edit), a pull-down list of
commands will appear. Simply highlight the command you want to use.
• The most frequently–used commands in the Menu Bar also appear as icons on the Toolbar (shown below).
Just click once on the icon for the command you want to perform.

Save

Enter
Query

Copy

Exit

Cut

Paste

Cancel
Query

Execute
Query

Previous
Record

Previous
Block

Next
Block

Next
Record

Remove
Record
Insert
Record

Figure 1-5. Commands in the Toolbar of an AWBDS Webform

1.9

Lock
Record

Help

Draft – 1 Dec 2004

The table below describes each command found in the Menu Bar and/or Toolbar.
Menu Title
Commands
Action
Save
Clear All
Print
Exit
Edit
Cut
Copy
Paste
Edit
Display List…
Query
Enter
Execute
Cancel
Last Criteria
Count Hits
Fetch Next Set
Block
Previous
Next
Clear
Record
Previous
Next
Scroll Up
Scroll Down
Remove
Lock
Duplicate
Clear

Field
Previous
Next
Clear
Duplicate
Help
Help
Keys
Display Error
Window
Cascade
Tile Horizontally
Tile Vertically
1 (form name)
2 (form name)

Purpose of Each Command

Submits the form's data into the AWBDS' Temporary Holding Database for validation/storage.
Removes all currently-displayed data from the form's fields.
Writes the current form to a file and asks if you want to print that form.
Exits the current form and returns you to a previous form or menu screen.
Deletes any currently-selected data from the onscreen form and stores the data in a paste buffer.
Copies any currently-selected data from the onscreen form and stores the data in a paste buffer.
Pastes any data from the paste buffer into the field where the cursor is currently located.
…Not currently in use…
Returns the Lookup values for a data field that has an L button next to it.
Acknowledges any data you just entered in a field, then moves the cursor to the next enterable field.
Clears the current block and retrieves all records from the database that match your search values.
Returns you to a blank Query Webform without executing your query.
Returns to the last query you submitted.
Returns the number of records that will be returned.
Retrieves the next set of 10 records into the current block from all records that satisfy an active
query and displays the first record in the form.
Moves the cursor to the previous block in the onscreen form.
Moves the cursor to the next block in the onscreen form.
Clears all data from the current block.
Lets you display the previous record in a record set that was retrieved by a query.
Lets you display the next record in a record set that was retrieved by a query.
Shifts the current view of the form upward in order to view its non-visible portions.
Shifts the current view of the form downward in order to view its non-visible portions.
Deletes the currently-displayed record from both the onscreen form and the Temporary Holding
Database.
Allows you to save data-entry steps by duplicating the last entered record.
Copies all data values from the previous record into a new record.
Deletes the currently-displayed record from the onscreen form, but not from the Temporary Holding
Database.
Moves the cursor to the previous enterable field.
Moves the cursor to the next enterable field.
Removes any data currently displayed in the field where the cursor is located.
Copies the currently-selected data into a new field that you choose.
Displays the popup screen with the properties for the field in which the cursor is positioned.
Press ENTER to close this popup screen and return to the form.
Displays a popup screen of all keyboard shortcuts and function key assignments.
Displays the full text of an error message you might have received onscreen
Refreshes the screen to make any open forms overlap each other and their title bars visible.
Refreshes the screen to make any open forms appear like table rows of equal size.
Refreshes the screen to make any open forms appear like table columns of equal size.
Link to the previous form you visited before displaying the current form.
Link to the current form that appears in front of any other open forms.

1.10

Draft – 1 Dec 2004

Installing the Jinitiator Plug-In Utility
The task of installing the Jinitiator plug-in utility, version 1.3.1.13, needs to be done only once. You should do this
prior to the first work session in which you want to run the AWBDS application. Only a person who has a
Windows user profile containing administrative privileges will be allowed to install this plug-in. If you do not have
administrative privileges, you will not be able to do this procedure.

1.1

If necessary, boot up your computer and log into Windows as you normally do.

1.2

Connect your computer to the Internet.

1.3

Start up the Microsoft Internet Explorer web browser application.

1.4

In the Address field of the web browser, enter the following URL to go to the AWBDS website:
http://mdrdoras54.aphis.usda.gov:7783/forms90/f90servlet?config=gdbnatrpt

1.5

A white screen will appear, which will look different depending on the user profile you used when logging
into Windows back in Step 1.1.
• If you do not have administrative privileges, the white screen you see will remain blank, and you may
see the word Done in the Status Bar at the bottom of the screen.
You cannot proceed any further in this procedure. You must exit the browser, and then contact your IT
department or supervisor for help.
• If you do have administrative privileges, the white screen will have a "red X" graphic icon in the upperleft corner. You can now continue with the Jinitiator plug-in installation by doing the rest of the steps in
this procedure.

1.6

After a short delay, you may see a pop-up message box in the middle of the white screen, explaining the
Information Bar feature. Click on OK to have this feature installed and to close this box.

1.7

Directly below the Address field, you should see a yellow bar containing a message, like the one shown
here:

a. Click once anywhere inside the yellow bar to highlight the entire message.
b. Click and hold once on the phrase, Click here to install…, to display a drop-down menu.
c. In the drop-down menu, click on the Install ActiveX Control… option (as shown below).

Next, you will see a Setup Progress pop-up box that shows in real-time the downloading
activity of the Jinitiator software).

1.11

Draft – 1 Dec 2004

1.8

The InstallShield Wizard program then begins the Jinitiator installation process. The white screen will
change to green, and you will be presented with a series of dialog boxes. For each dialog box, accept the
default option.
After the wizard program finishes its work, you should see a Jinitiator installation complete message.

1.9

You now need to wait for 1-2 minutes for the AWBDS application to configure itself and start up.
Eventually, you will see the Logon box shown below:

Congratulations! You have successfully installed Jinitiator. You will not need to do this procedure again.
For all future work sessions, you should instead use the Logging into the AWBDS Web Site procedure found
in the next section of this chapter.

1.12

Draft – 1 Dec 2004

Logging into the AWBDS Web Site
Below is the procedure to follow each time you want to start a new work session and use the AWBDS application
and web site. This procedure applies to both GDB-using States and non-GDB-using States.

1.1

If necessary, boot up your computer and log into Windows as you normally do.

1.2

Connect your computer to the Internet.

1.3

Start up the Microsoft Internet Explorer web browser application.

1.4

In the Address field of the web browser, enter the following URL to go to the AWBDS website:
http://mdrdoras54.aphis.usda.gov:7783/forms90/f90servlet?config=gdbnatrpt

1.5

When the Logon screen (shown below) appears onscreen, do the following:

a. In the Username1 field, type your user name.
b. In the Password1 field, type your password.
c. In the Database2 field, type the name of the production database, which is this: mdapnat
(If you have any questions about what login values you should be entering, contact your system
administrator.)
d. Click on the Connect button.
1

If your State has a Local GDB, then use the same Username/Password that you normally use to log into
the GDB on your local database. If your State does not use GDB, then you should request a new
Username/Password by contacting the GDB Helpdesk (see Chapter 14 for details).

Always use mdapnat (the literal name of the production database) in this field.

1.13

Draft – 1 Dec 2004

1.6

The Veterinary Services National Program Reports Menu (shown below) appears onscreen.

1.7

At this point, you now have a choice on which of the three tasks you wish to do. The table in the next
section, Where To Go In This Manual, will help you decide.

1.14

Draft – 1 Dec 2004

Where To Go In This Manual
This manual is divided into five sections, as outlined in the table below:
Manual
Section

Report
Name

Chapter
#

Section A

---

Overview of the AWBDS Process and Web Site

1.1

Submitting your State's Data for a TB6-2 National Report

2.1

Updating your State's Data for a TB6-2 National Report

3.1

Section B

Section C

Section D

Section E

TB6-2

PRV-190

SPR

---

Chapter Title

See Page

Approving your State's Data

4.1

Running a TB6-2 National Program Report

5.1

Submitting your State's Data for a PRV-190 National Report

6.1

Updating your State's Data for a PRV-190 National Report

7.1

Approving your State's Data

8.1

Running a PRV-190 National Program Report

9.1

Submitting your State's Data for an SPR National Report

10.1

Updating your State's Data for an SPR National Report

11.1

Approving your State's Data

12.1

Running an SPR National Program Report

13.1

Where to go for Help

14.1

1.15

Draft – 1 Dec 2004

1.16

Chapter 2:
Submitting Your State's Data for a
TB6-2 National Report
This chapter is for those States "not using" the GDB to enter their Tuberculosis surveillance data. It covers the
procedures for using, completing, and submitting your State's monthly TB eradication summary data, using the
AWBDS TB6-2 Data-Submission webform. The topics in this chapter appear below:
Topic

See
Page

Information Needed to Enter into the TB6-2 Data-Submission Webform

2.2

Requirements on Using the TB6-2 Data-Submission Webform

2.2

Procedure for Completing the TB6-2 Data-Submission Webform

2.4

2.1

Draft – 1 Dec 2004

Information Needed to Enter into the TB6-2
Data-Submission Webform
To do this procedure, you need to have available the summary data from your State's TB6-2 monthly report
regarding Tuberculosis (TB) eradication activities. This summary data may be compiled from your State's
Tuberculosis program data collection documents (such as those shown below), or from other sources.
VS Form 6-22
VS Form 6-22C
VS Form 6-22D
TB6-2

Tuberculosis Test Record
Tuberculin Test Record
Comparative Cervical Tuberculin Test Results
Monthly report of TB eradication activities

Requirements on Using the TB6-2 Data-Submission
Webform
When you open the TB6-2 Data-Submission webform on the AWBDS web site, you will see that the webform has
three tabbed pages on it -- one tabbed page for each of the three sections (A1, B1, and C1) that make up the VS
TB6-2 National Report. There are two requirements regarding this TB6-2 Data-Submission webform.
Requirement 1:
You must complete all three tabbed pages on the TB6-2 Data-Submission webform, even if you have no data this
month to enter on one or more of its pages.
Example: For this month, your State
• does have TBCF testing data to submit – you would enter this data on the Section A1 tabbed page of the
webform.
• does have TBCC testing data to submit – you would enter this data on the Section B1 tabbed page of the
webform.
• does not have any slaughter test results to submit -- you would enter the number 0 (zero) in each data field on
the Section C1 tabbed page of the webform.

Requirement 2:
The VS TB6-2 National Report has four parts in it, each part representing a species group: BOV, CAP, CER, and
OTH (which includes any species that are not BOV, CAP, or CER). In order to provide all of the necessary data for
the National Report, you will need to enter data for each of these four parts in each of the three sections of your
TB6-2 Data-Submission webform.
Example: To successfully submit your State's TB data for the month of September 2004, you will need to complete:
• Section A1 four times (one time each for BOV, CAP, CER, and OTH)
• Section B1 four times (one time each for BOV, CAP, CER, and OTH)
• Section C1 four times (one time each for BOV, CAP, CER, and OTH)
Note: If there was NO DATA during a report period for a particular part (species group), you must instead create
and submit a null report (one with all zeros) for that part. In other words, if your State does not have any TB data
to report for the CER species, you would create and submit a null Section A1 report for CER, a null Section B1
report for CER, and a null Section C1 report for CER.

2.2

Draft – 1 Dec 2004

On the other hand, if you do have data to report for each species, then this requirement means that you must fill out
12 sections in order to successfully submit your for your TB6-2 Data-Submission webform. Shown below is a
suggested sequence, which can help you keep track of which report section – species combination you need to do
next:
Task 1.
Task 2.
Task 3.
Task 4.
Task 5.
Task 6.
Task 7.
Task 8.
Task 9.
Task 10.
Task 11.
Task 12.

Fill out the Section A1 tabbed page on the webform for the BOV species.
Fill out the Section B1 tabbed page on the webform for the BOV species.
Fill out the Section C1 tabbed page on the webform for the BOV species.
Fill out the Section A1 tabbed page on the webform for the CAP species.
Fill out the Section B1 tabbed page on the webform for the CAP species.
Fill out the Section C1 tabbed page on the webform for the CAP species.
Fill out the Section A1 tabbed page on the webform for the CER species.
Fill out the Section B1 tabbed page on the webform for the CER species.
Fill out the Section C1 tabbed page on the webform for the CER species.
Fill out the Section A1 tabbed page on the webform for the OTH species.
Fill out the Section B1 tabbed page on the webform for the OTH species.
Fill out the Section C1 tabbed page on the webform for the OTH species.

Both Requirement 1 and Requirement 2 are covered in more detail in the following procedure, so that you can see
when and how to perform them.

2.3

Draft – 1 Dec 2004

Procedure for Completing the TB6-2 Data-Submission
Webform
This procedure describes how to fill out all three sections (A1, B1, and C1) of the TB6-2 Data-Submission webform
during a single work session. However, if you cannot complete all three sections of the webform during a single
work session, you can work on each section individually. But keep in mind that this approach will require you to
keep track of the data you entered into the Report Parameters block (the top block on the webform) – some fields in
this block must contain the same data regardless of which section you are currently working in.
To Work On:

Do These Steps Of This Procedure:

Sections A1, B1, and C1
Section A1 only
Section B1 only
Section C1 only

Step 1.1 through Step 1.9
Step 1.1 through Step 1.6
Step 1.1 through Step 1.5, then Step 1.7
Step 1.1 through Step 1.5, then Step 1.8

1.1

If necessary, log into the AWBDS web site.

1.2

The Veterinary Services National Surveillance Program
Reports main menu screen (shown at right) will appear.
In this screen, click on the Enter Summary Data option.

1.3

The National Reports Summary Data Entry Forms main menu
screen (shown at right) now appears.
In this screen, click on the [1] button next to the TB6-2
Tuberculosis option.

2.4

Draft – 1 Dec 2004

1.4

A blank TB6-2 Information Data-Submission webform will appear.
Menu Bar
Toolbar

Report
Parameters
Block

Functional Tabs

Animal and
Disease Program
Block

Command Buttons

2.5

Draft – 1 Dec 2004

1.5

Fill out the top block of the webform according to the guidelines in the following table. To move from one
field to the next field, press the TAB or ENTER key.

Field

Guidelines

Report Section
Letter

Letter of the section in the TB6-2 report for which you are submitting your data.
Click on the L button to display a List of Values for this field. The choices are:
A1
On-farm testing (using the Caudal Fold, Single Cervical, or Cervical Tuberculin test)
B1
On-farm testing (using the Comparative Cervical or Blood Tuberculosis test)
C1
Postmortem results from slaughter
Query (See Chapter 3 for instructions on how to use this feature for TB6-2.)
As soon as you select a value for this field and press TAB or ENTER, the Event Type field will be
automatically populated with an appropriate value. Also, the bottom block of the webform will
refresh and display only the tabbed page for the Report Section Letter you just selected.

State

Enter the two-letter postal abbreviation (such as WY) for the state in which the data collection
activity took place.

Species

Code for the animal species whose test results are being reported on this webform.
Click on the L button to display a List of Values for this field. The choices are:
BOV
Cattle
CAP
Goats
CER
Cervidae (includes Deer, Elk, Fallow Deer, Moose, Mule Deer, Red Deer, Reindeer,
and White-Tail Deer)
OTH
Other species not covered in the above three choices

Stage

Code for the stage level of your State for which the national report is being prepared.
Click on the L button to display a List of Values for this field. The choices are:
F
Free
S
Suspended
A
Modified Accredited Advanced
M
Modified Accredited
P
Accredited Preparatory
N
Non Accredited

Event Type

Code for the test event you are reporting on this webform.
This field will be populated automatically for you. The choices you will see are:
TBCF Caudal fold
TBCC Comparative cervical
TBCV Single cervical
TBOT Other test types
TBPA Palpebral
TBPM Postmortem examination

Begin Date

Enter the first date of the time period for which the national report is being prepared.
Use one of these formats: DD-MON-YYYY or DD MON YYYY or DD-MON-YY or DD MON YY
(i.e., 01-JUL-2004 or 01 JUL 2004 or 01-JUL-04 or 01 JUL 04).

End Date

Enter the last date of the time period for which the national report is being prepared.
Use one of these formats: DD-MON-YYYY or DD MON YYYY or DD-MON-YY or DD MON YY
(i.e., 01-JUL-2004 or 01 JUL 2004 or 01-JUL-04 or 01 JUL 04).
After pressing TAB or ENTER, your cursor returns to the Report Section Letter field.

Report Run Date

Automatically populated with today's date the first time you execute the "Save" command. (You
can wait to do this after you start working in the webform's bottom block.)

2.6

Draft – 1 Dec 2004

1.6

The tabbed page labeled Section A Reason for Test on Farm should be displayed onscreen:

The table below describes what kind of data you will enter into the fields on this page.
Field

Guidelines

Test Reason

Code for the reason the animal(s) or animal lot(s) were tested.
Click on the L button to display a List of Values for this field. The choices are:
ARE
Area
HA
Accreditation/Reaccredidation
MO
Milk Ordinance
MOV Movement
IMP
Import
INF
Infected
TK
Trace from Kill
TR
Trace Reactors
TE
Trace Exposed
SA
Suspect or Deviator Retest
OTH
Other (reason not listed above)

Total Tested
Total NR Lots Tested
Total NR Animals Tested

Total # of on-farm animal lots tested during this report period.
Total # of individual animals tested during this report period.

Lots Containing Reactors
NR Lots Tested
NR Animals Tested
NR Reactors
NR Deviators

Total # of on-farm animal lots tested during this report period.
Total # of individual animals tested during this report period.
Total # of animals showing a swelling of 5 millimeters or greater in diameter.
Total # of animals showing a minimal or PP (pinpoint) response to tuberculin.

Lots with Deviators but no
Reactors
NR Lots Tested
NR Animals Tested
NR Deviators

Total # of on-farm animal lots tested during this report period.
Total # of individual animals tested during this report period.
Total # of animals showing a minimal or PP (pinpoint) response to tuberculin.

a. In the Test Reason data field, select ARE in the List of Values.
b. Fill out the rest of the fields on this page with the appropriate data from your paper forms that
pertain to the ARE test reason. If you have no data to enter into a specific field, enter 0 (zero)
instead.
c. Click on either the Save command button at the bottom of the webform or the Save icon in the
Toolbar. Doing this immediately saves all of the data you just entered for the ARE test reason.
d. Click on the New Line for Section command button.
e. In the Test Reason data field, select the next choice in the List of Values (for this sub-step, it would
be HA).

2.7

Draft – 1 Dec 2004

f. Fill out all of the fields with the data from your paper forms for the HA test reason. If you have no
data to enter into a specific field, enter 0 (zero) instead.
g. Click on either the Save command button or the Save icon.
h. Click on the New Line for Section command button.
i. Repeat Step 1.6e through Step 1.6h for each choice shown in the Test Reason field's List of Values.
Reminder: If you have no data to enter for a particular Test Reason value (in other words, all
entries for this reason would be 0 (zero)), you do not have to do Steps 1.4e – 1.4h for that particular
Test Reason.
j. After you have saved the data for the final Test Reason choice, you can do either task below.
• Set up the webform to begin entering your State's data for Section B1:
i. Return to the top block of the webform In the Report Section Letter data field,
select the B1-ON FARM TESTING choice from the List of Values.
ii. Make sure the Species value for Section B1 is the same value you had for
Section A1.
iii. Change the Begin Date and End Date values, if necessary.
iv. Continue with Step 1.7 below
• Exit the TB6-2 Data-Submission webform by clicking on either the Exit command
button at the bottom of the webform or the Exit icon in the Toolbar.

2.8

Draft – 1 Dec 2004

1.7

The tabbed page labeled Section B Reason for Test on Farm should be displayed onscreen.

The table below describes what kind of data you will enter into the fields on this page.
Field

Guidelines

Test Reason

Total Tested
Total NR Lots Tested
Total NR Animals Tested

Total # of on-farm animal lots tested during this report period.
Total # of individual animals tested during this report period.

Lots Containing Reactors
NR Lots Tested
NR Animals Tested
NR Reactors
NR Deviators

Lots with Suspects but no
Reactors
NR Lots Tested
NR Animals Tested
NR Suspects

Total # of on-farm animal lots tested during this report period.
Total # of individual animals tested during this report period.
Total # of animals which show a response to tuberculin, but which are not classified as
DEVIATORS or REACTORS.

2.9

Draft – 1 Dec 2004

e. In the Test Reason data field, select the next choice in the List of Values (for this sub-step, it would
be HA).
f. Fill out all of the fields with the data from your paper forms for the HA test reason (or with zeros if
you have no data for individual fields).
g. Click on either the Save command button or the Save icon.
h. Click on the New Line for Section command button.
i. Repeat Step 1.7e through Step 1.7h for each choice shown in the Test Reason field's List of Values.
j. After you have saved the data for the final Test Reason choice, you can do either task below.
• Set up the webform to begin entering your State's data for Section C1:
i. Return to the top block of the webform In the Report Section Letter data field,
select the C1–POSTMORTEM RESULTS FROM SLAUGHTER choice from
the List of Values.
ii. Make sure the Species value for Section C1 is the same value you had for
Section A1.
iii. Change the Begin Date and End Date values, if necessary.
iv. Continue with Step 1.8 below
• Exit the TB6-2 Data-Submission webform by clicking on either the Exit command
button at the bottom of the webform or the Exit icon in the Toolbar.

2.10

Draft – 1 Dec 2004

1.8

The tabbed page labeled Section C Postmortem Results from Slaughter should be displayed onscreen.

The table below describes what kind of data you will enter into the fields on this page.
Field

Guidelines

Carcass Disposition

Code for the final handling of an animal's carcass.
Click on the L button to display a List of Values for this field. The choices are:
CPF
Carcass passed for food
CPC
Carcass passed for cooking
CCC
Carcass condemned
CNP
Carcass not posted

Reactors
NR Reactor NGL or Skin Lesions
NR Reactors Internal Lesions
Total NR Reactors
Exposed Non-Reactors
NR Non-Reactor NGL or Skin Lesions
NR Non-Reactors Internal Lesions
Total Non-Reactors

Total # of animals classified as REACTORS that have No Gross Lesions
(NGL) or skin lesions caused by Tuberculosis.
Total # of animals classified as REACTORS that have internal lesions caused
by Tuberculosis.
Total # of REACTOR animals tested during this report period.

Total # of animals classified as NON-REACTORS that have No Gross Lesions
(NGL) or skin lesions caused by Tuberculosis.
Total # of animals classified as NON-REACTORS that have internal lesions
caused by Tuberculosis.
Total # of NON-REACTOR animals tested during this report period.

a. In the Carcass Disposition data field, select the appropriate choice from the List of Values.
b. Fill out the rest of the fields on this page with the appropriate data from your paper forms that
pertain to the disposition choice you just selected. If you have no data to enter into a specific field,
enter 0 (zero) instead.
If you have no data to enter for a particular disposition -- in other words, all entries for it would be 0
(zero) -- you can skip that disposition.
c. Click on either the Save command button at the bottom of the webform or the Save icon in the
Toolbar. Doing this immediately saves all of the data you just entered for your disposition reason.

2.11

Draft – 1 Dec 2004

1.9

Once you have completed Sections A1, B1, and C1 on the webform for a single animal species (either during
a single work session or several sessions), you will have finished your data-entry work for one part of the
TB6-2 Data-Submission webform.
You can now either exit the TB6-2 Data-Submission webform, or you can continue entering data for the
other parts of the report.
• To exit the TB6-2 Data-Submission webform, click on the Exit button at the bottom of the webform
or the Exit icon in the Toolbar.
• To start submitting data for another animal species, do these steps:
i. Either select the Record > Clear command in the Menu Bar or click on the Clear
Record icon in the Toolbar. This action removes the current data from the webform so
that you now have a blank webform in which to work.
ii. Repeat Step 1.5 through Step 1.8 for the next animal species (part) of the TB6-2
Data-Submission webform.
iii. Continue repeating Step 1.5 through Step 1.8 for each additional animal species (part)
until you have completed all four parts of your TB6-2 Data-Submission webform.

2.12

Chapter 3:
Updating Your State's Data for a
TB6-2 National Report
This chapter covers the procedures for updating your State's Tuberculosis disease program data, using a set of
customized TB6-2 Query webforms available at the AWBDS web site.
You can perform these procedures as long as the Quality Control (QC) person for your State has not yet approved
your State's monthly Tuberculosis summary data.
The topics in this chapter appear below:
Topic

See Page

Introduction
When Not to Update Your TB6-2 Data

3.2
3.2

Procedure 1: Updating Your State's Data, by Using the TB6-2 Query Webforms

3.3

Procedure 2: Using the Auto-Scheduler to Process Your Updated Data

3.14

Reference Table 1: Organized by Report Section Letter

3.17

Reference Table 2: Organized by Data Field Labels

3.18

3.1

Draft – 1 Dec 2004

Introduction
The AWBDS process allows you to modify, if necessary, the data you have submitted for your State's TB program.
There are two steps involved in updating an existing TB6-2 Data-Submission record:
1.

You first retrieve from the Temporary Holding Database the record you want to update. This is
accomplished by specifying one or more search values on a customized TB6-2 Query webform. There are
three of these customized Query webforms, one for each of the three sections in the TB6-2 report. You
then execute your query; any matching TB6-2 Data-Submission records found will be retrieved and
displayed onscreen, one at a time, within the Query webform. You can view, print, and modify these
records right there within the Query webform itself.

Once you have updated a Data-Submission record, you then use the Auto-Scheduler utility at the AWBDS
web site to process your revised data. You accomplish this by leaving the Query webform and going to a
different area of the web site. In this new area, you will use an Approval webform to instruct the AutoScheduler to immediately (rather than wait until the 5th day of the next month) process your record.
Once the Auto-Scheduler has been alerted, it will do three tasks:
• Generate a new report from your modified Data-Submission record.
• Create a PDF version of the new report and e-mail it to the appropriate QA personnel in your State.
• Transfer the data in the updated report into the Temporary Holding Database. The data will remain
here until it has been officially reviewed and approved by the QC personnel.

You can query for, retrieve, and modify your State's TB6-2 Data-Submission records at any time, as long as the data
has not yet been approved by your State's QC personnel. Once a QC representative approves a TB6-2 DataSubmission record, its data is moved from the Temporary Holding Database to a permanent National Reports
Database. After this move occurs, the data can no longer be retrieved for the purposes of updating it.

When Not to Update Your TB6-2 Data
In Chapter 1, you learned that the Auto-Scheduler utility is pre-programmed to routinely do its three tasks on the 5th
day of every month. If by this date, your State:
• has finished entering its program report data for the previous month/quarter, the Auto-Scheduler will generate
the appropriate reports, e-mail them to QA personnel, and transfer the data to the Temporary Holding
Database.
• has not finished entering its program report data, the Auto-Scheduler will still generate, e-mail, and transfer
the appropriate reports, but these reports will be null (containing only zeros).
To avoid potential processing and data errors, do not attempt to update a null TB6-2 report. Instead, you should
delete it (see Chapter 4) and submit your data again in a new Data-Submission webform (see Chapter 2).
The reason you should not try to do this kind of update is that, for a null report the Auto-Scheduler creates only one
Test Reason line in a report section, with all zeroes. For example, your State has TB6-2 data for three different Test
Reasons in Section A, but the data did not get entered before the 5th deadline. The Auto-Scheduler will create a
Section A report with null values for just one Test Reason line. Several days later, you try to use a Query webform
to correct the null data in this report as well as add new data for the other two Test Reasons. You could update one
line – but the system will not allow you to enter the additional lines except in the Data-Submission webform. It will
be easier and safer to just delete the null report file and to enter all the data for the report section at one time in a
new Data-Submission webform.

3.2

Draft – 1 Dec 2004

Procedure for Updating Your State's Data, by
Using the TB6-2 Query Webforms
This procedure describes how to use the three customized TB6-2 Query webforms to retrieve data, modify it, and
save it back into the Temporary Holding Database.

1.1

If necessary, log into the AWBDS web site.

1.2

The Veterinary Services National Surveillance Program
Reports main menu screen (shown at right) will appear.
In this screen, click on the Enter Summary Data option.

1.3

The Summary Data Entry Forms main menu screen (shown at
right) now appears.
In this screen, click on the [1] button next to the TB6-2 Tuberculosis
option.

3.3

Draft – 1 Dec 2004

1.4

1.5

A blank TB6-2 Information Data-Submssion webform will appear.

In the Report Section Letter field in the top block, do the following:
a. Click on the L to display a List of Values. In this list, you will see three query form choices:
Query
Webform

Use This Form to Retrieve Data-Submission Records Containing
Data on:

Query_A
Query_B
Query_C

TBCF test results
TBCC test results
Slaughter test results

b. In this list, select the query form you want to use.
c. Click OK.
The List of Values disappears. The option you selected now appears in the Report Section Letter
field.
d. Press ENTER.
e. If you selected:
Query_A
Query_B
Query_C

Go directly now to Step 1.6 in this procedure.
Go directly now to Step 1.7 in this procedure.
Go directly now to Step 1.8 in this procedure.

3.4

Draft – 1 Dec 2004

1.6

If you selected Query_A, you should now see the following Query webform onscreen. This webform has
been customized for Section A of the TB6-2 report:

Field Label on
Data-Submission Form

Data Stored in This Field
on Both Forms
Default=TB62

Sectn

(Not found on Data-Submssion
webform)
A

State

Code for the State in which the data-collection activity took
place.

Disease

Code for the disease whose data was submitted.

Stg

Stage

Stage level that your State was in during this reporting
period.

Species

Code for the animal species whose test results was
submitted.

Dt Beg

Begin Date

First date of the time period whose data was submitted.

Letter for the related section in the TB6-2 report.

Dt End

End Date

Last date of the time period whose data was submitted.

Run Dt

Report Run Date

Date on which your State's data was submitted.

Rec Type

(Not found on D-S Form)

Default=A1

Event Type

Code for the test event whose data was submitted.

Test Reason

Code for the reason the animals/lots were tested.

Total nr lots tested

Total Tested:
Total NR Lots Tested

Total # of on-farm animal lots that were tested during this
reporting period.

Total nr animals tested

Total Tested:
Total NR Animals Tested

Total # of individual animals that were tested during this
reporting period.

Nr lots tested, in lots
containing reactors

Lots Containing Reactors:
NR Lots Tested

Total # of on-farm animal lots containing REACTOR animals
that were tested during this reporting period.

Nr animals tested, in lots
containing reactors

Lots Containing Reactors:
NR Animals Tested

In lots containing REACTOR animals, the total # of animals
present in these lots that were tested during this reporting
period.

3.5

Draft – 1 Dec 2004

Nr reactors, in lots
containing reactors

Lots Containing Reactors:
NR Reactors

In lots containing REACTOR animals, the total # of
REACTOR animals (those showing a swelling of 5
millimeters or greater in diameter during testing).

Nr deviators, in lots
containing reactors

Lots Containing Reactors:
NR Deviators

In lots containing REACTOR animals, the total # of
DEVIATOR animals (those showing a minimal or PP
(pinpoint) response to tuberculin testing).

Nr lots tested, in lots not
containing reactors

Lots with Deviators but no Reactors:
NR Lots Tested

Total # of lots with no REACTOR animals in them that were
tested during this reporting period.

Nr animals tested, in lots
not containing reactors

Lots with Deviators but no Reactors:
NR Animals Tested

In lots containing DEVIATORS but no REACTOR animals,
the total # of animals that were tested during this reporting
period.

Nr suspects, in lots not
containing reactors

Lots with Deviators but no Reactors:
NR Deviators

In lots containing DEVIATORS but no REACTOR animals,
the total # of DEVIATOR animals (those showing a minimal
or PP (pinpoint) response to tuberculin testing).

a. To retrieve a record that you want to view and/or update, insert one or more search values into the
field(s) on this query form.
If you are not sure how to spell a search value, use the per cent symbol (%) wildcard to replace the
letters that you don't know. See the chart below for examples on how to use this wildcard:
To Search For:

Type This:

And Get These Results:

all records whose Test
Reason involves a trace

TK
TR
TE

all records submitted for
the state of Arkansas
(but you don't know the
full code for this state)

AR%

all records for Arkansas
all records for Arizona

(trace from kill)
(trace reactions)
(trace exposed)

Below is an example of a Query_A form with three search values entered (Sp=BOV, Event
Type=TBCF, and Test Reason=T%). Note that the Test Reason search value includes the
wildcard.

b. Execute your query using one of the methods below:
• In the Menu Bar, select the Query > Execute command.
• In the Toolbar, click on the Execute Query icon.

3.6

Draft – 1 Dec 2004

c. Your query may retrieve more than one record. To be sure that you have the record you want,
scroll through all of the retrieved records by doing the following:
i.

Click inside the Event Type field.

ii.

Press the DOWN ARROW key on your computer keyboard. Each time you do so, a new
record will be displayed in the query form. So if your query retrieved four records, you
would need to press the DOWN ARROW key four times to see all of these records, one at
a time.
If you executed the search example shown in the above screen shot, you would have
retrieved every record containing SP=BOV, Event Type=TBCF, and Test Reason= TK or
TR or TE.

iii.

When the record you want is displayed in the form, click on Save. Below is an example of
a retrieved TB6-2 Data-Submission record for Section A:

d. If you want to modify this record, do so following these steps:
i.

Highlight the first value you want to modify.

ii.

Type the new value you want to use.

iii.

Repeat these two steps of highlighting-overtyping for each value you want to change.

iv.

After you have modified all of the values in this record, click on Save.

e. You can now do either of the following:
• If you modified the Data-Submission record for a TB6-2 report section, you now need to
instruct the Auto-Scheduler utility at the AWBDS web site to process this data. Go
directly now to the next section in this chapter, Procedure 2: Using the Auto-Scheduler
to Process Your Updated Data.
• You can exit the AWBDS web site by clicking on the Exit buttons in each webform or
screen.

3.7

Draft – 1 Dec 2004

1.7

If you selected Query_B, you should now see the following form onscreen:

Field Label on
Data-Submission Form

Data Stored in This Field
on Both Forms

Rpt Id

(Not found on D-S Form)

Default=TB62

Sectn

Letter for the related section in the TB6-2 report.

State

Code for the State in which the data-collection activity took place.

Disease

Code for the disease whose data was submitted.

Stg

Stage

Stage level that your State was in during this reporting period.

Species

Code for the animal species whose test results was submitted.

Dt Beg

Begin Date

First date of the time period whose data was submitted.

Dt End

End Date

Last date of the time period whose data was submitted.

Run Dt

Report Run Date

Date on which your State's data was submitted.

Rec Type

(Not found on D-S Form)

Default=B1

Event Type

Code for the test event whose data was submitted.

Test Reason

Code for the reason the animals/lots were tested.

Total nr lots tested

Total Tested:
Total NR Lots Tested

Total # of on-farm animal lots that were tested during this reporting
period.

Total nr animals tested

Total Tested:
Total NR Animals Tested

Total # of individual animals that were tested during this reporting
period.

Nr lots tested, in lots
containing reactors

Lots Containing Reactors:
NR Lots Tested

Total # of on-farm animal lots containing REACTOR animals that were
tested during this reporting period.

Nr animals tested, in lots
containing reactors

Lots Containing Reactors:
NR Animals Tested

In lots containing REACTOR animals, the total # of animals present in
these lots that were tested during this reporting period.

Nr reactors, in lots
containing reactors

Lots Containing Reactors:
NR Reactors

In lots containing REACTOR animals, the total # of REACTOR animals
(those showing a swelling of 5 millimeters or greater in diameter during
testing).

3.8

Draft – 1 Dec 2004

Nr suspects, in lots
containing reactors

Lots Containing Reactors:
NR Suspects

In lots containing REACTOR animals, the total # of SUSPECT animals
(those showing a response to tuberculin testing, but which are not
classified as DEVIATORS or REACTORS).

Nr lots tested, in lots not
containing reactors

Lots with Suspects but no
Reactors:
NR Lots Tested
Lots with Suspects but no
Reactors:
NR Animals Tested
Lots with Suspects but no
Reactors:
NR Suspects

In lots containing SUSPECT but no REACTOR animals, the total # of
lots that were tested during this reporting period.

Nr animals tested, in lots
not containing reactors
Nr suspects, in lots not
containing reactors

In lots containing SUSPECT but no REACTOR animals, the total # of
animals that were tested during this reporting period.
In lots containing DEVIATOR but no REACTOR animals, the total # of
SUSPECT animals (those showing a response to tuberculin testing,
but which are not classified as DEVIATORS or REACTORS).

Type This:

And Get These Results:

all records whose Test
Reason involves a trace

TK
TR
TE

all records submitted for
the state of Arkansas
(but you don't know the
full code for this state)

AR%

all records for Arkansas
all records for Arizona

(trace from kill)
(trace reactions)
(trace exposed)

Below is an example of a Query_B form with three search values entered (Sp=BOV, Event
Type=TBCC, and Test Reason=T%). Note that the Test Reason search value includes the
wildcard.

Click inside the Event Type field.

3.9

Draft – 1 Dec 2004

ii.

iii.

When the record you want is displayed in the form, click on Save. Below is an example of
a retrieved TB6-2 Data-Submission record for Section B:

d. If you want to modify this record, do so following these steps:
i. Highlight the first value you want to modify.
ii. Type the new value you want to use.
iii. Repeat these two steps of highlighting-overtyping for each value you want to change.
iv. After you have modified all of the values in this record, click on Save.
e. You can now do either of the following:
• If you modified the Data-Submission record for a TB6-2 report section, you now need to
instruct the Auto-Scheduler utility at the AWBDS web site to process this data. Go
directly now to the next section in this chapter, Procedure 2: Using the Auto-Scheduler
to Process Your Updated Data.
• You can exit the AWBDS web site by clicking on the Exit buttons in each webform or
screen.

3.10

Draft – 1 Dec 2004

1.8

If you selected Query_C, you should now see the following form onscreen:

Field Label on
Data-Submission Form

Data Stored in This Field
on Both Forms

Rpt Id

(Not found on D-S Form)

Default=TB62

Sectn

Letter for the related section in the TB6-2 report.

State

Code for the State in which the data-collection activity took
place.

Disease

Code for the disease whose data was submitted.

Stg

Stage

Stage level that your State was in during this reporting period.

Species

Code for the animal species whose data was submitted.

Dt Beg

Begin Date

First date of the time period whose data was submitted.

Dt End

End Date

Last date of the time period whose data was submitted.

Run Dt

Report Run Date

Date on which your State's data was submitted.

Rec Type

(Not found on D-S Form)

Default=C1

Event Type

Code for the test event whose data was submitted.

Nr reactors with skin
lesions or NGL

Reactors:
NR reactor NGL or Skin Lesions

Total # of animals classified as REACTORS which have NGL
(No Gross Lesions) or skin lesions.

Nr reactors with internal
lesions

Reactors:
NR Reactors Internal Lesions

Total # of animals classified as REACTORS which have
internal lesions.

Total nr reactors

Total NR Reactors

Total # of animals classified as REACTORS that were tested
during this reporting period.

Nr non reactors with skin
lesions or NGL

Exposed Non-Reactors:
NR Non Reactor NGL or Skin
Lesions

Total # of animals classified as EXPOSED NON-REACTORS
that have NGL (No Gross Lesions) or skin lesions.

3.11

Draft – 1 Dec 2004

Nr non reactrs with skin
lesions or NGL

Exposed Non-Reactors:
NR Non Reactor Internal Lesions

Total # of animals classified as EXPOSED NON-REACTORS
that have internal lesions.

Total nr non reactors

Total Non Reactors

Total # of NON-REACTOR animals that were tested during this
reporting period.

Carcass disposition

Carcass Disposition

Code for the final handling of an animal's carcass.

Type This:

And Get These Results:

all records whose Test
Reason involves a trace

TK
TR
TE

all records submitted for
the state of Arkansas
(but you don't know the
full code for this state)

AR%

all records for Arkansas
all records for Arizona

(trace from kill)
(trace reactions)
(trace exposed)

Below is an example of a Query_C form with three search values entered (Sp=BOV, Event
Type=TBPM, and Carcass disposition=CP%). Note that the Carcass disposition search value
includes the wildcard.

Click inside the Event Type field.

ii.

3.12

Draft – 1 Dec 2004

If you executed the search example shown in the above screen shot, you would have
retrieved every record containing SP=BOV, Event Type=TBPM, and Carcass
disposition= CPF or CPC.
iii.

When the record you want is displayed in the form, click on Save. Below is an example of
a retrieved TB6-2 Data-Submission record for Section C:

d. If you want to modify this record, do so following these steps:
i.

Highlight the first value you want to modify.

ii.

Type the new value you want to use.

iii.

Repeat these two steps of highlighting-overtyping for each value you want to change.

iv.

After you have modified all of the values in this record, click on Save.

3.13

Draft – 1 Dec 2004

Procedure 2:
Using the Auto-Scheduler to Process Your Updated
Data
Now that you have modified the record for a TB6-2 report section, you need to alert the Auto-Scheduler utility that
you have new data for it to process. You accomplish this task by leaving the Data Entry Forms area of the website
to work in the Approval Summary Data area. Follow the instructions below:

2.1

In the Query webform where you just modified the record for a TB6-2 report section, click on Exit.

2.2

The Summary Data Entry Forms main menu (shown at right)
now appears.
In this screen, click on Exit. You have now left the Data Entry
Forms area of the website.

2.3

The National Surveillance Program Reports main menu now
appears.
Click on the Approve Summary Data option. You have now
entered the Approval area of the website.

2.4

The National Surveillance Reports Menu (shown at right) will
appear onscreen.

3.14

Draft – 1 Dec 2004

2.5

Fill out the header block with the appropriate parameters for the TB6-2 report section whose DataSubmission record you just updated.

2.6

In the bottom block of this same menu, click on the [2] next to the TB6-2 National Summary Report
Data option.

2.7

An TB6-2 Approval Forms screen (shown below) now appears.

In the field next to the report section whose record you just modified, click on the down arrow and select
the Re-run the Report option (as shown below). The Re-run… option flags the report section that is to
be re-sent to your State's QA personnel again for review.

3.15

Draft – 1 Dec 2004

2.8

Click on Approve. This action notifies the Auto-Scheduler utility to generate a new report from your
modified Data-Submission record, send PDF copies of the report to the appropriate QA personnel, and
move the report data to the Temporary Holding Database. (If you click on the Approve option without
having the Re-run flag appear next to the appropriate report section, this means that you are approving the
report "as is" and that you consider the report ready to be moved to the permanent National Reports
Database.)

2.9

Even though you modified the record for only one TB6-2 report section, you may still see three popup
messages that describe the actions done by the Auto-Scheduler for all three sections shown on this screen.
Click OK in each popup window to close it.

2.10

At the end of your work session, you can exit the AWBDS web site by clicking on the Exit buttons in each
webform or screen.

3.16

Draft – 1 Dec 2004

Reference Table 1:
Organized by Report Section Letter
The table below allows you to see all of the data field labels for a single section within the TB62 report at a single glance.
Section A

Section B

Section C

On-Farm TBCF Test Reporting

On-farm TBCC Test Reporting

Postmortem Results from
Slaughter

Test reason

---

Total nr lots tested

Nr reactors with skin lesions or NGL

Total nr animals tested

Nr reactors with internal lesions

Nr lots tested, in lots that contain
reactors

Total nr reactors

D10

Nr animals tested, in lots that contain
reactors

Nr non-reactors with skin lesions or
NGL

D12

Nr reactors, in lots that contain
reactors

Nr non-reactors with internal lesions

D14

---

Nr suspects, in lots that contain
reactors

Total nr non-reactors

D16

Nr deviators, in lots that contain
reactors

---

D18

Nr lots tested, in lots that do not
contain reactors

---

D20

Nr animals tested, in lots that do not
contain reactors

---

D22

---

Nr suspects, in lots that do not
contain reactors

---

D24

Nr deviators, in lots that do not
contain reactors

---

D26

Event type

D28

---

Carcass disposition

3.17

Draft – 1 Dec 2004

Reference Table 2:
Organized by Data Field Label
The table below allows you to determine what a specific data field label is, depending on which
section in the TB6-2 report you see that label.
Field D2:

Section A:
Section B:
Section C:

Test reason
Test reason
---

Field D4:

Section A:
Section B:
Section C:

Total nr lots tested
Total nr lots tested
Nr reactors with skin lesions or NGL

Field D6:

Section A:
Section B:
Section C:

Total nr animals tested
Total nr animals tested
Nr reactors with internal lesions

Field D8:

Section A:
Section B:
Section C:

Nr lots tested, in lots that contain reactors
Nr lots tested, in lots that contain reactors
Total nr reactors

Field D10:

Section A:
Section B:
Section C:

Nr animals tested, in lots that contain reactors
Nr animals tested, in lots that contain reactors
Nr non-reactors with skin lesions or NGL

Field D12:

Section A:
Section B:
Section C:

Nr reactors, in lots that contain reactors
Nr reactors, in lots that contain reactors
Nr non-reactors with internal lesions

Field D14:

Section A:
Section B:
Section C:

--Nr suspects, in lots that contain reactors
Total nr non-reactors

Field D16:

Section A:
Section B:
Section C:

Nr deviators, in lots that contain reactors
-----

Field D18:

Section A:
Section B:
Section C:

Nr lots tested, in lots that do not contain reactors
Nr lots tested, in lots that do not contain reactors
---

Field D20:

Section A:
Section B:
Section C:

Nr animals tested, in lots that do not contain reactors
Nr animals tested, in lots that do not contain reactors
---

Field D22:

Section A:
Section B:
Section C:

--Nr suspects, in lots that do not contain reactors
---

Field D24:

Section A:
Section B:
Section C:

Nr deviators, in lots that do not contain reactors
-----

Field D26:

Section A:
Section B:
Section C:

Event type
Event type
Event type

Field D28:

Section A:
Section B:
Section C:

----Carcass disposition

3.18

Chapter 4:
Approving Your State's TB6-2 Data
In this task, you will learn how to approve, reject, and delete your State's data for a TB6-2 National
Report.
Unit

Topic

See Page

Procedure 1:

Approving/Rejecting a State's TB6-2 Data-Submission
(This procedure can be done only by authorized Quality Control (QC) personnel
for your State.)

4.2

Procedure 2:

Viewing an Existing, Not-Yet-Approved TB6-2 Data-Submission

4.6

Procedure 3:

Deleting an Existing, Not-Yet-Approved TB6-2 Data-Submission

4.11

4.1

Draft – 1 Dec 2004

Procedure 1:
Approving/Rejecting a State's TB6-2 Data-Submission
This procedure can be performed only by a State's authorized Quality Control (QC) personnel.

1.1

Log into the Automated Web-Based Data Submission (AWBDS) web site.
A Warning screen will appear onscreen.

1.2

Click on the Accept button.
The Veterinary Services National Surveillance Program Reports main screen (shown below) will
appear.

1.3

Click on the Approve Summary Data option.

4.2

Draft – 1 Dec 2004

1.4

The National Surveillance Reports Menu screen (shown below) will appear:

In the top block of this form, enter the parameters that identify the specific report whose section(s) you
want to record your approval/disapproval.
Field

Guidelines

Approver's
Oracle User
Name

User name that you use to log into the AWBDS web site.

State

Two-letter postal abbreviation for the state in which the data collection activity took place.
Click on the down arrow button to display a List of Values for this field.

Disease
Program

Code for the animal disease program whose test results are being reported on this form.
Click on the L button to display a List of Values for this field.

Species

Code for the animal species whose test results are being reported on this form.
Click on the down arrow button to display a List of Values for this field.

Report Begin
Date

Report Run Date

When completed, the top block should look similar to this example:

4.3

Draft – 1 Dec 2004

1.5

In the bottom block of this form, click on the 1. TB6-2 Tuberculosis National Summary Report Data
option.
A TB Approval Forms screen will now appear:

a. Note that the report parameters (such as its Species, Begin Date, and End Date parameters) which
you specified back in Step 1.4 will apply to every report section listed on this screen.
Keep in mind, however, that you can approve/disapprove only those sections for which you have
signoff authority. (As an example, the State of Florida might have one QC representative, John
Smith, who has signoff authority for Section A and Section B, and a second QC representative,
Cindy Nelson, who has signoff authority for Section C only. John Smith cannot
approve/disapprove Section C, and Cindy Nelson cannot approve/disapprove Sections A-B.)
b. For each section, you must click on the down arrow button and select a value from the displayed
List of Values. The choices are described below:
Option

Meaning

Y–
Report Approved

As your State's QC representative with signoff authority, you approve the data
submitted for this report section to be complete and accurate.

N–
Report Not Approved

Choose this option for either reason below:
-- As your State's QC representative with signoff authority, you do not approve the
data submitted for this report, as you have determined some or all of the data
to contain errors/omissions.
-- You do not have signoff authority for this specific report.

R–
Re-run the Report

Enables you to run a new version of the TB6-2 National Program Report.
This option is helpful, especially in situations where an initial Data-Submission from
a State had to be corrected and re-submitted for approval. Once the second,
corrected submission has been approved, this option can be used to generate a
new TB6-2 National Program Report whose data will be accurate.
This option is described in more detail in the following chapters of this manual:
Chapter 3 – Updating Your State's Data for a TB6-2 National Program Report
Chapter 7 – Updating Your State's Data for a PRV-190 National Program Report
Chapter 11 – Updating Your State's Data for an SPP National Program Report

4.4

Draft – 1 Dec 2004

c. Once you have indicated your approval/rejection for each section for which you have signoff
authority, click on the Approve command button.
d. A popup window like the one shown below will appear for each report section for which your
approval has been successfully recorded. Click OK to close each popup window.

e. After you have submitted your approval for each TB6-2 section for which you have signoff
authority, click on the Exit command button.
You are returned to the National Surveillance Reports Menu screen.

4.5

Draft – 1 Dec 2004

Procedure 2:
Viewing an Existing, Not-Yet-Approved
TB6-2 Data-Submission
This procedure enables you to query for and retrieve one or more existing TB6-2 Data-Submission records that are
currently being stored in the Temporary Holding Database.
You may wish to query for a record to see if it has already been submitted, or to see if it has been approved/signed
off by your State's QC personnel.

2.1

Log into the Automated Web-Based Data Submission (AWBDS) web site. (If necessary, refer back to
Task 1 for the procedure on how to do this.)
A Warning screen will appear onscreen.

2.2

Click on the Accept button.
The Veterinary Services National Surveillance Program Reports main screen (shown below) will
appear.

2.3

Click on the Approve Summary Data option.

4.6

Draft – 1 Dec 2004

2.4

The National Surveillance Reports Menu screen (shown below) will appear:

In the top block of this form, enter the parameters that identify the specific report whose section(s) you
want to view.
Field

Guidelines

Approver's
Oracle User
Name

User name that you use to log into the AWBDS web site.

State

Two-letter postal abbreviation for the state in which the data collection activity took place.
Click on the down arrow button to display a List of Values for this field.

Disease
Program

Code for the animal disease program whose test results are being reported on this form.
Click on the L button to display a List of Values for this field.

Species

Code for the animal species whose test results are being reported on this form.
Click on the down arrow button to display a List of Values for this field.

Report Begin
Date

Report Run Date

When completed, the top block should look similar to this example:

4.7

Draft – 1 Dec 2004

A TB Approval Forms screen will now appear.

2.6

To determine if a report section has already been submitted, approved, or rejected, click on the Already
Approved Report button. The following query screen will appear:

2.7

You will use this screen to enter a query. This query is then sent to the Temporary Holding Database to
find any Data-Submission records that might match it.
To enter a query, do the following:
a. Either select the Query > Enter command in the Menu Bar or click on the Enter Query icon in the
Toolbar.
b. In the query form, fill out as many fields as possible. The more fields you fill out, the faster the
search can be executed.

4.8

Draft – 1 Dec 2004

If you are not sure how to spell a particular value, you can type a % (per cent) wildcard variable to
represent the alphanumeric characters you don't know. The table below shows you how to use this
wildcard variable to get the most precise results:
To Search For:
the last names of all approvers
that include the letters STON
all States that start with A
all job IDs that end with AD44

Type This:

To Get These Results:

%STON%

Halstone

Charleston

Alabama
Arizona

Alaska
Arkansas

AD44

300AD44

%AD44

The example below shows the wildcard variable that was entered in the Approver User Name
field.

c. Either select the Query > Execute command in the Menu Bar or click on the Execute Query icon
in the Toolbar.
If any Data-Submission records in the Temporary Holding Database match your query, the
parameters for these reports will be displayed in the Query screen. The example below shows one
of several records that were retrieved for the query shown in the screen shot directly above this
paragraph.

4.9

Draft – 1 Dec 2004

d. Note that your query parameters may match and retrieve several records from the Temporary
Holding Database.
If so, you can view each report, one at a time, within the same Query screen. You move forward
and backwards through the set of retrieved records by using the UP ARROW and DOWN ARROW
keys on your computer keyboard. The instructions below to do this:
i.

Click your cursor inside any field (Record Create Date for example).

ii. Click the DOWN ARROW key on your computer keyboard. Each time you click this
key, a new report will be displayed in the Query screen.
iii. When you reach the last report that was retrieved, a popup message will alert you to this.
iv. You can now click the UP ARROW key to move back through the set of retrieved
records. When you reach the first report that was retrieved, the data in the Query screen
will stop changing.
2.8

To end your work session, you can exit the ASBDS web site by clicking on the Exit buttons in each
webform or screen.

4.10

Draft – 1 Dec 2004

Procedure 3:
Deleting an Existing, Not-Yet-Approved
TB6-2 Data-Submission
This procedure enables you to query for and delete an existing TB6-2 Data-Submission record that is currently
being stored in the Temporary Holding Database.

3.1

Log into the Automated Web-Based Data Submission (AWBDS) web site. (If necessary, refer back to
Task 1 for the procedure on how to do this.)
A Warning screen will appear onscreen.

3.2

Click on the Accept button.
The Veterinary Services National Surveillance Program Reports main screen (shown below) will
appear.

3.3

Click on the Approve Summary Data option.

4.11

Draft – 1 Dec 2004

3.4

The National Surveillance Reports Menu screen (shown below) will appear:

In the top block of this form, enter the parameters that identify the specific report whose section(s) you
want to delete.
Field

Guidelines

Approver's
Oracle User
Name

User name that you use to log into the AWBDS web site.

State

Two-letter postal abbreviation for the state in which the data collection activity took place.
Click on the down arrow button to display a List of Values for this field.

Disease
Program

Code for the animal disease program whose test results are being reported on this form.
Click on the L button to display a List of Values for this field.

Species

Code for the animal species whose test results are being reported on this form.
Click on the down arrow button to display a List of Values for this field.

Report Begin
Date

Report Run Date

When completed, the top block should look similar to this example:

4.12

Draft – 1 Dec 2004

3.5

In the bottom block of this form, click on the 1. TB6-2 Tuberculosis National Summary Report Data
option.
A TB Approval Forms screen will now appear.

3.6

Click on the Already Approved Report button. The following query screen will appear:

3.7

4.13

Draft – 1 Dec 2004

Type This:

To Get These Results:

%STON%

Halstone

Charleston

Alabama
Arizona

Alaska
Arkansas

AD44

300AD44

%AD44

The example below shows the wildcard variable that was entered in the Approver User Name
field.

4.14

Draft – 1 Dec 2004

d. Note that your query parameters may match and retrieve several records from the Temporary
Holding Database. So, you need to make sure the record you want to delete is displayed onscreen
within the Query form.
i.

Click your cursor inside any field (Record Create Date for example).

ii. Click the DOWN ARROW key on your computer keyboard. Each time you click this
key, a new report will be displayed in the Query screen.
iii. When you find the record you want to delete, leave it visible onscreen.
iv. Either select the Record > Remove command in the Menu Bar or click on the Remove
Record icon in the Toolbar.
The record has now been deleted from the Temporary Holding Database.
3.8

To end your work session, you can exit the ASBDS web site by clicking on the Exit buttons in each
webform or screen.

4.15

Draft – 1 Dec 2004

4.16

Chapter 5:
Running a TB6-2 National Report
In this task, you will learn how to run a new TB6-2 National Report, which should include the most
recent, approved TB6-2 Data-Submission records from your State. This report is being produced from
the permanent report tables and can be run only after the report has been approved and its data transferred
from the Temporary Holding Database to the National Reports Database.

5.1

Draft – 1 Dec 2004

Procedure for Running a New TB6-2 National Report:
1.1

Log into the Automated Web-Based Data Submission (AWBDS) web site.

1.2

A Warning screen will appear onscreen.
Click on the Accept button.

1.3

Veterinary Services National Surveillance Program
Reports main screen (shown at right) will appear.
In this screen, click on the Run Program Reports option.

1.4

The Summary Reports by Section screen (shown at right)
will appear:
In this screen, select the [1] button next to the
TB6-2 Tuberculosis option.

1.5

A TB6-2 Summary Reports by Section screen (shown at
right) will now appear:

…The remainder of this procedure will be written after code
development for this feature has been completed…

5.2

Chapter 6:
Submitting Your State's Data for a
PRV-190 National Report
This chapter is for those States "not using" the GDB to enter their Pseudorabies surveillance data. It covers the
procedures for using, completing, and submitting your State's monthly Pseudorabies eradication summary data,
using the AWBDS PRV-190 Data-Submission webform. The topics in this chapter appear below:
Topic

See
Page

Information Needed to Enter into the PRV-190 Data-Submission Webform

6.2

Requirements on Using the PRV-190 Data-Submission Webform

6.2

Procedure for Completing the PRV-190 Data-Submission Webform

6.3

6.1

Draft – 1 Dec 2004

Information Needed to Enter into the PRV-190
Data-Submission Webform
To do this procedure, you need to have available the summary data from your State's PRV-190 monthly report
regarding Pseudorabies (PRV) eradication activities. This summary data may be compiled from your State's
Pseudorabies program data collection documents or from other sources.

Requirements on Using the PRV-190 Data-Submission
Webform
The PRV-190 Data-Submission webform has five tabbed pages on it -- one tabbed page for each of the five sections
(A, B, C, E, and F) that make up the VS PRV-190 National Report. You must complete all five tabbed pages on the
PRV-190 Data-Submission webform, even if you have no data this month to enter on one or more of its pages.
Example: For this month , your State
• does have herd status data to submit – you would enter this data on the Section A tabbed page of the webform.
• does have market/slaughter surveillance data to submit – you would enter this data on the Section B tabbed
page of the webform.
• does not have any results regarding traceback of market/slaughter surveillance positives to submit -- you
would enter the number 0 (zero) in each data field on the Section C tabbed page of the webform.
• does not have data regarding the source of infection in new herds to submit – you would enter the number 0
(zero) in each data field on the Section E tabbed page of the webform.
• does have summary data regarding on farm testing results to submit – you would enter this data on the
Section F tabbed page of the webform.

6.2

Draft – 1 Dec 2004

Procedure for Completing the PRV-190
Data-Submission Webform
This procedure describes how to fill out all five sections (A, B, C, E, and F) of the PRV-190 Data-Submission
webform during a single work session. However, if you cannot complete all five sections of the webform during a
single work session, you can work on each section individually. But keep in mind that this approach will require
you to keep track of the data you entered into the Report Parameters block (the top block on the webform) – some
fields in this block must contain the same data regardless of which section you are currently working in.
To Work On:

Do These Steps Of This Procedure:

Sections A, B, C, E, and F
Section A only
Section B only
Section C only
Section E only
Section F only

Step 1.1 through Step 1.11
Step 1.1 through Step 1.6
Step 1.1 through Step 1.5, then Step 1.7
Step 1.1 through Step 1.5, then Step 1.8
Step 1.1 through Step 1.5, then Step 1.9
Step 1.1 through Step 1.5, then Step 1.10

1.1

If necessary, log into the AWBDS web site.

1.2

The Veterinary Services National Surveillance Program
Reports main menu screen (shown at right) will appear.
In this screen, click on the Enter Summary Data option.

1.3

The National Reports Summary Data Entry Forms main menu
screen (shown at right) now appears.
In this screen, click on the [2] button next to the PRV-190
Pseudorabies option.

6.3

Draft – 1 Dec 2004

1.4

A blank PRV 190 Information Data-Submission webform will appear.
Menu Bar
Toolbar
Report Parameters
Block
Report Section
Tabs

Report Data
Block

Command Buttons

6.4

Draft – 1 Dec 2004

1.5

Fill out the top block of the webform according to the guidelines in the following table. To move from one
field to the next field, press the TAB or ENTER key.

Field

Guidelines

Report Section Letter

Letter of the section in the PRV-190 report for which you are submitting your data.
Click on the L button to display a List of Values for this field. The choices are:
A
Herd status
B
Market/slaughter surveillance data
C
Traceback of market/slaughter surveillance positives
E
Source of infection of new herds
F
Summary of on-farm testing results
Query (See Chapter 7 for instructions on how to use this feature for PRV-190.)
As soon as you select a value for this field and press TAB or ENTER, the bottom block of the
webform will refresh and display only the tabbed page for the Report Section Letter you just
selected.

State

Enter the two-letter postal abbreviation (such as WY) for the state in which the data collection
activity took place.

Stage

Code for the stage level of your State for which the national report is being prepared.
Click on the L button to display a List of Values for this field. The choices are:
1
Preparation
2
Control
3
Mandatory herd cleanup
4
Surveillance
5
Free

Begin Date

End Date

Report Run Date

Automatically populated with today's date the first time you execute the "Save" command. (You
can wait to do this after you start working in the form's bottom block.)

6.5

Draft – 1 Dec 2004

1.6

The tabbed page labeled Section A should be displayed onscreen.

.
The table below describes what kind of data you will enter into the fields on this page.
Field

Guidelines

Report Line Number

The line number in the PRV-190 report in which your data will appear.
Click on the L button to display a List of Values for this field. The choices are:
1.
Begin quarter
2a.
New herds added during quarter
2b.
Previous infected herd
3a.
Removed during quarter
3b.
Statistical sampling
4.
At end of quarter
Note: Each line in Section A is related to a time frame relative to the reporting period (at the
beginning, during, or at the end). Therefore, the numbers you enter relate to the # of herds in
the chosen status relative to that time frame.

NR Infected Herds

Total # of infected herds during this report period.

NR FPM Herds

Total # of Pseudorabies-Monitored-Feeder-Pig (FPM) herds.

NR Animals in Herds

Total # of all animals in all herds.

NR QNV Herds

Total # of Qualified-Negative Vaccinated (QNV) herds.

NR QN Herds

Total # of Qualified Pseudorabies-Negative (QN) herds.

NR CLP Herds

Total # of herds under a cleanup plan.

a. In the Report Line Number data field, select 1. Begin quarter in the List of Values.
b. Fill out the rest of the fields on this page with the appropriate data from your paper forms that
pertain to the 1. Begin quarter report line number. If you have no data to enter into a specific field,
enter 0 (zero) instead.
c. Click on either the Save command button at the bottom of the webform or the Save icon in the
Toolbar. Doing this immediately saves all of the data you just entered for the 1. Begin quarter
line number.
d. Click on the New Line for Section command button.
e. In the Report Line Number data field, select the next choice in the List of Values. (The first time
you do this procedure, the next choice would be 2a. New herds added during quarter).

6.6

Draft – 1 Dec 2004

f. Fill out all of the fields with the data from your paper forms for this line number (or with zeros if
you have no data for individual fields).
g. Click on either the Save command button or the Save icon.
h. Click on the New Line for Section command button.
i. Repeat Steps 1.6e through 1.6h for each choice shown in the List of Values for the Report Line
Number field.
j. After you have saved the data for the final Report Line Number choice, you can do either action
below.
• Set up the PRV-190 Data-Submission webform to begin entering your State's data for
Section B:
i. Return to the top block of the webform. In the Report Section Letter data field, select
the B–MARKET SLAUGHTER SURVEILLANCE DATA choice from the List of
Values.
ii. Change the Begin Date and End Date values, if necessary.
iii. Continue with Step 1.7 below.
• Exit the PRV-190 Data-Submission webform by clicking on either the Exit command button at
the bottom of the webform or the Exit icon in the Toolbar.

6.7

Draft – 1 Dec 2004

1.7

The tabbed page labeled Section B should be displayed onscreen.

Fill out the fields on this page according to the guidelines shown in the table below:
Field

Guidelines

Prem Type

Code for the premises type whose data you are entering into this
section of the report.
Click on the L button to display a List of Values for this field. The
choices are:
SL
Slaughter Establishment
FP
First Point

NR instate samples, collected instate, barrows/gilts
Totals
NR Positive

Enter the total # of blood samples collected from this group.
Enter the # of positive samples collected from this group.

NR instate samples, collected instate, sows/boars
Totals
NR Positive

Enter the total # of blood samples collected from this group.
Enter the # of PRV-positive samples collected from this group.

NR out of state samples, collected instate, barrows/gilts
Totals
NR Positive

Enter the total # of blood samples collected from this group.
Enter the # of PRV-positive samples collected from this group.

NR out of state samples, collected instate, sows/boars
Totals
NR Positive

Enter the total # of blood samples collected from this group.
Enter the # of PRV-positive samples collected from this group.

NR instate samples, collected out of state, barrows/gilts
Totals
NR Positive

Enter the total # of blood samples collected from this group.
Enter the # of PRV-positive samples collected from this group.

NR instate samples, collected out of state, sows/boars
Totals
NR Positive

Enter the total # of blood samples collected from this group.
Enter the # of PRV-positive samples collected from this group.

a. In the Prem Type data field, select SL-SLAUGHTER ESTABLISHMENT in the List of Values.
b. Fill out the rest of the fields on this page with the appropriate data from your paper forms that
pertain to the SL choice. If you have no data to enter into a specific field, enter 0 (zero) instead.
c. Click on either the Save command button at the bottom of the webform or the Save icon in the
Toolbar. Doing this immediately saves all of the data you just entered for the SL choice.
d. Click on the New Line for Section command button.
e. In the Prem Type data field, select FP-First Point in the List of Values.

6.8

Draft – 1 Dec 2004

f. Fill out all of the fields with the data from your paper forms for the FP choice. If you have no data
to enter into a specific field, enter 0 (zero) instead.
g. Click on either the Save command button or the Save icon.
h. Do either action below.
• Set up the PRV-190 Data-Submission webform to begin entering your State's data for
Section C:
i. Return to the top block of the form. In the Report Section Letter data field, select the
C–TRACEBACK OF MARKET/SLAUGHTER SURVEILLANCE POSITIVES
choice from the List of Values.
ii. Change the Begin Date and End Date values, if necessary.
iii. Continue with Step 1.8 below.
• Exit the PRV-190 Data-Submission webform by clicking on either the Exit command button at
the bottom of the webform or the Exit icon in the Toolbar.

6.9

Draft – 1 Dec 2004

1.8

The tabbed page labeled Section C should be displayed onscreen.

Fill out the fields on this page according to the guidelines shown in the table below. Note: All numbers
entered into the following fields relate to testing or to traces that were closed during the reporting period.
Field

Guidelines

Prem Type

Code for the premises type whose data you are entering into this section of the report.
Click on the L button to display a List of Values for this field. The choices are:
SL
Slaughter Establishment
FP
First Point

NR Total Traces

Enter the total # of samples classified as POSITIVE from market (MKT) or slaughter (SL) testing.

NR TNR

Enter the # of market/slaughter traces that were closed as NOT REQUIRED.

NR TRH

Enter the # of market/slaughter traces that were closed as TRACED TO HERDS KNOWN TO BE
INFECTED.

NR TTR

Enter the # of market/slaughter traces that were closed as TRACED AND A HERD TEST IS
REQUIRED.

NR TTN

Enter the # of market/slaughter traces that were closed as TRACED AND A HERD TEST IS NOT
REQUIRED.

NR TSH

Enter the # of market/slaughter traces that were closed as TRACED TO SOLDOUT HERDS.

NR TOS

Enter the # of market/slaughter traces that were closed as TRACED TO ANOTHER STATE.

NR UT

Enter the # of market/slaughter traces that were closed as UNABLE TO TRACE.

NR Pending

Enter the # of market/slaughter traces that were in progress at the end of the reporting period.

6.10

Draft – 1 Dec 2004

g. Click on either the Save command button or the Save icon.
h. Do either action below.
• Set up the PRV-190 Data-Submission webform to begin entering your State's data for Section
E:
i. Return to the top block of the form. In the Report Section Letter data field, select the
E–SOURCE OF INFECTION OF NEW HERDS choice from the List of Values.
ii. Change the Begin Date and End Date values, if necessary.
iii. Continue with Step 1.9 below.
• Exit the PRV-190 Data-Submission webform by clicking on either the Exit command button at
the bottom of the webform or the Exit icon in the Toolbar.

6.11

Draft – 1 Dec 2004

1.9

The tabbed page labeled Section E should be displayed onscreen.

Fill out the fields on this page according to the guidelines shown in the table below. Each number you
enter into a data field relates to affected herds disclosed during the report period:
Field

Guidelines

NR Purchased Feeders

Enter the # of affected herds for which the source of infection was purchased feeder
animals.

NR Purchased Breeders

Enter the # of affected herds for which the source of infection was purchased breeder
animals.

NR Feral Swine

Enter the # of affected herds for which the source of infection was feral swine animals.

NR Feed / Bedding

Enter the # of affected herds for which the source of infection was feed or bedding.

NR Area Spread

Enter the # of affected herds for which the source of infection was area spread.

NR Infected Carcasses

Enter the # of affected herds for which the source of infection was infected carcasses.

NR Herd Divided

Enter the total # of affected herds created by separating infected animals from
non-infected animals to make two herds.

NR Unknown

Enter the # of affected herds for which the source of infection was unknown.

a. Fill out the fields on this page with the appropriate data from your paper forms. If you have no data
for a specific field, enter 0 (zero) instead.
b. Click on either the Save command button at the bottom of the webform or the Save icon in the
Toolbar. Doing this immediately saves all of the data you just entered.
c. Do either action below.
• Set up the PRV-190 Data-Submission webform to begin entering your State's data for Section
F:
i. Return to the top block of the form. In the Report Section Letter data field, select the
F–SUMMARY OF ON FARM TESTING RESULTS choice from the List of
Values.
ii. Change the Begin Date and End Date values, if necessary.
iii. Continue with Step 1.10 below.
• Exit the PRV-190 Data-Submission webform by clicking on either the Exit command button at
the bottom of the webform or the Exit icon in the Toolbar.

6.12

Draft – 1 Dec 2004

1.10

The tabbed page labeled Section F should be displayed onscreen.

Fill out the fields on this page according to the guidelines shown in the table below:
Field

Guidelines

Test Reason

Code for the reason the animal(s) or animal lot(s) were tested.
Click on the L button to display a List of Values for this field. The choices are:
ARE
Area
SLT
Slaughter Trace
FPT
First Point/Market Trace
ESR
Move from Infected Herd
EPA
Move to Infected Herd
CTI
Circle Test Around Infected Herd
EPI
Other Epi Testing

If Test Reason is 'ARE' check
BOX here

If you entered ARE in the Test Reason field, be sure to click in this box so that a
check mark appears in it.
When you check this box, a Herd Type data field (described in the third row of this
table) will appear in the form.

Herd Type

Code for the type of herd that was tested.
Click on the L button to display a List of Values for this field. The choices are:
BRD
Breeding
GF
Grower Finisher

The two fields directly below relate to herds in which testing occurred, but in which no POSITIVE animals were found
during the report period.
NR herds tested, no infection

Enter the # of herds that were tested for PRV and in which no infection was found.

NR animals tested, no infection

Enter the # of animals that were tested for PRV and in which no infection was found.

The three fields directly below relate to herds in which testing occurred, and in which at least one POSITIVE animal was
found during the report period.
NR herds tested, infection
found

Enter the # of herds that were tested for PRV and in which infection was found.

NR animals tested, infection
found

Enter the # of animals that were tested for PRV and in which infection was found.

NR animals positive

Enter the # of PRV-POSITIVE animals.

6.13

Draft – 1 Dec 2004

The two fields directly below are standalone fields.
Total herds tested

Enter the total # of herds that were tested for PRV in herds with no infection found
and in herds with infection found.

Total animals tested

Enter the total # of animals that were tested for PRV in herds with no infection found
and in herds with infection found.

a. In the Test Reason data field, select ARE-AREA in the List of Values.
i. Click in the checkbox beneath the prompt, If Test Reason is 'ARE' check BOX here.
A check mark must appear in this checkbox. As soon as you do so, a new data field
labeled Herd Type will appear on the electronic form.
ii. In the Herd Type data field, select the BRD choice from the List of Values.
iii. Fill out the rest of the fields on this page with the appropriate data from your paper forms
that pertain to the ARE-BRD combination. If you have no data to enter into a specific
field, enter 0 (zero) instead.
iv. Click on either the Save command button at the bottom of the webform or the Save icon
in the Toolbar. Doing this immediately saves all of the data you just entered for the
ARE-BRD combination.
b. Click on the New Line for Section command button.
c. In the Test Reason data field, select ARE-AREA again.
i. Click in the checkbox beneath the prompt, If Test Reason is 'ARE' check BOX here.
When you do so, the data field labeled Herd Type data field will re-appear.
ii. In the Herd Type data field, select the GF choice from the List of Values.
iii. Fill out the rest of the fields on this page with the appropriate data from your paper forms
that pertain to the ARE-GF combination. If you have no data to enter into a specific
field, enter 0 (zero) instead.
iv. Click on either the Save command button or the Save icon.
d. Click on the New Line for Section command button.
e. In the Test Reason data field, select the next choice in the List of Values (for this sub-step, it would
be FPM-Feeder Pig Monitoring).
i. Fill out all of the fields with the data from your paper forms for this third choice (or with
zeros if you have no data for individual fields).
ii. Click on either the Save command button or the Save icon.
f. Click on the New Line for Section command button.
g. Repeat Steps 1.10e through 1.10f for each choice shown in the List of Values for the Test Reason
field.

1.11

To end this work session, exit the PRV-190 Data-Submission webform by clicking on the Exit button at
the bottom of the webform or the Exit icon in the Toolbar.
Your PRV data-submission work for this month will be finished after you have completed Sections A, B,
C, E, and F on the PRV-190 Data-Submission webform (either during a single work session or several
sessions).

6.14

Chapter 7:
Updating Your State's Data for a
PRV-190 National Report
This chapter covers the procedures for updating your State's Pseudorabies disease program data, using a set of
customized PRV-190 Query webforms available at the AWBDS web site.
You can perform these procedures as long as the Quality Control (QC) person for your State has not yet approved
your State's monthly Pseudorabies summary data.
The topics in this chapter appear below:
Topic

See Page

Introduction
When Not to Update Your PRV-190 Data

7.2
7.2

Procedure 1: Updating Your State's Data, by Using the PRV-190 Query Webforms

7.3

Procedure 2: Using the Auto-Scheduler to Process Your Updated Data

7.21

Reference Table 1: Organized by Report Section Letter

7.24

Reference Table 2: Organized by Data Field Labels

7.26

7.1

Draft – 1 Dec 2004

Introduction
The AWBDS process allows you to modify, if necessary, the data you have submitted for your State's Pseudorabies
program. You accomplish this by filling out a customized PRV-190 Query webform. There are five of these
customized Query webforms, one for each of the five sections in the PRV-190 report. The values you enter on a
Query webform will be used to find any PRV-190 Data-Submission records that are stored in a Temporary Holding
Database. If any PRV-190 Data-Submission records in the database match the values on your Query webform,
these records are retrieved and displayed onscreen, one at a time, within the Query webform. You can view, print,
and modify these records right there within the Query webform itself.
You can query for, retrieve, and modify your State's PRV-190 Data-Submission records at any time, as long as the
data has not yet been approved by your State's QC personnel. Once a QC representative approves any of your
State's PRV-190 Data-Submission records, the data is moved from the Temporary Holding Database to a permanent
National Reports Database. After this move occurs, the data can no longer be retrieved for the purposes of
modifying it.
The procedure on the next page will show you how to use the PRV-190 Query webforms.

When Not to Update Your PRV-190 Data
In Chapter 1, you learned that the Auto-Scheduler utility is pre-programmed to routinely do its three tasks on the 5th
day of every month. If by this date, your State:
• has finished submitting its program data for the previous month/quarter, the Auto-Scheduler will generate the
appropriate reports, e-mail them to QA personnel, and transfer the data to the Temporary Holding Database.
• has not finished/finished submitting its program data, the Auto-Scheduler will still generate, e-mail, and
transfer the appropriate reports, but these reports will be null (containing only zeros).
To avoid potential processing and data errors, do not attempt to update a null PRV-190 report. Instead, you should
delete it (see Chapter 8) and submit your data again in a new Data-Submission webform (see Chapter 6).
The reason you should not try to do this kind of update is that, for a null report the Auto-Scheduler creates only one
Line or Prem Type in a report section, with all zeroes. For example, your State has PRV-190 data for three different
Prem Types in Section C, but the data did not get entered before the 5th deadline. The Auto-Scheduler will create a
Section C report with null values for just one of those Prem Types. Several days later, you try to use a Query
webform to correct the null data in this report as well as add new data for the other two Prem Types. You could
update one Prem Type – but the system will not allow you to enter the additional Prem Types except in the DataSubmission webform. It will be easier and safer to just delete the null report file and to enter all the data for the
report section at one time in a new Data-Submission webform.

7.2

Draft – 1 Dec 2004

Procedure 1:
Updating Your State's Data, by Using the PRV-190
Query Webforms
This procedure describes how to use the five customized PRV-190 Query webforms to retrieve data, modify it, and
save it back into the Temporary Holding Database.

1.1

If necessary, log into the AWBDS web site.

1.2

The Veterinary Services National Surveillance Program
Reports main menu screen (shown at right) will appear.
In this screen, click on the Enter Summary Data option.

1.3

The National Reports Summary Data Entry Forms main menu
screen (shown at right) now appears.
In this screen, click on the [2] button next to the PRV-190
Pseudorabies option.

7.3

Draft – 1 Dec 2004

1.4

A blank PRV190 Information Data-Submission webform will appear.

1.5

In the Report Section Letter field in the top block, do the following:
a. Click on the L to display a List of Values. In this list, you will see three query form choices:
Query
Webform

Use This Form to Retrieve Data-Submission Records Containing
Data on:

Query_A
Query_B
Query_C
Query_E
Query_F

Herd status
Market/slaughter surveillance
Traceback investigations done on market/slaughter PRV-positive animals
Probable sources of infection in new herds
Test results for cattle that were tested on farms and ranches

Go directly to Step 1.6 in this procedure.
Go directly to Step 1.7 in this procedure.
Go directly to Step 1.8 in this procedure.
Go directly to Step 1.9 in this procedure.
Go directly to Step 1.10 in this procedure.

7.4

Draft – 1 Dec 2004

1.6

If you selected Query_A, you should now see the following Query webform onscreen. This webform has
been customized for Section A of the PRV-190 report:

Field Label on
Data-Submission Form

Data Stored in This Field
on Both Forms

Rpt Id

(Not found on D-S Form)

Sectn

Report Section Letter

Default=A

State

Code for the State in which the data-collection activity took place.

Default=PRV190

Disease

Code for the disease whose data was submitted.

Stg

Stage

Stage level that your State was in during this reporting period.

Species

Code for the animal species whose test results was submitted.

Dt Beg

Begin Date

First date of the time period whose data was submitted.

Dt End

End Date

Last date of the time period whose data was submitted.

Run Dt

Report Run Date

Date on which your State's data was submitted.

Rec Type

(Not found on D-S Form)

Default=WEB

Line nr

Report Line Number

The line number in the PRV-190 report in which the data appears.
Note: Each line in Section A is related to a time frame relative to the reporting
period (at the beginning, during, or at the end). Therefore, the numbers you
enter relate to the # of herds in the chosen status relative to that time frame.

Nr infected herds

NR Infected Herds

Total # of infected herds during this reporting period.

Nr animals in herds

NR Animals in Herds

Total # of all animals in all herds.

Nr QN herds

NR QN Herds

Total # of Qualified Pseudorabies-Negative (QN) herds.

Nr FPM herds

NR FPM Herds

Total # of Pseudorabies-Monitored-Feeder-Pig (FPM) herds.

Nr QNV herds

NR QNV Herds

Total # of Qualified-Negative Vaccinated (QNV) herds.

Nr CLP herds

NR CLP Herds

Total # of herds under a cleanup plan (CLP).

7.5

Draft – 1 Dec 2004

a. To retrieve a record that you want to view and/or update, insert one or more search values into the
field(s) on this query form.
If you are not sure how to spell a search value, use the per cent symbol (%) wildcard to replace
the letters that you don't know. See the chart below for examples on how to use this wildcard:
To Search For:

Type This:

And Get These Results:

all records whose Test
Reason involves a trace

TK
TR
TE

all records submitted for
the state of Arkansas
(but you don't know the
full code for this state)

AR%

all records for Arkansas
all records for Arizona

(trace from kill)
(trace reactions)
(trace exposed)

Below is an example of a Query_A form with three search values entered (Sectn=A, Stg=1, and
Line nr=%). Note that the Line nr search value uses the wildcard.

b. Execute your query using one of the methods below:
• In the Menu Bar, select the Query > Execute command.
• In the Toolbar, click on the Execute Query icon.
c. Your query may retrieve more than one record. To be sure that you have the record you want,
scroll through all of the retrieved records by doing the following:
i. Click inside the Sectn field.
ii. Press the DOWN ARROW key on your computer keyboard. Each time you do so, a new
record will be displayed in the query form. So if your query retrieved four records, you
would need to press the DOWN ARROW key four times to see all of these records, one
at a time.
If you executed the search example shown in the above screen shot, you would have
retrieved every record containing Sectn=A, Stg=1, and Line nr= 0, 1, 2, 3, 4, or 5.

7.6

Draft – 1 Dec 2004

iii. When the record you want is displayed in the form, click on Save. Below is an example of
a retrieved PRV-190 Data-Submission record for Section A:

d. If you want to modify this record, follow these steps:
i. Highlight the first value you want to modify.
ii. Type the new value you want to use.
iii. Repeat these two steps of highlighting-overtyping for each value you want to change.
iv. After you have modified all of the values in this record, click on Save.
e. You can now do either of the following:
• If you modified the Data-Submission record for a PRV-190 report section, you now need
to instruct the Auto-Scheduler utility at the AWBDS web site to process this data. Go
directly now to the next section in this chapter, Procedure 2: Using the Auto-Scheduler to
Process Your Updated Data.
• You can exit the AWBDS web site by clicking on the Exit buttons in each webform or
screen.

7.7

Draft – 1 Dec 2004

1.7

If you selected Query_B, you should now see the following form onscreen. This webform has been
customized for Section B of the PRV-190 report:

Field Label on
Data-Submission Form

Data Stored in This Field
on Both Forms

Rpt Id

(Not found on D-S Form)

Default=PRV190

Sectn

Report Section Letter

Default=B

State

Code for the State in which the data-collection activity took
place.

Disease

Code for the disease whose data was submitted.

Stg

Stage

Stage level that your State was in during this reporting
period.

Species

Code for the animal species whose test results was
submitted.

Dt Beg

Begin Date

First date of the time period whose data was submitted.

Dt End

End Date

Last date of the time period whose data was submitted.

Run Dt

Report Run Date

Date on which your State's data was submitted.

Rec Type

(Not found on D-S Form)

Default=WEB

Prem Type

Code for the premises type whose data was submitted.

Nr positive
ST BG TEST

NR instate samples, collected
instate, barrows/gilts:
NR Positive
NR instate samples, collected
instate, barrows/gilts:
Totals
NR instate samples, collected
instate, sows/boars:
NR Positive
NR instate samples, collected
instate, sows/boars:
Totals

Total # of POSITIVE samples collected from this group.

Nr instate samples collected
instate barrows gilts
ST BG TEST
Nr positive
ST SB POS
Nr instate samples collected
instate sows boars
ST SB TEST

7.8

Total # of blood samples collected from this group.

Total # of POSITIVE samples collected from this group.

Total # of blood samples collected from this group.

Draft – 1 Dec 2004

Nr positive
OS SB POS
Nr out of state samples
collected instate barrows gilts
OS BG TEST
Nr positive
OS SB POS
Nr instate samples collected
instate sows boars
OS SB TEST
Nr positive
BS BG POS
Nr instate samples collected
out of state barrows gilts
BS BG TEST
Nr positive
BS BG TEST
Nr instate samples collected
out of state sows boars
BS SB TEST

NR out of state samples collected
instate, barrows/ gilts:
NR Positive
NR out of state samples collected
instate, barrows/ gilts:
Totals
NR out of state samples collected
instate, sows/ boars:
NR Positive
NR out of state samples collected
instate, sows/ boars:
Totals
NR instate samples collected out
of state, barrows/ gilts:
NR Positive
NR instate samples collected out
of state, barrows/ gilts:
Totals
NR instate samples collected out
of state, sows/ boars:
NR Positive
NR instate samples collected out
of state, sows/ boars:
Totals

Total # of POSITIVE samples collected from this group.

Total # of blood samples collected from this group.

Total # of POSITIVE samples collected from this group.

Total # of blood samples collected from this group.

Total # of POSITIVE samples collected from this group.

Total # of blood samples collected from this group.

Total # of POSITIVE samples collected from this group.

Total # of blood samples collected from this group.

a. To retrieve a record that you want to view and/or update, insert one or more search values into the
field(s) on this query form.
If you are not sure how to spell a search value, use the per cent symbol (%) wildcard to replace
the letters that you don't know. See the chart below for examples on how to use this wildcard:
To Search For:

Type This:

And Get These Results:

all records whose Test
Reason involves a trace

TK
TR
TE

all records submitted for
the state of Arkansas
(but you don't know the
full code for this state)

AR%

all records for Arkansas
all records for Arizona

7.9

(trace from kill)
(trace reactions)
(trace exposed)

Draft – 1 Dec 2004

Below is an example of a Query_B form with three search values entered (Sectn=B, Dz=PRV,
and Sp= P%). Note that the Sp search value includes the wildcard.

Click inside the Stg field.

ii.

iii.

When the record you want is displayed in the form, click on Save. Below is an example of
a retrieved PRV-190 Data-Submission record for Section B:

7.10

Draft – 1 Dec 2004

d. If you want to modify this record, follow these steps:
i.

Highlight the first value you want to modify.

ii.

Type the new value you want to use.

iii.

Repeat these two steps of highlighting-overtyping for each value you want to change.

iv.

After you have modified all of the values in this record, click on Save.

e. You can now do either of the following:
• If you modified the Data-Submission record for a PRV-190 report section, you now need
to instruct the Auto-Scheduler utility at the AWBDS web site to process this data. Go
directly now to the next section in this chapter, Procedure 2: Using the Auto-Scheduler to
Process Your Updated Data.
• You can exit the AWBDS web site by clicking on the Exit buttons in each webform or
screen.

7.11

Draft – 1 Dec 2004

1.8

If you selected Query_C, you should now see the following form onscreen. This webform has been
customized for Section C of the PRV-190 report:

Field Label on
Data-Submission Form

Data Stored in This Field
on Both Forms

(Not found on D-S Form)

Default=PRV190

Sectn

Report Section Letter

Default=C

State

Code for the State in which the data-collection activity took place.

Disease

Code for the disease whose data was submitted.

Stg

Stage

Stage level that your State was in during this reporting period.

Species

Code for the animal species whose data was submitted.

Dt Beg

Begin Date

First date of the time period whose data was submitted.

Dt End

End Date

Last date of the time period whose data was submitted.

Run Dt

Report Run Date

Date on which your State's data was submitted.

Rec Type

(Not found on D-S Form)

Default=WEB

Prem Type

Code for the premises type whose data was submitted.

All numbers entered into the following fields relate to testing or to traces that were closed during the reporting period.
Total nu traces
TOT POS

NR Total Traces

Total # of samples classified as POSITIVE from market (MKT) or
slaughter (SL) testing.

Nr TNR
trace not required
Trace NR
Nr TRH
trace to known infected herd
TRACE IH
Nr TTR
trace and herd test required
HRD TEST REQ
Nr TTR
trace and herd test not
required
HRD TEST NR
Nr TSH
traced to soldout herd
SOLD OUT HRD

NR TNR

Total # of market/slaughter traces that were closed as NOT
REQUIRED.

NR TRH

Total # of market/slaughter traces that were closed as TRACED
TO HERDS KNOWN TO BE INFECTED.

NR TTR

Total # of market/slaughter traces that were closed as TRACED
AND A HERD TEST IS REQUIRED.

NR TTN

Total # of market/slaughter traces that were closed as TRACED
AND A HERD TEST IS NOT REQUIRED.

NR TSH

Total # of market/slaughter traces that were closed as TRACED
TO SOLDOUT HERDS.

7.12

Draft – 1 Dec 2004

Nr TOS
traced to other state
TRACE ANOTH ST
Nr UT
unable to trace
TRACE UNABLE
Nr pending
non released or not closed
PENDING

NR TOS

Total # of market/slaughter traces that were closed as TRACED
TO ANOTHER STATE.

NR UT

Enter the # of market/slaughter traces that were closed as
UNABLE TO TRACE.

NR Pending

Enter the # of market/slaughter traces that were in progress at the
end of the reporting period.

a. To retrieve a record that you want to view and/or update, insert one or more search values into the
field(s) on this query form.
If you are not sure how to spell a search value, use the per cent symbol (%) wildcard to replace
the letters that you don't know. See the chart below for examples on how to use this wildcard:
To Search For:

Type This:

And Get These Results:

all records whose Test
Reason involves a trace

TK
TR
TE

all records submitted for
the state of Arkansas
(but you don't know the
full code for this state)

AR%

all records for Arkansas
all records for Arizona

(trace from kill)
(trace reactions)
(trace exposed)

Below is an example of a Query_C form with three search values entered (Sectn=C, St=O%, and
Dz=PRV). Note that the St search value includes the wildcard.

b. Execute your query using one of the methods below:
• In the Menu Bar, select the Query > Execute command.
• In the Toolbar, click on the Execute Query icon.

7.13

Draft – 1 Dec 2004

c. Your query may retrieve more than one record. To be sure that you have the record you want,
scroll through all of the retrieved records by doing the following:
i.

Click inside the Stg field.

ii.

iii.

When the record you want is displayed in the form, click on Save. Below is an example
of a retrieved PRV-190 Data-Submission record for Section C:

d. If you want to modify this record, do so following these steps:
i. Highlight the first value you want to modify.
ii. Type the new value you want to use.
iii. Repeat these two steps of highlighting-overtyping for each value you want to change.
iv. After you have modified all of the values in this record, click on Save.
e. You can now do either of the following:
• If you modified the Data-Submission record for a PRV-190 report section, you now
need to instruct the Auto-Scheduler utility at the AWBDS web site to process this data.
Go directly now to the next section in this chapter, Procedure 2: Using the AutoScheduler to Process Your Updated Data.
• You can exit the AWBDS web site by clicking on the Exit buttons in each webform or
screen.

7.14

Draft – 1 Dec 2004

1.9

If you selected Query_E, you should now see the following form onscreen. This webform has been
customized for Section E of the PRV-190 report:

Field Label on
Data-Submission Form

Data Stored in This Field
on Both Forms

Rpt Id

(Not found on D-S Form)

Sectn

Report Section Letter

Default=E

State

Code for the State in which the data-collection activity took place.

Default=PRV190

Disease

Code for the disease whose data was submitted.

Stg

Stage

Stage level that your State was in during this reporting period.

Species

Code for the animal species whose data was submitted.

Dt Beg

Begin Date

First date of the time period whose data was submitted.

Dt End

End Date

Last date of the time period whose data was submitted.

Run Dt

Report Run Date

Date on which your State's data was submitted.

Rec Type

(Not found on D-S Form)

Default=WEB

The numbers you enter into the following fields relate to affected herds disclosed during the reporting period:
Purchased feeders
PUR FEED

NR Purchased Feeders

Total # of affected herds for which the source of infection was
purchased feeder animals.

Purchased breeders
PUR BREED

NR Purchased Breeders

Total # of affected herds for which the source of infection was
purchased breeder animals.

Feral Swine
FERAL SW

NR Feral Swine

Total # of affected herds for which the source of infection was feral
swine animals.

Feed Bedding
FEED BED

NR Feed Bedding

Total # of affected herds for which the source of infection was feed
or bedding.

Area
AREA SP

NR Area Spread

Total # of affected herds for which the source of infection was area
spread.

Infected carcasses
INFECT SW

NR Infected Carcasses

Total # of affected herds for which the source of infection was
infected carcasses.

Herd divided
HERD DIV

NR Herd Divided

Total # of affected herds created by separating infected animals
from non-infected animals to make two herds.

Unknown
UNKNOWN

NR Unknown

Total # of affected herds for which the source of infection was
unknown.

7.15

Draft – 1 Dec 2004

a. To retrieve a record that you want to view and/or update, insert one or more search values into the
field(s) on this query form.
If you are not sure how to spell a search value, use the per cent symbol (%) wildcard to replace
the letters that you don't know. See the chart below for examples on how to use this wildcard:
To Search For:

Type This:

And Get These Results:

all records whose Test
Reason involves a trace

TK
TR
TE

all records submitted for
the state of Arkansas
(but you don't know the
full code for this state)

AR%

all records for Arkansas
all records for Arizona

(trace from kill)
(trace reactions)
(trace exposed)

Below is an example of a Query_E form with two search values entered (Sectn=E and St=M%).
Note that the St search value includes the wildcard.

b. Execute your query using one of the methods below:
• In the Menu Bar, select the Query > Execute command.
• In the Toolbar, click on the Execute Query icon.
c. Your query may retrieve more than one record. To be sure that you have the record you want,
scroll through all of the retrieved records by doing the following:
i. Click inside the Stg field.
ii. Press the DOWN ARROW key on your computer keyboard. Each time you do so, a new
record will be displayed in the query form. So if your query retrieved four records, you
would need to press the DOWN ARROW key four times to see all of these records, one
at a time.
If you executed the search example shown in the above screen shot, you would have
retrieved every record containing Sectn=E and St= MA, MD, ME, MI, MN, MO, MS,
or MT.

7.16

Draft – 1 Dec 2004

iii. When the record you want is displayed in the form, click on Save. Below is an example
of a retrieved PRV-190 Data-Submission record for Section E:

d. If you want to modify this record, do so following these steps:
i. Highlight the first value you want to modify.
ii. Type the new value you want to use.
iii. Repeat these two steps of highlighting-overtyping for each value you want to change.
iv. After you have modified all of the values in this record, click on Save.
e. You can now do either of the following:
• If you modified the Data-Submission record for a PRV-190 report section, you now
need to instruct the Auto-Scheduler utility at the AWBDS web site to process this data.
Go directly now to the next section in this chapter, Procedure 2: Using the AutoScheduler to Process Your Updated Data.
• You can exit the AWBDS web site by clicking on the Exit buttons in each webform or
screen.

7.17

Draft – 1 Dec 2004

1.10

If you selected Query_F, you should now see the following form onscreen. This webform has been
customized for Section F of the PRV-190 report:

Field Label on
Data-Submission Form
(Not found on D-S Form)
Report Section Letter
State
Disease
Stage
Species
Begin Date
End Date
Report Run Date
(Not found on D-S Form)

Data Stored in This Field
on Both Forms
Default=PRV190
Default=F
Code for the State in which the data-collection activity took place.
Code for the disease whose data was submitted.
Stage level that your State was in during this reporting period.
Code for the animal species whose data was submitted.
First date of the time period whose data was submitted.
Last date of the time period whose data was submitted.
Date on which your State's data was submitted.
Default=WEB

The two fields directly below relate to herds in which testing occurred, but in which no POSITIVE animals were found during the
report period.
Nr herds tested no infection
NR HERD TEST
Nr animals tested no infection
NR SW TEST

NR herds tested, no
infection
NR animals tested, no
infection

Total # of herds that were tested for PRV and in which no infection
was found.
Total # of animals that were tested for PRV and in which no
infection was found.

Herd Type

Code for the type of herds that was tested.

The three fields directly below relate to herds in which testing occurred, and in which at least one POSITIVE animal was found
during the report period.
Nr herds tested infection found
IF HRD TEST
Nr animals tested infection
found
IF SW TEST
Nr animals positive
IF SW POS

NR herds tested, infection
found
NR animals tested,
infection found

Total # of herds that were tested for PRV and in which infection
was found.
Total # of animals that were tested for PRV and in which infection
was found.

NR animals positive

Total # of PRV-POSITIVE animals.

7.18

Draft – 1 Dec 2004

The two fields directly below are standalone fields.
Total herds tested
TOT HRD TEST

Total herds tested

Total # of herds that were tested for PRV in herds with no infection
found and in herds with infection found.

Total animals tested
TOT SW TEST

Total animals tested

Total # of animals that were tested for PRV in herds with no
infection found and in herds with infection found.

a. To retrieve a record that you want to view and/or update, insert one or more search values into the
field(s) on this query form.
If you are not sure how to spell a search value, use the per cent symbol (%) wildcard to replace
the letters that you don't know. See the chart below for examples on how to use this wildcard:
To Search For:

Type This:

And Get These Results:

all records whose Test
Reason involves a trace

TK
TR
TE

all records submitted for
the state of Arkansas
(but you don't know the
full code for this state)

AR%

all records for Arkansas
all records for Arizona

(trace from kill)
(trace reactions)
(trace exposed)

Below is an example of a Query_F form with three search values entered (Dz=PRV, Stg=1, and
Herd Type=G%). Note that the Herd Type search value includes the wildcard.

b. Execute your query using one of the methods below:
• In the Menu Bar, select the Query > Execute command.
• In the Toolbar, click on the Execute Query icon.

7.19

Draft – 1 Dec 2004

c. Your query may retrieve more than one record. To be sure that you have the record you want,
scroll through all of the retrieved records by doing the following:
i.

Click inside the Stg field.

ii.

iii.

When the record you want is displayed in the form, click on Save. Below is an example
of a retrieved PRV-190 Data-Submission record for Section F:

d. If you want to modify this record, do so following these steps:
i. Highlight the first value you want to modify.
ii. Type the new value you want to use.
iii. Repeat these two steps of highlighting-overtyping for each value you want to change.
iv. After you have modified all of the values in this record, click on Save.
e. You can now do either of the following:
• If you modified the Data-Submission record for a PRV-190 report section, you now need
to instruct the Auto-Scheduler utility at the AWBDS web site to process this data. Go
directly now to the next section in this chapter, Procedure 2: Using the Auto-Scheduler to
Process Your Updated Data.
• You can exit the AWBDS web site by clicking on the Exit buttons in each webform or
screen.

7.20

Draft – 1 Dec 2004

Procedure 2:
Using the Auto-Scheduler to Process Your Updated
Data
Now that you have modified the record for a PRV-190 report section, you need to alert the Auto-Scheduler utility
that you have new data for it to process. You accomplish this task by leaving the Data Entry Forms area of the
website to work in the Approval Summary Data area. Follow the instructions below:

2.1

In the Query webform where you just modified the record for a PRV-190 report section, click on Exit.

2.2

The Summary Data Entry Forms main menu (shown at right)
now appears.
In this screen, click on Exit. You have now left the Data Entry
Forms area of the website.

2.3

The National Surveillance Program Reports main menu now
appears.
Click on the Approve Summary Data option. You have now
entered the Approval area of the website.

2.4

The National Surveillance Reports Menu (shown at right) will
appear onscreen.

7.21

Draft – 1 Dec 2004

2.5

Fill out the header block with the appropriate parameters for the PRV-190 report section whose DataSubmission record you just updated.

2.6

In the bottom block of this same menu, click on the [2] next to the PRV-190 National Summary Report
Data option.

2.7

A PRV-190 Approval Forms screen (shown below) now appears.

7.22

Draft – 1 Dec 2004

2.8

2.9

Even though you modified the record for only one PRV-190 report section, you may still see five popup
messages that describe the actions done by the Auto-Scheduler for all five sections shown on this screen.
Click OK in each popup window to close it.

2.10

At the end of your work session, you can exit the AWBDS web site by clicking on the Exit buttons in each
webform or screen.

7.23

Draft – 1 Dec 2004

Reference Table 1:
Organized by Report Section Letter (Sections A-C)
The table below allows you to see all of the data field labels for a single section within the
PRV-190 report at a single glance.
Section A

Section B

Section C

Herd Status

Market/Slaughter Surveillance Data, Blood
Samples Collected in this State

Tracebacks of Market/Slaughter
Surveillance Positives

D2
D4

Line nr
Nr infected herds

Prem type
Nr positive
ST_BG_POS
Nr instate samples, collected instate,
barrows/gilts ST_BG_TEST

Prem type
Total nr traces
TOT_POS
Nr TNR (trace not required)
TRACE_NR

Nr animals in herds

Nr QN herds

Nr positive
ST_SB_POS

D10

Nr FPM herds

D12

Nr QNV herds

Nr instate samples, collected instate,
sows/boars
ST_SB_TEST
Nr positive
OS_SB_POS

D14

Nr CLP herds

D16

---

D18

---

Nr TRH (trace to known
infected herd)
TRACE_IH
Nr TTR (trace and herd test
required)
HRD_TEST_REQ
Nr TTN (traced and herd test
not required)
HRD_TEST_NR
Nr TSH (traced to soldout
herd)
SOLD_OUT_HRD
Nr TOS (traced to other state)
TRACE_ANOTH_ST
Nr UT (unable to trace)
TRAACE_UNABLE

D20

---

D22

---

D24

---

D26

---

Nr out of state samples, collected instate,
barrows/gilts
OS_BG_TEST)
Nr positive
OS_SB_POS
Nr instate samples, collected instate,
sows/boars
OS_SB_TEST
Nr positive
BS_BG_POS
Nr instate samples, collected out of state,
barrows/gilts
BS_BG_TEST
Nr positive
BS_SB_POS
Nr instate samples, collected out of state,
sows/boars
BS_SB_TEST

7.24

Nr pending (non-released or
not closed)
PENDING
---

-----

Draft – 1 Dec 2004

Reference Table 1:
Organized by Report Section Letter (Sections E-F)

D2
D4
D6
D8
D10
D12
D14
D16
D18
D20
D22
D24
D26

Section E

Section F

Source of Infection of New Herds

Summary of On-Farm Testing Results

Purchased feeders
PUR_FEED
Purchased breeders
PUR_BREED
Feral swine
FERAL_SW
Feed/bedding
FEED_BED
Area
AREA_SP
Infected carcasses
INFECT_SW
Herd divided
HERD_DIV
Unknown
UNKNOWN
-----------

Nr herds tested, no infection
NR_HRD_TEST
Nr animals tested, no infection
NR_SW_TEST
Herd type
Nr herds tested, infection found
IF_HRD_TEST
Nr animals tested, infection found
IF_SW_TEST
Nr animals positive
IF_SW_POS
Total herds tested
TOT_HRD_TEST
Total animals tested
TOT_SW_TEST
-----------

7.25

Draft – 1 Dec 2004

Reference Table 2:
Organized by Data Field Label (1 of 1)
The table below allows you to determine what a specific data field label is, depending on which
section in the PRV-190 report you see that label.
Field D2:

Field D4:

Field D8:

Field D10:

Field D12:

Field D14:

Field D16:

Field D18:

Field D20:

Field D22:

Section A:
Section B:
Section C:
Section E:
Section F:
Section A:
Section B:
Section C
Section E:
Section F
Section A:
Section B:
Section C:
Section E:
Section F:
Section A:
Section B:
Section C
Section E:
Section F
Section A:
Section B:
Section C:
Section E:
Section F:
Section A:
Section B:
Section C:
Section E:
Section F:
Section A:
Section B:
Section C
Section E:
Section F
Section A:
Section B:
Section C:
Section E:
Section F:
Section A:
Section B:
Section C:
Section E:
Section F:
Section A:
Section B:
Section C
Section E:
Section F

Line nr
Prem type
Prem type
Purchased feeders
Nr herds tested, no infection
Nr infected herds
Nr positive
Total nr traces
Purchased breeders
Nr animals tested
Nr QN herds
Nr positive
Nr TRH (trace to known infected herd)
Feed/bedding
Nr herds tested, infection found
Nr FPM herds
Nr instate samples, collected instate, sows/boars
Nr TTR (trace and herd test required)
Area
Nr animals tested, infection found
Nr QNV herds
Nr positive
Nr TTN (traced and herd test not required)
Infected carcasses
Nr animals positive
Nr CLP herds
Nr out of state samples, collected instate, barrows/gilts
Nr TSH (traced to soldout herd)
Herd divided
Total herds tested
--Nr positive
Nr TOS (traced to other state)
Unknown
Total animals tested
--Nr instate samples, collected instate, sows/boars
Nr UT (unable to trace)
------Nr positive
Nr pending (non-released or not closed)
------Nr instate samples, collected out of state, barrows/gilts
-------

7.26

------PUR_FEED
NR_HRD_TEST
--ST_BG_TEST
TRACE_NR
FERAL_SW
NR_SW_TEST
--ST_SB_POS
TRACE_IH
FEED_BED
IF_HRD_TEST
--ST_SB_TEST
HRD_TEST_REQ
AREA_SP
IF_SW_TEST
--OS_SB_POS
HRD_TEST_NR
INFECT_SW
IF_SW_POS
--OS_BG_TEST
SOLD_OUT_HRD
HERD_DV
TOT_HRD_TEST
--OS_SB_POS
TRACE_ANOTH_ST
UNKNOWN
TOT_SW_TEST
--OS_SB_TEST
TRAACE_UNABLE
------BS_BG_POS
PENDING
------BS_SB_POS
-------

Draft – 1 Dec 2004

Field D24:

Field D26:

Section A:
Section B:
Section C:
Section E:
Section F:
Section A:
Section B:
Section C:
Section E:
Section F:

--Nr positive
--------Nr instate samples, collected out of state, sows/boars
-------

7.27

--BS_SB_POS
--------BS_SB_TEST
-------

Draft – 1 Dec 2004

7.28

Chapter 8:
Approving Your State's PRV-190 Data
In this task, you will learn how to approve, reject, and delete your State's data for a PRV-190 National
Report.
Unit

Topic

See Page

Procedure 1:

Approving/Rejecting a State's PRV-190 Data-Submission
(This procedure can be done only by authorized Quality Control (QC) personnel
for your State.)

8.2

Procedure 2:

Viewing an Existing, Not-Yet-Approved PRV-190 Data-Submission

8.6

Procedure 3:

Deleting an Existing, Not-Yet-Approved PRV-190 Data-Submission

8.11

8.1

Draft – 1 Dec 2004

Procedure 1:
Approving/Rejecting a State's PRV-190
Data-Submission
This procedure can be performed only by a State's authorized Quality Control (QC) personnel.

1.1

Log into the Automated Web-Based Data Submission (AWBDS) web site.
A Warning screen will appear onscreen.

1.2

Click on the Accept button.
The Veterinary Services National Surveillance Program Reports main screen (shown below) will
appear.

1.3

Click on the Approve Summary Data option.

8.2

Draft – 1 Dec 2004

1.4

The National Surveillance Reports Menu screen (shown below) will appear:

In the top block of this form, enter the parameters that identify the specific report whose section(s) you
want to record your approval/disapproval.
Field

Guidelines

Approver's
Oracle User
Name

User name that you use to log into the AWBDS web site.

State

Two-letter postal abbreviation for the state in which the data collection activity took place.
Click on the down arrow button to display a List of Values for this field.

Disease
Program

Code for the animal disease program whose test results are being reported on this form.
Click on the L button to display a List of Values for this field.

Species

Code for the animal species whose test results are being reported on this form.
Click on the down arrow button to display a List of Values for this field.

Report Begin
Date

Report Run Date

When completed, the top block should look similar to this example:

8.3

Draft – 1 Dec 2004

1.5

In the bottom block of this form, click on the 2. PRV-190 National Summary Report Data option.
A PRV-190 Approval Forms screen will now appear:

a. Note that the report parameters (such as its Species, Begin Date, and End Date parameters) which
you specified back in Step 1.4 will apply to every report section listed on this screen.
Keep in mind, however, that you can approve/reject only those sections for which you have signoff
authority. (As an example, the State of Florida might have one QC representative, John Smith,
who has signoff authority for Sections A-C, and a second QC representative, Cindy Nelson, who
has signoff authority for Sections E-F only. John Smith cannot approve/reject Sections E-F, and
Cindy Nelson cannot approve/reject Sections A-C.)
b. For each section, you must click on the down arrow button and select a value from the displayed
List of Values. The choices are described below:
Option

Meaning

Y–
Report Approved

As your State's QC representative with signoff authority, you approve the data
submitted for this report section to be complete and accurate.

N–
Report Not Approved

R–
Re-run the Report

Enables you to run a new version of the PRV-190 National Program Report.
This option is helpful, especially in situations where an initial Data-Submission from
a State had to be corrected and re-submitted for approval. Once the second,
corrected submission has been approved, this option can be used to generate a
new PRV-190 National Program Report whose data will be accurate.
This option is described in more detail in the following chapters of this manual:
Chapter 3 – Updating Your State's Data for a TB6-2 National Program Report
Chapter 7 – Updating Your State's Data for a PRV-190 National Program Report
Chapter 11 – Updating Your State's Data for an SPP National Program Report

8.4

Draft – 1 Dec 2004

c. Once you have indicated your approval/rejection for each section for which you have signoff
authority, your screen should look similar to the example below:

Click on the Approve command button.

d. A popup window like the one shown below will appear for each report section for which your
approval has been successfully recorded. Click OK to close each popup window.

e. After you have submitted your approval for each PRV-190 section for which you have signoff
authority, click on the Exit command button.
You are returned to the National Surveillance Reports Menu screen.

8.5

Draft – 1 Dec 2004

Procedure 2:
Viewing an Existing, Not-Yet-Approved
PRV-190 Data-Submission
This procedure enables you to query for and retrieve one or more existing PRV-190 Data-Submission records that
are currently being stored in the Temporary Holding Database.
You may wish to query for a record to see if it has already been submitted, or to see if it has been approved/signed
off by your State's QC personnel.

2.1

Log into the Automated Web-Based Data Submission (AWBDS) web site. (If necessary, refer back to
Task 1 for the procedure on how to do this.)
A Warning screen will appear onscreen.

2.2

Click on the Accept button.
The Veterinary Services National Surveillance Program Reports main screen (shown below) will
appear.

2.3

Click on the Approve Summary Data option.

8.6

Draft – 1 Dec 2004

2.4

The National Surveillance Reports Menu screen (shown below) will appear:

In the top block of this form, enter the parameters that identify the specific report whose section(s) you
want to view.
Field

Guidelines

Approver's
Oracle User
Name

User name that you use to log into the AWBDS web site.

State

Two-letter postal abbreviation for the state in which the data collection activity took place.
Click on the down arrow button to display a List of Values for this field.

Disease
Program

Code for the animal disease program whose test results are being reported on this form.
Click on the L button to display a List of Values for this field.

Species

Code for the animal species whose test results are being reported on this form.
Click on the down arrow button to display a List of Values for this field.

Report Begin
Date

Report Run Date

When completed, the top block should look similar to this example:

8.7

Draft – 1 Dec 2004

2.5

In the bottom block of this form, click on the 1. PRV-190 Tuberculosis National Summary Report
Data option.
A PRV-190 Approval Forms screen will now appear.

2.6

To determine if a report section has already been submitted, approved, or rejected, click on the Already
Approved Report button. The following query screen will appear:

2.7

8.8

Draft – 1 Dec 2004

Type This:

To Get These Results:

%STON%

Halstone

Charleston

Alabama
Arizona

Alaska
Arkansas

AD44

300AD44

%AD44

The example below shows the wildcard variable that was entered in the Approver User Name
field.

8.9

Draft – 1 Dec 2004

Click your cursor inside any field (Record Create Date for example).

To end your work session, you can exit the ASBDS web site by clicking on the Exit buttons in each
webform or screen.

8.10

Draft – 1 Dec 2004

Procedure 3:
Deleting an Existing, Not-Yet-Approved
PRV-190 Data-Submission
This procedure enables you to query for and delete an existing PRV-190 Data-Submission record that is currently
being stored in the Temporary Holding Database.

3.1

Log into the Automated Web-Based Data Submission (AWBDS) web site. (If necessary, refer back to
Task 1 for the procedure on how to do this.)
A Warning screen will appear onscreen.

3.2

Click on the Accept button.
The Veterinary Services National Surveillance Program Reports main screen (shown below) will
appear.

3.3

Click on the Approve Summary Data option.

8.11

Draft – 1 Dec 2004

3.4

The National Surveillance Reports Menu screen (shown below) will appear:

In the top block of this form, enter the parameters that identify the specific report whose section(s) you
want to delete.
Field

Guidelines

Approver's
Oracle User
Name

User name that you use to log into the AWBDS web site.

State

Two-letter postal abbreviation for the state in which the data collection activity took place.
Click on the down arrow button to display a List of Values for this field.

Disease
Program

Code for the animal disease program whose test results are being reported on this form.
Click on the L button to display a List of Values for this field.

Species

Code for the animal species whose test results are being reported on this form.
Click on the down arrow button to display a List of Values for this field.

Report Begin
Date

Report Run Date

When completed, the top block should look similar to this example:

8.12

Draft – 1 Dec 2004

3.5

In the bottom block of this form, click on the 1. PRV-190 Tuberculosis National Summary Report
Data option.
A PRV-190 Approval Forms screen will now appear.

3.6

Click on the Already Approved Report button. The following query screen will appear:

3.7

8.13

Draft – 1 Dec 2004

Type This:

To Get These Results:

%STON%

Halstone

Charleston

Alabama
Arizona

Alaska
Arkansas

AD44

300AD44

%AD44

The example below shows the wildcard variable that was entered in the Approver User Name
field.

8.14

Draft – 1 Dec 2004

Click your cursor inside any field (Record Create Date for example).

To end your work session, you can exit the ASBDS web site by clicking on the Exit buttons in each
webform or screen.

8.15

Draft – 1 Dec 2004

8.16

Chapter 9:
Running a PRV-190 National Report
In this task, you will learn how to run a new PRV-190 National Report, which should include the most
recent, approved PRV-190 Data-Submission record from your State. This report is being produced from
the permanent report tables and can be run only after the report has been approved and its data transferred
from the Temporary Holding Database to the National Reports Database.

9.1

Draft – 1 Dec 2004

Procedure for Running a New PRV-190 National
Report:
1.1

Log into the Automated Web-Based Data Submission (AWBDS) web site.

1.2

A Warning screen will appear onscreen.
Click on the Accept button.

1.3

Veterinary Services National Surveillance Program
Reports main screen (shown at right) will appear.
In this screen, click on the Run Program Reports option.

1.4

The Summary Reports by Section screen (shown at right)
will appear:
In this screen, select the [2] button next to the
PRV-190 Pseudorabies option.

1.5

A PRV-190 Summary Reports by Section screen (shown at
right) will now appear:

…The remainder of this procedure will be written after code
development for this feature has been completed…

9.2

Chapter 10:
Submitting Your State's Data for an
SPR National Report
This chapter is for those States "not using" the GDB to enter their Brucellosis or Johnes surveillance data. It covers
the procedures for using, completing, and submitting your State's monthly Brucellosis or Johne's eradication
summary data, using the AWBDS SPR Data-Submission webform. The topics in this chapter appear below:
Topic

See
Page

Information Needed to Enter into the SPR Data-Submission Webform

10.2

Requirements on Using the SPR Data-Submission Webform

10.3

Procedure for Completing the SPR Data-Submission Webform

10.4

10.1

Draft – 1 Dec 2004

Information Needed to Enter into the SPR
Data-Submission Webform
The Standard Program Report (SPR) is a generic report template that can report data for three of Veterinary
Services' animal disease management programs: Brucellosis, Johne's, and Equine Infectious Anemia. The SPR
report summarizes your data for a variety of disease eradication activities on farms and ranches, at markets, and at
slaughter establishments.
In the same spirit, we have provided a single SPR Data-Submission webform for you to use to submit your data for
these three disease programs. To use this webform, you will need to have available the monthly or quarterly
summary data for your particular disease program. This summary data may be compiled from your State's program
data collection documents or from other sources.

Requirements on Using the SPR Data-Submission
Webform
The SPR Data-Submission webform has fifteen tabbed pages on it -- one tabbed page for each of the fifteen sections
that make up the VS SPR National Report. The table below shows the kinds of data that you can enter into the
various sections of the SPR Data-Submission webform.
Data-Collection
Activity

Herd Reporting

Data from this Activity that
You want to Submit…

Is Entered in this
Section of the
Webform:

For a specified date range, you want to submit the following data:
- Information on cattle tested on farms and ranches
- Information on affected herds in your State
- Information on affected herds in your State
- Information on herds that have been depopulated
- Information on herds that are due for testing/retesting
- Information on certified Brucellosis-free herds
- Information on blood tests done in other species
- Information on probable sources of infection in new herds

A
B1
B2
C
D
E
F
L

Market Cattle
Identification (MCI)
Reporting

For a specified date range, you want to submit the following data:
- List of blood sample collections at slaughter establishments
- List of blood tests done on market cattle/bison that were tested in-State
- List of traceback investigations done on MCI animals diagnosed as reactors

G
H
I

BRT Reporting

You want to submit data about Brucellosis Ring Test (BRT) activities in a given BRT round
for herds located in-State, regardless of where they were actually tested.

Vaccination Reporting

For a specified date range, you want to submit vaccination information on young or older
animals.

Johne's Reporting

For a specified date range, you want to submit the following data:
- Information on the program status of herds in your State
- Information on affected herds in your State
- Information on the types of tests that were performed on herds and animals

10.2

M
N1
N2

Draft – 1 Dec 2004

Your State's animal disease management program(s) will determine which sections of the webform you should use.
Generally speaking:
• the cattle BR program uses data that you enter in Sections A, B1, B2, C, D, E, F, G, H, I, K, and L
• the swine BR program uses data that you enter in Sections A, B1, B2, G, H, and I
• the BRT program uses data that you enter in Section J only
• the equine EIA program does not yet have any officially-designated SPR sections assigned for its use
• the Johne's program uses data that you enter in Sections K, M, N1, and N2
(Note: Johne's data can be viewed in other sections of the SPR if they are requested; but only Sections K, M,
N1, and N2 are required to be submitted.)

10.3

Draft – 1 Dec 2004

Procedure for Completing the SPR Data-Submission
Webform
This procedure describes how to fill out all sixteen sections of the SPR Data-Submission webform. During a single
work session, you can work in as few or as many sections as you wish.
If you do need to work enter data for a single report during several work sessions, however, you will need to keep
track of the data you entered into the Report Parameters block (the top block on the webform) – some fields in this
block must contain the same data regardless of which section you are currently working in.
To Work On:

Do These Steps Of This Procedure:

Section A only
Section B1 only
Section B2 only
Section C only
Section D only
Section E only
Section F only
Section G only
Section H only
Section I only
Section J only
Section K only
Section L only
Section M only
Section N1 only
Section N2 only

Step 1.1 through Step 1.7
Step 1.1 through Step 1.6, then Step 1.8
Step 1.1 through Step 1.6, then Step 1.9
Step 1.1 through Step 1.6, then Step 1.10
Step 1.1 through Step 1.6, then Step 1.11
Step 1.1 through Step 1.6, then Step 1.12
Step 1.1 through Step 1.6, then Step 1.13
Step 1.1 through Step 1.6, then Step 1.14
Step 1.1 through Step 1.6, then Step 1.15
Step 1.1 through Step 1.6, then Step 1.16
Step 1.1 through Step 1.6, then Step 1.17
Step 1.1 through Step 1.6, then Step 1.18
Step 1.1 through Step 1.6, then Step 1.19
Step 1.1 through Step 1.6, then Step 1.20
Step 1.1 through Step 1.6, then Step 1.21
Step 1.1 through Step 1.6, then Step 1.22

1.1

If necessary, log into the AWBDS web site.

1.2

The Veterinary Services National Surveillance Program
Reports main menu screen (shown at right) will appear.
In this screen, click on the Enter Summary Data option.

1.3

The National Reports Summary Data Entry Forms main menu
screen (shown at right) now appears.
In this screen, click on the [3] button next to the
SPR – Standard Program Reports (incl. BR, JOH)
option.

10.4

Draft – 1 Dec 2004

1.4

A blank SPR Data-Submission webform will appear.
Menu Bar
Toolbar

Report
Parameters
Block

Functional Tabs

Animal and
Disease Program
Block

Command Buttons

1.5

Fill out the top block of the webform according to the guidelines in the following table. To move from one
field to the next field, press the TAB or ENTER key.

Field

Guidelines

Report Section
Letter

Letter of the section in the SPR report for which you are submitting your data.
Click on the L button to display a List of Values for this field. The choices are:
A
Tests on Farm or Ranch
B1
Affected Herds in State
B2
Affected Herds in State
C
Herds Depopulated
D
Herds Pending Test or Retest
E
Certified Herds
F
Tests in Other Species
G
Blood Sample Collections at Slaughter
H
Blood Tests on Market Animals Tested in State
I
Tracebacks from Market and Slaughter
J
Ring Test Results (Herds in-State regardless of where tested)
K
Animals Vaccinated
L
Source of New Herd Infections
M
Count of Herds in Johne's Program
N1
Part A: Johne's Herds Tested
N2
Part B: Johne's Herds and Animals Tested by Test Type
Query (See Chapter 11 for instructions on how to use this feature for SPR.)
Select the appropriate option. As soon as you do so and press TAB or ENTER, the bottom block of
the webform will refresh and display only the tabbed page for the Report Section Letter you just
selected.

10.5

Draft – 1 Dec 2004

State

Enter the two-letter postal abbreviation (such as WY) for the state in which the data collection activity
took place.

Disease

Code for the animal disease program whose test results are being reported on this webform.
Click on the L button to display a List of Values for this field. The choices are:
BR
Brucellosis
EIA
Equine Infectious Anemia
JOH
Johne's

Stage

Code for the stage level of your State for which the national report is being prepared.
Click on the L button to display a List of Values for this field. The choices are:
BR Program

EIA Program

Johne's Program

F
A
B
C

Free
A
B
C

Undefined

Code for the animal species whose test results are being reported on this webform.
Click on the L button to display a List of Values for this field. The choices are:

Species

BR Program

EIA Program

Johne's Program

BOV
CER
FER
POR

EQU

BOV
BIS

Cattle
Cervidae
Feral Swine
Porcine

Equine

Cattle
Bison

Begin Date

End Date

Report Run Date

1.6

Automatically populated with today's date the first time you execute the Save command. (You can
wait to do this after you start working in the webform's bottom block.)

Having filled out the top block of the webform, you now need to choose which section you want to work
in. The table below will help find the correct step for the section you choose:
Section A –

Do Step 1.7

Section F –

Do Step 1.13

Section K –

Do Step 1.18

Section B1 –

Do Step 1.8

Section G –

Do Step 1.14

Section L –

Do Step 1.19

Section B2 –

Do Step 1.9

Section H –

Do Step 1.15

Section M –

Do Step 1.20

Section C –

Do Step 1.10

Section I –

Do Step 1.16

Section N1 –

Do Step 1.21

Section D –

Do Step 1.11

Section J –

Do Step 1.17

Section N2 –

Do Step 1.22

Section E –

Do Step 1.12

Note: You do not have to complete the sections of the SPR Data-Submission webform in sequential order
(F, G, H, and I, for example) during your work session. The above table appears at the end of each step in
this procedure, so you can switch between sections in any order.

10.6

Draft – 1 Dec 2004

1.7

The tabbed page labeled Section A should be displayed onscreen:

The table below describes what kind of data you will enter into the fields on this page.
Field

Guidelines

Test Reason

Code for the reason the animal(s) or animal lot(s) were tested.
Click on the L button to display a List of Values for this field. The choices are:
ARE
Area
DX
Diagnostic
EPI
Epi Testing
HC
Herd Certification
MOV
Movement/Private Sale
TRACE MCI Trace
PQR
Post Quarantine Release
SHO
Show
INF
Infected
SA
Suspect Animals
MO
Milk Ordinance
OTH
Other (reason not listed above)

Fed Expense
Herds
Animals

Enter the # of herds whose testing costs were reimbursed at Federal expense.
Enter the # of animals whose testing costs were reimbursed at Federal expense.

Fed Fee Basis Expense
Herds
Animals

Enter the # of herds whose testing costs were reimbursed at Federal Fee Basis expense.
Enter the # of animals whose testing costs were reimbursed at Federal Fee Basis expense.

State Expense
Herds
Animals

Enter the # of herds whose testing costs were reimbursed at State expense.
Enter the # of animals whose testing costs were reimbursed at State expense.

State Fee Basis Expense
Herds
Animals

Enter the # of herds whose testing costs were reimbursed at State Fee Basis expense.
Enter the # of animals whose testing costs were reimbursed at State Fee Basis expense.

Owner Expense
Herds
Animals

Enter the # of herds whose testing costs were reimbursed at Owner expense.
Enter the # of animals whose testing costs were reimbursed at Owner expense.

Total Herds Tested

Enter the # of herds tested during this report period.

Total Animals Tested

Enter the # of animals tested during this report period.

10.7

Draft – 1 Dec 2004

a. In the Test Reason field, select ARE in the List of Values.
i. Fill out the rest of the fields on this page with the appropriate data from your paper forms
that pertain to the ARE test reason. If you have no data to enter into a specific field, enter 0
(zero) instead.
ii. Click on either the Save command button at the bottom of the webform or the Save icon in
the Toolbar. Doing this immediately saves all of the data you just entered for the ARE test
reason.
iii. Click on the New Line for Section command button.
b. In the Test Reason field, select the next choice in the List of Values (such as DX).
i. Fill out the rest of the fields with the appropriate data for this test reason. If you have no
data for a specific field, enter 0 (zero) instead.
ii. Click on either the Save command button or the Save icon to save your data for this second
test reason.
iii. Click on the New Line for Section command button.
c. Repeat Step 1.7b for each choice shown in the List of Values for the Test Reason field.
d. After you have saved your data for the final Test Reason choice, you can do either action below:
• Switch to a different section of the webform. In order to do this:
i. In the Report Section Letter field, select the desired letter from the List of Values.
ii. Edit any of the other fields in the top block, as needed.
iii. Go directly to the step for completing this new section (see the table below):
Section A –

Do Step 1.7

Section F –

Do Step 1.13

Section K –

Do Step 1.18

Section B1 –

Do Step 1.8

Section G –

Do Step 1.14

Section L –

Do Step 1.19

Section B2 –

Do Step 1.9

Section H –

Do Step 1.15

Section M –

Do Step 1.20

Section C –

Do Step 1.10

Section I –

Do Step 1.16

Section N1 –

Do Step 1.21

Section D –

Do Step 1.11

Section J –

Do Step 1.17

Section N2 –

Do Step 1.22

Section E –

Do Step 1.12

• Exit the SPR Data-Submission webform by clicking on either the Exit command button at the
bottom of the webform or the Exit icon in the Toolbar.

10.8

Draft – 1 Dec 2004

1.8

The tabbed page labeled Section B1 should be displayed onscreen.

The table below describes what kind of data you will enter into the fields on this page.
Field

Guidelines

Prem ID

Enter the official identification for the premises whose data you are submitting in this
section.

Prem Type

Code for the type of business/activity done on or by the premises.
Click on the L button to display a List of Values for this field. The choices are any
premises type other than the ones listed below:
CSL
Custom Slaughter Establishment
FPC
First Point of Contact
FSL
Federal Slaughter Establishment
MKT
Market
RSP
Restricted Swine Premises
SSL
State Slaughter Establishment

Prem Name

Enter the name of the premises' owner, the business, or the herd.
Use this format: lastname space firstname space middleinitial
(Do not use any punctuation, such as a comma, period, or special character.)
Example: Williamson Joseph B

Prem City

Enter the name of the city in which the premises is located.

Prem County

Enter the name of the county in which the premises is located.

Prem Zip Code

Enter the zip code of the premises's physical address.

Most Probable Source

Code for the most likely source of infection in an affected herd..
Click on the L button to display a List of Values for this field. The choices are:
NDA
Non-Domestic Animals
PUR
Purchase
ARE
Area
OTH
Other
UKN
Unknown

Isolate

Any code that your State wants to use in this field.

NR Eligible Animals

Total # of animals eligible for testing at a market or slaughter establishment.

Retest NR

The # of times the affected herd has been retested for Brucellosis or Johnes' on a
complete herd test, while considered "affected". (This field is usually left null.)

10.9

Draft – 1 Dec 2004

Test Reason

Code for the reason the animal(s) or animal lot(s) were tested.
Click on the L button to display a List of Values for this field. The choices are:
ARE
Area
DX
Diagnostic
EPI
Epidemiological Testing
HC
Herd Certification
MOV
Movement/Private Sale
TRACE MCI Trace
PQR
Post Quarantine Release
SHO
Show
INF
Infected
SA
Suspect Animals
MO
Milk Ordinance
OTH
Other (any reason not listed above)

NR Tested Last Test

Enter the # of animals tested on the most recent herd test.

NR Reactors Last Test

Enter the # of animals classified as REACTOR on the most recent herd test.

Collection Date Last Test

Enter the collection date of the most recent herd test.

Prev. React Date

Enter the most recent previous date on which reactor animals were found on a herd test
done prior to the last test (if reactor animals were found on the last test).

Quarantine Date

Enter the date on which a herd was quarantined.

a. In the Prem ID field, enter the official identification for the first premises you are reporting.
i. Fill out the rest of the fields on this page with the appropriate data from your paper forms
that pertain to this premises. If you have no data to enter into a specific field, enter 0 (zero)
instead.
ii. Click on either the Save command button at the bottom of the webform or the Save icon in
the Toolbar. Doing this immediately saves all of the data you just entered for this Prem ID.
iii. Click on the New Line for Section command button.
b. In the Prem ID field, enter the official identification for the next premises you are reporting.
i. Fill out the rest of the fields on this page with the appropriate data from your paper forms
that pertain to this second premises. If you have no data for a specific field, enter 0 (zero)
instead.
ii. Click on either the Save command button or the Save icon in the Toolbar to save the data
for this second premises.
iii. Click on the New Line for Section command button.
c. Repeat Step 1.8b for each additional premises whose data you are submitting.

10.10

Draft – 1 Dec 2004

d. After you have saved your data for the final Prem ID choice, you can do either task below:
• Switch to a different section of the webform. In order to do this:
i. In the Report Section Letter field, select the desired letter from the List of Values.
ii. Edit any of the other fields in the top block, as needed.
iii. Go directly to the step for completing this new section (see the table below):
Section A –

Do Step 1.7

Section F –

Do Step 1.13

Section K –

Do Step 1.18

Section B1 –

Do Step 1.8

Section G –

Do Step 1.14

Section L –

Do Step 1.19

Section B2 –

Do Step 1.9

Section H –

Do Step 1.15

Section M –

Do Step 1.20

Section C –

Do Step 1.10

Section I –

Do Step 1.16

Section N1 –

Do Step 1.21

Section D –

Do Step 1.11

Section J –

Do Step 1.17

Section N2 –

Do Step 1.22

Section E –

Do Step 1.12

• Exit the SPR Data-Submission webform by clicking on either the Exit command button at the
bottom of the webform or the Exit icon in the Toolbar.

10.11

Draft – 1 Dec 2004

1.9

The tabbed page labeled Section B2 should be displayed onscreen.

The table below describes what kind of data you will enter into the fields on this page.
Field

Guidelines

NR Herds Disclosed Reactors

Enter the # of herds tested during the report period on which at least one
animal was classified as a REACTOR, regardless of whether the herd was
quarantined.

NR Infected Herds Beginning of Month

Enter the # of herds classified as INFECTED at the beginning of this report
period.

NR New Infected Herds During Month

Enter the # of new herds classified as INFECTED during this report period.

NR Herds Released

Enter the # of herds whose classification as INFECTED was ended during this
report period.

NR Infected Herds End of Month

Enter the # of herds classified as INFECTED at the end of this report period.

a. Fill out the fields on this page with the appropriate data from your paper forms. If you have no data
to enter into a specific field, enter 0 (zero) instead.
b. Click on either the Save command button or the Save icon.
c. You can now do either action below:
• Switch to a different section of the webform. In order to do this:
i. In the Report Section Letter field, select the desired letter from the List of Values.
ii. Edit any of the other fields in the top block, as needed.
iii. Go directly to the step for completing this new section (see the table below):
Section A –

Do Step 1.7

Section F –

Do Step 1.13

Section K –

Do Step 1.18

Section B1 –

Do Step 1.8

Section G –

Do Step 1.14

Section L –

Do Step 1.19

Section B2 –

Do Step 1.9

Section H –

Do Step 1.15

Section M –

Do Step 1.20

Section C –

Do Step 1.10

Section I –

Do Step 1.16

Section N1 –

Do Step 1.21

Section D –

Do Step 1.11

Section J –

Do Step 1.17

Section N2 –

Do Step 1.22

Section E –

Do Step 1.12

• Exit the SPR Data-Submission webform by clicking on either the Exit command button at the
bottom of the webform or the Exit icon in the Toolbar.

10.12

Draft – 1 Dec 2004

1.10

The tabbed page labeled Section C should be displayed onscreen.

The table below describes what kind of data you will enter into the fields on this page.
Field

Guidelines

Prem ID

Enter the official identification for the premises whose data you are submitting on this webform.

Prem Type

Code for the type of business/activity done on or by the premises.
Click on the L button to display a List of Values for this field. The choices are:
FSL
Federal Slaughter Establishment
SSL
State Slaughter Establishment
CSL
Custom Slaughter Establishment
RSP
Restricted Swine Premises

Prem Name

Enter the name of the premises’ owner, the business, or the herd.

Prem City

Enter the name of the city in which the premises is located.

NR Depopulated

Enter the # of animals that were depopulated on this premises.

Indemnity Amount

Enter the total amount in U.S. Dollars of the indemnity paid to this premises for all of the
animals that were depopulated.

a. In the Prem ID field, enter the official identification for the first premises you are reporting.
i. Fill out the rest of the fields on this page with the appropriate data from your paper forms
that pertain to this premises. If you have no data to enter into a specific field, enter 0 (zero)
instead.
ii. Click on either the Save command button at the bottom of the webform or the Save icon in
the Toolbar. Doing this immediately saves all of the data you just entered for this Prem ID.
iii. Click on the New Line for Section command button.
b. In the Prem ID field, enter the official identification for the next premises you are reporting.
i. Fill out the rest of the fields on this page with the appropriate data for this second premises.
If you have no data to enter into a specific field, enter 0 (zero) instead.
ii. Click on either the Save command button or the Save icon in the Toolbar to save your data
for this second premises.
iii. Click on the New Line for Section command button.

10.13

Draft – 1 Dec 2004

Repeat Step 1.10b for each additional premises whose data you are submitting data.

After you have saved your data for the final Prem ID choice, you can do either task below:
• Switch to a different section of the webform. In order to do this:
i. In the Report Section Letter field, select the desired letter from the List of Values.
ii. Edit any of the other fields in the top block, as needed.
iii. Go directly to the step for completing this new section (see the table below):
Section A –

Do Step 1.7

Section F –

Do Step 1.13

Section K –

Do Step 1.18

Section B1 –

Do Step 1.8

Section G –

Do Step 1.14

Section L –

Do Step 1.19

Section B2 –

Do Step 1.9

Section H –

Do Step 1.15

Section M –

Do Step 1.20

Section C –

Do Step 1.10

Section I –

Do Step 1.16

Section N1 –

Do Step 1.21

Section D –

Do Step 1.11

Section J –

Do Step 1.17

Section N2 –

Do Step 1.22

Section E –

Do Step 1.12

• Exit the SPR Data-Submission webform by clicking on either the Exit command button at the
bottom of the webform or the Exit icon in the Toolbar.

10.14

Draft – 1 Dec 2004

1.11

The tabbed page labeled Section D should be displayed onscreen.

.
The table below describes what kind of data you will enter into the fields on this page.
Field

Guidelines

Dairy Herd Pending
Test or Retest *
NR Reac Herds

(* Are found at farms, ranches, and dairy establishments.)

NR MCI Herds

NR BRT Herds

NR Oth Herds

Enter the # of herds classified as INFECTED whose test/retest date was due within the
previous 0-60 days, the previous 61-180 days, or longer than >180 days.
Enter the # of herds whose test/retest date was due within the previous 0-60 days,
the previous 61-180 days, or longer than >180 days, where the reason for scheduling
the test was the traceback of an animal at a Point-of-Sale or Slaughter establishment.
Enter the # of BRT herds whose test/retest date was due within the previous 0-60 days,
the previous 61-180 days, or longer than >180 days, where the reason for scheduling
the test was due to a SUSPECT BRT interpretation.
Enter the # of Other Dairy herds whose test/retest date was due within the previous
0-60 days, the previous 61-180 days, or longer than >180 days, where the reason for
scheduling the test is due to any reason other than Reactor, MCI, or BRT herds.

Total NR Dairy
Reactor Herds

Enter the sum of the values from the 0-60, 61-180, and >180 fields in the NR Reac Herds
column.

Other Herd Pending
Test or Retest **
NR Reac Herds

(** Are found at feedlots, markets, auctions, and slaughter establishments.)

NR MCI Herds

NR BRT Herds

NR Oth Herds

Total NR Other
Reactor Herds

Enter the # of herds classified as INFECTED whose test/retest date was due within the
previous 0-60 days, the previous 61-180 days, or longer than >180 days.
Enter the # of herds whose test/retest date was due within the previous 0-60 days,
the previous 61-180 days, or longer than >180 days, where the reason for scheduling
the test was the traceback of an animal at a Point-of-Sale or Slaughter establishment.
Enter the # of BRT herds whose test/retest date was due within the previous 0-60 days,
the previous 61-180 days, or longer than >180 days, where the reason for scheduling
the test was due to a SUSPICIOUS BRT interpretation.
Enter the # of Other Dairy herds whose test/retest date was due within the previous
0-60 days, the previous 61-180 days, or longer than >180 days, where the reason for
scheduling the test is due to any reason other than those listed above for Reactor,
MCI, or BRT herds.
Enter the sum of the values from the 0-60, 61-180, and >180 fields in the NR Reac Herds
column.

a. In the Dairy Herd Pending Test or Retest block of this section, do the following:
i. In the NR Reac Herds column, enter the appropriate values from your paper forms into the
three Days Pending data fields (0-60, 61-180, and >180). If you have no data to enter into
a specific field, enter 0 (zero) instead.
ii. In the NR MCI Herds column, complete all three Days Pending fields the same way.
iii. In the NR BRT Herds column, complete all three Days Pending fields the same way.

10.15

Draft – 1 Dec 2004

iv. In the NR Oth Herds column, complete all three Days Pending fields the same way.
v. Return to the NR Reac Herds column and add the three values shown in the 0-60,
61-180, and >180 data fields. Enter this sum into the Total NR Dairy Reactor Herds
field.
For example, if the 0-60 field=8, the 61-180 field=12, and the >180 field=2, the sum
would be 22 (8+12+2). You would enter 22 into the Total NR Dairy Reactor Herds
field.
b. In the Other Herd Pending Test or Retest block of this section, do the following:
i. In the NR Reac Herds column, enter the appropriate values from your paper forms into the
three Days Pending data fields (0-60, 61-180, and >180). If you have no data to enter into
a specific field, enter 0 (zero) instead.
ii. In the NR MCI Herds column, complete all three Days Pending fields the same way.
iii. In the NR BRT Herds column, complete all three Days Pending fields the same way.
iv. In the NR Oth Herds column, complete all three Days Pending fields the same way.
v. Return to the NR Reac Herds column and add the three values shown in the 0-60,
61-180, and >180 data fields. Enter this sum into the Total NR Dairy Reactor Herds
field.
c. You can now do either action below:
• Switch to a different section of the webform. In order to do this:
i. In the Report Section Letter field, select the desired letter from the List of Values.
ii. Edit any of the other fields in the top block, as needed.
iii. Go directly to the step for completing this new section (see the table below):
Section A –

Do Step 1.7

Section F –

Do Step 1.13

Section K –

Do Step 1.18

Section B1 –

Do Step 1.8

Section G –

Do Step 1.14

Section L –

Do Step 1.19

Section B2 –

Do Step 1.9

Section H –

Do Step 1.15

Section M –

Do Step 1.20

Section C –

Do Step 1.10

Section I –

Do Step 1.16

Section N1 –

Do Step 1.21

Section D –

Do Step 1.11

Section J –

Do Step 1.17

Section N2 –

Do Step 1.22

Section E –

Do Step 1.12

• Exit the SPR Data-Submission webform by clicking on either the Exit command button at the
bottom of the webform or the Exit icon in the Toolbar.

10.16

Draft – 1 Dec 2004

1.12

The tabbed page labeled Section E should be displayed onscreen.

.
The table below describes what kind of data you will enter into the fields on this page.
Field

Guidelines

Certified Herds
NR Herds Certified

Enter the # of herds that were certified herds at the end of this report period.
Each animal disease management program uses its own terminology to identify a herd as
having "certified" status, as shown in the table below:
Program Name

Herd Type

BR Program

Bovine herds
Porcine herds
Porcine herds
Bovine herds
Bovine herds

PRV Program
JOH Program
TB Program

Term Used to Indicate
"Certified" Status
CERTified Free
VALIDated Free
Class 5
JPL4
ACCREDited

sdfd

a. Fill out the field on this page with the appropriate data from your paper forms. If you have no data
to enter into this field, enter 0 (zero) instead.
b. Click on either the Save command button or the Save icon.
c. You can now do either action below:
• Switch to a different section of the webform. In order to do this:
i. In the Report Section Letter field, select the desired letter from the List of Values.
ii. Edit any of the other fields in the top block, as needed.
iii. Go directly to the step for completing this new section (see the table below):
Section A –

Do Step 1.7

Section F –

Do Step 1.13

Section K –

Do Step 1.18

Section B1 –

Do Step 1.8

Section G –

Do Step 1.14

Section L –

Do Step 1.19

Section B2 –

Do Step 1.9

Section H –

Do Step 1.15

Section M –

Do Step 1.20

Section C –

Do Step 1.10

Section I –

Do Step 1.16

Section N1 –

Do Step 1.21

Section D –

Do Step 1.11

Section J –

Do Step 1.17

Section N2 –

Do Step 1.22

Section E –

Do Step 1.12

• Exit the SPR Data-Submission webform by clicking on either the Exit command button at the
bottom of the webform or the Exit icon in the Toolbar.

10.17

Draft – 1 Dec 2004

1.13

The tabbed page labeled Section F should be displayed onscreen.

.
The table below describes what kind of data you will enter into the fields on this page.
Field

Guidelines

Species

Code for the species being reported in this section of the webform.
Click on the L button to display a List of Values for this field.

NR Herds Tested

Enter the # of herds that were tested during this report period.

NR Animals Tested

Enter the # of animals that were tested during this report period.

NR Suspects

Enter the # of animals that were assigned SUSPECT status during this report period.

NR Herds w/Reactors

Enter the # of herds in which reactor animals were found during this report period.

NR Reactors

Enter the # of animals that were assigned REACTOR status during this report period.

a. In the Species field, select an animal species whose data you are submitting from the List of
Values.
i. Fill out the rest of the fields on this page with the appropriate data from your paper forms
that pertain to this species. If you have no data to enter into a specific field, enter 0 (zero)
instead.
ii. Click on either the Save command button at the bottom of the webform or the Save icon in
the Toolbar. Doing this immediately saves all of the data you just entered for this species.
iii. Click on the New Line for Section command button.
b. In the Species field, select the next species for which you are submitting data.
i. Fill out the rest of the fields on this page with the appropriate data for this second species.
If you have no data for a specific field, enter 0 (zero) instead.
ii. Click on either the Save command button or the Save icon in the Toolbar to save your data
for this second species.
iii. Click on the New Line for Section command button.
c. Repeat Step 1.13b for each additional species for which you want to submit data.

10.18

Draft – 1 Dec 2004

d. After you have saved the data for your final Species choice, you can do either action below:
• Switch to a different section of the webform. In order to do this:
i. In the Report Section Letter field, select the desired letter from the List of Values.
ii. Edit any of the other fields in the top block, as needed.
iii. Go directly to the step for completing this new section (see the table below):
Section A –

Do Step 1.7

Section F –

Do Step 1.13

Section K –

Do Step 1.18

Section B1 –

Do Step 1.8

Section G –

Do Step 1.14

Section L –

Do Step 1.19

Section B2 –

Do Step 1.9

Section H –

Do Step 1.15

Section M –

Do Step 1.20

Section C –

Do Step 1.10

Section I –

Do Step 1.16

Section N1 –

Do Step 1.21

Section D –

Do Step 1.11

Section J –

Do Step 1.17

Section N2 –

Do Step 1.22

Section E –

Do Step 1.12

• Exit the SPR Data-Submission webform by clicking on either the Exit command button at the
bottom of the webform or the Exit icon in the Toolbar.

10.19

Draft – 1 Dec 2004

1.14

The tabbed page labeled Section G should be displayed onscreen.

.
The table below describes what kind of data you will enter into the fields on this page.
Field

Guidelines

Prem ID

Enter the official identification for the premises whose data you are submitting on this webform.

Paycode

Code for the source of payment for an event.
Click on the L button to display a List of Values for this field. The choices are:
NA
Not applicable
0
Federal Meat Inspector
1
Federal Employee
2
Fed Fee Basis or independent contractor
3
Sate/county employee
4
Owner expense
5
State Fee Basis or state independent contractor
6
VS contract with establishment
7
State contract with establishment

NR Animals Tested

Enter the # of animals slaughtered at the establishment that were tested during this report
period.

NR Eligible

Enter the # of animals slaughtered at the establishment that were eligible to be tested.

a. In the Prem ID field, enter the official identification for the first premises you are reporting.
i. Fill out the rest of the fields on this page with the appropriate data from your paper forms
that pertain to this premises. If you have no data to enter into a specific field, enter 0 (zero)
instead.
ii. Click on either the Save command button at the bottom of the webform or the Save icon in
the Toolbar. Doing this immediately saves all of the data you just entered for this Prem ID.
iii. Click on the New Line for Section command button.
b. In the Prem ID field, enter the official identification for the next premises you are reporting.
i. Fill out the rest of the fields on this page with the appropriate data for this second premises.
If you have no data to enter into a specific field, enter 0 (zero) instead.
ii. Click on either the Save command button or the Save icon in the Toolbar to save the data
for this second premises.
iii. Click on the New Line for Section command button.

10.20

Draft – 1 Dec 2004

c. Repeat Step 1.14b for each additional premises whose data you are submitting.
d. After you have saved your data for the final Prem ID choice, you can do either task below:
• Switch to a different section of the webform. In order to do this:
i. In the Report Section Letter field, select the desired letter from the List of Values.
ii. Edit any of the other fields in the top block, as needed.
iii. Go directly to the step for completing this new section (see the table below):
Section A –

Do Step 1.7

Section F –

Do Step 1.13

Section K –

Do Step 1.18

Section B1 –

Do Step 1.8

Section G –

Do Step 1.14

Section L –

Do Step 1.19

Section B2 –

Do Step 1.9

Section H –

Do Step 1.15

Section M –

Do Step 1.20

Section C –

Do Step 1.10

Section I –

Do Step 1.16

Section N1 –

Do Step 1.21

Section D –

Do Step 1.11

Section J –

Do Step 1.17

Section N2 –

Do Step 1.22

Section E –

Do Step 1.12

• Exit the SPR Data-Submission webform by clicking on either the Exit command button at the
bottom of the webform or the Exit icon in the Toolbar.

10.21

Draft – 1 Dec 2004

1.15

The tabbed page labeled Section H should be displayed onscreen.

.
The table below describes what kind of data you will enter into the fields on this page.
Field

Guidelines

NR Animals at Instate
Markets

Enter the # of animals for which valid blood tests were performed on samples collected at
instate markets.

NR Reactors at Instate
Markets

Enter the # of animals for which valid blood tests were performed on samples collected at
instate markets, and for which the test interpretation was either REACTOR or POSITIVE.

NR Animals at Instate
Slaughter

Enter the # of animals for which valid blood tests were performed on samples collected at
instate slaughter establishments.

NR Reactors at Instate
Slaughter

Enter the # of animals for which valid blood tests were performed on samples collected at
instate slaughter establishments, and for which the test interpretation was either REACTOR
or POSITIVE.

NR Reactors Reported
by other States

Enter the # of not-NEGATIVE animals claimed by another State to have originated in the
reporting State for which valid blood tests were performed on samples collected at markets or
slaughter establishments in the other State, which the reporting State has decided to trace to
a herd of origin.

a. Fill out the fields on this page with the appropriate data from your paper forms. If you have no
data to enter into a specific field, enter 0 (zero) instead.
b. Click on either the Save command button or the Save icon.
c. You can now do either action below:
• Switch to a different section of the webform. In order to do this:
i. In the Report Section Letter field, select the desired letter from the List of Values.
ii. Edit any of the other fields in the top block, as needed.
iii. Go directly to the step for completing this new section (see the table below):
Section A –

Do Step 1.7

Section F –

Do Step 1.13

Section K –

Do Step 1.18

Section B1 –

Do Step 1.8

Section G –

Do Step 1.14

Section L –

Do Step 1.19

Section B2 –

Do Step 1.9

Section H –

Do Step 1.15

Section M –

Do Step 1.20

Section C –

Do Step 1.10

Section I –

Do Step 1.16

Section N1 –

Do Step 1.21

Section D –

Do Step 1.11

Section J –

Do Step 1.17

Section N2 –

Do Step 1.22

Section E –

Do Step 1.12

• Exit the SPR Data-Submission webform by clicking on either the Exit command button at the
bottom of the webform or the Exit icon in the Toolbar.

10.22

Draft – 1 Dec 2004

1.16

The tabbed page labeled Section I should be displayed onscreen.

.
The table below describes what kind of data you will enter into the fields on this page.
Field

Guidelines

Pending <31

Enter the # of MCI traces that are currently open and which are 30 days or less since the initiation date of
the trace.

Pending >30

Enter the # of MCI traces that are currently open and which are more than 30 days since the initiation date
of the trace.

TRC

Enter the # of MCI traces that were closed as TRACED RECLASSIFIED during this report period.

TNR

Enter the # of MCI traces that were closed as TRACED NOT REQUIRED during this report period.

TRH

Enter the # of MCI traces that were closed as being traced to a KNOWN REACTOR HERD during this
report period.

TTR

Enter the # of MCI traces that were closed as TRACED AND TEST RECOMMENDED during this report
period.

TTN

Enter the # of MCI traces that were closed as TRACED AND TEST NOT RECOMMENDED during this
report period.

TSH

Enter the # of MCI traces that were closed as TRACED TO A SOLDOUT HERD during this report period.

TOS

Enter the # of MCI traces that were closed as TRACED OUT OF STATE during this report period.

Total
Successful

Enter the # of MCI traces that were successfully closed during this report period.

Enter the # of MCI traces that were closed as TRACED TO A DEALER during this report period.

Enter the # of MCI traces that were closed as TRACED TO A FEEDLOT during this report period.

Enter the # of MCI traces that were closed as UNABLE TO TRACE during this report period.

Total
Unsuccessful

Enter the # of MCI traces that were not successfully closed during this report period.

10.23

Draft – 1 Dec 2004

a. Fill out the fields on this page with the appropriate data from your paper forms. If you have no
data to enter into a specific field, enter 0 (zero) instead.
b. Click on either the Save command button or the Save icon.
c. You can now do either action below:
• Switch to a different section of the webform. In order to do this:
i. In the Report Section Letter field, select the desired letter from the List of Values.
ii. Edit any of the other fields in the top block, as needed.
iii. Go directly to the step for completing this new section (see the table below):
Section A –

Do Step 1.7

Section F –

Do Step 1.13

Section K –

Do Step 1.18

Section B1 –

Do Step 1.8

Section G –

Do Step 1.14

Section L –

Do Step 1.19

Section B2 –

Do Step 1.9

Section H –

Do Step 1.15

Section M –

Do Step 1.20

Section C –

Do Step 1.10

Section I –

Do Step 1.16

Section N1 –

Do Step 1.21

Section D –

Do Step 1.11

Section J –

Do Step 1.17

Section N2 –

Do Step 1.22

Section E –

Do Step 1.12

• Exit the SPR Data-Submission webform by clicking on either the Exit command button at the
bottom of the webform or the Exit icon in the Toolbar.

10.24

Draft – 1 Dec 2004

1.17

The tabbed page labeled Section J should be displayed onscreen.

The table below describes what kind of data you will enter into the fields on this page.
Field

Guidelines

Round NR

Enter the # of the BRT round whose data is being reported in this section of the webform.

Total Eligible

Enter the total # of herds which were classified as ACCOUNTED FOR, MISSING,
NEGATIVE, and SUSPICIOUS during this BRT round.

NR New Herds

Enter the # of herds which participated in their first BRT collection during this BRT round.

NR Herds OOB

Enter the # of herds that went OUT OF BUSINESS (ceased operations) during this BRT
round.

NR Herds Accounted For

Enter the # of herds for which no sample was collected during this BRT round because the
entire herd is temporarily not producing milk.

NR Herds Missing

Enter the # of herds for which no valid BRT was tested during this round for various
reasons (a herd's milk sample was dry, insufficient, or sour, for example), but for which a
sample should have been available.

NR Herds Neg

Enter the # of herds in the State with a round interpretation of NEGATIVE for the round.
(Each subject herd is counted only once, regardless of the number of times it was tested
during the round, and cannot have had a SUSPICIOUS interpretation on any BRT during
the round.)

NR Herds Suspicious

Enter the # of herds in the State with a round interpretation of SUSPICIOUS in at least one
round during the year. (Each subject herd is counted only once, regardless of the number
of times it was tested during the round.)

Total Herds Tested

Enter the # of herds that received a NEGATIVE or SUSPICIOUS BRT interpretation during
this BRT round.

10.25

Draft – 1 Dec 2004

a. Fill out the fields on this page with the appropriate data from your paper forms. If you have no
data to enter into a specific field, enter 0 (zero) instead.
b. Click on either the Save command button or the Save icon.
c. You can now do either action below:
• Switch to a different section of the webform. In order to do this:
i. In the Report Section Letter field, select the desired letter from the List of Values.
ii. Edit any of the other fields in the top block, as needed.
iii. Go directly to the step for completing this new section (see the table below):
Section A –

Do Step 1.7

Section F –

Do Step 1.13

Section K –

Do Step 1.18

Section B1 –

Do Step 1.8

Section G –

Do Step 1.14

Section L –

Do Step 1.19

Section B2 –

Do Step 1.9

Section H –

Do Step 1.15

Section M –

Do Step 1.20

Section C –

Do Step 1.10

Section I –

Do Step 1.16

Section N1 –

Do Step 1.21

Section D –

Do Step 1.11

Section J –

Do Step 1.17

Section N2 –

Do Step 1.22

Section E –

Do Step 1.12

• Exit the SPR Data-Submission webform by clicking on either the Exit command button at the
bottom of the webform or the Exit icon in the Toolbar.

10.26

Draft – 1 Dec 2004

1.18

The tabbed page labeled Section K should be displayed onscreen.

.
The table below describes what kind of data you will enter into the fields on this page.
Field

Guidelines

NR Herds Vaccinated
VAC Juv
VAC Adult
VAC Age Not Specified

Enter the # of herds in which juvenile animals were vaccinated.
Enter the # of herds in which adult animals were vaccinated.
Enter the # of herds in which animals of unknown age were vaccinated.

NR Animals Vaccinated
VAC Juv
VAC Adult
VAC Age Not Specified

Enter the # of juvenile animals which were vaccinated during this report period.
Enter the # of adult animals which were vaccinated during this report period.
Enter the # of animals of unknown age which were vaccinated during this report period.

Note: Each animal disease management program will have its own guidelines for distinguishing between juvenile and
adult animals, so be sure to verify this information.

a. Fill out the fields on this page with the appropriate data from your paper forms. If you have no data
to enter into a specific field, enter 0 (zero) instead.
b. Click on either the Save command button or the Save icon.
c. Yu can now do either action below:
• Switch to a different section of the webform. In order to do this:
i. In the Report Section Letter field, select the desired letter from the List of Values.
ii. Edit any of the other fields in the top block, as needed.
iii. Go directly to the step for completing this new section (see the table below):
Section A –

Do Step 1.7

Section F –

Do Step 1.13

Section K –

Do Step 1.18

Section B1 –

Do Step 1.8

Section G –

Do Step 1.14

Section L –

Do Step 1.19

Section B2 –

Do Step 1.9

Section H –

Do Step 1.15

Section M –

Do Step 1.20

Section C –

Do Step 1.10

Section I –

Do Step 1.16

Section N1 –

Do Step 1.21

Section D –

Do Step 1.11

Section J –

Do Step 1.17

Section N2 –

Do Step 1.22

Section E –

Do Step 1.12

• Exit the SPR Data-Submission webform by clicking on either the Exit command button at the
bottom of the webform or the Exit icon in the Toolbar.

10.27

Draft – 1 Dec 2004

1.19

The tabbed page labeled Section L should be displayed onscreen.

The table below describes what kind of data you will enter into the fields on this page.
Field

Guidelines

Purchased Infected
Animals

Enter the # of herds for which, during the report period, the source of infection was
recorded as the PURCHASE OF INFECTED ANIMALS.

Exposed to Non-Domestic
Animals

Enter the # of herds for which, during the report period, the source of infection was
recorded as EXPOSURE TO NON-DOMESTIC ANIMALS.

Area Spread

Enter the # of herds for which, during the report period, the source of infection was
recorded as PROBABLE EXPOSURE TO OTHER INFECTED HERDS OR SOURCES
WITHIN THEIR COMMUNITY.

Other

Enter the # of herds for which, during the report period, the source of infection was
recorded as EXPOSURE TO KNOWN SOURCES (other than the three listed directly
above in this table).

Unknown

Enter the # of herds for which, during the report period, the source of infection was
recorded as UNKNOWN.

a. Fill out the fields on this page with the appropriate data from your paper forms. If you have no data
to enter into a specific field, enter 0 (zero) instead.
b. Click on either the Save command button or the Save icon.
c. Yu can now do either action below:
• Switch to a different section of the webform. In order to do this:
i. In the Report Section Letter field, select the desired letter from the List of Values.
ii. Edit any of the other fields in the top block, as needed.
iii. Go directly to the step for completing this new section (see the table below):
Section A –

Do Step 1.7

Section F –

Do Step 1.13

Section K –

Do Step 1.18

Section B1 –

Do Step 1.8

Section G –

Do Step 1.14

Section L –

Do Step 1.19

Section B2 –

Do Step 1.9

Section H –

Do Step 1.15

Section M –

Do Step 1.20

Section C –

Do Step 1.10

Section I –

Do Step 1.16

Section N1 –

Do Step 1.21

Section D –

Do Step 1.11

Section J –

Do Step 1.17

Section N2 –

Do Step 1.22

Section E –

Do Step 1.12

• Exit the SPR Data-Submission webform by clicking on either the Exit command button at the
bottom of the webform or the Exit icon in the Toolbar.

10.28

Draft – 1 Dec 2004

1.20

The tabbed page labeled Section M should be displayed onscreen.

The table below describes what kind of data you will enter into the fields on this page.
Field

Guidelines

Herd Type

Code for the types of herds being reported during this report period.
Click on the L button to display a List of Values for this field. The choices are:
Dairy-Part A
(DRY)
NonDairy-Part B
(any farm code other than DRY)

Program Level 1 Begin

Assess
Herd Plans
JPL1
JPL2
JPL3
JPL4
JPLM

Program Level 2 Add/Renew

Assess
Herd Plans
JPL1
JPL2
JPL3
JPL4
JPLM

Program Level 3 Removed

Assess
Herd Plans
JPL1
JPL2
JPL3
JPL4

Enter the # of herds for which a Risk Assessment (RA) is in effect at the beginning of the
report period.
Enter the # of herds for which a Herd Plan is in effect at the beginning of the report period.
Enter the # of herds that were at Status Level JPL1 at the beginning of the report period.
Enter the # of herds that were at Status Level JPL2 at the beginning of the report period.
Enter the # of herds that were at Status Level JPL3 at the beginning of the report period.
Enter the # of herds that were at Status Level JPL4 at the beginning of the report period.
Enter the # of herds in the Monitoring Program at the beginning of the report period.
Enter the # of herds for which a Risk Assessment (RA) was accomplished during the
report period.
Enter the # of herds for which a Herd Plan was accomplished during the report period.
Enter the # of herds that were added to or requalified for Status Level JPL1 during the
report period.
Enter the # of herds that were added to or requalified for Status Level JPL2 during the
report period.
Enter the # of herds that were added to or requalified for Status Level JPL3 during the
report period.
Enter the # of herds that were added to or requalified for Status Level JPL4 during the
report period.
Enter the # of herds in the Monitoring Program during the report period.
Enter the # of herds for which a Risk Assessment (RA) expired during the report period
and was not renewed.
Enter the # of herds for which a Herd Plan expired during the report period and was not
renewed.
Enter the # of herds that were removed from Status Level JPL1 during the report period. **
Enter the # of herds that were removed from Status Level JPL2 during the report period. **
Enter the # of herds that were removed from Status Level JPL3 during the report period. **
Enter the # of herds that were removed from Status Level JPL4 during the report period. **
** (These herds may have moved to a different Status Level or dropped out of the
Test Neg Program).

JPLM

Enter the # of herds that dropped out of the Monitoring Program during the report period.

10.29

Draft – 1 Dec 2004

Program Level 4 End

Assess
Herd Plans
JPL1
JPL2
JPL3
JPL4
JPLM

Enter the # of herds for which a Risk Assessment (RA) is in effect at the end of the
report period.
Enter the # of herds for which a Herd Plan is in effect at the end of the report period.
Enter the # of herds at Status Level JPL1 status at the end of the report period.
Enter the # of herds at Status Level JPL2 status at the end of the report period.
Enter the # of herds at Status Level JPL3 status at the end of the report period.
Enter the # of herds at Status Level JPL4 status at the end of the report period.
Enter the # of herds in the Monitoring Program at the end of the report period.

a. In the Herd Type field, select DAIRY-PART A (DRY) in the List of Values.
i. Fill out the rest of the fields on this page with the appropriate data from your paper forms
that pertain to the (DRY) herd type. If you have no data to enter into a specific field, enter
0 (zero) instead.
ii. Click on either the Save command button at the bottom of the webform or the Save icon in
the Toolbar. Doing this immediately saves all of the data you just entered for the (DRY)
herd type.
iii. Click on the New Line for Section command button.
b. In the Herd Type field, select NONDAIRY-PART B in the List of Values.
i. Fill out all of the fields with the data from your paper forms for this second herd type. If
you have no data to enter into a specific field, enter 0 (zero) instead.
ii. Click on either the Save command button or the Save icon to save your data for this second
herd type.
c. After you have saved the data for both herd types, you can do either action below:
• Switch to a different section of the webform. In order to do this:
i. In the Report Section Letter field, select the desired letter from the List of Values.
ii. Edit any of the other fields in the top block, as needed.
iii. Go directly to the step for completing this new section (see the table below):
Section A –

Do Step 1.7

Section F –

Do Step 1.13

Section K –

Do Step 1.18

Section B1 –

Do Step 1.8

Section G –

Do Step 1.14

Section L –

Do Step 1.19

Section B2 –

Do Step 1.9

Section H –

Do Step 1.15

Section M –

Do Step 1.20

Section C –

Do Step 1.10

Section I –

Do Step 1.16

Section N1 –

Do Step 1.21

Section D –

Do Step 1.11

Section J –

Do Step 1.17

Section N2 –

Do Step 1.22

Section E –

Do Step 1.12

• Exit the SPR Data-Submission webform by clicking on either the Exit command button at the
bottom of the webform or the Exit icon in the Toolbar.

10.30

Draft – 1 Dec 2004

1.21

The tabbed page labeled Section N1 should be displayed onscreen.

.
The table below describes what kind of data you will enter into the fields on this page.
Field

Guidelines

Species

Code for the species being reported on this webform.
Click on the L button to display a List of Values for this field.

Part A: Dairy Herds Tested *

(* Are those premises whose primary purpose is the production of milk.)

NR Herds Tested
NR Herds Positive
Part A: Non-Dairy Herds Tested **

NR Herds Tested
NR Herds Positive

Enter the # of herds that were tested during this report period.
Enter the # of herds that tested positive during this report period.
(** Are all other farm-type premises. These herds are not markets, slaughter
establishments (Federal, State, or Custom), restricted swine premises
(backyard slaughter), or milk-processing facilities.)
Enter the # of herds that were tested during this report period.
Enter the # of herds that tested positive during this report period.

a. In the Species field, select from the List of Values an animal species for which you are submitting
data.
i. Fill out the rest of the fields on this page with the appropriate data from your paper forms
that pertain to this species. If you have no data to enter into a specific field, enter 0 (zero)
instead.
ii. Click on either the Save command button at the bottom of the webform or the Save icon in
the Toolbar. Doing this immediately saves all of the data you just entered for this species.
iii. Click on the New Line for Section command button.
b. In the Species field, select the next species for which you are submitting data.
i. Fill out the rest of the fields on this page with the appropriate data for this second species.
If you have no data to enter into a specific field, enter 0 (zero) instead.
ii. Click on either the Save command button or the Save icon in the Toolbar to save your data
for this second species.
iii. Click on the New Line for Section command button.

10.31

Draft – 1 Dec 2004

c. Repeat Step 1.21b for each additional species whose data you are submitting.
d. After you have saved the data for your final Species choice, you can do either action below:
• Switch to a different section of the webform. In order to do this:
i. In the Report Section Letter field, select the desired letter from the List of Values.
ii. Edit any of the other fields in the top block, as needed.
iii. Go directly to the step for completing this new section (see the table below):
Section A –

Do Step 1.7

Section F –

Do Step 1.13

Section K –

Do Step 1.18

Section B1 –

Do Step 1.8

Section G –

Do Step 1.14

Section L –

Do Step 1.19

Section B2 –

Do Step 1.9

Section H –

Do Step 1.15

Section M –

Do Step 1.20

Section C –

Do Step 1.10

Section I –

Do Step 1.16

Section N1 –

Do Step 1.21

Section D –

Do Step 1.11

Section J –

Do Step 1.17

Section N2 –

Do Step 1.22

Section E –

Do Step 1.12

• Exit the SPR Data-Submission webform by clicking on either the Exit command button at the
bottom of the webform or the Exit icon in the Toolbar.

10.32

Draft – 1 Dec 2004

1.22

The tabbed page labeled Section N2 should be displayed onscreen.

The table below describes what kind of data you will enter into the fields on this page.
Field

Guidelines

Species

Code for the species being reported on this webform.
Click on the L button to display a List of Values for this field.

Test Type

Codes for the types of tests that were performed during this report period.
Click on the L button to display a List of Values for this field. The choices are:
ELS
Elisa
FCUL
Fecal culture; for indiv, not group record
JOHNIN
Skin Test
GIN
Gamma Inteferon
PCR
Polymerase Chain Reaction

Dairy *

(* Are those premises whose primary purpose is the production of milk.)

Nr Herds Tested
Nr Animals Tested
Nr Positive Tested
Nr Suspect Tested
Nr Inconclusive Tested

Non-Dairy **

Nr Herds Tested
Nr Animals Tested
Nr Positive Tested
Nr Suspect Tested
Nr Inconclusive Tested

Enter the # of dairy herds that were given the Test Type specified.
Enter the # of dairy animals that were given the Test Type specified.
Enter the # of dairy animals that were given the Test Type specified and whose test
interpretations were classified as POSITIVE.
Enter the # of dairy animals that were given the Test Type specified and whose test
interpretations were classified as SUSPECT.
Enter the # of dairy animals that were given the Test Type specified and whose test
interpretations were classified as INCONCLUSIVE.
(** Are all other farm-type premises. These herds are not markets, slaughter
establishments (Federal, State, or Custom), restricted swine premises (backyard
slaughter), or milk-processing facilities.)
Enter the # of non-dairy herds that were given the Test Type specified.
Enter the # of non-dairy animals that were given the Test Type specified.
Enter the # of non-dairy animals that were given the Test Type specified and whose test
interpretations were classified as POSITIVE.
Enter the # of non-dairy animals that were given the Test Type specified and whose test
interpretations were classified as SUSPECT.
Enter the # of non-dairy animals that were given the Test Type specified and whose test
interpretations were classified as INCONCLUSIVE.

10.33

Draft – 1 Dec 2004

a. In the Species field, select an animal species whose data you are submitting from the List of
Values.
i. Fill out the rest of the fields on this page with the appropriate data from your paper forms
that pertain to this species. If you have no data to enter into a specific field, enter 0 (zero)
instead.
ii. Click on either the Save command button at the bottom of the webform or the Save icon in
the Toolbar. Doing this immediately saves all of the data you just entered for this species.
iii. Click on the New Line for Section command button.
b. In the Species field, select the next species for which you are submitting data.
i. Fill out the rest of the fields on this page with the appropriate data for this second species.
If you have no data for a specific field, enter 0 (zero) instead.
ii. Click on either the Save command button or the Save icon in the Toolbar to save your data
for this second species.
iii. Click on the New Line for Section command button.
c. Repeat Step 1.22b for each additional species whose data you are submitting.
d. After you have saved your data for the final Species choice, you can do either action below:
• Switch to a different section of the webform. In order to do this:
i. In the Report Section Letter field, select the desired letter from the List of Values.
ii. Edit any of the other fields in the top block, as needed.
iii. Go directly to the step for completing this new section (see the table below):
Section A –

Do Step 1.7

Section F –

Do Step 1.13

Section K –

Do Step 1.18

Section B1 –

Do Step 1.8

Section G –

Do Step 1.14

Section L –

Do Step 1.19

Section B2 –

Do Step 1.9

Section H –

Do Step 1.15

Section M –

Do Step 1.20

Section C –

Do Step 1.10

Section I –

Do Step 1.16

Section N1 –

Do Step 1.21

Section D –

Do Step 1.11

Section J –

Do Step 1.17

Section N2 –

Do Step 1.22

Section E –

Do Step 1.12

• Exit the SPR Data-Submission webform by clicking on either the Exit command button at the
bottom of the webform or the Exit icon in the Toolbar.

10.34

Chapter 11:
Updating Your State's Data for an
SPR National Report
This chapter covers the procedures for updating your State's Brucellosis and Johne's disease program data, using a
set of customized SPR Query webforms available at the AWBDS web site.
You can perform these procedures as long as the Quality Control (QC) person for your State has not yet approved
your State's monthly Brucellosis or Johnes summary data.
The topics in this chapter appear below:
Topic

See Page

Introduction
When Not to Update Your SPR Data

11.2
11.2

Procedure 1: Updating Your State's Data, by Using the SPR Query Webforms

11.3

Procedure 2: Using the Auto-Scheduler to Process Your Updated Data

11.55

Reference Table 1: Organized by Report Section Letter

11.59

Reference Table 2: Organized by Data Field Labels

11.65

11.1

Draft – 1 Dec 2004

Introduction
The AWBDS process allows you to modify, if necessary, the data you have submitted for your State's Brucellosis or
Johne's disease program. You accomplish this by filling out a customized SPR Query webform. There are sixteen
of these customized Query webforms, one for each of the sixteen sections in the SPR report. The values you enter
on a Query webform will be used to find any SPR Data-Submission records that are stored in a Temporary Holding
Database. If any SPR Data-Submission records in the database match the values on your Query webform, these
records are retrieved and displayed onscreen, one at a time, within the Query webform. You can view, print, and
modify these records right there within the Query webform itself.
You can query for, retrieve, and modify your State's SPR Data-Submission records at any time, as long as the data
has not yet been approved by your State's QC personnel. Once a QC representative approves any of your State's
SPR Data-Submission records, the data is moved from the Temporary Holding Database to a permanent National
Reports Database. After this move occurs, the data can no longer be retrieved for the purposes of modifying it.
The procedure on the next page will show you how to use the SPR Query webforms.

When Not to Update Your SPR Data
In Chapter 1, you learned that the Auto-Scheduler utility is pre-programmed to routinely do its three tasks on the 5th
day of every month. If by this date, your State:
• has finished submitting its program data for the previous month/quarter, the Auto-Scheduler will generate the
appropriate reports, e-mail them to QA personnel, and transfer the data to the Temporary Holding Database.
• has not finished/finished submitting its program data, the Auto-Scheduler will still generate, e-mail, and
transfer the appropriate reports, but these reports will be null (containing only zeros).
To avoid potential processing and data errors, do not attempt to update a null SPR report. Instead, you should
delete it (see Chapter 12) and submit your data again in a new Data-Submission webform (see Chapter 10).
The reason you should not try to do this kind of update is that, for a null report the Auto-Scheduler creates only one
Line or Prem Type in a report section, with all zeroes. For example, your State has SPR data for three different
Prem Types in Section G, but the data did not get entered before the 5th deadline. The Auto-Scheduler will create a
Section G report with null values for just one of those Prem Types. Several days later, you try to use a Query
webform to correct the null data in this report as well as add new data for the other two Prem Types. You could
update one Prem Type – but the system will not allow you to enter the additional Prem Types except in the DataSubmission webform. It will be easier and safer to just delete the null report file and to enter all the data for the
report section at one time in a new Data-Submission webform.

11.2

Draft – 1 Dec 2004

Procedure for Updating Your State's Data, by
Using the SPR Query Webforms
This procedure describes how to use the sixteen customized SPR Query webforms to retrieve data, modify it, and
save it back into the Temporary Holding Database. During a single work session, you can work in as few or as
many sections as you wish.

1.1

If necessary, log into the AWBDS web site.

1.2

The Veterinary Services National Surveillance Program
Reports main menu screen (shown at right) will appear.
In this screen, click on the Enter Summary Data option.

1.3

The National Reports Summary Data Entry Forms main
menu screen (shown at right) now appears.
In this screen, click on the [3] button next to the SPR –
Standard Program Reports (incl BR, JOH) option.

11.3

Draft – 1 Dec 2004

1.4

1.5

A blank SPR Header Information Data-Submission webform will appear.

In the Report Section Letter field in the top block, do the following:
a. Click on the L to display a List of Values. In this list, you will see three query form choices:
Query Form

Use This Form to Retrieve Data-Submission Records Containing Data on:

Query_A
Query_B1
Query_B2
Query_C
Query_D
Query_E
Query_F
Query_G
Query_H
Query_I
Query_J
Query_K
Query_L
Query_M
Query_N1
Query_N2

Test results for cattle that were tested on farms and ranches
Affected herds in your State
Affected herds in your State
Herds that have been depopulated
Herds that are due for testing/retesting
Herds that have been certified Brucellosis-Free
Blood tests done on other species
MCI blood sample collections done at slaughter establishments
MCI blood sample collections done on market cattle/bison which were tested instate
Traceback investigations done on MCI animals that were classified as REACTORS
BRT activities that were performed during a specified BRT round
Vaccination information on calves and cattle
Probable sources of infection in new herds
Program status of herds in your State
Herds affected by Johne's in your State
Types of Johne's tests that were performed on animals and herds in your State

b. In this list, select the query form you want to use.
c. Click OK.
The List of Values disappears. The option you selected now appears in the Report Section Letter
field.
d. Press ENTER.

11.4

Draft – 1 Dec 2004

e. If you selected:
Section A only

Step 1.1 through Step 1.6

Section B1 only

Step 1.1 through Step 1.5, then Step 1.7

Section B2 only

Step 1.1 through Step 1.5, then Step 1.8

Section C only

Step 1.1 through Step 1.5, then Step 1.9

Section D only

Step 1.1 through Step 1.5, then Step 1.10

Section E only

Step 1.1 through Step 1.5, then Step 1.11

Section F only

Step 1.1 through Step 1.5, then Step 1.12

Section G only

Step 1.1 through Step 1.5, then Step 1.13

Section H only

Step 1.1 through Step 1.5, then Step 1.14

Section I only

Step 1.1 through Step 1.5, then Step 1.15

Section J only

Step 1.1 through Step 1.5, then Step 1.16

Section K only

Step 1.1 through Step 1.5, then Step 1.17

Section L only

Step 1.1 through Step 1.5, then Step 1.18

Section M only

Step 1.1 through Step 1.5, then Step 1.19

Section N1 only

Step 1.1 through Step 1.5, then Step 1.20

Section N2 only

Step 1.1 through Step 1.5, then Step 1.21

11.5

Draft – 1 Dec 2004

1.6

If you selected Query_A, you should now see the following Query webform onscreen. This webform has
been customized for Section A of the SPR report:

In case any of the field labels on this query form are unclear, refer to the table below. (For detailed
information about what data can appear in a specific field, refer to the tables at the end of this chapter.)
Field Label on
Query Form
Rpt Id
Sectn
St
Dz
Stg
Sp
Dt Beg
Dt End
Run Dt
Rec Type
Event(test) reason
Herds tested fed
expense
Animals tested fed
expense
Herds tested fed fee
basis expense
Animals tested fed
fee basis expense
Herds tested state
expense
Animals tested state
expense
Herds tested state
fee basis expense
Animals tested state
fee basis expense
Herds tested owner
expense

Field Label on
Data-Submission Form
(Not found on D-S Form)
Report Section Letter
State
Disease
Stage
Species
Begin Date
End Date
Report Run Date
(Not found on D-S Form)
Test Reason
Fed Expense
Herds
Fed Expense
Animals
Fed Fee Basis Expense
Herds
Fed Fee Basis Expense
Animals
State Expense
Herds
State Expense
Animals
State Fee Basis Expense
Herds
State Fee Basis Expense
Animals
Owner Expense
Herds

Data Stored in This Field
on Both Forms
Default=SPR
Default=A
Code for the State in which the data-collection activity took place.
Code for the disease whose data was submitted.
Stage level that your State was in during this reporting period.
Code for the animal species whose test results was submitted.
First date of the time period whose data was submitted.
Last date of the time period whose data was submitted.
Date on which your State's data was submitted.
Default=WEB
Code for the reason the herd(s) or animal(s) were tested.
Total # of herds whose testing costs were reimbursed at Federal
expense.
Total # of animals whose testing costs were reimbursed at Federal
expense.
Total # of herds whose testing costs were reimbursed at Federal Fee
Basis expense.
Total # of animals whose testing costs were reimbursed at Federal
Fee Basis expense.
Total # of herds whose testing costs were reimbursed at State
expense.
Total # of animals whose testing costs were reimbursed at State
expense.
Total # of herds whose testing costs were reimbursed at State Fee
Basis expense.
Total # of animals whose testing costs were reimbursed at State Fee
Basis expense.
Total # of herds whose testing costs were reimbursed at Owner
expense.

11.6

Draft – 1 Dec 2004

Animals tested
owner expense
Total herds tested
Total animals tested

Total # of animals whose testing costs were reimbursed at Owner
expense.
Total # of herds that were tested during this reporting period.
Total # of animals that were tested during this reporting period.

Owner Expense
Animals
Total Herds Tested
Total Animals Tested

a. To retrieve a record that you want to view and/or update, insert one or more search values into the
field(s) on this query form.
If you are not sure how to spell a search value, use the per cent symbol (%) wildcard to replace
the letters that you don't know. See the chart below for examples on how to use this wildcard:
To Search For:

Type This:

And Get These Results:

animal species codes that
begin with the letter "B"

BOV
BOV

(cattle)
(bison)

all disease codes

%
(in Dz field)

BR
EIA
JOH

(Brucellosis)
(Equine Infectious Anemia)
(Johne's)

all Prem Types that end with
the letters "SL"

%SL

CSL
FSL
SSL

(Custom Slaughter Estab.)
(Federal Slaughter Estab.)
(State Slaughter Estab.)

Below is an example of a Query_A form with three search values entered (Sectn=A, St=M%, and
Sp=BOV). Note that the St search value uses the wildcard.

b. Execute your query using one of the methods below:
• In the Menu Bar, select the Query > Execute command.
• In the Toolbar, click on the Execute Query icon.

11.7

Draft – 1 Dec 2004

c. Your query may retrieve more than one record. To be sure that you have the record you want,
scroll through all of the retrieved records by doing the following:
i. Click inside the Sectn field.
ii. Press the DOWN ARROW key on your computer keyboard. Each time you do so, a new
record will be displayed in the query form. So if your query retrieved four records, you
would need to press the DOWN ARROW key four times to see all of these records, one
at a time.
If you executed the search example shown in the above screen shot, you would have
retrieved every record containing Sectn=A, Sp=BOV, and St= MA, MD, ME, MI, MN,
MO, MS, or MT.
iii. When the record you want is displayed in the form, click on Save. Below is an example of
a retrieved SPR Data-Submission record for Section A:

d. If you want to modify this record, do these steps:
i.

Highlight the first value you want to modify.

ii. Type the new value you want to use.
iii. Repeat these two steps of highlighting-overtyping for each value you want to change.
iv. After you have modified all of the values in this record, click on Save.
e. You can now do either of the following:
• If you modified the Data-Submission record for an SPR report section, you now need to
instruct the Auto-Scheduler utility at the AWBDS web site to process this data. Go
directly now to the next section in this chapter, Procedure 2: Using the Auto-Scheduler
to Process Your Updated Data.
• You can exit the AWBDS web site by clicking on the Exit buttons in each webform or
screen.

11.8

Draft – 1 Dec 2004

1.7

If you selected Query_B1, you should now see the following form onscreen. This webform has been
customized for Section B1 of the SPR report:

In case any of the field labels on this query form are unclear, refer to the table below. (For detailed
information about what data can appear in a specific field, refer back to the tables on pages 4.4 and 4.8 of
this manual.)
Field Label on
Query Form

Field Label on
Data-Submission Form

Rpt Id
Sectn
St

(Not found on D-S Form)
Report Section Letter
State

Dz
Stg

Disease
Stage

Species

Dt Beg
Dt End
Run Dt
Rec Type
Prem Id

Begin Date
End Date
Report Run Date
(Not found on D-S Form)
Prem ID

Prem type
isolate
Prem name

Prem Type
Isolate
Prem Name

Prem city
Prem county
Prem zip code
Most probable source

Prem City
Prem County
Prem Zip Code
Most Probable Source

Nr eligible animals

NR Eligible Animals

Retest nr

Retest NR

11.9

Data Stored in This Field
on Both Forms
Default=SPR
Default=B1
Code for the State in which the data-collection activity took
place.
Code for the disease whose data was submitted.
Stage level that your State was in during this reporting
period.
Code for the animal species whose test results was
submitted.
First date of the time period whose data was submitted.
Last date of the time period whose data was submitted.
Date on which your State's data was submitted.
Default=WEB
Official identification for the premises whose data was
submitted.
Code for the premises type whose data was submitted.
Any code that your State wants to use in this field.
Name of the premises' owner, business name, or herd's
name.
Name of the city in which the premises is located.
Name of the county in which the premises is located.
Zip code of the premises' physical address.
Code for the most likely source of Brucellosis in an affected
herd.
Total # of animals eligible for Brucellosis testing at a
market or slaughter establishment.
The # of times the affected herd has been retested for
Brucellosis on a complete herd test, while considered
"affected". (This field is usually left null.)

Draft – 1 Dec 2004

Test reason
Nr tested last test
Nr reactors last test

Test Reason
NR Tested Last Test
NR Reactors Last Test

Collection date last test
Previous reactor date
prior to last test

Collection Date Last Test
Prev. React Date

Quarantine date

Quarantine Date

Code for the reason the herd(s) or animal(s) were tested.
Total # of animals tested on the most recent herd test.
Total # of animals classified as REACTOR on the most
recent herd test.
The collection date of the most recent herd test.
The most recent previous date on which REACTOR
animals were found on a herd test done prior to the last
retest (if REACTOR animals were found on the last test).
The date on which a herd was quarantined.

a. To retrieve a record that retrieve a record that you want to view and/or update, insert one or more
search values into the field(s) on this query form.
If you are not sure how to spell a search value, use the per cent symbol (%) wildcard to replace the
letters that you don't know. See the chart below for examples on how to use this wildcard:
To Search For:

Type This:

And Get These Results:

animal species codes that
begin with the letter "B"

BOV
BOV

(cattle)
(bison)

all disease codes

%
(in Dz field)

BR
EIA
JOH

(Brucellosis)
(Equine Infectious Anemia)
(Johne's)

all Prem Types that end with
the letters "SL"

%SL

CSL
FSL
SSL

(Custom Slaughter Estab.)
(Federal Slaughter Estab.)
(State Slaughter Estab.)

Below is an example of a Query_B1 form with three search values entered (St=OH, Dz=BR, and
Test Reason= %). Note that the Test Reason search value includes the wildcard, in order to
retrieve records using any test reason.

b. Execute your query using one of the methods below:
• In the Menu Bar, select the Query > Execute command.
• In the Toolbar, click on the Execute Query.

11.10

Draft – 1 Dec 2004

c. Your query may retrieve more than one record. To be sure that you have the record you want,
scroll through all of the retrieved records by doing the following:
i. Click inside the Sectn field.
ii. Press the DOWN ARROW key on your computer keyboard. Each time you do so, a new
record will be displayed in the query form. So if your query retrieved four records, you
would need to press the DOWN ARROW key four times to see all of these records, one
at a time.
If you executed the search example shown in the above screen shot, you would have
retrieved every record containing St=OH, Dz=BR, and Test Reason=%..
iii. When the record you want is displayed in the form, click on Save. Below is an example
of a retrieved SPR Data-Submission record for Section B1:

d. If you want to modify this record, do these steps:
i. Highlight the first value you want to modify.
ii. Type the new value you want to use.
iii. Repeat these two steps of highlighting-overtyping for each value you want to change.
iv. After you have modified all of the values in this record, click on Save.
e. You can now do either of the following:
• If you modified the Data-Submission record for an SPR report section, you now need to
instruct the Auto-Scheduler utility at the AWBDS web site to process this data. Go
directly now to the next section in this chapter, Procedure 2: Using the Auto-Scheduler
to Process Your Updated Data.
• You can exit the AWBDS web site by clicking on the Exit buttons in each webform or
screen.

11.11

Draft – 1 Dec 2004

1.8

If you selected Query_B2, you should now see the following form onscreen. This webform has been
customized for Section B2 of the SPR report:

Field Label on
Data-Submission Form

Data Stored in This Field
on Both Forms

Rpt Id

(Not found on D-S Form)

Default=SPR

Sectn

Report Section Letter

Default=B2

State

Code for the State in which the data-collection activity took place.

Disease

Code for the disease whose data was submitted.

Stg

Stage

Stage level that your State was in during this reporting period.

Species

Code for the animal species whose data was submitted.

Dt Beg

Begin Date

First date of the time period whose data was submitted.

Dt End

End Date

Last date of the time period whose data was submitted.

Run Dt

Report Run Date

Date on which your State's data was submitted.

Rec Type

(Not found on D-S Form)

Default=WEB

Nr new infected herds
during month

NR New Infected Herds
During Month

Total # of new herds classified as INFECTED during this reporting
period.

Nr herds that disclosed
reactors

NR Herds Disclosed
Reactors

Total # of herds tested during the report period in which at least
one animal was classified as a REACTOR, regardless of whether
the herd was quarantined.

Nr herds released

NR Herds Released

Total # of herds whose classification as INFECTED was ended
during this reporting period.

Nr infected herds begin
month

NR Infected Herds
Beginning of Month

Total # of herds classified as INFECTED as the beginning of this
reporting period.

Nr infected herds end
month

NR Infected Herds End of
Month

Total # of herds classified as INFECTED at the end of this
reporting period.

11.12

Draft – 1 Dec 2004

a. To retrieve a record that you want to view and/or update, insert one or more search values into the
field(s) on this query form.
If you are not sure how to spell a search value, use the per cent symbol (%) wildcard to replace
the letters that you don't know. See the chart below for examples on how to use this wildcard:
To Search For:

Type This:

And Get These Results:

animal species codes that
begin with the letter "B"

BOV
BOV

(cattle)
(bison)

all disease codes

%
(in Dz field)

BR
EIA
JOH

(Brucellosis)
(Equine Infectious Anemia)
(Johne's)

all Prem Types that end with
the letters "SL"

%SL

CSL
FSL
SSL

(Custom Slaughter Estab.)
(Federal Slaughter Estab.)
(State Slaughter Estab.)

Below is an example of a Query_B2 form with three search values entered (Sectn=B2, Dz=BR,
and Stg=%). Note that the Stg search value includes the wildcard.

11.13

Draft – 1 Dec 2004

iii. When the record you want is displayed in the form, click on Save. Below is an example
of a retrieved SPR Data-Submission record for Section B2:

11.14

Draft – 1 Dec 2004

1.9

If you selected Query_C, you should now see the following form onscreen. This webform has been
customized for Section C of the SPR report:

Field Label on
Data-Submission Form
(Not found on D-S Form)
Report Section Letter
State
Disease
Stage
Species
Begin Date
End Date
Report Run Date
(Not found on D-S Form)
Prem ID
Prem Type
Prem Name
Prem City
NR Depopulated
Indemnity Amount

Data Stored in This Field
on Both Forms
Default=SPR
Default=C
Code for the State in which the data-collection activity took place.
Code for the disease whose data was submitted.
Stage level that your State was in during this reporting period.
Code for the animal species whose data was submitted.
First date of the time period whose data was submitted.
Last date of the time period whose data was submitted.
Date on which your State's data was submitted.
Default=WEB
Official identification for the premises whose data was submitted.
Code for the type of business/activity done on or by the premises.
Name of the premises' owner, business, or herd.
Name of the city in which this premises is located.
Total # of animals on this premises that were depopulated.
Total amount in U.S. Dollars of the indemnity paid to this premises
for all of the animals that were depopulated.

11.15

Draft – 1 Dec 2004

Type This:

And Get These Results:

animal species codes that
begin with the letter "B"

BOV
BOV

(cattle)
(bison)

all disease codes

%
(in Dz field)

BR
EIA
JOH

(Brucellosis)
(Equine Infectious Anemia)
(Johne's)

all Prem Types that end with
the letters "SL"

%SL

CSL
FSL
SSL

(Custom Slaughter Estab.)
(Federal Slaughter Estab.)
(State Slaughter Estab.)

Below is an example of a Query_C form with three search values entered (Sectn=C, Dz=BR, and
Prem Type=%L). Note that the Prem Type search value includes the wildcard.

11.16

Draft – 1 Dec 2004

If you executed the search example shown in the above screen shot, you would have
retrieved every record containing Sectn=C, Dz=BR, and Prem TYpe= FSL, SSL, or
CSL.
iii. When the record you want is displayed in the form, click on Save. Below is an example
of a retrieved SPR Data-Submission record for Section C:

11.17

Draft – 1 Dec 2004

1.10

If you selected Query_D, you should now see the following form onscreen. This webform has been
customized for Section D of the SPR report:

Field Label on
Data-Submission
Form
(Not found on D-S
Form)
Report Section Letter
State
Disease
Stage
Species
Begin Date
End Date
Report Run Date
(Not found on D-S
Form)
Dairy Herd Pending
Test or Retest
NR Reac Herds

Nr MCI Herds

NR MCI Herds

Nr BRT Herds

NR BRT Herds

Nr Other Herds

NR Oth Herds

Data Stored in This Field
on Both Forms
Default=SPR
Default=D
Code for the State in which the data-collection activity took place.
Code for the disease whose data was submitted.
Stage level that your State was in during this reporting period.
Code for the animal species whose data was submitted.
First date of the time period whose data was submitted.
Last date of the time period whose data was submitted.
Date on which your State's data was submitted.
Default=WEB

Total # of herds with reactor animals whose test/retest date was due
within the previous 0-60 days, 61-180 days, or longer than 180 days.
Total # of MCI herds whose test/retest date was due within the
previous 0-60 days, 61-180 days, or longer than 180 days.
Total # of BRT herds whose test/retest date was due within the
previous 0-60 days, 61-180 days, or longer than 180 days.
Total # of Other Dairy herds whose test/retest date was due within
the previous 0-60 days, 61-180 days, or longer than 180 days.

11.18

Draft – 1 Dec 2004

Total dairy

Total NR Dairy
Reactor Herds

Other

Other Herd Pending
Test or Retest
NR Reac Herds

Nr Reactors Herds
Nr MCI Herds

NR MCI Herds

Nr BRT Herds

NR BRT Herds

Nr Other Herds

NR Oth Herds

Total other

Total NR Other
Reactor Herds

In the Dairy Herd Pending Test or Retest sub block…
The sum of the three values from the 0-60, 61-180, and >180 fields in the
NR Reac Herds column.

Total # of herds with reactor animals whose test/retest date was due
within the previous 0-60 days, 61-180 days, or longer than 180 days.
Total # of MCI herds whose test/retest date was due within the
previous 0-60 days, 61-180 days, or longer than 180 days.
Total # of BRT herds whose test/retest date was due within the
previous 0-60 days, 61-180 days, or longer than 180 days.
Total # of Other herds whose test/retest date was due within the
previous 0-60 days, 61-180 days, or longer than 180 days.
In the Other Herd Pending Test or Retest sub block…
The sum of the three values from the 0-60, 61-180, and >180 fields in the
NR Reac Herds column.

Type This:

And Get These Results:

animal species codes that
begin with the letter "B"

BOV
BOV

(cattle)
(bison)

all disease codes

%
(in Dz field)

BR
EIA
JOH

(Brucellosis)
(Equine Infectious Anemia)
(Johne's)

all Prem Types that end with
the letters "SL"

%SL

CSL
FSL
SSL

(Custom Slaughter Estab.)
(Federal Slaughter Estab.)
(State Slaughter Estab.)

Below is an example of a Query_D form with three search values entered (Sectn=D, Stg=%, and
Sp=BOV). Note that the Stg search value includes the wildcard.

11.19

Draft – 1 Dec 2004

b. Execute your query using one of the methods below:
• In the Menu Bar, select the Query > Execute command.
• In the Toolbar, click on the Execute Query
c. Your query may retrieve more than one record. To be sure that you have the record you want,
scroll through all of the retrieved records by doing the following:
i. Click inside the Sectn field.
ii. Press the DOWN ARROW key on your computer keyboard. Each time you do so, a new
record will be displayed in the query form. So if your query retrieved four records, you
would need to press the DOWN ARROW key four times to see all of these records, one
at a time.
If you executed the search example shown in the above screen shot, you would have
retrieved every record containing Sectn=D, Stg=F, A, B, or C, and Sp= BOV.
iii. When the record you want is displayed in the form, click on Save. Below is an example
of a retrieved SPR Data-Submission record for Section D:

11.20

Draft – 1 Dec 2004

1.11

If you selected Query_E, you should now see the following form onscreen. This webform has been
customized for Section E of the SPR report:

Field Label on
Data-Submission Form

Rpt Id
Sectn
St
Dz
Stg
Sp
Dt Beg
Dt End
Run Dt
Rec Type
Nr herds certified

(Not found on D-S Form)
Report Section Letter
State
Disease
Stage
Species
Begin Date
End Date
Report Run Date
(Not found on D-S Form)
Certified Herds

Data Stored in This Field
on Both Forms
Default=SPR
Default=E
Code for the State in which the data-collection activity took place.
Code for the disease whose data was submitted.
Stage level that your State was in during this reporting period.
Code for the animal species whose data was submitted.
First date of the time period whose data was submitted.
Last date of the time period whose data was submitted.
Date on which your State's data was submitted.
Default=WEB
Total # of herds that were certified at the end of this reporting period.

Type This:

And Get These Results:

animal species codes that
begin with the letter "B"

BOV
BOV

(cattle)
(bison)

all disease codes

%
(in Dz field)

BR
EIA
JOH

(Brucellosis)
(Equine Infectious Anemia)
(Johne's)

all Prem Types that end with
the letters "SL"

%SL

CSL
FSL
SSL

(Custom Slaughter Estab.)
(Federal Slaughter Estab.)
(State Slaughter Estab.)

11.21

Draft– 1 Dec 2004

Below is an example of a Query_E form with three search values entered (Sectn=E, Stg=%, and
Sp=BOV). Note that the Stg search value includes the wildcard.

b. Execute your query using one of the methods below:
• In the Menu Bar, select the Query > Execute command.
• In the Toolbar, click on the Execute Query
c. Your query may retrieve more than one record. To be sure that you have the record you want,
scroll through all of the retrieved records by doing the following:
i. Click inside the Sectn field.
ii. Press the DOWN ARROW key on your computer keyboard. Each time you do so, a new
record will be displayed in the query form. So if your query retrieved four records, you
would need to press the DOWN ARROW key four times to see all of these records, one
at a time.
If you executed the search example shown in the above screen shot, you would have
retrieved every record containing Sectn=E, Stg=F, A, B, or C, and Sp= BOV.
iii. When the record you want is displayed in the form, click on Save. Below is an example
of a retrieved SPR Data-Entry record for Section E:

11.22

Draft – 1 Dec 2004

e. You can now do either of the following:
• If you modified the Data-Entry record for an SPR report section, you now need to
instruct the Auto-Scheduler utility at the AWBDS web site to process this data. Go
directly now to the next section in this chapter, Procedure 2: Using the Auto-Scheduler
to Process Your Updated Data.
• You can exit the AWBDS web site by clicking on the Exit buttons in each webform or
screen.

11.23

Draft– 1 Dec 2004

1.12

If you selected Query_F, you should now see the following form onscreen. This webform has been
customized for Section F of the SPR report:

Field Label on
Data-Submission Form

Rpt Id
Sectn
St
Dz
Stg
Sp
Dt Beg
Dt End
Run Dt
Rec Type
Species
Nr herds tested
Nr animals tested
Nr suspects

(Not found on D-S Form)
Report Section Letter
State
Disease
Stage
Species
Begin Date
End Date
Report Run Date
(Not found on D-S Form)
Species
NR Herds Tested
NR Animals Tested
NR Suspects

Nr herds with reactors

NR Herds w/Reactors

Nr reactors

NR Reactors

Data Stored in This Field
on Both Forms
Default=SPR
Default=F
Code for the State in which the data-collection activity took place.
Code for the disease whose data was submitted.
Stage level that your State was in during this reporting period.
Code for the animal species whose data was submitted.
First date of the time period whose data was submitted.
Last date of the time period whose data was submitted.
Date on which your State's data was submitted.
Default=WEB
Code for the species being reported in this section of the form.
Total # of herds that were tested during this reporting period.
Total # of animals that were tested during this reporting period.
Total # of animals that were assigned SUSPECT status during this
reporting period.
Total # of herds in which reactor animals were present during this
reporting period.
Total # of animals that were assigned REACTOR status during this
reporting period.

11.24

Draft – 1 Dec 2004

Type This:

And Get These Results:

animal species codes that
begin with the letter "B"

BOV
BOV

(cattle)
(bison)

all disease codes

%
(in Dz field)

BR
EIA
JOH

(Brucellosis)
(Equine Infectious Anemia)
(Johne's)

all Prem Types that end with
the letters "SL"

%SL

CSL
FSL
SSL

(Custom Slaughter Estab.)
(Federal Slaughter Estab.)
(State Slaughter Estab.)

Below is an example of a Query_F form with three search values entered (Sectn=F, Stg=%, and
Sp=BOV). Note that the Stg search value includes the wildcard.

11.25

Draft– 1 Dec 2004

iii. When the record you want is displayed in the form, click on Save. Below is an example
of a retrieved SPR Data-Entry record for Section F:

d. If you want to modify this record, do these steps:
i. Highlight the first value you want to modify.
ii. Type the new value you want to use.
iii. Repeat these two steps of highlighting-overtyping for each value you want to change.
iv. After you have modified all of the values in this record, click on Save.
e. You can now do either of the following:
• If you modified the Data-Entry record for an SPR report section, you now need to
instruct the Auto-Scheduler utility at the AWBDS web site to process this data. Go
directly now to the next section in this chapter, Procedure 2: Using the Auto-Scheduler
to Process Your Updated Data.
• You can exit the AWBDS web site by clicking on the Exit buttons in each webform or
screen.

11.26

Draft – 1 Dec 2004

1.13

If you selected Query_G, you should now see the following form onscreen. This webform has been
customized for Section G of the SPR report:

Field Label on
Data-Submission
Form

Prem Id

(Not found on D-S
Form)
Report Section Letter
State
Disease
Stage
Species
Begin Date
End Date
Report Run Date
(Not found on D-S
Form)
Prem ID

Paycode
Nr animals tested
Prem Id

Paycode
NR Animals Tested
Prem ID

Nr eligible

NR Eligible

Sectn
St
Dz
Stg
Sp
Dt Beg
Dt End
Run Dt
Rec Type

Data Stored in This Field
on Both Forms
Default=SPR
Default=G
Code for the State in which the data-collection activity took place.
Code for the disease whose data was submitted.
Stage level that your State was in during this reporting period.
Code for the animal species whose data was submitted.
First date of the time period whose data was submitted.
Last date of the time period whose data was submitted.
Date on which your State's data was submitted.
Default=WEB
Official identification for the premises whose data was submitted.
The value in this field must exactly match the value entered for the second
th
Prem Id data field shown below in the 14 row of this table.
Code for the source of payment for an event.
Total # of animals that were tested during this reporting period.
Official identification for the premises whose data was submitted.
The value in this field must exactly match the value entered for the second
th
Prem Id data field shown above in the 11 row of this table.
Total # of animals slaughtered at the establishment that were eligible to be
tested.

11.27

Draft– 1 Dec 2004

Type This:

And Get These Results:

animal species codes that
begin with the letter "B"

BOV
BOV

(cattle)
(bison)

all disease codes

%
(in Dz field)

BR
EIA
JOH

(Brucellosis)
(Equine Infectious Anemia)
(Johne's)

all Prem Types that end with
the letters "SL"

%SL

CSL
FSL
SSL

(Custom Slaughter Estab.)
(Federal Slaughter Estab.)
(State Slaughter Estab.)

Below is an example of a Query_G form with two search values entered (Sectn=G and Sp=B%).
Note that the Sp search value includes the wildcard.

11.28

Draft – 1 Dec 2004

iii. When the record you want is displayed in the form, click on Save. Below is an example
of a retrieved SPR Data-Entry record for Section G:

d. If you want to modify this record, do these steps:
i. Highlight the first value you want to modify.
ii. Type the new value you want to use.
iii. Repeat these two steps of highlighting-overtyping for each value you want to change.
iv. After you have modified all of the values in this record, click on Save.
e. You can now do either of the following:
• If you modified the Data-Entry record for an SPR report section, you now need to
instruct the Auto-Scheduler utility at the AWBDS web site to process this data. Go
directly now to the next section in this chapter, Procedure 2: Using the Auto-Scheduler
to Process Your Updated Data.
• You can exit the AWBDS web site by clicking on the Exit buttons in each webform or
screen.

11.29

Draft– 1 Dec 2004

1.14

If you selected Query_H, you should now see the following form onscreen. This webform has been
customized for Section H of the SPR report:

Field Label on
Data-Submission Form

Rpt Id
Sectn
St
Dz
Stg
Sp
Dt Beg
Dt End
Run Dt
Rec Type
Nr animals at in state
markets
Nr reactors at instate
markets

(Not found on D-S Form)
Report Section Letter
State
Disease
Stage
Species
Begin Date
End Date
Report Run Date
(Not found on D-S Form)
NR Animals at Instate
Markets
NR Reactors at Instate
Markets

Nr animals at instate
slaughter
establishments
Nr reactors at instate
slaughter
establishments
Nr reactors reported
by other states

NR Animals at Instate
Slaughter
NR Reactors at Instate
Slaughter
NR Reactors Reported by
other States

Data Stored in This Field
on Both Forms
Default=SPR
Default=H
Code for the State in which the data-collection activity took place.
Code for the disease whose data was submitted.
Stage level that your State was in during this reporting period.
Code for the animal species whose data was submitted.
First date of the time period whose data was submitted.
Last date of the time period whose data was submitted.
Date on which your State's data was submitted.
Default=WEB
Total # of animals whose samples were collected at instate markets.
Total # of animals whose samples were collected at instate markets,
and whose blood test interpretations were classified as REACTOR or
POSITIVE.
Total # of animals whose samples were collected at instate slaughter
establishments.
Total # of animals whose samples were collected at instate slaughter
establishments, and whose blood test interpretations were classified
as REACTOR or POSITIVE.
Total # of animals classified as REACTOR or POSITIVE, whose
samples were collected at out-of-state establishments and reported
back to the reporting State as animals from the reporting State.

11.30

Draft – 1 Dec 2004

Type This:

And Get These Results:

animal species codes that
begin with the letter "B"

BOV
BOV

(cattle)
(bison)

all disease codes

%
(in Dz field)

BR
EIA
JOH

(Brucellosis)
(Equine Infectious Anemia)
(Johne's)

all Prem Types that end with
the letters "SL"

%SL

CSL
FSL
SSL

(Custom Slaughter Estab.)
(Federal Slaughter Estab.)
(State Slaughter Estab.)

Below is an example of a Query_H form with three search values entered (Dz=BR, Stg=F, and
Sp=B%). Note that the Sp search value includes the wildcard.

11.31

Draft– 1 Dec 2004

iii. When the record you want is displayed in the form, click on Save. Below is an example
of a retrieved SPR Data-Entry record for Section H:

d. If you want to modify this record, do these steps:
i. Highlight the first value you want to modify.
ii. Type the new value you want to use.
iii. Repeat these two steps of highlighting-overtyping for each value you want to change.
iv. After you have modified all of the values in this record, click on SaYou can now do
either of the following:
e. You can now do either of the following:
• If you modified the Data-Entry record for an SPR report section, you now need to
instruct the Auto-Scheduler utility at the AWBDS web site to process this data. Go
directly now to the next section in this chapter, Procedure 2: Using the Auto-Scheduler
to Process Your Updated Data.
• You can exit the AWBDS web site by clicking on the Exit buttons in each webform or
screen.

11.32

Draft – 1 Dec 2004

1.15

If you selected Query_I, you should now see the following form onscreen. This webform has been
customized for Section I of the SPR report:

Field Label on
Data-Submission
Form

Pending <31

(Not found on D-S
Form)
Report Section
Letter
State
Disease
Stage
Species
Begin Date
End Date
Report Run Date
(Not found on D-S
Form)
Pending <31

Pending >30

TNR

TOS

TRC

TRH

TTN

TTR

TSH

Sectn
St
Dz
Stg
Sp
Dt Beg
Dt End
Run Dt
Rec Type

Data Stored in This Field
on Both Forms
Default=SPR
Default=I
Code for the State in which the data-collection activity took place.
Code for the disease whose data was submitted.
Stage level that your State was in during this reporting period.
Code for the animal species whose data was submitted.
First date of the time period whose data was submitted.
Last date of the time period whose data was submitted.
Date on which your State's data was submitted.
Default=WEB
Total # of MCI traces that are currently open and which are 30 days or less since the
initiation date of the trace.
Total # of MCI traces that are currently open and which are more than 30 days since
the initiation date of the trace.
Total # of MCI traces that were closed as TRACED NOT REQUIRED during this
reporting period.
Total # of MCI traces that were closed as TRACED OUT OF STATE during this
reporting period.
Total # of MCI traces that were closed as TRACED RECLASSIFIED during this
reporting period.
Total # of MCI traces that were closed as being traced to a KNOWN REACTOR
HERD during this reporting period.
Total # of MCI traces that were closed as TRACED AND TEST NOT
RECOMMENDED during this reporting period.
Total # of MCI traces that were closed as TRACED AND TEST RECOMMENDED
during this reporting period.
Total # of MCI traces that were closed as TRACED TO A SOLDOUT HERD during
this reporting period.

11.33

Draft– 1 Dec 2004

Total
successful
Total
unsuccessful

Total Successful

Total # of MCI traces that were closed as TRACED TO A DEALER during this
reporting period.
Total # of MCI traces that were closed as TRACED TO A FEEDLOT during this
reporting period.
Total # of MCI traces that were closed as UNABLE TO TRACE during this reporting
period.
Total # of MCI traces that were successfully closed during this reporting period.

Total Unsuccessful

Total # of MCI traces that were not successfully closed during this reporting period.

Type This:

And Get These Results:

animal species codes that
begin with the letter "B"

BOV
BOV

(cattle)
(bison)

all disease codes

%
(in Dz field)

BR
EIA
JOH

(Brucellosis)
(Equine Infectious Anemia)
(Johne's)

all Prem Types that end with
the letters "SL"

%SL

CSL
FSL
SSL

(Custom Slaughter Estab.)
(Federal Slaughter Estab.)
(State Slaughter Estab.)

Below is an example of a Query_I form with three search values entered (Sectn=I, Dz=BR, and
Sp=%). Note that the Sp search value includes the wildcard.

b. Execute your query using one of the methods below:
• In the Menu Bar, select the Query > Execute command.
• In the Toolbar, click on the Execute Query

11.34

Draft – 1 Dec 2004

c. Your query may retrieve more than one record. To be sure that you have the record you want,
scroll through all of the retrieved records by doing the following:
i. Click inside the Sectn field.
ii. Press the DOWN ARROW key on your computer keyboard. Each time you do so, a new
record will be displayed in the query form. So if your query retrieved four records, you
would need to press the DOWN ARROW key four times to see all of these records, one
at a time.
If you executed the search example shown in the above screen shot, you would have
retrieved every record containing Sectn=I, Dz=BR, and Sp= BOV, CER, FER, or POR.
iii. When the record you want is displayed in the form, click on Save. Below is an example
of a retrieved SPR Data-Entry record for Section I:

d. If you want to modify this record, do these steps:
i. Highlight the first value you want to modify.
ii. Type the new value you want to use.
iii. Repeat these two steps of highlighting-overtyping for each value you want to change.
iv. After you have modified all of the values in this record, click on Save.
e. You can now do either of the following:
• If you modified the Data-Entry record for an SPR report section, you now need to
instruct the Auto-Scheduler utility at the AWBDS web site to process this data. Go
directly now to the next section in this chapter, Procedure 2: Using the Auto-Scheduler
to Process Your Updated Data.
• You can exit the AWBDS web site by clicking on the Exit buttons in each webform or
screen.

11.35

Draft– 1 Dec 2004

1.16

If you selected Query_J, you should now see the following form onscreen. This webform has been
customized for Section J of the SPR report:

Field Label on
Data-Submission Form

Rpt Id
Sectn
St
Dz
Stg
Sp
Dt Beg
Dt End
Run Dt
Rec Type
Nr new herds

(Not found on D-S Form)
Report Section Letter
State
Disease
Stage
Species
Begin Date
End Date
Report Run Date
(Not found on D-S Form)
NR New Herds

Nr herds oob

NR Herds OOB

Nr herds acted for

NR Herds Accounted For

Nr herds missing

NR Herds Missing

Nr herds negative

NR Herds Neg

Nr herds suspicious

NR Herds Suspicious

Total eligible herds

Total Eligible

Total herds tested
Round nr

Total Herds Tested
Round NR

Data Stored in This Field
on Both Forms
Default=SPR
Default=J
Code for the State in which the data-collection activity took place.
Code for the disease whose data was submitted.
Stage level that your State was in during this reporting period.
Code for the animal species whose test results was submitted.
First date of the time period whose data was submitted.
Last date of the time period whose data was submitted.
Date on which your State's data was submitted.
Default=WEB
Total # of herds which participated in their first BRT collection using a
new PUP ID during this BRT round.
Total # of herds that went OUT OF BUSINESS (ceased operations)
during this BRT round.
Total # of herds which participated successfully in at least one BRT
collection during this BRT round.
Total # of herds whose collection results are missing for this BRT
round for various reasons (a herd's milk sample was dry, insufficient,
or sour, for example).
Total # of herds in the State with a round interpretation of NEGATIVE
in all rounds during the year.
(Each subject herd is counted only once, regardless of the number of
rounds in which it was tested during the year.)
Total # of herds in the State with a round interpretation of
SUSPICIOUS in at least one round during the year.
(Each subject herd is counted only once, regardless of the number of
rounds in which it was tested during the year.)
Total # of herds which were classified as ACCOUNTED FOR,
MISSING, NEGATIVE, and SUSPICIOUS during this BRT round.
Total # of herds that were tested during this BRT round.
Number of the BRT round whose data was submitted in this section
of the form.

11.36

Draft – 1 Dec 2004

Type This:

And Get These Results:

animal species codes that
begin with the letter "B"

BOV
BOV

(cattle)
(bison)

all disease codes

%
(in Dz field)

BR
EIA
JOH

(Brucellosis)
(Equine Infectious Anemia)
(Johne's)

all Prem Types that end with
the letters "SL"

%SL

CSL
FSL
SSL

(Custom Slaughter Estab.)
(Federal Slaughter Estab.)
(State Slaughter Estab.)

Below is an example of a Query_J form with two search values entered (Dz=BR and Round
nr=04%). Note that the Round nr search value uses the wildcard.

11.37

Draft– 1 Dec 2004

iii. When the record you want is displayed in the form, click on Save. Below is an example
of a retrieved SPR Data-Entry record for Section J:

d. If you want to modify this record, do these steps:
i. Highlight the first value you want to modify.
ii. Type the new value you want to use.
iii. Repeat these two steps of highlighting-overtyping for each value you want to change.
iv. After you have modified all of the values in this record, click on Save.
e. You can now do either of the following:
• If you modified the Data-Entry record for an SPR report section, you now need to
instruct the Auto-Scheduler utility at the AWBDS web site to process this data. Go
directly now to the next section in this chapter, Procedure 2: Using the Auto-Scheduler
to Process Your Updated Data.
• You can exit the AWBDS web site by clicking on the Exit buttons in each webform or
screen.

11.38

Draft – 1 Dec 2004

1.17

If you selected Query_K, you should now see the following form onscreen. This webform has been
customized for Section K of the SPR report:

Field Label on
Data-Submission Form

Rpt Id
Sectn
St

(Not found on D-S Form)
Report Section Letter
State

Dz
Stg

Disease
Stage

Species

Dt Beg
Dt End
Run Dt
Rec Type
Type vaccination
VAC Juv
Nr animals vaccinated
VAC Juv
Nr herds vaccinated
VAC Juv
Type vaccination
VAC Adult
Nr animals vaccinated
VAC Adult
Nr herds vaccinated
VAC Adult
Type vaccination
VAC Age not specified
Nr animals vaccinated
VAC Age not specified
Nr herds vaccinated
VAC Age not specified

Begin Date
End Date
Report Run Date
(Not found on D-S Form)
(Not found on D-S Form)
NR Animals Vaccinated
VAC Juv
NR Herds Vaccinated
VAC Juv
(Not found on D-S Form)
NR Animals Vaccinated
VAC Juv
NR Herds Vaccinated
VAC Adult
(Not found on D-S Form)
NR Animals Vaccinated
VAC Age Not Specified
NR Herds Vaccinated
VAC Age Not Specified

11.39

Data Stored in This Field
on Both Forms
Default=SPR
Default=K
Code for the State in which the data-collection activity took
place.
Code for the disease whose data was submitted.
Stage level that your State was in during this reporting
period.
Code for the animal species whose test results was
submitted.
First date of the time period whose data was submitted.
Last date of the time period whose data was submitted.
Date on which your State's data was submitted.
Default=WEB
Total # of herds on which the vaccination event was
specified to be for animals considered to be calves.
Total # of juvenile animals (<14 months) which were
vaccinated during this reporting period.
Total # of herds in which juvenile animals (<14 months)
were vaccinated during this reporting period.
Total # of herds for which the vaccination event was
specified to be for adult animals.
Total # of adult animals which were vaccinated during this
reporting period.
Total # of herds in which adult animals (>14 months) were
vaccinated during this reporting period.
Total # of herds for which the vaccination event was not
specified to be age-related.
Total # of animals of unknown age for which the
vaccination event was not specified to be age-related.
Total # of herds in which animals of unknown age were
vaccinated during this reporting period.

Draft – 1 Dec 2004

Type This:

And Get These Results:

animal species codes that
begin with the letter "B"

BOV
BOV

(cattle)
(bison)

all disease codes

%
(in Dz field)

BR
EIA
JOH

(Brucellosis)
(Equine Infectious Anemia)
(Johne's)

all Prem Types that end with
the letters "SL"

%SL

CSL
FSL
SSL

(Custom Slaughter Estab.)
(Federal Slaughter Estab.)
(State Slaughter Estab.)

Below is an example of a Query_K form with three search values entered (Sectn=K, St=OH, and
Stg= %). Note that the Stg search value includes the wildcard.

11.40

Draft – 1 Dec 2004

iii. When the record you want is displayed in the form, click on Save. Below is an example
of a retrieved SPR Data-Submission record for Section K:

11.41

Draft – 1 Dec 2004

1.18

If you selected Query_L, you should now see the following form onscreen. This webform has been
customized for Section L of the SPR report:

Field Label on
Data-Submission Form
(Not found on D-S Form)

Data Stored in This Field
on Both Forms
Default=SPR

Sectn

Report Section Letter

Default=L

State

Code for the State in which the data-collection activity took place.

Disease

Code for the disease whose data was submitted.

Stg

Stage

Stage level that your State was in during this reporting period.

Species

Code for the animal species whose data was submitted.

Dt Beg

Begin Date

First date of the time period whose data was submitted.

Dt End

End Date

Last date of the time period whose data was submitted.

Run Dt

Report Run Date

Date on which your State's data was submitted.

Rec Type

(Not found on D-S Form)

Default=WEB

Purchased infected
animals

Purchased Infected
Animals

Enter the # of herds for which, during the report period, the source
of infection was recorded as the PURCHASE OF INFECTED
ANIMALS.

Exposed to non domestic
animals

Exposed to NonDomestic Animals

Enter the # of herds for which, during the report period, the source
of infection was recorded as EXPOSURE TO NON-DOMESTIC
ANIMALS.

Area Spread

Enter the # of herds for which, during the report period, the source
of infection was recorded as PROBABLE EXPOSURE TO OTHER
INFECTED HERDS OR SOURCES WITHIN THEIR COMMUNITY.

Other

Enter the # of herds for which, during the report period, the source
of infection was recorded as EXPOSURE TO KNOWN SOURCES
(other than the three listed directly above in this table).

Unknown

Enter the # of herds for which, during the report period, the source
of infection was recorded as UNKNOWN.

11.42

Draft – 1 Dec 2004

Type This:

And Get These Results:

animal species codes that
begin with the letter "B"

BOV
BOV

(cattle)
(bison)

all disease codes

%
(in Dz field)

BR
EIA
JOH

(Brucellosis)
(Equine Infectious Anemia)
(Johne's)

all Prem Types that end with
the letters "SL"

%SL

CSL
FSL
SSL

(Custom Slaughter Estab.)
(Federal Slaughter Estab.)
(State Slaughter Estab.)

Below is an example of a Query_L form with three search values entered (Sectn=L, Dz=%, and
Sp=BOV). Note that the Dz search value includes the wildcard.

11.43

Draft – 1 Dec 2004

iii. When the record you want is displayed in the form, click on Save. Below is an example
of a retrieved SPR Data-Submission record for Section L:

11.44

Draft – 1 Dec 2004

1.19

If you selected Query_M, you should now see the following form onscreen. This webform has been
customized for Section M of the SPR report:

Field Label on
Data-Submission Form
(Not found on D-S Form)
Report Section Letter
State
Disease
Stage
Species
Begin Date
End Date
Report Run Date
(Not found on D-S Form)
Herd Type
Program Level 1 – Begin
Assess

Herd Plans

JPL1

JPL2

JPL3

JPL4

JPLM

Data Stored in This Field
on Both Forms
Default=SPR
Default=L
Code for the State in which the data-collection activity took place.
Code for the disease whose data was submitted.
Stage level that your State was in during this reporting period.
Code for the animal species whose data was submitted.
First date of the time period whose data was submitted.
Last date of the time period whose data was submitted.
Date on which your State's data was submitted.
Default=WEB
Code for the types of herds being reported during this reporting period.
Enter the # of herds for which a Risk Assessment (RA) is in effect at the
beginning of the report period.
Enter the # of herds for which a Herd Plan is in effect at the beginning of
the report period.
Enter the # of herds that were at Status Level JPL1 at the beginning of the
report period.
Enter the # of herds that were at Status Level JPL2 at the beginning of the
report period.
Enter the # of herds that were at Status Level JPL3 at the beginning of the
report period.
Enter the # of herds that were at Status Level JPL4 at the beginning of the
report period.
Enter the # of herds in the Monitoring Program at the beginning of the
report period.

11.45

Draft – 1 Dec 2004

2 – Begin
Assess

Program Level 2 – Add/Renew
Assess

Herd Plans

JPL1

JPL2

JPL3

JPL4

JPLM
3 – Removed
Assess

JPLM
Program Level 3 – Removed
Assess

Herd Plans

JPL1

JPL2

JPL3

JPL4

Enter the # of herds for which a Risk Assessment (RA) was accomplished
during the report period.
Enter the # of herds for which a Herd Plan was accomplished during the
report period.
Enter the # of herds that were added to or requalified for Status Level JPL1
during the report period.
Enter the # of herds that were added to or requalified for Status Level JPL2
during the report period.
Enter the # of herds that were added to or requalified for Status Level JPL3
during the report period.
Enter the # of herds that were added to or requalified for Status Level JPL4
during the report period.
Enter the # of herds in the Monitoring Program during the report period.
Enter the # of herds for which a Risk Assessment (RA) expired during the
report period and was not renewed.
Enter the # of herds for which a Herd Plan expired during the report period
and was not renewed.
Enter the # of herds that were removed from Status Level JPL1 during the
report period. **
Enter the # of herds that were removed from Status Level JPL2 during the
report period. **
Enter the # of herds that were removed from Status Level JPL3 during the
report period. **
Enter the # of herds that were removed from Status Level JPL4 during the
report period. **
** (These herds may have moved to a different Status Level or dropped
out of the Test Neg Program).

JPLM
4 – End
Assess

JPLM
Program Level 4 – End
Assess

Herd Plans

JPL1

JPL2

JPL3

JPL4

JPLM

Enter the # of herds that dropped out of the Monitoring Program during the
report period.
Enter the # of herds for which a Risk Assessment (RA) is in effect at the
end of the report period.
Enter the # of herds for which a Herd Plan is in effect at the end of the
report period.
Enter the # of herds at Status Level JPL1 status at the end of the report
period.
Enter the # of herds at Status Level JPL2 status at the end of the report
period.
Enter the # of herds at Status Level JPL3 status at the end of the report
period.
Enter the # of herds at Status Level JPL4 status at the end of the report
period.
Enter the # of herds in the Monitoring Program at the end of the report
period.

11.46

Draft – 1 Dec 2004

Type This:

And Get These Results:

animal species codes that
begin with the letter "B"

BOV
BOV

(cattle)
(bison)

all disease codes

%
(in Dz field)

BR
EIA
JOH

(Brucellosis)
(Equine Infectious Anemia)
(Johne's)

all Prem Types that end with
the letters "SL"

%SL

CSL
FSL
SSL

(Custom Slaughter Estab.)
(Federal Slaughter Estab.)
(State Slaughter Estab.)

Below is an example of a Query_M form with three search values entered (Sectn=M, Dz=JOH, and
Herd Type=%). Note that the Herd Type search value includes the wildcard.

11.47

Draft – 1 Dec 2004

iii. When the record you want is displayed in the form, click on Save. Below is an example
of a retrieved SPR Data-Submission record for Section M:

11.48

Draft – 1 Dec 2004

1.20

If you selected Query_N1, you should now see the following form onscreen. This webform has been
customized for Section N1 of the SPR report:

In case any of the field labels on this query form are unclear, refer to the table below. (For detailed
information about what data can appear in a specific field, refer to the tables at the end of this chapter.)
Field Label on
Query Form
Rpt Id
Sectn
St
Dz
Stg
Sp
Dt Beg
Dt End
Run Dt
Rec Type
Species
Part A Dairy Herds
Tested
Nr Herds Tested
Nr Herds Positive
Part A Non Dairy
Herds Tested
Nr Herds Tested
Nr Herds Positive

Field Label on
Data-Submission
Form
(Not found on D-S
Form)
Report Section Letter
State
Disease
Stage
Species
Begin Date
End Date
Report Run Date
(Not found on D-S
Form)
Species
Part A: Dairy Herds
Tested
NR Herds Tested
NR Herds Positive
Part A: Non-Dairy
Herds Tested
NR Herds Tested
NR Herds Positive

Data Stored in This Field
on Both Forms
Default=SPR
Default=N1
Code for the State in which the data-collection activity took place.
Code for the disease whose data was submitted.
Stage level that your State was in during this reporting period.
Code for the animal species whose data was submitted.
First date of the time period whose data was submitted.
Last date of the time period whose data was submitted.
Date on which your State's data was submitted.
Default=WEB
Code for the species whose data was submitted.

Total # of herds that were tested during this reporting period.
Total # of herds that tested positive during this reporting period.

11.49

Draft – 1 Dec 2004

Type This:

And Get These Results:

animal species codes that
begin with the letter "B"

BOV
BOV

(cattle)
(bison)

all disease codes

%
(in Dz field)

BR
EIA
JOH

(Brucellosis)
(Equine Infectious Anemia)
(Johne's)

all Prem Types that end with
the letters "SL"

%SL

CSL
FSL
SSL

(Custom Slaughter Estab.)
(Federal Slaughter Estab.)
(State Slaughter Estab.)

Below is an example of a Query_N1 form with three search values entered (Sectn=N1, St=CO, and
Sp=%). Note that the Sp search value includes the wildcard.

11.50

Draft – 1 Dec 2004

iii. When the record you want is displayed in the form, click on Save. Below is an example
of a retrieved SPR Data-Submission record for Section N1:

11.51

Draft – 1 Dec 2004

1.21

If you selected Query_N2, you should now see the following form onscreen. This webform has been
customized for Section N2 of the SPR report:

Field Label on
Data-Submission Form

Rpt Id
Sectn
St
Dz
Stg
Sp
Dt Beg
Dt End
Run Dt
Rec Type
Species
Test type

(Not found on D-S Form)
Report Section Letter
State
Disease
Stage
Species
Begin Date
End Date
Report Run Date
(Not found on D-S Form)
Species
Test Type

Dairy
Nr Herds Tested
Nr Animals Tested
Nr Positive Tested

Nr Suspect Tested

Nr Inconclusive Tested

Non - Dairy
Nr Herds Tested
Nr Animals Tested
Nr Positive Tested

Nr Suspect Tested

Nr Inconclusive Tested

Data Stored in This Field
on Both Forms
Default=SPR
Default=N2
Code for the State in which the data-collection activity took place.
Code for the disease whose data was submitted.
Stage level that your State was in during this reporting period.
Code for the animal species whose data was submitted.
First date of the time period whose data was submitted.
Last date of the time period whose data was submitted.
Date on which your State's data was submitted.
Default=WEB
Code for the species being reported on this form.
Code for the types of tests that were performed during this reporting
period.
Total # of dairy herds given the Test Type specified.
Total # of dairy animals given the Test Type specified.
Total # of dairy animals given the Test Type specified and whose test
interpretations were classified as POSITIVE.
Total # of dairy animals given the Test Type specified and whose test
interpretations were classified as SUSPECT.
Total # of dairy animals given the Test Type specified and whose test
interpretations were classified as INCONCLUSIVE.
Total # of dairy herds given the Test Type specified.
Total # of dairy animals given the Test Type specified.
Total # of dairy animals given the Test Type specified and whose test
interpretations were classified as POSITIVE.
Total # of dairy animals given the Test Type specified and whose test
interpretations were classified as SUSPECT.
Total # of dairy animals given the Test Type specified and whose test
interpretations were classified as INCONCLUSIVE.

11.52

Draft – 1 Dec 2004

Type This:

And Get These Results:

animal species codes that
begin with the letter "B"

BOV
BOV

(cattle)
(bison)

all disease codes

%
(in Dz field)

BR
EIA
JOH

(Brucellosis)
(Equine Infectious Anemia)
(Johne's)

all Prem Types that end with
the letters "SL"

%SL

CSL
FSL
SSL

(Custom Slaughter Estab.)
(Federal Slaughter Estab.)
(State Slaughter Estab.)

Below is an example of a Query_N2 form with three search values entered (St=CO, Sp=BOV, and
Test type=%). Note that the Test type search value includes the wildcard.

b. Execute your query using one of the methods below:
• In the Menu Bar, select the Query > Execute command.
• In the Toolbar, click on the Execute Query
c. Your query may retrieve more than one record. To be sure that you have the record you want,
scroll through all of the retrieved records by doing the following:
i. Click inside the Sectn field.
ii. Press the DOWN ARROW key on your computer keyboard. Each time you do so, a new
record will be displayed in the query form. So if your query retrieved four records, you
would need to press the DOWN ARROW key four times to see all of these records, one
at a time.
If you executed the search example shown in the above screen shot, you would have
retrieved every record containing St=CO, Sp= BOV, and Test type=ELS, FCUL,
JOHNIN, or GI.

11.53

Draft – 1 Dec 2004

iii. When the record you want is displayed in the form, click on Save. Below is an example
of a retrieved SPR Data-Submission record for Section N2:

11.54

Draft – 1 Dec 2004

Procedure 2:
Using the Auto-Scheduler to Process Your Updated
Data
Now that you have modified the record for an SPR report section, you need to alert the Auto-Scheduler utility that
you have new data for it to process. You accomplish this task by leaving the Data Entry Forms area of the website
to work in the Approval Summary Data area. Follow the instructions below:

2.1

In the Query webform where you just modified the record for an SPR report section, click on Exit.

2.2

The Summary Data Entry Forms main menu (shown at right)
now appears.
In this screen, click on Exit. You have now left the Data Entry
Forms area of the website.

2.3

The National Surveillance Program Reports main menu now
appears.
Click on the Approve Summary Data option. You have now
entered the Approval area of the website.

2.4

The National Surveillance Reports Menu (shown at right) will
appear onscreen.

11.55

Draft – 1 Dec 2004

2.5

Fill out the header block with the appropriate parameters for the SPR report section whose DataSubmission record you just updated.

2.6

In the bottom block of this same menu, click on the [2] next to the SPR National Summary Report Data
option.

2.7

An SPR Approval Forms screen (shown below) now appears.

11.56

Draft – 1 Dec 2004

2.8

2.9

Even though you modified the record for only one SPR report section, you may still see sixteen popup
messages that describe the actions done by the Auto-Scheduler for all sixteen sections shown on this
screen. Click OK in each popup window to close it.

2.10

At the end of your work session, you can exit the AWBDS web site by clicking on the Exit buttons in each
webform or screen.

11.57

Draft – 1 Dec 2004

11.58

Draft– 1 Dec 2004

Reference Table 1:
Organized by Report Section Letter
The table below allows you to see at a single glance all of the data field labels for each
individual section within an SPR report.

Sections A, B1, and B2

D2
D4
D6
D8
D10
D12
D14
D16
D18
D20
D22
D24
D26
D28
D30
D32
D34
D36
D38
D40
D42
D44
D46
D48
D50
D52
D54
D56
D58

Section A

Section B1

Section B2

Tests on Farm or Ranch

Affected Herds in State

Event(test) reason
Herds tested,
fed expense
Animals tested,
fed expense
Herds tested,
fed fee basis expense
Animals tested,
fed fee basis expense
Herds tested,
state expense
Animals tested,
state expense
Herds tested,
state fee basis expense
Animals tested,
state fee basis expense
Herds tested,
owner expense
Animals tested,
owner expense
Total herds tested
Total animals tested
---------------------------------

Prem ID
Prem type

Nr herds that disclosed reactors
Nr infected herds end month

Isolate

Nr new infected herds during month

Prem name

Nr herds released

Prem city

Nr infected herds begin month

Prem county

---

Prem zip code

---

Most probable source

---

Nr eligible animals

---

Retest nr

---

Test reason

---

Nr tested, last test
Nr reactors, last test
Collection date, last test
Previous reactor date prior to last test
Quarantine date
---------------------------

-------------------------------------

11.59

Draft – 1 Dec 2004

Sections C, D, and E

D2
D4
D6
D8
D10
D12
D14
D16
D18
D20
D22
D24
D26
D28
D30
D32
D34
D36
D38
D40
D42
D44
D46
D48
D50
D52
D54
D56
D58

Section C

Section D

Section E

Herds Depopulated

Herds Pending Test or Retest

Certified Herds

Prem ID
Prem type
Prem name
Prem city
Nr depopulated
Amount of indemnity
-----------------------------------------------

Nr reactors herds, 0-60, dairy
Nr reactors herds, 0-60, other
Nr reactors herds, 61-180, dairy
Nr reactors herds, 61-180, other
Nr reactors herds, >180, dairy
Nr reactors herds, >180, other
Nr mci herds, 0-60, dairy
Nr mci herds, 0-60, other
Nr mci herds, 61-180, dairy
Nr mci herds, 61-180, other
Nr mci herds, >180, dairy
Nr mci herds, >180, other
Nr brt herds, 0-60, dairy
Nr brt herds, 0-60, other
Nr brt herds, 61-180, dairy
Nr brt herds, 61-180, other
Nr brt herds, >180, dairy
Nr brt herds, >180, other
Nr oth herds, 0-60, dairy
Nr oth herds, 0-60, other
Nr oth herds, 61-180, dairy
Nr oth herds, 61-180, other
Nr oth herds, >180, dairy
Nr oth herds, >180, other
Total, dairy
Total, other
-------

11.60

Nr herds certified
---------------------------------------------------------

Draft– 1 Dec 2004

Sections F, G, and H
Section F

Section G

Section H

Tests in Other Species

Blood Sample Collections
at Slaughter

Blood Tests on Market Animals
Tested In-State

D2
D4
D6

Species
Nr herds tested
Nr animals tested

Prem ID
Paycode
Nr animals tested

Nr suspects

---

D10
D12
D14
D16
D18
D20
D22
D24
D26
D28
D30
D32
D34
D36
D38
D40
D42
D44
D46
D48
D50
D52
D54
D56
D58

Nr herds w/reactors
Nr reactors
-----------------------------------------------

---------------------------------------------------

11.61

Nr animals at in-state markets
Nr reactors at in-state markets
Nr animals at in-state slaughter
establishments
Nr reactors at in-state slaughter
establishments
Nr reactors reported by other states
-------------------------------------------------

Draft – 1 Dec 2004

Sections I, J, and K
Section I

Section J

Section K

Tracebacks from Market
and Slaughter

Ring Test Results (Herds In-State
Regardless of Where Tested)

Animals Vaccinated

Pending <31

Nr new herds

D4
D6
D8

Pending >30
TNR
TOS

Nr herds oob
Nr herds accted for
Nr herds missing

D10
D12
D14

TRC
TRH
TTN

Nr herds negative
Nr herds suspicious
Total eligible herds

D16

TTR

Total herds tested

D18

TSH

Round nr

D20
D22
D24
D26
D28
D30
D32
D34
D36
D38
D40
D42
D44
D46
D48
D50
D52
D54
D56
D58

TD
TF
UT
Total successful
Total unsuccessful
-------------------------------

-----------------------------------------

Type vaccination,
VAC-Juv
Nr animals vaccinated, VAC-Juv
Nr herds vaccinated, VAC-Juv
Type vaccination,
VAC-Adult
Nr animals vaccinated, VAC-Adult
Nr herds vaccinated, VAC-Adult
Type vaccination,
VAC-Age not specified
Nr animals vaccinated, VAC- Age not
specified
Nr herds vaccinated, VAC- Age not
specified
-----------------------------------------

11.62

Draft– 1 Dec 2004

Sections L and M

D2
D4
D6
D8
D10
D12
D14
D16
D18
D20
D22
D24
D26
D28
D30
D32
D34
D36
D38
D40
D42
D44
D46
D48
D50
D52
D54
D56
D58

Section L

Section M

Source of New Herd Infections

Johne's Herds in Status

Purchased infected animals
Exposed to non-domestic animals
Area spread
Other
Unknown
-------------------------------------------------

Herd Type
Assess - Begin
Assess – Add/Renew
Assess - Removed
Assess - End
Herd Plans - Begin
Herd Plans – Add/Renew
Herd Plans - Removed
Herd Plans - End
JPL1 - Begin
JPL1 – Add/Renew
JPL1 - Removed
JPL1 - End
JPL2 - Begin
JPL2 – Add/Renew
JPL2 - Removed
JPL2 - End
JPL3 - Begin
JPL3 – Add/Renew
JPL3 - Removed
JPL3 - End
JPL4 - Begin
JPL4 – Add/Renew
JPL4 - Removed
JPL4 - End
JPLM (Sum A, B, C, D Herds) - Begin
JPLM (Sum A, B, C, D Herds) – Add/Renew
JPLM (Sum A, B, C, D Herds) - Removed
JPLM (Sum A, B, C, D Herds) - End

11.63

Draft – 1 Dec 2004

Sections N1 and N2

D2
D4
D6
D8
D10
D12
D14
D16
D18
D20
D22
D24
D26
D28
D30
D32
D34
D36
D38
D40
D42
D44
D46
D48
D50
D52
D54
D56
D58

Section N1

Section N2

Part A: Johnes Herds Tested

Part B: Johnes Herds and Animals
Tested by Test Type

Species

Part A …# Dairy Herds Tested
Part A…# Non-Dairy Herds Tested
Part A…# Dairy Herds Tested POSITIVE
Part A…# Non-Dairy Herds Tested POSITIVE
-----

Test Type
NR Dairy Herds Tested
NR Dairy Animals Tested
NR Dairy Animals Tested POSITIVE
NR Dairy Animals Tested SUSPECT
NR Dairy Animals Tested INCONCLUSIVE

-------------

NR Non-Dairy Herds Tested
NR Non-Dairy Animals Tested
NR Non-Dairy Animals Tested POSITIVE
NR Non-Dairy Animals Tested SUSPECT
NR Non-Dairy Animals Tested INCONCLUSIVE
---

-------------

---------

11.64

Draft– 1 Dec 2004

Reference Table 2:
Organized by Data Field Label (1 of 4)
The table below allows you to determine what a specific data field label is, depending on which
section in the SPR report you see that label.

Field D2:

Field D4:

Field D6:

Field D8:

Field D10:

Field D12:

Field D14:

Section A:
Section B1:
Section B2:
Section C:
Section D:
Section E:
Section F:
Section G:
Section A:
Section B1:
Section B2:
Section C:
Section D:
Section E:
Section F:
Section G:
Section A:
Section B1:
Section B2:
Section C:
Section D:
Section E:
Section F:
Section G:
Section A:
Section B1:
Section B2:
Section C:
Section D:
Section E:
Section F:
Section G:
Section A:
Section B1:
Section B2:
Section C:
Section D:
Section E:
Section F:
Section G:
Section A:
Section B1:
Section B2:
Section C:
Section D:
Section E:
Section F:
Section G:
Section A:
Section B1:
Section B2:
Section C:
Section D:
Section E:
Section F:
Section G:

Event (test) reason
Prem ID
Nr herds that disclosed reactors
Prem ID
Nr reactors herds, 0-60, dairy
Nr herds certified
Species
Prem ID
Herds tested, fed expense
Prem type
Nr infected herds end month
Prem type
Nr reactors herds, 0-60, other
Nr herds certified
Nr herds tested
Paycode
Animals tested, fed expense
Isolate
Nr infected herds during month
Prem name
Nr reactors herds, 61-180, dairy
--Nr animals tested
Nr animals tested
Herds tested, fed fee basis expense
Prem name
Nr herds released
Prem city
Nr reactors herds, 61-180, other
--Nr suspects
--Animals tested, fed fee basis expense
Prem city
Nr infected herds begin month
Nr depopulated
Nr reactors herds, >180, dairy
--Nr herds with reactors
--Herds tested, state expense
Prem county
--Amount of indemnity
Nr reactors herds, >180, other
--Nr reactors
--Animals tested, state expense
Prem zip code
----Nr mci herds, 0-60, dairy
-------

11.65

Section H:
Section I:
Section J:
Section K:
Section L:
Section M:
Section N:

Nr animals at instate markets
Pending <31
Nr new herds
Type vaccination, VAC-Juv
Purchased infected animals
Herd Type
Species

Section H:
Section I:
Section J:
Section K:
Section L:
Section M:
Section N:

Nr reactors at instate markets
Pending >30
Nr herds oob
Nr animals vaccinated, VAC-Juv
Exposed to non-domestic animals
Assess - Begin
Test Type

Section H:
Section I:
Section J:
Section K:
Section L:
Section M:
Section N:

Nr animals at instate markets
TNR
Nr herds accounted for
Nr herds vaccinated, VAC-Juv
Area spread
Assess – Add/Renew
NR Dairy Herds Tested

Section H:
Section I:
Section J:
Section K:
Section L:
Section M:
Section N:

Nr reactors at instate slaughter
TOS
Nr herds missing
Type vaccination, VAC-Adult
Other
Assess - Removed
NR Dairy Animals Tested

Section H:
Section I:
Section J:
Section K:
Section L:
Section M:
Section N:

Nr reactors reported by other states
TRC
Nr herds negative
Nr animals vaccinated, VAC-Adult
Unknown
Assess - End
NR Dairy Animals Tested POSITIVE

Section H:
Section I:
Section J:
Section K:
Section L:
Section M:
Section N:

--TRH
Nr herds suspicious
Nr herds vaccinated, VAC-Adult
--Herd Plans - Begin
NR Dairy Animals Tested SUSPECT

Section H:
Section I:
Section J:
Section K:

--TTN
Total eligible herds
Type vaccination, VAC-age not
specified
--Herd Plans – Add/Renew
NR Dairy Animals Tested
INCONCLUSIVE

Section L:
Section M:
Section N:

Draft – 1 Dec 2004

Reference Table 2:
Organized by Data Field Label (2 of 4)
Field D16:

Field D18:

Field D20:

Field D22:

Field D24:

Field D26:

Field D28:

Herds tested, state fee basis expense
Most probable source
----Nr mci herds, 0-60, other
------Animals tested, state fee basis expense
Nr eligible animals
----Nr mci herds, 61-180, dairy
------Herds tested, owner expense
Retest nr
----Nr mci herds, 61-180, other
------Animals tested, owner expense
Test reason
----Nr mci herds, >180, dairy
------Total herds tested
Nr tested, last test
----Nr mci herds, >180, other
------Total animals tested
Nr reactors, last test
----Nr brt herds, 0-60, dairy
--------Collection date, last test
----Nr brt herds, 0-60, other
-------

11.66

Section H:
Section I:
Section J:
Section K:

Section H:
Section I:
Section J:
Section K:
Section L:
Section M:
Section N:

--TTR
Total herds tested
Nr animals vaccinated, VAC-age not
specified
--Herd Plans - Removed
NR Non-Dairy Herds Tested
--TSH
Round nr
Nr herds vaccinated, VAC-age not
specified
--Herd Plans - End
NR Non-Dairy Animals Tested
--TD
------JPL1 - Begin
NR Non-Dairy Animals Tested
POSITIVE
--TF
------JPL1 – Add/Renew
NR Non-Dairy Animals Tested
SUSPECT
--UT
------JPL1 – Removed
NR Non-Dairy Animals Tested
INCONCLUSIVE
--Total successful
------JPL1 - End
---

Section H:
Section I:
Section J:
Section K:
Section L:
Section M:
Section N:

--Total unsuccessful
------JPL2 - Begin
---

Section L:
Section M:
Section N:
Section H:
Section I:
Section J:
Section K:
Section L:
Section M:
Section N:
Section H:
Section I:
Section J:
Section K:
Section L:
Section M:
Section N:
Section H:
Section I:
Section J:
Section K:
Section L:
Section M:
Section N:
Section H:
Section I:
Section J:
Section K:
Section L:
Section M:
Section N:

Draft– 1 Dec 2004

Reference Table 2:
Organized by Data Field Label (3 of 4)
Field D30:

Field D32:

Field D34:

Field D36:

Field D38:

Field D40:

Field D42:

--Previous reactor date prior to last test
----Nr brt herds, 61-180, dairy
--------Quarantine date
----Nr brt herds, 61-180, other
--------------Nr brt herds, >180, dairy
--------------Nr brt herds, >180, other
--------------Nr oth herds, 0-60, dairy
--------------Nr oth herds, 0-60, other
--------------Nr oth herds, 61-180, dairy
-------

11.67

Section H:
Section I:
Section J:
Section K:
Section L:
Section M:
Section N:

----------JPL2 – Add/Renew
---

Section H:
Section I:
Section J:
Section K:
Section L:
Section M:
Section N:

----------JPL2 – Removed
---

Section H:
Section I:
Section J:
Section K:
Section L:
Section M:
Section N:

----------JPL2 – End
---

Section H:
Section I:
Section J:
Section K:
Section L:
Section M:
Section N:

----------JPL3 – Begin
---

Section H:
Section I:
Section J:
Section K:
Section L:
Section M:
Section N:

----------JPL3 – Add/Renew
---

Section H:
Section I:
Section J:
Section K:
Section L:
Section M:
Section N:

----------JPL3 – Removed
---

Section H:
Section I:
Section J:
Section K:
Section L:
Section M:
Section N:

----------JPL3 – End
---

Draft – 1 Dec 2004

Reference Table 2:
Organized by Data Field Label (4 of 4)
Field D44:

Field D46:

Field D48:

Field D50:

Field D52:

Field D54:

Field D56:

--------Nr oth herds, 61-180, other
--------------Nr oth herds, >180, dairy
--------------Nr oth herds, >180, other
--------------Total, dairy
--------------Total, other
---------------------------------------

11.68

Section H:
Section I:
Section J:
Section K:
Section L:
Section M:
Section N:

----------JPL4 - Begin
---

Section H:
Section I:
Section J:
Section K:
Section L:
Section M:
Section N:

----------JPL4 – Add/Renew
---

Section H:
Section I:
Section J:
Section K:
Section L:
Section M:
Section N:

----------JPL4 - Removed
---

Section H:
Section I:
Section J:
Section K:
Section L:
Section M:
Section N:

----------JPL4 - End
---

Section H:
Section I:
Section J:
Section K:
Section L:
Section M:
Section N:

----------JPLM - Begin
---

Section H:
Section I:
Section J:
Section K:
Section L:
Section M:
Section N:

----------JPLM – Add/Renew
---

Section H:
Section I:
Section J:
Section K:
Section L:
Section M:
Section N:

----------JPLM - Removed
---

Draft– 1 Dec 2004

Field D58:

Section A:
Section B1:
Section B2:
Section C:
Section D:
Section E:
Section F:
Section G:

-----------------

Section H:
Section I:
Section J:
Section K:
Section L:
Section M:
Section N:

11.69

----------JPLM - End
---

Draft – 1 Dec 2004

11.70

Chapter 12:
Approving Your State's SPR Data
In this task, you will learn how to approve, reject, and delete your State's data for an SPR National
Report.
Unit

Topic

See Page

Procedure 1:

Approving/Rejecting a State's SPR Data-Submission
(This procedure can be done only by authorized Quality Control (QC) personnel
for your State.)

12.2

Procedure 2:

Viewing an Existing, Not-Yet-Approved SPR Data-Submission

12.6

Procedure 3:

Deleting an Existing, Not-Yet-Approved SPR Data-Submission

12.11

12.1

Draft – 1 Dec 2004

Procedure 1:
Approving/Rejecting a State's SPR Data-Submission
This procedure can be performed only by a State's authorized Quality Control (QC) personnel.

1.1

Log into the Automated Web-Based Data Submission (AWBDS) web site.
A Warning screen will appear onscreen.

1.2

Click on the Accept button.
The Veterinary Services National Surveillance Program Reports main screen (shown below) will
appear.

1.3

Click on the Approve Summary Data option.

12.2

Draft – 1 Dec 2004

1.4

The National Surveillance Reports Menu screen (shown below) will appear:

In the top block of this form, enter the parameters that identify the specific report whose section(s) you
want to record your approval/disapproval.
Field

Guidelines

Approver's
Oracle User
Name

User name that you use to log into the AWBDS web site.

State

Two-letter postal abbreviation for the state in which the data collection activity took place.
Click on the down arrow button to display a List of Values for this field.

Disease
Program

Code for the animal disease program whose test results are being reported on this form.
Click on the L button to display a List of Values for this field.

Species

Code for the animal species whose test results are being reported on this form.
Click on the down arrow button to display a List of Values for this field.

Report Begin
Date

Report Run Date

When completed, the top block should look similar to this example:

12.3

Draft – 1 Dec 2004

1.5

In the bottom block of this form, click on the 3. SPR National Summary Report Data option.
An SPR Approval Forms screen will now appear:

a. Note that the report parameters (such as its Species, Begin Date, and End Date parameters) which
you specified back in Step 1.4 will apply to every report section listed on this screen.
Keep in mind, however, that you can approve/reject only those sections for which you have signoff
authority. (As an example, the State of Florida might have one QC representative, John Smith,
who has signoff authority for Sections A-L, and a second QC representative, Cindy Nelson, who
has signoff authority for Sections M, N1, and N2 only. John Smith cannot approve/reject Sections
M, N1, and N2, and Cindy Nelson cannot approve/reject Sections A-L.)
b. For each section, you must click on the down arrow button and select a value from the displayed
List of Values. The choices are described below:
Option

Meaning

Y–
Report Approved

As your State's QC representative with signoff authority, you approve the data
submitted for this report section to be complete and accurate.

N–
Report Not Approved

Choose this option for either reason below:
-- As your State's QC representative with signoff authority, you do not approve the
data submitted for this report, as you have determined some or all of the data to
contain errors/omissions.
-- You do not have signoff authority for this specific report.

R–
Re-run the Report

Enables you to run a new version of the SPR National Program Report.
This option is helpful, especially in situations where an initial Data-Submission from
a State had to be corrected and re-submitted for approval. Once the second,
corrected submission has been approved, this option can be used to generate a
new PRV-190 National Program Report whose data will be accurate.
This option is described in more detail in the following chapters of this manual:
Chapter 3 – Updating Your State's Data for a TB6-2 National Program Report
Chapter 7 – Updating Your State's Data for a PRV-190 National Program Report
Chapter 11 – Updating Your State's Data for an SPP National Program Report

12.4

Draft – 1 Dec 2004

e. After you have submitted your approval for each SPR section for which you have signoff authority,
click on the Exit command button.
You are returned to the National Surveillance Reports Menu screen.

12.5

Draft – 1 Dec 2004

Procedure 2:
Viewing an Existing, Not-Yet-Approved
SPR Data-Submission
This procedure enables you to query for and retrieve one or more existing SPR Data-Submission records that are
currently being stored in the Temporary Holding Database.
You may wish to query for a record to see if it has already been submitted, or to see if it has been approved/signed
off by your State's QC personnel.

2.1

Log into the Automated Web-Based Data Submission (AWBDS) web site. (If necessary, refer back to
Task 1 for the procedure on how to do this.)
A Warning screen will appear onscreen.

2.2

Click on the Accept button.
The Veterinary Services National Surveillance Program Reports main screen (shown below) will
appear.

2.3

Click on the Approve Summary Data option.

12.6

Draft – 1 Dec 2004

2.4

The National Surveillance Reports Menu screen (shown below) will appear:

In the top block of this form, enter the parameters that identify the specific report whose section(s) you
want to view.
Field

Guidelines

Approver's
Oracle User
Name

User name that you use to log into the AWBDS web site.

State

Two-letter postal abbreviation for the state in which the data collection activity took place.
Click on the down arrow button to display a List of Values for this field.

Disease
Program

Code for the animal disease program whose test results are being reported on this form.
Click on the L button to display a List of Values for this field.

Species

Code for the animal species whose test results are being reported on this form.
Click on the down arrow button to display a List of Values for this field.

Report Begin
Date

Report Run Date

When completed, the top block should look similar to this example:

12.7

Draft – 1 Dec 2004

2.5

In the bottom block of this form, click on the 1. SPR Tuberculosis National Summary Report Data
option.
An SPR Approval Forms screen will now appear.

2.6

To determine if a report section has already been submitted, approved, or rejected, click on the Already
Approved Report button. The following query screen will appear:

2.7

12.8

Draft – 1 Dec 2004

Type This:

To Get These Results:

%STON%

Halstone

Charleston

Alabama
Arizona

Alaska
Arkansas

AD44

300AD44

%AD44

The example below shows the wildcard variable that was entered in the Approver User Name
field.

12.9

Draft – 1 Dec 2004

Click your cursor inside any field (Record Create Date for example).

To end your work session, you can exit the ASBDS web site by clicking on the Exit buttons in each
webform or screen.

12.10

Draft – 1 Dec 2004

Procedure 3:
Deleting an Existing, Not-Yet-Approved
SPR Data-Submission
This procedure enables you to query for and delete an existing SPR Data-Submission record that is currently being
stored in the Temporary Holding Database.

3.1

Log into the Automated Web-Based Data Submission (AWBDS) web site. (If necessary, refer back to
Task 1 for the procedure on how to do this.)
A Warning screen will appear onscreen.

3.2

Click on the Accept button.
The Veterinary Services National Surveillance Program Reports main screen (shown below) will
appear.

3.3

Click on the Approve Summary Data option.

12.11

Draft – 1 Dec 2004

3.4

The National Surveillance Reports Menu screen (shown below) will appear:

In the top block of this form, enter the parameters that identify the specific report whose section(s) you
want to delete.
Field

Guidelines

Approver's
Oracle User
Name

User name that you use to log into the AWBDS web site.

State

Two-letter postal abbreviation for the state in which the data collection activity took place.
Click on the down arrow button to display a List of Values for this field.

Disease
Program

Code for the animal disease program whose test results are being reported on this form.
Click on the L button to display a List of Values for this field.

Species

Code for the animal species whose test results are being reported on this form.
Click on the down arrow button to display a List of Values for this field.

Report Begin
Date

Report Run Date

When completed, the top block should look similar to this example:

12.12

Draft – 1 Dec 2004

3.5

In the bottom block of this form, click on the 1. SPR Tuberculosis National Summary Report Data
option.
An SPR Approval Forms screen will now appear.

3.6

Click on the Already Approved Report button. The following query screen will appear:

3.7

12.13

Draft – 1 Dec 2004

Type This:

To Get These Results:

%STON%

Halstone

Charleston

Alabama
Arizona

Alaska
Arkansas

AD44

300AD44

%AD44

The example below shows the wildcard variable that was entered in the Approver User Name
field.

12.14

Draft – 1 Dec 2004

Click your cursor inside any field (Record Create Date for example).

To end your work session, you can exit the ASBDS web site by clicking on the Exit buttons in each
webform or screen.

12.15

Draft – 1 Dec 2004

12.16

Chapter 13:
Running an SPR National Report
In this task, you will learn how to run a new SPR National Report, which should include the most recent,
approved SPR Data-Submission record from your State. This report is being produced from the
permanent report tables and can be run only after the report has been approved and its data transferred
from the Temporary Holding Database to the National Reports Database.

13.1

Draft – 1 Dec 2004

Procedure for Running a New SPR National Report:
1.1

Log into the Automated Web-Based Data Submission (AWBDS) web site.

1.2

A Warning screen will appear onscreen.
Click on the Accept button.

1.3

Veterinary Services National Surveillance Program
Reports main screen (shown at right) will appear.
In this screen, click on the Run Program Reports option.

1.4

The Summary Reports by Section screen (shown at right)
will appear:
In this screen, select the [3] button next to the
SPR – Standard Program Reports (incl. BR, JOH)
option.

1.5

An SPR Summary Reports by Section screen (shown at
right) will now appear:

…The remainder of this procedure will be written after code
development for this feature has been completed…

13.2

Chapter 14:
Where To Go For Help

The following resources are available to help with any questions or situations you might have in using the AWBDS
web site and webforms:
For Help On…

Contact…

Installing the Jinitiator plug-in application

Your Area Office's IT Support Department

• User Profile (login permissions)
• Using the AWBDS web site and
webforms

USDA's GDB Web Site
URL: http://gdb.aphis.usda.gov

Veterinary Services animal disease programrelated issues, such as which animal event
type to use.

One of the links at this web site is the GDB Helpdesk, which
can answer these questions. (See the section below in this
chapter for details.)
• the Designated Epidemiologist for the specific animal
disease management program in your State
• the Area-Veterinarian-in-Charge (AVIC) for the specific
animal disease management program in your State

USDA's GDB Web Site
This resource lets you:
! Find and print out online documentation for various VS-AIM database and software
products, such as the user guide for the AWBDS application.
!

Click on links to go directly to interactive help services such as the GDB Helpdesk, the
GDB Discussion Thread, and the Scrapie QuickPlace website.

Click on links to go directly to web pages which contain GDB workshop schedules.

To use this resource, do the following steps:
1. Enter the following URL in your web browser's Address or Location field. (Do not
include www. in the URL.)
http://gdb.aphis.usda.gov

14.1

Draft – 1 Dec 2004

2. When the home page for the USDA GDB web site appears, click on the appropriate link to
go to the information you want.
Click on This Link…

To Find These Resources…

Documentation

-- Online documentation on how to use the GDB Helpdesk service
-- Online documentation for various VS-AIM database and software application
products

Software

-- Links for downloading APHIS/VS-developed software applications
-- Links for downloading software applications specifically for use at
Mexican/Canadian port facilities

Support

-- Link to the GDB Helpdesk service
-- Links to the GDB and Scrapie Discussion Threads
-- Link to the Ftp website, which has an SQL macro library for your use
-- Links to online documentation for VS-AIM database and software application
products

Training

-- Calendar of 2005 GDB and Veterinary Services Databases workshops

14.2

File Type	application/pdf
File Title	Lesson 11 - Creating Person records
Author	Government User
File Modified	2009-04-08
File Created	2004-12-06