Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: individual_hooknline_view

Entity Information

Entity Type: Data View
Description:

Hook and Line individual details for only individuals that are not excluded

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
drop_time_dim$hour int2 standard representation of the hour
100
sampling_start_time_dim$second int2 number of seconds in the minute
100
best_available_taxonomy_observation_detail_dim$measurement_procurement varchar how the measurement was achieved
100
most_recent_age_update_date_dim$year int4 numeric representation of year
100
best_available_taxonomy_dim$hookandline_species_id int4 species identifier used by hook and line
100
best_available_taxonomy_dim$superfamily_48 varchar superfamily name
100
most_recent_taxonomy_update_date_dim$month_name varchar text representation of month
100
field_identified_taxonomy_dim$grp_nonstandard_taxon_99 varchar a pseudo taxonomic level that has a common usage such as Invertebrata, Pisces (Fish). This has been designed to allow for only one level of para- or poly-phyletic group that is the terminus of the definition (it may be associated with a higher level taxonomic hierarchy). Consequently a definition such as Fish->Roundfish would not be supported with this design
100
best_available_taxonomy_dim$kingdom_10 varchar kingdom name
100
best_available_taxonomy_dim$trawl_survey_species_id int4 species identifier used by the trawl survey
100
drop_time_whid int8 Warehouse identifier for the drop time
100
site_dim$tide_station_name varchar name of nearest tide station
100
taxon_rank varchar name of the lowest taxonomic level used to define scientific name
100
most_recent_taxonomy_update_date_dim$yyyymmdd bpchar text representation of year month day
100
best_available_taxonomy_observation_detail_dim$means_of_calculation varchar describes how the measurement was calculated
100
date_dim$day_of_month int2 numeric representation of the day in month
100
date_dim$month_abbrev bpchar three character representation of month in capital letters
100
tow_end_timestamp timestamp operation end date timestamp
100
field_identified_taxonomy_dim$observer_species_id int4 species identifier used by the observer program
100
field_identified_taxonomy_dim$norpac_species_id int4 A three-digit numeric code assigned by the NMFS Observer Program to each different marine organism expected to be seen in the Bering Sea and northeast Pacific Ocean. Each number is uniquely associated with a species_name and a scientific name.
100
operation_dim$vessel_id int2 field database vessel id number
100
field_identified_taxonomy_dim$species_sub_category varchar mid-level taxonomic ranking
100
operation_dim_whid int8 Warehouse identifier to operation details
100
operation_dim$coast_guard_number varchar Coast Guard documentation number of vessel
100
most_recent_age_update_date_dim$month_of_year int2 numeric representation of month of year
100
hook_id int4 Field database hook identifier
100
field_identified_taxonomy_dim$hookandline_species_id int4 species identifier used by hook and line
100
best_available_taxonomy_dim$observer_species_id int4 species identifier used by the observer program
100
most_recent_taxonomy_update_date_dim$day_of_month int2 numeric representation of the day in month
100
drop_time_dim$hh24miss bpchar concatenation of military hour, minute, second, example 230415 equates to 23:04:15
100
drop_latitude_dim$latitude_in_degrees numeric numeric representation of latitude in degrees
100
field_identified_taxonomy_dim$pacfin_spid varchar pacfin species id - many taxa may not have one of these
100
drop_longitude_dim$longitude_compass_direction bpchar longitude compass direction
100
operation_dim$captain_person_whid int4 person reference for the vessel captain
100
pacfin_spid varchar pacfin species id - many taxa may not have one of these
100
best_available_taxonomy_dim$tribe_60 varchar tribe name
100
operation_dim$state_registration_number varchar state registration number for the vessel
100
operation_dim$scientist_2_person_whid int4 person reference for the second scientist
100
site_dim$tide_station_longitude_whid int4 warehouse identifier to longitude details for site's nearest tide station
100
drop_latitude_dim$latitude_second_units int2 numeric representation of latitude that makes up the second unit only
100
hook_whid int4 Warehouse identifier to hook details
100
drop_sounder_depth_dim$depth_fathoms numeric depth low precision measurement in fathoms converted from meters measured to the tenth of a meter except for special fathom boundaries
100
operation_dim$operation_start_time_whid int8 start time reference for the operation
100
best_available_taxonomy_dim$grp_reg_depth_category varchar management grouping mostly for rockfishes (but could be assigned to any species): nearshore, shelf, or slope, or in future shallower shelf and deeper shelf
67
sex bpchar
100
best_available_taxonomy_dim$family_50 varchar family name
100
operation_dim$field_operation_seg_id int8 operation segment id reference to the field operational segment table
100
taxon_source varchar name of primary source used to get the measurement
100
drop_sounder_depth_dim$depth_meters numeric depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries)
100
site_dim$site_longitude_dd numeric site longitude in decimal degrees
100
otolith_number varchar Individual otolith tracking number
100
drop_longitude_whid int4 Warehouse identifier for the longitude drop to the second unit of measure
100
field_identified_taxonomy_dim$superorder_38 varchar superorder name
100
best_available_taxonomy_dim$genus_70 varchar genus name
100
drop_time_dim$record_type varchar time record or reason record is unavailable
100
operation_dim$return_date_whid int8 date reference that vessel returned for the defined leg or trip
100
angler_person_dim$first_name varchar first name of person
100
site_dim$inactive_date_whid int8 warehouse identifier for the date when the site went inactive
100
lab_maturity_detail_dim$functionally_mature_indicator varchar identifies the functional maturity of the individual
100
date_dim$full_date timestamp full date value
100
best_available_taxonomy_dim$suborder_42 varchar suborder name
100
best_available_taxonomy_dim$worms_aphiaid int4 WoRMS taxonomic identifier
100
drop_time_dim$period bpchar period of time
100
field_identified_taxonomy_dim$structure_source varchar Source of the taxonomic structure
100
operation_dim$operation_end_date_whid int8 end date reference for the operation
100
operation_dim$return_port_whid int4 port reference for return port
100
trawl_id int8 identifier for a sampling operation
100
hook_dim$record_type varchar hook record or reason record is unavailable
100
weight_kg numeric Individual weight in kilograms
100
sex_dim$record_type varchar latitude record type or reason record is unavailable
100
best_available_taxonomy_observation_detail_dim$record_type varchar observation detail record type or reason record is unavailable
100
disposition_dim$return_indicator varchar Indicates if returned to sea
100
field_identified_taxonomy_dim$phylum_20 varchar phylum name
100
best_available_taxonomy_dim$subspecies_82 varchar subspecies name
100
date_yyyymmdd bpchar text representation of year month day
100
site_dim$tide_station_latitude_whid int4 warehouse identifier to latitude details for site's nearest tide station
100
sampling_start_time_dim$record_type varchar time record or reason record is unavailable
100
drop_latitude_dim$latitude_compass_direction bpchar latitude compass direction
100
drop_longitude_dim$longitude_second_units int2 numeric representation of longitude that makes up the second unit only
100
field_identified_taxonomy_dim$acoustics_species_id int4 Species ID used in the acoustics program
100
field_identified_taxonomy_dim$genus_70 varchar genus name
100
most_recent_age_update_date_dim$month_abbrev bpchar three character representation of month in capital letters
100
date_dim$month_of_year int2 numeric representation of month of year
100
drop_time_dim$second int2 number of seconds in the minute
100
best_available_taxonomy_dim$superorder_38 varchar superorder name
100
most_recent_age_update_date_dim$month_name varchar text representation of month
100
site_dim$site_number int4 site identifier number
100
drop_latitude_dim$latitude_minute_units int2 numeric representation of latitude that makes up the minute unit only
100
field_identified_taxonomy_dim$record_type varchar record or reason record is unavailable
100
disposition_whid int2 Warehouse identifier to disposition details
100
angler_person_dim$full_name varchar full name in format of First and Last (Suffix)
100
best_available_taxonomy_dim$infraorder_44 varchar infraorder name
100
field_identified_taxonomy_dim$subfamily_52 varchar subfamily name
100
net_touchdown_time time military time representation of the time
100
sampling_end_hhmmss bpchar concatenation of military hour, minute, second, example 230415 equates to 23:04:15
100
field_identified_taxonomy_dim$abbreviated_name varchar specialized common name, generally for a well-known species of fish such as ATF, LST, SST
100
best_available_taxonomy_dim$class_30 varchar class name
100
best_available_taxonomy_dim$acoustics_species_id int4 Species ID used in the acoustics program
100
most_recent_taxon_update timestamp full date value
100
sampling_start_time_dim$period bpchar period of time
100
sampling_end_time_dim$record_type varchar time record or reason record is unavailable
100
field_identified_taxonomy_dim$grp_reg_depth_category varchar management grouping mostly for rockfishes (but could be assigned to any species): nearshore, shelf, or slope, or in future shallower shelf and deeper shelf
100
site_dim$area_name varchar name of area site is located in
100
most_recent_taxonomy_update_date_whid int8 Warehouse identifier for most recent taxonomy update date
100
most_recent_age_update_date_dim$record_type varchar date, month, or year record or reason record is unavailable
100
drop_latitude_dim$named_parallel varchar name of parallel, boundary, or commonly used geograpical location
100
angler_person_whid int4 Warehouse identifier for the angler
100
lab_maturity_detail_dim$record_type varchar lab maturity detail record or reason record is unavailable
100
best_available_taxonomy_observation_detail_whid int4 Warehouse identifier to taxonomy observation detail
100
drop_latitude_whid int4 Warehouse identifier for the latitude drop to the second unit of measure
100
date_dim$year int4 numeric representation of year
100
best_available_taxonomy_dim$infraclass_34 varchar infraclass name
100
field_identified_taxonomy_dim$subphylum_22 varchar subphylum name
100
best_available_taxonomy_dim$phylum_20 varchar phylum name
100
best_available_taxonomy_dim$itis_taxonomic_serial_no int4 ITIS taxonomic identifier
100
drop_latitude_dim$record_type varchar latitude record type or reason record is unavailable
100
sampling_end_time_dim$period bpchar period of time
100
tow_start_timestamp timestamp operation start date timestamp
100
site_dim$distance_to_port_nm numeric distance from site to nearest port in nautical miles
100
site_dim$site_latitude_dd numeric site latitude in decimal degrees
100
drop_longitude_dim$longitude_in_degrees numeric numeric representation of longitude in decimal degrees
100
site_dim$site_latitude_whid int4 warehouse identifier to latitude details for site
100
drop_sounder_depth_dim$boundary_indicator varchar depth boundry indicator identifying ifp boundary marks
100
field_identified_taxonomy_dim$superfamily_48 varchar superfamily name
100
most_recent_taxonomy_update_date_dim$month_abbrev bpchar three character representation of month in capital letters
100
date_dim$record_type varchar date, month, or year record or reason record is unavailable
100
drop_sounder_depth_dim$record_type varchar depth record or reason record is unavailable
100
operation_dim$operation_type varchar type of operation
100
best_available_taxonomy_whid int4 Warehouse identifier to best available taxonomy
100
best_available_taxonomy_dim$superclass_28 varchar superclass name
100
operation_dim$scientist_1_person_whid int4 person reference for the first scientist
100
operation_dim$record_type varchar operation record or reason record is unavailable
100
best_available_taxonomy_observation_detail_dim$observation_type varchar the type of observation
100
sampling_end_time_dim$military_hour int2 military representation of the hour
100
vessel varchar name of the vessel used for the operation
100
hook_dim$hook_result varchar The result of using the hook
100
field_identified_taxonomy_dim$family_50 varchar family name
100
operation_dim$observer_program varchar description of the observer program
100
most_recent_age_update_date_dim$day_of_month int2 numeric representation of the day in month
100
field_identified_taxonomy_dim$infraclass_34 varchar infraclass name
100
site_whid int4 Warehouse identifier to site details
100
fish_note varchar Fish note details
100
program varchar type of fram program
100
best_available_taxonomy_dim$abbreviated_name varchar specialized common name, generally for a well-known species of fish such as ATF, LST, SST
100
field_identified_taxonomy_dim$subspecies_82 varchar subspecies name
100
operation_dim$operation_start_date_whid int8 start date reference for the operation
67
sex_dim$sex varchar
100
sex_whid int2 Warehouse identifier to sex details
100
operation_dim$scientist_4_person_whid int4 person reference for the fourth scientist
100
operation_dim$fpc_person_whid int4 person reference for the FPC
100
drop_longitude_dim$longitude_degree_units int2 numeric representation of longitude that makes up the degree unit only
100
lab_maturity_detail_dim$functionally_mature_certain_indicator varchar identifies the certainty of the functionally mature evaluation
100
best_available_taxonomy_dim$record_type varchar record or reason record is unavailable
100
site_dim$record_type varchar site record or reason record is unavailable
100
disposition_dim$record_type varchar Type of record
100
best_available_taxonomy_dim$pacfin_nom_spid varchar PacFIN nominal species identifier
100
performance varchar performance of the operation
100
best_available_taxonomy_dim$norpac_species_id int4 A three-digit numeric code assigned by the NMFS Observer Program to each different marine organism expected to be seen in the Bering Sea and northeast Pacific Ocean. Each number is uniquely associated with a species_name and a scientific name.
100
sampling_end_time_dim$hour int2 standard representation of the hour
100
angler_person_dim$role varchar role taken during an operation
100
lab_maturity_detail_dim$biologically_mature_certain_indicator varchar identifies the certainty of the biological maturity
100
species_subcategory varchar mid-level taxonomic ranking
100
sampling_start_time_whid int4 Warehouse identifier for the sampling start time of the site visit
100
field_identified_taxonomy_dim$infraorder_44 varchar infraorder name
100
hook_dim$hook_number int2 The hook number on the line
100
disposition_dim$disposition varchar Identifies condition
100
operation_dim$ifq_account_number varchar unique number assigned to user accounts in the Vessel Accounting Database
100
sampling_end_time_whid int4 Warehouse identifier for the sampling end time of the site visit
100
best_available_taxonomy_dim$subfamily_52 varchar subfamily name
100
most_recent_age_update_date_whid int8 Warehouse identifier for most recent age update date
100
lab_maturity_detail_dim$biologically_mature_indicator varchar identifies biological maturity of the individual
100
fin_clip_number varchar Individual fin clip tracking number
100
hook_dim$gear_performance varchar Gear performance
100
lab_maturity_detail_whid int4 Warehouse identifier to lab maturity details
100
leg int2 leg number of the survey
100
field_identified_taxonomy_dim$kingdom_10 varchar kingdom name
100
field_identified_taxonomy_dim$worms_aphiaid int4 WoRMS taxonomic identifier
100
most_recent_age_update_date_dim$yyyymmdd bpchar text representation of year month day
100
field_identified_taxonomy_dim$itis_taxonomic_serial_no int4 ITIS taxonomic identifier
100
sampling_start_time_dim$military_hour int2 military representation of the hour
100
age_years int2 Individual determined age in years
100
angler_person_dim$record_type varchar person record or reason record is unavailable
100
inclusion_whid int4 Warehouse identifier for what to include in analysis
100
operation_dim$departure_port_whid int4 port reference for the departure port
100
field_identified_taxonomy_dim$pacfin_nom_spid varchar PacFIN nominal species identifier
100
field_identified_taxonomy_dim$common_name varchar only one broadly used common name is supported by this design. If the common name is not fairly universally used or is used by more than one taxon this should be left null
100
field_identified_taxonomy_dim$species_category varchar upper-level taxonomic ranking
100
drop_longitude_dim$record_type varchar longitude record type or reason record is unavailable
100
drop_sounder_depth_whid int4 Warehouse identifier to the drop depth from the sounder sensor to the tenth of a meter unit
100
field_identified_taxonomy_whid int4 Warehouse identifier to field identified taxonomy
100
drop_time_dim$military_hour int2 military representation of the hour
100
sampling_start_hhmmss bpchar concatenation of military hour, minute, second, example 230415 equates to 23:04:15
100
individual_tracking_id int4 Field individual identification number
100
most_recent_age_update timestamp full date value
100
sampling_start_time_dim$minute int2 number of minutes in the hour
100
inclusion_dim$hook_inclusion_indicator varchar indicates if hook should be included
100
angler_person_dim$nick_name varchar nickname of person
100
operation_dim$trip_id int4 trip identifier number
100
species_category varchar upper-level taxonomic ranking
100
field_identified_taxonomy_dim$scientific_name_taxonomic_level varchar name of the lowest taxonomic level used to define scientific name
100
best_available_taxonomy_observation_detail_dim$method_description varchar description of how the observation was taken
100
scientific_name varchar scientific name generally composed of the genus and species name and subspecies name if available, but may be the highest taxonomic level
100
sampling_end_time_dim$second int2 number of seconds in the minute
100
inclusion_dim$drop_inclusion_indicator varchar indicates if drop should be included
100
field_identified_taxonomy_dim$trawl_survey_species_id int4 species identifier used by the trawl survey
100
operation_dim$scientist_3_person_whid int4 person reference for the third scientist
100
site_dim$site_longitude_whid int4 warehouse identifier to longitude details for site
100
date_whid int8 Warehouse identifier to date details
100
drop_time_dim$minute int2 number of minutes in the hour
100
sampling_end_time_dim$minute int2 number of minutes in the hour
100
sampling_start_time_dim$hour int2 standard representation of the hour
100
field_identified_taxonomy_dim$scientific_name varchar scientific name generally composed of the genus and species name and subspecies name if available, but may be the highest taxonomic level
100
field_identified_taxonomy_dim$order_40 varchar order name
100
drop_longitude_dim$longitude_minute_units int2 numeric representation of longitude that makes up the minute unit only
100
best_available_taxonomy_dim$grp_nonstandard_taxon_99 varchar a pseudo taxonomic level that has a common usage such as Invertebrata, Pisces (Fish). This has been designed to allow for only one level of para- or poly-phyletic group that is the terminus of the definition (it may be associated with a higher level taxonomic hierarchy). Consequently a definition such as Fish->Roundfish would not be supported with this design
100
most_recent_taxonomy_update_date_dim$year int4 numeric representation of year
100
most_recent_taxonomy_update_date_dim$month_of_year int2 numeric representation of month of year
100
best_available_taxonomy_dim$subphylum_22 varchar subphylum name
100
year int2 operation year
100
field_identified_taxonomy_dim$tribe_60 varchar tribe name
100
best_available_taxonomy_dim$order_40 varchar order name
100
operation_dim$operation_end_time_whid int8 end time reference for the operation
100
tow int2 operation number of the survey
100
common_name varchar only one broadly used common name is supported by this design. If the common name is not fairly universally used or is used by more than one taxon this should be left null
100
field_identified_taxonomy_dim$superclass_28 varchar superclass name
100
site_dim$cowcod_conservation_area_indicator varchar indicates if site falls within the cowcod conservation area
100
best_available_taxonomy_dim$subclass_32 varchar subclass name
100
project varchar project name
100
field_identified_taxonomy_dim$subclass_32 varchar subclass name
100
site_dim$tide_station_noaa_id varchar tide station id according to NOAA's Tides and Currents site
100
pass int4 pass number of the survey
100
length_cm numeric Individual length in centimeters
100
inclusion_dim$record_type varchar inclusion record or reason record is unavailable
100
best_available_taxonomy_dim$species_80 varchar species name
100
best_available_taxonomy_dim$structure_source varchar Source of the taxonomic structure
100
drop_latitude_dim$latitude_in_degree_minute_second varchar string representation of latitude in degrees, minutes, and seconds for example 4525'01"
100
operation_dim$limited_entry_permit_number bpchar federal limited entry groundfish permit issued to fish in waters off of Washington, Oregon, and California
100
angler_person_dim$middle_initial bpchar middle initial of person
100
operation_dim$departure_date_whid int8 date reference that vessel departed for the defined leg or trip
100
site_dim$cdfgblock int4 CDFG Block Numbers that the sites fall within
100
most_recent_taxonomy_update_date_dim$record_type varchar date, month, or year record or reason record is unavailable
100
net_liftoff_time time military time representation of the time
100
angler_person_dim$last_name varchar last name of person
100
drop_time_dim$time time military time representation of the time
100
field_identified_taxonomy_dim$suborder_42 varchar suborder name
100
date_dim$month_name varchar text representation of month
100
drop_longitude_dim$longitude_in_degree_minute_second varchar string representation of longitude in degrees, minutes, and seconds for example 4525'01"
100
field_identified_taxonomy_dim$class_30 varchar class name
100
inclusion_dim$site_inclusion_indicator varchar indicates if site should be included
100
field_identified_taxonomy_dim$species_80 varchar species name
100
drop_latitude_dim$latitude_degree_units int2 numeric representation of latitude that makes up the degree unit only

