Item Identification

Title: Catch Acoustics Fact
Short Name: Catch Acoustics Fact
Status: Planned
Abstract:

Catch data from the Integrated acoustic and trawl survey of Pacific hake off the Pacific Coast

Entity Information

Entity Type: Spreadsheet
Active Version?: Yes
Schema Name: PARR
Description:

Catch data from the Integrated acoustic and trawl survey of Pacific hake off the Pacific Coast

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
operation_dim$return_port_whid Number port reference for return port
100
tow_end_timestamp Time operation end date timestamp
100
leg Number leg number of the survey
100
field_identified_taxonomy_dim$subphylum_22 Text subphylum name
100
operation_dim$captain_person_whid Number person reference for the vessel captain
100
field_identified_taxonomy_dim$phylum_20 Text phylum name
100
equilibrium_latitude_dim$latitude_compass_direction Text latitude compass direction
100
statistical_partition_whid Number Warehouse identifier for statistical partition
100
most_recent_taxonomy_update_date_dim$year Number numeric representation of year
100
equilibrium_longitude_dim$record_type Text longitude record type or reason record is unavailable
100
sampling_start_time_dim$second Number number of seconds in the minute
100
equilibrium_latitude_whid Number Warehouse identifier for equilibrium latitude
100
field_identified_taxonomy_dim$pacfin_spid Text pacfin species id - many taxa may not have one of these
100
operation_dim$ifq_account_number Text unique number assigned to user accounts in the Vessel Accounting Database
100
equilibrium_latitude_dim$record_type Text latitude record type or reason record is unavailable
100
sampling_end_time_dim$hour Number standard representation of the hour
100
field_identified_taxonomy_dim$superclass_28 Text superclass name
100
sample_weight_lb Number Weight of a sample of the catch measured in pounds
100
most_recent_taxonomy_update_date_dim$month_name Text text representation of month
100
field_identified_taxonomy_dim$genus_70 Text genus name
100
weight_in_haul_lb Number Weight of the organisms for the species found in the haul measured in pounds
100
average_bottom_depth_dim$boundary_indicator Text depth boundry indicator identifying ifp boundary marks
100
operation_dim$operation_start_time_whid Number start time reference for the operation
100
equilibrium_longitude_dim$longitude_in_degree_minute_second Text string representation of longitude in degrees, minutes, and seconds for example 4525'01"
100
operation_dim$scientist_1_person_whid Number person reference for the first scientist
100
net_liftoff_time Time military time representation of the time
100
sampling_start_time_dim$minute Number number of minutes in the hour
100
operation_dim$scientist_4_person_whid Number person reference for the fourth scientist
100
sampling_start_time_whid Number Warehouse identifier for the sampling start time
100
equilibrium_latitude_dim$latitude_in_degree_minute_second Text string representation of latitude in degrees, minutes, and seconds for example 4525'01"
100
field_identified_taxonomy_dim$itis_taxonomic_serial_no Number ITIS taxonomic identifier
100
operation_dim$departure_port_whid Number port reference for the departure port
100
pass Number pass number of the survey
100
sampling_end_time_dim$period Text period of time
100
operation_dim$scientist_3_person_whid Number person reference for the third scientist
100
weight_in_haul_kg Number Weight of the organisms for the species found in the haul measured in kilograms
100
field_identified_taxonomy_dim$structure_source Text Source of the taxonomic structure
100
most_recent_taxon_update Time full date value
100
equilibrium_longitude_dim$longitude_second_units Number numeric representation of longitude that makes up the second unit only
100
equilibrium_latitude_dim$latitude_degree_units Number numeric representation of latitude that makes up the degree unit only
100
whole_haul_weight_lb Number Weight for the catch that hasn't been sampled out but is the actual measured weight for the haul measured in pounds
100
project Text project name
100
partition Text Refines the partition type
100
sampling_start_time_dim$record_type Text time record or reason record is unavailable
100
field_identified_taxonomy_dim$observer_species_id Number species identifier used by the observer program
100
field_identified_taxonomy_dim$worms_aphiaid Number WoRMS taxonomic identifier
100
operation_dim$scientist_2_person_whid Number person reference for the second scientist
100
sampling_start_time_dim$military_hour Number military representation of the hour
100
most_recent_taxonomy_update_date_dim$yyyymmdd Text text representation of year month day
100
net_touchdown_time Time military time representation of the time
100
operation_dim$vessel_id Number field database vessel id number
100
sampling_start_time_dim$period Text period of time
100
trawl_id Number identifier for a sampling operation
100
equilibrium_latitude_dim$latitude_minute_units Number numeric representation of latitude that makes up the minute unit only
100
field_identified_taxonomy_dim$hookandline_species_id Number species identifier used by hook and line
100
sampling_end_time_dim$military_hour Number military representation of the hour
100
field_identified_taxonomy_dim$record_type Text record or reason record is unavailable
100
field_identified_taxonomy_dim$scientific_name_taxonomic_level Text name of the lowest taxonomic level used to define scientific name
100
sampling_start_time_dim$hour Number standard representation of the hour
100
field_identified_taxonomy_dim$pacfin_nom_spid Text PacFIN nominal species identifier
100
field_identified_taxonomy_dim$superfamily_48 Text superfamily name
100
program Text type of fram program
100
sampling_end_hhmmss Text concatenation of military hour, minute, second, example 230415 equates to 23:04:15
100
field_identified_taxonomy_dim$superorder_38 Text superorder name
100
most_recent_taxonomy_update_date_dim$day_of_month Number numeric representation of the day in month
100
total_catch_weight_kg Number Weight of the total catch for the tow measured in kilograms
100
operation_dim$state_registration_number Text state registration number for the vessel
100
sampling_end_time_whid Number Warehouse identifier for the sampling end time
100
operation_dim$record_type Text operation record or reason record is unavailable
100
average_weight_kg Number Average weight of the species in this haul (weight_in_haul/number_in_haul) measured in kilograms
100
equilibrium_latitude_dim$named_parallel Text name of parallel, boundary, or commonly used geograpical location
100
field_identified_taxonomy_dim$common_name Text 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
whole_haul_indicator Number Indicates if the catch weighed is the entire haul or a subsample
100
operation_dim_whid Number Warehouse identifier for operation
100
most_recent_taxonomy_update_date_whid Number Warehouse identifier for most recent taxonomy update date
100
number_in_haul Number Count of the organisms for the species found in the haul; some of these may be extrapolated numbers
100
field_identified_taxonomy_whid Number Warehouse identifier to field identified taxonomy
100
tow Number operation number of the survey
100
equilibrium_longitude_dim$longitude_minute_units Number numeric representation of longitude that makes up the minute unit only
100
average_bottom_depth_dim$depth_fathoms Number depth low precision measurement in fathoms converted from meters measured to the tenth of a meter except for special fathom boundaries
100
average_bottom_depth_whid Number Warehouse identifier for average bottom depth
100
field_identified_taxonomy_dim$infraclass_34 Text infraclass name
100
field_identified_taxonomy_dim$subspecies_82 Text subspecies name
100
operation_dim$coast_guard_number Text Coast Guard documentation number of vessel
100
field_identified_taxonomy_dim$kingdom_10 Text kingdom name
100
most_recent_taxonomy_update_date_dim$record_type Text date, month, or year record or reason record is unavailable
100
sampling_end_time_dim$record_type Text time record or reason record is unavailable
100
average_bottom_depth_dim$record_type Text depth record or reason record is unavailable
100
sampling_end_time_dim$minute Number number of minutes in the hour
100
whole_haul_weight_kg Number Weight for the catch that hasn't been sampled out but is the actual measured weight for the haul measured in kilograms
100
field_identified_taxonomy_dim$tribe_60 Text tribe name
100
year Number operation year
100
equilibrium_latitude_dim$latitude_in_degrees Number numeric representation of latitude in degrees
100
field_identified_taxonomy_dim$subfamily_52 Text subfamily name
100
field_identified_taxonomy_dim$subclass_32 Text subclass name
100
field_identified_taxonomy_dim$class_30 Text class name
100
equilibrium_longitude_whid Number Warehouse identifier for equilibrium longitude
100
operation_dim$operation_end_date_whid Number end date reference for the operation
100
field_identified_taxonomy_dim$grp_nonstandard_taxon_99 Text 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
operation_dim$departure_date_whid Number date reference that vessel departed for the defined leg or trip
100
statistical_partition_dim$record_type Text statistical partition record or reason record is unavailable
100
sampling_end_time_dim$second Number number of seconds in the minute
100
operation_dim$fpc_person_whid Number person reference for the FPC
100
sampling_start_hhmmss Text concatenation of military hour, minute, second, example 230415 equates to 23:04:15
100
field_identified_taxonomy_dim$infraorder_44 Text infraorder name
100
performance Text performance of the operation
100
total_catch_weight_lb Number Weight of the total catch for the tow measured in pounds
100
field_identified_taxonomy_dim$norpac_species_id Number 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
field_identified_taxonomy_dim$suborder_42 Text suborder name
100
field_identified_taxonomy_dim$family_50 Text family name
100
field_identified_taxonomy_dim$species_category Text upper-level taxonomic ranking
100
field_identified_taxonomy_dim$scientific_name Text scientific name generally composed of the genus and species name and subspecies name if available, but may be the highest taxonomic level
100
most_recent_taxonomy_update_date_dim$month_abbrev Text three character representation of month in capital letters
100
tow_start_timestamp Time operation start date timestamp
100
field_identified_taxonomy_dim$species_sub_category Text mid-level taxonomic ranking
100
operation_dim$return_date_whid Number date reference that vessel returned for the defined leg or trip
100
operation_dim$observer_program Text description of the observer program
100
statistical_partition_dim$statistical_partition_type Text Defines the partition type
100
equilibrium_longitude_dim$longitude_degree_units Number numeric representation of longitude that makes up the degree unit only
100
field_identified_taxonomy_dim$acoustics_species_id Number Species ID used in the acoustics program
100
operation_dim$operation_start_date_whid Number start date reference for the operation
100
average_bottom_depth_dim$depth_meters Number depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries)
100
field_identified_taxonomy_dim$order_40 Text order name
100
field_identified_taxonomy_dim$species_80 Text species name
100
equilibrium_longitude_dim$longitude_in_degrees Number numeric representation of longitude in decimal degrees
100
field_identified_taxonomy_dim$trawl_survey_species_id Number species identifier used by the trawl survey
100
average_weight_lb Number Average weight of the species in this haul (weight_in_haul/number_in_haul) measured in pounds
100
operation_dim$operation_type Text type of operation
100
vessel Text name of the vessel used for the operation
100
most_recent_taxonomy_update_date_dim$month_of_year Number numeric representation of month of year
100
equilibrium_longitude_dim$longitude_compass_direction Text longitude compass direction
100
equilibrium_latitude_dim$latitude_second_units Number numeric representation of latitude that makes up the second unit only
100
operation_dim$operation_end_time_whid Number end time reference for the operation
100
field_identified_taxonomy_dim$abbreviated_name Text specialized common name, generally for a well-known species of fish such as ATF, LST, SST
100
operation_dim$limited_entry_permit_number Text federal limited entry groundfish permit issued to fish in waters off of Washington, Oregon, and California
100
operation_dim$field_operation_seg_id Number operation segment id reference to the field operational segment table
100
operation_dim$trip_id Number trip identifier number
100
field_identified_taxonomy_dim$grp_reg_depth_category Text 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
sample_weight_kg Number Weight of a sample of the catch measured in kilograms
100
transect_whid Number Warehouse identifier for transect

