Slide Menu
System Maintenance Notice, Sunday, January 23, 2022 @ 8am-2pm Eastern. The Operations Team will be performing system maintenance on all server environments. During this scheduled downtime, InPort will not be available.
View All
Search Help Show/Hide Menu

Item Identification

Title: catch_hooknline_view

Entity Information

Entity Type: Data View
Description:

Detail and aggregate catch data given a date at a site and species caught

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
vessel varchar name of the vessel used for the operation
100
best_available_taxonomy_dim$structure_source varchar Source of the taxonomic structure
100
ctd_drop_time_dim$hour int2 standard representation of the hour
100
net_touchdown_time time military time representation of the time
100
site_dim$distance_to_port_nm numeric distance from site to nearest port in nautical miles
100
best_available_taxonomy_dim$genus_70 varchar genus name
100
ctd_drop_latitude_whid int4 warehouse identifier for CTD drop latitude
100
species_category varchar upper-level taxonomic ranking
100
best_available_taxonomy_dim$subfamily_52 varchar subfamily name
100
scientist_1_person_dim$full_name varchar full name in format of First and Last (Suffix)
100
ctd_on_bottom_measure_depth_dim$record_type varchar depth record or reason record is unavailable
100
sampling_end_time_dim$period bpchar period of time
100
fpc_person_whid int4 warehouse identifier for the FPC
100
site_dim$site_number int4 site identifier number
100
best_available_taxonomy_dim$itis_taxonomic_serial_no int4 ITIS taxonomic identifier
100
scientist_2_person_whid int4 warehouse identifier for the second scientist
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
date_dim$record_type varchar date, month, or year record or reason record is unavailable
100
tide_height_last_ft numeric tide height at last (fifth) drop for a site measured in feet
100
captain_person_dim$first_name varchar first name of person
100
ctd_drop_latitude_dim$latitude_compass_direction bpchar latitude compass direction
100
best_available_taxonomy_dim$superfamily_48 varchar superfamily name
100
departure_port_dim$state_abbrev bpchar two letter state abbreviation
100
departure_port_dim$state_name varchar state name
100
ctd_drop_longitude_dim$longitude_minute_units int2 numeric representation of longitude that makes up the minute unit only
100
marine_reserve_indicator varchar identifier if the hook was inside a marine reserve
100
best_available_taxonomy_dim$acoustics_species_id int4 Species ID used in the acoustics program
100
best_available_taxonomy_dim$worms_aphiaid int4 WoRMS taxonomic identifier
100
scientist_1_person_whid int4 warehouse identifier for the first scientist
100
ctd_on_bottom_measure_depth_whid int4 warehouse identifier for CTD on bottom measure depth
100
ctd_on_bottom_measure_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
fpc_person_dim$role varchar role taken during an operation
100
operation_type varchar type of operation
100
captain_person_dim$last_name varchar last name of person
100
fpc_person_dim$last_name varchar last name of person
100
total_catch_numbers int8 a count off the number of species caught at a site
100
scientist_2_person_dim$full_name varchar full name in format of First and Last (Suffix)
100
sunrise_time_dim$minute int2 number of minutes in the hour
100
site_dim$tide_station_latitude_whid int4 warehouse identifier to latitude details for site's nearest tide station
100
return_port_dim$state_abbrev bpchar two letter state abbreviation
100
departure_port_dim$port_group_name varchar port group name for observer program
100
fpc_person_dim$record_type varchar person record or reason record is unavailable
100
best_available_taxonomy_dim$record_type varchar record or reason record is unavailable
100
sunrise_time_dim$hour int2 standard representation of the hour
100
departure_port_whid int4 warehouse identifier for the departure port
100
ctd_sounder_depth_dim$record_type varchar depth record or reason record is unavailable
100
best_available_taxonomy_dim$family_50 varchar family name
100
set_identifier varchar set identifier
100
departure_port_dim$port_code bpchar port code for observer program
100
best_available_taxonomy_dim$kingdom_10 varchar kingdom name
100
best_available_taxonomy_dim$class_30 varchar class name
100
sampling_start_hhmmss bpchar concatenation of military hour, minute, second, example 230415 equates to 23:04:15
100
sampling_start_time_dim$military_hour int2 military representation of the hour
100
departure_port_dim$port_name_caps varchar port name in all capitals format
100
pacfin_spid varchar pacfin species id - many taxa may not have one of these
100
leg int2 leg number for the survey
100
return_port_dim$record_type varchar port record or reason record is unavailable
100
return_port_dim$state_name varchar state name
100
ctd_on_bottom_measure_depth_dim$depth_meters numeric depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries)
100
ctd_on_bottom_salinity_psu numeric CTD on bottom salinity in practical salinity units (psu)
100
best_available_taxonomy_dim$observer_species_id int4 species identifier used by the observer program
100
scientist_2_person_dim$last_name varchar last name of person
100
sunrise_time_dim$record_type varchar time record or reason record is unavailable
100
sampling_end_time_dim$record_type varchar time record or reason record is unavailable
100
scientist_2_person_dim$record_type varchar person record or reason record is unavailable
100
departure_port_dim$record_type varchar port record or reason record is unavailable
100
sampling_start_time_dim$second int2 number of seconds in the minute
100
scientist_2_person_dim$middle_initial bpchar middle initial of person
100
tide_height_mid_ft numeric tide height at middle (third) drop for a site measured in feet
100
tide_height_mid_m numeric tide height at middle (third) drop for a site measured in meters
100
sunset_time_dim$second int2 number of seconds in the minute
100
captain_person_dim$middle_initial bpchar middle initial of person
100
site_general_note varchar site general notes
100
captain_person_dim$role varchar role taken during an operation
100
ctd_sounder_depth_dim$boundary_indicator varchar depth boundry indicator identifying ifp boundary marks
100
sampling_end_time_whid int4 warehouse identifier for the sampling end time
100
ctd_drop_longitude_dim$longitude_compass_direction bpchar longitude compass direction
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
ctd_drop_time_whid int4 warehouse identifier for CTD drop time
100
site_dim$inactive_date_whid int8 warehouse identifier for the date when the site went inactive
100
scientist_2_person_dim$role varchar role taken during an operation
100
tide_height_first_m numeric tide height at first drop for a site measured in meters
100
return_port_dim$port_name_std varchar port name in standard format
100
ctd_drop_time_dim$minute int2 number of minutes in the hour
100
best_available_taxonomy_dim$superorder_38 varchar superorder name
100
sunrise_time_whid int4 Warehouse identifier for the sunrise time
100
best_available_taxonomy_dim$hookandline_species_id int4 species identifier used by hook and line
100
return_port_dim$port_group_code bpchar port group code for observer program
100
species_subcategory varchar mid-level taxonomic ranking
100
site_dim$cdfgblock int4 CDFG Block Numbers that the sites fall within
100
date_dim$month_name varchar text representation of month
100
sunrise_time_dim$military_hour int2 military representation of the hour
100
site_dim$area_name varchar name of area site is located in
100
date_dim$full_date timestamp full date value
100
swell_direction_mag int2 swell direction in magnetic degrees
100
site_dim$cowcod_conservation_area_indicator varchar indicates if site falls within the cowcod conservation area
100
fpc_person_dim$full_name varchar full name in format of First and Last (Suffix)
100
sampling_end_time_dim$military_hour int2 military representation of the hour
100
ctd_drop_latitude_dd numeric high precision value for CTD drop latitude in decimal degrees
100
ctd_drop_longitude_dim$longitude_second_units int2 numeric representation of longitude that makes up the second unit only
100
sunset_time_dim$period bpchar period of time
100
best_available_taxonomy_dim$phylum_20 varchar phylum name
100
best_available_taxonomy_dim$suborder_42 varchar suborder name
100
net_liftoff_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
ctd_drop_longitude_dim$record_type varchar longitude record type or reason record is unavailable
100
cpue_normalized_catch_numbers numeric a derived number of species caught at a site based off the number of valid hooks deployed at the site
100
best_available_taxonomy_dim$tribe_60 varchar tribe name
100
vessel_id int2 field database vessel id number
100
site_dim$site_longitude_dd numeric site longitude in decimal degrees
100
best_available_taxonomy_dim$subclass_32 varchar subclass name
100
sunset_time_dim$time time military time representation of the time
100
sampling_start_time_dim$hour int2 standard representation of the hour
100
ctd_drop_latitude_dim$record_type varchar latitude record type or reason record is unavailable
100
scientist_1_person_dim$role varchar role taken during an operation
100
departure_port_dim$port_group_code bpchar port group code for observer program
100
scientist_1_person_dim$middle_initial bpchar middle initial of person
100
site_whid int4 warehouse identifier to the site details
100
captain_person_whid int4 warehouse identifier for the vessel captain
100
best_available_taxonomy_dim$order_40 varchar order name
100
sunrise_time_dim$second int2 number of seconds in the minute
100
ctd_sounder_depth_m numeric CTD sounder depth in meters
100
date_dim$month_abbrev bpchar three character representation of month in capital letters
100
ctd_drop_longitude_whid int4 warehouse identifier for CTD drop longitude
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
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_start_time_dim$period bpchar period of time
100
site_ocean_weather_note varchar site's ocean and weather notes
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
total_catch_wt_kg numeric a sum of the measured weights of a species caught at a site
100
swell_height_ft numeric swell height in feet
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
100
scientist_1_person_dim$last_name varchar last name of person
100
site_dim$record_type varchar site record or reason record is unavailable
100
return_port_whid int4 warehouse identifier for return port
100
swell_height_m numeric swell height in meters
100
ctd_on_bottom_temp_c numeric CTD on bottom temperature in degrees celcius
100
date_dim$day_of_month int2 numeric representation of the day in month
100
sea_surface_temp_c numeric sea surface temperature in degrees celcius
100
departure_port_dim$port_name_std varchar port name in standard format
100
ctd_drop_time_dim$period bpchar period of time
100
fish_info_note varchar overall fish information note
100
date_yyyymmdd bpchar text representation of year month day
100
ctd_drop_latitude_dim$named_parallel varchar name of parallel, boundary, or commonly used geograpical location
100
site_moon_tide_dim$tide_type varchar tide type
100
date_dim$year int4 numeric representation of year
100
site_valid_hooks int8 a count of the number of valid hooks deployed at a site
100
ctd_on_bottom_measure_depth_dim$boundary_indicator varchar depth boundry indicator identifying ifp boundary marks
100
sunrise_time_dim$time time military time representation of the time
100
ctd_drop_latitude_dim$latitude_degree_units int2 numeric representation of latitude that makes up the degree unit only
100
fpc_person_dim$middle_initial bpchar middle initial of person
100
project_name varchar project name
100
ctd_sounder_depth_whid int4 warehouse identifier for CTD sounder depth
100
fram_program varchar type of fram program
100
sampling_end_time_dim$hour int2 standard representation of the hour
100
site_dim$tide_station_name varchar name of nearest tide station
100
scientist_2_person_dim$nick_name varchar nickname of person
100
sunset_time_dim$record_type varchar time record or reason record is unavailable
100
ctd_drop_time_dim$time time military time representation of the time
100
taxon_rank varchar name of the lowest taxonomic level used to define scientific name
100
ctd_on_bottom_disolved_oxygen_sbe43_ml_per_l numeric CTD SBE43 sensor on bottom disolved oxygen measured in milliliters per liter
100
fpc_person_dim$first_name varchar first name of person
100
site_habitat_note varchar site habitat notes
100
scientist_1_person_dim$first_name varchar first name of person
100
ctd_on_bottom_disolved_oxygen_aanderaa_ml_per_l numeric CTD aanderaa sensor on bottom disolved oxygen measured in milliliters per liter
100
fpc_person_dim$nick_name varchar nickname of person
100
best_available_taxonomy_dim$superclass_28 varchar superclass name
100
ctd_drop_longitude_dim$longitude_in_degrees numeric numeric representation of longitude in decimal degrees
100
ctd_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_whid int4 warehouse identifier to longitude details for site
100
ctd_drop_time_dim$second int2 number of seconds in the minute
100
best_available_taxonomy_dim$infraclass_34 varchar infraclass name
100
best_available_taxonomy_dim$pacfin_nom_spid varchar PacFIN nominal species identifier
100
best_available_taxonomy_dim$subphylum_22 varchar subphylum name
100
scientist_1_person_dim$record_type varchar person record or reason record is unavailable
100
sampling_end_time_dim$minute int2 number of minutes in the hour
100
tide_height_last_m numeric tide height at last (fifth) drop for a site measured in meters
100
ctd_drop_time_dim$hh24miss bpchar concatenation of military hour, minute, second, example 230415 equates to 23:04:15
100
best_available_taxonomy_whid int4 warehouse identifier to best available taxonomy
100
ctd_drop_time_dim$military_hour int2 military representation of the hour
100
best_available_taxonomy_dim$trawl_survey_species_id int4 species identifier used by the trawl survey
100
wave_height_ft numeric wave height in feet
100
ctd_drop_longitude_dim$longitude_in_degree_minute_second varchar string representation of longitude in degrees, minutes, and seconds for example 4525'01"
100
scientist_1_person_dim$nick_name varchar nickname of person
100
best_available_taxonomy_dim$infraorder_44 varchar infraorder name
100
return_port_dim$port_name_caps varchar port name in all capitals format
100
ctd_drop_time_dim$record_type varchar time record or reason record is unavailable
100
date_whid int8 warehouse identifier for date
100
site_dim$tide_station_noaa_id varchar tide station id according to NOAA's Tides and Currents site
100
sunset_time_dim$military_hour int2 military representation of the hour
100
site_dim$site_latitude_dd numeric site latitude in decimal degrees
100
ctd_drop_longitude_dd numeric high precision value for CTD drop longitude in decimal degrees
100
ctd_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
best_available_taxonomy_dim$species_80 varchar species name
100
tide_height_first_ft numeric tide height at first drop for a site measured in feet
100
date_dim$month_of_year int2 numeric representation of month of year
100
sunset_time_whid int4 warehouse identifier for the sunset time
100
sampling_end_time_dim$second int2 number of seconds in the minute
100
sunrise_time_dim$hh24miss bpchar concatenation of military hour, minute, second, example 230415 equates to 23:04:15
100
sunset_time_dim$hour int2 standard representation of the hour
100
sampling_start_time_dim$record_type varchar time record or reason record is unavailable
100
sunset_time_dim$minute int2 number of minutes in the hour
100
ctd_drop_latitude_dim$latitude_in_degrees numeric numeric representation of latitude in degrees
100
site_dim$site_latitude_whid int4 warehouse identifier to latitude details for site
100
captain_person_dim$nick_name varchar nickname of person
100
sunset_time_dim$hh24miss bpchar concatenation of military hour, minute, second, example 230415 equates to 23:04:15
100
return_port_dim$port_code bpchar port code for observer program
100
site_moon_tide_dim$tide_phase varchar tide phase
100
sunrise_time_dim$period bpchar period of time
100
return_port_dim$port_group_name varchar port group name for observer program
100
ctd_drop_latitude_dim$latitude_second_units int2 numeric representation of latitude that makes up the second unit only
100
sampling_start_time_dim$minute int2 number of minutes in the hour
100
ctd_on_bottom_measure_depth_m numeric CTD on bottom measured depth in meters
100
scientist_2_person_dim$first_name varchar first name of person
100
best_available_taxonomy_dim$subspecies_82 varchar subspecies name
100
captain_person_dim$record_type varchar person record or reason record is unavailable
100
ctd_drop_latitude_dim$latitude_minute_units int2 numeric representation of latitude that makes up the minute unit only
100
site_dim$tide_station_longitude_whid int4 warehouse identifier to longitude details for site's nearest tide station
100
captain_person_dim$full_name varchar full name in format of First and Last (Suffix)
100
site_moon_tide_whid int2 warehouse identifier for site moon tide
100
site_moon_tide_dim$moon_phase varchar moon phase
100
wave_height_m numeric wave height in meters
100
ctd_drop_longitude_dim$longitude_degree_units int2 numeric representation of longitude that makes up the degree unit only
100
site_fish_finder_note varchar site fish finder notes
100
ctd_drop_latitude_dim$latitude_in_degree_minute_second varchar string representation of latitude in degrees, minutes, and seconds for example 4525'01"
100
site_moon_tide_dim$record_type varchar moon tide record or reason record is unavailable
100
sampling_start_time_whid int4 warehouse identifier for the sampling start time
100
full_moon_pct int2 percent of full moon

