Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Fisheries Research and Monitoring Divisio... > Stock Assessment Program > Bottomfish Fishery-Independent Survey in Hawaii... > Bottomfish Fishery-Independent Survey in Hawaii... >

CRF_DRIFT_20190321

Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:56040 | Updated: August 9, 2022 | Published / External

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

	Name	Type	Description
100	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	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.

Name

Type

Description

100

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

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