catch_fact

Northwest Fisheries Science Center
Entity (ENT) | ID: 36437 | Published / External
Created: 2017-01-25   |   Last Modified: 2022-08-09

Parent: West Coast Groundfish Bottom Trawl Survey Data - 2020 West Coast Groundfish Bottom Trawl Survey and indices of abundance
Data Set (DS) | ID: 18418

ID: 36437
Entity (ENT)

* Discovery
• First Pass
» Metadata Rubric

Item Identification

* » Title catch_fact
Short Name  
* Status  
Creation Date  
Revision Date  
• Publication Date  
* » Abstract
* Purpose
Notes
Other Citation Details
• Supplemental Information
DOI (Digital Object Identifier)  
DOI Registration Authority  
DOI Issue Date  

Keywords

Theme Keywords

Thesaurus Keyword
   
   
   

Temporal Keywords

Thesaurus Keyword
   
   
   

* Spatial Keywords

Thesaurus Keyword
   
   
   

Stratum Keywords

Thesaurus Keyword
   
   
   

Instrument Keywords

Thesaurus Keyword
   
   
   

Platform Keywords

Thesaurus Keyword
   
   
   

Physical Location

• » Organization  
• » City  
• » State/Province  
• Country  
• » Location Description

Entity Information

Entity Type Data Table
Active Version?  
Alias  
Schema Name  
» Description

Catch data from bottom trawl survey
Change Summary

Data Attributes

Attribute Summary