Attribute Details

vessel

CC ID: 377454
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

best_available_taxonomy_dim$structure_source

CC ID: 377455
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

ctd_drop_time_dim$hour

CC ID: 377456
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

net_touchdown_time

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

military time representation of the time

site_dim$distance_to_port_nm

CC ID: 377458
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

best_available_taxonomy_dim$genus_70

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

genus name

ctd_drop_latitude_whid

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

warehouse identifier for CTD drop latitude

species_category

CC ID: 377461
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

best_available_taxonomy_dim$subfamily_52

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

subfamily name

scientist_1_person_dim$full_name

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

full name in format of First and Last (Suffix)

ctd_on_bottom_measure_depth_dim$record_type

CC ID: 377464
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

sampling_end_time_dim$period

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

period of time

Allowed Values: AM, PM

fpc_person_whid

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

warehouse identifier for the FPC

site_dim$site_number

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

site identifier number

best_available_taxonomy_dim$itis_taxonomic_serial_no

CC ID: 377468
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

scientist_2_person_whid

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

warehouse identifier for the second scientist

best_available_taxonomy_dim$grp_nonstandard_taxon_99

CC ID: 377470
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

date_dim$record_type

CC ID: 377471
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

tide_height_last_ft

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

tide height at last (fifth) drop for a site measured in feet

