Column Notes for Opah Tissue Samples Collected and Information on Lampris spp.

Pacific Islands Fisheries Science Center
Entity (ENT) | ID: 11631 | Published / External
Created: 2012-01-06   |   Last Modified: 2025-02-13

Parent: Opah Tissue Samples Collected and Information Regarding Lampris spp. Obtained from Various Entities
Data Set (DS) | ID: 10837

ID: 11631
Entity (ENT)

* Discovery
• First Pass
» Metadata Rubric

Item Identification

* » Title Column Notes for Opah Tissue Samples Collected and Information on Lampris spp.
Short Name  
* Status In Work
Creation Date  
Revision Date  
• Publication Date  
* » Abstract

Description of the columns created for the Opah Tissue Samples Collected and Information Regarding Lampris spp. Obtained from Various Entities. Describes dataset and what information each column could contain.
* Purpose
Notes
Other Citation Details
• Supplemental Information
DOI (Digital Object Identifier)  
DOI Registration Authority  
DOI Issue Date  

Keywords

Theme Keywords

Thesaurus Keyword
None distribution
None fin clip
None genetics
None lampris
   
   
   

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

The Life History Program has relocated to the Honolulu IRC facility on Ford Island hence; most data sets are stored there.

Entity Information

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

Opah Tissue Samples Collected and Information Regarding Lampris spp. Obtained from Various Entities.
Change Summary

Data Attributes

Attribute Summary

Score Req'd? PKey? » Name Data Storage Type Description
100 Yes Yes COUNTRY VARCHAR2 The country from which the contact is located.
100 No No CONTACT_LAST_NAME VARCHAR2 The last name of the specific contact.
100 No No CONTACT_FIRST_NAME VARCHAR2 The first name of the specific contact.
100 Yes Yes MUSEUM_LAB_AFFILIATION VARCHAR2 The museum, lab, research institution, or affiliation associated with the contact.
100 No No ADDRESS VARCHAR2 The address of the museum, lab, research institution, or affiliation associated with the contact.
100 No No CITY VARCHAR2 The city of the museum, lab, research institution, or affiliation associated with the contact.
100 No No STATE_PROVINCE VARCHAR2 The state or province of the museum, lab, research institution, or affiliation associated with the contact.
100 No No POSTAL_CODE VARCHAR2 The postal code of the museum, lab, research institution, or affiliation associated with the contact.
100 No No PHONE_NUMBER NUM The phone number of the museum, lab, research institution, or affiliation associated with the contact.
100 No No FAX_NUMBER NUM The fax number of the museum, lab, research institution, or affiliation associated with the contact.
100 No No EMAIL_ADDRESS VARCHAR The email address of the museum, lab, research institution, or affiliation associated with the contact.
100 No No WEBSITE VARCHAR The website of the museum, lab, research institution, or affiliation associated with the contact. The URL is included in the record.
100 No No CATALOG_NUMBER_IF_APPLICABLE VARCHAR2 The catalog number assigned to the specimen by the museum, lab, research institution, or affiliation associated with the contact.
100 Yes No INITIAL_CONTACT_DATE DATE The date the researcher initially contacted the museum, lab, research institution, or affiliation.
100 Yes No NOTES VARCHAR2 Notes explaining the reasons I chose to contact this specific museum, lab, research institution, or affiliation.
100 Yes No DATE_REPLIED_BACK VARCHAR2 The date the museum, lab, research institution, or affiliation responded to my inquiry.
100 Yes No REPLY_NOTES VARCHAR2 Details about the correspondence between myself and the museum, lab, research institution, or affiliation. May include information about whether or not a specimen can be acquired or is available.
100 Yes No TISSUE_SAMPLE_YN CHAR Will there a tissue sample be acquired as a result of this particular correspondence? Is there a possibility of collecting tissue samples in the future? Yes (Y) or no (N).
100 No No TISSUE_SAMPLE_NOTES VARCHAR2 Specific details regarding the tissue sample acquired, information about future collaboration, and the possibility of additional samples are included in this column.
100 Yes No OBSERVER_PROGRAM_YN CHAR Is this particular contact associated with an observer program, yes (Y) or no (N)?

Attribute Details

Attribute Name COUNTRY
Seq. Order 1
Data Storage Type VARCHAR2
Max Length 30
Min Length  
Required Yes
Primary Key Yes
Precision  
Scale  
Status Active
Description

The country from which the contact is located.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value NO
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CONTACT_LAST_NAME
Seq. Order 2
Data Storage Type VARCHAR2
Max Length 30
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

The last name of the specific contact.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value YES
Null Value Meaning

For general inquiries executed through a website or other means, a specific person may not be associated with that inquiry.
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CONTACT_FIRST_NAME
Seq. Order 3
Data Storage Type VARCHAR2
Max Length 30
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

The first name of the specific contact.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value YES
Null Value Meaning

For general inquiries executed through a website or other means, a specific person may not be associated with that inquiry.
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name MUSEUM_LAB_AFFILIATION
Seq. Order 4
Data Storage Type VARCHAR2
Max Length 50
Min Length  
Required Yes
Primary Key Yes
Precision  
Scale  
Status Active
Description

The museum, lab, research institution, or affiliation associated with the contact.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value NO
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name ADDRESS
Seq. Order 5
Data Storage Type VARCHAR2
Max Length 30
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