Score Req'd? PKey? » Name Data Storage Type Description
100 No No vessel varchar name of the vessel used for the operation
100 No No target_station_design_dim$station_design_name varchar name of the design for a collection of stations
100 No No best_available_taxonomy_dim$structure_source varchar Source of the taxonomic structure
100 No No min_depth_m numeric high precision value of minimum depth measured in meters
100 No No actual_station_design_dim$min_depth_whid int4 minimum depth warehouse identifier
100 No No net_touchdown_time time military time representation of the time
100 No No species_category varchar upper-level taxonomic ranking
100 No No year_stn_invalid int2 Survey year the station became invalid for trawl
100 No No best_available_taxonomy_dim$subfamily_52 varchar subfamily name
100 No No sampling_end_time_dim$period bpchar period of time
100 No No actual_station_design_dim$centroid_id numeric eight character code representing a unique identifier for a grid cell that is composed of a truncated latitude and longitude central to the cell. For example, 46252413 represents latitude 46 degrees 25 minutes and longitude -124 degrees and 13 minutes. The grid cells are small enough that 8 characters captures uniqueness. Note that these are NOT technically or mathematically centroids of the polygons.
100 No No 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 No No field_identified_taxonomy_dim$subphylum_22 varchar subphylum name
100 No No actual_station_design_dim$station_code varchar unique identifier for a station definition
100 No No catch_id int8 unique(legacy) identifier for the catch from a haul, sorted to taxonomic group or debris type.
100 No No best_available_taxonomy_dim$itis_taxonomic_serial_no int4 ITIS taxonomic identifier
100 No No field_identified_taxonomy_dim$species_80 varchar species name
100 No No field_identified_taxonomy_dim$subfamily_52 varchar subfamily name
100 No No haul_latitude_dim$record_type varchar latitude record type or reason record is unavailable
100 No No 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 No No operation_dim$limited_entry_permit_number bpchar federal limited entry groundfish permit issued to fish in waters off of Washington, Oregon, and California
100 No No field_identified_taxonomy_dim$superfamily_48 varchar superfamily name
100 No No date_dim$full_date timestamp full date value
100 No No actual_station_design_dim$station_invalid_survey_year int2 Survey year the station became invalid for trawl
100 No No actual_station_design_dim$lower_left_longitude_whid int4 lower left longitude warehouse identifier for a design type of grid
100 No No total_catch_wt_observation_detail_whid int4 warehouse identifier to total catch weight observation details
100 No No target_station_design_dim$transect_station_longitude_whid int4 longitude on transect warehouse identifier for a design type of transect
100 No No best_available_taxonomy_dim$superfamily_48 varchar superfamily name
100 No No field_identified_taxonomy_dim$superclass_28 varchar superclass name
100 No No haul_latitude_dim$latitude_in_degree_minute_second varchar string representation of latitude in degrees, minutes, and seconds for example 4525'01"
100 No No actual_station_design_dim$station_grid_dd polygon collection of vertices of grid points of a grid design measured in decimal degrees
100 No No field_identified_taxonomy_dim$infraclass_34 varchar infraclass name
100 No No best_available_taxonomy_dim$acoustics_species_id int4 Species ID used in the acoustics program
100 No No most_recent_taxon_update timestamp full date value
100 No No operation_dim$scientist_3_person_whid int4 person reference for the third scientist
100 No No target_station_design_dim$lower_left_latitude_whid int4 lower left latitude warehouse identifier for a design type of grid
100 No No actual_station_design_dim$area_hectares numeric station area measured in hectares
100 No No haul_longitude_whid int4 warehouse identifier for haul longitude
100 No No best_available_taxonomy_dim$worms_aphiaid int4 WoRMS taxonomic identifier
100 No No target_station_design_dim$max_depth_whid int4 maximum depth warehouse identifier
100 No No best_available_taxonomy_observation_detail_dim$record_type varchar observation detail record type or reason record is unavailable
100 No No field_identified_taxonomy_dim$order_40 varchar order name
100 No No most_recent_taxonomy_update_date_dim$record_type varchar date, month, or year record or reason record is unavailable
100 No No haul_longitude_dim$longitude_second_units int2 numeric representation of longitude that makes up the second unit only
100 No No actual_station_design_dim$min_latitude_whid int4 minimum latitude warehouse identifier for a design type of transect
100 No No pass int4 pass number of the survey
100 No No actual_station_design_dim$min_depth_m numeric high precision value of minimum depth measured in meters
100 No No station_ul_lat_dd numeric high precision value of upper left latitude of design type grid measured in decimal degrees
100 No No total_catch_numbers int4 numbers expansion for a taxonomic group within a haul.
100 No No max_depth_m numeric high precision value of maximum depth measured in meters
100 No No operation_dim$operation_start_time_whid int8 start time reference for the operation
100 No No best_available_taxonomy_dim$family_50 varchar family name
100 No No field_identified_taxonomy_dim$itis_taxonomic_serial_no int4 ITIS taxonomic identifier
100 No No program varchar type of fram program
100 No No best_available_taxonomy_dim$record_type varchar record or reason record is unavailable
100 No No operation_dim$captain_person_whid int4 person reference for the vessel captain
100 No No total_catch_wt_observation_detail_dim$source_primary varchar name of primary source used to get the measurement
100 No No total_catch_wt_observation_detail_dim$means_of_calculation varchar describes how the measurement was calculated
100 No No actual_station_design_dim$upper_left_latitude_whid int4 upper left latitude warehouse identifier for a design type of grid
100 No No target_station_design_dim$stn_invalid_for_trawl_date_whid int8 station design invalidation date warehouse identifier
100 No No mean_seafloor_dep_boundary varchar depth boundry indicator identifying ifp boundary marks
100 No No field_identified_taxonomy_dim$infraorder_44 varchar infraorder name
100 No No operation_dim$fpc_person_whid int4 person reference for the FPC
100 No No best_available_taxonomy_dim$order_40 varchar order name
100 No No haul_latitude_dim$latitude_second_units int2 numeric representation of latitude that makes up the second unit only
100 No No target_station_design_dim$max_latitude_dd numeric high precision value of maximum latitude measured in decimal degrees
100 No No actual_station_design_dim$upper_left_latitude_dd numeric high precision value of upper left latitude of design type grid measured in decimal degrees
100 No No sampling_start_time_dim$military_hour int2 military representation of the hour
100 No No actual_station_design_dim$station_design_name varchar name of the design for a collection of stations
100 No No pacfin_spid varchar pacfin species id - many taxa may not have one of these
100 No No leg int2 leg number of the survey
100 No No actual_station_design_dim$lower_left_longitude_dd numeric high precision value of lower left longitude of design type grid measured in decimal degrees
100 No No actual_station_design_dim$record_type varchar station design record or reason record is unavailable
100 No No target_station_design_dim$active_polygon_dd polygon collection of vertices of the usuable area inside a station grid measured in decimal degrees
100 No No operation_dim$operation_type varchar type of operation
100 No No subsample_count int4 count of the subsample used for numbers expansion. This is usually either the counted fraction or the subsample that is measured for fish length.
100 No No best_available_taxonomy_dim$observer_species_id int4 species identifier used by the observer program
100 No No reason_stn_invalid varchar reason station was invalidated, multiple reasons are comma separated
100 No No actual_station_design_dim$transect_latitude_dd numeric high precision value of transect latitude measured in decimal degrees
100 No No operation_dim$ifq_account_number varchar unique number assigned to user accounts in the Vessel Accounting Database
100 No No field_identified_taxonomy_dim$hookandline_species_id int4 species identifier used by hook and line
100 No No target_station_design_dim$upper_right_longitude_whid int4 upper right longitude warehouse identifier for a design type of grid
100 No No actual_station_design_dim$min_latitude_dd numeric high precision value of minimum latitude measured in decimal degrees
100 No No station_ll_lat_dd numeric high precision value of lower left latitude of design type grid measured in decimal degrees
100 No No most_recent_taxonomy_update_date_dim$month_of_year int2 numeric representation of month of year
100 No No actual_station_design_dim$upper_right_latitude_whid int4 upper right latitude warehouse identifier for a design type of grid
100 No No operation_dim$operation_end_date_whid int8 end date reference for the operation
100 No No sampling_start_time_dim$second int2 number of seconds in the minute
100 No No 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 No No best_available_taxonomy_dim$superclass_28 varchar superclass name
100 No No total_catch_wt_observation_detail_dim$record_type varchar observation detail record type or reason record is unavailable
100 No No 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 No No best_available_taxonomy_dim$subspecies_82 varchar subspecies name
100 No No sampling_end_time_whid int8 warehouse identifier for the sampling end time
100 No No actual_station_design_dim$transect_station_longitude_dd numeric high precision value of transect station longitude measured in decimal degrees
100 No No operation_dim$scientist_4_person_whid int4 person reference for the fourth scientist
100 No No best_available_taxonomy_dim$abbreviated_name varchar specialized common name, generally for a well-known species of fish such as ATF, LST, SST
100 No No tow_end_timestamp timestamp operation end date timestamp
100 No No target_station_design_dim$area_hectares numeric station area measured in hectares
100 No No target_station_design_dim$mean_depth_m numeric high precision value of mean depth measured in meters
100 No No most_recent_taxonomy_update_date_dim$month_name varchar text representation of month
100 No No actual_station_design_dim$lower_right_longitude_dd numeric high precision value of lower right longitude of design type grid measured in decimal degrees
100 No No tow_start_timestamp timestamp operation start date timestamp
100 No No best_available_taxonomy_dim$superorder_38 varchar superorder name
100 No No best_available_taxonomy_dim$kingdom_10 varchar kingdom name
100 No No field_identified_taxonomy_dim$structure_source varchar Source of the taxonomic structure
100 No No station_lr_lat_dd numeric high precision value of lower right latitude of design type grid measured in decimal degrees
100 No No best_available_taxonomy_dim$hookandline_species_id int4 species identifier used by hook and line
100 No No operation_dim$trip_id int4 trip identifier number
100 No No field_identified_taxonomy_dim$family_50 varchar family name
100 No No species_subcategory varchar mid-level taxonomic ranking
100 No No actual_station_design_dim$upper_right_latitude_dd numeric high precision value of upper right latitude of design type grid measured in decimal degrees
100 No No 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 No No operation_dim$coast_guard_number varchar Coast Guard documentation number of vessel
100 No No date_dim$month_name varchar text representation of month
100 No No operation_dim$record_type varchar operation record or reason record is unavailable
100 No No target_station_design_dim$lower_left_longitude_whid int4 lower left longitude warehouse identifier for a design type of grid
100 No No operation_dim$operation_end_time_whid int8 end time reference for the operation
100 No No actual_station_design_dim$upper_right_longitude_whid int4 upper right longitude warehouse identifier for a design type of grid
100 No No actual_station_design_dim$transect_station_longitude_whid int4 longitude on transect warehouse identifier for a design type of transect
100 No No actual_station_design_dim$max_latitude_dd numeric high precision value of maximum latitude measured in decimal degrees
100 No No field_identified_taxonomy_dim$subspecies_82 varchar subspecies name
100 No No target_station_design_dim$mean_depth_whid int4 mean depth warehouse identifier
100 No No field_identified_taxonomy_dim$abbreviated_name varchar specialized common name, generally for a well-known species of fish such as ATF, LST, SST
100 No No sampling_end_time_dim$military_hour int2 military representation of the hour
100 No No sampling_start_time_dim$period bpchar period of time
100 No No total_catch_wt_kg numeric total catch weight in kilograms is ordinarily the weight of a taxonomic group within a haul. It is usually the sum of all baskets weights collected for a taxonomic group within a haul, but may be derived as a linear expansion based on a weighed, sorted subsample pulled randomly from the weighed unsorted total within a haul.
100 No No best_available_taxonomy_dim$phylum_20 varchar phylum name
100 No No best_available_taxonomy_dim$suborder_42 varchar suborder name
100 No No net_liftoff_time time military time representation of the time
100 No No sampling_end_hhmmss bpchar concatenation of military hour, minute, second, example 230415 equates to 23:04:15
100 No No most_recent_taxonomy_update_date_dim$day_of_month int2 numeric representation of the day in month
100 No No partition varchar Refines the partition type
100 No No best_available_taxonomy_dim$tribe_60 varchar tribe name
100 No No actual_station_design_dim$mean_depth_whid int4 mean depth warehouse identifier
100 No No sampling_start_time_dim$minute int2 number of minutes in the hour
100 No No target_station_design_dim$upper_left_longitude_whid int4 upper left longitude warehouse identifier for a design type of grid
100 No No field_identified_taxonomy_dim$worms_aphiaid int4 WoRMS taxonomic identifier
100 No No haul_longitude_dim$longitude_in_degree_minute_second varchar string representation of longitude in degrees, minutes, and seconds for example 4525'01"
100 No No station_ur_lon_dd numeric high precision value of upper right longitude of design type grid measured in decimal degrees
100 No No statistical_partition_dim$record_type varchar statistical partition record or reason record is unavailable
100 No No midtow_lat_named_parallel varchar name of parallel, boundary, or commonly used geograpical location
100 No No centroid_id numeric eight character code representing a unique identifier for a grid cell that is composed of a truncated latitude and longitude central to the cell. For example, 46252413 represents latitude 46 degrees 25 minutes and longitude -124 degrees and 13 minutes. The grid cells are small enough that 8 characters captures uniqueness. Note that these are NOT technically or mathematically centroids of the polygons.
100 No No most_recent_taxonomy_update_date_dim$yyyymmdd bpchar text representation of year month day
100 No No field_identified_taxonomy_dim$subclass_32 varchar subclass name
100 No No target_station_design_dim$station_grid_dd polygon collection of vertices of grid points of a grid design measured in decimal degrees
100 No No target_station_design_dim$transect_latitude_dd numeric high precision value of transect latitude measured in decimal degrees
100 No No target_station_design_whid int4 warehouse identifier for target station design
100 No No 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 No No field_identified_taxonomy_dim$phylum_20 varchar phylum name
100 No No actual_station_design_dim$variance_depth_m2 numeric high precision value of variance depth mesured in squared meters
100 No No haul_latitude_dim$latitude_minute_units int2 numeric representation of latitude that makes up the minute unit only
100 No No operation_dim_whid int8 warehouse identifier for operation
100 No No field_identified_taxonomy_dim$species_category varchar upper-level taxonomic ranking
100 No No best_available_taxonomy_observation_detail_dim$measurement_procurement varchar how the measurement was achieved
100 No No total_catch_wt_observation_detail_dim$method_description varchar description of how the observation was taken
100 No No depth_ftm numeric depth low precision measurement in fathoms converted from meters measured to the tenth of a meter except for special fathom boundaries
100 No No best_available_taxonomy_dim$class_30 varchar class name
100 No No actual_station_design_dim$lower_left_latitude_dd numeric high precision value of lower left latitude of design type grid measured in decimal degrees
100 No No performance varchar performance of the operation
100 No No date_dim$month_abbrev bpchar three character representation of month in capital letters
100 No No station_ll_lon_dd numeric high precision value of lower left longitude of design type grid measured in decimal degrees
100 No No seafloor_depth_whid int4 warehouse identifier for seafloor depth
100 No No 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 No No field_identified_taxonomy_dim$scientific_name_taxonomic_level varchar name of the lowest taxonomic level used to define scientific name
100 No No 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 No No target_station_design_dim$station_design_type varchar type of design underlying the survey station set: Transect or Grid to date
100 No No operation_dim$departure_port_whid int4 port reference for the departure port
100 No No haul_latitude_dim$latitude_degree_units int2 numeric representation of latitude that makes up the degree unit only
100 No No actual_station_design_dim$lower_right_latitude_dd numeric high precision value of lower right latitude of design type grid measured in decimal degrees
100 No No 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 No No operation_dim$field_operation_seg_id int8 operation segment id reference to the field operational segment table
100 No No haul_latitude_dim$latitude_compass_direction bpchar latitude compass direction
100 No No field_identified_taxonomy_dim$record_type varchar record or reason record is unavailable
100 No No station_lr_lon_dd numeric high precision value of lower right longitude of design type grid measured in decimal degrees
100 No No date_dim$day_of_month int2 numeric representation of the day in month
100 No No actual_station_design_dim$upper_left_longitude_dd numeric high precision value of upper left longitude of design type grid measured in decimal degrees
100 No No cpue_kg_per_ha_der numeric derivation of catch per unit effort in weight (kilograms) per hectare ordinarily estimated as the expanded haul catch weight divided by the area swept by the net.
100 No No field_identified_taxonomy_dim$species_sub_category varchar mid-level taxonomic ranking
100 No No field_note varchar notes made in the field about the catch
100 No No operation_dim$scientist_2_person_whid int4 person reference for the second scientist
100 No No actual_station_design_dim$max_depth_whid int4 maximum depth warehouse identifier
100 No No most_recent_taxonomy_update_date_dim$month_abbrev bpchar three character representation of month in capital letters
100 No No target_station_design_dim$max_latitude_whid int4 maximum latitude warehouse identifier for a design type of transect
100 No No haul_longitude_dim$longitude_minute_units int2 numeric representation of longitude that makes up the minute unit only
100 No No date_dim$year int4 numeric representation of year
100 No No operation_dim$state_registration_number varchar state registration number for the vessel
100 No No best_available_taxonomy_dim$genus_70 varchar genus name
100 No No total_catch_wt_observation_detail_dim$observation_type varchar the type of observation
100 No No actual_station_design_dim$transect_latitude_whid int4 latitude warehouse identifier for a design type of transect
100 No No sampling_end_time_dim$hour int2 standard representation of the hour
100 No No target_station_design_dim$lower_right_latitude_whid int4 lower right latitude warehouse identifier for a design type of grid
100 No No field_identified_taxonomy_dim$pacfin_spid varchar pacfin species id - many taxa may not have one of these
100 No No latitude_dd numeric numeric representation of latitude in degrees
100 No No taxon_rank varchar name of the lowest taxonomic level used to define scientific name
100 No No haul_longitude_dim$record_type varchar longitude record type or reason record is unavailable
100 No No actual_station_design_dim$active_polygon_dd polygon collection of vertices of the usuable area inside a station grid measured in decimal degrees
100 No No actual_station_design_dim$reason_station_invalid varchar reason station was invalidated, multiple reasons are comma separated
100 No No target_station_design_dim$min_latitude_dd numeric high precision value of minimum latitude measured in decimal degrees
100 No No field_identified_taxonomy_dim$tribe_60 varchar tribe name
100 No No field_identified_taxonomy_dim$observer_species_id int4 species identifier used by the observer program
100 No No sampling_end_time_dim$record_type varchar time record or reason record is unavailable
100 No No target_station_design_dim$transect_station_longitude_dd numeric high precision value of transect station longitude measured in decimal degrees
100 No No most_recent_taxonomy_update_date_dim$year int4 numeric representation of year
100 No No target_station_design_dim$upper_left_latitude_whid int4 upper left latitude warehouse identifier for a design type of grid
100 No No 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 No No actual_station_design_dim$mean_depth_m numeric high precision value of mean depth measured in meters
100 No No actual_station_design_dim$upper_left_longitude_whid int4 upper left longitude warehouse identifier for a design type of grid
100 No No field_identified_taxonomy_dim$class_30 varchar class name
100 No No statistical_partition_whid int4 warehouse identifier for statistical partition
100 No No best_available_taxonomy_dim$infraclass_34 varchar infraclass name
100 No No best_available_taxonomy_dim$pacfin_nom_spid varchar PacFIN nominal species identifier
100 No No best_available_taxonomy_dim$subphylum_22 varchar subphylum name
100 No No actual_station_design_dim$max_depth_m numeric high precision value of maximum depth measured in meters
100 No No best_available_taxonomy_observation_detail_dim$means_of_calculation varchar describes how the measurement was calculated
100 No No sampling_end_time_dim$minute int2 number of minutes in the hour
100 No No date_yyyymmdd bpchar text representation of year month day
100 No No best_available_taxonomy_whid int4 warehouse identifier to best available taxonomy
100 No No haul_longitude_dim$longitude_compass_direction bpchar longitude compass direction
100 No No project varchar project name
100 No No best_available_taxonomy_dim$trawl_survey_species_id int4 species identifier used by the trawl survey
100 No No total_catch_wt_observation_detail_dim$measurement_procurement varchar how the measurement was achieved
100 No No station_ur_lat_dd numeric high precision value of upper right latitude of design type grid measured in decimal degrees
100 No No target_station_design_dim$transect_latitude_whid int4 latitude warehouse identifier for a design type of transect
100 No No best_available_taxonomy_dim$infraorder_44 varchar infraorder name
100 No No field_identified_taxonomy_dim$superorder_38 varchar superorder name
100 No No actual_station_design_dim$lower_right_latitude_whid int4 lower right latitude warehouse identifier for a design type of grid
100 No No operation_dim$observer_program varchar description of the observer program
100 No No actual_station_design_whid int4 warehouse identifier for station design
100 No No tow int2 operation number of the survey
100 No No actual_station_design_dim$lower_right_longitude_whid int4 lower right longitude warehouse identifier for a design type of grid
100 No No date_whid int8 warehouse identifier for date
100 No No target_station_design_dim$min_latitude_whid int4 minimum latitude warehouse identifier for a design type of transect
100 No No subsample_wt_kg numeric weight in kilograms of the subsample used for numbers expansion. This is usually either the counted fraction or the subsample that is measured for fish length.
100 No No operation_dim$return_port_whid int4 port reference for return port
100 No No field_identified_taxonomy_whid int4 warehouse identifier to field identified taxonomy
100 No No date_dim$record_type varchar date, month, or year record or reason record is unavailable
100 No No most_recent_taxonomy_update_date_whid int8 warehouse identifier for most recent taxonomy update date
100 No No best_available_taxonomy_observation_detail_dim$observation_type varchar the type of observation
100 No No best_available_taxonomy_dim$species_80 varchar species name
100 No No taxon_source varchar name of primary source used to get the measurement
100 No No date_dim$month_of_year int2 numeric representation of month of year
100 No No field_identified_taxonomy_dim$kingdom_10 varchar kingdom name
100 No No sampling_end_time_dim$second int2 number of seconds in the minute
100 No No haul_latitude_whid int4 warehouse identifier for haul latitude
100 No No operation_dim$departure_date_whid int8 date reference that vessel departed for the defined leg or trip
100 No No actual_station_design_dim$max_latitude_whid int4 maximum latitude warehouse identifier for a design type of transect
100 No No sampling_start_time_dim$record_type varchar time record or reason record is unavailable
100 No No target_station_design_dim$variance_depth_m2 numeric high precision value of variance depth mesured in squared meters
100 No No field_identified_taxonomy_dim$acoustics_species_id int4 Species ID used in the acoustics program
100 No No actual_station_design_dim$upper_right_longitude_dd numeric high precision value of upper right longitude of design type grid measured in decimal degrees
100 No No depth_m numeric depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries)
100 No No operation_dim$scientist_1_person_whid int4 person reference for the first scientist
100 No No target_station_design_dim$upper_right_latitude_whid int4 upper right latitude warehouse identifier for a design type of grid
100 No No best_available_taxonomy_dim$subclass_32 varchar subclass name
100 No No haul_longitude_dim$longitude_degree_units int2 numeric representation of longitude that makes up the degree unit only
100 No No target_station_design_dim$record_type varchar station design record or reason record is unavailable
100 No No field_identified_taxonomy_dim$trawl_survey_species_id int4 species identifier used by the trawl survey
100 No No cpue_numbers_per_ha_der numeric derivation of catch per unit effort in numbers of individuals per hectare ordinarily estimated as the expanded haul catch in numbers divided by the area swept by the net.
100 No No best_available_taxonomy_observation_detail_dim$method_description varchar description of how the observation was taken
100 No No sampling_start_hhmmss bpchar concatenation of military hour, minute, second, example 230415 equates to 23:04:15
100 No No operation_dim$vessel_id int2 field database vessel id number
100 No No actual_station_design_dim$station_design_type varchar type of design underlying the survey station set: Transect or Grid to date
100 No No target_station_design_dim$min_depth_whid int4 minimum depth warehouse identifier
100 No No target_station_design_dim$lower_right_longitude_whid int4 lower right longitude warehouse identifier for a design type of grid
100 No No operation_dim$return_date_whid int8 date reference that vessel returned for the defined leg or trip
100 No No field_identified_taxonomy_dim$suborder_42 varchar suborder name
100 No No field_identified_taxonomy_dim$pacfin_nom_spid varchar PacFIN nominal species identifier
100 No No best_available_taxonomy_observation_detail_whid int4 warehouse identifier to best available taxonomy observation detail
100 No No seafloor_depth_dim$record_type varchar depth record or reason record is unavailable
100 No No sampling_start_time_dim$hour int2 standard representation of the hour
100 No No year int2 operation year
100 No No actual_station_design_dim$stn_invalid_for_trawl_date_whid int8 station design invalidation date warehouse identifier
100 No No statistical_partition_dim$statistical_partition_type varchar Defines the partition type
100 No No operation_dim$operation_start_date_whid int8 start date reference for the operation
100 No No longitude_dd numeric numeric representation of longitude in decimal degrees
100 No No field_identified_taxonomy_dim$genus_70 varchar genus name
100 No No station_code varchar unique identifier for a station definition
100 No No station_ul_lon_dd numeric high precision value of upper left longitude of design type grid measured in decimal degrees
100 No No sampling_start_time_whid int8 warehouse identifier for the sampling start time
100 No No actual_station_design_dim$lower_left_latitude_whid int4 lower left latitude warehouse identifier for a design type of grid
100 No No trawl_id int8 identifier for a sampling operation