Unit of Measure: ft

captain_person_dim$first_name

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

first name of person

ctd_drop_latitude_dim$latitude_compass_direction

CC ID: 377474
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

best_available_taxonomy_dim$superfamily_48

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

superfamily name

departure_port_dim$state_abbrev

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

two letter state abbreviation

Allowed Values: AK, CA, OR, WA

departure_port_dim$state_name

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

state name

Allowed Values: Alaska, California, Oregon, Washington

ctd_drop_longitude_dim$longitude_minute_units

CC ID: 377478
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

marine_reserve_indicator

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

identifier if the hook was inside a marine reserve

Allowed Values: Is Marine Reserve, Not Marine Reserve, NA

best_available_taxonomy_dim$acoustics_species_id

CC ID: 377480
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

best_available_taxonomy_dim$worms_aphiaid

CC ID: 377481
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

scientist_1_person_whid

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

warehouse identifier for the first scientist

ctd_on_bottom_measure_depth_whid

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

warehouse identifier for CTD on bottom measure depth

ctd_on_bottom_measure_depth_dim$depth_fathoms

CC ID: 377484
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

fpc_person_dim$role

CC ID: 377485
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

operation_type

CC ID: 377486
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

captain_person_dim$last_name

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

last name of person

fpc_person_dim$last_name

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

