This page contains step-by-step guidance for the most common queries in the Queries menu and their function, but will not be an exhaustive list. This information is primarily intended for Agency staff who need detailed eLandings information for reporting purposes.
| Note |
|---|
These reports with the exception of the Delinquent Fish Ticket Report by Region do not display the statistical area and are more limited in scope than the Landing Details Queries. |
...
The results.csv file will contain each permit broken out into it's component parts and the data associated with that permit. (ex. Revoked or not, Name, etc.)
Dual Permit Queries
Dual Permit Salmon Landing Reports show those landing reports that have more than one CFEC permit associated with them.
| Note |
|---|
There are currently two types of Dual Permit report, w/ Numbers and w/Flag. The search criteria are the same, the only difference is the output. See below for examples of how they differ. |
Select one of the Dual Permit Queries from the menu and click 'Run'.
Enter or select a START_DATE and END_DATE for your query.
Click 'Execute' to generate your results.
The data will be available as a results.csv file.
Bristol Bay Queries
The Assurance Report was developed at the request of Bristol Bay processors to assist them in identifying fish tickets that documented incorrect information. Information contained in the report include:
- Date fishing began
- Date of landing
- Time of landing
- Statarea of harvest
- Gear
- Landing report id
- Fish Ticket Number
- Fishery (as defined by district and gear)
The procedure used by processors is to generate the Bristol Bay Weekly Report and if discrepancies are identified, run the Data Assurance Report to identify the specific report(s) containing incorrect information. The ticket(s) is corrected and the Bristol Bay Weekly Report generated from eLandings again.
Select the Bristol Bay Data Assurance Report from the menu and click 'Run'.
A popup will open and allow you to select your search criteria. Enter a START_DATE and END_DATE.
...