This page contains step-by-step guidance for the most common queries in the Queries menu and their function. This information is primarily intended for Agency staff who....
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.
Delinquent Fish Ticket Queries
To access the Delinquent Fish Ticket reports, simply click on the Queries drop down menu and again, select Queries.
Please note the Delinquent Fish Ticket reports. These reports help you 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.
