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 |
|---|
The report, Delinquent Fish Tickets is a statewide report and is normally used by the Headquarters staff. Local staff chooses the Delinquent Fish Tickets by Port or by Region. |
When you select the delinquent report, a dialog box opens and requests that you set the number of days delinquent. If you do not set the days delinquent, then all un-batched fish ticket reports will be returned. Please also keep in mind that all un-batched fish ticket reports, for all fisheries are returned.
...
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
...
The results will be downloaded (or emailed) as results.csv. Below you can see a TEST version of the report.
Landing Report Queries
"Report Detail by ..." Queries
Fisheries Mgmt Pgm (Fisheries Management Program)
...