Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Fisheries Research and Monitoring Divisio... > Stock Assessment Program > Bottomfish tagging > Bottomfish tagging data >

PIFG_TAGGING

Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:58731 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Data for cooperative research tagging studies in MHI and Guam.

Description

Data for cooperative research tagging studies in MHI and Guam.

Entity Type
Data Table

Data Attribute / Type	Description
DATASET_CODE VARCHAR2	Source ID Code assigned by the data entry staff (FC076).
VERSION_CODE VARCHAR2	Code for the format version assigned by the data entry staff.
ISLAND VARCHAR2	Island where fishing took place.
VESSEL_NAME VARCHAR2	Vessel name.
CAPTAIN_FIRST_NAME VARCHAR2	First name of captain.
CAPTAIN_LAST_NAME VARCHAR2	Last name of captain.
TRIP_START_MONTH VARCHAR2	The month the trip started in.
TRIP_START_DAY VARCHAR2	The day the trip started on.
TRIP_START_YEAR VARCHAR2	The year the trip started in.
TRIP_END_MONTH VARCHAR2	The month the trip ended in.
TRIP_END_DAY VARCHAR2	The day the trip ended on.
TRIP_END_YEAR VARCHAR2	The year the trip ended in.
FISHING_LOCATION VARCHAR2	Location where fishing occurred, if written in.
TAG_NUMBER_1 VARCHAR2	Tag number.
FORK_LENGTH_INCHES VARCHAR2	Fork length in inches. Units for values are inches.
FORK_LENGTH_CENTIMETERS VARCHAR2	Fork length in centimeters. Units for values are centimeters.
PURGE VARCHAR2	Was a tool used to treat barotrauma (Y=yes, Blank=no).
DROP_SHOT VARCHAR2	Was a weighted recompression device used to treat baratrauma (Y=yes, Blank=no).
RECAPTURED VARCHAR2	Was the fish a recapture (Y=yes, Blank=no).
RECAPTURED_AND_RELEASED VARCHAR2	If the fish was a recapture, was it released (Y=yes, Blank=no).
TAG_NUMBER_2 VARCHAR2	Additional tag number.
SPECIES VARCHAR2	Species of fish caught.
DATE_CAPTURED_MONTH VARCHAR2	Month fish was caught.
DATE_CAPTURED_DAY VARCHAR2	Day fish was caught.
DATE_CAPTURED_YEAR VARCHAR2	Year fish was caught.
LATITUDE_DEGREES VARCHAR2	Degrees latitutde where fish was caught. Units for values are degrees.
LATITUDE_MINUTES VARCHAR2	Minutes latitutde where fish was caught. Units for values are minutes.
LATITUDE_DIRECTION VARCHAR2	Latitude direction (N/S) where fish was caught.
LONGITUDE_DEGREES VARCHAR2	Degrees longitude where fish was caught. Units for values are degrees.
LONGITUDE_MINUTES VARCHAR2	Minutes longitude where fish was caught. Units for values are minutes.
LONGITUDE_DIRECTION VARCHAR2	Longitude direction (E/W) where fish was caught.
STATE_CHART_AREA_CODE VARCHAR2	State of Hawaii area code, if in Hawaii.
DEPTH_FATHOMS VARCHAR2	Depth in fathoms where fish was caught. Units for values are fathoms.
DEPTH_METERS VARCHAR2	Depth in meters where fish was caught. Units for values are meters.
NOTES_LINE_1 VARCHAR2	First line of comments from fisher.
NOTES_LINE_2 VARCHAR2	Second line of comments from fisher.
NOTES_LINE_3 VARCHAR2	Third line of comments from fisher.
JOB_NUMBER VARCHAR2	A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D12045.
FROM_FILE VARCHAR2	Name of the flat ASCII file that was the source of the data.
DATE_LOADED DATE	Date when the record was loaded into Oracle or updated.
TAGGER VARCHAR2	Name of individual tagging the fish.

Data Attribute / Type

Description

DATASET_CODE
VARCHAR2

Source ID Code assigned by the data entry staff (FC076).