Attribute Details

Attribute Name vessel
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

name of the vessel used for the operation
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
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
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name target_station_design_dim$station_design_name
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

name of the design for a collection of stations
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name best_available_taxonomy_dim$structure_source
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

Source of the taxonomic structure
General Data Type  
Unit of Measure unspecified
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values Any
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name min_depth_m
Seq. Order  
Data Storage Type numeric
Max Length 12
Min Length  
Required No
Primary Key No
Precision 4
Scale  
Status Active
Description

high precision value of minimum depth measured in meters
General Data Type  
Unit of Measure m
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$min_depth_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

minimum depth warehouse identifier
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name net_touchdown_time
Seq. Order  
Data Storage Type time
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

military time representation of the time
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name species_category
Seq. Order  
Data Storage Type varchar
Max Length 40
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

upper-level taxonomic ranking
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values fish, invertebrate, mammal, seabird, reptile, nonspecific organics, NA
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name year_stn_invalid
Seq. Order  
Data Storage Type int2
Max Length 16
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Survey year the station became invalid for trawl
General Data Type  
Unit of Measure year
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values Any
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name best_available_taxonomy_dim$subfamily_52
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

subfamily name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name sampling_end_time_dim$period
Seq. Order  
Data Storage Type bpchar
Max Length 2
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

