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

Item Identification

Title: operation_hook_fact

Entity Information

Entity Type: Data Table
Description:

Operation details down to the hook level

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
vessel varchar name of the vessel used for the operation
100
net_touchdown_time time military time representation of the time
100
site_dim$distance_to_port_nm numeric distance from site to nearest port in nautical miles
100
ctd_drop_latitude_whid int4 warehouse identifier for CTD drop latitude
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
angler_person_dim$full_name varchar full name in format of First and Last (Suffix)
100
ctd_drop_longitude_dim$longitude_compass_direction bpchar longitude compass direction
100
ctd_on_bottom_measure_depth_dim$record_type varchar depth record or reason record is unavailable
100
sampling_end_time_dim$period bpchar period of time
100
tide_height_mid_ft numeric tide height at middle (third) drop for a site measured in feet
100
site_dim$site_number int4 site identifier number
100
drop_latitude_dim$named_parallel varchar name of parallel, boundary, or commonly used geograpical location
100
operation_dim$state_registration_number varchar state registration number for the vessel
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
date_dim$record_type varchar date, month, or year record or reason record is unavailable
100
ctd_drop_latitude_dim$latitude_compass_direction bpchar latitude compass direction
100
drop_longitude_dim$longitude_in_degrees numeric numeric representation of longitude in decimal degrees
100
ctd_on_bottom_salinity_psu numeric CTD on bottom salinity in practical salinity units (psu)
100
hook_dim$record_type varchar hook record or reason record is unavailable
100
ctd_drop_longitude_dim$longitude_minute_units int2 numeric representation of longitude that makes up the minute unit only
100
marine_reserve_indicator varchar identifier if the hook was inside a marine reserve
100
operation_dim$scientist_3_person_whid int4 person reference for the third scientist
100
hook_id int4 field database hook identifier
100
angler_person_whid int4 warehouse identifier for angler person
100
tide_height_first_ft numeric tide height at first drop for a site measured in feet
100
ctd_on_bottom_measure_depth_whid int4 warehouse identifier for CTD on bottom measure depth
100
ctd_on_bottom_measure_depth_dim$depth_fathoms numeric depth low precision measurement in fathoms converted from meters measured to the tenth of a meter except for special fathom boundaries
100
sunset_time_whid int4 warehouse identifier for the sunset time
100
site_whid int4 warehouse identifier for site
100
drop_sounder_depth_whid int4 warehouse identifier for drop sounder depth
100
drop_longitude_dim$longitude_second_units int2 numeric representation of longitude that makes up the second unit only
100
site_moon_tide_dim$tide_phase varchar tide phase
100
angler_person_dim$nick_name varchar nickname of person
100
sunrise_time_dim$minute int2 number of minutes in the hour
100
site_dim$tide_station_latitude_whid int4 warehouse identifier to latitude details for site's nearest tide station
100
operation_dim$operation_start_date_whid int8 start date reference for the operation
100
begin_retrieval_interval_sec int4 interval in seconds between gear deployment until gear retrieval began
100
program varchar type of fram program
100
date_dim$month_of_year int2 numeric representation of month of year
100
operation_dim$captain_person_whid int4 person reference for the vessel captain
100
tide_height_last_ft numeric tide height at last (fifth) drop for a site measured in feet
100
set_identifier varchar set identifier
100
inclusion_whid int4 warehouse identifier for what to include in analysis
100
operation_dim$fpc_person_whid int4 person reference for the FPC
100
operation_dim$record_type varchar operation record or reason record is unavailable
100
sampling_start_time_dim$military_hour int2 military representation of the hour
100
angler_person_dim$role varchar role taken during an operation
100
drop_latitude_dim$latitude_in_degree_minute_second varchar string representation of latitude in degrees, minutes, and seconds for example 4525'01"
100
ctd_drop_time_dim$period bpchar period of time
100
ctd_on_bottom_measure_depth_dim$depth_meters numeric depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries)
100
operation_dim$operation_type varchar type of operation
100
swell_height_ft numeric swell height in feet
100
operation_dim$ifq_account_number varchar unique number assigned to user accounts in the Vessel Accounting Database
100
sunrise_time_dim$record_type varchar time record or reason record is unavailable
100
sampling_end_time_dim$hour int2 standard representation of the hour
100
inclusion_dim$record_type varchar inclusion record or reason record is unavailable
100
sinker_weight_lbs int2 sinker weights in pounds
100
inclusion_dim$site_inclusion_indicator varchar indicates if site should be included
100
operation_dim$operation_end_date_whid int8 end date reference for the operation
100
sampling_start_time_dim$second int2 number of seconds in the minute
100
site_dim$tide_station_noaa_id varchar tide station id according to NOAA's Tides and Currents site
100
tide_height_mid_m numeric tide height at middle (third) drop for a site measured in meters
100
sunset_time_dim$second int2 number of seconds in the minute
100
site_general_note varchar site general notes
100
drop_longitude_dim$longitude_compass_direction bpchar longitude compass direction
100
wave_height_m numeric wave height in meters
100
hook_note varchar hook notes
100
site_moon_tide_dim$record_type varchar moon tide record or reason record is unavailable
100
operation_dim$scientist_4_person_whid int4 person reference for the fourth scientist
100
drop_average_sea_surface_temp_c numeric drop average sea surface temperature in degrees celcius
100
ctd_drop_time_whid int4 warehouse identifier for CTD drop time
100
tow_end_timestamp timestamp operation end date timestamp
100
site_dim$inactive_date_whid int8 warehouse identifier for the date when the site went inactive
100
tide_height_first_m numeric tide height at first drop for a site measured in meters
100
angler_person_dim$record_type varchar person record or reason record is unavailable
100
pass int4 pass number of the survey
100
tow_start_timestamp timestamp operation start date timestamp
100
ctd_on_bottom_measure_depth_dim$boundary_indicator varchar depth boundry indicator identifying ifp boundary marks
100
ctd_drop_time_dim$minute int2 number of minutes in the hour
100
sunrise_time_whid int4 warehouse identifier for the sunrise time
100
drop_time_dim$record_type varchar time record or reason record is unavailable
100
drop_latitude_dim$latitude_in_degrees numeric numeric representation of latitude in degrees
100
site_dim$cdfgblock int4 CDFG Block Numbers that the sites fall within
100
operation_dim$coast_guard_number varchar Coast Guard documentation number of vessel
100
operation_dim$operation_start_time_whid int8 start time reference for the operation
100
site_dim$area_name varchar name of area site is located in
100
time_to_first_bite_interval_sec int4 interval in seconds calculated from the difference between first bite and on bottom
100
date_dim$full_date timestamp full date value
100
sunrise_time_dim$hh24miss bpchar concatenation of military hour, minute, second, example 230415 equates to 23:04:15
100
site_dim$site_longitude_whid int4 warehouse identifier to longitude details for site
100
site_dim$cowcod_conservation_area_indicator varchar indicates if site falls within the cowcod conservation area
100
hook_dim$gear_performance varchar Gear performance
100
inclusion_dim$drop_inclusion_indicator varchar indicates if drop should be included
100
sampling_end_time_dim$military_hour int2 military representation of the hour
100
fishing_time_interval_sec int4 interval in seconds calculated from the difference between begin retrieval and on bottomv
100
ctd_drop_longitude_dim$longitude_second_units int2 numeric representation of longitude that makes up the second unit only
100
sunset_time_dim$period bpchar period of time
100
hook_whid int4 warehouse identifier to hook details
100
swell_direction_mag int2 swell direction in magnetic degrees
100
net_liftoff_time time military time representation of the time
100
leg int2 leg number of the survey
100
hook_dim$hook_number int2 The hook number on the line
100
site_dim$site_longitude_dd numeric site longitude in decimal degrees
100
operation_dim$observer_program varchar description of the observer program
100
drop_timestamp timestamp drop timestamp
100
drop_sounder_depth_dim$boundary_indicator varchar depth boundry indicator identifying ifp boundary marks
100
drop_latitude_dd numeric drop latitude in decimal degrees
100
drop_time_dim$hour int2 standard representation of the hour
100
date_dim$month_name varchar text representation of month
100
sunset_time_dim$time time military time representation of the time
100
sampling_start_time_dim$hour int2 standard representation of the hour
100
drop_latitude_whid int4 warehouse identifier for drop latitude
100
ctd_drop_latitude_dim$record_type varchar latitude record type or reason record is unavailable
100
ctd_drop_time_dim$second int2 number of seconds in the minute
100
drop_longitude_dim$longitude_in_degree_minute_second varchar string representation of longitude in degrees, minutes, and seconds for example 4525'01"
100
operation_dim_whid int4 warehouse identifier for operation
100
angler_position varchar position of angler on vessel
100
sunrise_time_dim$military_hour int2 military representation of the hour
100
sunrise_time_dim$second int2 number of seconds in the minute
100
performance varchar performance of the operation
100
ctd_sounder_depth_m numeric CTD sounder depth in meters
100
date_dim$month_abbrev bpchar three character representation of month in capital letters
100
ctd_drop_longitude_whid int4 warehouse identifier for CTD drop longitude
100
drop_time_dim$hh24miss bpchar concatenation of military hour, minute, second, example 230415 equates to 23:04:15
100
ctd_drop_latitude_dd numeric high precision value for CTD drop latitude in decimal degrees
100
site_ocean_weather_note varchar site's ocean and weather notes
100
drop_time_whid int4 warehouse identifier for the drop time
100
operation_dim$departure_port_whid int4 port reference for the departure port
100
angler_person_dim$first_name varchar first name of person
100
sampling_end_hhmmss bpchar concatenation of military hour, minute, second, example 230415 equates to 23:04:15
100
operation_dim$field_operation_seg_id int8 operation segment id reference to the field operational segment table
100
sampling_start_hhmmss bpchar concatenation of military hour, minute, second, example 230415 equates to 23:04:15
100
drop_latitude_dim$latitude_compass_direction bpchar latitude compass direction
100
site_dim$record_type varchar site record or reason record is unavailable
100
swell_height_m numeric swell height in meters
100
ctd_drop_time_dim$hour int2 standard representation of the hour
100
date_dim$day_of_month int2 numeric representation of the day in month
100
sea_surface_temp_c numeric sea surface temperature in degrees celcius
100
operation_dim$scientist_2_person_whid int4 person reference for the second scientist
100
drop_latitude_dim$latitude_degree_units int2 numeric representation of latitude that makes up the degree unit only
100
drop_time_dim$second int2 number of seconds in the minute
100
fish_info_note varchar overall fish information note
100
date_yyyymmdd bpchar text representation of year month day
100
drop_time_dim$period bpchar period of time
100
ctd_drop_latitude_dim$named_parallel varchar name of parallel, boundary, or commonly used geograpical location
100
site_moon_tide_dim$tide_type varchar tide type
100
date_dim$year int4 numeric representation of year
100
sunrise_time_dim$time time military time representation of the time
100
ctd_drop_latitude_dim$latitude_degree_units int2 numeric representation of latitude that makes up the degree unit only
100
site_dim$tide_station_longitude_whid int4 warehouse identifier to longitude details for site's nearest tide station
100
operation_dim$scientist_1_person_whid int4 person reference for the first scientist
100
sampling_end_time_dim$record_type varchar time record or reason record is unavailable
100
first_bite_interval_sec int4 interval in seconds between gear deployment until angler feels first bite
100
site_dim$tide_station_name varchar name of nearest tide station
100
angler_person_dim$middle_initial bpchar middle initial of person
100
drop_time_dim$military_hour int2 military representation of the hour
100
sunset_time_dim$record_type varchar time record or reason record is unavailable
100
ctd_drop_time_dim$time time military time representation of the time
100
ctd_on_bottom_disolved_oxygen_sbe43_ml_per_l numeric CTD SBE43 sensor on bottom disolved oxygen measured in milliliters per liter
100
at_surface_interval_sec int4 interval in seconds between gear deployment until gear reaches surface concluding the drop
100
ctd_drop_time_dim$military_hour int2 military representation of the hour
100
site_habitat_note varchar site habitat notes
100
drop_latitude_dim$latitude_second_units int2 numeric representation of latitude that makes up the second unit only
100
ctd_on_bottom_disolved_oxygen_aanderaa_ml_per_l numeric CTD aanderaa sensor on bottom disolved oxygen measured in milliliters per liter
100
wave_height_ft numeric wave height in feet
100
drop_longitude_dim$longitude_minute_units int2 numeric representation of longitude that makes up the minute unit only
100
ctd_sounder_depth_dim$depth_meters numeric depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries)
100
ctd_drop_longitude_dim$record_type varchar longitude record type or reason record is unavailable
100
sampling_start_time_dim$period bpchar period of time
100
drop_time_dim$time time military time representation of the time
100
angler_person_dim$last_name varchar last name of person
100
drop_latitude_dim$latitude_minute_units int2 numeric representation of latitude that makes up the minute unit only
100
ctd_on_bottom_temp_c numeric CTD on bottom temperature in degrees celcius
100
drop_latitude_dim$record_type varchar latitude record type or reason record is unavailable
100
drop_longitude_dim$record_type varchar longitude record type or reason record is unavailable
100
operation_dim$return_port_whid int4 port reference for return port
100
sunrise_time_dim$hour int2 standard representation of the hour
100
sampling_end_time_dim$minute int2 number of minutes in the hour
100
tide_height_last_m numeric tide height at last (fifth) drop for a site measured in meters
100
ctd_drop_time_dim$hh24miss bpchar concatenation of military hour, minute, second, example 230415 equates to 23:04:15
100
operation_dim$trip_id int4 trip identifier number
100
project varchar project name
100
ctd_sounder_depth_dim$record_type varchar depth record or reason record is unavailable
100
ctd_drop_longitude_dim$longitude_in_degree_minute_second varchar string representation of longitude in degrees, minutes, and seconds for example 4525'01"
100
ctd_sounder_depth_dim$boundary_indicator varchar depth boundry indicator identifying ifp boundary marks
100
drop_sounder_depth_dim$record_type varchar depth record or reason record is unavailable
100
drop_longitude_dim$longitude_degree_units int2 numeric representation of longitude that makes up the degree unit only
100
tow int2 operation number of the survey
100
ctd_drop_longitude_dim$longitude_in_degrees numeric numeric representation of longitude in decimal degrees
100
ctd_drop_time_dim$record_type varchar time record or reason record is unavailable
100
date_whid int4 warehouse identifier for date
100
sunset_time_dim$military_hour int2 military representation of the hour
100
on_bottom_interval_sec int4 interval in seconds between gear deployment until it hits bottom
100
site_dim$site_latitude_dd numeric site latitude in decimal degrees
100
ctd_drop_longitude_dd numeric high precision value for CTD drop longitude in decimal degrees
100
ctd_sounder_depth_dim$depth_fathoms numeric depth low precision measurement in fathoms converted from meters measured to the tenth of a meter except for special fathom boundaries
100
drop_longitude_dd numeric drop longitude in decimal degrees
100
hook_dim$hook_result varchar The result of using the hook
100
operation_dim$operation_end_time_whid int8 end time reference for the operation
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
sampling_end_time_dim$second int2 number of seconds in the minute
100
operation_dim$departure_date_whid int8 date reference that vessel departed for the defined leg or trip
100
sunset_time_dim$hour int2 standard representation of the hour
100
sampling_start_time_dim$record_type varchar time record or reason record is unavailable
100
sunset_time_dim$minute int2 number of minutes in the hour
100
ctd_drop_latitude_dim$latitude_in_degrees numeric numeric representation of latitude in degrees
100
site_dim$site_latitude_whid int4 warehouse identifier to latitude details for site
100
drop_detail_note varchar drop detail notes
100
sunset_time_dim$hh24miss bpchar concatenation of military hour, minute, second, example 230415 equates to 23:04:15
100
drop_time_dim$minute int2 number of minutes in the hour
100
inclusion_dim$hook_inclusion_indicator varchar indicates if hook should be included
100
sunrise_time_dim$period bpchar period of time
100
ctd_drop_latitude_dim$latitude_second_units int2 numeric representation of latitude that makes up the second unit only
100
sampling_start_time_dim$minute int2 number of minutes in the hour
100
ctd_on_bottom_measure_depth_m numeric CTD on bottom measured depth in meters
100
operation_dim$vessel_id int2 field database vessel id number
100
drop_longitude_whid int4 warehouse identifier for drop latitude
100
operation_dim$return_date_whid int8 date reference that vessel returned for the defined leg or trip
100
ctd_drop_latitude_dim$latitude_minute_units int2 numeric representation of latitude that makes up the minute unit only
100
site_moon_tide_whid int2 warehouse identifier for site moon tide
100
site_moon_tide_dim$moon_phase varchar moon phase
100
ctd_sounder_depth_whid int4 warehouse identifier for CTD sounder depth
100
ctd_drop_longitude_dim$longitude_degree_units int2 numeric representation of longitude that makes up the degree unit only
100
site_fish_finder_note varchar site fish finder notes
100
year int2 operation year
100
ctd_drop_latitude_dim$latitude_in_degree_minute_second varchar string representation of latitude in degrees, minutes, and seconds for example 4525'01"
100
sampling_end_time_whid int4 warehouse identifier for the sampling end time
100
sampling_start_time_whid int4 warehouse identifier for the sampling start time
100
full_moon_pct int2 percent of full moon
100
trawl_id int8 identifier for a sampling operation