Attribute Details

drop_time_dim$hour

CC ID: 377682
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

standard representation of the hour

Unit of Measure: hr
Allowed Values: 0-12

sampling_start_time_dim$second

CC ID: 377683
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

number of seconds in the minute

Unit of Measure: sec
Allowed Values: 0-60

best_available_taxonomy_observation_detail_dim$measurement_procurement

CC ID: 377684
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

how the measurement was achieved

Allowed Values: NA, Calculated, Estimated, Observed, Measured, Not Documented

most_recent_age_update_date_dim$year

CC ID: 377685
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of year

Allowed Values: 1978+

best_available_taxonomy_dim$hookandline_species_id

CC ID: 377686
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

species identifier used by hook and line

best_available_taxonomy_dim$superfamily_48

CC ID: 377687
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

superfamily name

most_recent_taxonomy_update_date_dim$month_name

CC ID: 377688
Data Storage Type: varchar
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

text representation of month

Allowed Values: January, February, March, April, May, June, July, August, September, October, November, December

field_identified_taxonomy_dim$grp_nonstandard_taxon_99

CC ID: 377689
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

a pseudo taxonomic level that has a common usage such as Invertebrata, Pisces (Fish). This has been designed to allow for only one level of para- or poly-phyletic group that is the terminus of the definition (it may be associated with a higher level taxonomic hierarchy). Consequently a definition such as Fish->Roundfish would not be supported with this design

