Item Identification

Title: CRF_DRIFT_20190321
Short Name: CRF_DRIFT_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
DRIFT_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, Drift_NR("00").
100
DRIFT_NR NUMBER Sequential number for each unique drift within a "PSU".
100
DRIFT_MEAN_DEPTH_M NUMBER "mean_depth_fa" * 1.8288. Units for values are meters.
100
DRIFT_START_TIME VARCHAR2 Local time sampling began on the drift.
100
START_DEPTH_FA NUMBER Depth in fathoms at the start of the drift. Units for values are fathoms. Measures are reported with a precision of 4.
100
START_DEPTH_M NUMBER Depth in meters at the start of the drift. Units for values are meters. Measures are reported with a precision of 8.
100
START_LAT NUMBER Latitiude in decimal degrees at the start of the drift. Units for values are degrees. Measures are reported with a precision of 10.
100
START_LAT_DEG NUMBER Latitude degrees at the start of the drift. Units for values are degrees.
100
START_LAT_MIN NUMBER Latitude minutes at the start of the drift. Units for values are minutes. Measures are reported with a precision of 6.
100
START_LAT_POS VARCHAR2 Latitude hemisphere at the start of the drift (N,S).
100
START_LON NUMBER Longitude in decimal degrees at the start of the drift. Units for values are degrees. Measures are reported with a precision of 10.
100
START_LON_DEG NUMBER Longitude degrees at the start of the drift. Units for values are degrees.
100
START_LON_MIN NUMBER Longitude minutes at the start of the drift. Units for values are minutes. Measures are reported with a precision of 5.
100
START_LON_POS VARCHAR2 Longitude hemisphere at the start of the drift (E,W).
100
DRIFT_END_TIME VARCHAR2 Local time sampling ended on the drift.
100
DRIFT_DURATION VARCHAR2 "drift_end_time" - "Drift_Start_Time".
100
END_DEPTH_FA NUMBER Depth in fathoms at the end of the drift. Units for values are fathoms. Measures are reported with a precision of 4.
100
END_DEPTH_M NUMBER Depth in meters at the end of the drift. Units for values are meters. Measures are reported with a precision of 8.
100
END_LAT NUMBER Latitude in decimal degrees at the end of the drift. Units for values are degrees. Measures are reported with a precision of 10.
100
END_LAT_DEG NUMBER Latitude degrees at the end of the drift. Units for values are degrees.
100
END_LAT_MIN NUMBER Latitude minutes at the end of the drift. Units for values are minutes. Measures are reported with a precision of 6.
100
END_LAT_POS VARCHAR2 Latitude hemisphere at end start of the drift (N,S).
100
END_LON NUMBER Longitude in decimal degrees at the end of the drift. Units for values are degrees. Measures are reported with a precision of 10.
100
END_LON_DEG NUMBER Longitude degrees at the end of the drift. Units for values are degrees.
100
END_LON_MIN NUMBER Longitude minutes at the end of the drift. Units for values are minutes. Measures are reported with a precision of 5.
100
END_LON_POS VARCHAR2 Longitude hemisphere at the end of the drift (E,W).
100
BOTTOM_TYPE_CD VARCHAR2 "H" or "S" to denote hardbottom or softbottom.
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: 833618
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: 833619
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

DRIFT_ID

CC ID: 833620
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 18
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, Drift_NR("00").

General Data Type: CHARACTER

DRIFT_NR

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

Sequential number for each unique drift within a "PSU".

General Data Type: NUMBER

DRIFT_MEAN_DEPTH_M

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

"mean_depth_fa" * 1.8288. Units for values are meters.

General Data Type: NUMBER
Unit of Measure: meters

DRIFT_START_TIME

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

Local time sampling began on the drift.

General Data Type: CHARACTER

START_DEPTH_FA

CC ID: 833624
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 5
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Depth in fathoms at the start of the drift. Units for values are fathoms. Measures are reported with a precision of 4.

General Data Type: NUMBER
Unit of Measure: fathoms

START_DEPTH_M

CC ID: 833625
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 9
Required: No
Primary Key: No
Scale: 5
Status: Active
Description:

Depth in meters at the start of the drift. Units for values are meters. Measures are reported with a precision of 8.

General Data Type: NUMBER
Unit of Measure: meters

START_LAT

CC ID: 833626
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 11
Required: No
Primary Key: No
Scale: 8
Status: Active
Description:

Latitiude in decimal degrees at the start of the drift. Units for values are degrees. Measures are reported with a precision of 10.