period of time
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values AM, PM
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$centroid_id
Seq. Order  
Data Storage Type numeric
Max Length 10
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

eight character code representing a unique identifier for a grid cell that is composed of a truncated latitude and longitude central to the cell. For example, 46252413 represents latitude 46 degrees 25 minutes and longitude -124 degrees and 13 minutes. The grid cells are small enough that 8 characters captures uniqueness. Note that these are NOT technically or mathematically centroids of the polygons.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name field_identified_taxonomy_dim$norpac_species_id
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
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.
General Data Type  
Unit of Measure unspecified
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values Any
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name field_identified_taxonomy_dim$subphylum_22
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

subphylum name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$station_code
Seq. Order  
Data Storage Type varchar
Max Length 12
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

unique identifier for a station definition
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name catch_id
Seq. Order  
Data Storage Type int8
Max Length 64
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

unique(legacy) identifier for the catch from a haul, sorted to taxonomic group or debris type.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name best_available_taxonomy_dim$itis_taxonomic_serial_no
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

ITIS taxonomic identifier
General Data Type  
Unit of Measure unspecified
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values Any
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name field_identified_taxonomy_dim$species_80
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

species name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name field_identified_taxonomy_dim$subfamily_52
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

subfamily name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name haul_latitude_dim$record_type
Seq. Order  
Data Storage Type varchar
Max Length 30
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

latitude record type or reason record is unavailable
General Data Type  
Unit of Measure NA
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name best_available_taxonomy_dim$grp_nonstandard_taxon_99
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
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
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name operation_dim$limited_entry_permit_number
Seq. Order  
Data Storage Type bpchar
Max Length 6
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

federal limited entry groundfish permit issued to fish in waters off of Washington, Oregon, and California
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name field_identified_taxonomy_dim$superfamily_48
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

superfamily name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name date_dim$full_date
Seq. Order  
Data Storage Type timestamp
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

full date value
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$station_invalid_survey_year
Seq. Order  
Data Storage Type int2
Max Length 16
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Survey year the station became invalid for trawl
General Data Type  
Unit of Measure year
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values Any
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$lower_left_longitude_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

lower left longitude warehouse identifier for a design type of grid
General Data Type  
Unit of Measure unspecified
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values Any
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name total_catch_wt_observation_detail_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

warehouse identifier to total catch weight observation details
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name target_station_design_dim$transect_station_longitude_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

longitude on transect warehouse identifier for a design type of transect
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name best_available_taxonomy_dim$superfamily_48
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

superfamily name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name field_identified_taxonomy_dim$superclass_28
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

superclass name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name haul_latitude_dim$latitude_in_degree_minute_second
Seq. Order  
Data Storage Type varchar
Max Length 20
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

string representation of latitude in degrees, minutes, and seconds for example 4525'01"
General Data Type  
Unit of Measure NA
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values any
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$station_grid_dd
Seq. Order  
Data Storage Type polygon
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

