Column Notes for Striped Marlin Hardparts and Gonads Collected by the Hawaii LOP.
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 11761
| Published / External
Created: 2012-02-13
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 11760
ID: 11761
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Column Notes for Striped Marlin Hardparts and Gonads Collected by the Hawaii LOP. |
---|---|
Short Name | |
* Status | In Work |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
Column Notes describing what is included in the striped marlin (Tetrapturus audax) hardparts and gonad database, Collected by the PIRO Hawaii Longline Observer Program (LOP). |
* Purpose | |
Notes | |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
None | Dorsal Spines |
None | EFL |
None | Gender |
None | Gonads |
None | Hawaiian Longline Observer Program |
None | Histology |
None | Otoliths |
None | PIRO |
None | Striped Marlin |
None | tetrapturus audax |
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
None | central North Pacific |
None | Hawaii |
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 |
Striped Marlin (Tetrapturus audax) Hardparts and Gonads Collected by the PIRO Hawaii Longline Observer Program. |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | LONGLINE_TRIP_NUM | VARCHAR | The longline trip number the specimen was caught during; this should be written onto the specimen identification tag as part of the fish data num. |
100 | No | No | SET | NUMBER | The set number of a particular trip the specimen was caught during; this should be written onto the specimen identification tag as part of the fish data num. |
100 | No | No | PAGE | NUMBER | The catch event page number; this should be written onto the specimen identification tag as part of the fish data num. |
100 | No | No | LINE | NUMBER | The catch event line number; this should be written onto the specimen identification tag as part of the fish data num. |
100 | No | No | SPECIMEN_NUM_COMMENTS | VARCHAR | Any comments about the specimen number. There were a lot of discrepancies between the written specimen tag numbers and what was entered into Data Trawler. Identified differences between hand-written tag and what was entered into Data Trawler is noted here. |
100 | No | Yes | FISH_DATA_NUM | VARCHAR | AKA the SPECIMEN_ID, it is a combination of the Longline Trip Num, Set, Page, and Line Number. This is the unique identifier for the specimen, if there are discrepancies or uncertainties about the integrity of the Longline Trip Num, Set, Page, or Line, the data may be unreliable. |
100 | Yes | No | DATA_MISSING_OR_INCORRECT_YN | CHAR | Were there discrepancies between what was written on the specimen tag and what was entered into Data Trawler? Is there important information about a particular specimen missing? Yes (Y) or no (N)? |
100 | No | No | COLLECTION_DATE_BEGIN_HAUL | DATE | The begin haul date of the set the specimen was caught is used for the collection date. If not available on the specimen tag, the collection date/begin haul date is found by looking up the specimen ID in Data Trawler. |
100 | No | No | LENGTH_EFL_CM | NUMBER | The EFL (eye to fork length) measured at sea by an observer recorded in centimeters. If not available on the specimen tag, the EFL can be found by looking up the SPECIEMN_ID in Data Trawler. |
100 | No | No | LENGTH_COMMENTS | VARCHAR | Comments about the length of the specimen such as differences between the value written on the tag and the value entered into Data Trawler. |
100 | No | No | CATCH_LOCATION_BEG_HAUL_LAT_DEC_DEG | NUMBER | The latitude of the begin haul of the set the specimen was caught is recorded for the catch location in decimal degrees. The catch location begin haul latitude is found by looking up the SPECIMEN_ID in Data Trawler. |
100 | No | No | CATCH_LOCATION_BEG_HAUL_LONG_DEC_DEG | NUMBER | The longitude of the begin haul of the set the specimen was caught is recorded for the catch location in decimal degrees. The catch location begin haul longitude is found by looking up the specimen ID in Data Trawler. |
100 | Yes | No | 4TH_DORSAL_SPINE_EXTRACTED_YNU | CHAR | Was the 4th dorsal spine from this specimen extracted and brought to the Aiea lab for processing, yes (Y), no (N), or unknown (U)? |
100 | Yes | No | 5TH_DORSAL_SPINE_EXTRACTED_YNU | CHAR | Was the 5th dorsal spine from this specimen extracted and brought to the Aiea lab for processing, yes (Y), no (N), or unknown (U)? |
100 | No | No | DF_RAYS_GIVEN_TO_KOPF_YN | CHAR | Were the 4th and/or 5th dorsal spines sent to Dr. Keller Kopf for age and growth work, yes (Y), no (N), or unknown (U)? |
100 | No | No | SAGITTAE | NUMBER | The number of sagittae successfully extracted from the specimen. |
100 | No | No | LAPILLAE | NUMBER | The number of lapillae successfully extracted from the specimen. |
100 | No | No | ASTERI | NUMBER | The number of asteri successfully extracted from the specimen. |
100 | No | No | VISUAL_GENDER_ID_MFU | CHAR | The gender of the fish determined visually either male (M), female (F), or unknown (U) should be entered here. |
100 | No | No | TOTAL_GONAD_WEIGHT_G | NUMBER | The weight of the whole gonad in grams. |
100 | No | No | TOTAL_GONAD_WEIGHT_KG | NUMBER | The weight of the whole gonad in kilograms. |
100 | No | No | RIGHT_LOBE_GONAD_WEIGHT_G | NUMBER | The weight of the right lobe of the gonad in grams. |
100 | No | No | LEFT_LOBE_GONAD_WEIGHT_G | NUMBER | The weight of the left lobe of the gonad in grams. |
100 | No | No | DATE_FIXED_IN_FORMALIN | DATE | The date that the gonads were fixed in formalin by the Life History Program (LHP) staff at the Aiea lab. |
100 | No | No | FROZEN_TO_FORMALIN_FIXED_YN | CHAR | The date that the gonads were fixed in formalin by the Life History Program (LHP) staff at the Aiea lab after they were stored frozen at sea. |
100 | Yes | No | GLYO_FIXX_AT_SEA_YNU | CHAR | Were the gonads fixed in Glyo Fixx by an observer at sea, yes (Y), no (N), or unknown (U)? |
100 | Yes | No | HISTO_SLIDE_CREATED_YNU | CHAR | Was a cross sectioned fragment of the collected gonad sent to John Burns Medical School for creation of a histological microscope slide, yes (Y), no (N), unknown (U)? |
100 | No | No | HISTO_GENDER_ID_MFU | CHAR | If a histological slide was created, the gender determined using the information found on the slide, male (M), female (F), unknown (U). |
100 | No | No | GENERAL_COMMENTS | VARCHAR | Any comments about the specimen. There were a lot of discrepancies between what was recorded on the specimen tag and the data entered into Data Trawler, these difference are noted here. |
Attribute Details
Attribute Name | LONGLINE_TRIP_NUM |
---|---|
Seq. Order | 1 |
Data Storage Type | VARCHAR |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The longline trip number the specimen was caught during; this should be written onto the specimen identification tag as part of the fish data num. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | Yes |
Null Value Meaning |
There is a discrepancy in the data and the longline trip number written on the specimen tag does not match what was entered into Data Trawler or no information was recorded. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SET |
---|---|
Seq. Order | 2 |
Data Storage Type | NUMBER |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The set number of a particular trip the specimen was caught during; this should be written onto the specimen identification tag as part of the fish data num. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | Yes |
Null Value Meaning |
There is a discrepancy in the data and the set number written on the specimen tag does not match what was entered into Data Trawler or no information was recorded. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PAGE |
---|---|
Seq. Order | 3 |
Data Storage Type | NUMBER |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The catch event page number; this should be written onto the specimen identification tag as part of the fish data num. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | Yes |
Null Value Meaning |
There is a discrepancy in the data, the page number written on the specimen tag does not match what was entered into data trawler, or no information was recorded. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LINE |
---|---|
Seq. Order | 4 |
Data Storage Type | NUMBER |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The catch event line number; this should be written onto the specimen identification tag as part of the fish data num. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | Yes |
Null Value Meaning |
There is a discrepancy in the data, the line number written on the specimen tag does not match what was entered into Data Trawler, or no information was recorded. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SPECIMEN_NUM_COMMENTS |
---|---|
Seq. Order | 5 |
Data Storage Type | VARCHAR |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Any comments about the specimen number. There were a lot of discrepancies between the written specimen tag numbers and what was entered into Data Trawler. Identified differences between hand-written tag and what was entered into Data Trawler is noted here. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | Yes |
Null Value Meaning |
There were no comments or discrepancies about the specimen number worth noting. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FISH_DATA_NUM |
---|---|
Seq. Order | 6 |
Data Storage Type | VARCHAR |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | Yes |
Precision | |
Scale | |
Status | Active |
Description |
AKA the SPECIMEN_ID, it is a combination of the Longline Trip Num, Set, Page, and Line Number. This is the unique identifier for the specimen, if there are discrepancies or uncertainties about the integrity of the Longline Trip Num, Set, Page, or Line, the data may be unreliable. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | Yes |
Null Value Meaning |
This is the unique identifier for all specimens, but some specimens don't have a valid fish data number, if this is the case, there will be a note in the SPECIMEN_NUM_COMMENTS. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DATA_MISSING_OR_INCORRECT_YN |
---|---|
Seq. Order | 7 |
Data Storage Type | CHAR |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Were there discrepancies between what was written on the specimen tag and what was entered into Data Trawler? Is there important information about a particular specimen missing? Yes (Y) or no (N)? |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | No |
Null Value Meaning |
The data is either in good shape or variations exist between what is written on the specimen tag and what has been entered into Data Trawler, if the answer to this is yes (Y), the data may be unreliable. |
Allowed Values | Y, N |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | COLLECTION_DATE_BEGIN_HAUL |
---|---|
Seq. Order | 8 |
Data Storage Type | DATE |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The begin haul date of the set the specimen was caught is used for the collection date. If not available on the specimen tag, the collection date/begin haul date is found by looking up the specimen ID in Data Trawler. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | Yes |
Null Value Meaning |
The date is unknown or was not recorded. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LENGTH_EFL_CM |
---|---|
Seq. Order | 9 |
Data Storage Type | NUMBER |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The EFL (eye to fork length) measured at sea by an observer recorded in centimeters. If not available on the specimen tag, the EFL can be found by looking up the SPECIEMN_ID in Data Trawler. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | Yes |
Null Value Meaning |
The EFL is unknown or was not recorded. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LENGTH_COMMENTS |
---|---|
Seq. Order | 10 |
Data Storage Type | VARCHAR |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Comments about the length of the specimen such as differences between the value written on the tag and the value entered into Data Trawler. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | Yes |
Null Value Meaning |
No comments on the length are worth noting. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CATCH_LOCATION_BEG_HAUL_LAT_DEC_DEG |
---|---|
Seq. Order | 11 |
Data Storage Type | NUMBER |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The latitude of the begin haul of the set the specimen was caught is recorded for the catch location in decimal degrees. The catch location begin haul latitude is found by looking up the SPECIMEN_ID in Data Trawler. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | Yes |
Null Value Meaning |
The Fish Data Number is invalid, the latitude of the catch location wasn't recorded, or the latitude is unknown. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CATCH_LOCATION_BEG_HAUL_LONG_DEC_DEG |
---|---|
Seq. Order | 12 |
Data Storage Type | NUMBER |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The longitude of the begin haul of the set the specimen was caught is recorded for the catch location in decimal degrees. The catch location begin haul longitude is found by looking up the specimen ID in Data Trawler. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | Yes |
Null Value Meaning |
The Fish Data Number is invalid, the longitude of the catch location wasn't recorded, or is unknown. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | 4TH_DORSAL_SPINE_EXTRACTED_YNU |
---|---|
Seq. Order | 13 |
Data Storage Type | CHAR |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Was the 4th dorsal spine from this specimen extracted and brought to the Aiea lab for processing, yes (Y), no (N), or unknown (U)? |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | No |
Null Value Meaning |
It is either known or unknown if the 4th dorsal spine was collected. |
Allowed Values | Y, N, U |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | 5TH_DORSAL_SPINE_EXTRACTED_YNU |
---|---|
Seq. Order | 14 |
Data Storage Type | CHAR |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Was the 5th dorsal spine from this specimen extracted and brought to the Aiea lab for processing, yes (Y), no (N), or unknown (U)? |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | No |
Null Value Meaning |
It is either known or unknown if the 5th dorsal spine was collected. |
Allowed Values | Y, N, U |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DF_RAYS_GIVEN_TO_KOPF_YN |
---|---|
Seq. Order | 15 |
Data Storage Type | CHAR |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Were the 4th and/or 5th dorsal spines sent to Dr. Keller Kopf for age and growth work, yes (Y), no (N), or unknown (U)? |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | No |
Null Value Meaning |
It is either known or unknown if the dorsal spines were sent to Dr. Keller Kopf. |
Allowed Values | Y, N, U |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SAGITTAE |
---|---|
Seq. Order | 16 |
Data Storage Type | NUMBER |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The number of sagittae successfully extracted from the specimen. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | No |
Null Value Meaning |
Either 0, 1, or 2 sagittae can be extracted. |
Allowed Values | 0, 1, 2 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LAPILLAE |
---|---|
Seq. Order | 17 |
Data Storage Type | NUMBER |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The number of lapillae successfully extracted from the specimen. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | No |
Null Value Meaning |
Either 0, 1, or 2 lapillae can be extracted. |
Allowed Values | 0, 1, 2 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ASTERI |
---|---|
Seq. Order | 18 |
Data Storage Type | NUMBER |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The number of asteri successfully extracted from the specimen. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | No |
Null Value Meaning |
Either 0, 1, or 2 asteri can be extracted. |
Allowed Values | 0, 1, 2 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | VISUAL_GENDER_ID_MFU |
---|---|
Seq. Order | 19 |
Data Storage Type | CHAR |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The gender of the fish determined visually either male (M), female (F), or unknown (U) should be entered here. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | No |
Null Value Meaning |
The gender is either male, female, or unknown. |
Allowed Values | M, F, U |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TOTAL_GONAD_WEIGHT_G |
---|---|
Seq. Order | 20 |
Data Storage Type | NUMBER |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The weight of the whole gonad in grams. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | Yes |
Null Value Meaning |
The gonad weight was not taken or was not recorded. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TOTAL_GONAD_WEIGHT_KG |
---|---|
Seq. Order | 21 |
Data Storage Type | NUMBER |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The weight of the whole gonad in kilograms. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | Yes |
Null Value Meaning |
The gonad weight was not taken or was not recorded. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RIGHT_LOBE_GONAD_WEIGHT_G |
---|---|
Seq. Order | 22 |
Data Storage Type | NUMBER |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The weight of the right lobe of the gonad in grams. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | Yes |
Null Value Meaning |
The gonad weight of the right lobe was not taken or was not recorded. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LEFT_LOBE_GONAD_WEIGHT_G |
---|---|
Seq. Order | 23 |
Data Storage Type | NUMBER |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The weight of the left lobe of the gonad in grams. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | Yes |
Null Value Meaning |
The gonad weight of the left lobe was not taken or was not recorded. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DATE_FIXED_IN_FORMALIN |
---|---|
Seq. Order | 24 |
Data Storage Type | DATE |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The date that the gonads were fixed in formalin by the Life History Program (LHP) staff at the Aiea lab. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | Yes |
Null Value Meaning |
No gonads were collected from this specimen, the gonads were not fixed in formalin, or the date was not recorded. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FROZEN_TO_FORMALIN_FIXED_YN |
---|---|
Seq. Order | 25 |
Data Storage Type | CHAR |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The date that the gonads were fixed in formalin by the Life History Program (LHP) staff at the Aiea lab after they were stored frozen at sea. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | Yes |
Null Value Meaning |
No gonads were collected from this specimen, the gonads were not fixed in formalin, previously stored frozen, or the date was not recorded. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GLYO_FIXX_AT_SEA_YNU |
---|---|
Seq. Order | 26 |
Data Storage Type | CHAR |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Were the gonads fixed in Glyo Fixx by an observer at sea, yes (Y), no (N), or unknown (U)? |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | No |
Null Value Meaning |
The gonads either were or were not fixed in Glyo Fixx at sea or it is unknown if the gonads were fixed in Glyo Fixx. |
Allowed Values | Y, N, U |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | HISTO_SLIDE_CREATED_YNU |
---|---|
Seq. Order | 27 |
Data Storage Type | CHAR |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Was a cross sectioned fragment of the collected gonad sent to John Burns Medical School for creation of a histological microscope slide, yes (Y), no (N), unknown (U)? |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | No |
Null Value Meaning |
A histological slide either was or was not created or it is not known if a slide was created. |
Allowed Values | Y, N, U |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | HISTO_GENDER_ID_MFU |
---|---|
Seq. Order | 28 |
Data Storage Type | CHAR |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
If a histological slide was created, the gender determined using the information found on the slide, male (M), female (F), unknown (U). |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | Yes |
Null Value Meaning |
Could be blank if a histological slide was not created. |
Allowed Values | M, F, U |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GENERAL_COMMENTS |
---|---|
Seq. Order | 29 |
Data Storage Type | VARCHAR |
Max Length | 500 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Any comments about the specimen. There were a lot of discrepancies between what was recorded on the specimen tag and the data entered into Data Trawler, these difference are noted here. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | Yes |
Null Value Meaning |
There were no additional comments about the specimen. |
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 |
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
* » 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
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» 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 | 11761 |
---|---|
Metadata Record Created By | Meagan A Sundberg |
Metadata Record Created | 2012-02-13 22:42+0000 |
Metadata Record Last Modified By | SysAdmin InPortAdmin |
» Metadata Record Last Modified | 2022-08-09 17:11+0000 |
Metadata Record Published | 2019-07-23 |
Owner Org | PIFSC |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | 2019-07-23 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2020-07-23 |
Tags |
---|