Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

.

Description

.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
BFISH
VARCHAR2
Id for survey Mission: BFISH_Year_Season (e.g. BFISH_2017_F).
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.
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").
DRIFT_NR
NUMBER
Sequential number for each unique drift within a "PSU".
DRIFT_MEAN_DEPTH_M
NUMBER
"mean_depth_fa" * 1.8288. Units for values are meters.
DRIFT_START_TIME
VARCHAR2
Local time sampling began on the drift.
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.
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.
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.
START_LAT_DEG
NUMBER
Latitude degrees at the start of the drift. Units for values are degrees.
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.
START_LAT_POS
VARCHAR2
Latitude hemisphere at the start of the drift (N,S).
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.
START_LON_DEG
NUMBER
Longitude degrees at the start of the drift. Units for values are degrees.
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.
START_LON_POS
VARCHAR2
Longitude hemisphere at the start of the drift (E,W).
DRIFT_END_TIME
VARCHAR2
Local time sampling ended on the drift.
DRIFT_DURATION
VARCHAR2
"drift_end_time" - "Drift_Start_Time".
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.
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.
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.
END_LAT_DEG
NUMBER
Latitude degrees at the end of the drift. Units for values are degrees.
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.
END_LAT_POS
VARCHAR2
Latitude hemisphere at end start of the drift (N,S).
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.
END_LON_DEG
NUMBER
Longitude degrees at the end of the drift. Units for values are degrees.
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.
END_LON_POS
VARCHAR2
Longitude hemisphere at the end of the drift (E,W).
BOTTOM_TYPE_CD
VARCHAR2
"H" or "S" to denote hardbottom or softbottom.
SEQUENCE_NR
VARCHAR2
Consecutive number added to each record. Starts with 00000001 for each BFISH (Survey Mission)
CREATE_DTM
DATE
Date and time this record was added to the database (populated by trigger); field added in August 2019.
CREATED_BY
VARCHAR2
Application Express or Oracle username of the person creating this record (populated by trigger); field added in August 2019.
LAST_MOD_DTM
DATE
Date and time this record was last modified (populated by trigger); field added in August 2019.
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.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

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
GUID: gov.noaa.nmfs.inport:56040
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2019-04-12 22:22+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2019-08-21
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2019-08-21
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2020-08-21