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... >

CAM_MAXN_20190321

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Data source: 20190321

Description

Entity Type
Data Table

Data Attribute / Type	Description
BFISH VARCHAR2	Id for survey Mission: BFISH_Year_Season (e.g. BFISH_2017_F).
MISSION_ID VARCHAR2	Id for NOAA ship mission (e.g. SE1707).
DROP_CD VARCHAR2	Unique ID for the collected sample.
VIDEO_FRAME NUMBER	Sequential image frame number from which data record was derived.
TIME_FROM_TOUCHDOWN_MIN NUMBER	Cummulative number of mintues from time of camera contact with seafloor to "video_frame".
SPECIES_CD VARCHAR2	4 letter code for species name.
SCIENTIFIC_NAME VARCHAR2	Linean (Latin) species name.
COMMON_NAME CHARACTER	Local Hawaiian species name.
MAXN NUMBER	Maximum number of individuals of "scientific_name" observed during "drop_code".
DATA_TYPE VARCHAR2	Anazlysis classification method.
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).

MISSION_ID
VARCHAR2

Id for NOAA ship mission (e.g. SE1707).

DROP_CD
VARCHAR2

Unique ID for the collected sample.

VIDEO_FRAME
NUMBER

Sequential image frame number from which data record was derived.

TIME_FROM_TOUCHDOWN_MIN
NUMBER

Cummulative number of mintues from time of camera contact with seafloor to "video_frame".

SPECIES_CD
VARCHAR2

4 letter code for species name.

SCIENTIFIC_NAME
VARCHAR2

Linean (Latin) species name.

COMMON_NAME
CHARACTER

Local Hawaiian species name.

MAXN
NUMBER

Maximum number of individuals of "scientific_name" observed during "drop_code".

DATA_TYPE
VARCHAR2

Anazlysis classification method.

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:	CAM_MAXN_20190321
Short Name:	CAM_MAXN_20190321
Status:	On Going
Abstract:	Data source: 20190321

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	MISSION_ID	VARCHAR2	Id for NOAA ship mission (e.g. SE1707).
100	DROP_CD	VARCHAR2	Unique ID for the collected sample.
100	VIDEO_FRAME	NUMBER	Sequential image frame number from which data record was derived.
100	TIME_FROM_TOUCHDOWN_MIN	NUMBER	Cummulative number of mintues from time of camera contact with seafloor to "video_frame".
100	SPECIES_CD	VARCHAR2	4 letter code for species name.
100	SCIENTIFIC_NAME	VARCHAR2	Linean (Latin) species name.
100	COMMON_NAME	CHARACTER	Local Hawaiian species name.
100	MAXN	NUMBER	Maximum number of individuals of "scientific_name" observed during "drop_code".
100	DATA_TYPE	VARCHAR2	Anazlysis classification method.
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

MISSION_ID

VARCHAR2

Id for NOAA ship mission (e.g. SE1707).

100

DROP_CD

VARCHAR2

Unique ID for the collected sample.

100

VIDEO_FRAME

NUMBER

Sequential image frame number from which data record was derived.

100

TIME_FROM_TOUCHDOWN_MIN

NUMBER

Cummulative number of mintues from time of camera contact with seafloor to "video_frame".

100

SPECIES_CD

VARCHAR2

4 letter code for species name.

100

SCIENTIFIC_NAME

VARCHAR2

Linean (Latin) species name.

100

COMMON_NAME

CHARACTER

Local Hawaiian species name.

100

MAXN

NUMBER

Maximum number of individuals of "scientific_name" observed during "drop_code".

100

DATA_TYPE

VARCHAR2

Anazlysis classification method.

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: 833672

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

MISSION_ID

CC ID: 833673

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Id for NOAA ship mission (e.g. SE1707).
General Data Type:	CHARACTER

DROP_CD

CC ID: 833674

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	15
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique ID for the collected sample.
General Data Type:	CHARACTER

VIDEO_FRAME

CC ID: 833675

Seq. Order:	4
Data Storage Type:	NUMBER
Max Length:	5
Required:	No
Primary Key:	No
Status:	Active
Description:	Sequential image frame number from which data record was derived.
General Data Type:	NUMBER

TIME_FROM_TOUCHDOWN_MIN

CC ID: 833676

Seq. Order:	5
Data Storage Type:	NUMBER
Max Length:	7
Required:	No
Primary Key:	No
Scale:	6
Status:	Active
Description:	Cummulative number of mintues from time of camera contact with seafloor to "video_frame".
General Data Type:	NUMBER
Derivation:	4

SPECIES_CD

CC ID: 833677

Seq. Order:	6
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: 833678

Seq. Order:	7
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: 833679

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

MAXN

CC ID: 833680

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Maximum number of individuals of "scientific_name" observed during "drop_code".
General Data Type:	NUMBER

DATA_TYPE

CC ID: 833681

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Anazlysis classification method.
General Data Type:	CHARACTER

SEQUENCE_NR

CC ID: 868055

Seq. Order:	11
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: 868056

Seq. Order:	12
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:	DATE

CREATED_BY

CC ID: 868057

Seq. Order:	13
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: 868058

Seq. Order:	14
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: 868059

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 who last modified this record (populated by trigger); field added in August 2019.
General Data Type:	CHARACTER

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

CAM_MAXN_20190321

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

BFISH

MISSION_ID

DROP_CD

VIDEO_FRAME

TIME_FROM_TOUCHDOWN_MIN

SPECIES_CD

SCIENTIFIC_NAME

COMMON_NAME

MAXN

DATA_TYPE

SEQUENCE_NR

CREATE_DTM

CREATED_BY

LAST_MOD_DTM

LAST_MOD_BY

Catalog Details