UFA Auction Sampling Data
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:11044 | Updated: February 20, 2025 | Published / External
Item Identification
| Title: | UFA Auction Sampling Data |
|---|---|
| Short Name: | UFA |
| Status: | In Work |
Keywords
Theme Keywords
| Thesaurus | Keyword |
|---|---|
| UNCONTROLLED | |
| None | FMB |
| None | FRMD |
Physical Location
| Organization: | Pacific Islands Fisheries Science Center |
|---|---|
| City: | Honolulu |
| State/Province: | HI |
| Country: | USA |
Entity Information
| Entity Type: | Data Table |
|---|---|
| Active Version?: | Yes |
| Alias: | UFA |
| Schema Name: | UFA |
| Description: |
UFA Auction Sampling Data. |
Data Attributes
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. |
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. |
Support Roles
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 |
Access Information
| Security Class: | Confidential |
|---|
Issues
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 Details
| 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 |