Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Fisheries Research and Monitoring Divisio... > Stock Assessment Program > Bottomfish Fishery-Independent Survey in Hawaii... > Bottomfish Fishery-Independent Survey in Hawaii... >

CRF_CATCH_20190321

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Description

Entity Type
Data Table

Data Attribute / Type	Description
BFISH VARCHAR2	Id for survey Mission: BFISH_Year_Season (e.g. BFISH_2017_F).
SAMPLE_ID VARCHAR2	Id for primary sampling unit in which the sample was collected.
DRIFT_NR NUMBER	Sequential number for each unique drift within a "PSU".
BAIT_CD VARCHAR2	Code for bait being fished.
SPECIES_CD VARCHAR2	4 letter code for species name.
SCIENTIFIC_NAME VARCHAR2	Linean (Latin) species name.
COMMON_NAME VARCHAR2	Local Hawaiian species name.
LENGTH_CM NUMBER	Fork length of fish to nearest centimeter. Units for values are centimeters. Measures are reported with a precision of 6.
WEIGHT_LB NUMBER	Weight in pounds of the fish. Units for values are pounds.
N NUMBER	Numer of species of this length caught.
RETAINED VARCHAR2	"y" or "N code for if the fish was retained (Y) or released (N).
TAG_NR NUMBER	Id number for PIFSC LHP tag per fish.
SEQUENCE_NR VARCHAR2	Consecutive number added to each record. Starts with 00000001 for each BFISH (Survey Mission).
CREATE_DTM DATE	Date and time this record was added to the database (populated by trigger); field added in August 2019.
CREATED_BY VARCHAR2	Application Express or Oracle username of the person creating this record (populated by trigger); field added in August 2019.
LAST_MOD_DTM DATE	Date and time this record was last modified (populated by trigger); field added in August 2019.
LAST_MOD_BY VARCHAR2	Application Express or Oracle username of the person who last modified this record (populated by trigger); field added in August 2019.

Data Attribute / Type

Description

BFISH
VARCHAR2

Id for survey Mission: BFISH_Year_Season (e.g. BFISH_2017_F).

SAMPLE_ID
VARCHAR2

Id for primary sampling unit in which the sample was collected.

DRIFT_NR
NUMBER

Sequential number for each unique drift within a "PSU".

BAIT_CD
VARCHAR2

Code for bait being fished.

SPECIES_CD
VARCHAR2

4 letter code for species name.

SCIENTIFIC_NAME
VARCHAR2

Linean (Latin) species name.

COMMON_NAME
VARCHAR2

Local Hawaiian species name.

LENGTH_CM
NUMBER

Fork length of fish to nearest centimeter. Units for values are centimeters. Measures are reported with a precision of 6.

WEIGHT_LB
NUMBER

Weight in pounds of the fish. Units for values are pounds.

N
NUMBER

Numer of species of this length caught.

RETAINED
VARCHAR2

"y" or "N code for if the fish was retained (Y) or released (N).

TAG_NR
NUMBER

Id number for PIFSC LHP tag per fish.

SEQUENCE_NR
VARCHAR2

Consecutive number added to each record. Starts with 00000001 for each BFISH (Survey Mission).

CREATE_DTM
DATE

Date and time this record was added to the database (populated by trigger); field added in August 2019.

CREATED_BY
VARCHAR2

Application Express or Oracle username of the person creating this record (populated by trigger); field added in August 2019.

LAST_MOD_DTM
DATE

Date and time this record was last modified (populated by trigger); field added in August 2019.

LAST_MOD_BY
VARCHAR2

Application Express or Oracle username of the person who last modified this record (populated by trigger); field added in August 2019.

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:	CRF_CATCH_20190321
Short Name:	CRF_CATCH_20190321
Status:	On Going
Abstract:	.

Entity Type:	Data Table
Description:	.

Attribute Summary

	Name	Type	Description
100	BFISH	VARCHAR2	Id for survey Mission: BFISH_Year_Season (e.g. BFISH_2017_F).
100	SAMPLE_ID	VARCHAR2	Id for primary sampling unit in which the sample was collected.
100	DRIFT_NR	NUMBER	Sequential number for each unique drift within a "PSU".
100	BAIT_CD	VARCHAR2	Code for bait being fished.
100	SPECIES_CD	VARCHAR2	4 letter code for species name.
100	SCIENTIFIC_NAME	VARCHAR2	Linean (Latin) species name.
100	COMMON_NAME	VARCHAR2	Local Hawaiian species name.
100	LENGTH_CM	NUMBER	Fork length of fish to nearest centimeter. Units for values are centimeters. Measures are reported with a precision of 6.
100	WEIGHT_LB	NUMBER	Weight in pounds of the fish. Units for values are pounds.
100	N	NUMBER	Numer of species of this length caught.
100	RETAINED	VARCHAR2	"y" or "N code for if the fish was retained (Y) or released (N).
100	TAG_NR	NUMBER	Id number for PIFSC LHP tag per fish.
100	SEQUENCE_NR	VARCHAR2	Consecutive number added to each record. Starts with 00000001 for each BFISH (Survey Mission).
100	CREATE_DTM	DATE	Date and time this record was added to the database (populated by trigger); field added in August 2019.
100	CREATED_BY	VARCHAR2	Application Express or Oracle username of the person creating this record (populated by trigger); field added in August 2019.
100	LAST_MOD_DTM	DATE	Date and time this record was last modified (populated by trigger); field added in August 2019.
100	LAST_MOD_BY	VARCHAR2	Application Express or Oracle username of the person who last modified this record (populated by trigger); field added in August 2019.

Name

Type

Description

100

BFISH

VARCHAR2

