individual_hooknline_view
Entity (ENT) | Northwest Fisheries Science Center (NWFSC)GUID: gov.noaa.nmfs.inport:36441 | Updated: August 9, 2022 | Published / External
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
drop_time_dim$hour | int2 | standard representation of the hour | |
|
100
|
sampling_start_time_dim$second | int2 | number of seconds in the minute | |
|
100
|
best_available_taxonomy_observation_detail_dim$measurement_procurement | varchar | how the measurement was achieved | |
|
100
|
most_recent_age_update_date_dim$year | int4 | numeric representation of year | |
|
100
|
best_available_taxonomy_dim$hookandline_species_id | int4 | species identifier used by hook and line | |
|
100
|
best_available_taxonomy_dim$superfamily_48 | varchar | superfamily name | |
|
100
|
most_recent_taxonomy_update_date_dim$month_name | varchar | text representation of month | |
|
100
|
field_identified_taxonomy_dim$grp_nonstandard_taxon_99 | varchar | a pseudo taxonomic level that has a common usage such as Invertebrata, Pisces (Fish). This has been designed to allow for only one level of para- or poly-phyletic group that is the terminus of the definition (it may be associated with a higher level taxonomic hierarchy). Consequently a definition such as Fish->Roundfish would not be supported with this design | |
|
100
|
best_available_taxonomy_dim$kingdom_10 | varchar | kingdom name | |
|
100
|
best_available_taxonomy_dim$trawl_survey_species_id | int4 | species identifier used by the trawl survey | |
|
100
|
drop_time_whid | int8 | Warehouse identifier for the drop time | |
|
100
|
site_dim$tide_station_name | varchar | name of nearest tide station | |
|
100
|
taxon_rank | varchar | name of the lowest taxonomic level used to define scientific name | |
|
100
|
most_recent_taxonomy_update_date_dim$yyyymmdd | bpchar | text representation of year month day | |
|
100
|
best_available_taxonomy_observation_detail_dim$means_of_calculation | varchar | describes how the measurement was calculated | |
|
100
|
date_dim$day_of_month | int2 | numeric representation of the day in month | |
|
100
|
date_dim$month_abbrev | bpchar | three character representation of month in capital letters | |
|
100
|
tow_end_timestamp | timestamp | operation end date timestamp | |
|
100
|
field_identified_taxonomy_dim$observer_species_id | int4 | species identifier used by the observer program | |
|
100
|
field_identified_taxonomy_dim$norpac_species_id | int4 | A three-digit numeric code assigned by the NMFS Observer Program to each different marine organism expected to be seen in the Bering Sea and northeast Pacific Ocean. Each number is uniquely associated with a species_name and a scientific name. | |
|
100
|
operation_dim$vessel_id | int2 | field database vessel id number | |
|
100
|
field_identified_taxonomy_dim$species_sub_category | varchar | mid-level taxonomic ranking | |
|
100
|
operation_dim_whid | int8 | Warehouse identifier to operation details | |
|
100
|
operation_dim$coast_guard_number | varchar | Coast Guard documentation number of vessel | |
|
100
|
most_recent_age_update_date_dim$month_of_year | int2 | numeric representation of month of year | |
|
100
|
hook_id | int4 | Field database hook identifier | |
|
100
|
field_identified_taxonomy_dim$hookandline_species_id | int4 | species identifier used by hook and line | |
|
100
|
best_available_taxonomy_dim$observer_species_id | int4 | species identifier used by the observer program | |
|
100
|
most_recent_taxonomy_update_date_dim$day_of_month | int2 | numeric representation of the day in month | |
|
100
|
drop_time_dim$hh24miss | bpchar | concatenation of military hour, minute, second, example 230415 equates to 23:04:15 | |
|
100
|
drop_latitude_dim$latitude_in_degrees | numeric | numeric representation of latitude in degrees | |
|
100
|
field_identified_taxonomy_dim$pacfin_spid | varchar | pacfin species id - many taxa may not have one of these | |
|
100
|
drop_longitude_dim$longitude_compass_direction | bpchar | longitude compass direction | |
|
100
|
operation_dim$captain_person_whid | int4 | person reference for the vessel captain | |
|
100
|
pacfin_spid | varchar | pacfin species id - many taxa may not have one of these | |
|
100
|
best_available_taxonomy_dim$tribe_60 | varchar | tribe name | |
|
100
|
operation_dim$state_registration_number | varchar | state registration number for the vessel | |
|
100
|
operation_dim$scientist_2_person_whid | int4 | person reference for the second scientist | |
|
100
|
site_dim$tide_station_longitude_whid | int4 | warehouse identifier to longitude details for site's nearest tide station | |
|
100
|
drop_latitude_dim$latitude_second_units | int2 | numeric representation of latitude that makes up the second unit only | |
|
100
|
hook_whid | int4 | Warehouse identifier to hook details | |
|
100
|
drop_sounder_depth_dim$depth_fathoms | numeric | depth low precision measurement in fathoms converted from meters measured to the tenth of a meter except for special fathom boundaries | |
|
100
|
operation_dim$operation_start_time_whid | int8 | start time reference for the operation | |
|
100
|
best_available_taxonomy_dim$grp_reg_depth_category | varchar | management grouping mostly for rockfishes (but could be assigned to any species): nearshore, shelf, or slope, or in future shallower shelf and deeper shelf | |
|
67
|
sex | bpchar | ||
|
100
|
best_available_taxonomy_dim$family_50 | varchar | family name | |
|
100
|
operation_dim$field_operation_seg_id | int8 | operation segment id reference to the field operational segment table | |
|
100
|
taxon_source | varchar | name of primary source used to get the measurement | |
|
100
|
drop_sounder_depth_dim$depth_meters | numeric | depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries) | |
|
100
|
site_dim$site_longitude_dd | numeric | site longitude in decimal degrees | |
|
100
|
otolith_number | varchar | Individual otolith tracking number | |
|
100
|
drop_longitude_whid | int4 | Warehouse identifier for the longitude drop to the second unit of measure | |
|
100
|
field_identified_taxonomy_dim$superorder_38 | varchar | superorder name | |
|
100
|
best_available_taxonomy_dim$genus_70 | varchar | genus name | |
|
100
|
drop_time_dim$record_type | varchar | time record or reason record is unavailable | |
|
100
|
operation_dim$return_date_whid | int8 | date reference that vessel returned for the defined leg or trip | |
|
100
|
angler_person_dim$first_name | varchar | first name of person | |
|
100
|
site_dim$inactive_date_whid | int8 | warehouse identifier for the date when the site went inactive | |
|
100
|
lab_maturity_detail_dim$functionally_mature_indicator | varchar | identifies the functional maturity of the individual | |
|
100
|
date_dim$full_date | timestamp | full date value | |
|
100
|
best_available_taxonomy_dim$suborder_42 | varchar | suborder name | |
|
100
|
best_available_taxonomy_dim$worms_aphiaid | int4 | WoRMS taxonomic identifier | |
|
100
|
drop_time_dim$period | bpchar | period of time | |
|
100
|
field_identified_taxonomy_dim$structure_source | varchar | Source of the taxonomic structure | |
|
100
|
operation_dim$operation_end_date_whid | int8 | end date reference for the operation | |
|
100
|
operation_dim$return_port_whid | int4 | port reference for return port | |
|
100
|
trawl_id | int8 | identifier for a sampling operation | |
|
100
|
hook_dim$record_type | varchar | hook record or reason record is unavailable | |
|
100
|
weight_kg | numeric | Individual weight in kilograms | |
|
100
|
sex_dim$record_type | varchar | latitude record type or reason record is unavailable | |
|
100
|
best_available_taxonomy_observation_detail_dim$record_type | varchar | observation detail record type or reason record is unavailable | |
|
100
|
disposition_dim$return_indicator | varchar | Indicates if returned to sea | |
|
100
|
field_identified_taxonomy_dim$phylum_20 | varchar | phylum name | |
|
100
|
best_available_taxonomy_dim$subspecies_82 | varchar | subspecies name | |
|
100
|
date_yyyymmdd | bpchar | text representation of year month day | |
|
100
|
site_dim$tide_station_latitude_whid | int4 | warehouse identifier to latitude details for site's nearest tide station | |
|
100
|
sampling_start_time_dim$record_type | varchar | time record or reason record is unavailable | |
|
100
|
drop_latitude_dim$latitude_compass_direction | bpchar | latitude compass direction | |
|
100
|
drop_longitude_dim$longitude_second_units | int2 | numeric representation of longitude that makes up the second unit only | |
|
100
|
field_identified_taxonomy_dim$acoustics_species_id | int4 | Species ID used in the acoustics program | |
|
100
|
field_identified_taxonomy_dim$genus_70 | varchar | genus name | |
|
100
|
most_recent_age_update_date_dim$month_abbrev | bpchar | three character representation of month in capital letters | |
|
100
|
date_dim$month_of_year | int2 | numeric representation of month of year | |
|
100
|
drop_time_dim$second | int2 | number of seconds in the minute | |
|
100
|
best_available_taxonomy_dim$superorder_38 | varchar | superorder name | |
|
100
|
most_recent_age_update_date_dim$month_name | varchar | text representation of month | |
|
100
|
site_dim$site_number | int4 | site identifier number | |
|
100
|
drop_latitude_dim$latitude_minute_units | int2 | numeric representation of latitude that makes up the minute unit only | |
|
100
|
field_identified_taxonomy_dim$record_type | varchar | record or reason record is unavailable | |
|
100
|
disposition_whid | int2 | Warehouse identifier to disposition details | |
|
100
|
angler_person_dim$full_name | varchar | full name in format of First and Last (Suffix) | |
|
100
|
best_available_taxonomy_dim$infraorder_44 | varchar | infraorder name | |
|
100
|
field_identified_taxonomy_dim$subfamily_52 | varchar | subfamily name | |
|
100
|
net_touchdown_time | time | military time representation of the time | |
|
100
|
sampling_end_hhmmss | bpchar | concatenation of military hour, minute, second, example 230415 equates to 23:04:15 | |
|
100
|
field_identified_taxonomy_dim$abbreviated_name | varchar | specialized common name, generally for a well-known species of fish such as ATF, LST, SST | |
|
100
|
best_available_taxonomy_dim$class_30 | varchar | class name | |
|
100
|
best_available_taxonomy_dim$acoustics_species_id | int4 | Species ID used in the acoustics program | |
|
100
|
most_recent_taxon_update | timestamp | full date value | |
|
100
|
sampling_start_time_dim$period | bpchar | period of time | |
|
100
|
sampling_end_time_dim$record_type | varchar | time record or reason record is unavailable | |
|
100
|
field_identified_taxonomy_dim$grp_reg_depth_category | varchar | management grouping mostly for rockfishes (but could be assigned to any species): nearshore, shelf, or slope, or in future shallower shelf and deeper shelf | |
|
100
|
site_dim$area_name | varchar | name of area site is located in | |
|
100
|
most_recent_taxonomy_update_date_whid | int8 | Warehouse identifier for most recent taxonomy update date | |
|
100
|
most_recent_age_update_date_dim$record_type | varchar | date, month, or year record or reason record is unavailable | |
|
100
|
drop_latitude_dim$named_parallel | varchar | name of parallel, boundary, or commonly used geograpical location | |
|
100
|
angler_person_whid | int4 | Warehouse identifier for the angler | |
|
100
|
lab_maturity_detail_dim$record_type | varchar | lab maturity detail record or reason record is unavailable | |
|
100
|
best_available_taxonomy_observation_detail_whid | int4 | Warehouse identifier to taxonomy observation detail | |
|
100
|
drop_latitude_whid | int4 | Warehouse identifier for the latitude drop to the second unit of measure | |
|
100
|
date_dim$year | int4 | numeric representation of year | |
|
100
|
best_available_taxonomy_dim$infraclass_34 | varchar | infraclass name | |
|
100
|
field_identified_taxonomy_dim$subphylum_22 | varchar | subphylum name | |
|
100
|
best_available_taxonomy_dim$phylum_20 | varchar | phylum name | |
|
100
|
best_available_taxonomy_dim$itis_taxonomic_serial_no | int4 | ITIS taxonomic identifier | |
|
100
|
drop_latitude_dim$record_type | varchar | latitude record type or reason record is unavailable | |
|
100
|
sampling_end_time_dim$period | bpchar | period of time | |
|
100
|
tow_start_timestamp | timestamp | operation start date timestamp | |
|
100
|
site_dim$distance_to_port_nm | numeric | distance from site to nearest port in nautical miles | |
|
100
|
site_dim$site_latitude_dd | numeric | site latitude in decimal degrees | |
|
100
|
drop_longitude_dim$longitude_in_degrees | numeric | numeric representation of longitude in decimal degrees | |
|
100
|
site_dim$site_latitude_whid | int4 | warehouse identifier to latitude details for site | |
|
100
|
drop_sounder_depth_dim$boundary_indicator | varchar | depth boundry indicator identifying ifp boundary marks | |
|
100
|
field_identified_taxonomy_dim$superfamily_48 | varchar | superfamily name | |
|
100
|
most_recent_taxonomy_update_date_dim$month_abbrev | bpchar | three character representation of month in capital letters | |
|
100
|
date_dim$record_type | varchar | date, month, or year record or reason record is unavailable | |
|
100
|
drop_sounder_depth_dim$record_type | varchar | depth record or reason record is unavailable | |
|
100
|
operation_dim$operation_type | varchar | type of operation | |
|
100
|
best_available_taxonomy_whid | int4 | Warehouse identifier to best available taxonomy | |
|
100
|
best_available_taxonomy_dim$superclass_28 | varchar | superclass name | |
|
100
|
operation_dim$scientist_1_person_whid | int4 | person reference for the first scientist | |
|
100
|
operation_dim$record_type | varchar | operation record or reason record is unavailable | |
|
100
|
best_available_taxonomy_observation_detail_dim$observation_type | varchar | the type of observation | |
|
100
|
sampling_end_time_dim$military_hour | int2 | military representation of the hour | |
|
100
|
vessel | varchar | name of the vessel used for the operation | |
|
100
|
hook_dim$hook_result | varchar | The result of using the hook | |
|
100
|
field_identified_taxonomy_dim$family_50 | varchar | family name | |
|
100
|
operation_dim$observer_program | varchar | description of the observer program | |
|
100
|
most_recent_age_update_date_dim$day_of_month | int2 | numeric representation of the day in month | |
|
100
|
field_identified_taxonomy_dim$infraclass_34 | varchar | infraclass name | |
|
100
|
site_whid | int4 | Warehouse identifier to site details | |
|
100
|
fish_note | varchar | Fish note details | |
|
100
|
program | varchar | type of fram program | |
|
100
|
best_available_taxonomy_dim$abbreviated_name | varchar | specialized common name, generally for a well-known species of fish such as ATF, LST, SST | |
|
100
|
field_identified_taxonomy_dim$subspecies_82 | varchar | subspecies name | |
|
100
|
operation_dim$operation_start_date_whid | int8 | start date reference for the operation | |
|
67
|
sex_dim$sex | varchar | ||
|
100
|
sex_whid | int2 | Warehouse identifier to sex details | |
|
100
|
operation_dim$scientist_4_person_whid | int4 | person reference for the fourth scientist | |
|
100
|
operation_dim$fpc_person_whid | int4 | person reference for the FPC | |
|
100
|
drop_longitude_dim$longitude_degree_units | int2 | numeric representation of longitude that makes up the degree unit only | |
|
100
|
lab_maturity_detail_dim$functionally_mature_certain_indicator | varchar | identifies the certainty of the functionally mature evaluation | |
|
100
|
best_available_taxonomy_dim$record_type | varchar | record or reason record is unavailable | |
|
100
|
site_dim$record_type | varchar | site record or reason record is unavailable | |
|
100
|
disposition_dim$record_type | varchar | Type of record | |
|
100
|
best_available_taxonomy_dim$pacfin_nom_spid | varchar | PacFIN nominal species identifier | |
|
100
|
performance | varchar | performance of the operation | |
|
100
|
best_available_taxonomy_dim$norpac_species_id | int4 | A three-digit numeric code assigned by the NMFS Observer Program to each different marine organism expected to be seen in the Bering Sea and northeast Pacific Ocean. Each number is uniquely associated with a species_name and a scientific name. | |
|
100
|
sampling_end_time_dim$hour | int2 | standard representation of the hour | |
|
100
|
angler_person_dim$role | varchar | role taken during an operation | |
|
100
|
lab_maturity_detail_dim$biologically_mature_certain_indicator | varchar | identifies the certainty of the biological maturity | |
|
100
|
species_subcategory | varchar | mid-level taxonomic ranking | |
|
100
|
sampling_start_time_whid | int4 | Warehouse identifier for the sampling start time of the site visit | |
|
100
|
field_identified_taxonomy_dim$infraorder_44 | varchar | infraorder name | |
|
100
|
hook_dim$hook_number | int2 | The hook number on the line | |
|
100
|
disposition_dim$disposition | varchar | Identifies condition | |
|
100
|
operation_dim$ifq_account_number | varchar | unique number assigned to user accounts in the Vessel Accounting Database | |
|
100
|
sampling_end_time_whid | int4 | Warehouse identifier for the sampling end time of the site visit | |
|
100
|
best_available_taxonomy_dim$subfamily_52 | varchar | subfamily name | |
|
100
|
most_recent_age_update_date_whid | int8 | Warehouse identifier for most recent age update date | |
|
100
|
lab_maturity_detail_dim$biologically_mature_indicator | varchar | identifies biological maturity of the individual | |
|
100
|
fin_clip_number | varchar | Individual fin clip tracking number | |
|
100
|
hook_dim$gear_performance | varchar | Gear performance | |
|
100
|
lab_maturity_detail_whid | int4 | Warehouse identifier to lab maturity details | |
|
100
|
leg | int2 | leg number of the survey | |
|
100
|
field_identified_taxonomy_dim$kingdom_10 | varchar | kingdom name | |
|
100
|
field_identified_taxonomy_dim$worms_aphiaid | int4 | WoRMS taxonomic identifier | |
|
100
|
most_recent_age_update_date_dim$yyyymmdd | bpchar | text representation of year month day | |
|
100
|
field_identified_taxonomy_dim$itis_taxonomic_serial_no | int4 | ITIS taxonomic identifier | |
|
100
|
sampling_start_time_dim$military_hour | int2 | military representation of the hour | |
|
100
|
age_years | int2 | Individual determined age in years | |
|
100
|
angler_person_dim$record_type | varchar | person record or reason record is unavailable | |
|
100
|
inclusion_whid | int4 | Warehouse identifier for what to include in analysis | |
|
100
|
operation_dim$departure_port_whid | int4 | port reference for the departure port | |
|
100
|
field_identified_taxonomy_dim$pacfin_nom_spid | varchar | PacFIN nominal species identifier | |
|
100
|
field_identified_taxonomy_dim$common_name | varchar | only one broadly used common name is supported by this design. If the common name is not fairly universally used or is used by more than one taxon this should be left null | |
|
100
|
field_identified_taxonomy_dim$species_category | varchar | upper-level taxonomic ranking | |
|
100
|
drop_longitude_dim$record_type | varchar | longitude record type or reason record is unavailable | |
|
100
|
drop_sounder_depth_whid | int4 | Warehouse identifier to the drop depth from the sounder sensor to the tenth of a meter unit | |
|
100
|
field_identified_taxonomy_whid | int4 | Warehouse identifier to field identified taxonomy | |
|
100
|
drop_time_dim$military_hour | int2 | military representation of the hour | |
|
100
|
sampling_start_hhmmss | bpchar | concatenation of military hour, minute, second, example 230415 equates to 23:04:15 | |
|
100
|
individual_tracking_id | int4 | Field individual identification number | |
|
100
|
most_recent_age_update | timestamp | full date value | |
|
100
|
sampling_start_time_dim$minute | int2 | number of minutes in the hour | |
|
100
|
inclusion_dim$hook_inclusion_indicator | varchar | indicates if hook should be included | |
|
100
|
angler_person_dim$nick_name | varchar | nickname of person | |
|
100
|
operation_dim$trip_id | int4 | trip identifier number | |
|
100
|
species_category | varchar | upper-level taxonomic ranking | |
|
100
|
field_identified_taxonomy_dim$scientific_name_taxonomic_level | varchar | name of the lowest taxonomic level used to define scientific name | |
|
100
|
best_available_taxonomy_observation_detail_dim$method_description | varchar | description of how the observation was taken | |
|
100
|
scientific_name | varchar | scientific name generally composed of the genus and species name and subspecies name if available, but may be the highest taxonomic level | |
|
100
|
sampling_end_time_dim$second | int2 | number of seconds in the minute | |
|
100
|
inclusion_dim$drop_inclusion_indicator | varchar | indicates if drop should be included | |
|
100
|
field_identified_taxonomy_dim$trawl_survey_species_id | int4 | species identifier used by the trawl survey | |
|
100
|
operation_dim$scientist_3_person_whid | int4 | person reference for the third scientist | |
|
100
|
site_dim$site_longitude_whid | int4 | warehouse identifier to longitude details for site | |
|
100
|
date_whid | int8 | Warehouse identifier to date details | |
|
100
|
drop_time_dim$minute | int2 | number of minutes in the hour | |
|
100
|
sampling_end_time_dim$minute | int2 | number of minutes in the hour | |
|
100
|
sampling_start_time_dim$hour | int2 | standard representation of the hour | |
|
100
|
field_identified_taxonomy_dim$scientific_name | varchar | scientific name generally composed of the genus and species name and subspecies name if available, but may be the highest taxonomic level | |
|
100
|
field_identified_taxonomy_dim$order_40 | varchar | order name | |
|
100
|
drop_longitude_dim$longitude_minute_units | int2 | numeric representation of longitude that makes up the minute unit only | |
|
100
|
best_available_taxonomy_dim$grp_nonstandard_taxon_99 | varchar | a pseudo taxonomic level that has a common usage such as Invertebrata, Pisces (Fish). This has been designed to allow for only one level of para- or poly-phyletic group that is the terminus of the definition (it may be associated with a higher level taxonomic hierarchy). Consequently a definition such as Fish->Roundfish would not be supported with this design | |
|
100
|
most_recent_taxonomy_update_date_dim$year | int4 | numeric representation of year | |
|
100
|
most_recent_taxonomy_update_date_dim$month_of_year | int2 | numeric representation of month of year | |
|
100
|
best_available_taxonomy_dim$subphylum_22 | varchar | subphylum name | |
|
100
|
year | int2 | operation year | |
|
100
|
field_identified_taxonomy_dim$tribe_60 | varchar | tribe name | |
|
100
|
best_available_taxonomy_dim$order_40 | varchar | order name | |
|
100
|
operation_dim$operation_end_time_whid | int8 | end time reference for the operation | |
|
100
|
tow | int2 | operation number of the survey | |
|
100
|
common_name | varchar | only one broadly used common name is supported by this design. If the common name is not fairly universally used or is used by more than one taxon this should be left null | |
|
100
|
field_identified_taxonomy_dim$superclass_28 | varchar | superclass name | |
|
100
|
site_dim$cowcod_conservation_area_indicator | varchar | indicates if site falls within the cowcod conservation area | |
|
100
|
best_available_taxonomy_dim$subclass_32 | varchar | subclass name | |
|
100
|
project | varchar | project name | |
|
100
|
field_identified_taxonomy_dim$subclass_32 | varchar | subclass name | |
|
100
|
site_dim$tide_station_noaa_id | varchar | tide station id according to NOAA's Tides and Currents site | |
|
100
|
pass | int4 | pass number of the survey | |
|
100
|
length_cm | numeric | Individual length in centimeters | |
|
100
|
inclusion_dim$record_type | varchar | inclusion record or reason record is unavailable | |
|
100
|
best_available_taxonomy_dim$species_80 | varchar | species name | |
|
100
|
best_available_taxonomy_dim$structure_source | varchar | Source of the taxonomic structure | |
|
100
|
drop_latitude_dim$latitude_in_degree_minute_second | varchar | string representation of latitude in degrees, minutes, and seconds for example 4525'01" | |
|
100
|
operation_dim$limited_entry_permit_number | bpchar | federal limited entry groundfish permit issued to fish in waters off of Washington, Oregon, and California | |
|
100
|
angler_person_dim$middle_initial | bpchar | middle initial of person | |
|
100
|
operation_dim$departure_date_whid | int8 | date reference that vessel departed for the defined leg or trip | |
|
100
|
site_dim$cdfgblock | int4 | CDFG Block Numbers that the sites fall within | |
|
100
|
most_recent_taxonomy_update_date_dim$record_type | varchar | date, month, or year record or reason record is unavailable | |
|
100
|
net_liftoff_time | time | military time representation of the time | |
|
100
|
angler_person_dim$last_name | varchar | last name of person | |
|
100
|
drop_time_dim$time | time | military time representation of the time | |
|
100
|
field_identified_taxonomy_dim$suborder_42 | varchar | suborder name | |
|
100
|
date_dim$month_name | varchar | text representation of month | |
|
100
|
drop_longitude_dim$longitude_in_degree_minute_second | varchar | string representation of longitude in degrees, minutes, and seconds for example 4525'01" | |
|
100
|
field_identified_taxonomy_dim$class_30 | varchar | class name | |
|
100
|
inclusion_dim$site_inclusion_indicator | varchar | indicates if site should be included | |
|
100
|
field_identified_taxonomy_dim$species_80 | varchar | species name | |
|
100
|
drop_latitude_dim$latitude_degree_units | int2 | numeric representation of latitude that makes up the degree unit only |
Attribute Details
drop_time_dim$hour
CC ID: 377682
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
standard representation of the hour |
| Unit of Measure: | hr |
| Allowed Values: | 0-12 |
sampling_start_time_dim$second
CC ID: 377683
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
number of seconds in the minute |
| Unit of Measure: | sec |
| Allowed Values: | 0-60 |
best_available_taxonomy_observation_detail_dim$measurement_procurement
CC ID: 377684
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
how the measurement was achieved |
| Allowed Values: | NA, Calculated, Estimated, Observed, Measured, Not Documented |
most_recent_age_update_date_dim$year
CC ID: 377685
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of year |
| Allowed Values: | 1978+ |
best_available_taxonomy_dim$hookandline_species_id
CC ID: 377686
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
species identifier used by hook and line |
best_available_taxonomy_dim$superfamily_48
CC ID: 377687
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
superfamily name |
most_recent_taxonomy_update_date_dim$month_name
CC ID: 377688
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of month |
| Allowed Values: | January, February, March, April, May, June, July, August, September, October, November, December |
field_identified_taxonomy_dim$grp_nonstandard_taxon_99
CC ID: 377689
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
a pseudo taxonomic level that has a common usage such as Invertebrata, Pisces (Fish). This has been designed to allow for only one level of para- or poly-phyletic group that is the terminus of the definition (it may be associated with a higher level taxonomic hierarchy). Consequently a definition such as Fish->Roundfish would not be supported with this design |
best_available_taxonomy_dim$kingdom_10
CC ID: 377690
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
kingdom name |
best_available_taxonomy_dim$trawl_survey_species_id
CC ID: 377691
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
species identifier used by the trawl survey |
drop_time_whid
CC ID: 377692
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier for the drop time |
site_dim$tide_station_name
CC ID: 377693
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 60 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
name of nearest tide station |
taxon_rank
CC ID: 377694
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 15 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
name of the lowest taxonomic level used to define scientific name |
most_recent_taxonomy_update_date_dim$yyyymmdd
CC ID: 377695
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of year month day |
best_available_taxonomy_observation_detail_dim$means_of_calculation
CC ID: 377696
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
describes how the measurement was calculated |
| Allowed Values: | Observation Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
date_dim$day_of_month
CC ID: 377697
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of the day in month |
| Allowed Values: | 1-31 |
date_dim$month_abbrev
CC ID: 377698
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
three character representation of month in capital letters |
| Allowed Values: | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
tow_end_timestamp
CC ID: 377699
| Data Storage Type: | timestamp |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
operation end date timestamp |
field_identified_taxonomy_dim$observer_species_id
CC ID: 377700
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
species identifier used by the observer program |
field_identified_taxonomy_dim$norpac_species_id
CC ID: 377701
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
A three-digit numeric code assigned by the NMFS Observer Program to each different marine organism expected to be seen in the Bering Sea and northeast Pacific Ocean. Each number is uniquely associated with a species_name and a scientific name. |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
operation_dim$vessel_id
CC ID: 377702
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
field database vessel id number |
field_identified_taxonomy_dim$species_sub_category
CC ID: 377703
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 40 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
mid-level taxonomic ranking |
| Allowed Values: | rockfish, flatfish, shark, crab, NA |
operation_dim_whid
CC ID: 377704
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier to operation details |
operation_dim$coast_guard_number
CC ID: 377705
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Coast Guard documentation number of vessel |
most_recent_age_update_date_dim$month_of_year
CC ID: 377706
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of month of year |
| Allowed Values: | 1-12 |
hook_id
CC ID: 377707
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Field database hook identifier |
field_identified_taxonomy_dim$hookandline_species_id
CC ID: 377708
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
species identifier used by hook and line |
best_available_taxonomy_dim$observer_species_id
CC ID: 377709
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
species identifier used by the observer program |
most_recent_taxonomy_update_date_dim$day_of_month
CC ID: 377710
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of the day in month |
| Allowed Values: | 1-31 |
drop_time_dim$hh24miss
CC ID: 377711
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
drop_latitude_dim$latitude_in_degrees
CC ID: 377712
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Status: | Active |
| Description: |
numeric representation of latitude in degrees |
| Unit of Measure: | dd |
| Allowed Values: | -90 to 90 |
field_identified_taxonomy_dim$pacfin_spid
CC ID: 377713
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
pacfin species id - many taxa may not have one of these |
drop_longitude_dim$longitude_compass_direction
CC ID: 377714
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
longitude compass direction |
| Allowed Values: | E, W |
operation_dim$captain_person_whid
CC ID: 377715
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
person reference for the vessel captain |
pacfin_spid
CC ID: 377716
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
pacfin species id - many taxa may not have one of these |
best_available_taxonomy_dim$tribe_60
CC ID: 377717
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
tribe name |
operation_dim$state_registration_number
CC ID: 377718
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
state registration number for the vessel |
operation_dim$scientist_2_person_whid
CC ID: 377719
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
person reference for the second scientist |
site_dim$tide_station_longitude_whid
CC ID: 377720
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
warehouse identifier to longitude details for site's nearest tide station |
drop_latitude_dim$latitude_second_units
CC ID: 377721
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of latitude that makes up the second unit only |
| Unit of Measure: | sec |
| Allowed Values: | 0-60 |
hook_whid
CC ID: 377722
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier to hook details |
drop_sounder_depth_dim$depth_fathoms
CC ID: 377723
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Status: | Active |
| Description: |
depth low precision measurement in fathoms converted from meters measured to the tenth of a meter except for special fathom boundaries |
| Unit of Measure: | fth |
operation_dim$operation_start_time_whid
CC ID: 377724
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
start time reference for the operation |
best_available_taxonomy_dim$grp_reg_depth_category
CC ID: 377725
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
management grouping mostly for rockfishes (but could be assigned to any species): nearshore, shelf, or slope, or in future shallower shelf and deeper shelf |
sex
CC ID: 377726
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
best_available_taxonomy_dim$family_50
CC ID: 377727
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
family name |
operation_dim$field_operation_seg_id
CC ID: 377728
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
operation segment id reference to the field operational segment table |
taxon_source
CC ID: 377729
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
name of primary source used to get the measurement |
| Allowed Values: | Angler, FPC, Genetics, Lab Exam, Large Scale, Morphometrics, Morphometrics + Genetics, NA, Quality Assurance, Retrospective Review, Taxon Rank Upped, Whole Organism |
drop_sounder_depth_dim$depth_meters
CC ID: 377730
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Status: | Active |
| Description: |
depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries) |
| Unit of Measure: | m |
| Allowed Values: | 0-1500 |
site_dim$site_longitude_dd
CC ID: 377731
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Status: | Active |
| Description: |
site longitude in decimal degrees |
| Unit of Measure: | dd |
otolith_number
CC ID: 377732
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Individual otolith tracking number |
drop_longitude_whid
CC ID: 377733
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier for the longitude drop to the second unit of measure |
field_identified_taxonomy_dim$superorder_38
CC ID: 377734
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
superorder name |
best_available_taxonomy_dim$genus_70
CC ID: 377735
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
genus name |
drop_time_dim$record_type
CC ID: 377736
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
time record or reason record is unavailable |
| Allowed Values: | Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
operation_dim$return_date_whid
CC ID: 377737
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
date reference that vessel returned for the defined leg or trip |
angler_person_dim$first_name
CC ID: 377738
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
first name of person |
site_dim$inactive_date_whid
CC ID: 377739
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
warehouse identifier for the date when the site went inactive |
lab_maturity_detail_dim$functionally_mature_indicator
CC ID: 377740
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
identifies the functional maturity of the individual |
| Allowed Values: | Functionally Mature, Not Functionally Mature, NA |
date_dim$full_date
CC ID: 377741
| Data Storage Type: | timestamp |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
full date value |
best_available_taxonomy_dim$suborder_42
CC ID: 377742
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
suborder name |
best_available_taxonomy_dim$worms_aphiaid
CC ID: 377743
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
WoRMS taxonomic identifier |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
drop_time_dim$period
CC ID: 377744
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
period of time |
| Allowed Values: | AM, PM |
field_identified_taxonomy_dim$structure_source
CC ID: 377745
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Source of the taxonomic structure |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
operation_dim$operation_end_date_whid
CC ID: 377746
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
end date reference for the operation |
operation_dim$return_port_whid
CC ID: 377747
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
port reference for return port |
trawl_id
CC ID: 377748
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
identifier for a sampling operation |
hook_dim$record_type
CC ID: 377749
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
hook record or reason record is unavailable |
| Allowed Values: | Hook, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
weight_kg
CC ID: 377750
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Precision: | 2 |
| Status: | Active |
| Description: |
Individual weight in kilograms |
sex_dim$record_type
CC ID: 377751
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
latitude record type or reason record is unavailable |
| Unit of Measure: | NA |
| Allowed Values: | Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
best_available_taxonomy_observation_detail_dim$record_type
CC ID: 377752
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
observation detail record type or reason record is unavailable |
| Allowed Values: | Observation Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
disposition_dim$return_indicator
CC ID: 377753
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicates if returned to sea |
| Allowed Values: | Returned to Sea, Not Returned to Sea, NA |
field_identified_taxonomy_dim$phylum_20
CC ID: 377754
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
phylum name |
best_available_taxonomy_dim$subspecies_82
CC ID: 377755
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
subspecies name |
date_yyyymmdd
CC ID: 377756
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of year month day |
site_dim$tide_station_latitude_whid
CC ID: 377757
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
warehouse identifier to latitude details for site's nearest tide station |
sampling_start_time_dim$record_type
CC ID: 377758
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
time record or reason record is unavailable |
| Allowed Values: | Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
drop_latitude_dim$latitude_compass_direction
CC ID: 377759
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
latitude compass direction |
| Unit of Measure: | NA |
| Allowed Values: | N, S |
drop_longitude_dim$longitude_second_units
CC ID: 377760
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of longitude that makes up the second unit only |
| Unit of Measure: | sec |
| Allowed Values: | 0-59 |
field_identified_taxonomy_dim$acoustics_species_id
CC ID: 377761
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Species ID used in the acoustics program |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
field_identified_taxonomy_dim$genus_70
CC ID: 377762
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
genus name |
most_recent_age_update_date_dim$month_abbrev
CC ID: 377763
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
three character representation of month in capital letters |
| Allowed Values: | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
date_dim$month_of_year
CC ID: 377764
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of month of year |
| Allowed Values: | 1-12 |
drop_time_dim$second
CC ID: 377765
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
number of seconds in the minute |
| Unit of Measure: | sec |
| Allowed Values: | 0-60 |
best_available_taxonomy_dim$superorder_38
CC ID: 377766
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
superorder name |
most_recent_age_update_date_dim$month_name
CC ID: 377767
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of month |
| Allowed Values: | January, February, March, April, May, June, July, August, September, October, November, December |
site_dim$site_number
CC ID: 377768
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
site identifier number |
drop_latitude_dim$latitude_minute_units
CC ID: 377769
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of latitude that makes up the minute unit only |
| Unit of Measure: | min |
| Allowed Values: | 0-60 |
field_identified_taxonomy_dim$record_type
CC ID: 377770
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
record or reason record is unavailable |
| Allowed Values: | Taxonomy, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
disposition_whid
CC ID: 377771
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier to disposition details |
angler_person_dim$full_name
CC ID: 377772
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 100 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
full name in format of First and Last (Suffix) |
best_available_taxonomy_dim$infraorder_44
CC ID: 377773
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
infraorder name |
field_identified_taxonomy_dim$subfamily_52
CC ID: 377774
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
subfamily name |
net_touchdown_time
CC ID: 377775
| Data Storage Type: | time |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
military time representation of the time |
sampling_end_hhmmss
CC ID: 377776
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
field_identified_taxonomy_dim$abbreviated_name
CC ID: 377777
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
specialized common name, generally for a well-known species of fish such as ATF, LST, SST |
best_available_taxonomy_dim$class_30
CC ID: 377778
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
class name |
best_available_taxonomy_dim$acoustics_species_id
CC ID: 377779
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Species ID used in the acoustics program |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
most_recent_taxon_update
CC ID: 377780
| Data Storage Type: | timestamp |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
full date value |
sampling_start_time_dim$period
CC ID: 377781
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
period of time |
| Allowed Values: | AM, PM |
sampling_end_time_dim$record_type
CC ID: 377782
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
time record or reason record is unavailable |
| Allowed Values: | Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
field_identified_taxonomy_dim$grp_reg_depth_category
CC ID: 377783
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
management grouping mostly for rockfishes (but could be assigned to any species): nearshore, shelf, or slope, or in future shallower shelf and deeper shelf |
site_dim$area_name
CC ID: 377784
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
name of area site is located in |
most_recent_taxonomy_update_date_whid
CC ID: 377785
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier for most recent taxonomy update date |
most_recent_age_update_date_dim$record_type
CC ID: 377786
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
date, month, or year record or reason record is unavailable |
| Allowed Values: | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
drop_latitude_dim$named_parallel
CC ID: 377787
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
name of parallel, boundary, or commonly used geograpical location |
| Unit of Measure: | NA |
| Allowed Values: | any |
angler_person_whid
CC ID: 377788
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier for the angler |
lab_maturity_detail_dim$record_type
CC ID: 377789
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
lab maturity detail record or reason record is unavailable |
| Allowed Values: | Lab Maturity Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
best_available_taxonomy_observation_detail_whid
CC ID: 377790
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier to taxonomy observation detail |
drop_latitude_whid
CC ID: 377791
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier for the latitude drop to the second unit of measure |
date_dim$year
CC ID: 377792
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of year |
| Allowed Values: | 1978+ |
best_available_taxonomy_dim$infraclass_34
CC ID: 377793
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
infraclass name |
field_identified_taxonomy_dim$subphylum_22
CC ID: 377794
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
subphylum name |
best_available_taxonomy_dim$phylum_20
CC ID: 377795
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
phylum name |
best_available_taxonomy_dim$itis_taxonomic_serial_no
CC ID: 377796
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
ITIS taxonomic identifier |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
drop_latitude_dim$record_type
CC ID: 377797
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
latitude record type or reason record is unavailable |
| Unit of Measure: | NA |
| Allowed Values: | Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
sampling_end_time_dim$period
CC ID: 377798
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
period of time |
| Allowed Values: | AM, PM |
tow_start_timestamp
CC ID: 377799
| Data Storage Type: | timestamp |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
operation start date timestamp |
site_dim$distance_to_port_nm
CC ID: 377800
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 1 |
| Status: | Active |
| Description: |
distance from site to nearest port in nautical miles |
| Unit of Measure: | m |
site_dim$site_latitude_dd
CC ID: 377801
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Status: | Active |
| Description: |
site latitude in decimal degrees |
| Unit of Measure: | dd |
drop_longitude_dim$longitude_in_degrees
CC ID: 377802
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Status: | Active |
| Description: |
numeric representation of longitude in decimal degrees |
| Unit of Measure: | dd |
| Allowed Values: | -180 to 180 |
site_dim$site_latitude_whid
CC ID: 377803
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
warehouse identifier to latitude details for site |
drop_sounder_depth_dim$boundary_indicator
CC ID: 377804
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 40 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
depth boundry indicator identifying ifp boundary marks |
| Allowed Values: | IFP Boundary Depth, Standard Contour Depth, NA |
field_identified_taxonomy_dim$superfamily_48
CC ID: 377805
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
superfamily name |
most_recent_taxonomy_update_date_dim$month_abbrev
CC ID: 377806
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
three character representation of month in capital letters |
| Allowed Values: | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
date_dim$record_type
CC ID: 377807
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
date, month, or year record or reason record is unavailable |
| Allowed Values: | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
drop_sounder_depth_dim$record_type
CC ID: 377808
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
depth record or reason record is unavailable |
| Allowed Values: | Depth, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
operation_dim$operation_type
CC ID: 377809
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
type of operation |
| Allowed Values: | CTD Cast, Drop, Experiment, Search, Trawl, VPR Tow, [null] |
best_available_taxonomy_whid
CC ID: 377810
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier to best available taxonomy |
best_available_taxonomy_dim$superclass_28
CC ID: 377811
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
superclass name |
operation_dim$scientist_1_person_whid
CC ID: 377812
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
person reference for the first scientist |
operation_dim$record_type
CC ID: 377813
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
operation record or reason record is unavailable |
| Allowed Values: | Operation, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
best_available_taxonomy_observation_detail_dim$observation_type
CC ID: 377814
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
the type of observation |
| Allowed Values: | NA, width, length, total_catch_weight, taxonomy, etc |
sampling_end_time_dim$military_hour
CC ID: 377815
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
military representation of the hour |
| Allowed Values: | 0-24 |
vessel
CC ID: 377816
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
name of the vessel used for the operation |
| Allowed Values: | Aggressor, Amy Lynn, BJ Thomas, Blue Horizon, Captain Jack, Coast Pride, Excalibur, Last Straw, Limit Stalker, Mirage, Miss Leona, Morning Star, Ms. Julie, Noahs Ark, Pacific Sun IV, Raven, Sea Eagle, Toronado |
hook_dim$hook_result
CC ID: 377817
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The result of using the hook |
| Allowed Values: | No Bait On Hook, Bait Back On Hook, No Hook, Multiple Hook, Fish, Angler Did Not Drop |
field_identified_taxonomy_dim$family_50
CC ID: 377818
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
family name |
operation_dim$observer_program
CC ID: 377819
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 150 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
description of the observer program |
most_recent_age_update_date_dim$day_of_month
CC ID: 377820
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of the day in month |
| Allowed Values: | 1-31 |
field_identified_taxonomy_dim$infraclass_34
CC ID: 377821
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
infraclass name |
site_whid
CC ID: 377822
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier to site details |
fish_note
CC ID: 377823
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 1000 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Fish note details |
program
CC ID: 377824
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
type of fram program |
| Allowed Values: | Bottom Trawl, Hook and Line |
best_available_taxonomy_dim$abbreviated_name
CC ID: 377825
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
specialized common name, generally for a well-known species of fish such as ATF, LST, SST |
field_identified_taxonomy_dim$subspecies_82
CC ID: 377826
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
subspecies name |
operation_dim$operation_start_date_whid
CC ID: 377827
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
start date reference for the operation |
sex_dim$sex
CC ID: 377828
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
sex_whid
CC ID: 377829
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier to sex details |
operation_dim$scientist_4_person_whid
CC ID: 377830
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
person reference for the fourth scientist |
operation_dim$fpc_person_whid
CC ID: 377831
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
person reference for the FPC |
drop_longitude_dim$longitude_degree_units
CC ID: 377832
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of longitude that makes up the degree unit only |
| Unit of Measure: | deg |
| Allowed Values: | -180 to 180 |
lab_maturity_detail_dim$functionally_mature_certain_indicator
CC ID: 377833
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 40 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
identifies the certainty of the functionally mature evaluation |
| Allowed Values: | Functionally Mature Certain, Not Functionally Mature Certain, NA |
best_available_taxonomy_dim$record_type
CC ID: 377834
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
record or reason record is unavailable |
| Allowed Values: | Taxonomy, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
site_dim$record_type
CC ID: 377835
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
site record or reason record is unavailable |
| Allowed Values: | Site, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
disposition_dim$record_type
CC ID: 377836
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Type of record |
| Allowed Values: | Disposition, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
best_available_taxonomy_dim$pacfin_nom_spid
CC ID: 377837
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
PacFIN nominal species identifier |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
performance
CC ID: 377838
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
performance of the operation |
| Allowed Values: | Insufficient Information, Indeterminate, Satisfactory, Trawlable, Untrawlable, Unsatisfactory, [null] |
best_available_taxonomy_dim$norpac_species_id
CC ID: 377839
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
A three-digit numeric code assigned by the NMFS Observer Program to each different marine organism expected to be seen in the Bering Sea and northeast Pacific Ocean. Each number is uniquely associated with a species_name and a scientific name. |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
sampling_end_time_dim$hour
CC ID: 377840
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
standard representation of the hour |
| Unit of Measure: | hr |
| Allowed Values: | 0-12 |
angler_person_dim$role
CC ID: 377841
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
role taken during an operation |
| Allowed Values: | Captain, 2nd Captain, FPC, Cook, Scientist, Deck Hand |
lab_maturity_detail_dim$biologically_mature_certain_indicator
CC ID: 377842
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 40 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
identifies the certainty of the biological maturity |
| Allowed Values: | Biologically Mature Certain, Not Biologically Mature Certain, NA |
species_subcategory
CC ID: 377843
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 40 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
mid-level taxonomic ranking |
| Allowed Values: | rockfish, flatfish, shark, crab, NA |
sampling_start_time_whid
CC ID: 377844
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier for the sampling start time of the site visit |
field_identified_taxonomy_dim$infraorder_44
CC ID: 377845
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
infraorder name |
hook_dim$hook_number
CC ID: 377846
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
The hook number on the line |
| Allowed Values: | 1-5 |
disposition_dim$disposition
CC ID: 377847
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Identifies condition |
| Allowed Values: | Live, Dead, NA |
operation_dim$ifq_account_number
CC ID: 377848
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
unique number assigned to user accounts in the Vessel Accounting Database |
sampling_end_time_whid
CC ID: 377849
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier for the sampling end time of the site visit |
best_available_taxonomy_dim$subfamily_52
CC ID: 377850
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
subfamily name |
most_recent_age_update_date_whid
CC ID: 377851
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier for most recent age update date |
lab_maturity_detail_dim$biologically_mature_indicator
CC ID: 377852
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
identifies biological maturity of the individual |
| Allowed Values: | Biologically Mature, Not Biologically Mature, NA |
fin_clip_number
CC ID: 377853
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 5 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Individual fin clip tracking number |
hook_dim$gear_performance
CC ID: 377854
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Gear performance |
| Allowed Values: | No Problems, Lost Sinker, Minor Tangle, Major Tangle, Lost Gangion, Lost Hook(s), Missing Time, Multiple Hook, Gear Not Deployed |
lab_maturity_detail_whid
CC ID: 377855
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier to lab maturity details |
leg
CC ID: 377856
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
leg number of the survey |
| Allowed Values: | 1,2,3,4,5,6,7,8 |
field_identified_taxonomy_dim$kingdom_10
CC ID: 377857
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
kingdom name |
field_identified_taxonomy_dim$worms_aphiaid
CC ID: 377858
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
WoRMS taxonomic identifier |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
most_recent_age_update_date_dim$yyyymmdd
CC ID: 377859
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of year month day |
field_identified_taxonomy_dim$itis_taxonomic_serial_no
CC ID: 377860
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
ITIS taxonomic identifier |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
sampling_start_time_dim$military_hour
CC ID: 377861
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
military representation of the hour |
| Allowed Values: | 0-24 |
age_years
CC ID: 377862
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Individual determined age in years |
angler_person_dim$record_type
CC ID: 377863
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
person record or reason record is unavailable |
| Allowed Values: | Person, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
inclusion_whid
CC ID: 377864
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier for what to include in analysis |
operation_dim$departure_port_whid
CC ID: 377865
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
port reference for the departure port |
field_identified_taxonomy_dim$pacfin_nom_spid
CC ID: 377866
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
PacFIN nominal species identifier |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
field_identified_taxonomy_dim$common_name
CC ID: 377867
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
only one broadly used common name is supported by this design. If the common name is not fairly universally used or is used by more than one taxon this should be left null |
field_identified_taxonomy_dim$species_category
CC ID: 377868
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 40 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
upper-level taxonomic ranking |
| Allowed Values: | fish, invertebrate, mammal, seabird, reptile, nonspecific organics, NA |
drop_longitude_dim$record_type
CC ID: 377869
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
longitude record type or reason record is unavailable |
| Allowed Values: | Longitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
drop_sounder_depth_whid
CC ID: 377870
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier to the drop depth from the sounder sensor to the tenth of a meter unit |
field_identified_taxonomy_whid
CC ID: 377871
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier to field identified taxonomy |
drop_time_dim$military_hour
CC ID: 377872
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
military representation of the hour |
| Allowed Values: | 0-24 |
sampling_start_hhmmss
CC ID: 377873
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
individual_tracking_id
CC ID: 377874
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Field individual identification number |
most_recent_age_update
CC ID: 377875
| Data Storage Type: | timestamp |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
full date value |
sampling_start_time_dim$minute
CC ID: 377876
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
number of minutes in the hour |
| Unit of Measure: | min |
| Allowed Values: | 0-60 |
inclusion_dim$hook_inclusion_indicator
CC ID: 377877
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
indicates if hook should be included |
| Allowed Values: | Include Hook, Do Not Include Hook, NA |
angler_person_dim$nick_name
CC ID: 377878
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
nickname of person |
operation_dim$trip_id
CC ID: 377879
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
trip identifier number |
species_category
CC ID: 377880
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 40 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
upper-level taxonomic ranking |
| Allowed Values: | fish, invertebrate, mammal, seabird, reptile, nonspecific organics, NA |
field_identified_taxonomy_dim$scientific_name_taxonomic_level
CC ID: 377881
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 15 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
name of the lowest taxonomic level used to define scientific name |
best_available_taxonomy_observation_detail_dim$method_description
CC ID: 377882
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 500 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
description of how the observation was taken |
scientific_name
CC ID: 377883
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 120 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
scientific name generally composed of the genus and species name and subspecies name if available, but may be the highest taxonomic level |
sampling_end_time_dim$second
CC ID: 377884
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
number of seconds in the minute |
| Unit of Measure: | sec |
| Allowed Values: | 0-60 |
inclusion_dim$drop_inclusion_indicator
CC ID: 377885
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
indicates if drop should be included |
| Allowed Values: | Include Drop, Do Not Include Drop, NA |
field_identified_taxonomy_dim$trawl_survey_species_id
CC ID: 377886
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
species identifier used by the trawl survey |
operation_dim$scientist_3_person_whid
CC ID: 377887
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
person reference for the third scientist |
site_dim$site_longitude_whid
CC ID: 377888
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
warehouse identifier to longitude details for site |
date_whid
CC ID: 377889
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier to date details |
drop_time_dim$minute
CC ID: 377890
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
number of minutes in the hour |
| Unit of Measure: | min |
| Allowed Values: | 0-60 |
sampling_end_time_dim$minute
CC ID: 377891
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
number of minutes in the hour |
| Unit of Measure: | min |
| Allowed Values: | 0-60 |
sampling_start_time_dim$hour
CC ID: 377892
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
standard representation of the hour |
| Unit of Measure: | hr |
| Allowed Values: | 0-12 |
field_identified_taxonomy_dim$scientific_name
CC ID: 377893
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 120 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
scientific name generally composed of the genus and species name and subspecies name if available, but may be the highest taxonomic level |
field_identified_taxonomy_dim$order_40
CC ID: 377894
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
order name |
drop_longitude_dim$longitude_minute_units
CC ID: 377895
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of longitude that makes up the minute unit only |
| Unit of Measure: | min |
| Allowed Values: | 0-59 |
best_available_taxonomy_dim$grp_nonstandard_taxon_99
CC ID: 377896
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
a pseudo taxonomic level that has a common usage such as Invertebrata, Pisces (Fish). This has been designed to allow for only one level of para- or poly-phyletic group that is the terminus of the definition (it may be associated with a higher level taxonomic hierarchy). Consequently a definition such as Fish->Roundfish would not be supported with this design |
most_recent_taxonomy_update_date_dim$year
CC ID: 377897
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of year |
| Allowed Values: | 1978+ |
most_recent_taxonomy_update_date_dim$month_of_year
CC ID: 377898
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of month of year |
| Allowed Values: | 1-12 |
best_available_taxonomy_dim$subphylum_22
CC ID: 377899
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
subphylum name |
year
CC ID: 377900
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
operation year |
| Unit of Measure: | year |
| Allowed Values: | 2007+ |
field_identified_taxonomy_dim$tribe_60
CC ID: 377901
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
tribe name |
best_available_taxonomy_dim$order_40
CC ID: 377902
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
order name |
operation_dim$operation_end_time_whid
CC ID: 377903
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
end time reference for the operation |
tow
CC ID: 377904
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
operation number of the survey |
common_name
CC ID: 377905
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
only one broadly used common name is supported by this design. If the common name is not fairly universally used or is used by more than one taxon this should be left null |
field_identified_taxonomy_dim$superclass_28
CC ID: 377906
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
superclass name |
site_dim$cowcod_conservation_area_indicator
CC ID: 377907
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 40 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
indicates if site falls within the cowcod conservation area |
| Allowed Values: | Inside_Cowcod_Conservancy_Area, Outside_Cowcod_Conservancy_Area. |
best_available_taxonomy_dim$subclass_32
CC ID: 377908
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
subclass name |
project
CC ID: 377909
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
project name |
| Allowed Values: | Groundfish Shelf Survey, Groundfish Slope and Shelf Combination Survery, Groundfish Slope Survey, Groundfish Triennial Shelf Survery, Hypoxia Study, Santa Barbara Basin Study, Shelf Rockfish [2004-2015], Video Study |
field_identified_taxonomy_dim$subclass_32
CC ID: 377910
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
subclass name |
site_dim$tide_station_noaa_id
CC ID: 377911
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
tide station id according to NOAA's Tides and Currents site |
pass
CC ID: 377912
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
pass number of the survey |
| Allowed Values: | 1,2,3,4 |
length_cm
CC ID: 377913
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Precision: | 1 |
| Status: | Active |
| Description: |
Individual length in centimeters |
inclusion_dim$record_type
CC ID: 377914
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
inclusion record or reason record is unavailable |
| Allowed Values: | Inclusion, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
best_available_taxonomy_dim$species_80
CC ID: 377915
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
species name |
best_available_taxonomy_dim$structure_source
CC ID: 377916
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Source of the taxonomic structure |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
drop_latitude_dim$latitude_in_degree_minute_second
CC ID: 377917
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
string representation of latitude in degrees, minutes, and seconds for example 4525'01" |
| Unit of Measure: | NA |
| Allowed Values: | any |
operation_dim$limited_entry_permit_number
CC ID: 377918
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
federal limited entry groundfish permit issued to fish in waters off of Washington, Oregon, and California |
angler_person_dim$middle_initial
CC ID: 377919
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
middle initial of person |
operation_dim$departure_date_whid
CC ID: 377920
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
date reference that vessel departed for the defined leg or trip |
site_dim$cdfgblock
CC ID: 377921
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
CDFG Block Numbers that the sites fall within |
most_recent_taxonomy_update_date_dim$record_type
CC ID: 377922
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
date, month, or year record or reason record is unavailable |
| Allowed Values: | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
net_liftoff_time
CC ID: 377923
| Data Storage Type: | time |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
military time representation of the time |
angler_person_dim$last_name
CC ID: 377924
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
last name of person |
drop_time_dim$time
CC ID: 377925
| Data Storage Type: | time |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
military time representation of the time |
field_identified_taxonomy_dim$suborder_42
CC ID: 377926
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
suborder name |
date_dim$month_name
CC ID: 377927
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of month |
| Allowed Values: | January, February, March, April, May, June, July, August, September, October, November, December |
drop_longitude_dim$longitude_in_degree_minute_second
CC ID: 377928
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
string representation of longitude in degrees, minutes, and seconds for example 4525'01" |
field_identified_taxonomy_dim$class_30
CC ID: 377929
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
class name |
inclusion_dim$site_inclusion_indicator
CC ID: 377930
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
indicates if site should be included |
| Allowed Values: | Include Site, Do Not Include Site, NA |
field_identified_taxonomy_dim$species_80
CC ID: 377931
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
species name |
drop_latitude_dim$latitude_degree_units
CC ID: 377932
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of latitude that makes up the degree unit only |
| Unit of Measure: | deg |
| Allowed Values: | -90 to 90 |