17 AUG 2008 14:19 PacFIN Report: Database Tables Page: 1 coldsc_rpt_tbls_only This report was generated using the column description (coldsc) table. This report provides a listing of available tables. TABLE_NAME DESCRIPTION -------------------- ------------------------------------------------------------ LE_grnd_cnts TABLE; contains non-confidential summary fish-ticket data; contains one record for each LE vessel, MGRP, GRID, PCID, permit-list combination LE_grnd_tkts TABLE; contains selected non-confidential fish-ticket data for each fish-ticket for each limited-entry (LE) vessel landing groundfish caught in the PFMC EEZ aar TABLE; contains agency-PacFIN areas relation acm TABLE; contains catch-by-area proportions ag TABLE; contains PacFIN agency_ids and attributes agr TABLE; contains agency-PacFIN gears relation apc TABLE; contains agency-PacFIN processor relation apr TABLE; contains agency-PacFIN ports relation ar TABLE; contains tree of PacFIN area-ids and attributes asp TABLE; contains agency-PacFIN species-id relation bds_ag TABLE; biological data sample_agency to sample_agid mapping bds_age TABLE; biological data age (many to 1 with fish) bds_ar TABLE; biological data agency to PacFIN area code mapping bds_cluster TABLE; biological data clusters (many to 1 with samples) bds_df_acl TABLE; biological datafeed agency-code-list bds_df_report TABLE; biological datafeed report record (most recent) bds_df_warning TABLE; biological datafeed warnings (most recent) bds_fish TABLE; biological data fish (many to 1 with clusters) bds_gr TABLE; biological data agency to PacFIN gear code mapping bds_pr TABLE; biological data agency to PacFIN port code mapping bds_sample TABLE; biological data samples bds_sample_odfw TABLE; biological data sample columns specific to ODFW bds_sp TABLE; biological data agency to PacFIN species code mapping bds_ul TABLE; biological datafeed update log bds_units_conversion TABLE; unit of measure conversion factors block_pos TABLE; center position of blocks cg TABLE; contains coast guard vessels data cl TABLE; contains code list data cnty TABLE; Contains PacFIN county ids amd attributes cnty_region TABLE; Contains PacFIN county region identifiers and description cor_gear TABLE; contains corrected gear info, columns are identical to FTL table with additional columns cor_gear, and rule. dc TABLE; contains detail catch data de TABLE; contains detail effort data dl TABLE; contains detailed updatelog information ft TABLE; contains fish ticket data ftl TABLE; contains fish ticket line data. fusport TABLE: Table fusport includes total commercial landings by port (i.e. pcid). Table fusport includes catch for all species for all management groups, including shellfish and treaty-Indian from all catch areas including Puget Sound, Alaska Ocean areas, the Columbia River, and Washington coastal rivers. gr TABLE; contains tree of PacFIN gear-ids and attributes lbk_catch TABLE; trawl logbook catch records lbk_ftid TABLE; ftid-logbook matching tables lbk_gr TABLE; logbook gear/net-type codes lbk_pr TABLE; logbook port codes lbk_sp TABLE; logbook species codes lbk_strategy TABLE; strategy codes lbk_tow TABLE; Trawl logbook tows lbk_trip TABLE; trawl logbook trips lbk_ul TABLE; logbook update log lep TABLE; contains limited entry permit data lep_app TABLE; contains data of vessels that appealed the denial of a groundfish permit lep_status TABLE; contains domain of permit status lep_type TABLE; contains domain of permit type npac4900 TABLE; contains daily summaries for the W-O-C at-sea fishery summarized from NORPAC tow-by-tow observations nv TABLE; contains non-vessels data used in ft transaction nwr_lep_src TABLE; contains limited entry permits source data from NWR Permit Office ok_gear TABLE; contains FTLs which should not be corrected by gear correction algorithm. columns as in FTL omibbfee TABLE; Vessel Summaries for verifying fee collections for 2003 vessel buy-back project. For NMFS Office of Operations Management and Information pc TABLE; contains codelist of PacFIN codes for ports and also codes for port groups, regions, subregions, counties, joint-ventures(81-90), and foreign countries(81-88). prin_cmplx TABLE; Table includes all vessels, and only vessels, registered to land marine species in W-O-C ports. This includes catch from all areas including Puget Sound, Columbia River, and Alaska areas. prmt_own TABLE; WOC permit owner information prmtdesc TABLE; WOC permit attributes qar TABLE; contains area id of QSM reported catches entry qdisp TABLE: contains QSM data to identify category of fish on various QSM reports qdpar TABLE; contains QSM date parameters qhg TABLE; contains QSM harvest quideline data qovrd TABLE; contains QSM correction factors(CF) override data qpc TABLE; contains QSM port id data qprompts TABLE; contains prompt data of QSM data entry qrc TABLE; contains QSM reported catches data qsc TABLE; contains subset of summary catch used in QSM subsystem qscsp TABLE; contains species id used in QSM and summary catch qsp TABLE; contains species id and gear id for entering QSM reported catches qti TABLE; contains WDFW treaty Indian SABL catches data sc TABLE; contains summary catch data sc_le_oa TABLE; contains summary catch data for limited entry and open access fleets. Used in Quota Species Monitoring (QSM) Subsystem. scm TABLE; contains species composition data scm_history TABLE; contains a history of all species composition data supplied by the state agencies(WOC). se TABLE; contains summary effort data sp TABLE; contains PacFIN species-id and attributes strategy TABLE; PacFIN strategy codes sum_fous2 TABLE; Summary table for the NMFS-DC Fishery Statistics Division F/ST1. Applications include: Fisheries of the U.S.; NMFS/ST1 Internet home page sum_nmfs_st1 TABLE; Summary table for the NMFS-DC Fishery Statistics Division F/ST1. Table contains canadian vessel landings sv TABLE; contains state agency vessel registration records, including vessel-ids and other attributes tkprmtlst TABLE; Produced by program prod/refresh_tkprmtlst.sql. Joins info in the NWR_LEP_SRC object with info in the FTL table. tpy TABLE; Contains yearly trip-principal vessel summary data generated from the build_vsums program. The summations in this table are derived solely from the FT and FTL Oracle data tables. Re-assignment to catch-area and species using ACM and SCM proportions is not included in these summations. Note: Aquaculture has been excluded. ul TABLE; contains log of all database updates vdrfd TABLE; Produced by program prod/refresh_vdrfd.sql. The relation between/among vessels, tickets, date-of-landing, permit(s), fish-ticket category, and post-distribution spid code. ves_sctr TABLE; Produced by program prod/refresh_ves_sctr.sql. Relation between vessels and vessel sectors. Vessel sectors are defined in the CL table. ves_sctr_principal Produced by program prod/refresh_ves_sctr.sql and derived from table VES_SCTR. Relation between vessels and principal sectors. This table differs from VES_SCTR in that it is a cross-tablulation of VES_SCTR. Vessel sectors are defined in the CL table. Vessel sectors are prioritized and not mutually exclusive where the lowest sector number has the highest priority. vescnt TABLE; contains vessel summary data generated from the refresh_vescnt.sql script. vesgrprd TABLE: Vessel-Gear-Time-Period; Contains one entry for each unique combination for year, vessel, and gear used. This table is populated/maintained by routine insert_vesgrprd.sql vesportgr TABLE: Vessel-Port-Gear; Contains one entry for each unique combination for year, vessel, agency, port. This table is populated/maintained by routine insert_vesportgr.sql. The data in table_vesportgr is derived from data in tables: FT, FTL, CG, SV, TPY, and APR vfcmrfd TABLE; Contains monthly vessel summaries with rockfish distributed per fishticket categories. Generated using the refresh_vfcmrfd program. The summations in this table have been developed using the FT, FTL, TKPRMTLST, ACM, and SCM tables/views. vsy TABLE; Contains yearly vessel summary data generated from the build_vsums program. The summations in this table are derived solely from the FT and FTL Oracle data tables. Re-assignment to catch-area and species using ACM and SCM proportions is not included in these summations. Note: Aquaculture has been excluded. wocobs TABLE; WOC Observer data wocprmt TABLE; WOC permit data 162 rows selected. Elapsed: 00:00:00.06