last name of person

total_catch_numbers

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

a count off the number of species caught at a site

scientist_2_person_dim$full_name

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

full name in format of First and Last (Suffix)

sunrise_time_dim$minute

CC ID: 377491
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

site_dim$tide_station_latitude_whid

CC ID: 377492
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

return_port_dim$state_abbrev

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

two letter state abbreviation

Allowed Values: AK, CA, OR, WA

departure_port_dim$port_group_name

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

port group name for observer program

fpc_person_dim$record_type

CC ID: 377495
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

best_available_taxonomy_dim$record_type

CC ID: 377496
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

sunrise_time_dim$hour

CC ID: 377497
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

departure_port_whid

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

warehouse identifier for the departure port

ctd_sounder_depth_dim$record_type

CC ID: 377499
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

best_available_taxonomy_dim$family_50

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

family name

set_identifier

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

set identifier

departure_port_dim$port_code

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

port code for observer program

best_available_taxonomy_dim$kingdom_10

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

kingdom name

best_available_taxonomy_dim$class_30

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

class name

sampling_start_hhmmss

CC ID: 377505
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

sampling_start_time_dim$military_hour

CC ID: 377506
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

departure_port_dim$port_name_caps

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

port name in all capitals format

pacfin_spid

CC ID: 377508
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