VERSION_CODE
VARCHAR2

Code for the format version assigned by the data entry staff.

ISLAND
VARCHAR2

Island where fishing took place.

VESSEL_NAME
VARCHAR2

Vessel name.

CAPTAIN_FIRST_NAME
VARCHAR2

First name of captain.

CAPTAIN_LAST_NAME
VARCHAR2

Last name of captain.

TRIP_START_MONTH
VARCHAR2

The month the trip started in.

TRIP_START_DAY
VARCHAR2

The day the trip started on.

TRIP_START_YEAR
VARCHAR2

The year the trip started in.

TRIP_END_MONTH
VARCHAR2

The month the trip ended in.

TRIP_END_DAY
VARCHAR2

The day the trip ended on.

TRIP_END_YEAR
VARCHAR2

The year the trip ended in.

FISHING_LOCATION
VARCHAR2

Location where fishing occurred, if written in.

TAG_NUMBER_1
VARCHAR2

Tag number.

FORK_LENGTH_INCHES
VARCHAR2

Fork length in inches. Units for values are inches.

FORK_LENGTH_CENTIMETERS
VARCHAR2

Fork length in centimeters. Units for values are centimeters.

PURGE
VARCHAR2

Was a tool used to treat barotrauma (Y=yes, Blank=no).

DROP_SHOT
VARCHAR2

Was a weighted recompression device used to treat baratrauma (Y=yes, Blank=no).

RECAPTURED
VARCHAR2

Was the fish a recapture (Y=yes, Blank=no).

RECAPTURED_AND_RELEASED
VARCHAR2

If the fish was a recapture, was it released (Y=yes, Blank=no).

TAG_NUMBER_2
VARCHAR2

Additional tag number.

SPECIES
VARCHAR2

Species of fish caught.

DATE_CAPTURED_MONTH
VARCHAR2

Month fish was caught.

DATE_CAPTURED_DAY
VARCHAR2

Day fish was caught.

DATE_CAPTURED_YEAR
VARCHAR2

Year fish was caught.

LATITUDE_DEGREES
VARCHAR2

Degrees latitutde where fish was caught. Units for values are degrees.

LATITUDE_MINUTES
VARCHAR2

Minutes latitutde where fish was caught. Units for values are minutes.

LATITUDE_DIRECTION
VARCHAR2

Latitude direction (N/S) where fish was caught.

LONGITUDE_DEGREES
VARCHAR2

Degrees longitude where fish was caught. Units for values are degrees.

LONGITUDE_MINUTES
VARCHAR2

Minutes longitude where fish was caught. Units for values are minutes.

LONGITUDE_DIRECTION
VARCHAR2

Longitude direction (E/W) where fish was caught.

STATE_CHART_AREA_CODE
VARCHAR2

State of Hawaii area code, if in Hawaii.

DEPTH_FATHOMS
VARCHAR2

Depth in fathoms where fish was caught. Units for values are fathoms.

DEPTH_METERS
VARCHAR2

Depth in meters where fish was caught. Units for values are meters.

NOTES_LINE_1
VARCHAR2

First line of comments from fisher.

NOTES_LINE_2
VARCHAR2

Second line of comments from fisher.

NOTES_LINE_3
VARCHAR2

Third line of comments from fisher.

JOB_NUMBER
VARCHAR2

A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D12045.

FROM_FILE
VARCHAR2

Name of the flat ASCII file that was the source of the data.

DATE_LOADED
DATE

Date when the record was loaded into Oracle or updated.

TAGGER
VARCHAR2

Name of individual tagging the fish.

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

Title:	PIFG_TAGGING
Short Name:	PIFG_TAGGING
Status:	Completed
Abstract:	Data for cooperative research tagging studies in MHI and Guam.

Entity Type:	Data Table
Active Version?:	Yes
Description:	Data for cooperative research tagging studies in MHI and Guam.

Attribute Summary

	Name	Type	Description