Id for survey Mission: BFISH_Year_Season (e.g. BFISH_2017_F).

100

SAMPLE_ID

VARCHAR2

Id for primary sampling unit in which the sample was collected.

100

DRIFT_NR

NUMBER

Sequential number for each unique drift within a "PSU".

100

BAIT_CD

VARCHAR2

Code for bait being fished.

100

SPECIES_CD

VARCHAR2

4 letter code for species name.

100

SCIENTIFIC_NAME

VARCHAR2

Linean (Latin) species name.

100

COMMON_NAME

VARCHAR2

Local Hawaiian species name.

100

LENGTH_CM

NUMBER

Fork length of fish to nearest centimeter. Units for values are centimeters. Measures are reported with a precision of 6.

100

WEIGHT_LB

NUMBER

Weight in pounds of the fish. Units for values are pounds.

100

NUMBER

Numer of species of this length caught.

100

RETAINED

VARCHAR2

"y" or "N code for if the fish was retained (Y) or released (N).

100

TAG_NR

NUMBER

Id number for PIFSC LHP tag per fish.

100

SEQUENCE_NR

VARCHAR2

Consecutive number added to each record. Starts with 00000001 for each BFISH (Survey Mission).

100

CREATE_DTM

DATE

Date and time this record was added to the database (populated by trigger); field added in August 2019.

100

CREATED_BY

VARCHAR2

Application Express or Oracle username of the person creating this record (populated by trigger); field added in August 2019.

100

LAST_MOD_DTM

DATE

Date and time this record was last modified (populated by trigger); field added in August 2019.

100

LAST_MOD_BY

VARCHAR2

Application Express or Oracle username of the person who last modified this record (populated by trigger); field added in August 2019.

Attribute Details

BFISH

CC ID: 833647

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	12
Required:	Yes
Primary Key:	Yes
Status:	Active
Description:	Id for survey Mission: BFISH_Year_Season (e.g. BFISH_2017_F).
General Data Type:	CHARACTER

SAMPLE_ID

CC ID: 833648

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	16
Required:	No
Primary Key:	No
Status:	Active
Description:	Id for primary sampling unit in which the sample was collected.
General Data Type:	CHARACTER

DRIFT_NR

CC ID: 833649

Seq. Order:	3
Data Storage Type:	NUMBER
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Sequential number for each unique drift within a "PSU".
General Data Type:	NUMBER

BAIT_CD

CC ID: 833650

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for bait being fished.
General Data Type:	CHARACTER

SPECIES_CD

CC ID: 833651

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	4 letter code for species name.
General Data Type:	CHARACTER

SCIENTIFIC_NAME

CC ID: 833652

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Linean (Latin) species name.
General Data Type:	CHARACTER

COMMON_NAME

CC ID: 833653

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Local Hawaiian species name.
General Data Type:	CHARACTER

LENGTH_CM

CC ID: 833654

Seq. Order:	8
Data Storage Type:	NUMBER
Max Length:	6
Required:	No
Primary Key:	No
Scale:	2
Status:	Active
Description:	Fork length of fish to nearest centimeter. Units for values are centimeters. Measures are reported with a precision of 6.
General Data Type:	NUMBER
Unit of Measure:	centimeters

WEIGHT_LB

CC ID: 833655

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Weight in pounds of the fish. Units for values are pounds.
General Data Type:	NUMBER
Unit of Measure:	pounds

N

CC ID: 833656

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Numer of species of this length caught.
General Data Type:	NUMBER

RETAINED

CC ID: 833657

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	"y" or "N code for if the fish was retained (Y) or released (N).
General Data Type:	CHARACTER

TAG_NR

CC ID: 833658

Seq. Order:	12
Data Storage Type:	NUMBER
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Id number for PIFSC LHP tag per fish.
General Data Type:	NUMBER

SEQUENCE_NR

CC ID: 868065

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	8
Min Length:	8
Required:	Yes
Primary Key:	Yes
Status:	Active
Description:	Consecutive number added to each record. Starts with 00000001 for each BFISH (Survey Mission).
General Data Type:	CHARACTER

CREATE_DTM

CC ID: 868066

Seq. Order:	14
Data Storage Type:	DATE
Required:	No
Primary Key:	No
Status:	Active
Description:	Date and time this record was added to the database (populated by trigger); field added in August 2019.
General Data Type:	CHARACTER

CREATED_BY

CC ID: 868067

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	Application Express or Oracle username of the person creating this record (populated by trigger); field added in August 2019.
General Data Type:	CHARACTER

LAST_MOD_DTM

CC ID: 868068

Seq. Order:	16
Data Storage Type:	DATE
Required:	No
Primary Key:	No
Status:	Active
Description:	Date and time this record was last modified (populated by trigger); field added in August 2019.
General Data Type:	DATE

LAST_MOD_BY

CC ID: 868069

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	Application Express or Oracle username of the person who last modified this record (populated by trigger); field added in August 2019.
General Data Type:	CHARACTER

Catalog Item ID:	56041
GUID:	gov.noaa.nmfs.inport:56041
Metadata Record Created By:	Brent M Miyamoto
Metadata Record Created:	2019-04-12 22:22+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2019-08-21
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2019-08-21
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2020-08-21

CRF_CATCH_20190321

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

BFISH

SAMPLE_ID

DRIFT_NR

BAIT_CD

SPECIES_CD

SCIENTIFIC_NAME

COMMON_NAME

LENGTH_CM

WEIGHT_LB

N

RETAINED

TAG_NR

SEQUENCE_NR

CREATE_DTM

CREATED_BY

LAST_MOD_DTM

LAST_MOD_BY

Catalog Details