best_available_taxonomy_dim$kingdom_10

CC ID: 377690
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

kingdom name

best_available_taxonomy_dim$trawl_survey_species_id

CC ID: 377691
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

species identifier used by the trawl survey

drop_time_whid

CC ID: 377692
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for the drop time

site_dim$tide_station_name

CC ID: 377693
Data Storage Type: varchar
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

name of nearest tide station

taxon_rank

CC ID: 377694
Data Storage Type: varchar
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

name of the lowest taxonomic level used to define scientific name

most_recent_taxonomy_update_date_dim$yyyymmdd

CC ID: 377695
Data Storage Type: bpchar
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

text representation of year month day

best_available_taxonomy_observation_detail_dim$means_of_calculation

CC ID: 377696
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

describes how the measurement was calculated

Allowed Values: Observation Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

date_dim$day_of_month

CC ID: 377697
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of the day in month

Allowed Values: 1-31

date_dim$month_abbrev

CC ID: 377698
Data Storage Type: bpchar
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

three character representation of month in capital letters

Allowed Values: JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC

tow_end_timestamp

CC ID: 377699
Data Storage Type: timestamp
Required: No
Primary Key: No
Status: Active
Description:

operation end date timestamp

field_identified_taxonomy_dim$observer_species_id

CC ID: 377700
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