100	DATASET_CODE	VARCHAR2	Source ID Code assigned by the data entry staff (FC076).
100	VERSION_CODE	VARCHAR2	Code for the format version assigned by the data entry staff.
100	ISLAND	VARCHAR2	Island where fishing took place.
100	VESSEL_NAME	VARCHAR2	Vessel name.
100	CAPTAIN_FIRST_NAME	VARCHAR2	First name of captain.
100	CAPTAIN_LAST_NAME	VARCHAR2	Last name of captain.
100	TRIP_START_MONTH	VARCHAR2	The month the trip started in.
100	TRIP_START_DAY	VARCHAR2	The day the trip started on.
100	TRIP_START_YEAR	VARCHAR2	The year the trip started in.
100	TRIP_END_MONTH	VARCHAR2	The month the trip ended in.
100	TRIP_END_DAY	VARCHAR2	The day the trip ended on.
100	TRIP_END_YEAR	VARCHAR2	The year the trip ended in.
100	FISHING_LOCATION	VARCHAR2	Location where fishing occurred, if written in.
100	TAG_NUMBER_1	VARCHAR2	Tag number.
100	FORK_LENGTH_INCHES	VARCHAR2	Fork length in inches. Units for values are inches.
100	FORK_LENGTH_CENTIMETERS	VARCHAR2	Fork length in centimeters. Units for values are centimeters.
100	PURGE	VARCHAR2	Was a tool used to treat barotrauma (Y=yes, Blank=no).
100	DROP_SHOT	VARCHAR2	Was a weighted recompression device used to treat baratrauma (Y=yes, Blank=no).
100	RECAPTURED	VARCHAR2	Was the fish a recapture (Y=yes, Blank=no).
100	RECAPTURED_AND_RELEASED	VARCHAR2	If the fish was a recapture, was it released (Y=yes, Blank=no).
100	TAG_NUMBER_2	VARCHAR2	Additional tag number.
100	SPECIES	VARCHAR2	Species of fish caught.
100	DATE_CAPTURED_MONTH	VARCHAR2	Month fish was caught.
100	DATE_CAPTURED_DAY	VARCHAR2	Day fish was caught.
100	DATE_CAPTURED_YEAR	VARCHAR2	Year fish was caught.
100	LATITUDE_DEGREES	VARCHAR2	Degrees latitutde where fish was caught. Units for values are degrees.
100	LATITUDE_MINUTES	VARCHAR2	Minutes latitutde where fish was caught. Units for values are minutes.
100	LATITUDE_DIRECTION	VARCHAR2	Latitude direction (N/S) where fish was caught.
100	LONGITUDE_DEGREES	VARCHAR2	Degrees longitude where fish was caught. Units for values are degrees.
100	LONGITUDE_MINUTES	VARCHAR2	Minutes longitude where fish was caught. Units for values are minutes.
100	LONGITUDE_DIRECTION	VARCHAR2	Longitude direction (E/W) where fish was caught.
100	STATE_CHART_AREA_CODE	VARCHAR2	State of Hawaii area code, if in Hawaii.
100	DEPTH_FATHOMS	VARCHAR2	Depth in fathoms where fish was caught. Units for values are fathoms.
100	DEPTH_METERS	VARCHAR2	Depth in meters where fish was caught. Units for values are meters.
100	NOTES_LINE_1	VARCHAR2	First line of comments from fisher.
100	NOTES_LINE_2	VARCHAR2	Second line of comments from fisher.
100	NOTES_LINE_3	VARCHAR2	Third line of comments from fisher.
100	JOB_NUMBER	VARCHAR2	A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D12045.
100	FROM_FILE	VARCHAR2	Name of the flat ASCII file that was the source of the data.
100	DATE_LOADED	DATE	Date when the record was loaded into Oracle or updated.
100	TAGGER	VARCHAR2	Name of individual tagging the fish.

Name

Type

Description

100

DATASET_CODE

VARCHAR2

Source ID Code assigned by the data entry staff (FC076).

100

VERSION_CODE

VARCHAR2

Code for the format version assigned by the data entry staff.

100

ISLAND

VARCHAR2

Island where fishing took place.

100

VESSEL_NAME

VARCHAR2

Vessel name.

