Item Identification

Title: BadDepths
Short Name: BadDepths
Status: In Work
Abstract:

Table than is populated during data import if there is data catch data that cannot be imported into the depths table.

Notes:

Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08

Entity Information

Description:

Table than is populated during data import if there is data catch data that cannot be imported into the depths table.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Depth_ID Unknown auto generated
100
Haul_Position_ID Unknown auto generated
100
Vessel Unknown vessel code
100
cruise Unknown cruise number, year + 01. e.g., 200101
100
station Unknown standard station number. >500 = experimental stations
100
hachi Unknown Hachi(also called skate) number. Each hachi gets a number at each station starting with 1 and numbered sequntially.
100
depth_time Unknown time at which hachi was hauled
100
depth Unknown depth taken at haul-back for every 5th skate and when there is a depth stratum change
100
intrpdep Unknown depth interpolated for hachi's where no depth was recorded (recorded for every 5th skate)
100
stratum Unknown depth interval used for summarizing lengths and catch. Increments range from 100-200 meters depending on the stratum
100
baited Unknown number of hooks with bait only at haul-back
100
ineffective Unknown number of hooks that were not fishing effectively at haul-back because they were snarled with other hooks, bent, broken, or missing
100
create_date Unknown date
100
error_description Unknown reason why depth information could not be added to the depths table at import

Attribute Details

Depth_ID

CC ID: 222539
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

auto generated

Allowed Values: No domain defined.

Haul_Position_ID

CC ID: 222540
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

auto generated

Allowed Values: No domain defined.

Vessel

CC ID: 222541
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

vessel code

Allowed Values: No domain defined.

cruise

CC ID: 222542
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

cruise number, year + 01. e.g., 200101

Allowed Values: No domain defined.

station

CC ID: 222543
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

standard station number. >500 = experimental stations

Allowed Values: No domain defined.

hachi

CC ID: 222544
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Hachi(also called skate) number. Each hachi gets a number at each station starting with 1 and numbered sequntially.

Allowed Values: No domain defined.

depth_time

CC ID: 222545
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

time at which hachi was hauled

Allowed Values: No domain defined.

depth

CC ID: 222546
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

depth taken at haul-back for every 5th skate and when there is a depth stratum change

Allowed Values: No domain defined.

intrpdep

CC ID: 222547
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

depth interpolated for hachi's where no depth was recorded (recorded for every 5th skate)

Allowed Values: No domain defined.

stratum

CC ID: 222548
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

depth interval used for summarizing lengths and catch. Increments range from 100-200 meters depending on the stratum

Allowed Values: No domain defined.

baited

CC ID: 222549
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

number of hooks with bait only at haul-back

Allowed Values: No domain defined.

ineffective

CC ID: 222550
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

number of hooks that were not fishing effectively at haul-back because they were snarled with other hooks, bent, broken, or missing

Allowed Values: No domain defined.

create_date

CC ID: 222551
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

date

Allowed Values: No domain defined.

error_description

CC ID: 222552
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

reason why depth information could not be added to the depths table at import

Allowed Values: No domain defined.

Catalog Details

Catalog Item ID: 27274
Metadata Record Created By: Emily A Fergusson
Metadata Record Created: 2015-09-18 13:08+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2016-05-18
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2017-05-19