UFA Auction Sampling Data

Pacific Islands Fisheries Science Center
Entity (ENT) | ID: 11044 | Published / External
Created: 2011-05-26   |   Last Modified: 2025-02-20

Parent: UFA Auction Sampling Data
Data Set (DS) | ID: 6349

ID: 11044
Entity (ENT)

* Discovery
• First Pass
» Metadata Rubric

Item Identification

* » Title UFA Auction Sampling Data
Short Name UFA
* Status In Work
Creation Date  
Revision Date  
• Publication Date  
* » Abstract
* Purpose
Notes
Other Citation Details
• Supplemental Information
DOI (Digital Object Identifier)  
DOI Registration Authority  
DOI Issue Date  

Keywords

Theme Keywords

Thesaurus Keyword
None FMB
None FRMD
   
   
   

Temporal Keywords

Thesaurus Keyword
   
   
   

* Spatial Keywords

Thesaurus Keyword
   
   
   

Stratum Keywords

Thesaurus Keyword
   
   
   

Instrument Keywords

Thesaurus Keyword
   
   
   

Platform Keywords

Thesaurus Keyword
   
   
   

Physical Location

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

Entity Information

Entity Type Data Table
Active Version? Y
Alias UFA
Schema Name UFA
» Description

UFA Auction Sampling Data.
Change Summary

Data Attributes

Attribute Summary

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

Attribute Details

Attribute Name YEAR
Seq. Order 1
Data Storage Type VARCHAR2
Max Length 4
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Year of sample
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name MONTH
Seq. Order 2
Data Storage Type VARCHAR2
Max Length 2
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Month of sample; left justified, one-digit months may or may not be padded with leading zero
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name DAY
Seq. Order 3
Data Storage Type VARCHAR2
Max Length 2
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Day of sample; left justified, one-digit days may or may not be padded with leading zero
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name BOAT
Seq. Order 4
Data Storage Type VARCHAR2
Max Length 6
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Code for boat or fisher; left justified, one-digit code may or may not be padded with leading zero
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name AREA
Seq. Order 5
Data Storage Type VARCHAR2
Max Length 3
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Code for area fished; left justified, one-digit code may or may not be padded with leading zero
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SPECIES
Seq. Order 6
Data Storage Type VARCHAR2
Max Length 5
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Code for species; left justified, one-digit code may or may not be padded with leading zero
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NUM
Seq. Order 7
Data Storage Type NUMERIC
Max Length 4
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Number of pieces
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name POUNDS
Seq. Order 8
Data Storage Type NUMERIC
Max Length 7
Min Length  
Required No
Primary Key No
Precision  
Scale 2
Status Active
Description

Adjusted whole weight of fish
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PRICE
Seq. Order 9
Data Storage Type NUMERIC
Max Length 6
Min Length  
Required No
Primary Key No
Precision  
Scale 2
Status Active
Description

Price per (sold) pounds
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name BUYER
Seq. Order 10
Data Storage Type VARCHAR2
Max Length 6
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Code for buyer; code is padded with leading zeros or left justified
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CONDITION
Seq. Order 11
Data Storage Type VARCHAR2
Max Length 2
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Code for condition or state of fish; code is padded with leading zero or left justified
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TRIPTYPE
Seq. Order 12
Data Storage Type VARCHAR2
Max Length 2
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Code for trip type; code is padded with leading zero or left justified
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TRIPNUM
Seq. Order 13
Data Storage Type VARCHAR2
Max Length 5
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

For longline trips, this field is comprised of the trip_type_code and trip_number from the longline logbook data
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CONV
Seq. Order 14
Data Storage Type NUMERIC
Max Length 4
Min Length  
Required No
Primary Key No
Precision  
Scale 2
Status Active
Description

Conversion factor to convert auction weight to whole weight of fish
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FROM_FILE
Seq. Order 15
Data Storage Type VARCHAR2
Max Length 12
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Source file of the data
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name POSTED
Seq. Order 16
Data Storage Type DATE
Max Length 21
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

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

General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Support Roles

» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.
* » Support Role Data Steward
* » Date Effective From 2006-08-31
Date Effective To
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
Mobile  
URL  
Business Hours  
Contact Instructions
* » Support Role Originator
* » Date Effective From 2006-08-31
Date Effective To
Person Cabacungan, Frank L
Address 1845 Wasp Blvd.
Honolulu, HI 96818
USA
Email Address frank.cabacungan@noaa.gov
Phone (808)725-5321
Fax  
Mobile  
URL  
Business Hours  
Contact Instructions
* » Support Role Point of Contact
* » Date Effective From 2008-04-08
Date Effective To
Person Lowe, Kimberly
Address 1845 Wasp Blvd.
Honolulu, HI 96818
USA
Email Address kimberly.lowe@noaa.gov
Phone (808)725-5660
Fax  
Mobile  
URL  
Business Hours 9:00 a.m. - 5:30 p.m. HST M-F
Contact Instructions
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions

Extents

Currentness Reference  

Extent Group 1

Extent Description

Extent Group 1 / Geographic Area

* » W° Bound
* » E° Bound
* » N° Bound
* » S° Bound
* » Description

Extent Group 1 / Vertical Extent

EPSG Code
Vertical Minimum
Vertical Maximum

Extent Group 1 / Time Frame

* » Time Frame Type
* » Start
End
Alternate Start as of Info
Alternate End as of Info
Description

Access Information

* » Security Class Confidential
* Security Classification System
Security Handling Description
• Data Access Policy
» Data Access Procedure
• » Data Access Constraints
• Data Use Constraints
Metadata Access Constraints
Metadata Use Constraints

Distribution Information

Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status
Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status
Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status

Activity Log

Activity Time
Activity Type
Responsible Party
Description
Activity Time
Activity Type
Responsible Party
Description
Activity Time
Activity Type
Responsible Party
Description

Issues

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.
Issue Date
Author
Issue
Issue Date
Author
Issue
Issue Date
Author
Issue

FAQs

Date
Author
Question
Answer

Child Items

Rubric scores updated every 15m

Score Type Title
     
     
     

Related Items

Item Type Relationship Type Title
     
     
     

Catalog Details

Catalog Item ID 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 Workflow State Published / External
Metadata Last Review Date  
Metadata Review Frequency 1 Year
Metadata Next Review Date  
Tags