Attribute Details

vessel

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

net_touchdown_time

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

military time representation of the time

site_dim$distance_to_port_nm

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

ctd_drop_latitude_whid

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

warehouse identifier for CTD drop latitude

drop_sounder_depth_dim$depth_meters

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

angler_person_dim$full_name

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

full name in format of First and Last (Suffix)

ctd_drop_longitude_dim$longitude_compass_direction

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

longitude compass direction

Allowed Values: E, W

ctd_on_bottom_measure_depth_dim$record_type

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

depth record or reason record is unavailable

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

sampling_end_time_dim$period

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

period of time

Allowed Values: AM, PM

tide_height_mid_ft

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

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

Unit of Measure: ft

site_dim$site_number

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

site identifier number

drop_latitude_dim$named_parallel

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

operation_dim$state_registration_number

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

state registration number for the vessel

operation_dim$limited_entry_permit_number

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

date_dim$record_type

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

ctd_drop_latitude_dim$latitude_compass_direction

CC ID: 377948
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_in_degrees

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

numeric representation of longitude in decimal degrees

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

ctd_on_bottom_salinity_psu

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

CTD on bottom salinity in practical salinity units (psu)

Unit of Measure: psu

hook_dim$record_type

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

ctd_drop_longitude_dim$longitude_minute_units

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