Attribute Details

operation_dim$return_port_whid

CC ID: 385272
Seq. Order: 1
Data Storage Type: Number
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

port reference for return port

General Data Type: Number

tow_end_timestamp

CC ID: 385273
Seq. Order: 2
Data Storage Type: Time
Required: No
Primary Key: No
Status: Active
Description:

operation end date timestamp

General Data Type: Time

leg

CC ID: 385274
Seq. Order: 3
Data Storage Type: Number
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

leg number of the survey

General Data Type: Number
Allowed Values: 1,2,3,4,5,6,7,8

field_identified_taxonomy_dim$subphylum_22

CC ID: 385275
Seq. Order: 4
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

subphylum name

General Data Type: Text

operation_dim$captain_person_whid

CC ID: 385276
Seq. Order: 5
Data Storage Type: Number
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

person reference for the vessel captain

General Data Type: Number

field_identified_taxonomy_dim$phylum_20

CC ID: 385277
Seq. Order: 6
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

phylum name

General Data Type: Text

equilibrium_latitude_dim$latitude_compass_direction

CC ID: 385278
Seq. Order: 7
Data Storage Type: Text
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

latitude compass direction

General Data Type: Text
Unit of Measure: NA
Allowed Values: N, S

statistical_partition_whid

CC ID: 385279
Seq. Order: 8
Data Storage Type: Number
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for statistical partition