species identifier used by the observer program

field_identified_taxonomy_dim$norpac_species_id

CC ID: 377701
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

A three-digit numeric code assigned by the NMFS Observer Program to each different marine organism expected to be seen in the Bering Sea and northeast Pacific Ocean. Each number is uniquely associated with a species_name and a scientific name.

Unit of Measure: unspecified
Allowed Values: Any

operation_dim$vessel_id

CC ID: 377702
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

field database vessel id number

field_identified_taxonomy_dim$species_sub_category

CC ID: 377703
Data Storage Type: varchar
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

mid-level taxonomic ranking

Allowed Values: rockfish, flatfish, shark, crab, NA

operation_dim_whid

CC ID: 377704
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier to operation details

operation_dim$coast_guard_number

CC ID: 377705
Data Storage Type: varchar
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Coast Guard documentation number of vessel

most_recent_age_update_date_dim$month_of_year

CC ID: 377706
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of month of year

Allowed Values: 1-12

hook_id

CC ID: 377707
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Field database hook identifier

field_identified_taxonomy_dim$hookandline_species_id

CC ID: 377708
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

species identifier used by hook and line

best_available_taxonomy_dim$observer_species_id

CC ID: 377709
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

species identifier used by the observer program

most_recent_taxonomy_update_date_dim$day_of_month

CC ID: 377710
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of the day in month

Allowed Values: 1-31

drop_time_dim$hh24miss

CC ID: 377711
Data Storage Type: bpchar
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

concatenation of military hour, minute, second, example 230415 equates to 23:04:15

drop_latitude_dim$latitude_in_degrees

CC ID: 377712
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 8
Status: Active
Description:

numeric representation of latitude in degrees

Unit of Measure: dd
Allowed Values: -90 to 90

field_identified_taxonomy_dim$pacfin_spid

CC ID: 377713
Data Storage Type: varchar
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

pacfin species id - many taxa may not have one of these

drop_longitude_dim$longitude_compass_direction

CC ID: 377714
Data Storage Type: bpchar
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

longitude compass direction

Allowed Values: E, W

operation_dim$captain_person_whid

CC ID: 377715
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

person reference for the vessel captain

pacfin_spid

CC ID: 377716
Data Storage Type: varchar
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

pacfin species id - many taxa may not have one of these

best_available_taxonomy_dim$tribe_60

CC ID: 377717
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

tribe name

operation_dim$state_registration_number

CC ID: 377718
Data Storage Type: varchar
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

state registration number for the vessel

operation_dim$scientist_2_person_whid

CC ID: 377719
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

person reference for the second scientist

site_dim$tide_station_longitude_whid

CC ID: 377720
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier to longitude details for site's nearest tide station

drop_latitude_dim$latitude_second_units

CC ID: 377721
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of latitude that makes up the second unit only

Unit of Measure: sec
Allowed Values: 0-60

hook_whid

CC ID: 377722
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier to hook details

drop_sounder_depth_dim$depth_fathoms

CC ID: 377723
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

depth low precision measurement in fathoms converted from meters measured to the tenth of a meter except for special fathom boundaries

Unit of Measure: fth

operation_dim$operation_start_time_whid

CC ID: 377724
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

start time reference for the operation

best_available_taxonomy_dim$grp_reg_depth_category

CC ID: 377725
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

management grouping mostly for rockfishes (but could be assigned to any species): nearshore, shelf, or slope, or in future shallower shelf and deeper shelf

sex

CC ID: 377726
Data Storage Type: bpchar
Max Length: 1
Required: No
Primary Key: No
Status: Active
Unit of Measure: unspecified
Allowed Values: Any

best_available_taxonomy_dim$family_50

CC ID: 377727
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

family name

operation_dim$field_operation_seg_id

CC ID: 377728
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

operation segment id reference to the field operational segment table

taxon_source

CC ID: 377729
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

name of primary source used to get the measurement