numeric representation of longitude that makes up the minute unit only

Unit of Measure: min
Allowed Values: 0-59

marine_reserve_indicator

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

identifier if the hook was inside a marine reserve

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

operation_dim$scientist_3_person_whid

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

person reference for the third scientist

hook_id

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

field database hook identifier

angler_person_whid

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

warehouse identifier for angler person

tide_height_first_ft

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

tide height at first drop for a site measured in feet

Unit of Measure: ft

ctd_on_bottom_measure_depth_whid

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

warehouse identifier for CTD on bottom measure depth

ctd_on_bottom_measure_depth_dim$depth_fathoms

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

sunset_time_whid

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

warehouse identifier for the sunset time

site_whid

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

warehouse identifier for site

drop_sounder_depth_whid

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

warehouse identifier for drop sounder depth

drop_longitude_dim$longitude_second_units

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

site_moon_tide_dim$tide_phase

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

tide phase

Allowed Values: Ebb, Flood, Steady

angler_person_dim$nick_name

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

nickname of person

sunrise_time_dim$minute

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

number of minutes in the hour

Unit of Measure: min
Allowed Values: 0-60

site_dim$tide_station_latitude_whid

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

operation_dim$operation_start_date_whid

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

start date reference for the operation

begin_retrieval_interval_sec

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