General Data Type: Number

most_recent_taxonomy_update_date_dim$year

CC ID: 385280
Seq. Order: 9
Data Storage Type: Number
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of year

General Data Type: Number
Allowed Values: 1978+

equilibrium_longitude_dim$record_type

CC ID: 385281
Seq. Order: 10
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

longitude record type or reason record is unavailable

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

sampling_start_time_dim$second

CC ID: 385282
Seq. Order: 11
Data Storage Type: Number
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

number of seconds in the minute

General Data Type: Number
Unit of Measure: sec
Allowed Values: 0-60

equilibrium_latitude_whid

CC ID: 385283
Seq. Order: 12
Data Storage Type: Number
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for equilibrium latitude

General Data Type: Number

field_identified_taxonomy_dim$pacfin_spid

CC ID: 385284
Seq. Order: 13
Data Storage Type: Text
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: Text

operation_dim$ifq_account_number

CC ID: 385285
Seq. Order: 14
Data Storage Type: Text
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

unique number assigned to user accounts in the Vessel Accounting Database

General Data Type: Text

equilibrium_latitude_dim$record_type

CC ID: 385286
Seq. Order: 15
Data Storage Type: Text
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

latitude record type or reason record is unavailable

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

sampling_end_time_dim$hour

CC ID: 385287
Seq. Order: 16
Data Storage Type: Number
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

