Accumulative Landings System Viewlets

These viewlets will show you how to access the information in the National Marine Fisheries Accumulative Landing System (ALS).

These viewlets let you see how to find out more about the tables and columns making up the data.
You will follow the extraction and reporting process step by step.
Extra notes on the screen guide the viewer to a deeper understanding of the task at hand.

SEFSC_ACCESS_Overview Viewlet or Printable PDF Version(very large): An overview explaining how to sign on to the Delphi Computer and to gain information about the Accumulative Landings System.
Using_SQL_Plus or Printable PDF Version(very large): How to use SQL*Plus to view the tables and codes needed to query ALS and to interpret system output. Please view it even if you are comfortable with SQL. It contains descriptions of the most important code tables used in the extractions and reports.
Transferring Files From The Delphi To Your PC or Printable PDF Version(very large): How to bring a file from the Delphi down to your personal computer.
Extraction or Printable PDF Version(very large): How to generate a text file containing the ALS data that meets your selection criteria.
Loading Text Into Excel or Printable PDF Version(very large): How to create an Microsoft Excel spreadsheet from your extract file.
Custom Data Extraction or Printable PDF Version(very large): How to create a custom extract file that summarizes price, value and number of dealers for the grouping variables you specify.
Als Reports or Printable PDF Version(very large): How to create a custom extract file that summarizes price, value and number of dealers for the grouping variables you specify.