interval in seconds between gear deployment until gear retrieval began

Unit of Measure: sec

program

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

date_dim$month_of_year

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

operation_dim$captain_person_whid

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

person reference for the vessel captain

tide_height_last_ft

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

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

Unit of Measure: ft

set_identifier

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

set identifier

inclusion_whid

CC ID: 377975
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$fpc_person_whid

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

person reference for the FPC

operation_dim$record_type

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

sampling_start_time_dim$military_hour

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

angler_person_dim$role

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

drop_latitude_dim$latitude_in_degree_minute_second

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

ctd_drop_time_dim$period

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

period of time

Allowed Values: AM, PM

ctd_on_bottom_measure_depth_dim$depth_meters

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

operation_dim$operation_type

CC ID: 377983
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]

swell_height_ft

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

swell height in feet

Unit of Measure: ft

operation_dim$ifq_account_number

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

sunrise_time_dim$record_type

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

time record or reason record is unavailable

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

sampling_end_time_dim$hour

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

inclusion_dim$record_type

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

sinker_weight_lbs

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

sinker weights in pounds

Unit of Measure: lbs

inclusion_dim$site_inclusion_indicator

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

operation_dim$operation_end_date_whid

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

end date reference for the operation

sampling_start_time_dim$second

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

site_dim$tide_station_noaa_id

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

