Script Name	Description
lbk_table_stats.sql	lists record counts for each table by year, agency
slct_last_lbk_update.sql	lists information from lbk_ul table for each data year for a given agid.
slct_lbk_load_hist.sql	lists all loads in lbk_ul table for a given agid, datayear
slct_lbk_rejects.sql	lists information on records not loaded for given agid, datayear
slct_lbk_rej_hist.sql	lists rejectinformation for all loads for a given agid, datayear
slct_waterhauls.sql	lists all tows which don't have any hail records associated with them
slct_longtows.sql	lists all tows which were flagged as suspiciously long for a given agency, year

Script Name	Description
slct_tow_arid_spid.sql	list all tows from a given period for a given species in a given area.
slct_tow_arid_period.sql	same as the previous, data is more restricted by time period than by species
area_effort.sql	gives a monthly activity summary for given area/year
vessel_effort.sql	gives a monthly activity report for given vessel/year
slct_trip.sql	Lists trip attributes and total catch by species for given vessel, date
slct_tow.sql	Lists catch by species,tow for given vessel, date
slct_tows_depth_arid.sql	Lists all tows for given depth range, time period, area