Allowed Values: Angler, FPC, Genetics, Lab Exam, Large Scale, Morphometrics, Morphometrics + Genetics, NA, Quality Assurance, Retrospective Review, Taxon Rank Upped, Whole Organism

drop_sounder_depth_dim$depth_meters

CC ID: 377730
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries)

Unit of Measure: m
Allowed Values: 0-1500

site_dim$site_longitude_dd

CC ID: 377731
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 6
Status: Active
Description:

site longitude in decimal degrees

Unit of Measure: dd

otolith_number

CC ID: 377732
Data Storage Type: varchar
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Individual otolith tracking number

drop_longitude_whid

CC ID: 377733
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for the longitude drop to the second unit of measure

field_identified_taxonomy_dim$superorder_38

CC ID: 377734
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

superorder name

best_available_taxonomy_dim$genus_70

CC ID: 377735
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

genus name

drop_time_dim$record_type

CC ID: 377736
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

time record or reason record is unavailable

Allowed Values: Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

operation_dim$return_date_whid

CC ID: 377737
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

date reference that vessel returned for the defined leg or trip

angler_person_dim$first_name

CC ID: 377738
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

first name of person

site_dim$inactive_date_whid

CC ID: 377739
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier for the date when the site went inactive

lab_maturity_detail_dim$functionally_mature_indicator

CC ID: 377740
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

identifies the functional maturity of the individual

Allowed Values: Functionally Mature, Not Functionally Mature, NA

date_dim$full_date

CC ID: 377741
Data Storage Type: timestamp
Required: No
Primary Key: No
Status: Active
Description:

full date value

best_available_taxonomy_dim$suborder_42

CC ID: 377742
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

suborder name

best_available_taxonomy_dim$worms_aphiaid

CC ID: 377743
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

WoRMS taxonomic identifier

Unit of Measure: unspecified
Allowed Values: Any

drop_time_dim$period

CC ID: 377744
Data Storage Type: bpchar
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

period of time

Allowed Values: AM, PM

field_identified_taxonomy_dim$structure_source

CC ID: 377745
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Source of the taxonomic structure

Unit of Measure: unspecified
Allowed Values: Any

operation_dim$operation_end_date_whid

CC ID: 377746
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

end date reference for the operation

operation_dim$return_port_whid

CC ID: 377747
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

port reference for return port

trawl_id

CC ID: 377748
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

identifier for a sampling operation

hook_dim$record_type

CC ID: 377749
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

hook record or reason record is unavailable

Allowed Values: Hook, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

weight_kg

CC ID: 377750
Data Storage Type: numeric
Max Length: 6
Required: No
Primary Key: No
Precision: 2
Status: Active
Description:

Individual weight in kilograms

sex_dim$record_type

CC ID: 377751
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

latitude record type or reason record is unavailable

Unit of Measure: NA
Allowed Values: Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

best_available_taxonomy_observation_detail_dim$record_type

CC ID: 377752
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

observation detail record type or reason record is unavailable

Allowed Values: Observation Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

disposition_dim$return_indicator

CC ID: 377753
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Indicates if returned to sea

Allowed Values: Returned to Sea, Not Returned to Sea, NA

field_identified_taxonomy_dim$phylum_20

CC ID: 377754
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

phylum name

best_available_taxonomy_dim$subspecies_82

CC ID: 377755
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

subspecies name

date_yyyymmdd

CC ID: 377756
Data Storage Type: bpchar
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

text representation of year month day

site_dim$tide_station_latitude_whid

CC ID: 377757
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier to latitude details for site's nearest tide station

sampling_start_time_dim$record_type

CC ID: 377758
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

time record or reason record is unavailable

Allowed Values: Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

drop_latitude_dim$latitude_compass_direction

CC ID: 377759
Data Storage Type: bpchar
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

latitude compass direction

Unit of Measure: NA
Allowed Values: N, S

drop_longitude_dim$longitude_second_units

CC ID: 377760
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of longitude that makes up the second unit only

Unit of Measure: sec
Allowed Values: 0-59

field_identified_taxonomy_dim$acoustics_species_id

CC ID: 377761
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Species ID used in the acoustics program

Unit of Measure: unspecified
Allowed Values: Any

field_identified_taxonomy_dim$genus_70

CC ID: 377762
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

genus name

most_recent_age_update_date_dim$month_abbrev

CC ID: 377763
Data Storage Type: bpchar
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

three character representation of month in capital letters

Allowed Values: JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC

date_dim$month_of_year

CC ID: 377764
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of month of year

Allowed Values: 1-12

drop_time_dim$second

CC ID: 377765
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

number of seconds in the minute

Unit of Measure: sec
Allowed Values: 0-60

best_available_taxonomy_dim$superorder_38

CC ID: 377766
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

superorder name

most_recent_age_update_date_dim$month_name

CC ID: 377767
Data Storage Type: varchar
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

text representation of month

Allowed Values: January, February, March, April, May, June, July, August, September, October, November, December

site_dim$site_number

CC ID: 377768
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

site identifier number

drop_latitude_dim$latitude_minute_units

CC ID: 377769
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of latitude that makes up the minute unit only

Unit of Measure: min
Allowed Values: 0-60

field_identified_taxonomy_dim$record_type

CC ID: 377770
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

record or reason record is unavailable

Allowed Values: Taxonomy, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

disposition_whid

CC ID: 377771
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier to disposition details

angler_person_dim$full_name

CC ID: 377772
Data Storage Type: varchar
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

full name in format of First and Last (Suffix)

best_available_taxonomy_dim$infraorder_44

CC ID: 377773
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

infraorder name

field_identified_taxonomy_dim$subfamily_52

CC ID: 377774
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

subfamily name

net_touchdown_time

CC ID: 377775
Data Storage Type: time
Required: No
Primary Key: No
Status: Active
Description:

military time representation of the time

sampling_end_hhmmss

CC ID: 377776
Data Storage Type: bpchar
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

concatenation of military hour, minute, second, example 230415 equates to 23:04:15

field_identified_taxonomy_dim$abbreviated_name

CC ID: 377777
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

specialized common name, generally for a well-known species of fish such as ATF, LST, SST

best_available_taxonomy_dim$class_30

CC ID: 377778
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

class name

best_available_taxonomy_dim$acoustics_species_id

CC ID: 377779
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Species ID used in the acoustics program

Unit of Measure: unspecified
Allowed Values: Any

most_recent_taxon_update

CC ID: 377780
Data Storage Type: timestamp
Required: No
Primary Key: No
Status: Active
Description:

full date value

sampling_start_time_dim$period

CC ID: 377781
Data Storage Type: bpchar
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

period of time

Allowed Values: AM, PM

sampling_end_time_dim$record_type

CC ID: 377782
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

time record or reason record is unavailable

Allowed Values: Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

field_identified_taxonomy_dim$grp_reg_depth_category

CC ID: 377783
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