The address of the museum, lab, research institution, or affiliation associated with the contact.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value YES
Null Value Meaning

Address is unknown.
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CITY
Seq. Order 6
Data Storage Type VARCHAR2
Max Length 30
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

The city of the museum, lab, research institution, or affiliation associated with the contact.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value YES
Null Value Meaning

The city is unknown.
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name STATE_PROVINCE
Seq. Order 7
Data Storage Type VARCHAR2
Max Length 30
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

The state or province of the museum, lab, research institution, or affiliation associated with the contact.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value YES
Null Value Meaning

The state or province is unknown.
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name POSTAL_CODE
Seq. Order 8
Data Storage Type VARCHAR2
Max Length 30
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

The postal code of the museum, lab, research institution, or affiliation associated with the contact.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value YES
Null Value Meaning

The postal code is unknown.
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PHONE_NUMBER
Seq. Order 9
Data Storage Type NUM
Max Length 20
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

The phone number of the museum, lab, research institution, or affiliation associated with the contact.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value YES
Null Value Meaning

The phone number is unknown.
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FAX_NUMBER
Seq. Order 10
Data Storage Type NUM
Max Length 20
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

The fax number of the museum, lab, research institution, or affiliation associated with the contact.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value YES
Null Value Meaning

The fax number is unknown.
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name EMAIL_ADDRESS
Seq. Order 11
Data Storage Type VARCHAR
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

The email address of the museum, lab, research institution, or affiliation associated with the contact.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value YES
Null Value Meaning

The email address is unknown.
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name WEBSITE
Seq. Order 12
Data Storage Type VARCHAR
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

The website of the museum, lab, research institution, or affiliation associated with the contact. The URL is included in the record.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value YES
Null Value Meaning

There is not a website or it is unknown.
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CATALOG_NUMBER_IF_APPLICABLE
Seq. Order 13
Data Storage Type VARCHAR2
Max Length 30
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

The catalog number assigned to the specimen by the museum, lab, research institution, or affiliation associated with the contact.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value YES
Null Value Meaning

There is not a catalog number available.
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name INITIAL_CONTACT_DATE
Seq. Order 14
Data Storage Type DATE
Max Length 8
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

The date the researcher initially contacted the museum, lab, research institution, or affiliation.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value NO
Null Value Meaning

There should always be a date provided as to when the specific entity was contacted.
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NOTES
Seq. Order 15
Data Storage Type VARCHAR2
Max Length 500
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

Notes explaining the reasons I chose to contact this specific museum, lab, research institution, or affiliation.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value NO
Null Value Meaning

There should be something in this column to provide information regarding specific inquiries.
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name DATE_REPLIED_BACK
Seq. Order 16
Data Storage Type VARCHAR2
Max Length 30
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

The date the museum, lab, research institution, or affiliation responded to my inquiry.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value NO
Null Value Meaning

This entry will almost always be a date, but some inquiries were unsuccessful and I never received a response.
Allowed Values Awaiting Reply, Never Replied, the date
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name REPLY_NOTES
Seq. Order 17
Data Storage Type VARCHAR2
Max Length 500
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

Details about the correspondence between myself and the museum, lab, research institution, or affiliation. May include information about whether or not a specimen can be acquired or is available.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value NO
Null Value Meaning

There should be something in this column to provide information regarding specific inquiries.
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TISSUE_SAMPLE_YN
Seq. Order 18
Data Storage Type CHAR
Max Length 1
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

Will there a tissue sample be acquired as a result of this particular correspondence? Is there a possibility of collecting tissue samples in the future? Yes (Y) or no (N).
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value NO
Null Value Meaning
Allowed Values Y, N
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TISSUE_SAMPLE_NOTES
Seq. Order 19
Data Storage Type VARCHAR2
Max Length 500
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Specific details regarding the tissue sample acquired, information about future collaboration, and the possibility of additional samples are included in this column.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value YES
Null Value Meaning

A tissue sample was not located within this particular museum, lab, research institution, or affiliation.
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OBSERVER_PROGRAM_YN
Seq. Order 20
Data Storage Type CHAR
Max Length 1
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

Is this particular contact associated with an observer program, yes (Y) or no (N)?
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value NO
Null Value Meaning
Allowed Values Y, N
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 2008-01-01
Date Effective To 2015-12
Person Sundberg, Meagan A
Address 1845 Wasp Blvd.
Honolulu, HI 96818
USA
Email Address meagan.sundberg@noaa.gov
Phone (808)725-5379
Fax  
Mobile  
URL  
Business Hours 7:30 a.m. - 4:00 p.m. M-F
Contact Instructions

Email with questions.
* » 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 1

* » Time Frame Type Continuing
* » Start 2009-05-01
End  
Alternate Start As Of Info  
Alternate End As Of Info  
Description

Access Information

* » Security Class Confidential
* Security Classification System

Contains confidential fisheries data.
Security Handling Description
• Data Access Policy

Some of the information within may be confidential, but much of it is available to the public from credited museums, research institutions, etc. Inquire about specifics.
» 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
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 11631
Metadata Record Created By Meagan A Sundberg
Metadata Record Created 2012-01-06 16:11+0000
Metadata Record Last Modified By Michael Chang
» Metadata Record Last Modified 2025-02-13 23:18+0000
Metadata Record Published 2025-02-13
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