tide_height_mid_m

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

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

Unit of Measure: m

sunset_time_dim$second

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

site_general_note

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

site general notes

drop_longitude_dim$longitude_compass_direction

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

longitude compass direction

Allowed Values: E, W

wave_height_m

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

wave height in meters

Unit of Measure: m

hook_note

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

hook notes

site_moon_tide_dim$record_type

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

moon tide record or reason record is unavailable

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

operation_dim$scientist_4_person_whid

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

person reference for the fourth scientist

drop_average_sea_surface_temp_c

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

drop average sea surface temperature in degrees celcius

Unit of Measure: c

ctd_drop_time_whid

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

warehouse identifier for CTD drop time

tow_end_timestamp

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

operation end date timestamp

site_dim$inactive_date_whid

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

tide_height_first_m

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

tide height at first drop for a site measured in meters

Unit of Measure: m

angler_person_dim$record_type

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

pass

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

tow_start_timestamp

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

operation start date timestamp

ctd_on_bottom_measure_depth_dim$boundary_indicator

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

ctd_drop_time_dim$minute

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

sunrise_time_whid

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

warehouse identifier for the sunrise time

drop_time_dim$record_type

CC ID: 378013
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_in_degrees

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

numeric representation of latitude in degrees

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

site_dim$cdfgblock

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