standard representation of the hour

General Data Type: Number
Unit of Measure: hr
Allowed Values: 0-12

field_identified_taxonomy_dim$superclass_28

CC ID: 385288
Seq. Order: 17
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

superclass name

General Data Type: Text

sample_weight_lb

CC ID: 385289
Seq. Order: 18
Data Storage Type: Number
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Weight of a sample of the catch measured in pounds

General Data Type: Number
Unit of Measure: lb

most_recent_taxonomy_update_date_dim$month_name

CC ID: 385290
Seq. Order: 19
Data Storage Type: Text
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

text representation of month

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

field_identified_taxonomy_dim$genus_70

CC ID: 385291
Seq. Order: 20
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

genus name

General Data Type: Text

weight_in_haul_lb

CC ID: 385292
Seq. Order: 21
Data Storage Type: Number
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Weight of the organisms for the species found in the haul measured in pounds

General Data Type: Number
Unit of Measure: lb

average_bottom_depth_dim$boundary_indicator

CC ID: 385293
Seq. Order: 22
Data Storage Type: Text
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

depth boundry indicator identifying ifp boundary marks

General Data Type: Text
Allowed Values: IFP Boundary Depth, Standard Contour Depth, NA

operation_dim$operation_start_time_whid

CC ID: 385294
Seq. Order: 23
Data Storage Type: Number
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

start time reference for the operation

General Data Type: Number

equilibrium_longitude_dim$longitude_in_degree_minute_second

CC ID: 385295
Seq. Order: 24
Data Storage Type: Text
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: Text

operation_dim$scientist_1_person_whid

CC ID: 385296
Seq. Order: 25
Data Storage Type: Number
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

person reference for the first scientist

General Data Type: Number

net_liftoff_time

CC ID: 385297
Seq. Order: 26
Data Storage Type: Time
Required: No
Primary Key: No
Status: Active
Description:

military time representation of the time

General Data Type: Time

sampling_start_time_dim$minute

CC ID: 385298
Seq. Order: 27
Data Storage Type: Number
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

number of minutes in the hour

General Data Type: Number
Unit of Measure: min
Allowed Values: 0-60

operation_dim$scientist_4_person_whid

CC ID: 385299
Seq. Order: 28
Data Storage Type: Number
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

person reference for the fourth scientist

General Data Type: Number

sampling_start_time_whid

CC ID: 385300
Seq. Order: 29
Data Storage Type: Number
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for the sampling start time

General Data Type: Number

equilibrium_latitude_dim$latitude_in_degree_minute_second

CC ID: 385301
Seq. Order: 30
Data Storage Type: Text
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: Text
Unit of Measure: NA
Allowed Values: any

field_identified_taxonomy_dim$itis_taxonomic_serial_no

CC ID: 385302
Seq. Order: 31
Data Storage Type: Number
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

ITIS taxonomic identifier

General Data Type: Number
Unit of Measure: unspecified
Allowed Values: Any

operation_dim$departure_port_whid

CC ID: 385303
Seq. Order: 32
Data Storage Type: Number
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

port reference for the departure port

General Data Type: Number

pass

CC ID: 385304
Seq. Order: 33
Data Storage Type: Number
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

pass number of the survey

General Data Type: Number
Allowed Values: 1,2,3,4

sampling_end_time_dim$period

CC ID: 385305
Seq. Order: 34
Data Storage Type: Text
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

period of time

General Data Type: Text
Allowed Values: AM, PM

operation_dim$scientist_3_person_whid

CC ID: 385306
Seq. Order: 35
Data Storage Type: Number
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

person reference for the third scientist

General Data Type: Number

weight_in_haul_kg

CC ID: 385307
Seq. Order: 36
Data Storage Type: Number
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Weight of the organisms for the species found in the haul measured in kilograms

General Data Type: Number
Unit of Measure: kg

field_identified_taxonomy_dim$structure_source

CC ID: 385308
Seq. Order: 37
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Source of the taxonomic structure

General Data Type: Text
Unit of Measure: unspecified
Allowed Values: Any

most_recent_taxon_update

CC ID: 385309
Seq. Order: 38
Data Storage Type: Time
Required: No
Primary Key: No
Status: Active
Description:

full date value

General Data Type: Time

equilibrium_longitude_dim$longitude_second_units

CC ID: 385310
Seq. Order: 39
Data Storage Type: Number
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of longitude that makes up the second unit only

General Data Type: Number
Unit of Measure: sec
Allowed Values: 0-59

