NOAA/NMFS/NWFSC TM-31: Data Collection -- Groundfish: Table 6.2

U.S. Dept Commerce/NOAA/NMFS/NWFSC/Publications

NOAA-NMFS-NWFSC TM-31: Data Collection -- Groundfish (cont):

Table 6.2
Database tables maintained within PacFIN.^a


Table	Acronym	Description

Species code list	SP	PacFIN codes for species of fish
Area code list	AR	PacFIN codes for area fished
Gear-type code list	GR	PacFIN codes for types of fishing gear
Port/JV/Country code list	PC	PacFIN codes for ports/joint ventures/countries
Agency code list	AG	PacFIN codes for agencies (data sources)
Code list	CL	PacFIN codes for miscellaneous fields
Agency-species code list	ASP	Agency codes for species of fish and corresponding PacFIN codes
Agency-area code list	AAR	Agency codes for area fished and corresponding PacFIN codes
Agency-gear type code list	AGR	Agency codes for types of fishing gear and corresponding PacFIN codes
Agency-port code list	APR	Agency codes for ports and corresponding PacFIN codes
Agency-processor code list	APC	Agency codes for fish processors
Fish ticket	FT	Fish ticket data, one entry for each delivery of fish (i.e., each fishing trip)
Fish-ticket lines	FTL	Fish ticket data, one entry for each category of fish delivered
Catch-by-area composition	ACM	Area fished data
Species-composition	SCM	Species-composition data
Effort-by-area composition^b	ECM	Fishing effort data
Summary-catch	SC	Catch summaries for combinations of time period, species, area, gear type, and port
Detail-catch	DC	Catch summaries aggregated by day, week, or month
Summary-effort	SE	Effort summaries for combinations of time period, species, area, gear type, and port
Detail-effort	DE	Effort summaries aggregated by day, week, or month
State-vessels	SV	State-vessel registration records
U.S. Coast Guard vessels	CG	Selected attributes from U.S. Coast Guard vessel registration records
Non-vessel	NV	Data not found in SV table, primarily tribal ID data
Average-weights^b	AW	Average-weight data
Update-log	UL	Processing data, one entry for each update transaction
Detail-log	DL	Processing data, catch added during each update event by management group and month

^aFor a thorough description of each database table, see: Daspit, W. P. 1996. A description of the Pacific Fishery Information Network (PacFIN) 1981-1996. Unpubl. manuscr., 39 p. plus appendices. (Available from Pacific States Marine Fisheries Commission-PacFIN F/AKC, Building 4 - Room 2066, 7600 Sand Point Way NE, Seattle, WA 98115.)

^bTables contain only data submitted by the Oregon Department of Fish and Wildlife; AW table includes only average-weight data for salmon, sturgeon, and shad.