operation_dim$coast_guard_number

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

Coast Guard documentation number of vessel

operation_dim$operation_start_time_whid

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

start time reference for the operation

site_dim$area_name

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

name of area site is located in

time_to_first_bite_interval_sec

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

interval in seconds calculated from the difference between first bite and on bottom

Unit of Measure: sec

date_dim$full_date

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

full date value

sunrise_time_dim$hh24miss

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

site_dim$site_longitude_whid

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

warehouse identifier to longitude details for site

site_dim$cowcod_conservation_area_indicator

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

hook_dim$gear_performance

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

inclusion_dim$drop_inclusion_indicator

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

sampling_end_time_dim$military_hour

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

fishing_time_interval_sec

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

interval in seconds calculated from the difference between begin retrieval and on bottomv

Unit of Measure: sec

ctd_drop_longitude_dim$longitude_second_units

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

numeric representation of longitude that makes up the second unit only

Unit of Measure: sec
Allowed Values: 0-59

sunset_time_dim$period

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

period of time

Allowed Values: AM, PM

hook_whid

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

warehouse identifier to hook details

swell_direction_mag

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

swell direction in magnetic degrees

Unit of Measure: mag

net_liftoff_time

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

military time representation of the time

leg

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

hook_dim$hook_number

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

site_dim$site_longitude_dd

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

operation_dim$observer_program

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

description of the observer program

drop_timestamp

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

drop timestamp

drop_sounder_depth_dim$boundary_indicator

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

drop_latitude_dd

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

drop latitude in decimal degrees

Unit of Measure: dd

drop_time_dim$hour

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

date_dim$month_name

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