General Data Type: NUMBER
Unit of Measure: degrees

START_LAT_DEG

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

Latitude degrees at the start of the drift. Units for values are degrees.

General Data Type: NUMBER
Unit of Measure: degrees

START_LAT_MIN

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

Latitude minutes at the start of the drift. Units for values are minutes. Measures are reported with a precision of 6.

General Data Type: NUMBER
Unit of Measure: minutes

START_LAT_POS

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

Latitude hemisphere at the start of the drift (N,S).

General Data Type: CHARACTER

START_LON

CC ID: 833630
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 12
Required: No
Primary Key: No
Scale: 7
Status: Active
Description:

Longitude in decimal degrees at the start of the drift. Units for values are degrees. Measures are reported with a precision of 10.

General Data Type: NUMBER
Unit of Measure: degrees

START_LON_DEG

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

Longitude degrees at the start of the drift. Units for values are degrees.

General Data Type: NUMBER
Unit of Measure: degrees

START_LON_MIN

CC ID: 833632
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 6
Required: No
Primary Key: No
Scale: 3
Status: Active
Description:

Longitude minutes at the start of the drift. Units for values are minutes. Measures are reported with a precision of 5.

General Data Type: NUMBER
Unit of Measure: minutes

START_LON_POS

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

Longitude hemisphere at the start of the drift (E,W).

General Data Type: CHARACTER

DRIFT_END_TIME

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

Local time sampling ended on the drift.

General Data Type: CHARACTER

DRIFT_DURATION

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

"drift_end_time" - "Drift_Start_Time".

General Data Type: CHARACTER

END_DEPTH_FA

CC ID: 833636
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 5
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Depth in fathoms at the end of the drift. Units for values are fathoms. Measures are reported with a precision of 4.

General Data Type: NUMBER
Unit of Measure: fathoms

END_DEPTH_M

CC ID: 833637
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 9
Required: No
Primary Key: No
Scale: 5
Status: Active
Description:

Depth in meters at the end of the drift. Units for values are meters. Measures are reported with a precision of 8.

General Data Type: NUMBER
Unit of Measure: meters

END_LAT

CC ID: 833638
Seq. Order: 21
Data Storage Type: NUMBER
Max Length: 11
Required: No
Primary Key: No
Scale: 8
Status: Active
Description:

Latitude in decimal degrees at the end of the drift. Units for values are degrees. Measures are reported with a precision of 10.

General Data Type: NUMBER
Unit of Measure: degrees

END_LAT_DEG

CC ID: 833639
Seq. Order: 22
Data Storage Type: NUMBER
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Latitude degrees at the end of the drift. Units for values are degrees.

General Data Type: NUMBER
Unit of Measure: degrees

END_LAT_MIN

CC ID: 833640
Seq. Order: 23
Data Storage Type: NUMBER
Max Length: 7
Required: No
Primary Key: No
Scale: 4
Status: Active
Description:

Latitude minutes at the end of the drift. Units for values are minutes. Measures are reported with a precision of 6.

General Data Type: NUMBER
Unit of Measure: minutes

END_LAT_POS

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

Latitude hemisphere at end start of the drift (N,S).

General Data Type: CHARACTER

END_LON

CC ID: 833642
Seq. Order: 25
Data Storage Type: NUMBER
Max Length: 12
Required: No
Primary Key: No
Scale: 7
Status: Active
Description:

Longitude in decimal degrees at the end of the drift. Units for values are degrees. Measures are reported with a precision of 10.

General Data Type: NUMBER
Unit of Measure: degrees

END_LON_DEG

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

Longitude degrees at the end of the drift. Units for values are degrees.

General Data Type: NUMBER
Unit of Measure: degrees

END_LON_MIN

CC ID: 833644
Seq. Order: 27
Data Storage Type: NUMBER
Max Length: 6
Required: No
Primary Key: No
Scale: 3
Status: Active
Description:

Longitude minutes at the end of the drift. Units for values are minutes. Measures are reported with a precision of 5.

General Data Type: NUMBER
Unit of Measure: minutes

END_LON_POS

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

Longitude hemisphere at the end of the drift (E,W).

General Data Type: CHARACTER

BOTTOM_TYPE_CD

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

"H" or "S" to denote hardbottom or softbottom.

General Data Type: CHARACTER

SEQUENCE_NR

CC ID: 868070
Seq. Order: 30
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: 868071
Seq. Order: 31
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: 868072
Seq. Order: 32
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: 868073
Seq. Order: 33
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: 868074
Seq. Order: 34
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: 56040
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:09+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