collection of vertices of grid points of a grid design measured in decimal degrees
General Data Type  
Unit of Measure dd
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name field_identified_taxonomy_dim$infraclass_34
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

infraclass name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name best_available_taxonomy_dim$acoustics_species_id
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

Species ID used in the acoustics program
General Data Type  
Unit of Measure unspecified
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values Any
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name most_recent_taxon_update
Seq. Order  
Data Storage Type timestamp
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

full date value
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name operation_dim$scientist_3_person_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

person reference for the third scientist
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name target_station_design_dim$lower_left_latitude_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

lower left latitude warehouse identifier for a design type of grid
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$area_hectares
Seq. Order  
Data Storage Type numeric
Max Length 12
Min Length  
Required No
Primary Key No
Precision 8
Scale  
Status Active
Description

station area measured in hectares
General Data Type  
Unit of Measure hectares
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name haul_longitude_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

warehouse identifier for haul longitude
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name best_available_taxonomy_dim$worms_aphiaid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

WoRMS taxonomic identifier
General Data Type  
Unit of Measure unspecified
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values Any
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name target_station_design_dim$max_depth_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

maximum depth warehouse identifier
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name best_available_taxonomy_observation_detail_dim$record_type
Seq. Order  
Data Storage Type varchar
Max Length 30
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

observation detail record type or reason record is unavailable
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values Observation Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name field_identified_taxonomy_dim$order_40
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

order name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name most_recent_taxonomy_update_date_dim$record_type
Seq. Order  
Data Storage Type varchar
Max Length 30
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

date, month, or year record or reason record is unavailable
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name haul_longitude_dim$longitude_second_units
Seq. Order  
Data Storage Type int2
Max Length 16
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

numeric representation of longitude that makes up the second unit only
General Data Type  
Unit of Measure sec
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values 0-59
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$min_latitude_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

minimum latitude warehouse identifier for a design type of transect
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name pass
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

pass number of the survey
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values 1,2,3,4
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$min_depth_m
Seq. Order  
Data Storage Type numeric
Max Length 12
Min Length  
Required No
Primary Key No
Precision 4
Scale  
Status Active
Description

high precision value of minimum depth measured in meters
General Data Type  
Unit of Measure m
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name station_ul_lat_dd
Seq. Order  
Data Storage Type numeric
Max Length 12
Min Length  
Required No
Primary Key No
Precision 8
Scale  
Status Active
Description

high precision value of upper left latitude of design type grid measured in decimal degrees
General Data Type  
Unit of Measure dd
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name total_catch_numbers
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

numbers expansion for a taxonomic group within a haul.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name max_depth_m
Seq. Order  
Data Storage Type numeric
Max Length 12
Min Length  
Required No
Primary Key No
Precision 4
Scale  
Status Active
Description

high precision value of maximum depth measured in meters
General Data Type  
Unit of Measure m
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name operation_dim$operation_start_time_whid
Seq. Order  
Data Storage Type int8
Max Length 64
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

start time reference for the operation
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name best_available_taxonomy_dim$family_50
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

family name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name field_identified_taxonomy_dim$itis_taxonomic_serial_no
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

ITIS taxonomic identifier
General Data Type  
Unit of Measure unspecified
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values Any
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name program
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

type of fram program
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values Bottom Trawl, Hook and Line
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name best_available_taxonomy_dim$record_type
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

record or reason record is unavailable
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values Taxonomy, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name operation_dim$captain_person_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

person reference for the vessel captain
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name total_catch_wt_observation_detail_dim$source_primary
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

name of primary source used to get the measurement
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values Angler, FPC, Genetics, Lab Exam, Large Scale, Morphometrics, Morphometrics + Genetics, NA, Quality Assurance, Retrospective Review, Taxon Rank Upped, Whole Organism
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name total_catch_wt_observation_detail_dim$means_of_calculation
Seq. Order  
Data Storage Type varchar
Max Length 30
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

describes how the measurement was calculated
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values Observation Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$upper_left_latitude_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

upper left latitude warehouse identifier for a design type of grid
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name target_station_design_dim$stn_invalid_for_trawl_date_whid
Seq. Order  
Data Storage Type int8
Max Length 64
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

station design invalidation date warehouse identifier
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name mean_seafloor_dep_boundary
Seq. Order  
Data Storage Type varchar
Max Length 40
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

depth boundry indicator identifying ifp boundary marks
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values IFP Boundary Depth, Standard Contour Depth, NA
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name field_identified_taxonomy_dim$infraorder_44
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

infraorder name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name operation_dim$fpc_person_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

person reference for the FPC
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name best_available_taxonomy_dim$order_40
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

order name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name haul_latitude_dim$latitude_second_units
Seq. Order  
Data Storage Type int2
Max Length 16
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

numeric representation of latitude that makes up the second unit only
General Data Type  
Unit of Measure sec
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values 0-60
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name target_station_design_dim$max_latitude_dd
Seq. Order  
Data Storage Type numeric
Max Length 12
Min Length  
Required No
Primary Key No
Precision 8
Scale  
Status Active
Description

high precision value of maximum latitude measured in decimal degrees
General Data Type  
Unit of Measure dd
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$upper_left_latitude_dd
Seq. Order  
Data Storage Type numeric
Max Length 12
Min Length  
Required No
Primary Key No
Precision 8
Scale  
Status Active
Description

high precision value of upper left latitude of design type grid measured in decimal degrees
General Data Type  
Unit of Measure dd
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name sampling_start_time_dim$military_hour
Seq. Order  
Data Storage Type int2
Max Length 16
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

military representation of the hour
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values 0-24
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$station_design_name
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

name of the design for a collection of stations
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name pacfin_spid
Seq. Order  
Data Storage Type varchar
Max Length 10
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

pacfin species id - many taxa may not have one of these
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name leg
Seq. Order  
Data Storage Type int2
Max Length 16
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

leg number of the survey
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values 1,2,3,4,5,6,7,8
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$lower_left_longitude_dd
Seq. Order  
Data Storage Type numeric
Max Length 12
Min Length  
Required No
Primary Key No
Precision 8
Scale  
Status Active
Description

high precision value of lower left longitude of design type grid measured in decimal degrees
General Data Type  
Unit of Measure dd
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$record_type
Seq. Order  
Data Storage Type varchar
Max Length 30
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

station design record or reason record is unavailable
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values Station Design, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name target_station_design_dim$active_polygon_dd
Seq. Order  
Data Storage Type polygon
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

collection of vertices of the usuable area inside a station grid measured in decimal degrees
General Data Type  
Unit of Measure dd
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name operation_dim$operation_type
Seq. Order  
Data Storage Type varchar
Max Length 20
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

type of operation
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values CTD Cast, Drop, Experiment, Search, Trawl, VPR Tow, [null]
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name subsample_count
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

count of the subsample used for numbers expansion. This is usually either the counted fraction or the subsample that is measured for fish length.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name best_available_taxonomy_dim$observer_species_id
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

species identifier used by the observer program
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name reason_stn_invalid
Seq. Order  
Data Storage Type varchar
Max Length 150
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

reason station was invalidated, multiple reasons are comma separated
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values California State MPA, Cowcod Conservation Area, ENC Avoidance, Farallon Island Radioactive Waste Dump, ONMS MPA, ONMS Permit Exclusion, Outside Survey Extent, Mooring, San Clemente Is. Military test range
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$transect_latitude_dd
Seq. Order  
Data Storage Type numeric
Max Length 12
Min Length  
Required No
Primary Key No
Precision 8
Scale  
Status Active
Description

high precision value of transect latitude measured in decimal degrees
General Data Type  
Unit of Measure dd
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name operation_dim$ifq_account_number
Seq. Order  
Data Storage Type varchar
Max Length 12
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

unique number assigned to user accounts in the Vessel Accounting Database
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name field_identified_taxonomy_dim$hookandline_species_id
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

species identifier used by hook and line
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name target_station_design_dim$upper_right_longitude_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

