PacFIN - Table Column Descriptions

This page shows and describes the columns in tables available in the PacFIN database.

TABLE NAME
COLUMN NAME
DESCRIPTION
aar Agency/PacFIN area relationship data
agid An agency identifier
area Source agency catch area identifier
arid PacFIN area code
description Description of area
modified Boolean (T/F); ='T' if this record had been modified
ulid Report number of initial data feed or of most recent modification (update log id)

TABLE NAME
COLUMN NAME
DESCRIPTION
acm Catch-by-area proportions data
agid An agency identifier
arid PacFIN area identifier
coeffvar Coefficient of variance
comptype type of composition value contained in PROPORTION see COMP-TYPE in table cl
day Day of week (Ignored if period='M' or 'Q'; if period='W' specifies that proportion applies to the 7-day period ending on this YEAR-MONTH-DAY). (Format: dd)
grade Composition grade (same as in table ftl; may be null)
grid PacFIN gear or gear group code
modified Boolean (T/F); ='T' if this record had been modified
month Month or quarter for which proportion applies (if period='Q' then specifies last month of quarter (3 ⇒ Q1, 6 ⇒ Q2, 9 ⇒ Q3, 12 ⇒ Q4)) (Format: mm)
pcid PacFIN port identifier (may be null)
period Time period used (w=week; m=month; q=quarter)
proportion Estimated proportion for the area within specified time-period, comptype, pcid, grid, spid, grade and trip type
samples Number of samples
spid PacFIN species identifier
triptype Type of fishing trip (for more information, see trip-type in table cl)
ulid Report number of initial data feed or of most recent modification (update log id)
year Year for which proportion applies. (Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
ag PacFIN agency_ids and attributes
agid An agency identifier
completion_90 Date that the agency data update is 90% completed
description Description of the agency
lbstons Boolean (T/F); ='T' if input is lbs; ='F' if input is .01 metric tons
name Agency or source name
pmfcinpfc Boolean (T/F); ='T' if input is by psmfc areas; ='F' if input is by inpfc areas
usdomestic Boolean (T/F); ='T' if the agency is a U.S. domestic agency and not a data source for joint venture or foreign data and not a foreign agency supplying their domestic data

TABLE NAME
COLUMN NAME
DESCRIPTION
agr Agency/PacFIN gear relationship data
agid An agency identifier
description Description of gear id
gear Source agency gear identifier
grid PacFIN gear or gear group code
modified Boolean (T/F); ='T' if this record had been modified
ulid Report number of initial data feed or of most recent modification (update log id)

TABLE NAME
COLUMN NAME
DESCRIPTION
apc Agency/PacFIN processor relationship data
agid An agency identifier
description Description of processor
modified Boolean (T/F); ='T' if this record had been modified
processorid The identifier for the processor company or buyer that processed, or received, the delivery of fish. For CDFW this column contains a buyer-id and the processor-id is derived by taking the first five characters only.
ulid Report number of initial data feed or of most recent modification (update log id)

TABLE NAME
COLUMN NAME
DESCRIPTION
apr Agency/PacFIN port relationship data
agid An agency identifier
cdistrict Congressional district that the port is within.
cid County identifier
description Description of port
modified Boolean (T/F); ='T' if this record had been modified
pcid PacFIN port identifier (may be null)
port Source agency port identifier
ulid Report number of initial data feed or of most recent modification (update log id)

TABLE NAME
COLUMN NAME
DESCRIPTION
ar PacFIN area-ids and attributes data
argroup The area's area group
arid PacFIN area identifier
arorder North to south order of areas
council Council in which the area resides (N=npfmc; P=pfmc; *=neither council)
description Description of the area
entered Date row was entered into the database or date of last modification (format: dd-MMM-yy)
inpfc_area INPFC area identifier (type = 1 (psmfc), type = 2 (inpfc), type = 7 (inpfc subarea) or type = 8 (psmfc subarea) otherwise it is null)
inputallowed Boolean (T/F); ='T' if input transactions can use this area
name the Area's short-name (for reporting)
summarized Boolean (T/F); ='T' if summarized data exists for this code
type Area type (1=psmfc; 2=inpfc; 3=inpfc-grp; 4=shrimp; 5=salmon; 6=salmon-grp; 7=inpfc subarea; 8=psmfc subarea; 99=all)

TABLE NAME
COLUMN NAME
DESCRIPTION
asp Agency/PacFIN species-id relationship data
agid An agency identifier
category State agency species identifier category (i.e. market category)
description Description of species
modified Boolean (T/F); ='T' if this record had been modified
spid PacFIN species identifier
ulid Report number of initial data feed or of most recent modification (update log id)

TABLE NAME
COLUMN NAME
DESCRIPTION
bds_ag Biological data samples including agency to sample agency id mapping information
agid An agency identifier
sample_agency Agency sample agency code
sample_agid PacFIN sample agency code

TABLE NAME
COLUMN NAME
DESCRIPTION
bds_age Biological data samples ages (many to 1 with fish)
age Age of fish in years
age_method Aging method:
WDFW (B-break and burn; L-length; N-not aged; O-optical scanner; X-sectioning)
ODWF (1-break and burn; 2-surface; 3-scales; 4-thin section; 5-optical scanner; 6-length; 9-unable)
CDFW (B-break and burn; S-surface; T-thin section)
age_no Sequential number for each age
age_readability Age readability (WDFW only)
age_struct PacFIN age structure code
age_struct_agcode Source agency age structure code
aged_by Person who read structure age (WDFW only)
cluster_no Sequential number for each cluster in sample
date_aged date sample was aged (WDFW only) (Format: dd-MMM-yy)
fish_no Sequential number for each specimen (fish) in sample
sample_no Unique number for each sample
sample_year Year in which sample was obtained. (Format: yyyy)
source_agid PacFIN code of source agency
species_code Agency species code
spid PacFIN species identifier

TABLE NAME
COLUMN NAME
DESCRIPTION
bds_age_code Biological data samples age codes
agid Source agency for data
age_code Agency age code
age_yr PacFIN age code
description Description
modified Whether data has been modified or not (T/F)

TABLE NAME
COLUMN NAME
DESCRIPTION
bds_age_struct Biological data samples age structure codes
source_agid Source agency for data
age_struct_agcode Agency code for age structures
age_struct PacFIN age structure code

TABLE NAME
COLUMN NAME
DESCRIPTION
bds_ar Biological data samples including agency to PacFIN area code mapping information
agid An agency identifier
area Source agency catch area identifier
arid PacFIN area code
description Description of area
modified Boolean (T/F); ='T' if this record had been modified

TABLE NAME
COLUMN NAME
DESCRIPTION
bds_cluster Biological data samples including data clusters (many to 1 with samples)
adj_clwt Weight (pounds) of the cluster that the specimen came from minus weight of fish that can't be aged (ODFW only)
cluster_no Sequential number for each cluster in sample
cluster_wgt Weight (pounds) of the cluster that the specimen came from
frame_clwt Weight (pounds) of the cluster that the specimen frame came from in postprocessing sample (ODFW only)
sample_no Unique number for each sample
sample_year Year in which sample was obtained. (Format: yyyy)
source_agid PacFIN code of source agency
species_code Agency species code
species_wgt Weight (pounds) of the target species
spid PacFIN species identifier

TABLE NAME
COLUMN NAME
DESCRIPTION
bds_cond Biological data samples catch condition codes
source_agid Source agency for data
cond_agcode Agency catch condition codes
cond PacFIN condition codes

TABLE NAME
COLUMN NAME
DESCRIPTION
bds_df_acl Biological data samples including datafeed and agency code list information
agency_code A valid agency code
code_type The type of agency code being submitted. values: S = agency species code, A = agency area code, G = agency gear code, P = agency port code.
description If code_type = S then scientific name and/or common name and/or general description, if code_type = A then description of area, if code_type = G then description of gear, if code_type = P then name of port.
pacfin_code A valid PacFIN species, area, gear or port code

TABLE NAME
COLUMN NAME
DESCRIPTION
bds_df_report Biological data samples datafeed report records (most recent)
comm_desc Comment or description regarding this periodic report.
rpt_date The date the datafeed report was generated (two datafeeds from the same source may not have the same date)(Format: dd-MMM-yy)
source Agency acronym (name in ag table) (Values: WDFW = Washington Dept of Fish and Wildlife, ODFW = Oregon Dept of Fish and Wildlife, CDFW = California Dept of Fish and Wildlife, NWFSC = Northwest Fisheries Science Center, AFSC = Alaska Fisheries Science Center)

TABLE NAME
COLUMN NAME
DESCRIPTION
bds_df_warning Biological data samples datafeed warnings (most recent)
agid An agency identifier
message Message describing what is wrong with the data
more_info More information about the data that caused the warning
sample_year Year in which samples were obtained. (Format: yyyy)
trans_id Transaction identifier

TABLE NAME
COLUMN NAME
DESCRIPTION
bds_disp Biological data samples catch disposition codes
source_agid Source agency for data
disp_agcode Agency catch disposition codes
disp PacFIN disposition codes

TABLE NAME
COLUMN NAME
DESCRIPTION
bds_fish Biological data samples fish data (many to 1 with clusters)
brood_yr Year of brooding (widow rockfish only)(ODFW only)(Format: yyyy)
cluster_no Sequential number for each cluster in sample
fish_age_years_final Age of specimen (best age or final age)
fish_length Length of specimen in millimeters (mm)
fish_length_type Length type (A = alternate length, F = fork length, S = standard length, T = total length)
fish_no Sequential number for each specimen (fish) in sample if bds_fish.freq = 1 (if bds_fish.freq > 1 then represents a group of fish)
fish_weight Weight (pounds) of fish
fork_length Fork length (mm) of fish, either measured or estimated
fork_length_estimated Flag indicating source of fork_length (T = True, fork_length was estimated F = False, fork_length was measured)
frame_wt Weight (pounds) of specimen frame in postprocessing sample(ODFW only)
freq Specifies the number of fish observed with the same characteristics specified in the other columns of each bds_fish record
maturity PacFIN maturity code
maturity_agcode Agency maturity code. ((W=?), (O: 0=unknown, 1-2=immature,3-8=mature), (C: 1=immature,2,3,4,5,6,7,8 =undeterminable, 9=not noted))
sample_no Unique number for each sample
sample_year Year in which sample was obtained. (Format: yyyy)
sex PacFIN sex code
sex_agcode Source agency sex code
source_agid PacFIN code for source agency
species_code Source agency species code
spid PacFIN species identifier

TABLE NAME
COLUMN NAME
DESCRIPTION
bds_gr Biological data samples including agency to PacFIN gear code mapping information
agid An agency identifier
description Description of gear
gear Source agency gear identifier
grid PacFIN gear or gear group code
modified Boolean (T/F); ='T' if this record had been modified

TABLE NAME
COLUMN NAME
DESCRIPTION
bds_maturity Biological data samples maturity codes
source_agid Source agency for data
maturity_agcode Agency maturity codes
maturity PacFIN maturity codes

TABLE NAME
COLUMN NAME
DESCRIPTION
bds_pr Biological data samples with agency to PacFIN port code mapping information
agid An agency identifier
description Description or name of port
modified Boolean (T/F); ='T' if this record had been modified
pcid PacFIN port identifier (may be null)
port Source agency port identifier

TABLE NAME
COLUMN NAME
DESCRIPTION
bds_sample Biological data samples with sample information
block State fishing area block number
comments Comments
cond PacFIN condition code
cond_agcode Agency condition code
data_type Data type will be either "C" = commercial sample or "S" = Survey
dealer Dealer code or name of plant where sample was obtained
depth_avg Average depth fished in fathoms
depth_max Maximum depth fished in fathoms
depth_min Minimum depth fished in fathoms
disp PacFIN disposition code
disp_agcode Agency disposition code
drvid A coastwide vessel identifier. Can be a USCG VID (ex: 1234567 or AK1234nn) or a ZZZ identifier indicating no vessel used, vessel id not provided, or an invalid vessel identifier provided
females_num Number of females in sample
females_wgt Weight (pounds) of females in sample
ftid Fish ticket number
gear Source agency gear identifier
grade PacFIN grade code
grade_agcode Agency grade code
grid PacFIN gear or gear group code
inpfc_area Agency INPFC area code
inpfc_arid PacFIN INPFC area code (type 2)
latitude Latitude in decimal degrees
longitude Longitude in decimal degrees
males_num Number of males in sample
males_wgt Weight (pounds) of males in sample
market_category Agency market category (state spcode) of species sampled market_category (submitted by CA and OR; null for WA)
mesh size Mesh size in tenths of inches
other_sample_no Other sample number if received from another agency
pcid PacFIN port identifier (may be null)
port Source agency port identifier
psmfc_area Agency PSMFC area code. (Values are: (W: 1C, 2A, 2B, 2C, 2E, 2F, 3A, 3B,3C, 3N, 3S) (O: 1C, 2A, 2B, 2C, 2E, 2F, 3A, 3B, CS) (C: 1A, 1B, 1C))
psmfc_arid PacFIN PSMFC area code (type 1)
sample_agency Agency code for agency that obtained sample (N=NMFS Newport, W, WA=WDFW, OR, O=ODFW, C,CA=CDFW, T=NMFS Tiburon, ED=EDCP, MS=Mackerel Studies, PW=Pacific Whiting, SP=Special projects, T-Treaty)
sample_agid PacFIN code for agency that obtained sample
sample_day Day of month that sample was obtained. (Format: dd)
sample_method Sample method (R=Random, S=Stratified, N=Systematic, P=Purposive, X=Special)
sample_month Month (MM) in which sample was obtained. (Format: mm)
sample_no Unique number for each sample
sample_strat Sample stratification
sample_type Sample type (M=Market, R=Research, S=Special request, C=Commercial on-board)
sample_year Year in which sample was obtained. (Format: yyyy)
sampler_code Sampler initials or number
second_stage_unit Second stage of sample design (fixed number or weight)
source_agid PacFIN code of source agency. W=Washington, O=Oregon, C=California, M=NWFSC, F=AKFSC
total_clusters Number of clusters in sample
total_fish Number of fish in sample
total_wgt Total landed weight (in pounds) for just that species portion of the landed catch
veid Vessel identifier
weight_source Weight source
wgtmax Top of weight range (pounds) that processor is using to define grade (NWFSC srtgrp) for this sample
wgtmin Bottom of weight range (pounds) that processor is using to define grade (NWFSC srtgrp) for this sample

TABLE NAME
COLUMN NAME
DESCRIPTION
bds_sample_odfw Biological data samples with sample information columns specific to Oregon Department of Fish and Wildlife
adj_bothn Total number of "adjusted" fish in sample
adj_fmnum Total number of females minus number of females that can't be aged
adj_fmwt Total weight (pounds) of females minus estimated weight of females that can't be aged (estimates come from the most current length/weight equation accepted for that species and sex)
adj_mnum Total number of males minus number of males that can't be aged
adj_mwt Total weight (pounds) of males minus estimated weight of males that can't be aged (estimates come from the most current length/weight equation accepted for that species and sex)
chan1 Descriptor for 1st loran coordinate
chan2 Descriptor for 2nd loran coordinate
exp_wt Weight (pounds) the sample will be expanded to (default is the landing weight). This value may be larger or smaller than total_wgt depending on various situations documented in text file ∼pacfin/doc/bds_odfw_expanded_weight.txt
fr_bothn Total number of frames in postprocessing sample
fr_fmnm Total number of female frames in postprocessing sample
fr_fmwt Total weight (pounds) of female frames in postprocessing sample
fr_mnum Total number of male frames in postprocessing sample
fr_mwt Total weight (pounds) of male frames in postprocessing sample
hours Hours fishing
keep Flag field indicating whether the sample can be aged (default is "True")
max_sizein Maximum grade size (inches) for length graded species
max_sizelb Maximum grade size (pounds) for weightgraded species
min_sizein Minimum grade size (inches) for length graded species
min_sizelb Minimum grade size (pounds) for weight graded species
msec1 First loran coordinate of catch
msec2 Second loran coordinate of catch
nspec Number of specimens of sample
quality Sample quality level
sample_no Unique number for each sample
sample_year Year in which sample was obtained. (Format: yyyy)
sampler Sampler's name(s)
source_agid PacFIN code of source agency
start_bien Otolith tray number first otoliths go into
state State area of catch (default is area of port if area of catch is not known)
tow Trawl tow that was sampled (if known)
unk_num Total number of sex unknown fish in sample
unk_wgt Total weight (pounds) of sex unknown fish in sample
vess_name Vessel name

TABLE NAME
COLUMN NAME
DESCRIPTION
bds_sex Biological data samples fish sex codes
source_agid Source agency for data
sex_agcode Agency codes for each sex - numerical
sex PacFIN codes for each sex - M/F or U for unknown

TABLE NAME
COLUMN NAME
DESCRIPTION
bds_sp Biological data samples with agency to PacFIN species code mapping information
agid An agency identifier
description Scientific name and/or common name and/or general description
modified Boolean (T/F); ='T' if this record had been modified
spcode Agency species code
spid PacFIN species identifier

TABLE NAME
COLUMN NAME
DESCRIPTION
bds_ul Biological data samples datafeed update log
agid An agency identifier
processdate Date on which the datafeed was processed. (Format: dd-MMM-yy)
rptcomment Comment or description regarding the datafeed
rptdate The date the datafeed report was generated (two datafeeds from the same source may not have the same date) (Format: dd-MMM-yy)
sample_year Year in which samples were obtained. (Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
bds_units_conversion Biological data samples unit of measure conversion factors information
conv_factor Conversion factor used to convert from_um to to_um
from_um From unit of measure
to_um To unit of measure
unit_domain Unit domain ("WEIGHT" or "LENGTH")

TABLE NAME
COLUMN NAME
DESCRIPTION
block_pos Center position of fishing area blocks
agid An agency identifier
block Block number
lat Latitude at block center point
lon Longitude at block center point

TABLE NAME
COLUMN NAME
DESCRIPTION
cg Coast Guard vessels data
adr1 Vessel owner's address (line 1)
adr2 Vessel owner's address (line 2)
adr3 Vessel owner's address (line 3)
bldyr Year the vessel was built. (Format: yyyy)
breadth Breadth of beam, widest measure
city Vessel owner's city
cname Vessel owner's company name
depth Depth of hold
fname Vessel owner's first name
grosswt Vessel's gross weight (tons)
hailing_port Port where vessel is based
hp Horse power of vessel
hp_main_astern Main power at stern
hull_config Configuration of hull
hull_design Type of hull
hull_material Material hull is composed of
hull_number Hull number (identifier)
hull_shape Shape of hull
latest Boolean (T/F); ='T' if this record has the latest pubyr+pubmo of the vid
len Length of vessel (feet)
lname Vessel owner's last name
netwt Vessel's net weight (tons)
pubmo Month data of vessel was published. (Format: MMM; ex. JAN)
pubyr Year data of vessel was published. (Format: yyyy)
service Vessel service type
state Vessel owner's state
trade1 Trade indicator 1=coastwise unrestricted
trade2 Trade indicator 2=Great Lakes
trade3 Trade indicator 3=fisheries
trade4 Trade indicator 4=bowater
trade5 trade indicator 5=registry
trade6 Trade indicator 6=recreation
vid Vessel identifier
vname Vessel name
zip Vessel owner's zip code

TABLE NAME
COLUMN NAME
DESCRIPTION
cl Code list data
code Actual code
description Description of the code
length Length of code
name Name of the code list
year Code's effective year (0=all years) (Format: y)

TABLE NAME
COLUMN NAME
DESCRIPTION
cnty PacFIN county ids and attributes data
cid County identifier
corder Used to order counties from south to north.
county Name of county.
entered Date row was entered into the database or date of last modification. (Format: dd-MMM-yy)
rid1 Regional identifier #1; groups counties into regions; see table cnty_region
rid2 Regional identifier #2; groups counties into regions; see table cnty_region
shortname Short name is used for reporting.
state State abbreviation (2 characters)

TABLE NAME
COLUMN NAME
DESCRIPTION
cnty_region PacFIN county region identifiers and description information
region Description of the region
rid Regional identifier; groups counties into regions;

TABLE NAME
COLUMN NAME
DESCRIPTION
cor_gear Corrected gear information (Columns are identical to fish ticket lines (FTL) table with additional columns cor_gear, and rule.
agid An agency identifier
area Source agency catch area identifier
areatype Type of area of this catch (see area-type in table cl)
category State agency species-id or market_category.
CDFW_origin Origin of catch (CDFW transactions only, contains CDFW block number)
cond Condition of catch at time of landing (see condition in table cl)
cor_gear Gear group assigned by correction algorithm.
day Day the catch was delivered by the fisher (Numeric, # in month)(Format: dd)
disp Disposition of this catch (see disposition in table cl)
estimated Boolean (T/F); ='T' if dollar value is estimated.
factor Round weight conversion factor scaled nn.nnn.
ftid Fish ticket identifer from fish ticket
gear Source agency gear identifier
grade Grade and size category of this catch; see grade in table cl.
landed_wt Landed weight, units=pounds.
modified Boolean (T/F); ='T' if this record has been modified.
month Month the catch was delivered by the fisher (Numeric, # in year) (Format: mm)
num_fish The number of fish caught (nominally for salmon only. For CDFW salmon for 1986 thru the present this statistic is a derived value based on average weights developed from samples. For CDFW for 1981-1985 numbers-of-fish for salmon are not available (i.e. num_fish is set to null).)
pargrp Participation group (see par-group in table cl)
ppp Price per pound (units = dollars per pound (xxxx.xxx))
rule Rule applied to correct gear
ulid Report number of initial data feed or of most recent modification (update log id)
worst_est Boolean (T/F); ='T' if worst $/lb estimate from species dataset was used for ftl ppp in this record.
year Year the catch was delivered. (Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
dc Detailed catch data
agglvl Detail aggregation level (D, W, M, or Y)
agid An agency identifier
arid PacFIN area code
cond Condition of catch
day Day the catch was delivered by the fisher (Format: dd, #)
estimated Boolean (T/F); ='T' if estval dollar value is an estimate
estval Actual or estimated revenue(cents)
grade Grade or size of catch
grid PacFIN gear or gear group code
heads Y = if heads are on; N = if heads are off;
lbs Weight of catch in pounds
lbspriced Catch weight that was priced
lpok Boolean (T/F); ='T' if lbspriced is not null
modified Boolean (T/F); ='T' if this record had been modified
month Month the catch was delivered by the fisher (Format: mm, #)
nf Number of fish
nfok Boolean(T/F); ='T' if nf is not null
nl Number of landings
nlok Boolean (T/F); ='T' if nl is not null
pargrp Participant group
pcid PacFIN port identifier (may be null)
spid PacFIN species identifier
ulid Report number of initial data feed or of most recent modification (update log id)
valok Boolean (T/F); ='T' if estval is not null
worst_est Boolean(T/F); ='T' if worst $/lb estimate was used
year Year of catch. (Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
de Detailed effort data
agglvl Detail aggregation level (D, W, M, or Y)
agid An agency identifier
arid PacFIN area code
day Day the catch was delivered by the fisher (Format: dd, #)
daysfished number of days fished (note: if originally reported as null then set to 1 here)
deliveries Number of deliveries
grid PacFIN gear or gear group code
mgrp Management group
modified Boolean (T/F); ='T' if this record had been modified
month Month the catch was delivered by the fisher (Format: mm)
pargrp Participant group
pcid PacFIN port identifier (may be null)
trawlhrs Hours fished with trawl gear
ulid Report number of initial data feed or of most recent modification (update log id)
year Year of catch. (Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
dl Detailed update log information
agid An agency identifier
catchmode A=aquaculture; C=commercial; I=indian; U=unspecified
lbsadded Number of pounds added
lbschged Number of pounds changed
lbsdlted Number of pounds deleted
mgrp Management group (example: 'GRND', 'SAMN', 'SRMP')
period Period of data update activity
periodtype W=week; M=month; Q=quarter; Y=year
recsadded Number of records added
recschged Number of records changed
recsdlted Number of records deleted
ulid Report number of initial data feed or of most recent modification (update log id)
year Year of data update activity. (Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
ft Fish ticket data
agid An agency identifier
day Day the catch was delivered by the fisher (Format: dd)
daysfished Number of days fished
drvid A coastwide vessel identifier. Can be a USCG VID (ex: 1234567 or AK1234nn) or a ZZZ identifier indicating no vessel used, vessel id not provided, or an invalid vessel identifier provided
ftid Fish ticket identifier (ftid must be qualified at a minimum by agency id for uniqueness. A more complete criteria would include pargrp(C-"non-indian commercial" or I - "indian comercial") and also year, month, and day)
ifq_landing If landing was IFQ, flag = 'Y'; if not an IFQ landing, flag is null or = 'N'
modified Boolean (T/F); ='T' if this record had been modified
month Month the catch was delivered by the fisher (Format: mm)
pargrp Participant group (see par_group in table cl)
port Source agency port identifier (the port-of-landing)
processorid TIdentifier for the processor company or buyer that processed, or received, the delivery of fish. (For CDFW this column contains a buyer-id and the processor-id is derived by taking the first five characters only)
removaltype Obsolete - no longer valid in table FT
tdate Ticket date. (Format: dd-MMM-yy)
ulid Report number of initial data feed or of most recent modification (update log id)
veid Vessel identifier (The veid must be qualified by the source agency identifier (agid))
vesseltype Vessel type (see vid-type in table cl)
vesselused Boolean (T/F); ='T' if a vessel was used
year Year the catch was delivered. (Format: yyyy)
fisherman_license A fisherman license number (CA and WA only)

TABLE NAME
COLUMN NAME
DESCRIPTION
ftl Fish ticket line data
adj_grid Adjusted grid (set using data in column ftl.gear, table agr, and table cor_gear)
agid An agency identifier
area Source agency catch area identifier
areatype Type of area of this catch; see area-type in table cl.
assignment Catch assignment (See code list for assignment. The list includes vessel, state agency, NOAA - revenue based)
category State agency species-id or market_category.
CDFW_origin Origin of catch for CDFW transactions only. Contains CDFW block number.
cond Condition of catch at time of landing; see condition in table cl.
day Day the catch was delivered by the fisher (Format: dd)
disp Disposition of this catch (see disposition in table cl)
estimated Boolean (T/F); ='T' if dollar value is estimated
factor Round weight conversion factor scaled nn.nnn.
ftid Fish ticket identifier (The ftid must be qualified at a minimum by agency id for uniqueness. A more complete criteria would include pargrp(C-"Non-Indian Commercial" or I - "Indian Comercial") and also year, month, and day)
gear Source agency gear identifier
grade Grade and size category of this catch; see grade in table cl.
landed_wt Landed weight, units=pounds.
legal_removal Boolean (T/F); = 'T' if the removal was legal.
modified Boolean (T/F); ='T' if this record had been modified
month Month the catch was delivered by the fisher (Format: mm)
num_fish Number of fish caught (nominally for salmon only. For CDFW salmon (i.e. chinook) for 1986 thru the present this statistic is a derived value based on average weights developed from samples. For CDFW for 1981-1985 num_fish for salmon are not available (i.e. num_fish is set to null). For ODFW num_fish is *NOT* provided (i.e. all values for num_fish are null). For WDFW salmon the num-fish values are actual counts of fish (i.e. no sampling for average weight). For WDFW num_fish is provided for a few non-salmon species)
nwr_le_permid Limited entry pemit identifier
overage Boolean (T/F); = 'T' if the catch exceeds the limit
pargrp Participation group; see par-group in table cl.
ppp Price per pound; units = dollars per pound (xxxx.xxx).
product_form The form of the product. See code list for product_form
product_use Intended use of the catch. See code list for product_use
removal_type Removal type is either (commercial, EFP, personal use, research, or commercial (direct sale). See code list.
ulid Report number of initial data feed or of most recent modification (update log id)
worst_est Boolean(T/F); ='T' if worst $/lb estimate from species dataset was used for ftl ppp in this record.
year Year the catch was delivered. (Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
fusport Total commercial landings by port. (Table includes catch for all species by all management groups, shellfish and treaty-Indian catch from all catch areas including Puget Sound, Alaska ocean areas, the Columbia River, and Washington coastal rivers.)
agid An agency identifier
nftids Number of fish ticket identifiers
nprocessors Number of processors
ntrips Number of trips
nvids Number of vessel identifiers
pcid PacFIN port identifier (may be null)
port_name Name of port
rev Revenue
rwt_lbs Round weight in pounds
year Year. (Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
gr PacFIN gear-ids and attributes data
description Description of the gear or gear group
entered Date row was entered into the database or date of last modification (format: yymmdd)
grgroup Gear group
grid PacFIN gear or gear group code
shortname Short name used for reporting
summarized Boolean (T/F); ='T' if summarized data exists for this code
type 1=gear code; 2=gear group; 3='all'

TABLE NAME
COLUMN NAME
DESCRIPTION
lbk_catch Trawl logbook catch records
agid An agency identifier
apounds Adjusted pounds(on trip level) for CDFW, ODFW, and WDFW. Applies to all three states.
apounds_calculated Values = Y/N (Y = calculated using FTL catch; N = apounds set equal to hpounds (no match))
apounds_wdfw Ticket adjusted pounds for WDFW only (representing missing logs as well)
condition Condition (possible future use)
disposition Disposition (possible future use)
grade Grade (possible future use)
hpounds Hailed pounds
source Source of column apounds (values: L = agency LBK datafeed; F = fish-ticket landed-catch using program lbk_set_apounds)
spcode Species code
townum Key to lbk_tow
trip_id Key to lbk_trip
warning Warning flag, see WARNING in table cl n-th charcter corresponds to flag for n-th column

TABLE NAME
COLUMN NAME
DESCRIPTION
lbk_ftid Matches fish ticket ids to logbooks
agid An agency identifier
ftid Key to ft and ftl tables in fishticket system
pargrp Key to ft and ftl tables in fishticket system
source Source of tripid-ftid match (values: L = agency LBK datafeed F = FTL table using program lbk_set_apounds)
ticket_date Date on ticket (use for key to ft) (Format: dd-MMM-yy)
townum Key to lbk_tow in trawl logbook subsystem
trip_id Key to lbk_trip in trawl logbook subsystem

TABLE NAME
COLUMN NAME
DESCRIPTION
lbk_gr Logbook gear/net-type codes
agid An agency identifier
created Date code was first created. (Format: dd-MMM-yy)
description Description
grid PacFIN gear or gear group code
modified Date code was last modified. (Format: dd-MMM-yy)
net_type Gear code used on logbook

TABLE NAME
COLUMN NAME
DESCRIPTION
lbk_pr Logbook port codes
agid An agency identifier
created Date code was first created. (Format: dd-MMM-yy)
description Description
lbk_port Port code used on logbook
modified Date code was last modified. (Format: dd-MMM-yy)
pcid PacFIN port identifier (may be null)

TABLE NAME
COLUMN NAME
DESCRIPTION
lbk_sp Logbook species codes
agid An agency identifier
category Agency category code (link to asp)
created Date code was first created. (Format: dd-MMM-yy)
description description
lbk_spcode Species code used on logbook
modified Date code was last modified. (Format: dd-MMM-yy)

TABLE NAME
COLUMN NAME
DESCRIPTION
lbk_strategy Logbook strategy codes
agid An agency identifier
created Date code was first created. (Format: dd-MMM-yy)
lbk_strategy Strategy code used on logbook
modified Date code was last modified. (Format: dd-MMM-yy)
strategy PacFIN strategy code (link to strategy)

TABLE NAME
COLUMN NAME
DESCRIPTION
lbk_tow Logbook trawl tow information
adj_towtime Wdfw adjusted tow time, represents missing logs as well, see documentation for details
agid An agency identifier
area Source agency catch area identifier
arid_psmfc PSMFC area ID, might be filled from block_pos table set position
block block number (10x10 minutes): set position
block_or ODFW 5x5 minutes block number: set position
ch_lat 1st Loran radio channel: set position
ch_long 2nd Loran radio channel: set position
depth1 1st depth in fathoms (see depth_type1)
depth2 2nd depth in fathoms (see depth_type1)
depth_type1 Type of depth1 (N=Net depth, B= Bottom depth, A=Average depth, + = Max depth, - = Min depth)
depth_type2 type of depth2 (N=Net depth, B= Bottom depth, A=Average depth, + = Max depth, - = Min depth)
duration Tow duration (up-set time) in hours
latlong_type Source of lat/long info L = Logbook entry C = Center of area, entered by agency staff B = Center position of block, from the block_pos table
lbs_adj Adjusted weight in pounds(California and Oregon) at the trip level
lbs_adjexp WDFW adjusted weight in pounds
lbs_hail Hailed weight in pounds
msec_lat Milliseconds from 1st channel: set position
msec_long Milliseconds from 2nd channel: set position
net_type Net type
pacfin_target Target species (PacFIN code)
ps_grnd_code Puget Sound ground code (see maps in "History of WA State Marine fish management areas" WDFW technical report# MRD 97-04)
ps_mgmt_area Puget Sound management area (see maps in "History of WA State Marine fish management areas" WDFW technical report# MRD 97-04)
ryear Year of return. (Format: yyyy)
set_lat Latitude of set position converted from degrees/minutes to degrees.decimal
set_long Longitude of set position converted from degrees/minutes to degrees.decimal
set_time Time net was set (hhmm)
target Target species/strategy code (note that only 48% of all tows have a designated target)
tow_date Date tow occurred. (Format: dd-MMM-yy)
townum Number of tow on trip
trip_id Key to lbk_trip
up_area State area of up position
up_arid_psmfc PSMFC area ID (up position)
up_block Block number (10x10 minutes) (up position)
up_block_or ODFW 5x5 minutes block number (up position)
up_ch_lat 1st Loran radio channel (up position)
up_ch_long 2nd Loran radio channel (up position)
up_lat Latitude of up position converted from degrees/minutes to degrees.decimal
up_long Longitude of up position converted from degrees/minutes to degrees.decimal
up_msec_lat milliseconds from 1st channel (up position)
up_msec_long Milliseconds from 2nd channel (up position)
up_time Time net was hauled up (hhmm)
warning Warning flag (see WARNING in table cl n-th charcter corresponds to flag for n-th column)

TABLE NAME
COLUMN NAME
DESCRIPTION
lbk_trip Logbook trawl trip information
agid An agency identifier
daysfished Days fished (wdfw only)
daysout Days at sea (wdfw only)
dday Date of departure, Orcale date truncated to 12 am. (Format: dd-MMM-yy)
dmonth Month of departure (Format: mm)
dport Departure port
drvid A coastwide vessel identifier. Can be a USCG VID (ex: 1234567 or AK1234nn) or a ZZZ identifier indicating no vessel used, vessel id not provided, or an invalid vessel identifier provided
dtime Departure time (hhmm) (24 hour time)
dyear Year of departure. (Format: yyyy)
ft_match_flag Boolean (T/F) ='T' Trip has matching fish ticket
ncrew Crewsize, including captain
ngal Fuel consumed in Gallons(Note that only 13% of all trip_id's have a fuel value entered)
ntows Number of tows on trip (wdfw only)
rday Date of return, Oracle date truncated to 12 am. (Format: dd-MMM-yy)
region Region of trip ((wdfw only) 1=Canada, 2=Alaska, 3=Coastal, 4=Straits and Gulf, 5=Puget Sound and Hood Canal)
rmonth Month of return. (Format: mm)
rport Return port
rtime Return time (hhmm) (24 hour time)
ryear Year of return. (Format: yyyy)
towsrec Number of tows recorded (wdfw only, prior to 19?? only every 4th tow was recorded)
trip_id Trip id, sequence generated
veid Vessel id as in source data
vidtype Type of veid (see vid-type in table cl)
warning Warning flag, see WARNING in table cl n-th charcter corresponds to flag for n-th column

TABLE NAME
COLUMN NAME
DESCRIPTION
lbk_ul Logbook update log
agid An agency identifier
comments Comments supplied by person processng the data
data_year Year of data. (Format: dd-MMM-yy)
datafile Location of input data file as given to loading routine
proctime Time data was loaded in DB (down to the second). (Format: dd-MMM-yy)
records Number of records of this type loaded
type Record type (A=adjusted pounds (WDFW only) C=catch, F= Fishticket match, H= Haul/Tow, T= Trip)

TABLE NAME
COLUMN NAME
DESCRIPTION
LE_grnd_cnts Non-confidential summary fish-ticket data containing one record for each limited entry (LE) vessel, management group (MGRP), gear id (GRID), port id (PCID) and permit-list combination
council Specifies council (example: PFMC)
cwvid Coastwide vessel identifier: USCG Doc#, USCG small vessel identifier; examples: 1234567, CF1234X
earliest Earliest fish-ticket date for each CWVID-MGRP-GRID-PCID-PRMTLST combination. (Format: dd-MMM-yy)
latest Latest fish-ticket date for each CWVID-MGRP-GRID-PCID-PRMTLST combination. (Format: dd-MMM-yy)
ntrips Number of trips for each CWVID-MGRP-GRID-PCID-PRMTLST combination
prmtlst Permit list from Northwest Region limited entry list of permits
year Year from fish-ticket. (Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
LE_grnd_tkts Selected non-confidential fish-ticket data for each fish-ticket per limited-entry (LE) vessel landing groundfish caught in the Pacfic Fisheries Management Council (PFMC) exclusive economic zone (EEZ)
agid An agency identifier
council Specifies council (example: PFMC)
cwvid Coastwide vessel identifier: USCG Doc#, USCG small vessel identifier; examples: 1234567, CF1234XY
ftid Fish-ticket identifer from fish-ticket
prmtlst Permit list from NWR LE list of permits
tdate Date from fish-ticket. (Format: dd-MMM-yy)
year Year from fish-ticket. (Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
lep_app Information regarding vessels that appealed the denial of a limited entry groundfish permit
begdate Begining of appeal date. (Format: dd-MMM-yy)
end1 Permit gear endorsement
enddate Ending of appeal date. (Format: dd-MMM-yy)
permid Permit id
pstatus Permit status code
vid Vessel identifier

TABLE NAME
COLUMN NAME
DESCRIPTION
lep_status Limited entry permit status
code Permit status code (0=Pending renewal, 1=Under review, 2=Pending evidence, 3=Sanction, 4=Blank, 5=Cancelled, 6=Appeal, 7=Dead (expired), 8=Dead (combined), 9=Active)
description Description of status

TABLE NAME
COLUMN NAME
DESCRIPTION
lep_type Limited entry permit type
code Permit type (Corresponds to permtype in lep. A=Permanent, B=Permanent, C=Provisional permanent, D=Temporary, E=None, U=Unknown sc agglvl M=Month, Y=Year)
description Description of permit type

TABLE NAME
COLUMN NAME
DESCRIPTION
npac4900 Daily summaries for the Washington, Oregon, California (W-O-C) at-sea fishery summarized from the NORPAC database tow-by-tow observations
accumulated_by Day, week, month, indicating species-comp aggregation level
arid PacFIN area code
catcher Vessel identifier for cather vessel
cdq_code Community code (used to identify tribal)
day Day the catch was delivered by the fisher (Format: dd)
grid PacFIN gear or gear group code
month Month the catch was delivered by the fisher (Format: mm)
processor Vessel identifier for processing vessel, CP or Mother ship
spid PacFIN species identifier
total-weight Total catch in metric tons
wt_retained Retained catch in metric tons
year Year of catch. (Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
nv Information for non-vessels used in fish ticket transactions
agid An agency identifier
artvid Artificial vessel id (used in construction of derived vessel id for ft transactions to ensure assignment of catch to correct vessel)
idtype Vessel identifier type (see table cl)
veid Vessel identifier
year Year of vessel. (Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
nwr_lep_src Limited entry permits source data from the National Oceanic and Atmospheric Administration's (NOAA) Northwest Region (NWR) Permit Office
dory_endr A value of 1 ⇒ dory small fleet
expdate Permit expiration date
ghid Permit holder identifier
goid Permit owner identifier
h_name Permit holder name
h_pob Permit holder PO box
h_pob_city Permit holder PO box - city
h_pob_state Permit holder PO box - state
h_pob_zip Permit holder PO box - zip code
h_str Permit holder street
h_str_city Permit holder street city
h_str_state Permit holder street state
h_str_zip Permit holder street zip code
issdate Permit issue date
len_endor Endorsed permit length (± 5 feet)
lgln_gear A value of 1 ⇒ longline gear
o_name Permit owner name
o_pob Permit owner PO box
o_pob_city Permit owner PO box - city
o_pob_state Permit owner PO box - state
o_pob_zip Permit owner PO box - zip code
o_str Permit owner street
o_str_city Permit owner street - city
o_str_state Permit owner street - state
o_str_zip Permit owner street - zip code
permid Permit identifier
platoon Code in month ok to land fish if trawl
pstatus Permit status code
sable_tier Sablefish allowable catch (tier 1, 2 or 3; 0= no tier)
trap_gear A value of 1 ⇒ trap
trwl_gear A value of 1 ⇒ trawl
vid Vessel id
vname Vessel name

TABLE NAME
COLUMN NAME
DESCRIPTION
ok_gear Fish ticket lines (ftl) which should not be corrected by the gear correction algorithm (columns as in ftl).
agid An agency identifier
area Source agency catch area identifier
areatype Type of area of this catch; see area-type in table cl.
category State agency species-id or market_category.
cond Condition of catch at time of landing; see condition in table cl.
day Day the catch was delivered by the fisher (Format: dd)
disp Disposition of this catch; see disposition in table cl.
ftid Fish ticket identifer from fish ticket
gear Source agency gear identifier
grade Grade and size category of this catch; see grade in table cl.
landed_wt Landed weight, units=pounds.
month Month the catch was delivered by the fisher (Format: mm)
pargrp Participation group (see par-group in table cl)
year Year the catch was delivered. (Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
omibbfee Vessel summaries for verifying fee collections for the 2003 vessel buy-back project. (For NMFS Office of Operations Management and Information)
agid An agency identifier
buyer Buyer or processor who processed the catch (see table apc)
council Area designation (P = PFMC; N = NPFMC; * = neither)
lwt_lbs Landed weight in pounds
month Month the catch was delivered by the fisher (Format: mm)
revenue Revenue in $US
rwt_lbs Round weight equivalent in pounds
spid PacFIN species code
tdate Fish ticket date (date landing received from fisher) (Format: dd-MMM-yy)
year Year of data (Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
pc PacFIN codes for ports, port groups, regions, subregions, counties, joint-ventures (1981-1990), and foreign countries (1981-1988).
agid An agency identifier
cid Obsolete; see column CID in table APR
entered Date row was entered into the database or date of last modification (Format: dd-MMM-yy)
grouporder North to south order for code groups.
name Name associated with this code.
pcgroup Code Group (port group, region, or country group)
pcid PacFIN port identifier (may be null)
pcorder North to south order for code.
sgroup Port group for grouping samples of landed catch (i.e. port sampling). (Only used by CDFW.)
shortname Short code name used for reporting.
summarized Boolean (T/F); ='T' if summarized data exists for this code.
type Type of code (1=port/subregion/country/jv; 2=portgrp/region; 3=state/jvp/foreign; 4=nwafc(jvp+foreign)/ALP (all domestic); 5=all U.S. data sources)

TABLE NAME
COLUMN NAME
DESCRIPTION
prin_cmplx All vessels (and only vessels) registered to land marine species in Washington, Oregon and California (W-O-C) ports. This includes catch from all areas including Puget Sound, Columbia River, and Alaska.
drvid A coastwide vessel identifier. Can be a USCG VID (ex: 1234567 or AK1234nn) or a ZZZ identifier indicating no vessel used, vessel id not provided, or an invalid vessel identifier provided
gr_lbs Primary gear for lbs
gr_lr Gear relation (same or diff)
gr_rev Primary gear for revenue
nwr_le NWR limited entry permit(True or False)
prncmp_lbs Principal complex for lbs
prncmp_lr Complex relation(same or diff)
prncmp_rev Principal complex for revenue
spid_lbs Primary spid for lbs
spid_lr Spid relation (same or diff)
spid_rev Primary spid for revenue
year Year (Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
prmt_own Washington, Oregon and California (W-O-C) permit owner information
actdate Date permit activated for a vessel or a fisher. (Format: dd-MMM-yy)
address Permit owners address
agid An agency identifier
city city of residence
expdate Date permit expires or is de-activated, if not renewed. (Format: dd-MMM-yy)
owname Permit owners name
permid Permit id
permtype Agency defined permit type
state State of residence
year Year of permit. (Format: yyyy)
zip Zip code

TABLE NAME
COLUMN NAME
DESCRIPTION
prmtdesc Washington, Oregon and California (W-O-C) permit attributes
agid An agency identifier
description Description of permit
permtype Agency defined permit type
restricted restrictions on permit - Boolean T/F
transfer transferability either N = not transferable; K = transferable, but vessel is NOT transferred (sold) with the permit V = transferable, and vessel IS transferred (sold) with the permit

TABLE NAME
COLUMN NAME
DESCRIPTION
qar Area ids for quota species monitoring (QSM) reported catches
arid PacFIN area code

TABLE NAME
COLUMN NAME
DESCRIPTION
qdisp Quota species monitoring (QSM) data to identify category of fish on various QSM reports
arid PacFIN area code
grid PacFIN gear or gear group code
ord Dummy order for software development purpose
qdisp Text displayed on report
spid PacFIN species identifier

TABLE NAME
COLUMN NAME
DESCRIPTION
qdpar Quota species monitoring (QSM) date parameters
description Detailed description of usage
qdate Date. (Format: dd-MMM-yy)
date usage Indicates where the date is used

TABLE NAME
COLUMN NAME
DESCRIPTION
qhg Quota species monitoring (QSM) harvest guideline data
arid PacFIN area code
description Description of the harvest guideline
grid PacFIN gear or gear group code
hg Quota units=metric-tons
ord Used for display purposes (matches with ord in qdisp table)
spid PacFIN species identifier
year Year of harvest quideline. (Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
qovrd Quota species monitoring (QSM) correction factors (CF) override data
ag Override agency
ar Override area identifier
cf Actual CF value; =null if surrogate exists
gr Override gear identifier
sp Override species identifier
srag Surrogate agency
srar Surrogate area identifier
srgr Surrogate gear identifier
srsp surrogate species identifier

TABLE NAME
COLUMN NAME
DESCRIPTION
qpc Quota species monitoring (QSM) port identifier data
pcid PacFIN port identifier (may be null)

TABLE NAME
COLUMN NAME
DESCRIPTION
qprompts Prompt data for quota species monitoring (QSM) data entry
ag Agency of data entry
arid PacFIN area code
disp_entry Actual display
grid PacFIN gear or gear group code
lb_catch Catch weight (in pounds)
ord Order of prompt for data entry
process_dt Date of data entry processeding. (Format: dd-MMM-yy)
spid PacFIN species identifier

TABLE NAME
COLUMN NAME
DESCRIPTION
qrc Quota species monitoring (QSM) reported catches data
agid An agency identifier
arid PacFIN area code
b_date Beginning date of catch. (Format: dd-MMM-yy)
cum 'C' indicats catch is monthly cumulative, otherwise weekly
e_date Ending date of catch. (Format: dd-MMM-yy)
ent_date Date that catch was entered into PacFIN database. (Format: dd-MMM-yy)
est_catch Estimated catch in pound
fleet Fleet type (L = Limited Entry; O = Open Access; T = Total Fleet)
grid PacFIN gear or gear group code
mod_date Date that catch was modified. (Format: dd-MMM-yy)
spid PacFIN species identifier
unit Unit of catch ('P'=pounds)

TABLE NAME
COLUMN NAME
DESCRIPTION
qsc Subset of summary catch used in quota species monitoring (QSM) subsystem
agglvl Summary aggregation level (M or Y)
arid PacFIN area code
grid Gear identifier in qsp table
lbs Aggregated weight
pcid PacFIN port identifier (may be null)
period Month or year period
spid Species identifier in qsp table
year Year of catch. (Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
qscsp Species id used in quota species monitoring (QSM) and summary catch
qsm_sp A valid species id of QSM subsystem
sc_sp Summary catch species identifier correspond to QSM species identifier

TABLE NAME
COLUMN NAME
DESCRIPTION
qsp Species identifiers and gear identifiers for entering quota species monitoring (QSM) reported catches
grid PacFIN gear or gear group code
spid PacFIN species identifier

TABLE NAME
COLUMN NAME
DESCRIPTION
qti Washington Department of Fish and Wildlife (WDFW) treaty Indian sablefish (SABL) catch data
lbs_catch Catch in pounds
lvl Y (year) or M (month)
period Period of catch
year Year of catch. (Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
sc Summary catch data
agglvl Summary aggregation level (M or Y)
arid PacFIN area code
estval Estimated revenue(cents)
grid PacFIN gear or gear group code
lbs Aggregated weight
lbspriced Aggregated weight that was priced
nf Aggregated number of fish (salmon only)
nl Number of landings (port aggregation only)
pcid PacFIN port identifier (may be null)
period Month or year period
spid PacFIN species identifier
year Year of catch. (Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
sc_le_oa Summary catch data for limited entry and open access fleets. Used in Quota Species Monitoring (QSM) subsystem.
agid An agency identifier
arid PacFIN area code
estval Estimated revenue (cents)
fleet Fleet typer (L = Limited Entry; O = Open Access)
grid Gear identifier = "ALL" unless spid = "SABL" then "TWL", "TWS", or "USP"
lbspriced Aggregated weight that was priced
nf Aggregated number of fish (salmon only)
nl Number of landingsi (port aggregation only)
period MONTH = 1-12; YEAR = 99
spid PacFIN species identifier
weight Aggregated weight (pounds)
year Year of catch. (Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
scm Species composition data
agid An agency identifier
arid PacFIN area code (May be NULL (i.e: no stratification by area))
coeffvar Coefficient of variance
day Day of week (Ignored if period='M' or 'Q'; if period='W' specifies that proportion applies to the 7-day period ending on this YEAR-MONTH-DAY) (Format: dd)
grid PacFIN gear or gear group code
modified Boolean (T/F); ='T' if this record had been modified
month Month or quarter for which proportion applies (if period='Q' then specifies last month of quarter(3 ⇒ Q1, 6 ⇒ Q2, 9 ⇒ Q3, 12 ⇒ Q4)) (Format: mm)
pcid PacFIN port identifier (may be null)
period Time period (w = week; m = month; q = quarter)
proportion Estimated proportion for species within the specified time-period, port, area, gear, and unspid
sample_cond Condition of sample (L = live; D = dead; 9 = all landing conditions)
samples Number of samples
spid PacFIN species identifier
ulid Report number of initial data feed or of most recent modification (update log id)
unspid PacFIN unspecified species id (an SPID code)
year Year for which proportion applies. (Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
scm_history History of all species composition data supplied by Washington, Oregon and California (W-O-C) state agencies.
agid An agency identifier
arid PacFIN PSMFC area code or PSMFC sub area code; may be NULL (i.e: no stratification by area)
coeffvar Coefficient of variance
day Day of week (Ignored if period='M' or 'Q'; if period='W' specifies that proportion applies to the 7-day period ending on this YEAR-MONTH-DAY) (Format: dd)
file_name File name of the data file which was loaded to the database
grid PacFIN gear or gear group code
modified Boolean (T/F); ='T' if this record had been modified
month Month or quarter for which proportion applies (if period='Q' then specifies last month of quarter(3 ⇒ Q1, 6 ⇒ Q2, 9 ⇒ Q3, 12 ⇒ Q4)) (Format: mm)
pcid PacFIN port identifier (may be null)
period time period (w=week; m=month; q=quarter)
proportion Estimated proportion for species within the specified time-period, port, area, gear, and unspid)
report_date This date corresponds to the date in the header record of the original datafile supplied by the agency. (Format: dd-MMM-yy)
sample_cond Sample condition (L = live; D = dead; 9 = all landing conditions)
samples Number of samples
spid PacFIN species identifier
trans_op Transaction operation (A code which describes what the data loading program should do with the associated record. Ex: update,insert,delete.)
ulid Report number of initial data feed or of most recent modification (update log id)
unspid PacFIN unspecified species id (an SPID code)
year Year for which proportion applies. (Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
se Summary effort data
agglvl Summary aggregation level (M or Y)
arid PacFIN area code
daysfished Number of aggregated days fished (note: if originally reported as null then set to 1 here)
deliveries Number of aggregated deliveries
grid PacFIN gear or gear group code
mgrp Management group
pcid PacFIN port identifier (may be null)
period Month or year period
trawlhrs hours fished with trawl gear: only applicable for grid within TWL,TWS subtrees; otherwise value is zero (including at grid=ALL)
year Year of catch. (Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
sp PacFIN species-id and attributes
actsp Boolean (T/F); ='T' if SP table entry is for an actual
bsacomplex Used to group bsa species in subcomplexes
bsaorder Used to order species for bsa retrievals
cname Species common name
complex Species grouping
complex2 Additional species grouping
complex3 Additional species grouping
complex4 Additional species grouping
cporder Used to order species complex for retrieval
entered Date row was entered into the database or date of last modification (Format: dd-MMM-yy)
grp_nom_act Groups nominal and actual species codes together (e.g. YTR9 = YTRK, YTR1)
gulfcomplex Used to group gulf species in subcomplexes
gulforder Used to order species for gulf retrievals
mgrp Management group
ncflag Boolean(T/F); ='T' if the species used in npfmc reports
nom_act Actual or nominal species (A,N or null)
pcflag Boolean(T/F); ='T' if the species used in pfmc reports
ppp_lower Lower bound of price per pound (units=dollars per pound)
ppp_upper Upper bound of price per pound (units=dollars per pound)
regionflag Boolean (T/F); ='T' if the species used in region wide reports
sname Species scientific name
spid PacFIN species identifier
sporder Used to order species for retrieval
stateflag Boolean (T/F); ='T' if the species used in state reports
summarized Boolean(T/F); ='T' if summary data exists for this code
type Species code type (1 = species; 2 = complex; 3 = mgmt grp; 4 = sub complex, complex2, complex3 or complex4; 5 = gulf subcomplex; 6 = bsa subcomplex; 7 = a "remaining" collection of fish)
worst_est_ppp Worst estimated price per pound; units = dollars per pound

TABLE NAME
COLUMN NAME
DESCRIPTION
strategy PacFIN strategy codes
created Date code was first created. (Format: dd-MMM-yy)
description Description
modified Date code was last modified. (Format: dd-MMM-yy)
strategy PacFIN strategy code

TABLE NAME
COLUMN NAME
DESCRIPTION
sum_fous2 Summary table for the National Marine Fisheries Service (NMFS) - DC Fishery Statistics Division F/ST1. Applications include: Fisheries of the U.S. NMFS/ST1 Internet home page
agid An agency identifier
cond Either E = roe, or R = round weight equiv.
disp Same as disposition in ftl with the addition of '9' meaning all dispositions combined
drvid_cnt Count of distinct catching vessels
flag Flag value (1 = necessary summary; 2 = informational; 9 = temporary computation)
grid Gear group, gr.type = 2, 'ALL', or 'ggg'; 'ggg' used in conjunction with month = 13
lbs_ppp_zero Sum of rwt_lbs where ftl.ppp = 0
lbs_priced Sum of rwt_lbs where ftl.estimated = 'F'
month Month from ft/ftl or period from sc; 99 = annual; 13 = grouped confidential summaries and used with GRID = ggg (Format: mm)
num_ftl Count of ftl rows for this summary
pargrp Same as pargrp in ft/ftl (see table cl)
processor_cnt Count of distinct processor/buyer codes
revenue Units = U.S. dollars (ex-vessel or un-processed)
rwt_lbs Landed_wt * factor, factor set = 1 if null
source_table T = ftl table; S = sc table
spid PacFIN species identifier (HROE, is equivalent to PHRG and COND = E)
year Year from ft/ftl or year form sc. (Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
sum_nmfs_st1 Summary table for the National Marine Fisheries Service (NMFS) — DC Fishery Statistics Division F/ST1. Table contains canadian vessel landings
agid An agency identifier
cname Common name
id Identifier(canadian)
revenue Revenue of catch in U.S. dollars
rwt_lbs Round weight in lbs
spid PacFIN species identifier
year Year of landing. (Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
sv State agency vessel registration records, including vessel-ids and other attributes
agid An agency identifier
charterboat Boolean (T/F); = 'T' if vessel is used as a charter
city City of vessel owner's address
hp Horsepower rating
idtype Type of identifier (1 = u.s. coast guard; 2 = state marine board; 5 = canadian see table cl (code-list-name = VID-TYPE) for a complete list)
len Vessel length in feet
lentype Measurement used (0 = sv len is null; 1 = overall length in feet; 2 = keel length in feet; 3 = uscg length in feet)
modified Boolean (T/F); ='T' if this record had been modified
name Vessel name
owner Name of the current, or most recent, vessel owner within a single calendar year (as of Jan06 WDFW and CDFW provide owner info, while ODFW does not)
plate Plate number
state State of vessel owner's address
street Street address of vessel owner
svid Vessel identifier
ulid Report number of initial data feed or of most recent modification (update log id)
wgt Vessel weight; if the value in this data field is found to inconsistent with USCG supplied data, then USCG data should be used in lieu of the value in this data column
wgttype Measurement used: 0 = sv wgt is null; 1 = net tonnage; 2 = gross tonnage; 3 = uscg reported gross tonnage
year Year the vessel was registered with the data source agency. (Format: yyyy)
zipcode Zip code for owner's address

TABLE NAME
COLUMN NAME
DESCRIPTION
tkprmtlst Combines the Northwest Region limited entry permit source (nwr_lep_src) and fish ticket line (ftl) tables. Produced by program prod/refresh_tkprmtlst.sql.
agid An agency identifier
day Day the catch was delivered by the fisher (Format: dd))
drvid A coastwide vessel identifier. Can be a USCG VID (ex: 1234567 or AK1234nn) or a ZZZ identifier indicating no vessel used, vessel id not provided, or an invalid vessel identifier provided
ftid Fish ticket identifier
gr_endors List of gear endorsements corresponding to list of permits
len_endors List of length endoresments corresponding to list of permits
list_of_permids List of permit identifiers "held" by the vessel on the day recorded on the fish-ticket
month Month the catch was delivered. (Format: mm)
multi_endor Boolean (T/F) T = one or more of listed permits has multiple endorsements
pargrp Participant group; see par_group in table cl
sabltiers List of sablefish tier assignments corresponding to list of permits
tdate Date of ticket delivery by fisher. (Format: dd-MMM-yy)
year Year of fish ticket data. (Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
tpy Contains yearly trip-principal vessel summary data generated from the build_vsums program. (The summations in this table are derived solely from the fish ticket (ft) and fish ticket line (ftl) Oracle data tables. Re-assignment to catch-area and species using catch by area proportions (acm), and species composition (scm) is not included in these summations. Note: Aquaculture has been excluded.)
agid An agency identifier
daysfsh Sum of days fished during period, mostly salmon Set to -1 (null) if PARGRP="I" (Treaty Indian) and DAYSFSH > 999D, or if Vessel Id = "00000" and DAYSFSH > 999.
drvid A coastwide vessel identifier. Can be a USCG VID (ex: 1234567 or AK1234nn) or a ZZZ identifier indicating no vessel used, vessel id not provided, or an invalid vessel identifier provided
fday First fishing day of the period (julian day).
grid Principal PacFIN gear code during the period based on revenue.
lday Last fishing day of the period (julian day).
pcid Principal PacFIN port code during the period based on revenue.
prd Period type (eg. Month, Week, Year).
prdid Period identifier (eg. 1-54, 1-12).
proc Principal processor who processed or received delivery.
rwt_null Round weight null flag.= 0 If all ftl rwt_lbs components were non-null. = 4 If the rwt_null field in the corresponding rows of the vsy table were set to "1", "2", or "3". See column descriptions in table coldsc for vsy.
spid Principal PacFIN species code during the period based on revenue.
tot_rev Revenue in US dollars (price-per-lb * lwt_lbs) scale is 12 digits with 2 decimal places (eg. 123456789.12).
tot_rwt Round weight equivalent in lbs (lwt_lbs * conversion factor). Total rwt pounds for the vessel.
trips Number of trips (effort, FT rec cnt, date not same).
year Year of fish ticket data. (Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
ul Log of all database updates
agid An agency identifier
beg_date Earliest date contained in the report (date datatype; new)
begindate Earliest date contained in the report. (Format: yyyymmdd)
end_date Latest date contained in the report (date datatype; new)
enddate Latest date contained in the report. (Format: yyyymmdd)
processdate Date the report was added to the database. (Format: dd-MMM-yy)
rptcomment Comment supplied by the reporting agency
rptdate Agency report date. (Format: dd-MMM-yy)
ulid Report number of initial data feed or of most recent modification (update log id)

TABLE NAME
COLUMN NAME
DESCRIPTION
vdrfd The relationship between vessels, tickets, date-of-landing, permit(s), fish-ticket category, and post-distribution species id code. (Produced by program prod/refresh_vdrfd.sql.)
adj_grid Adjusted grid. Set using data in column ftl.gear, table agr,and table cor_gear.
agid An agency identifier
arid PacFIN area code after application of area comps. The value of this area code is different than ftl_arid.
assignment Catch assignment. See code list for assignment. The list includes vessel, state agency, NOAA - revenue based.
cond Condition of catch at time of landing; see condition in table CL.
disp Disposition of this catch; see disposition in table CL.
drvid A coastwide vessel identifier. Can be a USCG VID (ex: 1234567 or AK1234nn) or a ZZZ identifier indicating no vessel used, vessel id not provided, or an invalid vessel identifier provided
fleet Fleet type (limited entry ⇒ 'LE', open access ⇒ 'OA', tribal indian ⇒ 'TI', research ⇒ 'R', unknown ⇒ 'XX').
ftid Fish ticket identifer from fish ticket
ftl_arid PacFIN area id corresponding to the state agency area code found on the fish ticket
ftl_spid PacFIN species id corresponding to the state agency category code found on the fish ticket.
grade Grade and size category of this catch; see grade in table CL.
grid PacFIN gear or gear group code
ifq_landing If landing was IFQ, flag = 'Y'; if not an IFQ landing, flag is null or = 'N'
legal_removal Boolean (T/F); = 'T' if the removal was legal.
lwt_lbs Landed weight (in pounds)
overage Boolean (T/F); = 'T' if the catch exceeds the limit.
pargrp Participant group (see par_group in table cl)
pcid PacFIN port identifier (may be null)
port Source agency port identifier
prmtlst One or more NWR/LE permits under which the vessel fished.
proc Processor id (who processed the fish or received delivery)
product_form The form of the product (See code list for product form)
product_use Intended use of the catch (See code list for product use)
removal_type Removal type is either (commercial, EFP, personal use, research, or commercial (direct sale) see code list)
rev Revenue in US dollars ((price-per-lb * lwt_lbs) scale is 12 digits with 2 decimal places (eg. 123456789.12))
rwt_lbs Round weight equivalent in pounds (lwt_lbs * conversion factor)
spid PacFIN species identifier after application of species comps. The value of this species code is differenct than ftl_spid.
tdate Date of ticket delivery by fisher. (Format: dd-MMM-yy)
year Year of fish ticket data. (Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
ves_sctr Relationship between vessels and vessel sectors where vessel sectors are defined in the code list (cl) table. (Produced by program prod/refresh_ves_sctr.sql.)
drvid A coastwide vessel identifier. Can be a USCG VID (ex: 1234567 or AK1234nn) or a ZZZ identifier indicating no vessel used, vessel id not provided, or an invalid vessel identifier provided
vessel_sector Vessel belongs to a sector if it's annual revenue for a defined fishery, gear relation is greater than a defined value. There are 19 sectors defined in the CL table.
year Year of data (used to categorize vessels). (Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
ves_sctr_principal Relationship between vessels and principal sectors. (Produced by program prod/refresh_ves_sctr.sql and derived from the vessel sector (ves_sctr) table. This table differs from ves_sctr in that it is a cross-tablulation of ves_sctr. Vessel sectors are defined in the code list (cl) table. Vessel sectors are prioritized and not mutually exclusive where the lowest sector number has the highest priority.)
drvid A coastwide vessel identifier. Can be a USCG VID (ex: 1234567 or AK1234nn) or a ZZZ identifier indicating no vessel used, vessel id not provided, or an invalid vessel identifier provided
sector_01 A flag(0 or 1) if the vessel belongs in the sector.
sector_02 A flag(0 or 1) if the vessel belongs in the sector.
sector_03 A flag(0 or 1) if the vessel belongs in the sector.
sector_04 A flag(0 or 1) if the vessel belongs in the sector.
sector_05 A flag(0 or 1) if the vessel belongs in the sector.
sector_06 A flag(0 or 1) if the vessel belongs in the sector.
sector_07 A flag(0 or 1) if the vessel belongs in the sector.
sector_08 A flag(0 or 1) if the vessel belongs in the sector.
sector_09 A flag(0 or 1) if the vessel belongs in the sector.
sector_10 A flag(0 or 1) if the vessel belongs in the sector.
sector_11 A flag(0 or 1) if the vessel belongs in the sector.
sector_12 A flag(0 or 1) if the vessel belongs in the sector.
sector_13 A flag(0 or 1) if the vessel belongs in the sector.
sector_14 A flag(0 or 1) if the vessel belongs in the sector.
sector_15 A flag(0 or 1) if the vessel belongs in the sector.
sector_16 A flag(0 or 1) if the vessel belongs in the sector.
sector_17 A flag(0 or 1) if the vessel belongs in the sector.
sector_18 A flag(0 or 1) if the vessel belongs in the sector.
sector_19 A flag(0 or 1) if the vessel belongs in the sector.
vessel_sector_princ Sector with the highest priority which corresponds to this vessel
year Year of data used to categorize vessels. (Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
vescnt Vessel summary data generated from the refresh_vescnt.sql script.
agid An agency identifier
nves_lrg Number of vessels ≥ 5 metric tons
nves_sml Number of vessels < 5 metric tons
year Year of fish ticket data. (Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
vesgrprd Vessel-Gear-Time-Period data (Contains one entry for each unique combination by year, vessel, and gear used. This table is populated/maintained by routine insert_vesgrprd.sql)
drvid A coastwide vessel identifier. Can be a USCG VID (ex: 1234567 or AK1234nn) or a ZZZ identifier indicating no vessel used, vessel id not provided, or an invalid vessel identifier provided
earliest Earliest fishing date for the drvid-grid combination. (Format: dd-MMM-yy)
grid PacFIN gear or gear group code
latest Latest fishing date for the drvid-grid combination. (Format: dd-MMM-yy)
ntrips Number of fishing trips for the drvid-grid combination
year Year from fish-ticket table(s) (Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
vesportgr Vessel-Port-Gear data (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: fish tickets (ft), fish ticket lines (ftl), Coast Guard (cg), state vessel (sv), yearly trip principle vessel summary (TPY), and ageny port relations (apr) tables)
agid An agency identifier
cg_len_feet Vessel length as measured by the coast gaurd in table CG. The most recent value per year is used, if not available, the most recent value across all time.
cg_pubmo Month the Merchant Vessels of the U.S. data file was recieved from the USCG via NMFS/ST1. (Format: MMM, ex. JAN)
cg_pubyr Year the Merchant Vessels of the U.S. data file was recieved from the USCG via NMFS/ST1.(Format: yyyy)
cg_wt_gross Vessel gross tonnage as collected by the USCG in table CG. The most recent value per year is used, if not available, use the most recent value across all time.
drvid A coastwide vessel identifier. Can be a USCG VID (ex: 1234567 or AK1234nn) or a ZZZ identifier indicating no vessel used, vessel id not provided, or an invalid vessel identifier provided
grid_prin Principal gear id from table TPY where principal is defined by the gear used to catch the max revenue within the year.
ntrips Number of trips for the drvid,pcid combination. Note that Vessels may offload at multiple ports within one trip. Therefore, trip counts across drvid,pcid combos are not mutually exclusive and cannot be summed across drvid.
pcid PacFIN port identifier (may be null)
st_len_feet Vessel length as measured by a state agency in SV table.
st_wt_net Vessel net tonnage as collected by a state agency in SV tab.
year Year from fish-ticket table(s)(Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
vfcmrfd Monthly vessel summaries with rockfish distributed per fish ticket category. (Generated using the refresh_vfcmrfd program. The summations in this table have been developed using the fish ticket (ft), fish ticket lines (ftl), ticket permit list (tkprmtlst), catch by area proportion (acm), and species composition (scm) tables/views.)
agid An agency identifier
arid PacFIN area identifier (groundfish, salmon, or shrimp area).
cond Condition of catch at time of landing (see table cl).
disp Disposition of catch (see table cl).
drvid A coastwide vessel identifier. Can be a USCG VID (ex: 1234567 or AK1234nn) or a ZZZ identifier indicating no vessel used, vessel id not provided, or an invalid vessel identifier provided
fleet Classifies catch into limited-entry (LE) or open-access (OA)
ftl_spid PacFIN spid (landed catch-category (FTL category))
gr_endors List of gear endorsements corresponding to list of permits
grade Grade or size category of the catch (see table cl for types).
grid A PacFIN level 1 (gr.type = 1) gear code (grid). Column ftl.adj_grid is used here. This is the original grid overlayed with a corrected-gear if one exists.
len_endors List of length endoresments corresponding to list of permits
lwt_lbs Landed weight in pounds.
month Month the catch was delivered by the fisher (Format: mm))
multi_endor Boolean (T/F) T = one or more of listed permits has multiple endorsements
pargrp Participant group (see par-group in table cl)
pcid PacFIN port identifier (may be null)
port Source agency port identifier
prmtlst One or more NWR/LE permits under which the vessel fished. Different permit lists on different days for the same vessel produces additional rows for each vessel within each month.
proc Processor identifier (The receiver/processer of the fish/animals/plants)
product_form Form of the product (See code list for product_form)
product_use Intended use of the catch (See code list for product use)
rev Revenue in US dollars (price-per-lb * lwt_lbs) scale is 12 digits with 2 decimal places (eg. 123456789.12).
rwt_lbs Round weight equivalent in lbs (lwt_lbs * conversion factor)
sabltiers List of sablefish tier assignments corresponding to list of permits
spid PacFIN species identifier
year Year of fish ticket data. (Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
vsy Yearly vessel summary data generated from the build_vsums program. (The summations in this table are derived solely from the fish ticket (ft) and fish ticket line (ftl) data tables. Re-assignment to catch-area and species using catch by area proportions (acm), and species composition (scm) proportions is not included in these summations. Note: Aquaculture has been excluded.)
agid An agency identifier
arid PacFIN area code (groundfish, salmon, or shrimp area).
cond Condition of catch at time of landing (see table cl).
disp Disposition of catch (see table cl).
drvid A coastwide vessel identifier. Can be a USCG VID (ex: 1234567 or AK1234nn) or a ZZZ identifier indicating no vessel used, vessel id not provided, or an invalid vessel identifier provided
grd Grade and size category of the catch (see table cl for types).
grid PacFIN gear or gear group code
lwt_lbs Landed weight in pounds
pargrp Participant group (eg. commercial, Indian).note: excludes aquaculture
pcid PacFIN port identifier (may be null)
prd Period type (eg. Month, Week, Year)
prdid Period identifier (eg. 1-54, 1-12)
proc Processor identifier Who processed the fish or received delivery
rev Revenue in US dollars (price-per-lb * lwt_wt) scale is 12 digits with 2 decimal places (eg. 123456789.12).
rwt_lbs Round weight equivalent in pounds (lwt_lbs * conversion factor)
rwt_null "Round weight null flag.= 0 If all ftl rwt-lbs components were non-null. = 1 If cond = 'E' (fish eggs, roe) in one or more ftl rows;rwt_lbs is set to zero. May include one or more zero rwt_lbs components.= 2 If cond not equal to 'E' and cond not equal to 'R' (round) and conversion factor is null, in one or more ftl rows; factor is set to 2 in the appropriate rows. = 3 If cond = 'R' and conversion factor is null, in one or more ftl rows; factor set to 1 in the appropriate rows."
spid PacFIN species identifier
year Year of fish ticket data. (Format: yyyy)

TABLE NAME
COLUMN NAME
DESCRIPTION
wocprmt Washington, Oregon and California (W-O-C) permit data
actdate Date permit activated for a vessel or a fisher. (Format: dd-MMM-yy)
agid An agency identifier
drvid A coastwide vessel identifier. Can be a USCG VID (ex: 1234567 or AK1234nn) or a ZZZ identifier indicating no vessel used, vessel id not provided, or an invalid vessel identifier provided
expdate Date permit expires or is de-activated. (Format: dd-MMM-yy)
fee Units = dollars, initial or renewal fee paid to agency
length_restrict Vessel length restrictions (units = feet; transfer/sale of this permit is restricted by this length; this restriction may be established by agency policy using certain formulas)
licnum license number
ownleas boolean (T/F)
penalty_cost Additional cost (late fee units = dollars)
permid Permit identifier
permtype Agency defined permit type
price Permit cost in dollars
status Alpha, optional (A = Active, T = waiting transfer, I = waiting to be issued, W = waiting issue and transfer
text_comment Additional description of permit, provided by the state agency.
veid Vessel identifier as in source data
vidtype Type of vessel identifier (see vid-type in table cl)
year Year of permit (Format: yyyy)