Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Fisheries Research and Monitoring Divisio... > Fisheries Monitoring > Hawaii Fish Dealer > UFA Auction Sampling Data >

UFA Auction Sampling Data

Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:11044 | Updated: February 20, 2025 | Published / External

Summary

Item Identification

Keywords

Physical Location

Entity Info

Data Attributes

Support Roles

Access Info

Issues

Catalog Details

Description

UFA Auction Sampling Data.

Entity Type
Data Table

Data Attribute / Type	Description
YEAR VARCHAR2	Year of sample
MONTH VARCHAR2	Month of sample; left justified, one-digit months may or may not be padded with leading zero
DAY VARCHAR2	Day of sample; left justified, one-digit days may or may not be padded with leading zero
BOAT VARCHAR2	Code for boat or fisher; left justified, one-digit code may or may not be padded with leading zero
AREA VARCHAR2	Code for area fished; left justified, one-digit code may or may not be padded with leading zero
SPECIES VARCHAR2	Code for species; left justified, one-digit code may or may not be padded with leading zero
NUM NUMERIC	Number of pieces
POUNDS NUMERIC	Adjusted whole weight of fish
PRICE NUMERIC	Price per (sold) pounds
BUYER VARCHAR2	Code for buyer; code is padded with leading zeros or left justified
CONDITION VARCHAR2	Code for condition or state of fish; code is padded with leading zero or left justified
TRIPTYPE VARCHAR2	Code for trip type; code is padded with leading zero or left justified
TRIPNUM VARCHAR2	For longline trips, this field is comprised of the trip_type_code and trip_number from the longline logbook data
CONV NUMERIC	Conversion factor to convert auction weight to whole weight of fish
FROM_FILE VARCHAR2	Source file of the data
POSTED DATE	Date the data was loaded or updated, or date of the source file.

Data Attribute / Type

Description

YEAR
VARCHAR2

Year of sample

MONTH
VARCHAR2

Month of sample; left justified, one-digit months may or may not be padded with leading zero

DAY
VARCHAR2

Day of sample; left justified, one-digit days may or may not be padded with leading zero

BOAT
VARCHAR2

Code for boat or fisher; left justified, one-digit code may or may not be padded with leading zero

AREA
VARCHAR2

Code for area fished; left justified, one-digit code may or may not be padded with leading zero

SPECIES
VARCHAR2

Code for species; left justified, one-digit code may or may not be padded with leading zero

NUM
NUMERIC

Number of pieces

POUNDS
NUMERIC

Adjusted whole weight of fish

PRICE
NUMERIC

Price per (sold) pounds

BUYER
VARCHAR2

Code for buyer; code is padded with leading zeros or left justified

CONDITION
VARCHAR2

Code for condition or state of fish; code is padded with leading zero or left justified

TRIPTYPE
VARCHAR2

Code for trip type; code is padded with leading zero or left justified

TRIPNUM
VARCHAR2

For longline trips, this field is comprised of the trip_type_code and trip_number from the longline logbook data

CONV
NUMERIC

Conversion factor to convert auction weight to whole weight of fish

FROM_FILE
VARCHAR2

Source file of the data

POSTED
DATE

Date the data was loaded or updated, or date of the source file.

No Child Items for this record.

Title:	UFA Auction Sampling Data
Short Name:	UFA
Status:	In Work

Theme Keywords

Thesaurus	Keyword
UNCONTROLLED
None	FMB
None	FRMD

Thesaurus

Keyword

UNCONTROLLED

None

FMB

None

FRMD

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

Entity Type:	Data Table
Active Version?:	Yes
Alias:	UFA
Schema Name:	UFA
Description:	UFA Auction Sampling Data.

Attribute Summary

	Name	Type	Description
100	YEAR	VARCHAR2	Year of sample
100	MONTH	VARCHAR2	Month of sample; left justified, one-digit months may or may not be padded with leading zero
100	DAY	VARCHAR2	Day of sample; left justified, one-digit days may or may not be padded with leading zero
100	BOAT	VARCHAR2	Code for boat or fisher; left justified, one-digit code may or may not be padded with leading zero
100	AREA	VARCHAR2	Code for area fished; left justified, one-digit code may or may not be padded with leading zero
100	SPECIES	VARCHAR2	Code for species; left justified, one-digit code may or may not be padded with leading zero
100	NUM	NUMERIC	Number of pieces
100	POUNDS	NUMERIC	Adjusted whole weight of fish
100	PRICE	NUMERIC	Price per (sold) pounds
100	BUYER	VARCHAR2	Code for buyer; code is padded with leading zeros or left justified
100	CONDITION	VARCHAR2	Code for condition or state of fish; code is padded with leading zero or left justified
100	TRIPTYPE	VARCHAR2	Code for trip type; code is padded with leading zero or left justified
100	TRIPNUM	VARCHAR2	For longline trips, this field is comprised of the trip_type_code and trip_number from the longline logbook data
100	CONV	NUMERIC	Conversion factor to convert auction weight to whole weight of fish
100	FROM_FILE	VARCHAR2	Source file of the data
100	POSTED	DATE	Date the data was loaded or updated, or date of the source file.

Name

Type

Description

100

YEAR

VARCHAR2

Year of sample

100

MONTH

VARCHAR2

Month of sample; left justified, one-digit months may or may not be padded with leading zero

100

DAY

VARCHAR2

Day of sample; left justified, one-digit days may or may not be padded with leading zero

100

BOAT

VARCHAR2

Code for boat or fisher; left justified, one-digit code may or may not be padded with leading zero

100