management grouping mostly for rockfishes (but could be assigned to any species): nearshore, shelf, or slope, or in future shallower shelf and deeper shelf

site_dim$area_name

CC ID: 377784
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

name of area site is located in

most_recent_taxonomy_update_date_whid

CC ID: 377785
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for most recent taxonomy update date

most_recent_age_update_date_dim$record_type

CC ID: 377786
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

date, month, or year record or reason record is unavailable

Allowed Values: Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

drop_latitude_dim$named_parallel

CC ID: 377787
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

name of parallel, boundary, or commonly used geograpical location

Unit of Measure: NA
Allowed Values: any

angler_person_whid

CC ID: 377788
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for the angler

lab_maturity_detail_dim$record_type

CC ID: 377789
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

lab maturity detail record or reason record is unavailable

Allowed Values: Lab Maturity Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

best_available_taxonomy_observation_detail_whid

CC ID: 377790
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier to taxonomy observation detail

drop_latitude_whid

CC ID: 377791
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for the latitude drop to the second unit of measure

date_dim$year

CC ID: 377792
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of year

Allowed Values: 1978+

best_available_taxonomy_dim$infraclass_34

CC ID: 377793
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

infraclass name

field_identified_taxonomy_dim$subphylum_22

CC ID: 377794
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

subphylum name

best_available_taxonomy_dim$phylum_20

CC ID: 377795
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

phylum name

best_available_taxonomy_dim$itis_taxonomic_serial_no

CC ID: 377796
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

ITIS taxonomic identifier

Unit of Measure: unspecified
Allowed Values: Any

drop_latitude_dim$record_type

CC ID: 377797
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

latitude record type or reason record is unavailable

Unit of Measure: NA
Allowed Values: Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

sampling_end_time_dim$period

CC ID: 377798
Data Storage Type: bpchar
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

period of time

Allowed Values: AM, PM

tow_start_timestamp

CC ID: 377799
Data Storage Type: timestamp
Required: No
Primary Key: No
Status: Active
Description:

operation start date timestamp

site_dim$distance_to_port_nm

CC ID: 377800
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 1
Status: Active
Description:

distance from site to nearest port in nautical miles

Unit of Measure: m

site_dim$site_latitude_dd

CC ID: 377801
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 6
Status: Active
Description:

site latitude in decimal degrees

Unit of Measure: dd

drop_longitude_dim$longitude_in_degrees

CC ID: 377802
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 8
Status: Active
Description:

numeric representation of longitude in decimal degrees

Unit of Measure: dd
Allowed Values: -180 to 180

site_dim$site_latitude_whid

CC ID: 377803
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier to latitude details for site

drop_sounder_depth_dim$boundary_indicator

CC ID: 377804
Data Storage Type: varchar
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

depth boundry indicator identifying ifp boundary marks

Allowed Values: IFP Boundary Depth, Standard Contour Depth, NA

field_identified_taxonomy_dim$superfamily_48

CC ID: 377805
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

superfamily name

most_recent_taxonomy_update_date_dim$month_abbrev

CC ID: 377806
Data Storage Type: bpchar
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

three character representation of month in capital letters

Allowed Values: JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC

date_dim$record_type

CC ID: 377807
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

date, month, or year record or reason record is unavailable

Allowed Values: Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

drop_sounder_depth_dim$record_type

CC ID: 377808
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

depth record or reason record is unavailable

Allowed Values: Depth, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

operation_dim$operation_type

CC ID: 377809
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

type of operation

Allowed Values: CTD Cast, Drop, Experiment, Search, Trawl, VPR Tow, [null]

best_available_taxonomy_whid

CC ID: 377810
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier to best available taxonomy

best_available_taxonomy_dim$superclass_28

CC ID: 377811
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

superclass name

operation_dim$scientist_1_person_whid

CC ID: 377812
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

person reference for the first scientist

operation_dim$record_type

CC ID: 377813
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

operation record or reason record is unavailable

Allowed Values: Operation, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

best_available_taxonomy_observation_detail_dim$observation_type

CC ID: 377814
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

the type of observation

Allowed Values: NA, width, length, total_catch_weight, taxonomy, etc

sampling_end_time_dim$military_hour

CC ID: 377815
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

military representation of the hour

Allowed Values: 0-24

vessel

CC ID: 377816
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

name of the vessel used for the operation

Allowed Values: Aggressor, Amy Lynn, BJ Thomas, Blue Horizon, Captain Jack, Coast Pride, Excalibur, Last Straw, Limit Stalker, Mirage, Miss Leona, Morning Star, Ms. Julie, Noahs Ark, Pacific Sun IV, Raven, Sea Eagle, Toronado

hook_dim$hook_result

CC ID: 377817
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

The result of using the hook

Allowed Values: No Bait On Hook, Bait Back On Hook, No Hook, Multiple Hook, Fish, Angler Did Not Drop

field_identified_taxonomy_dim$family_50

CC ID: 377818
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

family name

operation_dim$observer_program

CC ID: 377819
Data Storage Type: varchar
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

description of the observer program

most_recent_age_update_date_dim$day_of_month

CC ID: 377820
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of the day in month

Allowed Values: 1-31

field_identified_taxonomy_dim$infraclass_34

CC ID: 377821
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

infraclass name

site_whid

CC ID: 377822
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier to site details

fish_note

CC ID: 377823
Data Storage Type: varchar
Max Length: 1000
Required: No
Primary Key: No
Status: Active
Description:

Fish note details

program

CC ID: 377824
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

type of fram program

Allowed Values: Bottom Trawl, Hook and Line

best_available_taxonomy_dim$abbreviated_name

CC ID: 377825
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

specialized common name, generally for a well-known species of fish such as ATF, LST, SST

field_identified_taxonomy_dim$subspecies_82

CC ID: 377826
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

subspecies name

operation_dim$operation_start_date_whid

CC ID: 377827
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

start date reference for the operation

sex_dim$sex

CC ID: 377828
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Unit of Measure: unspecified
Allowed Values: Any

sex_whid

CC ID: 377829
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier to sex details

operation_dim$scientist_4_person_whid

CC ID: 377830
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

person reference for the fourth scientist

operation_dim$fpc_person_whid

CC ID: 377831
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

person reference for the FPC

drop_longitude_dim$longitude_degree_units

CC ID: 377832
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of longitude that makes up the degree unit only

Unit of Measure: deg
Allowed Values: -180 to 180

lab_maturity_detail_dim$functionally_mature_certain_indicator

CC ID: 377833
Data Storage Type: varchar
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

identifies the certainty of the functionally mature evaluation

Allowed Values: Functionally Mature Certain, Not Functionally Mature Certain, NA

best_available_taxonomy_dim$record_type

CC ID: 377834
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

record or reason record is unavailable

Allowed Values: Taxonomy, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

site_dim$record_type

CC ID: 377835
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

site record or reason record is unavailable

Allowed Values: Site, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

disposition_dim$record_type