sunset_time_dim$time

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

military time representation of the time

sampling_start_time_dim$hour

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

drop_latitude_whid

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

warehouse identifier for drop latitude

ctd_drop_latitude_dim$record_type

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

ctd_drop_time_dim$second

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

drop_longitude_dim$longitude_in_degree_minute_second

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

operation_dim_whid

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

warehouse identifier for operation

angler_position

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

position of angler on vessel

Allowed Values: Bow (a), Mid-ship (b), Stern (c)

sunrise_time_dim$military_hour

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

sunrise_time_dim$second

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

performance

CC ID: 378052
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]

ctd_sounder_depth_m

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

CTD sounder depth in meters

Unit of Measure: m

date_dim$month_abbrev

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

three character representation of month in capital letters

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

ctd_drop_longitude_whid

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

warehouse identifier for CTD drop longitude

drop_time_dim$hh24miss

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

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

ctd_drop_latitude_dd

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

high precision value for CTD drop latitude in decimal degrees

Unit of Measure: dd

site_ocean_weather_note

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

site's ocean and weather notes

drop_time_whid

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

warehouse identifier for the drop time

operation_dim$departure_port_whid

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

port reference for the departure port

angler_person_dim$first_name

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

first name of person

sampling_end_hhmmss

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

operation_dim$field_operation_seg_id

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

sampling_start_hhmmss

CC ID: 378064
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_compass_direction

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

site_dim$record_type

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

swell_height_m

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

swell height in meters

Unit of Measure: m

ctd_drop_time_dim$hour

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

date_dim$day_of_month

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

numeric representation of the day in month

Allowed Values: 1-31

sea_surface_temp_c

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

sea surface temperature in degrees celcius

Unit of Measure: c

operation_dim$scientist_2_person_whid

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

person reference for the second scientist

drop_latitude_dim$latitude_degree_units

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

drop_time_dim$second

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

fish_info_note

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

overall fish information note

date_yyyymmdd

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

text representation of year month day

drop_time_dim$period

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

period of time

Allowed Values: AM, PM

ctd_drop_latitude_dim$named_parallel

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

name of parallel, boundary, or commonly used geograpical location

Unit of Measure: NA
Allowed Values: any

site_moon_tide_dim$tide_type

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

tide type

Allowed Values: Spring, Neap, Neither

date_dim$year

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

numeric representation of year

Allowed Values: 1978+

sunrise_time_dim$time

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

military time representation of the time

ctd_drop_latitude_dim$latitude_degree_units

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

site_dim$tide_station_longitude_whid

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

operation_dim$scientist_1_person_whid

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

person reference for the first scientist

sampling_end_time_dim$record_type

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

first_bite_interval_sec

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

interval in seconds between gear deployment until angler feels first bite

Unit of Measure: sec

site_dim$tide_station_name

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

name of nearest tide station

angler_person_dim$middle_initial

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

middle initial of person

drop_time_dim$military_hour

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

sunset_time_dim$record_type

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

time record or reason record is unavailable

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

ctd_drop_time_dim$time

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

military time representation of the time

ctd_on_bottom_disolved_oxygen_sbe43_ml_per_l

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

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

Unit of Measure: ml/l

at_surface_interval_sec

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

interval in seconds between gear deployment until gear reaches surface concluding the drop

Unit of Measure: sec

ctd_drop_time_dim$military_hour

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

military representation of the hour

Allowed Values: 0-24

site_habitat_note

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

site habitat notes

drop_latitude_dim$latitude_second_units

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

ctd_on_bottom_disolved_oxygen_aanderaa_ml_per_l

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

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

Unit of Measure: ml/l

wave_height_ft

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

wave height in feet

Unit of Measure: ft

drop_longitude_dim$longitude_minute_units

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

ctd_sounder_depth_dim$depth_meters

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

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

Unit of Measure: m
Allowed Values: 0-1500

ctd_drop_longitude_dim$record_type

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

sampling_start_time_dim$period

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

period of time

Allowed Values: AM, PM

drop_time_dim$time

CC ID: 378102
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: 378103
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

last name of person

drop_latitude_dim$latitude_minute_units

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