100

CAPTAIN_FIRST_NAME

VARCHAR2

First name of captain.

100

CAPTAIN_LAST_NAME

VARCHAR2

Last name of captain.

100

TRIP_START_MONTH

VARCHAR2

The month the trip started in.

100

TRIP_START_DAY

VARCHAR2

The day the trip started on.

100

TRIP_START_YEAR

VARCHAR2

The year the trip started in.

100

TRIP_END_MONTH

VARCHAR2

The month the trip ended in.

100

TRIP_END_DAY

VARCHAR2

The day the trip ended on.

100

TRIP_END_YEAR

VARCHAR2

The year the trip ended in.

100

FISHING_LOCATION

VARCHAR2

Location where fishing occurred, if written in.

100

TAG_NUMBER_1

VARCHAR2

Tag number.

100

FORK_LENGTH_INCHES

VARCHAR2

Fork length in inches. Units for values are inches.

100

FORK_LENGTH_CENTIMETERS

VARCHAR2

Fork length in centimeters. Units for values are centimeters.

100

PURGE

VARCHAR2

Was a tool used to treat barotrauma (Y=yes, Blank=no).

100

DROP_SHOT

VARCHAR2

Was a weighted recompression device used to treat baratrauma (Y=yes, Blank=no).

100

RECAPTURED

VARCHAR2

Was the fish a recapture (Y=yes, Blank=no).

100

RECAPTURED_AND_RELEASED

VARCHAR2

If the fish was a recapture, was it released (Y=yes, Blank=no).

100

TAG_NUMBER_2

VARCHAR2

Additional tag number.

100

SPECIES

VARCHAR2

Species of fish caught.

100

DATE_CAPTURED_MONTH

VARCHAR2

Month fish was caught.

100

DATE_CAPTURED_DAY

VARCHAR2

Day fish was caught.

100

DATE_CAPTURED_YEAR

VARCHAR2

Year fish was caught.

100

LATITUDE_DEGREES

VARCHAR2

Degrees latitutde where fish was caught. Units for values are degrees.

100

LATITUDE_MINUTES

VARCHAR2

Minutes latitutde where fish was caught. Units for values are minutes.

100

LATITUDE_DIRECTION

VARCHAR2

Latitude direction (N/S) where fish was caught.

100

LONGITUDE_DEGREES

VARCHAR2

Degrees longitude where fish was caught. Units for values are degrees.

100

LONGITUDE_MINUTES

VARCHAR2

Minutes longitude where fish was caught. Units for values are minutes.

100

LONGITUDE_DIRECTION

VARCHAR2

Longitude direction (E/W) where fish was caught.

100

STATE_CHART_AREA_CODE

VARCHAR2

State of Hawaii area code, if in Hawaii.

100

DEPTH_FATHOMS

VARCHAR2

Depth in fathoms where fish was caught. Units for values are fathoms.

100

DEPTH_METERS

VARCHAR2

Depth in meters where fish was caught. Units for values are meters.

100

NOTES_LINE_1

VARCHAR2

First line of comments from fisher.

100

NOTES_LINE_2

VARCHAR2

Second line of comments from fisher.

100

NOTES_LINE_3

VARCHAR2

Third line of comments from fisher.

100

JOB_NUMBER

VARCHAR2

100

FROM_FILE

VARCHAR2

Name of the flat ASCII file that was the source of the data.

100

DATE_LOADED

DATE

Date when the record was loaded into Oracle or updated.

100

TAGGER

VARCHAR2

Name of individual tagging the fish.

Attribute Details

DATASET_CODE

CC ID: 895991

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Status:	Active
Description:	Source ID Code assigned by the data entry staff (FC076).
General Data Type:	VARCHAR2

VERSION_CODE

CC ID: 895992

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for the format version assigned by the data entry staff.
General Data Type:	VARCHAR2

ISLAND

CC ID: 895993

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	Island where fishing took place.
General Data Type:	VARCHAR2

VESSEL_NAME

CC ID: 895994

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	25
Required:	No
Primary Key:	No
Status:	Active
Description:	Vessel name.
General Data Type:	VARCHAR2