equilibrium_latitude_dim$latitude_degree_units

CC ID: 385311
Seq. Order: 40
Data Storage Type: Number
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of latitude that makes up the degree unit only

General Data Type: Number
Unit of Measure: deg
Allowed Values: -90 to 90

whole_haul_weight_lb

CC ID: 385312
Seq. Order: 41
Data Storage Type: Number
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Weight for the catch that hasn't been sampled out but is the actual measured weight for the haul measured in pounds

General Data Type: Number
Unit of Measure: lb

project

CC ID: 385313
Seq. Order: 42
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

project name

General Data Type: Text
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

partition

CC ID: 385314
Seq. Order: 43
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Refines the partition type

General Data Type: Text
Allowed Values: Life stage: YOY, larvae, eggs and egg cases, adult, subadult; Size: Large, Small, Unspecified; Gender: Male, Female

sampling_start_time_dim$record_type

CC ID: 385315
Seq. Order: 44
Data Storage Type: Text
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

time record or reason record is unavailable

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

field_identified_taxonomy_dim$observer_species_id

CC ID: 385316
Seq. Order: 45
Data Storage Type: Number
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

species identifier used by the observer program

General Data Type: Number

field_identified_taxonomy_dim$worms_aphiaid

CC ID: 385317
Seq. Order: 46
Data Storage Type: Number
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

WoRMS taxonomic identifier

General Data Type: Number
Unit of Measure: unspecified
Allowed Values: Any

operation_dim$scientist_2_person_whid

CC ID: 385318
Seq. Order: 47
Data Storage Type: Number
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

person reference for the second scientist

General Data Type: Number

sampling_start_time_dim$military_hour

CC ID: 385319
Seq. Order: 48
Data Storage Type: Number
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

military representation of the hour

General Data Type: Number
Allowed Values: 0-24

most_recent_taxonomy_update_date_dim$yyyymmdd

CC ID: 385320
Seq. Order: 49
Data Storage Type: Text
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

text representation of year month day

General Data Type: Text

net_touchdown_time

CC ID: 385321
Seq. Order: 50
Data Storage Type: Time
Required: No
Primary Key: No
Status: Active
Description:

military time representation of the time

General Data Type: Time

operation_dim$vessel_id

CC ID: 385322
Seq. Order: 51
Data Storage Type: Number
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

field database vessel id number

General Data Type: Number

sampling_start_time_dim$period

CC ID: 385323
Seq. Order: 52
Data Storage Type: Text
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

period of time

General Data Type: Text
Allowed Values: AM, PM

trawl_id

CC ID: 385324
Seq. Order: 53
Data Storage Type: Number
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

identifier for a sampling operation

General Data Type: Number

equilibrium_latitude_dim$latitude_minute_units

CC ID: 385325
Seq. Order: 54
Data Storage Type: Number
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of latitude that makes up the minute unit only

General Data Type: Number
Unit of Measure: min
Allowed Values: 0-60

field_identified_taxonomy_dim$hookandline_species_id

CC ID: 385326
Seq. Order: 55
Data Storage Type: Number
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

species identifier used by hook and line

General Data Type: Number

sampling_end_time_dim$military_hour

CC ID: 385327
Seq. Order: 56
Data Storage Type: Number
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

military representation of the hour

General Data Type: Number
Allowed Values: 0-24

field_identified_taxonomy_dim$record_type

CC ID: 385328
Seq. Order: 57
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

record or reason record is unavailable

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

field_identified_taxonomy_dim$scientific_name_taxonomic_level

CC ID: 385329
Seq. Order: 58
Data Storage Type: Text
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

name of the lowest taxonomic level used to define scientific name

General Data Type: Text

sampling_start_time_dim$hour

CC ID: 385330
Seq. Order: 59
Data Storage Type: Number
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

standard representation of the hour

General Data Type: Number
Unit of Measure: hr
Allowed Values: 0-12

field_identified_taxonomy_dim$pacfin_nom_spid

CC ID: 385331
Seq. Order: 60
Data Storage Type: Text
Max Length: 10
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

PacFIN nominal species identifier

General Data Type: Text
Unit of Measure: unspecified
Allowed Values: Any

field_identified_taxonomy_dim$superfamily_48

CC ID: 385332
Seq. Order: 61
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

superfamily name

General Data Type: Text

program

CC ID: 385333
Seq. Order: 62
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

type of fram program

General Data Type: Text
Allowed Values: Bottom Trawl, Hook and Line

sampling_end_hhmmss

CC ID: 385334
Seq. Order: 63
Data Storage Type: Text
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: Text

field_identified_taxonomy_dim$superorder_38

CC ID: 385335
Seq. Order: 64
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

superorder name

General Data Type: Text

most_recent_taxonomy_update_date_dim$day_of_month