CC ID: 377836
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Type of record

Allowed Values: Disposition, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

best_available_taxonomy_dim$pacfin_nom_spid

CC ID: 377837
Data Storage Type: varchar
Max Length: 10
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

PacFIN nominal species identifier

Unit of Measure: unspecified
Allowed Values: Any

performance

CC ID: 377838
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

performance of the operation

Allowed Values: Insufficient Information, Indeterminate, Satisfactory, Trawlable, Untrawlable, Unsatisfactory, [null]

best_available_taxonomy_dim$norpac_species_id

CC ID: 377839
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

A three-digit numeric code assigned by the NMFS Observer Program to each different marine organism expected to be seen in the Bering Sea and northeast Pacific Ocean. Each number is uniquely associated with a species_name and a scientific name.

Unit of Measure: unspecified
Allowed Values: Any

sampling_end_time_dim$hour

CC ID: 377840
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

standard representation of the hour

Unit of Measure: hr
Allowed Values: 0-12

angler_person_dim$role

CC ID: 377841
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

role taken during an operation

Allowed Values: Captain, 2nd Captain, FPC, Cook, Scientist, Deck Hand

lab_maturity_detail_dim$biologically_mature_certain_indicator

CC ID: 377842
Data Storage Type: varchar
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

identifies the certainty of the biological maturity

Allowed Values: Biologically Mature Certain, Not Biologically Mature Certain, NA

species_subcategory

CC ID: 377843
Data Storage Type: varchar
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

mid-level taxonomic ranking

Allowed Values: rockfish, flatfish, shark, crab, NA

sampling_start_time_whid

CC ID: 377844
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for the sampling start time of the site visit

field_identified_taxonomy_dim$infraorder_44

CC ID: 377845
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

infraorder name

hook_dim$hook_number

CC ID: 377846
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

The hook number on the line

Allowed Values: 1-5

disposition_dim$disposition

CC ID: 377847
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Identifies condition

Allowed Values: Live, Dead, NA

operation_dim$ifq_account_number

CC ID: 377848
Data Storage Type: varchar
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

unique number assigned to user accounts in the Vessel Accounting Database

sampling_end_time_whid

CC ID: 377849
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for the sampling end time of the site visit

best_available_taxonomy_dim$subfamily_52

CC ID: 377850
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

subfamily name

most_recent_age_update_date_whid

CC ID: 377851
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for most recent age update date

lab_maturity_detail_dim$biologically_mature_indicator

CC ID: 377852
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

identifies biological maturity of the individual

Allowed Values: Biologically Mature, Not Biologically Mature, NA

fin_clip_number

CC ID: 377853
Data Storage Type: varchar
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Individual fin clip tracking number

hook_dim$gear_performance

CC ID: 377854
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Gear performance

Allowed Values: No Problems, Lost Sinker, Minor Tangle, Major Tangle, Lost Gangion, Lost Hook(s), Missing Time, Multiple Hook, Gear Not Deployed

lab_maturity_detail_whid

CC ID: 377855
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier to lab maturity details

leg

CC ID: 377856
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

leg number of the survey

Allowed Values: 1,2,3,4,5,6,7,8

field_identified_taxonomy_dim$kingdom_10

CC ID: 377857
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

kingdom name

field_identified_taxonomy_dim$worms_aphiaid

CC ID: 377858
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

WoRMS taxonomic identifier

Unit of Measure: unspecified
Allowed Values: Any

most_recent_age_update_date_dim$yyyymmdd

CC ID: 377859
Data Storage Type: bpchar
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

text representation of year month day

field_identified_taxonomy_dim$itis_taxonomic_serial_no

CC ID: 377860
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

ITIS taxonomic identifier

Unit of Measure: unspecified
Allowed Values: Any

sampling_start_time_dim$military_hour

CC ID: 377861
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

military representation of the hour

Allowed Values: 0-24

age_years

CC ID: 377862
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Individual determined age in years

angler_person_dim$record_type

CC ID: 377863
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

person record or reason record is unavailable

Allowed Values: Person, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

inclusion_whid

CC ID: 377864
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for what to include in analysis

operation_dim$departure_port_whid

CC ID: 377865
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

port reference for the departure port

field_identified_taxonomy_dim$pacfin_nom_spid

CC ID: 377866
Data Storage Type: varchar
Max Length: 10
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

PacFIN nominal species identifier

Unit of Measure: unspecified
Allowed Values: Any

field_identified_taxonomy_dim$common_name

CC ID: 377867
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

only one broadly used common name is supported by this design. If the common name is not fairly universally used or is used by more than one taxon this should be left null

field_identified_taxonomy_dim$species_category

CC ID: 377868
Data Storage Type: varchar
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

upper-level taxonomic ranking

Allowed Values: fish, invertebrate, mammal, seabird, reptile, nonspecific organics, NA

drop_longitude_dim$record_type

CC ID: 377869
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

longitude record type or reason record is unavailable

Allowed Values: Longitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

drop_sounder_depth_whid

CC ID: 377870
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier to the drop depth from the sounder sensor to the tenth of a meter unit

field_identified_taxonomy_whid

CC ID: 377871
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier to field identified taxonomy

drop_time_dim$military_hour

CC ID: 377872
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

military representation of the hour

Allowed Values: 0-24

sampling_start_hhmmss

CC ID: 377873
Data Storage Type: bpchar
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

concatenation of military hour, minute, second, example 230415 equates to 23:04:15

individual_tracking_id

CC ID: 377874
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Field individual identification number

most_recent_age_update

CC ID: 377875
Data Storage Type: timestamp
Required: No
Primary Key: No
Status: Active
Description:

full date value

sampling_start_time_dim$minute

CC ID: 377876
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

number of minutes in the hour

Unit of Measure: min
Allowed Values: 0-60

inclusion_dim$hook_inclusion_indicator

CC ID: 377877
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

indicates if hook should be included

Allowed Values: Include Hook, Do Not Include Hook, NA

angler_person_dim$nick_name

CC ID: 377878
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

nickname of person

operation_dim$trip_id

CC ID: 377879
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

trip identifier number

species_category

CC ID: 377880
Data Storage Type: varchar
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

upper-level taxonomic ranking

Allowed Values: fish, invertebrate, mammal, seabird, reptile, nonspecific organics, NA

field_identified_taxonomy_dim$scientific_name_taxonomic_level

CC ID: 377881
Data Storage Type: varchar
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

name of the lowest taxonomic level used to define scientific name

best_available_taxonomy_observation_detail_dim$method_description

CC ID: 377882
Data Storage Type: varchar
Max Length: 500
Required: No
Primary Key: No
Status: Active
Description:

description of how the observation was taken

scientific_name

CC ID: 377883
Data Storage Type: varchar
Max Length: 120
Required: No
Primary Key: No
Status: Active
Description:

scientific name generally composed of the genus and species name and subspecies name if available, but may be the highest taxonomic level