CAPTAIN_FIRST_NAME

CC ID: 895995

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	25
Required:	No
Primary Key:	No
Status:	Active
Description:	First name of captain.
General Data Type:	VARCHAR2

CAPTAIN_LAST_NAME

CC ID: 895996

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	25
Required:	No
Primary Key:	No
Status:	Active
Description:	Last name of captain.
General Data Type:	VARCHAR2

TRIP_START_MONTH

CC ID: 895997

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	The month the trip started in.
General Data Type:	VARCHAR2

TRIP_START_DAY

CC ID: 895998

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	The day the trip started on.
General Data Type:	VARCHAR2

TRIP_START_YEAR

CC ID: 895999

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	The year the trip started in.
General Data Type:	VARCHAR2

TRIP_END_MONTH

CC ID: 896000

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	The month the trip ended in.
General Data Type:	VARCHAR2

TRIP_END_DAY

CC ID: 896001

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	The day the trip ended on.
General Data Type:	VARCHAR2

TRIP_END_YEAR

CC ID: 896002

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	The year the trip ended in.
General Data Type:	VARCHAR2

FISHING_LOCATION

CC ID: 896003

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	60
Required:	No
Primary Key:	No
Status:	Active
Description:	Location where fishing occurred, if written in.
General Data Type:	VARCHAR2

TAG_NUMBER_1

CC ID: 896004

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Tag number.
General Data Type:	VARCHAR2

FORK_LENGTH_INCHES

CC ID: 896005

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Fork length in inches. Units for values are inches.
General Data Type:	VARCHAR2
Unit of Measure:	inches

FORK_LENGTH_CENTIMETERS

CC ID: 896006

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Fork length in centimeters. Units for values are centimeters.
General Data Type:	VARCHAR2
Unit of Measure:	centimeters

PURGE

CC ID: 896007

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Was a tool used to treat barotrauma (Y=yes, Blank=no).
General Data Type:	VARCHAR2

DROP_SHOT

CC ID: 896008

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Was a weighted recompression device used to treat baratrauma (Y=yes, Blank=no).
General Data Type:	VARCHAR2

RECAPTURED

CC ID: 896009

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Was the fish a recapture (Y=yes, Blank=no).
General Data Type:	VARCHAR2

RECAPTURED_AND_RELEASED

CC ID: 896010

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	If the fish was a recapture, was it released (Y=yes, Blank=no).
General Data Type:	VARCHAR2

TAG_NUMBER_2

CC ID: 896011

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Additional tag number.
General Data Type:	VARCHAR2

SPECIES

CC ID: 896012

Seq. Order:	22
Data Storage Type:	VARCHAR2
Max Length:	15
Required:	No
Primary Key:	No
Status:	Active
Description:	Species of fish caught.
General Data Type:	VARCHAR2

DATE_CAPTURED_MONTH

CC ID: 896013

Seq. Order:	23
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Month fish was caught.
General Data Type:	VARCHAR2

DATE_CAPTURED_DAY

CC ID: 896014

Seq. Order:	24
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Day fish was caught.
General Data Type:	VARCHAR2

DATE_CAPTURED_YEAR

CC ID: 896015

Seq. Order:	25
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Year fish was caught.
General Data Type:	VARCHAR2

LATITUDE_DEGREES

CC ID: 896016

Seq. Order:	26
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Degrees latitutde where fish was caught. Units for values are degrees.
General Data Type:	VARCHAR2
Unit of Measure:	degrees

LATITUDE_MINUTES

CC ID: 896017

Seq. Order:	27
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Minutes latitutde where fish was caught. Units for values are minutes.
General Data Type:	VARCHAR2
Unit of Measure:	minutes

LATITUDE_DIRECTION

CC ID: 896018

Seq. Order:	28
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Latitude direction (N/S) where fish was caught.
General Data Type:	VARCHAR2

LONGITUDE_DEGREES

CC ID: 896019

Seq. Order:	29
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Degrees longitude where fish was caught. Units for values are degrees.
General Data Type:	VARCHAR2
Unit of Measure:	degrees

