Item Identification

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

.

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

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