ctd_on_bottom_temp_c

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

CTD on bottom temperature in degrees celcius

Unit of Measure: c

drop_latitude_dim$record_type

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

drop_longitude_dim$record_type

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

operation_dim$return_port_whid

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

port reference for return port

sunrise_time_dim$hour

CC ID: 378109
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_end_time_dim$minute

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

number of minutes in the hour

Unit of Measure: min
Allowed Values: 0-60

tide_height_last_m

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

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

Unit of Measure: m

ctd_drop_time_dim$hh24miss

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

operation_dim$trip_id

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

trip identifier number

project

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

ctd_sounder_depth_dim$record_type

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

ctd_drop_longitude_dim$longitude_in_degree_minute_second

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

ctd_sounder_depth_dim$boundary_indicator

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

drop_sounder_depth_dim$record_type

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

drop_longitude_dim$longitude_degree_units

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

tow

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

operation number of the survey

ctd_drop_longitude_dim$longitude_in_degrees

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

numeric representation of longitude in decimal degrees

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

ctd_drop_time_dim$record_type

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

time record or reason record is unavailable

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

date_whid

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

warehouse identifier for date

sunset_time_dim$military_hour

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

on_bottom_interval_sec

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

interval in seconds between gear deployment until it hits bottom

Unit of Measure: sec

site_dim$site_latitude_dd

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

site latitude in decimal degrees

Unit of Measure: dd

ctd_drop_longitude_dd

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

high precision value for CTD drop longitude in decimal degrees

Unit of Measure: dd

ctd_sounder_depth_dim$depth_fathoms

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

drop_longitude_dd

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

drop longitude in decimal degrees

Unit of Measure: dd

hook_dim$hook_result

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

operation_dim$operation_end_time_whid

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

end time reference for the operation

drop_sounder_depth_dim$depth_fathoms

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

sampling_end_time_dim$second

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

operation_dim$departure_date_whid

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

sunset_time_dim$hour

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

standard representation of the hour

Unit of Measure: hr
Allowed Values: 0-12

sampling_start_time_dim$record_type

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

time record or reason record is unavailable

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

sunset_time_dim$minute

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

number of minutes in the hour

Unit of Measure: min
Allowed Values: 0-60

ctd_drop_latitude_dim$latitude_in_degrees

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

numeric representation of latitude in degrees

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

site_dim$site_latitude_whid

CC ID: 378139
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_detail_note

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

drop detail notes

sunset_time_dim$hh24miss

CC ID: 378141
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_time_dim$minute

CC ID: 378142
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: 378143
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

sunrise_time_dim$period

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

period of time

Allowed Values: AM, PM

ctd_drop_latitude_dim$latitude_second_units

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

numeric representation of latitude that makes up the second unit only

Unit of Measure: sec
Allowed Values: 0-60

sampling_start_time_dim$minute

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

number of minutes in the hour

Unit of Measure: min
Allowed Values: 0-60

ctd_on_bottom_measure_depth_m

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

CTD on bottom measured depth in meters

Unit of Measure: m

operation_dim$vessel_id

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

field database vessel id number

drop_longitude_whid

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

warehouse identifier for drop latitude

operation_dim$return_date_whid

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

ctd_drop_latitude_dim$latitude_minute_units

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

numeric representation of latitude that makes up the minute unit only

Unit of Measure: min
Allowed Values: 0-60

site_moon_tide_whid

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

warehouse identifier for site moon tide

site_moon_tide_dim$moon_phase

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

moon phase

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

ctd_sounder_depth_whid

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

warehouse identifier for CTD sounder depth

ctd_drop_longitude_dim$longitude_degree_units

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

numeric representation of longitude that makes up the degree unit only

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

site_fish_finder_note

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

site fish finder notes

year

CC ID: 378157
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+

ctd_drop_latitude_dim$latitude_in_degree_minute_second

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

sampling_end_time_whid

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

warehouse identifier for the sampling end time

sampling_start_time_whid

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

warehouse identifier for the sampling start time

full_moon_pct

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

percent of full moon

trawl_id

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

identifier for a sampling operation

Catalog Details

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