CC ID: 385336
Seq. Order: 65
Data Storage Type: Number
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of the day in month

General Data Type: Number
Allowed Values: 1-31

total_catch_weight_kg

CC ID: 385337
Seq. Order: 66
Data Storage Type: Number
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Weight of the total catch for the tow measured in kilograms

General Data Type: Number
Unit of Measure: kg

operation_dim$state_registration_number

CC ID: 385338
Seq. Order: 67
Data Storage Type: Text
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

state registration number for the vessel

General Data Type: Text

sampling_end_time_whid

CC ID: 385339
Seq. Order: 68
Data Storage Type: Number
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for the sampling end time

General Data Type: Number

operation_dim$record_type

CC ID: 385340
Seq. Order: 69
Data Storage Type: Text
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

operation record or reason record is unavailable

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

average_weight_kg

CC ID: 385341
Seq. Order: 70
Data Storage Type: Number
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Average weight of the species in this haul (weight_in_haul/number_in_haul) measured in kilograms

General Data Type: Number
Unit of Measure: kg

equilibrium_latitude_dim$named_parallel

CC ID: 385342
Seq. Order: 71
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

name of parallel, boundary, or commonly used geograpical location

General Data Type: Text
Unit of Measure: NA
Allowed Values: any

field_identified_taxonomy_dim$common_name

CC ID: 385343
Seq. Order: 72
Data Storage Type: Text
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

General Data Type: Text

whole_haul_indicator

CC ID: 385344
Seq. Order: 73
Data Storage Type: Number
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Indicates if the catch weighed is the entire haul or a subsample

General Data Type: Number
Allowed Values: Whole Haulled, Not Whole Haulled

operation_dim_whid

CC ID: 385345
Seq. Order: 74
Data Storage Type: Number
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for operation

General Data Type: Number

most_recent_taxonomy_update_date_whid

CC ID: 385346
Seq. Order: 75
Data Storage Type: Number
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for most recent taxonomy update date

General Data Type: Number

number_in_haul

CC ID: 385347
Seq. Order: 76
Data Storage Type: Number
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Count of the organisms for the species found in the haul; some of these may be extrapolated numbers

General Data Type: Number

field_identified_taxonomy_whid

CC ID: 385348
Seq. Order: 77
Data Storage Type: Number
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier to field identified taxonomy

General Data Type: Number

tow

CC ID: 385349
Seq. Order: 78
Data Storage Type: Number
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

operation number of the survey

General Data Type: Number

equilibrium_longitude_dim$longitude_minute_units

CC ID: 385350
Seq. Order: 79
Data Storage Type: Number
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of longitude that makes up the minute unit only

General Data Type: Number
Unit of Measure: min
Allowed Values: 0-59

average_bottom_depth_dim$depth_fathoms

CC ID: 385351
Seq. Order: 80
Data Storage Type: Number
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

General Data Type: Number
Unit of Measure: fth

average_bottom_depth_whid

CC ID: 385352
Seq. Order: 81
Data Storage Type: Number
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for average bottom depth

General Data Type: Number

field_identified_taxonomy_dim$infraclass_34

CC ID: 385353
Seq. Order: 82
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

infraclass name

General Data Type: Text

field_identified_taxonomy_dim$subspecies_82

CC ID: 385354
Seq. Order: 83
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

subspecies name

General Data Type: Text

operation_dim$coast_guard_number

CC ID: 385355
Seq. Order: 84
Data Storage Type: Text
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Coast Guard documentation number of vessel

General Data Type: Text

field_identified_taxonomy_dim$kingdom_10

CC ID: 385356
Seq. Order: 85
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

kingdom name

General Data Type: Text

most_recent_taxonomy_update_date_dim$record_type

CC ID: 385357
Seq. Order: 86
Data Storage Type: Text
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

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

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

sampling_end_time_dim$record_type

CC ID: 385358
Seq. Order: 87
Data Storage Type: Text
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

time record or reason record is unavailable

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

average_bottom_depth_dim$record_type

CC ID: 385359
Seq. Order: 88
Data Storage Type: Text
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

depth record or reason record is unavailable

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

sampling_end_time_dim$minute

CC ID: 385360
Seq. Order: 89
Data Storage Type: Number
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

number of minutes in the hour

General Data Type: Number
Unit of Measure: min
Allowed Values: 0-60

whole_haul_weight_kg

CC ID: 385361
Seq. Order: 90
Data Storage Type: Number
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Weight for the catch that hasn't been sampled out but is the actual measured weight for the haul measured in kilograms

General Data Type: Number
Unit of Measure: kg

field_identified_taxonomy_dim$tribe_60

CC ID: 385362
Seq. Order: 91
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

tribe name

General Data Type: Text

year

