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

Summary

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.

Description

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

Entity Information

Entity Type
Data Table

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

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

Extents

Time Frame 1
2009-05-01 - Present

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