upper right longitude warehouse identifier for a design type of grid
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$min_latitude_dd
Seq. Order  
Data Storage Type numeric
Max Length 12
Min Length  
Required No
Primary Key No
Precision 8
Scale  
Status Active
Description

high precision value of minimum latitude measured in decimal degrees
General Data Type  
Unit of Measure dd
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name station_ll_lat_dd
Seq. Order  
Data Storage Type numeric
Max Length 12
Min Length  
Required No
Primary Key No
Precision 8
Scale  
Status Active
Description

high precision value of lower left latitude of design type grid measured in decimal degrees
General Data Type  
Unit of Measure dd
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name most_recent_taxonomy_update_date_dim$month_of_year
Seq. Order  
Data Storage Type int2
Max Length 16
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

numeric representation of month of year
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values 1-12
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$upper_right_latitude_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

upper right latitude warehouse identifier for a design type of grid
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name operation_dim$operation_end_date_whid
Seq. Order  
Data Storage Type int8
Max Length 64
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

end date reference for the operation
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name sampling_start_time_dim$second
Seq. Order  
Data Storage Type int2
Max Length 16
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

number of seconds in the minute
General Data Type  
Unit of Measure sec
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values 0-60
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name field_identified_taxonomy_dim$grp_reg_depth_category
Seq. Order  
Data Storage Type varchar
Max Length 25
Min Length  
Required No
Primary Key No
Precision  
Scale  
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
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name best_available_taxonomy_dim$superclass_28
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

superclass name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name total_catch_wt_observation_detail_dim$record_type
Seq. Order  
Data Storage Type varchar
Max Length 30
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

observation detail record type or reason record is unavailable
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values Observation Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name common_name
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
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
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name best_available_taxonomy_dim$subspecies_82
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

subspecies name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name sampling_end_time_whid
Seq. Order  
Data Storage Type int8
Max Length 64
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

warehouse identifier for the sampling end time
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$transect_station_longitude_dd
Seq. Order  
Data Storage Type numeric
Max Length 12
Min Length  
Required No
Primary Key No
Precision 8
Scale  
Status Active
Description

high precision value of transect station longitude measured in decimal degrees
General Data Type  
Unit of Measure dd
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name operation_dim$scientist_4_person_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

person reference for the fourth scientist
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name best_available_taxonomy_dim$abbreviated_name
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

specialized common name, generally for a well-known species of fish such as ATF, LST, SST
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name tow_end_timestamp
Seq. Order  
Data Storage Type timestamp
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

operation end date timestamp
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name target_station_design_dim$area_hectares
Seq. Order  
Data Storage Type numeric
Max Length 12
Min Length  
Required No
Primary Key No
Precision 8
Scale  
Status Active
Description

station area measured in hectares
General Data Type  
Unit of Measure hectares
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name target_station_design_dim$mean_depth_m
Seq. Order  
Data Storage Type numeric
Max Length 12
Min Length  
Required No
Primary Key No
Precision 4
Scale  
Status Active
Description

high precision value of mean depth measured in meters
General Data Type  
Unit of Measure m
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name most_recent_taxonomy_update_date_dim$month_name
Seq. Order  
Data Storage Type varchar
Max Length 10
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

text representation of month
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values January, February, March, April, May, June, July, August, September, October, November, December
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$lower_right_longitude_dd
Seq. Order  
Data Storage Type numeric
Max Length 12
Min Length  
Required No
Primary Key No
Precision 8
Scale  
Status Active
Description

high precision value of lower right longitude of design type grid measured in decimal degrees
General Data Type  
Unit of Measure dd
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name tow_start_timestamp
Seq. Order  
Data Storage Type timestamp
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

operation start date timestamp
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name best_available_taxonomy_dim$superorder_38
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

superorder name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name best_available_taxonomy_dim$kingdom_10
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

kingdom name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name field_identified_taxonomy_dim$structure_source
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

Source of the taxonomic structure
General Data Type  
Unit of Measure unspecified
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values Any
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name station_lr_lat_dd
Seq. Order  
Data Storage Type numeric
Max Length 12
Min Length  
Required No
Primary Key No
Precision 8
Scale  
Status Active
Description

high precision value of lower right latitude of design type grid measured in decimal degrees
General Data Type  
Unit of Measure dd
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name best_available_taxonomy_dim$hookandline_species_id
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

species identifier used by hook and line
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name operation_dim$trip_id
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

trip identifier number
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name field_identified_taxonomy_dim$family_50
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

family name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name species_subcategory
Seq. Order  
Data Storage Type varchar
Max Length 40
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

mid-level taxonomic ranking
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values rockfish, flatfish, shark, crab, NA
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$upper_right_latitude_dd
Seq. Order  
Data Storage Type numeric
Max Length 12
Min Length  
Required No
Primary Key No
Precision 8
Scale  
Status Active
Description

high precision value of upper right latitude of design type grid measured in decimal degrees
General Data Type  
Unit of Measure dd
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name field_identified_taxonomy_dim$grp_nonstandard_taxon_99
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
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
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name operation_dim$coast_guard_number
Seq. Order  
Data Storage Type varchar
Max Length 10
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Coast Guard documentation number of vessel
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name date_dim$month_name
Seq. Order  
Data Storage Type varchar
Max Length 10
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

text representation of month
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values January, February, March, April, May, June, July, August, September, October, November, December
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name operation_dim$record_type
Seq. Order  
Data Storage Type varchar
Max Length 30
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

operation record or reason record is unavailable
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values Operation, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name target_station_design_dim$lower_left_longitude_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

lower left longitude warehouse identifier for a design type of grid
General Data Type  
Unit of Measure unspecified
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values Any
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name operation_dim$operation_end_time_whid
Seq. Order  
Data Storage Type int8
Max Length 64
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

end time reference for the operation
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$upper_right_longitude_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

upper right longitude warehouse identifier for a design type of grid
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$transect_station_longitude_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

longitude on transect warehouse identifier for a design type of transect
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$max_latitude_dd
Seq. Order  
Data Storage Type numeric
Max Length 12
Min Length  
Required No
Primary Key No
Precision 8
Scale  
Status Active
Description

high precision value of maximum latitude measured in decimal degrees
General Data Type  
Unit of Measure dd
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name field_identified_taxonomy_dim$subspecies_82
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

subspecies name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name target_station_design_dim$mean_depth_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

mean depth warehouse identifier
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name field_identified_taxonomy_dim$abbreviated_name
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

specialized common name, generally for a well-known species of fish such as ATF, LST, SST
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name sampling_end_time_dim$military_hour
Seq. Order  
Data Storage Type int2
Max Length 16
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

military representation of the hour
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values 0-24
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name sampling_start_time_dim$period
Seq. Order  
Data Storage Type bpchar
Max Length 2
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

period of time
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values AM, PM
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name total_catch_wt_kg
Seq. Order  
Data Storage Type numeric
Max Length 10
Min Length  
Required No
Primary Key No
Precision 4
Scale  
Status Active
Description

total catch weight in kilograms is ordinarily the weight of a taxonomic group within a haul. It is usually the sum of all baskets weights collected for a taxonomic group within a haul, but may be derived as a linear expansion based on a weighed, sorted subsample pulled randomly from the weighed unsorted total within a haul.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name best_available_taxonomy_dim$phylum_20
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

phylum name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name best_available_taxonomy_dim$suborder_42
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

suborder name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name net_liftoff_time
Seq. Order  
Data Storage Type time
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

military time representation of the time
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name sampling_end_hhmmss
Seq. Order  
Data Storage Type bpchar
Max Length 6
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

concatenation of military hour, minute, second, example 230415 equates to 23:04:15
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name most_recent_taxonomy_update_date_dim$day_of_month
Seq. Order  
Data Storage Type int2
Max Length 16
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

numeric representation of the day in month
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values 1-31
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name partition
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Refines the partition type
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values Life stage: YOY, larvae, eggs and egg cases, adult, subadult; Size: Large, Small, Unspecified; Gender: Male, Female
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name best_available_taxonomy_dim$tribe_60
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