CC ID: 385363
Seq. Order: 92
Data Storage Type: Number
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

operation year

General Data Type: Number
Unit of Measure: year
Allowed Values: 2007+

equilibrium_latitude_dim$latitude_in_degrees

CC ID: 385364
Seq. Order: 93
Data Storage Type: Number
Max Length: 12
Required: No
Primary Key: No
Precision: 8
Status: Active
Description:

numeric representation of latitude in degrees

General Data Type: Number
Unit of Measure: dd
Allowed Values: -90 to 90

field_identified_taxonomy_dim$subfamily_52

CC ID: 385365
Seq. Order: 94
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

subfamily name

General Data Type: Text

field_identified_taxonomy_dim$subclass_32

CC ID: 385366
Seq. Order: 95
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

subclass name

General Data Type: Text

field_identified_taxonomy_dim$class_30

CC ID: 385367
Seq. Order: 96
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

class name

General Data Type: Text

equilibrium_longitude_whid

CC ID: 385368
Seq. Order: 97
Data Storage Type: Number
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for equilibrium longitude

General Data Type: Number

operation_dim$operation_end_date_whid

CC ID: 385369
Seq. Order: 98
Data Storage Type: Number
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

end date reference for the operation

General Data Type: Number

field_identified_taxonomy_dim$grp_nonstandard_taxon_99

CC ID: 385370
Seq. Order: 99
Data Storage Type: Text
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

General Data Type: Text

operation_dim$departure_date_whid

CC ID: 385371
Seq. Order: 100
Data Storage Type: Number
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

date reference that vessel departed for the defined leg or trip

General Data Type: Number

statistical_partition_dim$record_type

CC ID: 385372
Seq. Order: 101
Data Storage Type: Text
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

statistical partition record or reason record is unavailable

General Data Type: Text
Allowed Values: Statistical Partition, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

sampling_end_time_dim$second

CC ID: 385373
Seq. Order: 102
Data Storage Type: Number
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

number of seconds in the minute

General Data Type: Number
Unit of Measure: sec
Allowed Values: 0-60

operation_dim$fpc_person_whid

CC ID: 385374
Seq. Order: 103
Data Storage Type: Number
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

person reference for the FPC

General Data Type: Number

sampling_start_hhmmss

CC ID: 385375
Seq. Order: 104
Data Storage Type: Text
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: Text

field_identified_taxonomy_dim$infraorder_44

CC ID: 385376
Seq. Order: 105
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

infraorder name

General Data Type: Text

performance

CC ID: 385377
Seq. Order: 106
Data Storage Type: Text
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

performance of the operation

General Data Type: Text
Allowed Values: Insufficient Information, Indeterminate, Satisfactory, Trawlable, Untrawlable, Unsatisfactory, [null]

total_catch_weight_lb

CC ID: 385378
Seq. Order: 107
Data Storage Type: Number
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Weight of the total catch for the tow measured in pounds

General Data Type: Number
Unit of Measure: lb

field_identified_taxonomy_dim$norpac_species_id

CC ID: 385379
Seq. Order: 108
Data Storage Type: Number
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.

General Data Type: Number
Unit of Measure: unspecified
Allowed Values: Any

field_identified_taxonomy_dim$suborder_42

CC ID: 385380
Seq. Order: 109
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

suborder name

General Data Type: Text

field_identified_taxonomy_dim$family_50

CC ID: 385381
Seq. Order: 110
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

family name

General Data Type: Text

field_identified_taxonomy_dim$species_category

CC ID: 385382
Seq. Order: 111
Data Storage Type: Text
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

upper-level taxonomic ranking

General Data Type: Text
Allowed Values: fish, invertebrate, mammal, seabird, reptile, nonspecific organics, NA

field_identified_taxonomy_dim$scientific_name

CC ID: 385383
Seq. Order: 112
Data Storage Type: Text
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

General Data Type: Text

most_recent_taxonomy_update_date_dim$month_abbrev

CC ID: 385384
Seq. Order: 113
Data Storage Type: Text
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

three character representation of month in capital letters

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

tow_start_timestamp

CC ID: 385385
Seq. Order: 114
Data Storage Type: Time
Required: No
Primary Key: No
Status: Active
Description:

operation start date timestamp

General Data Type: Time

field_identified_taxonomy_dim$species_sub_category

CC ID: 385386
Seq. Order: 115
Data Storage Type: Text
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

mid-level taxonomic ranking

General Data Type: Text
Allowed Values: rockfish, flatfish, shark, crab, NA

operation_dim$return_date_whid

CC ID: 385387
Seq. Order: 116
Data Storage Type: Number
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

date reference that vessel returned for the defined leg or trip

General Data Type: Number

operation_dim$observer_program

