Search Help Show/Hide Menu
Summary
Item Identification
Keywords
Physical Location
Entity Info
Data Attributes
Support Roles
Extents
Access Info
Catalog Details

Summary

Abstract

Explanation of what each column could include in the UFA Sampling Data.

Description

UFA Sampling Data.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
UFA_MAIN_ID
NUMBER
The unique sequential number recorded within the database (this number has no significance outside of the database) starting with 1 to uniquely identify each record.
VESSEL
VARCHAR2
The name of the vessel that caught the fish.
NWHI_OR_MHI
CHAR
The region where the bottomfish or pelagic species of fish originated from. This can be determined by the vessel name if its general fishing grounds are known. All bottomfish entries after January 2010 originated from the MHI; the NWHI was closed for bottomfishing.
DATE_MEASURED
DATE
Date that samplers measured the fish on location at the UFA Fish Auction.
SPECIES
VARCHAR2
Species name of the fish sampled, scientific names are used.
DRESSED_YN
CHAR
Whether or not the fish was eviscerated at sea. Most fish sampled are intact except for dolphinfish, wahoo, Smith's Escolar, and Oilfish; but they too are sometimes sold without being gutted. Bottomfish are never eviscerated at sea.
NMFS_WT_KG
NUMBER
Weight taken by NMFS staff using a bench scale. This measurement was no longer taken after June 2009. Weight measurements collected independently of the UFA were time consuming and got in the way of normal auction operations. From June 2010 and on, the UFA weight in pounds was collected.
TL_EFL_FL
CHAR
What type of length was recorded, total length (TL), fork length (FL), or eye to fork length (EFL)
NMFS_LENGTH_TAPE_CM
NUMBER
The length of the fish in centimeters rounded up to the nearest 0.5 cm.
UFA_WT_LBS
NUMBER
The weight given by the UFA and put onto the fish's identifying barcode tag. Weight is measured in pounds to the 0.5 lb.
NMFS_LENGTH_BOARD_CM
NUMBER
The length of the fish obtained using a fish board. Comparison of measuremnts obtained using a fish board versus a fabric measuring tape began in January 2012.
NUM_OF_INDVL
NUMBER
Number of fish grouped into a lot. Could be 1 to 100+
ALL_FISH_MSRD
CHAR
Were all the fish in the lot measured, yes (Y), no (N)? If there was only one fish in the lot and it was measured or both fish in a lot of 2 were measured, the answer would be Y. If 4 out of 6 fish in the lot were measured, the answer would be N.
SEX
CHAR
Sex of the fish, male (M), female (F), unknown (U).
EYE_SIZE
CHAR
This column pertains only to Lampris species, if it is a smalleye opah, SE will be recorded, bigeye-BE, and if it is unknown what species it is, then U.
SPECIMEN_NOTES
VARCHAR2
Any additional information associated with this fish.
LESS_THAN_1_LB
CHAR
Did the fish measured weigh less than 1 pound, yes (Y) or no (N)? UFA staff record a less than sign on the barcode tag of fish weighing less than one pound.
GONAD_YN
CHAR
Were the gonads from this fish extracted, yes (Y) or no (N)? Collection of gonads from the UFA fish auction specimens began in the summer of 2012; all entries prior to May 2012 will have an N in this row.
UFA_FISH_ID
NUMBER
The number assigned to each fish by the UFA. There will be a value here if the toughbook scanning system was used for data collection.
USERNAME
VARCHAR2
The name of the person operating the toughbook scanning system or person sampling on that specific date.

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.

Extents

Time Frame 1
2007-10-01 - Present

Item Identification

Title: Column Notes for UFA Sampling Data
Status: In Work
Abstract:

Explanation of what each column could include in the UFA Sampling Data.

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None bottomfish
None fish auction
None Length
None species
None UFA
None Weight

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None Big Island
None Kauai
None Maui
None Molokai
None NWHI
None Oahu

Physical Location

Organization: Pacific Islands Fisheries Science Center
City: Honolulu
State/Province: HI
Country: USA
Location Description:

IRC

Entity Information

Entity Type: Data Table
Description:

