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

Summary

Description

UFA_SPEC.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
CODE
VARCHAR2
Code for the species; left justified
NAME
VARCHAR2
Species name
UFA_NAME
VARCHAR2
Species name used by UFA
RNP
LOGICAL
(R)equired (N)ame (P)ieces - field used by the error checking program
MAJOR
VARCHAR2
Major grouping; field used for processing
MINOR
VARCHAR2
Minor grouping; field used for processing
SEQ
VARCHAR2
Sequence in major / minor grouping; field used for processing
POSTED
DATE
Date the data was posted or updated, or date of the source file. Default date format is DD-MON-YY

Child Items

No Child Items for this record.

Contact Information

Point of Contact
Kimberly Lowe
kimberly.lowe@noaa.gov
(808)725-5660

Item Identification

Title: UFA_SPEC
Status: In Work
Notes:

Reference code table

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
Schema Name: UFA
Description:

UFA_SPEC.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
CODE VARCHAR2 Code for the species; left justified
100
NAME VARCHAR2 Species name
100
UFA_NAME VARCHAR2 Species name used by UFA
100
RNP LOGICAL (R)equired (N)ame (P)ieces - field used by the error checking program
100
MAJOR VARCHAR2 Major grouping; field used for processing
100
MINOR VARCHAR2 Minor grouping; field used for processing
100
SEQ VARCHAR2 Sequence in major / minor grouping; field used for processing
100
POSTED DATE Date the data was posted or updated, or date of the source file. Default date format is DD-MON-YY

Attribute Details

CODE

CC ID: 43512
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Code for the species; left justified

NAME

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

Species name

UFA_NAME

CC ID: 43514
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 35
Required: No
Primary Key: No
Status: Active
Description:

Species name used by UFA

RNP

CC ID: 43515
Seq. Order: 4
Data Storage Type: LOGICAL
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

(R)equired (N)ame (P)ieces - field used by the error checking program

MAJOR

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

Major grouping; field used for processing

MINOR

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

Minor grouping; field used for processing

SEQ

CC ID: 43518
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Sequence in major / minor grouping; field used for processing

POSTED

CC ID: 43519
Seq. Order: 8
Data Storage Type: DATE
Max Length: 21
Required: No
Primary Key: No
Status: Active
Description:

Date the data was posted or updated, or date of the source file. Default date format is DD-MON-YY

Support Roles

Data Steward

CC ID: 43524
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: 43525
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: 43523
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: 43542
Issue Date: 2011-06-06
Author: Brent Miyamoto
Issue:

Code for species is left justified.

Catalog Details

Catalog Item ID: 11069
GUID: gov.noaa.nmfs.inport:11069
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2011-06-06 16:07+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