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.
...
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.
Federal Permit Query
The Federal Permit Query provides a list of all the valid Federal Processor Permits (FPP) and Federal Fisheries Permits (FFP) from a specified time frame. This query will combine both the FFPs and the FPPs into .csv document. The information that is included is:
- Federal Permit Number (either the FFP or FPP)
- Processor Name
- At Sea Processor (Yes/No)
- License Year
- Effective Date
To run the Federal Permit Query, navigate to Queries/Tools > Queries, then navigate to page 2 using the page numbers at the bottom of the screen.
Find the Federal Permit query, and select the "Run" button associated with it.
Enter the START_DATE and the END_DATE. Then select "Execute" to generate the report. The report will either download immediately if you have unchecked the Email Results box, or be sent to the email address on file with your User ID.
The results will download in a .CSV file for you to search and sort as needed.
Bristol Bay Queries
...
Clicking on the download will open the file in excel. From here you can search and manipulate the data as desired.
Report Detail By...
There are multiple queries that begin with "Report Detail by..." They are:
- Report Detail by CFEC Fishery
- Report Detail by CFEC Fishery and Management Program
- Report Detail by Management Program
- Report Detail by Port and CFEC Fishery
- Report Detail by Port and Management Program
These reports can be found with the other queries on pages 4 and 5.
The five reports all provide landing details with results narrowed by different parameter combinations. All five are narrowed by a selected date range, then depending on your needs, you can choose one of the five reports to further narrow the search. Because they all have the same functionality and provide the same informational details, only one example is provided. However, this one example should give you an understanding of how to run these five reports effectively.
To run the Report Detailsby CFEC Fishery and Management Program, first click the "Run" button associated with it.
Enter the CFEC Fishery, the Fishery Management Program, and the start and stop date. then hit execute.
The Report Detail by CFEC Fishery and Management Program report will download. Landings include Management Program, Program ID, CFEC Permit number, ADF&G, date of landing, port of landing, Proc Code, Fish Ticket Number, gear code, species code, species condition code, landed weight, round weight, ice and slime, disposition code, harvest code, ADF&G Office code, Sequence ticket number, landing report number, report type and trip number. There will be a line for each species reported on each fish ticket.
Operations Queries
...