tribe name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$mean_depth_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

mean depth warehouse identifier
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name sampling_start_time_dim$minute
Seq. Order  
Data Storage Type int2
Max Length 16
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

number of minutes in the hour
General Data Type  
Unit of Measure min
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values 0-60
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name target_station_design_dim$upper_left_longitude_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

upper left longitude warehouse identifier for a design type of grid
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name field_identified_taxonomy_dim$worms_aphiaid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

WoRMS taxonomic identifier
General Data Type  
Unit of Measure unspecified
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values Any
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name haul_longitude_dim$longitude_in_degree_minute_second
Seq. Order  
Data Storage Type varchar
Max Length 20
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

string representation of longitude in degrees, minutes, and seconds for example 4525'01"
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name station_ur_lon_dd
Seq. Order  
Data Storage Type numeric
Max Length 12
Min Length  
Required No
Primary Key No
Precision 8
Scale  
Status Active
Description

high precision value of upper right longitude of design type grid measured in decimal degrees
General Data Type  
Unit of Measure dd
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name statistical_partition_dim$record_type
Seq. Order  
Data Storage Type varchar
Max Length 25
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

statistical partition record or reason record is unavailable
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values Statistical Partition, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name midtow_lat_named_parallel
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

name of parallel, boundary, or commonly used geograpical location
General Data Type  
Unit of Measure NA
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values any
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name centroid_id
Seq. Order  
Data Storage Type numeric
Max Length 10
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

eight character code representing a unique identifier for a grid cell that is composed of a truncated latitude and longitude central to the cell. For example, 46252413 represents latitude 46 degrees 25 minutes and longitude -124 degrees and 13 minutes. The grid cells are small enough that 8 characters captures uniqueness. Note that these are NOT technically or mathematically centroids of the polygons.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name most_recent_taxonomy_update_date_dim$yyyymmdd
Seq. Order  
Data Storage Type bpchar
Max Length 8
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

text representation of year month day
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name field_identified_taxonomy_dim$subclass_32
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

subclass name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name target_station_design_dim$station_grid_dd
Seq. Order  
Data Storage Type polygon
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

collection of vertices of grid points of a grid design measured in decimal degrees
General Data Type  
Unit of Measure dd
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name target_station_design_dim$transect_latitude_dd
Seq. Order  
Data Storage Type numeric
Max Length 12
Min Length  
Required No
Primary Key No
Precision 8
Scale  
Status Active
Description

high precision value of transect latitude measured in decimal degrees
General Data Type  
Unit of Measure dd
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name target_station_design_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

warehouse identifier for target station design
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name field_identified_taxonomy_dim$common_name
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
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
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name field_identified_taxonomy_dim$phylum_20
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

phylum name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$variance_depth_m2
Seq. Order  
Data Storage Type numeric
Max Length 12
Min Length  
Required No
Primary Key No
Precision 4
Scale  
Status Active
Description

high precision value of variance depth mesured in squared meters
General Data Type  
Unit of Measure m2
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name haul_latitude_dim$latitude_minute_units
Seq. Order  
Data Storage Type int2
Max Length 16
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

numeric representation of latitude that makes up the minute unit only
General Data Type  
Unit of Measure min
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values 0-60
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name operation_dim_whid
Seq. Order  
Data Storage Type int8
Max Length 64
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

warehouse identifier for operation
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name field_identified_taxonomy_dim$species_category
Seq. Order  
Data Storage Type varchar
Max Length 40
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

upper-level taxonomic ranking
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values fish, invertebrate, mammal, seabird, reptile, nonspecific organics, NA
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name best_available_taxonomy_observation_detail_dim$measurement_procurement
Seq. Order  
Data Storage Type varchar
Max Length 30
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

how the measurement was achieved
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values NA, Calculated, Estimated, Observed, Measured, Not Documented
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name total_catch_wt_observation_detail_dim$method_description
Seq. Order  
Data Storage Type varchar
Max Length 500
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

description of how the observation was taken
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name depth_ftm
Seq. Order  
Data Storage Type numeric
Max Length 12
Min Length  
Required No
Primary Key No
Precision 4
Scale  
Status Active
Description

depth low precision measurement in fathoms converted from meters measured to the tenth of a meter except for special fathom boundaries
General Data Type  
Unit of Measure fth
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name best_available_taxonomy_dim$class_30
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

class name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$lower_left_latitude_dd
Seq. Order  
Data Storage Type numeric
Max Length 12
Min Length  
Required No
Primary Key No
Precision 8
Scale  
Status Active
Description

high precision value of lower left latitude of design type grid measured in decimal degrees
General Data Type  
Unit of Measure dd
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name performance
Seq. Order  
Data Storage Type varchar
Max Length 25
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

performance of the operation
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values Insufficient Information, Indeterminate, Satisfactory, Trawlable, Untrawlable, Unsatisfactory, [null]
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name date_dim$month_abbrev
Seq. Order  
Data Storage Type bpchar
Max Length 3
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

three character representation of month in capital letters
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name station_ll_lon_dd
Seq. Order  
Data Storage Type numeric
Max Length 12
Min Length  
Required No
Primary Key No
Precision 8
Scale  
Status Active
Description

high precision value of lower left longitude of design type grid measured in decimal degrees
General Data Type  
Unit of Measure dd
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name seafloor_depth_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

warehouse identifier for seafloor depth
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name scientific_name
Seq. Order  
Data Storage Type varchar
Max Length 120
Min Length  
Required No
Primary Key No
Precision  
Scale  
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
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name field_identified_taxonomy_dim$scientific_name_taxonomic_level
Seq. Order  
Data Storage Type varchar
Max Length 15
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

name of the lowest taxonomic level used to define scientific name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name best_available_taxonomy_dim$norpac_species_id
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
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.
General Data Type  
Unit of Measure unspecified
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values Any
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name target_station_design_dim$station_design_type
Seq. Order  
Data Storage Type varchar
Max Length 15
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

type of design underlying the survey station set: Transect or Grid to date
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values Transect, Grid
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name operation_dim$departure_port_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

port reference for the departure port
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name haul_latitude_dim$latitude_degree_units
Seq. Order  
Data Storage Type int2
Max Length 16
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

numeric representation of latitude that makes up the degree unit only
General Data Type  
Unit of Measure deg
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values -90 to 90
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$lower_right_latitude_dd
Seq. Order  
Data Storage Type numeric
Max Length 12
Min Length  
Required No
Primary Key No
Precision 8
Scale  
Status Active
Description

high precision value of lower right latitude of design type grid measured in decimal degrees
General Data Type  
Unit of Measure dd
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name best_available_taxonomy_dim$grp_reg_depth_category
Seq. Order  
Data Storage Type varchar
Max Length 25
Min Length  
Required No
Primary Key No
Precision  
Scale  
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
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name operation_dim$field_operation_seg_id
Seq. Order  
Data Storage Type int8
Max Length 64
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

operation segment id reference to the field operational segment table
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name haul_latitude_dim$latitude_compass_direction
Seq. Order  
Data Storage Type bpchar
Max Length 1
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

latitude compass direction
General Data Type  
Unit of Measure NA
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values N, S
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name field_identified_taxonomy_dim$record_type
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

record or reason record is unavailable
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values Taxonomy, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name station_lr_lon_dd
Seq. Order  
Data Storage Type numeric
Max Length 12
Min Length  
Required No
Primary Key No
Precision 8
Scale  
Status Active
Description

high precision value of lower right longitude of design type grid measured in decimal degrees
General Data Type  
Unit of Measure dd
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name date_dim$day_of_month
Seq. Order  
Data Storage Type int2
Max Length 16
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

numeric representation of the day in month
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values 1-31
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$upper_left_longitude_dd
Seq. Order  
Data Storage Type numeric
Max Length 12
Min Length  
Required No
Primary Key No
Precision 8
Scale  
Status Active
Description