AREA

VARCHAR2

Code for area fished; left justified, one-digit code may or may not be padded with leading zero

100

SPECIES

VARCHAR2

Code for species; left justified, one-digit code may or may not be padded with leading zero

100

NUM

NUMERIC

Number of pieces

100

POUNDS

NUMERIC

Adjusted whole weight of fish

100

PRICE

NUMERIC

Price per (sold) pounds

100

BUYER

VARCHAR2

Code for buyer; code is padded with leading zeros or left justified

100

CONDITION

VARCHAR2

Code for condition or state of fish; code is padded with leading zero or left justified

100

TRIPTYPE

VARCHAR2

Code for trip type; code is padded with leading zero or left justified

100

TRIPNUM

VARCHAR2

For longline trips, this field is comprised of the trip_type_code and trip_number from the longline logbook data

100

CONV

NUMERIC

Conversion factor to convert auction weight to whole weight of fish

100

FROM_FILE

VARCHAR2

Source file of the data

100

POSTED

DATE

Date the data was loaded or updated, or date of the source file.

Attribute Details

YEAR

CC ID: 43344

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Year of sample

MONTH

CC ID: 43345

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Month of sample; left justified, one-digit months may or may not be padded with leading zero

DAY

CC ID: 43346

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Day of sample; left justified, one-digit days may or may not be padded with leading zero

BOAT

CC ID: 43349

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for boat or fisher; left justified, one-digit code may or may not be padded with leading zero

AREA

CC ID: 43350

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for area fished; left justified, one-digit code may or may not be padded with leading zero

SPECIES

CC ID: 43351

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for species; left justified, one-digit code may or may not be padded with leading zero

NUM

CC ID: 43352

Seq. Order:	7
Data Storage Type:	NUMERIC
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Number of pieces

POUNDS

CC ID: 43353

Seq. Order:	8
Data Storage Type:	NUMERIC
Max Length:	7
Required:	No
Primary Key:	No
Scale:	2
Status:	Active
Description:	Adjusted whole weight of fish

PRICE

CC ID: 43356

Seq. Order:	9
Data Storage Type:	NUMERIC
Max Length:	6
Required:	No
Primary Key:	No
Scale:	2
Status:	Active
Description:	Price per (sold) pounds

BUYER

CC ID: 43360

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for buyer; code is padded with leading zeros or left justified

CONDITION

CC ID: 43361

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for condition or state of fish; code is padded with leading zero or left justified

TRIPTYPE

CC ID: 43362

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for trip type; code is padded with leading zero or left justified

TRIPNUM

CC ID: 43364

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Status:	Active
Description:	For longline trips, this field is comprised of the trip_type_code and trip_number from the longline logbook data

CONV

CC ID: 43367

Seq. Order:	14
Data Storage Type:	NUMERIC
Max Length:	4
Required:	No
Primary Key:	No
Scale:	2
Status:	Active
Description:	Conversion factor to convert auction weight to whole weight of fish

FROM_FILE

CC ID: 43369

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	12
Required:	No
Primary Key:	No
Status:	Active
Description:	Source file of the data

POSTED

CC ID: 43371

Seq. Order:	16
Data Storage Type:	DATE
Max Length:	21
Required:	No
Primary Key:	No
Status:	Active
Description:	Date the data was loaded or updated, or date of the source file.

Data Steward

CC ID: 43504

Date Effective From:	2006-08-31
Date Effective To:
Contact (Person):	Kawamoto, Kurt E
Address:	1845 Wasp Blvd. Honolulu, HI 96818 USA
Email Address:	kurt.kawamoto@noaa.gov
Phone:	(808)725-5326
Fax:	(808)725-5475

Originator

CC ID: 43505

Date Effective From:	2006-08-31
Date Effective To:
Contact (Person):	Cabacungan, Frank L
Address:	1845 Wasp Blvd. Honolulu, HI 96818 USA
Email Address:	frank.cabacungan@noaa.gov
Phone:	(808)725-5321

Point of Contact

CC ID: 43503

Date Effective From:	2008-04-08
Date Effective To:
Contact (Person):	Lowe, Kimberly
Address:	1845 Wasp Blvd. Honolulu, HI 96818 USA
Email Address:	kimberly.lowe@noaa.gov
Phone:	(808)725-5660
Business Hours:	9:00 a.m. - 5:30 p.m. HST M-F

Security Class:	Confidential

Issue 1

CC ID: 43545

Issue Date:	2011-06-06
Author:	Brent Miyamoto
Issue:	Month, day, boat, area, species, buyer, condition, triptype are padded with leading zero(s) or left justified.

Catalog Item ID:	11044
GUID:	gov.noaa.nmfs.inport:11044
Metadata Record Created By:	Brent M Miyamoto
Metadata Record Created:	2011-05-26 20:35+0000
Metadata Record Last Modified By:	Bradley M Gough
Metadata Record Last Modified:	2025-02-20 00:53+0000
Metadata Record Published:	2025-02-20
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Review Frequency:	1 Year

UFA Auction Sampling Data

Summary

Entity Information

Child Items

Contact Information

Item Identification

Keywords

Theme Keywords

Physical Location

Entity Information

Data Attributes

Attribute Summary

Attribute Details

YEAR

MONTH

DAY

BOAT

AREA

SPECIES

NUM

POUNDS

PRICE

BUYER

CONDITION

TRIPTYPE

TRIPNUM

CONV

FROM_FILE

POSTED

Support Roles

Data Steward

Originator

Point of Contact

Access Information

Issues

Issue 1

Catalog Details