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
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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.
DescriptionOpah 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
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
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
![]() |
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
|
![]() |
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Extents
Extent Group 1
Extent Group 1 / Time Frame 1
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 |