leg

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

leg number for the survey

return_port_dim$record_type

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

port record or reason record is unavailable

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

return_port_dim$state_name

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

state name

Allowed Values: Alaska, California, Oregon, Washington

ctd_on_bottom_measure_depth_dim$depth_meters

CC ID: 377512
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

ctd_on_bottom_salinity_psu

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

CTD on bottom salinity in practical salinity units (psu)

Unit of Measure: psu

best_available_taxonomy_dim$observer_species_id

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

species identifier used by the observer program

scientist_2_person_dim$last_name

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

last name of person

sunrise_time_dim$record_type

CC ID: 377516
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

sampling_end_time_dim$record_type

CC ID: 377517
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

scientist_2_person_dim$record_type

CC ID: 377518
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

departure_port_dim$record_type

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

port record or reason record is unavailable

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

sampling_start_time_dim$second

CC ID: 377520
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

scientist_2_person_dim$middle_initial

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

middle initial of person

tide_height_mid_ft

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

tide height at middle (third) drop for a site measured in feet

Unit of Measure: ft

tide_height_mid_m

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

tide height at middle (third) drop for a site measured in meters

Unit of Measure: m

sunset_time_dim$second

CC ID: 377524
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

captain_person_dim$middle_initial

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

middle initial of person

site_general_note

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

