Item Identification

Title: CAM_MAXN_20190321
Short Name: CAM_MAXN_20190321
Status: On Going
Abstract:

Data source: 20190321

Entity Information

Entity Type: Data Table
Description:

.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key 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
Primary Key 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 Details

Catalog Item ID: 56043
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2019-04-12 22:37+0000
Metadata Record Last Modified By: Brent M Miyamoto
Metadata Record Last Modified: 2020-01-02 22:14+0000
Metadata Record Published: 2019-08-20
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2020-08-20