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_LENGTHS_20190321

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

Item Identification

Title:	CAM_LENGTHS_20190321
Short Name:	CAM_LENGTHS_20190321
Status:	On Going
Abstract:	Data source: 20190321

Entity Information

Entity Type:	Data Table
Description:	.

Data Attributes

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	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	N	NUMBER	Number of individuals measured.
100	REPLICATES	NUMBER	Number of times the individual fish was measured.
100	MIN_MM	NUMBER	Minimum length in millimeters of target within 3 replicate measures. Units for values are millimeters. Measures are reported with a precision of 6.
100	MAX_MM	NUMBER	Maximum length in millimeters of target within 3 replicate measures. Units for values are millimeters. Measures are reported with a precision of 6.
100	MEAN_MM	NUMBER	Mean length in millimeters of target within3 replicate measures. Units for values are millimeters. Measures are reported with a precision of 11.
100	SD_MM	NUMBER	Standard deviation of length in millimeters of target within 3 replicate measures. Units for values are millimeters. Measures are reported with a precision of 11.
100	RANGE_TO_TARGET_MM	NUMBER	Distance (mm) from camera to measured fish at time of measurement. Units for values are millimeters. Measures are reported with a precision of 11.
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

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

NUMBER

Number of individuals measured.

100

REPLICATES

NUMBER

Number of times the individual fish was measured.

100

MIN_MM

NUMBER

Minimum length in millimeters of target within 3 replicate measures. Units for values are millimeters. Measures are reported with a precision of 6.

100

MAX_MM

NUMBER

Maximum length in millimeters of target within 3 replicate measures. Units for values are millimeters. Measures are reported with a precision of 6.

100

MEAN_MM

NUMBER

Mean length in millimeters of target within3 replicate measures. Units for values are millimeters. Measures are reported with a precision of 11.

100

SD_MM

NUMBER

Standard deviation of length in millimeters of target within 3 replicate measures. Units for values are millimeters. Measures are reported with a precision of 11.

100

RANGE_TO_TARGET_MM

NUMBER

Distance (mm) from camera to measured fish at time of measurement. Units for values are millimeters. Measures are reported with a precision of 11.

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

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

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

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

SPECIES_CD

CC ID: 833685

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

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

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

N

CC ID: 833688

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Number of individuals measured.
General Data Type:	NUMBER

REPLICATES

CC ID: 833689

Seq. Order:	8
Data Storage Type:	NUMBER
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Number of times the individual fish was measured.
General Data Type:	NUMBER

MIN_MM

CC ID: 833690

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	7
Required:	No
Primary Key:	No
Scale:	3
Status:	Active
Description:	Minimum length in millimeters of target within 3 replicate measures. Units for values are millimeters. Measures are reported with a precision of 6.
General Data Type:	NUMBER
Unit of Measure:	millimeters

MAX_MM

CC ID: 833691

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	7
Required:	No
Primary Key:	No
Scale:	3
Status:	Active
Description:	Maximum length in millimeters of target within 3 replicate measures. Units for values are millimeters. Measures are reported with a precision of 6.
General Data Type:	NUMBER
Unit of Measure:	millimeters

MEAN_MM

CC ID: 833692

Seq. Order:	11
Data Storage Type:	NUMBER
Max Length:	11
Required:	No
Primary Key:	No
Scale:	8
Status:	Active
Description:	Mean length in millimeters of target within3 replicate measures. Units for values are millimeters. Measures are reported with a precision of 11.
General Data Type:	NUMBER
Unit of Measure:	millimeters

SD_MM

CC ID: 833693

Seq. Order:	12
Data Storage Type:	NUMBER
Max Length:	11
Required:	No
Primary Key:	No
Scale:	9
Status:	Active
Description:	Standard deviation of length in millimeters of target within 3 replicate measures. Units for values are millimeters. Measures are reported with a precision of 11.
General Data Type:	NUMBER
Unit of Measure:	millimeters

RANGE_TO_TARGET_MM

CC ID: 833694

Seq. Order:	13
Data Storage Type:	NUMBER
Max Length:	11
Required:	No
Primary Key:	No
Scale:	7
Status:	Active
Description:	Distance (mm) from camera to measured fish at time of measurement. Units for values are millimeters. Measures are reported with a precision of 11.
General Data Type:	NUMBER
Unit of Measure:	millimeters

SEQUENCE_NR

CC ID: 868050

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

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

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

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

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

Catalog Item ID:	56044
GUID:	gov.noaa.nmfs.inport:56044
Metadata Record Created By:	Brent M Miyamoto
Metadata Record Created:	2019-04-12 22:38+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