LONGITUDE_MINUTES

CC ID: 896020

Seq. Order:	30
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Minutes longitude where fish was caught. Units for values are minutes.
General Data Type:	VARCHAR2
Unit of Measure:	minutes

LONGITUDE_DIRECTION

CC ID: 896021

Seq. Order:	31
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Longitude direction (E/W) where fish was caught.
General Data Type:	VARCHAR2

STATE_CHART_AREA_CODE

CC ID: 896022

Seq. Order:	32
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	State of Hawaii area code, if in Hawaii.
General Data Type:	VARCHAR2

DEPTH_FATHOMS

CC ID: 896023

Seq. Order:	33
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Status:	Active
Description:	Depth in fathoms where fish was caught. Units for values are fathoms.
General Data Type:	VARCHAR2
Unit of Measure:	fathoms

DEPTH_METERS

CC ID: 896024

Seq. Order:	34
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Status:	Active
Description:	Depth in meters where fish was caught. Units for values are meters.
General Data Type:	VARCHAR2
Unit of Measure:	meters

NOTES_LINE_1

CC ID: 896025

Seq. Order:	35
Data Storage Type:	VARCHAR2
Max Length:	80
Required:	No
Primary Key:	No
Status:	Active
Description:	First line of comments from fisher.
General Data Type:	VARCHAR2

NOTES_LINE_2

CC ID: 896026

Seq. Order:	36
Data Storage Type:	VARCHAR2
Max Length:	80
Required:	No
Primary Key:	No
Status:	Active
Description:	Second line of comments from fisher.
General Data Type:	VARCHAR2

NOTES_LINE_3

CC ID: 896027

Seq. Order:	37
Data Storage Type:	VARCHAR2
Max Length:	80
Required:	No
Primary Key:	No
Status:	Active
Description:	Third line of comments from fisher.
General Data Type:	VARCHAR2

JOB_NUMBER

CC ID: 896028

Seq. Order:	38
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D12045.
General Data Type:	VARCHAR2

FROM_FILE

CC ID: 896029

Seq. Order:	39
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Name of the flat ASCII file that was the source of the data.
General Data Type:	VARCHAR2

DATE_LOADED

CC ID: 896030

Seq. Order:	40
Data Storage Type:	DATE
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Date when the record was loaded into Oracle or updated.
General Data Type:	DATE

TAGGER

CC ID: 896031

Seq. Order:	41
Data Storage Type:	VARCHAR2
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Name of individual tagging the fish.
General Data Type:	VARCHAR2

Catalog Item ID:	58731
GUID:	gov.noaa.nmfs.inport:58731
Metadata Record Created By:	Brian J Langseth
Metadata Record Created:	2020-01-30 16:35+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2020-01-30
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2020-01-30
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2021-01-30

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

DATASET_CODE

VERSION_CODE

ISLAND

VESSEL_NAME

CAPTAIN_FIRST_NAME

CAPTAIN_LAST_NAME

TRIP_START_MONTH

TRIP_START_DAY

TRIP_START_YEAR

TRIP_END_MONTH

TRIP_END_DAY

TRIP_END_YEAR

FISHING_LOCATION

TAG_NUMBER_1

FORK_LENGTH_INCHES

FORK_LENGTH_CENTIMETERS

PURGE

DROP_SHOT

RECAPTURED

RECAPTURED_AND_RELEASED

TAG_NUMBER_2

SPECIES

DATE_CAPTURED_MONTH

DATE_CAPTURED_DAY

DATE_CAPTURED_YEAR

LATITUDE_DEGREES

LATITUDE_MINUTES

LATITUDE_DIRECTION

LONGITUDE_DEGREES

LONGITUDE_MINUTES

LONGITUDE_DIRECTION

STATE_CHART_AREA_CODE

DEPTH_FATHOMS

DEPTH_METERS

NOTES_LINE_1

NOTES_LINE_2

NOTES_LINE_3

JOB_NUMBER

FROM_FILE

DATE_LOADED

TAGGER

Catalog Details