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.
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 different types of queries and their use can be found below.
Accessing the Queries Menu
To access the Delinquent Fish Ticket reports, simply click on the Queries drop down menu and again, select Queries.
Delinquent Fish Ticket Queries
The Delinquent Fish Ticket reports show up in the main query list. These reports help identify landing reports that have been created and saved in the eLandings repository database, but the signed copy of the fish ticket has not been either submitted to the local office of ADFG or has yet to be processed by staff. This is a pretty simple report as it searches for and returns all records without batching information – the Office code, Batch number and Sequence number.
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.
Please note in the illustration below, highlighted in yellow, the range of CFEC permits, from groundfish to salmon.
To display and save only those reports that is pertinent to your fisheries management team, simply select the Excel filter feature.
Select Sort & Filter and then Filter. When you make this selection a down arrow will appear on each on the columns. Click on the CFEC Fishery column and a complete summary of all permit fisheries in the spreadsheet will display. All values will be selected. Simply unclick the Select All option at the beginning of the list and then scroll thru the list to locate the CFEC Fisheries that you wish to review.
Once the filter is determined, only those records that pertain to your requirements are displayed.
Permit Queries
Their are several types of Permit Queries that show up in the main query list. These queries will help identify various permits that exist in eLandings and the users that posses them.
CFEC Permit Query
This query will allow you to see all CFEC Permits and the information associated with a particular Permit.
Select CFEC Permits from the menu and click 'Run'.
A popup will open to allow you to enter your desired search criteria.
You can either type a date directly into the box, or use the Calendar that will appear when you select the field.
Enter a START_DATE.
Enter an END_DATE.
After you've entered the date range click 'Execute' to run the query.
After the query runs it will either email or download a .csv file depending on whether or not 'Email Results' is checked.
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.
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.
Enter the PROC_CODE (a processor or F-code) for the processor whose data you desire.
The results will be downloaded (or emailed) as results.csv. Below you can see a TEST version of the report.
Landing Report Queries
Operations Queries
Processor Queries
Sealandings Queries
Trip Number Queries
Other Queries
Voided Landing Reports
This query will let you see all the years (select when running) voided landing reports.
Select the query from the list and click 'Run'.
Enter the Year and click 'Execute'.
The results will be a .csv file.
