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_SAMPLE_20190321

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Description

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.
SAMPLE_DATE DATE	Local Date sample was collected.
VESSEL VARCHAR2	Name of vessel from which sample was collected.
CAPTAIN VARCHAR2	Name of captain commanding the vessel from which the sample was collected.
CAPTAIN_CD VARCHAR2	4 letter code for captain's name.
OBSERVER VARCHAR2	Name of observer on board the vessel from which the sample was collected.
TARGET_GRID_ID VARCHAR2	Id for primary sampling unit that was targeted for sampling.
PSU VARCHAR2	Id for primary sampling unit in which the sample was collected.
SAMPLE_MEAN_DEPTH_M NUMBER	Mean depth of all drifts within sample. Units for values are meters.
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.
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.
CURRENT_CD VARCHAR2	Was the current good for catching fish.
SAMPLE_START_TIME VARCHAR2	Local time sampling began (i.e. start time of first drift).
SAMPLE_END_TIME VARCHAR2	Local time sampling concluded (i.e. end time of last drift).
SAMPLE_NOTES VARCHAR2	Any notes regarding the sample.
ENTERED_BY VARCHAR2	Name of data entry technician.
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.

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.

SAMPLE_DATE
DATE

Local Date sample was collected.

VESSEL
VARCHAR2

Name of vessel from which sample was collected.

CAPTAIN
VARCHAR2

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

CAPTAIN_CD
VARCHAR2

4 letter code for captain's name.

OBSERVER
VARCHAR2

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

TARGET_GRID_ID
VARCHAR2

Id for primary sampling unit that was targeted for sampling.

PSU
VARCHAR2

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

SAMPLE_MEAN_DEPTH_M
NUMBER

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

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.

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.

CURRENT_CD
VARCHAR2

Was the current good for catching fish.

SAMPLE_START_TIME
VARCHAR2

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

SAMPLE_END_TIME
VARCHAR2

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

SAMPLE_NOTES
VARCHAR2

Any notes regarding the sample.

ENTERED_BY
VARCHAR2

Name of data entry technician.

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.

No Child Items for this record.

No contact information is available for this record.

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

Title:	CRF_SAMPLE_20190321
Short Name:	CRF_SAMPLE_20190321
Status:	On Going
Abstract:	.

Entity Type:	Data Table
Description:	.

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

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

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 Item ID:	56039
GUID:	gov.noaa.nmfs.inport:56039
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

CRF_SAMPLE_20190321

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

BFISH

SAMPLE_ID

SAMPLE_DATE

VESSEL

CAPTAIN

CAPTAIN_CD

OBSERVER

TARGET_GRID_ID

PSU

SAMPLE_MEAN_DEPTH_M

WIND_SPEED_KT

WAVE_HEIGHT_FT

CURRENT_CD

SAMPLE_START_TIME

SAMPLE_END_TIME

SAMPLE_NOTES

ENTERED_BY

SEQUENCE_NR

CREATE_DTM

CREATED_BY

LAST_MOD_DTM

LAST_MOD_BY

Catalog Details