site general notes

captain_person_dim$role

CC ID: 377527
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

ctd_sounder_depth_dim$boundary_indicator

CC ID: 377528
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

sampling_end_time_whid

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

warehouse identifier for the sampling end time

ctd_drop_longitude_dim$longitude_compass_direction

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

longitude compass direction

Allowed Values: E, W

best_available_taxonomy_dim$abbreviated_name

CC ID: 377531
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

ctd_drop_time_whid

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

warehouse identifier for CTD drop time

site_dim$inactive_date_whid

CC ID: 377533
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

scientist_2_person_dim$role

CC ID: 377534
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

tide_height_first_m

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

tide height at first drop for a site measured in meters

Unit of Measure: m

return_port_dim$port_name_std

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

port name in standard format

ctd_drop_time_dim$minute

CC ID: 377537
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

best_available_taxonomy_dim$superorder_38

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

superorder name

sunrise_time_whid

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

Warehouse identifier for the sunrise time

best_available_taxonomy_dim$hookandline_species_id

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

species identifier used by hook and line

return_port_dim$port_group_code

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

port group code for observer program

Allowed Values: AK, AT, BB, CA, CB, CC, EA, FB, LA, MB, MT, NB, NP, SB, SF

species_subcategory

CC ID: 377542
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

site_dim$cdfgblock

CC ID: 377543
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

date_dim$month_name

CC ID: 377544
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

sunrise_time_dim$military_hour

CC ID: 377545
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

site_dim$area_name

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

name of area site is located in

date_dim$full_date

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

full date value

swell_direction_mag

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

swell direction in magnetic degrees

Unit of Measure: mag

site_dim$cowcod_conservation_area_indicator

CC ID: 377549
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.

fpc_person_dim$full_name

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

full name in format of First and Last (Suffix)

sampling_end_time_dim$military_hour

CC ID: 377551
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

ctd_drop_latitude_dd

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

high precision value for CTD drop latitude in decimal degrees

Unit of Measure: dd

ctd_drop_longitude_dim$longitude_second_units

CC ID: 377553
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

sunset_time_dim$period

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

period of time

Allowed Values: AM, PM

best_available_taxonomy_dim$phylum_20

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

phylum name

best_available_taxonomy_dim$suborder_42

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

suborder name

net_liftoff_time

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

military time representation of the time

sampling_end_hhmmss

CC ID: 377558
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

ctd_drop_longitude_dim$record_type

CC ID: 377559
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

cpue_normalized_catch_numbers

CC ID: 377560
Data Storage Type: numeric
Required: No
Primary Key: No
Status: Active
Description:

a derived number of species caught at a site based off the number of valid hooks deployed at the site

best_available_taxonomy_dim$tribe_60

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

tribe name

vessel_id

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

field database vessel id number

site_dim$site_longitude_dd

CC ID: 377563
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

best_available_taxonomy_dim$subclass_32

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

subclass name

sunset_time_dim$time

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

military time representation of the time

sampling_start_time_dim$hour

CC ID: 377566
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

ctd_drop_latitude_dim$record_type

CC ID: 377567
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

scientist_1_person_dim$role

CC ID: 377568
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

departure_port_dim$port_group_code

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

port group code for observer program