high precision value of upper left longitude of design type grid measured in decimal degrees
General Data Type  
Unit of Measure dd
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name cpue_kg_per_ha_der
Seq. Order  
Data Storage Type numeric
Max Length 16
Min Length  
Required No
Primary Key No
Precision 12
Scale  
Status Active
Description

derivation of catch per unit effort in weight (kilograms) per hectare ordinarily estimated as the expanded haul catch weight divided by the area swept by the net.
General Data Type  
Unit of Measure kg/ha
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name field_identified_taxonomy_dim$species_sub_category
Seq. Order  
Data Storage Type varchar
Max Length 40
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

mid-level taxonomic ranking
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values rockfish, flatfish, shark, crab, NA
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name field_note
Seq. Order  
Data Storage Type varchar
Max Length 1000
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

notes made in the field about the catch
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name operation_dim$scientist_2_person_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

person reference for the second scientist
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$max_depth_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

maximum depth warehouse identifier
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name most_recent_taxonomy_update_date_dim$month_abbrev
Seq. Order  
Data Storage Type bpchar
Max Length 3
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

three character representation of month in capital letters
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name target_station_design_dim$max_latitude_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

maximum latitude warehouse identifier for a design type of transect
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name haul_longitude_dim$longitude_minute_units
Seq. Order  
Data Storage Type int2
Max Length 16
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

numeric representation of longitude that makes up the minute unit only
General Data Type  
Unit of Measure min
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values 0-59
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name date_dim$year
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

numeric representation of year
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values 1978+
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name operation_dim$state_registration_number
Seq. Order  
Data Storage Type varchar
Max Length 12
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

state registration number for the vessel
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name best_available_taxonomy_dim$genus_70
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

genus name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name total_catch_wt_observation_detail_dim$observation_type
Seq. Order  
Data Storage Type varchar
Max Length 30
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

the type of observation
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values NA, width, length, total_catch_weight, taxonomy, etc
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$transect_latitude_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

latitude warehouse identifier for a design type of transect
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name sampling_end_time_dim$hour
Seq. Order  
Data Storage Type int2
Max Length 16
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

standard representation of the hour
General Data Type  
Unit of Measure hr
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values 0-12
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name target_station_design_dim$lower_right_latitude_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

lower right latitude warehouse identifier for a design type of grid
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name field_identified_taxonomy_dim$pacfin_spid
Seq. Order  
Data Storage Type varchar
Max Length 10
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

pacfin species id - many taxa may not have one of these
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name latitude_dd
Seq. Order  
Data Storage Type numeric
Max Length 12
Min Length  
Required No
Primary Key No
Precision 8
Scale  
Status Active
Description

numeric representation of latitude in degrees
General Data Type  
Unit of Measure dd
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values -90 to 90
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name taxon_rank
Seq. Order  
Data Storage Type varchar
Max Length 15
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

name of the lowest taxonomic level used to define scientific name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name haul_longitude_dim$record_type
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

longitude record type or reason record is unavailable
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values Longitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$active_polygon_dd
Seq. Order  
Data Storage Type polygon
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

collection of vertices of the usuable area inside a station grid measured in decimal degrees
General Data Type  
Unit of Measure dd
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$reason_station_invalid
Seq. Order  
Data Storage Type varchar
Max Length 150
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

reason station was invalidated, multiple reasons are comma separated
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values California State MPA, Cowcod Conservation Area, ENC Avoidance, Farallon Island Radioactive Waste Dump, ONMS MPA, ONMS Permit Exclusion, Outside Survey Extent, Mooring, San Clemente Is. Military test range
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name target_station_design_dim$min_latitude_dd
Seq. Order  
Data Storage Type numeric
Max Length 12
Min Length  
Required No
Primary Key No
Precision 8
Scale  
Status Active
Description

high precision value of minimum latitude measured in decimal degrees
General Data Type  
Unit of Measure dd
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name field_identified_taxonomy_dim$tribe_60
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

tribe name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name field_identified_taxonomy_dim$observer_species_id
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

species identifier used by the observer program
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name sampling_end_time_dim$record_type
Seq. Order  
Data Storage Type varchar
Max Length 30
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

time record or reason record is unavailable
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name target_station_design_dim$transect_station_longitude_dd
Seq. Order  
Data Storage Type numeric
Max Length 12
Min Length  
Required No
Primary Key No
Precision 8
Scale  
Status Active
Description

high precision value of transect station longitude measured in decimal degrees
General Data Type  
Unit of Measure dd
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name most_recent_taxonomy_update_date_dim$year
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

numeric representation of year
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values 1978+
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name target_station_design_dim$upper_left_latitude_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

upper left latitude warehouse identifier for a design type of grid
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name field_identified_taxonomy_dim$scientific_name
Seq. Order  
Data Storage Type varchar
Max Length 120
Min Length  
Required No
Primary Key No
Precision  
Scale  
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
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$mean_depth_m
Seq. Order  
Data Storage Type numeric
Max Length 12
Min Length  
Required No
Primary Key No
Precision 4
Scale  
Status Active
Description

high precision value of mean depth measured in meters
General Data Type  
Unit of Measure m
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$upper_left_longitude_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

upper left longitude warehouse identifier for a design type of grid
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name field_identified_taxonomy_dim$class_30
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

class name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name statistical_partition_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

warehouse identifier for statistical partition
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name best_available_taxonomy_dim$infraclass_34
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

infraclass name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name best_available_taxonomy_dim$pacfin_nom_spid
Seq. Order  
Data Storage Type varchar
Max Length 10
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

PacFIN nominal species identifier
General Data Type  
Unit of Measure unspecified
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values Any
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name best_available_taxonomy_dim$subphylum_22
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

subphylum name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$max_depth_m
Seq. Order  
Data Storage Type numeric
Max Length 12
Min Length  
Required No
Primary Key No
Precision 4
Scale  
Status Active
Description

high precision value of maximum depth measured in meters
General Data Type  
Unit of Measure m
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name best_available_taxonomy_observation_detail_dim$means_of_calculation
Seq. Order  
Data Storage Type varchar
Max Length 30
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

describes how the measurement was calculated
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values Observation Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name sampling_end_time_dim$minute
Seq. Order  
Data Storage Type int2
Max Length 16
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

number of minutes in the hour
General Data Type  
Unit of Measure min
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values 0-60
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name date_yyyymmdd
Seq. Order  
Data Storage Type bpchar
Max Length 8
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

text representation of year month day
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name best_available_taxonomy_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

warehouse identifier to best available taxonomy
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name haul_longitude_dim$longitude_compass_direction
Seq. Order  
Data Storage Type bpchar
Max Length 1
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

longitude compass direction
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values E, W
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name project
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

project name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
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
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name best_available_taxonomy_dim$trawl_survey_species_id
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

species identifier used by the trawl survey
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name total_catch_wt_observation_detail_dim$measurement_procurement
Seq. Order  
Data Storage Type varchar
Max Length 30
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

how the measurement was achieved
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values NA, Calculated, Estimated, Observed, Measured, Not Documented
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name station_ur_lat_dd
Seq. Order  
Data Storage Type numeric
Max Length 12
Min Length  
Required No
Primary Key No
Precision 8
Scale  
Status Active
Description

high precision value of upper right latitude of design type grid measured in decimal degrees
General Data Type  
Unit of Measure dd
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name target_station_design_dim$transect_latitude_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

latitude warehouse identifier for a design type of transect
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name best_available_taxonomy_dim$infraorder_44
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

infraorder name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name field_identified_taxonomy_dim$superorder_38
Seq. Order  
Data Storage Type varchar
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

superorder name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name actual_station_design_dim$lower_right_latitude_whid
Seq. Order  
Data Storage Type int4
Max Length 32
Min Length  
Required No
Primary Key No
Precision 0
Scale  
Status Active
Description

lower right latitude warehouse identifier for a design type of grid
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation