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
...
Immediately the list will sort by number of reports, and allow the user to see the closed or archived operations with the most number of reports.
Processor Queries
SeaLandings Queries
There are three SeaLandings Queries available in the Agency Web. These three queries are used to help eLandings staff provide user support to seaLandings users.
Sealandings Emaillf History
...
Operations for a User
The query "Operations for a User" lists all the operations an eLandings user is authorized on. To run this report navigate to Queries/Tools > Queries. Use , and then using the page numbers at the bottom of the screen, find the query page to navigate the queries and get to the Sealandings Emaillf History Query then "Operations for a User" query, and click the "Run" button on the same lineassociated with it.
No parameters are required, so clicking "Execute" will start the query download.
A .CVS document will begin downloading. The document will have details about the IERS Monitor Date, the user ID, and the webservice method.
Sealandings Emaillf User
The Sealandings Emaillf User provides important information about sealandings users to eLandings staff. This information is primarily used to assist sealandings users with troubleshooting problems that may arise.
To run the Sealandings Emaillf User Query, use the eLandings Agency website to 
You will need to know the User ID that you wish to search for. Enter that User ID in the Value box, then click "Execute"
The .CSV file will download and can be opened in an excel spread sheet. The query will provide a list of all the operation names that the selected user is authorized on, as well as the operation ID, authorization type, and the status of the operation.
Processor Queries
SeaLandings Queries
There are three SeaLandings Queries available in the Agency Web. These three queries are used to help eLandings staff provide user support to seaLandings users.
Sealandings Emaillf History
Sealandings 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, then use . Use the page numbers at the bottom of the screen query page to navigate the queries and get to the Sealandings Emaillf User Query. Click History Query then click the "Run" to start.
button on the same line.
No parameters are needed to run this query. To begin the download, click "Execute."
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 informational banner will appear at the top of your screen providing information on the success of the query request, and a time frame within which the results will be emailed.
When the results are processed you will receive an email with a .csv attachment.
Open the email and download the attachment
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 the operating system and software versions that sealandings users are operating with. 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 > 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 give this search parameters, it will return information on every registered sealandings user.
To execute the query and start the download, click "Execute." The .CSV file will 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 or narrow the results, click on the Data tab, then hit "Filter." Next, click the down arrows on the column header to open options for filter the results. You can use the search bar, or sort the columns.
...
required, so clicking "Execute" will start the query download.
A .CVS document will begin downloading. The document will have details about the IERS Monitor Date, the user ID, and the webservice method.
Sealandings Emaillf User
The Sealandings Emaillf User provides important information about sealandings users to eLandings staff. This information is primarily used to assist sealandings users with troubleshooting problems that may arise.
To run the Sealandings 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 Emaillf User Query. Click "Run" to start.
No parameters are needed to run this query. To begin the download, click "Execute."
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 informational banner will appear at the top of your screen providing information on the success of the query request, and a time frame within which the results will be emailed.
When the results are processed you will receive an email with a .csv attachment.
Open the email and download the attachment
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 the operating system and software versions that sealandings users are operating with. 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 > 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 give this search parameters, it will return information on every registered sealandings user.
To execute the query and start the download, click "Execute." The .CSV file will 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 or narrow the results, click on the Data tab, then hit "Filter." Next, click the down arrows on the column header to open options for filter the results. You can use the search bar, or sort the columns.
Trip Number Queries
Logbook Queries
Flow Scale Tests Query
The Flow Scale Test Query provides a summary of all the flowscale tests recorded in a single vessel's logbook. To retrieve this information, use the Agency Web to navigate to Queries/Tools > Queries. Use the page numbers at the bottom of the browser screen to navigate through the queries until you find the Flow Scale Tests Query.
Select the "Run" button associated with the Flow Scale Query.
Enter the date range you wish to search for using the START_DATE and END_DATE, then enter target vessel's ADF&G. Click "Execute" to generate the report
The .CSV file will download and can be opened in an excel spreadsheet. The query will contain all the entered flow scale tests entered by the selected vessel within the date parameters set. Addition information will include Logbook ID, the entry sequence of the flow scale test, time of test, platform weight, flow scale test weight, the percentage error and any comments entered.
Production Report Summary
The Production Report Summary is used to see a detailed summary of all production reports for an at sea or shoreside operation. The report provides a spreadsheet with each line on all production reports based on the date parameters.
To run the Production Report Summary Query, navigate to Queries/Tools > Queries; then, using the page numbers at the bottom of the browser screen, navigate through the pages until you find the Production Report Summary Query. To start the query, click the "Run" button associated with it.
Enter the federal permit number you wish to search (either the FFP or the FPP) and the date parameters, using the START_DATE and STOP_DATE. Click Execute to run the query.
A detailed .CSV document will download. Users can sort and filter for species, disposition code, or management program as needed to narrow the detailed information.
Other Queries
Voided Landing Reports
...