CC ID: 385388
Seq. Order: 117
Data Storage Type: Text
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

description of the observer program

General Data Type: Text

statistical_partition_dim$statistical_partition_type

CC ID: 385389
Seq. Order: 118
Data Storage Type: Text
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Defines the partition type

General Data Type: Text
Allowed Values: Life Stage, Size, Gender

equilibrium_longitude_dim$longitude_degree_units

CC ID: 385390
Seq. Order: 119
Data Storage Type: Number
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of longitude that makes up the degree unit only

General Data Type: Number
Unit of Measure: deg
Allowed Values: -180 to 180

field_identified_taxonomy_dim$acoustics_species_id

CC ID: 385391
Seq. Order: 120
Data Storage Type: Number
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Species ID used in the acoustics program

General Data Type: Number
Unit of Measure: unspecified
Allowed Values: Any

operation_dim$operation_start_date_whid

CC ID: 385392
Seq. Order: 121
Data Storage Type: Number
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

start date reference for the operation

General Data Type: Number

average_bottom_depth_dim$depth_meters

CC ID: 385393
Seq. Order: 122
Data Storage Type: Number
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)

General Data Type: Number
Unit of Measure: m
Allowed Values: 0-1500

field_identified_taxonomy_dim$order_40

CC ID: 385394
Seq. Order: 123
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

order name

General Data Type: Text

field_identified_taxonomy_dim$species_80

CC ID: 385395
Seq. Order: 124
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

species name

General Data Type: Text

equilibrium_longitude_dim$longitude_in_degrees

CC ID: 385396
Seq. Order: 125
Data Storage Type: Number
Max Length: 12
Required: No
Primary Key: No
Precision: 8
Status: Active
Description:

numeric representation of longitude in decimal degrees

General Data Type: Number
Unit of Measure: dd
Allowed Values: -180 to 180

field_identified_taxonomy_dim$trawl_survey_species_id

CC ID: 385397
Seq. Order: 126
Data Storage Type: Number
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

species identifier used by the trawl survey

General Data Type: Number

average_weight_lb

CC ID: 385398
Seq. Order: 127
Data Storage Type: Number
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Average weight of the species in this haul (weight_in_haul/number_in_haul) measured in pounds

General Data Type: Number
Unit of Measure: lb

operation_dim$operation_type

CC ID: 385399
Seq. Order: 128
Data Storage Type: Text
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

type of operation

General Data Type: Text
Allowed Values: CTD Cast, Drop, Experiment, Search, Trawl, VPR Tow, [null]

vessel

CC ID: 385400
Seq. Order: 129
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

name of the vessel used for the operation

General Data Type: Text
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

most_recent_taxonomy_update_date_dim$month_of_year

CC ID: 385401
Seq. Order: 130
Data Storage Type: Number
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of month of year

General Data Type: Number
Allowed Values: 1-12

equilibrium_longitude_dim$longitude_compass_direction

CC ID: 385402
Seq. Order: 131
Data Storage Type: Text
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

longitude compass direction

General Data Type: Text
Allowed Values: E, W

equilibrium_latitude_dim$latitude_second_units

CC ID: 385403
Seq. Order: 132
Data Storage Type: Number
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of latitude that makes up the second unit only

General Data Type: Number
Unit of Measure: sec
Allowed Values: 0-60

operation_dim$operation_end_time_whid

CC ID: 385404
Seq. Order: 133
Data Storage Type: Number
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

end time reference for the operation

General Data Type: Number

field_identified_taxonomy_dim$abbreviated_name

CC ID: 385405
Seq. Order: 134
Data Storage Type: Text
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

General Data Type: Text

operation_dim$limited_entry_permit_number

CC ID: 385406
Seq. Order: 135
Data Storage Type: Text
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

General Data Type: Text

operation_dim$field_operation_seg_id

CC ID: 385407
Seq. Order: 136
Data Storage Type: Number
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

operation segment id reference to the field operational segment table

General Data Type: Number

operation_dim$trip_id

CC ID: 385408
Seq. Order: 137
Data Storage Type: Number
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

trip identifier number

General Data Type: Number

field_identified_taxonomy_dim$grp_reg_depth_category

CC ID: 385409
Seq. Order: 138
Data Storage Type: Text
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

General Data Type: Text

sample_weight_kg

CC ID: 385410
Seq. Order: 139
Data Storage Type: Number
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Weight of a sample of the catch measured in kilograms

General Data Type: Number
Unit of Measure: kg

transect_whid

CC ID: 385411
Seq. Order: 140
Data Storage Type: Number
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for transect

General Data Type: Number

Catalog Details

Catalog Item ID: 36425
Metadata Record Created By: Jeffrey W Cowen
Metadata Record Created: 2017-01-25 10:28+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2017-03-03
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2018-03-04