Slide Menu
Jump to Section...
Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Fisheries Research and Monitoring Divisio... > Life History Program > Archival > Opah Tissue Samples Collected and Information R... >

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

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

Item Identification

Title: Column Notes for Opah Tissue Samples Collected and Information on Lampris spp.
Status: In Work
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.

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None distribution
None fin clip
None genetics
None lampris

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
Description:

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

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key COUNTRY VARCHAR2 The country from which the contact is located.
100
 CONTACT_LAST_NAME VARCHAR2 The last name of the specific contact.
100
 CONTACT_FIRST_NAME VARCHAR2 The first name of the specific contact.
100
 Primary Key MUSEUM_LAB_AFFILIATION VARCHAR2 The museum, lab, research institution, or affiliation associated with the contact.
100
 ADDRESS VARCHAR2 The address of the museum, lab, research institution, or affiliation associated with the contact.
100
 CITY VARCHAR2 The city of the museum, lab, research institution, or affiliation associated with the contact.
100
 STATE_PROVINCE VARCHAR2 The state or province of the museum, lab, research institution, or affiliation associated with the contact.
100
 POSTAL_CODE VARCHAR2 The postal code of the museum, lab, research institution, or affiliation associated with the contact.
100
 PHONE_NUMBER NUM The phone number of the museum, lab, research institution, or affiliation associated with the contact.
100
 FAX_NUMBER NUM The fax number of the museum, lab, research institution, or affiliation associated with the contact.
100
 EMAIL_ADDRESS VARCHAR The email address of the museum, lab, research institution, or affiliation associated with the contact.
100
 WEBSITE VARCHAR The website of the museum, lab, research institution, or affiliation associated with the contact. The URL is included in the record.
100
 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
 INITIAL_CONTACT_DATE DATE The date the researcher initially contacted the museum, lab, research institution, or affiliation.
100
 NOTES VARCHAR2 Notes explaining the reasons I chose to contact this specific museum, lab, research institution, or affiliation.
100
 DATE_REPLIED_BACK VARCHAR2 The date the museum, lab, research institution, or affiliation responded to my inquiry.
100
 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
 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
 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
 OBSERVER_PROGRAM_YN CHAR Is this particular contact associated with an observer program, yes (Y) or no (N)?

Attribute Details

COUNTRY

CC ID: 45008
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: Yes
Status: Active
Description:

The country from which the contact is located.
Null Value: NO

CONTACT_LAST_NAME

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

The last name of the specific contact.
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.

CONTACT_FIRST_NAME

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

The first name of the specific contact.
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.

MUSEUM_LAB_AFFILIATION

CC ID: 45011
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 50
Required: Yes
Primary Key: Yes
Status: Active
Description:

The museum, lab, research institution, or affiliation associated with the contact.
Null Value: NO

ADDRESS

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

The address of the museum, lab, research institution, or affiliation associated with the contact.
Null Value: YES
Null Value Meaning:

Address is unknown.

CITY

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

The city of the museum, lab, research institution, or affiliation associated with the contact.
Null Value: YES
Null Value Meaning:

The city is unknown.

STATE_PROVINCE

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

The state or province of the museum, lab, research institution, or affiliation associated with the contact.
Null Value: YES
Null Value Meaning:

The state or province is unknown.

POSTAL_CODE

CC ID: 45015
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

The postal code of the museum, lab, research institution, or affiliation associated with the contact.
Null Value: YES
Null Value Meaning:

The postal code is unknown.

PHONE_NUMBER

CC ID: 45016
Seq. Order: 9
Data Storage Type: NUM
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

The phone number of the museum, lab, research institution, or affiliation associated with the contact.
Null Value: YES
Null Value Meaning:

The phone number is unknown.

FAX_NUMBER

CC ID: 45017
Seq. Order: 10
Data Storage Type: NUM
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

The fax number of the museum, lab, research institution, or affiliation associated with the contact.
Null Value: YES
Null Value Meaning:

The fax number is unknown.

EMAIL_ADDRESS

CC ID: 45018
Seq. Order: 11
Data Storage Type: VARCHAR
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

The email address of the museum, lab, research institution, or affiliation associated with the contact.
Null Value: YES
Null Value Meaning:

The email address is unknown.

WEBSITE

CC ID: 45019
Seq. Order: 12
Data Storage Type: VARCHAR
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

The website of the museum, lab, research institution, or affiliation associated with the contact. The URL is included in the record.
Null Value: YES
Null Value Meaning:

There is not a website or it is unknown.

CATALOG_NUMBER_IF_APPLICABLE

CC ID: 45021
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

The catalog number assigned to the specimen by the museum, lab, research institution, or affiliation associated with the contact.
Null Value: YES
Null Value Meaning:

There is not a catalog number available.

INITIAL_CONTACT_DATE

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

The date the researcher initially contacted the museum, lab, research institution, or affiliation.
Null Value: NO
Null Value Meaning:

There should always be a date provided as to when the specific entity was contacted.

NOTES

CC ID: 45022
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 500
Required: Yes
Primary Key: No
Status: Active
Description:

Notes explaining the reasons I chose to contact this specific museum, lab, research institution, or affiliation.
Null Value: NO
Null Value Meaning:

There should be something in this column to provide information regarding specific inquiries.

DATE_REPLIED_BACK

CC ID: 45023
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
Description:

The date the museum, lab, research institution, or affiliation responded to my inquiry.
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

REPLY_NOTES

CC ID: 45024
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 500
Required: Yes
Primary Key: No
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.
Null Value: NO
Null Value Meaning:

There should be something in this column to provide information regarding specific inquiries.

TISSUE_SAMPLE_YN

CC ID: 45025
Seq. Order: 18
Data Storage Type: CHAR
Max Length: 1
Required: Yes
Primary Key: No
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).
Null Value: NO
Allowed Values: Y, N

TISSUE_SAMPLE_NOTES

CC ID: 45026
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 500
Required: No
Primary Key: No
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.
Null Value: YES
Null Value Meaning:

A tissue sample was not located within this particular museum, lab, research institution, or affiliation.

OBSERVER_PROGRAM_YN

CC ID: 45027
Seq. Order: 20
Data Storage Type: CHAR
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Is this particular contact associated with an observer program, yes (Y) or no (N)?
Null Value: NO
Allowed Values: Y, N

Support Roles

This Catalog Item has no Support Roles that are currently in effect.
View Historical Support Roles

Extents

Extent Group 1

Extent Group 1 / Time Frame 1

CC ID: 45029
Time Frame Type: Continuing
Start: 2009-05-01

Access Information

Security Class: Confidential
Security Classification System:

Contains confidential fisheries data.
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.

Catalog Details

Catalog Item ID: 11631
GUID: gov.noaa.nmfs.inport: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 Review Frequency: 1 Year