sampling_end_time_dim$second

CC ID: 377884
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

number of seconds in the minute

Unit of Measure: sec
Allowed Values: 0-60

inclusion_dim$drop_inclusion_indicator

CC ID: 377885
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

indicates if drop should be included

Allowed Values: Include Drop, Do Not Include Drop, NA

field_identified_taxonomy_dim$trawl_survey_species_id

CC ID: 377886
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

species identifier used by the trawl survey

operation_dim$scientist_3_person_whid

CC ID: 377887
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

person reference for the third scientist

site_dim$site_longitude_whid

CC ID: 377888
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier to longitude details for site

date_whid

CC ID: 377889
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier to date details

drop_time_dim$minute

CC ID: 377890
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

number of minutes in the hour

Unit of Measure: min
Allowed Values: 0-60

sampling_end_time_dim$minute

CC ID: 377891
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

number of minutes in the hour

Unit of Measure: min
Allowed Values: 0-60

sampling_start_time_dim$hour

CC ID: 377892
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

standard representation of the hour

Unit of Measure: hr
Allowed Values: 0-12

field_identified_taxonomy_dim$scientific_name

CC ID: 377893
Data Storage Type: varchar
Max Length: 120
Required: No
Primary Key: No
Status: Active
Description:

scientific name generally composed of the genus and species name and subspecies name if available, but may be the highest taxonomic level

field_identified_taxonomy_dim$order_40

CC ID: 377894
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

order name

drop_longitude_dim$longitude_minute_units

CC ID: 377895
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of longitude that makes up the minute unit only

Unit of Measure: min
Allowed Values: 0-59

best_available_taxonomy_dim$grp_nonstandard_taxon_99

CC ID: 377896
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

a pseudo taxonomic level that has a common usage such as Invertebrata, Pisces (Fish). This has been designed to allow for only one level of para- or poly-phyletic group that is the terminus of the definition (it may be associated with a higher level taxonomic hierarchy). Consequently a definition such as Fish->Roundfish would not be supported with this design

most_recent_taxonomy_update_date_dim$year

CC ID: 377897
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of year

Allowed Values: 1978+

most_recent_taxonomy_update_date_dim$month_of_year

CC ID: 377898
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of month of year

Allowed Values: 1-12

best_available_taxonomy_dim$subphylum_22

CC ID: 377899
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

subphylum name

year

CC ID: 377900
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

operation year

Unit of Measure: year
Allowed Values: 2007+

field_identified_taxonomy_dim$tribe_60

CC ID: 377901
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

tribe name

best_available_taxonomy_dim$order_40

CC ID: 377902
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

order name

operation_dim$operation_end_time_whid

CC ID: 377903
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

end time reference for the operation

tow

CC ID: 377904
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

operation number of the survey

common_name

CC ID: 377905
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

only one broadly used common name is supported by this design. If the common name is not fairly universally used or is used by more than one taxon this should be left null

field_identified_taxonomy_dim$superclass_28

CC ID: 377906
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

superclass name

site_dim$cowcod_conservation_area_indicator

CC ID: 377907
Data Storage Type: varchar
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

indicates if site falls within the cowcod conservation area

Allowed Values: Inside_Cowcod_Conservancy_Area, Outside_Cowcod_Conservancy_Area.

best_available_taxonomy_dim$subclass_32

CC ID: 377908
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

subclass name

project

CC ID: 377909
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

project name

Allowed Values: Groundfish Shelf Survey, Groundfish Slope and Shelf Combination Survery, Groundfish Slope Survey, Groundfish Triennial Shelf Survery, Hypoxia Study, Santa Barbara Basin Study, Shelf Rockfish [2004-2015], Video Study

field_identified_taxonomy_dim$subclass_32

CC ID: 377910
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

subclass name

site_dim$tide_station_noaa_id

CC ID: 377911
Data Storage Type: varchar
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

tide station id according to NOAA's Tides and Currents site

pass

CC ID: 377912
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

pass number of the survey

Allowed Values: 1,2,3,4

length_cm

CC ID: 377913
Data Storage Type: numeric
Max Length: 4
Required: No
Primary Key: No
Precision: 1
Status: Active
Description:

Individual length in centimeters

inclusion_dim$record_type

CC ID: 377914
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

inclusion record or reason record is unavailable

Allowed Values: Inclusion, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

best_available_taxonomy_dim$species_80

CC ID: 377915
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

species name

best_available_taxonomy_dim$structure_source

CC ID: 377916
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Source of the taxonomic structure

Unit of Measure: unspecified
Allowed Values: Any

drop_latitude_dim$latitude_in_degree_minute_second

CC ID: 377917
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

string representation of latitude in degrees, minutes, and seconds for example 4525'01"

Unit of Measure: NA
Allowed Values: any

operation_dim$limited_entry_permit_number

CC ID: 377918
Data Storage Type: bpchar
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

federal limited entry groundfish permit issued to fish in waters off of Washington, Oregon, and California

angler_person_dim$middle_initial

CC ID: 377919
Data Storage Type: bpchar
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

middle initial of person

operation_dim$departure_date_whid

CC ID: 377920
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

date reference that vessel departed for the defined leg or trip

site_dim$cdfgblock

CC ID: 377921
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

CDFG Block Numbers that the sites fall within

most_recent_taxonomy_update_date_dim$record_type

CC ID: 377922
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

date, month, or year record or reason record is unavailable

Allowed Values: Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

net_liftoff_time

CC ID: 377923
Data Storage Type: time
Required: No
Primary Key: No
Status: Active
Description:

military time representation of the time

angler_person_dim$last_name

CC ID: 377924
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

last name of person

drop_time_dim$time

CC ID: 377925
Data Storage Type: time
Required: No
Primary Key: No
Status: Active
Description:

military time representation of the time

field_identified_taxonomy_dim$suborder_42

CC ID: 377926
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

suborder name

date_dim$month_name

CC ID: 377927
Data Storage Type: varchar
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

text representation of month

Allowed Values: January, February, March, April, May, June, July, August, September, October, November, December

drop_longitude_dim$longitude_in_degree_minute_second

CC ID: 377928
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

string representation of longitude in degrees, minutes, and seconds for example 4525'01"

field_identified_taxonomy_dim$class_30

CC ID: 377929
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

class name

inclusion_dim$site_inclusion_indicator

CC ID: 377930
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

indicates if site should be included

Allowed Values: Include Site, Do Not Include Site, NA

field_identified_taxonomy_dim$species_80

CC ID: 377931
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

species name

drop_latitude_dim$latitude_degree_units

CC ID: 377932
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of latitude that makes up the degree unit only

Unit of Measure: deg
Allowed Values: -90 to 90

Catalog Details

Catalog Item ID: 36441
GUID: gov.noaa.nmfs.inport:36441
Metadata Record Created By: Jeffrey W Cowen
Metadata Record Created: 2017-01-25 13:18+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2017-02-13
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2018-02-14