PGA Information
The
PGA Mapping
screen contains several options for adding PGA data to records. These methods are described in the sections listed below.Manual Data Input
PGA data can be manually added or modified per record. This is ideal in instances where only a few records need their PGA data updated or added.
To manually add PGA data:
- Choose a record from the grid below to edit.
- After a record is chosen, click its correspondingEditlink on the far left to open the standardPGA Managementpop-up.

- Enter any necessary data or make any necessary changes.
- ClickSaveto save the update.
If templates have been set up, a template can also be applied to the record using this screen. For more information about setting up PGA Templates, refer to the Global Classification User Guide.

Spreadsheet Upload
To update product records as a group:
- Open the applicable tab.
- ClickExtracton the top right corner of the grid. IfExtractwas clicked while on theMissing PGA Recordstab, theExtractpop-up will open.

- Choose an Agency Code and Program Code to be extracted.
- ClickExtract.

If
Extract
was clicked while on a specific PGA tab (e.g., APHIS
), the spreadsheet will automatically filter the results by the Agency/Program Code tab that was selected when Extract
was clicked. 
The extracted data will generate in the form of a Microsoft Excel spreadsheet.
- Open the spreadsheet.
- Enter the missing/updated PGA information.
- Save changes.
The columns in the Excel file are formatted based on the Agency requirements that were selected for that Agency/Program Code. As a result, do not change the columns in the Excel file before re-uploading the data.
Once the spreadsheet is completed, click
Upload
to the right of the Extract
button. This will upload the final spreadsheet to the PGA Mapping
screen. 
The information will then be uploaded into the system. To validate the contents against the system’s rules, click on the “
Validate
” button.
After validation starts, the following message will appear on the screen until validation is complete:

After validation is complete, a message containing the number of validation errors will appear on the screen. Errors can be resolved by editing a record.

To edit a record, choose a record from the grid and click on its corresponding “Edit” button in the leftmost column.