Allowed Values: AK, AT, BB, CA, CB, CC, EA, FB, LA, MB, MT, NB, NP, SB, SF

scientist_1_person_dim$middle_initial

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

middle initial of person

site_whid

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

warehouse identifier to the site details

captain_person_whid

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

warehouse identifier for the vessel captain

best_available_taxonomy_dim$order_40

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

order name

sunrise_time_dim$second

CC ID: 377574
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

ctd_sounder_depth_m

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

CTD sounder depth in meters

Unit of Measure: m

date_dim$month_abbrev

CC ID: 377576
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

ctd_drop_longitude_whid

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

warehouse identifier for CTD drop longitude

common_name

CC ID: 377578
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

scientific_name

CC ID: 377579
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_start_time_dim$period

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

period of time

Allowed Values: AM, PM

site_ocean_weather_note

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

site's ocean and weather notes

best_available_taxonomy_dim$norpac_species_id

CC ID: 377582
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

total_catch_wt_kg

CC ID: 377583
Data Storage Type: numeric
Required: No
Primary Key: No
Status: Active
Description:

a sum of the measured weights of a species caught at a site

Unit of Measure: kg

swell_height_ft

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

swell height in feet

Unit of Measure: ft

best_available_taxonomy_dim$grp_reg_depth_category

CC ID: 377585
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

scientist_1_person_dim$last_name

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

last name of person

site_dim$record_type

CC ID: 377587
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

return_port_whid

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

warehouse identifier for return port

swell_height_m

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

swell height in meters

Unit of Measure: m

ctd_on_bottom_temp_c

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

CTD on bottom temperature in degrees celcius

Unit of Measure: c

date_dim$day_of_month

CC ID: 377591
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

sea_surface_temp_c

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

sea surface temperature in degrees celcius

Unit of Measure: c

departure_port_dim$port_name_std

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

port name in standard format

ctd_drop_time_dim$period

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

period of time

Allowed Values: AM, PM

fish_info_note

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

overall fish information note

date_yyyymmdd

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

text representation of year month day

ctd_drop_latitude_dim$named_parallel

CC ID: 377597
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

site_moon_tide_dim$tide_type

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

tide type

Allowed Values: Spring, Neap, Neither

date_dim$year

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

numeric representation of year

Allowed Values: 1978+

site_valid_hooks

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

a count of the number of valid hooks deployed at a site

ctd_on_bottom_measure_depth_dim$boundary_indicator

CC ID: 377601
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

sunrise_time_dim$time

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

military time representation of the time

ctd_drop_latitude_dim$latitude_degree_units

CC ID: 377603
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

fpc_person_dim$middle_initial

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

middle initial of person

project_name

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

project name

ctd_sounder_depth_whid

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

warehouse identifier for CTD sounder depth

fram_program

CC ID: 377607
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

sampling_end_time_dim$hour

CC ID: 377608
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

site_dim$tide_station_name

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

name of nearest tide station

scientist_2_person_dim$nick_name

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

nickname of person

sunset_time_dim$record_type

CC ID: 377611
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

ctd_drop_time_dim$time

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

military time representation of the time

taxon_rank

CC ID: 377613
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

ctd_on_bottom_disolved_oxygen_sbe43_ml_per_l

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

CTD SBE43 sensor on bottom disolved oxygen measured in milliliters per liter

Unit of Measure: ml/l

fpc_person_dim$first_name

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

first name of person

site_habitat_note

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

site habitat notes

scientist_1_person_dim$first_name

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

first name of person

ctd_on_bottom_disolved_oxygen_aanderaa_ml_per_l

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

CTD aanderaa sensor on bottom disolved oxygen measured in milliliters per liter

Unit of Measure: ml/l

fpc_person_dim$nick_name

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

nickname of person

best_available_taxonomy_dim$superclass_28

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

superclass name

ctd_drop_longitude_dim$longitude_in_degrees

CC ID: 377621
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

ctd_sounder_depth_dim$depth_meters

CC ID: 377622
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_whid

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

warehouse identifier to longitude details for site

ctd_drop_time_dim$second

CC ID: 377624
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$infraclass_34

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

infraclass name

best_available_taxonomy_dim$pacfin_nom_spid

CC ID: 377626
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

