Item Identification

Title: CRF_SAMPLE_20190321
Short Name: CRF_SAMPLE_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 Concatinated unique ID for collected sample: Year("000"), Month("00"), Day("00"), Sample_Start_time hour("00"), Sample_start_time minute("00"), Captain_CD.
100
SAMPLE_DATE DATE Local Date sample was collected.
100
VESSEL VARCHAR2 Name of vessel from which sample was collected.
100
CAPTAIN VARCHAR2 Name of captain commanding the vessel from which the sample was collected.
100
CAPTAIN_CD VARCHAR2 4 letter code for captain's name.
100
OBSERVER VARCHAR2 Name of observer on board the vessel from which the sample was collected.
100
TARGET_GRID_ID VARCHAR2 Id for primary sampling unit that was targeted for sampling.
100
PSU VARCHAR2 Id for primary sampling unit in which the sample was collected.
100
SAMPLE_MEAN_DEPTH_M NUMBER Mean depth of all drifts within sample. Units for values are meters.
100
WIND_SPEED_KT NUMBER Average wind speed while sample was being collected. Units for values are knots. Measures are reported with a precision of 3.
100
WAVE_HEIGHT_FT NUMBER Average wave height while sample was being collected. Units for values are feet. Measures are reported with a precision of 3.
100
CURRENT_CD VARCHAR2 Was the current good for catching fish.
100
SAMPLE_START_TIME VARCHAR2 Local time sampling began (i.e. start time of first drift).
100
SAMPLE_END_TIME VARCHAR2 Local time sampling concluded (i.e. end time of last drift).
100
SAMPLE_NOTES VARCHAR2 Any notes regarding the sample.
100
ENTERED_BY VARCHAR2 Name of data entry technician.
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: 833601
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: 833602
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 16
Required: No
Primary Key: No
Status: Active
Description:

Concatinated unique ID for collected sample: Year("000"), Month("00"), Day("00"), Sample_Start_time hour("00"), Sample_start_time minute("00"), Captain_CD.

General Data Type: CHARACTER

SAMPLE_DATE

CC ID: 833603
Seq. Order: 3
Data Storage Type: DATE
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Local Date sample was collected.

General Data Type: DATE

VESSEL

CC ID: 833604
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Name of vessel from which sample was collected.

General Data Type: CHARACTER

CAPTAIN

CC ID: 833605
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Name of captain commanding the vessel from which the sample was collected.

General Data Type: CHARACTER

CAPTAIN_CD

CC ID: 833606
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

4 letter code for captain's name.

General Data Type: CHARACTER

OBSERVER

CC ID: 833607
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Name of observer on board the vessel from which the sample was collected.

General Data Type: CHARACTER

TARGET_GRID_ID

CC ID: 833608
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Id for primary sampling unit that was targeted for sampling.

General Data Type: CHARACTER

PSU

CC ID: 833609
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: CHARACTER

SAMPLE_MEAN_DEPTH_M

CC ID: 833610
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Mean depth of all drifts within sample. Units for values are meters.

General Data Type: NUMBER
Unit of Measure: meters

WIND_SPEED_KT

CC ID: 833611
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 4
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Average wind speed while sample was being collected. Units for values are knots. Measures are reported with a precision of 3.

General Data Type: NUMBER
Unit of Measure: knots

WAVE_HEIGHT_FT

CC ID: 833612
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 4
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Average wave height while sample was being collected. Units for values are feet. Measures are reported with a precision of 3.

General Data Type: NUMBER
Unit of Measure: feet

CURRENT_CD

CC ID: 833613
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Was the current good for catching fish.

General Data Type: CHARACTER

SAMPLE_START_TIME

CC ID: 833614
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Local time sampling began (i.e. start time of first drift).

General Data Type: CHARACTER

SAMPLE_END_TIME

CC ID: 833615
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Local time sampling concluded (i.e. end time of last drift).

General Data Type: CHARACTER

SAMPLE_NOTES

CC ID: 833616
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 500
Required: No
Primary Key: No
Status: Active
Description:

Any notes regarding the sample.

General Data Type: CHARACTER

ENTERED_BY

CC ID: 833617
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Name of data entry technician.

General Data Type: CHARACTER

SEQUENCE_NR

CC ID: 868075
Seq. Order: 18
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: 868076
Seq. Order: 19
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: 868077
Seq. Order: 20
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: 868078
Seq. Order: 21
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: 868079
Seq. Order: 22
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: 56039
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:10+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