UFA Sampling Data.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key UFA_MAIN_ID NUMBER The unique sequential number recorded within the database (this number has no significance outside of the database) starting with 1 to uniquely identify each record.
100
VESSEL VARCHAR2 The name of the vessel that caught the fish.
100
NWHI_OR_MHI CHAR The region where the bottomfish or pelagic species of fish originated from. This can be determined by the vessel name if its general fishing grounds are known. All bottomfish entries after January 2010 originated from the MHI; the NWHI was closed for bottomfishing.
100
DATE_MEASURED DATE Date that samplers measured the fish on location at the UFA Fish Auction.
100
SPECIES VARCHAR2 Species name of the fish sampled, scientific names are used.
100
DRESSED_YN CHAR Whether or not the fish was eviscerated at sea. Most fish sampled are intact except for dolphinfish, wahoo, Smith's Escolar, and Oilfish; but they too are sometimes sold without being gutted. Bottomfish are never eviscerated at sea.
100
NMFS_WT_KG NUMBER Weight taken by NMFS staff using a bench scale. This measurement was no longer taken after June 2009. Weight measurements collected independently of the UFA were time consuming and got in the way of normal auction operations. From June 2010 and on, the UFA weight in pounds was collected.
100
TL_EFL_FL CHAR What type of length was recorded, total length (TL), fork length (FL), or eye to fork length (EFL)
100
NMFS_LENGTH_TAPE_CM NUMBER The length of the fish in centimeters rounded up to the nearest 0.5 cm.
100
UFA_WT_LBS NUMBER The weight given by the UFA and put onto the fish's identifying barcode tag. Weight is measured in pounds to the 0.5 lb.
100
NMFS_LENGTH_BOARD_CM NUMBER The length of the fish obtained using a fish board. Comparison of measuremnts obtained using a fish board versus a fabric measuring tape began in January 2012.
100
NUM_OF_INDVL NUMBER Number of fish grouped into a lot. Could be 1 to 100+
100
ALL_FISH_MSRD CHAR Were all the fish in the lot measured, yes (Y), no (N)? If there was only one fish in the lot and it was measured or both fish in a lot of 2 were measured, the answer would be Y. If 4 out of 6 fish in the lot were measured, the answer would be N.
100
SEX CHAR Sex of the fish, male (M), female (F), unknown (U).
100
EYE_SIZE CHAR This column pertains only to Lampris species, if it is a smalleye opah, SE will be recorded, bigeye-BE, and if it is unknown what species it is, then U.
100
SPECIMEN_NOTES VARCHAR2 Any additional information associated with this fish.
100
LESS_THAN_1_LB CHAR Did the fish measured weigh less than 1 pound, yes (Y) or no (N)? UFA staff record a less than sign on the barcode tag of fish weighing less than one pound.
100
GONAD_YN CHAR Were the gonads from this fish extracted, yes (Y) or no (N)? Collection of gonads from the UFA fish auction specimens began in the summer of 2012; all entries prior to May 2012 will have an N in this row.
100
UFA_FISH_ID NUMBER The number assigned to each fish by the UFA. There will be a value here if the toughbook scanning system was used for data collection.
100
USERNAME VARCHAR2 The name of the person operating the toughbook scanning system or person sampling on that specific date.

Attribute Details

UFA_MAIN_ID

CC ID: 43203
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 6
Required: Yes
Primary Key: Yes
Status: Active
Description:

The unique sequential number recorded within the database (this number has no significance outside of the database) starting with 1 to uniquely identify each record.

Null Value: NO

VESSEL

CC ID: 43204
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
Description:

The name of the vessel that caught the fish.

Null Value: NO

NWHI_OR_MHI

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

The region where the bottomfish or pelagic species of fish originated from. This can be determined by the vessel name if its general fishing grounds are known. All bottomfish entries after January 2010 originated from the MHI; the NWHI was closed for bottomfishing.

Null Value: YES
Null Value Meaning:

The fish was caught on a pelagic fishing vessel and the location of capture was not known.

Allowed Values: NWHI, MHI
Default Value: MHI

DATE_MEASURED

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

Date that samplers measured the fish on location at the UFA Fish Auction.

Null Value: NO
Null Value Meaning:

There should always be a date recorded.

SPECIES

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

Species name of the fish sampled, scientific names are used.

Null Value: NO

DRESSED_YN

CC ID: 43208
Seq. Order: 6
Data Storage Type: CHAR
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Whether or not the fish was eviscerated at sea. Most fish sampled are intact except for dolphinfish, wahoo, Smith's Escolar, and Oilfish; but they too are sometimes sold without being gutted. Bottomfish are never eviscerated at sea.

Null Value: NO
Allowed Values: Y, N
Default Value: N

NMFS_WT_KG

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

Weight taken by NMFS staff using a bench scale. This measurement was no longer taken after June 2009. Weight measurements collected independently of the UFA were time consuming and got in the way of normal auction operations. From June 2010 and on, the UFA weight in pounds was collected.

Null Value: YES
Null Value Meaning:

The weight was not taken by NMFS staff. After June 2009, all rows in this field will be null.

TL_EFL_FL