best_available_taxonomy_dim$subphylum_22

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

subphylum name

scientist_1_person_dim$record_type

CC ID: 377628
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

sampling_end_time_dim$minute

CC ID: 377629
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

tide_height_last_m

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

tide height at last (fifth) drop for a site measured in meters

Unit of Measure: m

ctd_drop_time_dim$hh24miss

CC ID: 377631
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

best_available_taxonomy_whid

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

warehouse identifier to best available taxonomy

ctd_drop_time_dim$military_hour

CC ID: 377633
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

best_available_taxonomy_dim$trawl_survey_species_id

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

species identifier used by the trawl survey

wave_height_ft

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

wave height in feet

Unit of Measure: ft

ctd_drop_longitude_dim$longitude_in_degree_minute_second

CC ID: 377636
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"

scientist_1_person_dim$nick_name

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

nickname of person

best_available_taxonomy_dim$infraorder_44

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

infraorder name

return_port_dim$port_name_caps

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

port name in all capitals format

ctd_drop_time_dim$record_type

CC ID: 377640
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

date_whid

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

warehouse identifier for date

site_dim$tide_station_noaa_id

CC ID: 377642
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

sunset_time_dim$military_hour

CC ID: 377643
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

site_dim$site_latitude_dd

CC ID: 377644
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

ctd_drop_longitude_dd

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

high precision value for CTD drop longitude in decimal degrees

Unit of Measure: dd

ctd_sounder_depth_dim$depth_fathoms

CC ID: 377646
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

best_available_taxonomy_dim$species_80

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

species name

tide_height_first_ft

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

tide height at first drop for a site measured in feet

Unit of Measure: ft

date_dim$month_of_year

CC ID: 377649
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

sunset_time_whid

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

warehouse identifier for the sunset time

sampling_end_time_dim$second

CC ID: 377651
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

sunrise_time_dim$hh24miss

CC ID: 377652
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

sunset_time_dim$hour

CC ID: 377653
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$record_type

CC ID: 377654
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

sunset_time_dim$minute

CC ID: 377655
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

ctd_drop_latitude_dim$latitude_in_degrees

CC ID: 377656
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

site_dim$site_latitude_whid

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

warehouse identifier to latitude details for site

captain_person_dim$nick_name

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

nickname of person

sunset_time_dim$hh24miss

CC ID: 377659
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

return_port_dim$port_code

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

port code for observer program

site_moon_tide_dim$tide_phase

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

tide phase

Allowed Values: Ebb, Flood, Steady

sunrise_time_dim$period

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

period of time

Allowed Values: AM, PM

return_port_dim$port_group_name

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

port group name for observer program

ctd_drop_latitude_dim$latitude_second_units

CC ID: 377664
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

sampling_start_time_dim$minute

CC ID: 377665
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

ctd_on_bottom_measure_depth_m

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

CTD on bottom measured depth in meters

Unit of Measure: m

scientist_2_person_dim$first_name

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

first name of person

best_available_taxonomy_dim$subspecies_82

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

subspecies name

captain_person_dim$record_type

CC ID: 377669
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

ctd_drop_latitude_dim$latitude_minute_units

CC ID: 377670
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

site_dim$tide_station_longitude_whid

CC ID: 377671
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

captain_person_dim$full_name

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

full name in format of First and Last (Suffix)

site_moon_tide_whid

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

warehouse identifier for site moon tide

site_moon_tide_dim$moon_phase

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

moon phase

Allowed Values: New Moon, Waxing Crescent, First Quarter, Waxing Gibbous, Waning Gibbous, Third Quarter, Waning Crescent, Full Moon

wave_height_m

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

wave height in meters

Unit of Measure: m

ctd_drop_longitude_dim$longitude_degree_units

CC ID: 377676
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

site_fish_finder_note

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

site fish finder notes

ctd_drop_latitude_dim$latitude_in_degree_minute_second

CC ID: 377678
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

site_moon_tide_dim$record_type

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

moon tide record or reason record is unavailable

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

sampling_start_time_whid

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

warehouse identifier for the sampling start time

full_moon_pct

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

percent of full moon

Catalog Details

Catalog Item ID: 36440
GUID: gov.noaa.nmfs.inport:36440
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