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) for a specified time frame. This query will combine both the FFPs and the FPPs into one excel sheet. 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 select page 2
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, or be sent to the email address associated with the User ID.
The results will download in a .CSV file for you to search and sort as needed.
Bristol Bay Queries
...
Sealandings Emaillf History
Sealandings Email Emaillf History provide programmers, and eLandings support staff with a detailed log of file transmissions being sent in to the sealandings server. To get this information, sign into the Agency Web interface, then navigate to Queries/Tools>Queries. Use the page numbers at the bottom of the query page to navigate the queries and get to the sealandings Emaillf History Query. Click the "Run" button associated with on the seaLandings Emaillf History Queryline.
No parameters are required, so clicking "Execute" is all that you need to do to start starts the query download.
The .CVS sheet that downloads will have details about the IERS Monitor Date, the user ID, and the webservice method to search and sort as needed.
Sealandings
...
Emaillf User
The Sealandings Emailif Emaillf User provide provides important information about sealandings user users to eLandings staff. This information is primarily used to assist sealandings users with troubleshooting problems that may arise.
To run the Sealandings Email Emaillf User Query, use the eLandings Agency website to navigate to Queries/Tools > Queries, then use the page numbers at the bottom of the screen to navigate the to Sealandings Emailif Emaillf User Query. Click "Run" to start.
To execute the query, first click "Run", then click "No parameters are needed to run this query. To begin the download, click "Execute."
If you have choosen to have the results emailed, Leaving the "Email Results" box checked will result in the query .csv file to be sent to the email address associated with your user name. If the box remains checked, once you click "Execute" the Execute Query dialog box will close , and a green message about the status informational banner will appear at the top of your screen providing information on the success of the screenthe query request, and a time frame within which the results will be emailed.
In approximately 5 minutes, When the results are processed you will receive an email with the a .csv file attachedattachment.
Open the email and download the attachment
The When you open the query file it will provide you with UserIDs, Schema version, the last date the user logged into sealandings, and the number of calls to the server for all active sealandings user IDs.
Sealandings User Version
The Sealandings User Version query provides details about which version of sealandings and which schema the operating system sealandings users are operating. This is especially useful when sending receipts to users. To run this query, find it in the queries and select "Run."utilizing. This query takes the sealandings emaillf user query and expands on it, providing more details for troubleshooting or sending receipts.
To run this query, go to Queries/Tools > then Queries. Use the page numbers at the bottom of the screen to search through queries and find the query entitled "Sealandings User Version, select the "Run" button on the same line.
No information is needed to create parameters on give this search . It will search for and provide a list of all parameters, it will return information on every registered sealandings user.
To execute the query and start the download, select click "Execute."
the The .csv file will open and download. automatically begin downloading.
The information provided in the report includes the User ID, the operating system that the sealandings program is installed on, the java version, the release build they are operating, the schema version, last date of use, and number of calls to the server.
To search for a user, go to or narrow the results, click on the Data Tabtab, then hit "SortFilter." By clicking Next, click the down arrow at arrows on the column header you to open options for filter the results. You can use the search field in any column to narrow the resultsbar, or sort the columns.
Trip Number Queries
Other Queries
...