CC ID: 43210
Seq. Order: 8
Data Storage Type: CHAR
Max Length: 3
Required: Yes
Primary Key: No
Status: Active
Description:

What type of length was recorded, total length (TL), fork length (FL), or eye to fork length (EFL)

Null Value: NO
Null Value Meaning:

It can always be determined what type of length was/would have been recorded based on the species.

Allowed Values: TL, EFL, FL
Default Value: FL

NMFS_LENGTH_TAPE_CM

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

The length of the fish in centimeters rounded up to the nearest 0.5 cm.

Null Value: YES
Null Value Meaning:

The length was not taken.

UFA_WT_LBS

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

The weight given by the UFA and put onto the fish's identifying barcode tag. Weight is measured in pounds to the 0.5 lb.

Null Value: YES
Null Value Meaning:

The fish is grouped into a lot so the individual weight is unknown.

NMFS_LENGTH_BOARD_CM

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

The length of the fish obtained using a fish board. Comparison of measuremnts obtained using a fish board versus a fabric measuring tape began in January 2012.

Null Value: YES
Null Value Meaning:

Information was collected prior to 2012 when the fish board was not in use or fish board was too small to capture measurement of large-sized bottomfish specimens.

NUM_OF_INDVL

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

Number of fish grouped into a lot. Could be 1 to 100+

Null Value: NO
Null Value Meaning:

Each fish is part of a lot. If more than one fish is in a lot, the total number of fish in that lot will be indicated here. All fish in the lot are not always measured.

ALL_FISH_MSRD

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

Were all the fish in the lot measured, yes (Y), no (N)? If there was only one fish in the lot and it was measured or both fish in a lot of 2 were measured, the answer would be Y. If 4 out of 6 fish in the lot were measured, the answer would be N.

Null Value: NO
Null Value Meaning:

All fish in the lot either were or were not measured.

SEX

CC ID: 43214
Seq. Order: 14
Data Storage Type: CHAR
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Sex of the fish, male (M), female (F), unknown (U).

Null Value: NO
Null Value Meaning:

If the sex is unknown, which will be the case for most species, a U should be entered into the cell.

Allowed Values: M, F, U
Default Value: U

EYE_SIZE

CC ID: 43215
Seq. Order: 15
Data Storage Type: CHAR
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

This column pertains only to Lampris species, if it is a smalleye opah, SE will be recorded, bigeye-BE, and if it is unknown what species it is, then U.

Null Value: YES
Null Value Meaning:

Will be blank for all species except Lampris spp.

Allowed Values: BE, SE, U

SPECIMEN_NOTES

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

Any additional information associated with this fish.

Null Value: YES
Null Value Meaning:

No additional information is available.

LESS_THAN_1_LB

CC ID: 67921
Seq. Order: 17
Data Storage Type: CHAR
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Did the fish measured weigh less than 1 pound, yes (Y) or no (N)? UFA staff record a less than sign on the barcode tag of fish weighing less than one pound.

Null Value: NO
Null Value Meaning:

The fish either did or did not weigh less than one pound.

Allowed Values: Y, N

GONAD_YN

CC ID: 67922
Seq. Order: 18
Data Storage Type: CHAR
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Were the gonads from this fish extracted, yes (Y) or no (N)? Collection of gonads from the UFA fish auction specimens began in the summer of 2012; all entries prior to May 2012 will have an N in this row.

Null Value: NO
Null Value Meaning:

Gonads either were or were not collected.

Allowed Values: Y, N

UFA_FISH_ID

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

The number assigned to each fish by the UFA. There will be a value here if the toughbook scanning system was used for data collection.

Null Value: YES
Null Value Meaning:

The toughbook was not in operation until November 2010, any entry prior will not have a value for this column. This column will be blank whenever the scanning system was not used.

USERNAME

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

The name of the person operating the toughbook scanning system or person sampling on that specific date.

Null Value: YES
Null Value Meaning:

The username was not recorded.

Support Roles

This Catalog Item has no Support Roles that are currently in effect.
View Historical Support Roles

Extents

Extent Group 1

Extent Group 1 / Time Frame 1

CC ID: 45108
Time Frame Type: Continuing
Start: 2007-10-01

Access Information

Security Class: Restricted
Security Classification System:

May contain confidential fisheries data.

Data Access Constraints:

Some information contained within may contain confidential information, contact for details.

Catalog Details

Catalog Item ID: 11001
GUID: gov.noaa.nmfs.inport:11001
Metadata Record Created By: Meagan A Sundberg
Metadata Record Created: 2011-04-29 16:21+0000
Metadata Record Last Modified By: Michael Chang
Metadata Record Last Modified: 2025-02-13 22:57+0000
Metadata Record Published: 2025-02-13
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year