PIFG_TAGGING
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:58731 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | PIFG_TAGGING |
|---|---|
| Short Name: | PIFG_TAGGING |
| Status: | Completed |
| Abstract: |
Data for cooperative research tagging studies in MHI and Guam. |
Entity Information
| Entity Type: | Data Table |
|---|---|
| Active Version?: | Yes |
| Description: |
Data for cooperative research tagging studies in MHI and Guam. |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
DATASET_CODE | VARCHAR2 | Source ID Code assigned by the data entry staff (FC076). | |
|
100
|
VERSION_CODE | VARCHAR2 | Code for the format version assigned by the data entry staff. | |
|
100
|
ISLAND | VARCHAR2 | Island where fishing took place. | |
|
100
|
VESSEL_NAME | VARCHAR2 | Vessel name. | |
|
100
|
CAPTAIN_FIRST_NAME | VARCHAR2 | First name of captain. | |
|
100
|
CAPTAIN_LAST_NAME | VARCHAR2 | Last name of captain. | |
|
100
|
TRIP_START_MONTH | VARCHAR2 | The month the trip started in. | |
|
100
|
TRIP_START_DAY | VARCHAR2 | The day the trip started on. | |
|
100
|
TRIP_START_YEAR | VARCHAR2 | The year the trip started in. | |
|
100
|
TRIP_END_MONTH | VARCHAR2 | The month the trip ended in. | |
|
100
|
TRIP_END_DAY | VARCHAR2 | The day the trip ended on. | |
|
100
|
TRIP_END_YEAR | VARCHAR2 | The year the trip ended in. | |
|
100
|
FISHING_LOCATION | VARCHAR2 | Location where fishing occurred, if written in. | |
|
100
|
TAG_NUMBER_1 | VARCHAR2 | Tag number. | |
|
100
|
FORK_LENGTH_INCHES | VARCHAR2 | Fork length in inches. Units for values are inches. | |
|
100
|
FORK_LENGTH_CENTIMETERS | VARCHAR2 | Fork length in centimeters. Units for values are centimeters. | |
|
100
|
PURGE | VARCHAR2 | Was a tool used to treat barotrauma (Y=yes, Blank=no). | |
|
100
|
DROP_SHOT | VARCHAR2 | Was a weighted recompression device used to treat baratrauma (Y=yes, Blank=no). | |
|
100
|
RECAPTURED | VARCHAR2 | Was the fish a recapture (Y=yes, Blank=no). | |
|
100
|
RECAPTURED_AND_RELEASED | VARCHAR2 | If the fish was a recapture, was it released (Y=yes, Blank=no). | |
|
100
|
TAG_NUMBER_2 | VARCHAR2 | Additional tag number. | |
|
100
|
SPECIES | VARCHAR2 | Species of fish caught. | |
|
100
|
DATE_CAPTURED_MONTH | VARCHAR2 | Month fish was caught. | |
|
100
|
DATE_CAPTURED_DAY | VARCHAR2 | Day fish was caught. | |
|
100
|
DATE_CAPTURED_YEAR | VARCHAR2 | Year fish was caught. | |
|
100
|
LATITUDE_DEGREES | VARCHAR2 | Degrees latitutde where fish was caught. Units for values are degrees. | |
|
100
|
LATITUDE_MINUTES | VARCHAR2 | Minutes latitutde where fish was caught. Units for values are minutes. | |
|
100
|
LATITUDE_DIRECTION | VARCHAR2 | Latitude direction (N/S) where fish was caught. | |
|
100
|
LONGITUDE_DEGREES | VARCHAR2 | Degrees longitude where fish was caught. Units for values are degrees. | |
|
100
|
LONGITUDE_MINUTES | VARCHAR2 | Minutes longitude where fish was caught. Units for values are minutes. | |
|
100
|
LONGITUDE_DIRECTION | VARCHAR2 | Longitude direction (E/W) where fish was caught. | |
|
100
|
STATE_CHART_AREA_CODE | VARCHAR2 | State of Hawaii area code, if in Hawaii. | |
|
100
|
DEPTH_FATHOMS | VARCHAR2 | Depth in fathoms where fish was caught. Units for values are fathoms. | |
|
100
|
DEPTH_METERS | VARCHAR2 | Depth in meters where fish was caught. Units for values are meters. | |
|
100
|
NOTES_LINE_1 | VARCHAR2 | First line of comments from fisher. | |
|
100
|
NOTES_LINE_2 | VARCHAR2 | Second line of comments from fisher. | |
|
100
|
NOTES_LINE_3 | VARCHAR2 | Third line of comments from fisher. | |
|
100
|
JOB_NUMBER | VARCHAR2 | A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D12045. | |
|
100
|
FROM_FILE | VARCHAR2 | Name of the flat ASCII file that was the source of the data. | |
|
100
|
DATE_LOADED | DATE | Date when the record was loaded into Oracle or updated. | |
|
100
|
TAGGER | VARCHAR2 | Name of individual tagging the fish. |
Attribute Details
DATASET_CODE
CC ID: 895991
| Seq. Order: | 1 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 5 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Source ID Code assigned by the data entry staff (FC076). |
| General Data Type: | VARCHAR2 |
VERSION_CODE
CC ID: 895992
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code for the format version assigned by the data entry staff. |
| General Data Type: | VARCHAR2 |
ISLAND
CC ID: 895993
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Island where fishing took place. |
| General Data Type: | VARCHAR2 |
VESSEL_NAME
CC ID: 895994
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Vessel name. |
| General Data Type: | VARCHAR2 |
CAPTAIN_FIRST_NAME
CC ID: 895995
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
First name of captain. |
| General Data Type: | VARCHAR2 |
CAPTAIN_LAST_NAME
CC ID: 895996
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Last name of captain. |
| General Data Type: | VARCHAR2 |
TRIP_START_MONTH
CC ID: 895997
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The month the trip started in. |
| General Data Type: | VARCHAR2 |
TRIP_START_DAY
CC ID: 895998
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The day the trip started on. |
| General Data Type: | VARCHAR2 |
TRIP_START_YEAR
CC ID: 895999
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The year the trip started in. |
| General Data Type: | VARCHAR2 |
TRIP_END_MONTH
CC ID: 896000
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The month the trip ended in. |
| General Data Type: | VARCHAR2 |
TRIP_END_DAY
CC ID: 896001
| Seq. Order: | 11 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The day the trip ended on. |
| General Data Type: | VARCHAR2 |
TRIP_END_YEAR
CC ID: 896002
| Seq. Order: | 12 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The year the trip ended in. |
| General Data Type: | VARCHAR2 |
FISHING_LOCATION
CC ID: 896003
| Seq. Order: | 13 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 60 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Location where fishing occurred, if written in. |
| General Data Type: | VARCHAR2 |
TAG_NUMBER_1
CC ID: 896004
| Seq. Order: | 14 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Tag number. |
| General Data Type: | VARCHAR2 |
FORK_LENGTH_INCHES
CC ID: 896005
| Seq. Order: | 15 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Fork length in inches. Units for values are inches. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | inches |
FORK_LENGTH_CENTIMETERS
CC ID: 896006
| Seq. Order: | 16 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Fork length in centimeters. Units for values are centimeters. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | centimeters |
PURGE
CC ID: 896007
| Seq. Order: | 17 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Was a tool used to treat barotrauma (Y=yes, Blank=no). |
| General Data Type: | VARCHAR2 |
DROP_SHOT
CC ID: 896008
| Seq. Order: | 18 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Was a weighted recompression device used to treat baratrauma (Y=yes, Blank=no). |
| General Data Type: | VARCHAR2 |
RECAPTURED
CC ID: 896009
| Seq. Order: | 19 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Was the fish a recapture (Y=yes, Blank=no). |
| General Data Type: | VARCHAR2 |
RECAPTURED_AND_RELEASED
CC ID: 896010
| Seq. Order: | 20 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
If the fish was a recapture, was it released (Y=yes, Blank=no). |
| General Data Type: | VARCHAR2 |
TAG_NUMBER_2
CC ID: 896011
| Seq. Order: | 21 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Additional tag number. |
| General Data Type: | VARCHAR2 |
SPECIES
CC ID: 896012
| Seq. Order: | 22 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 15 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Species of fish caught. |
| General Data Type: | VARCHAR2 |
DATE_CAPTURED_MONTH
CC ID: 896013
| Seq. Order: | 23 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Month fish was caught. |
| General Data Type: | VARCHAR2 |
DATE_CAPTURED_DAY
CC ID: 896014
| Seq. Order: | 24 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Day fish was caught. |
| General Data Type: | VARCHAR2 |
DATE_CAPTURED_YEAR
CC ID: 896015
| Seq. Order: | 25 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Year fish was caught. |
| General Data Type: | VARCHAR2 |
LATITUDE_DEGREES
CC ID: 896016
| Seq. Order: | 26 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Degrees latitutde where fish was caught. Units for values are degrees. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | degrees |
LATITUDE_MINUTES
CC ID: 896017
| Seq. Order: | 27 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Minutes latitutde where fish was caught. Units for values are minutes. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | minutes |
LATITUDE_DIRECTION
CC ID: 896018
| Seq. Order: | 28 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Latitude direction (N/S) where fish was caught. |
| General Data Type: | VARCHAR2 |
LONGITUDE_DEGREES
CC ID: 896019
| Seq. Order: | 29 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Degrees longitude where fish was caught. Units for values are degrees. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | degrees |
LONGITUDE_MINUTES
CC ID: 896020
| Seq. Order: | 30 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Minutes longitude where fish was caught. Units for values are minutes. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | minutes |
LONGITUDE_DIRECTION
CC ID: 896021
| Seq. Order: | 31 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Longitude direction (E/W) where fish was caught. |
| General Data Type: | VARCHAR2 |
STATE_CHART_AREA_CODE
CC ID: 896022
| Seq. Order: | 32 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
State of Hawaii area code, if in Hawaii. |
| General Data Type: | VARCHAR2 |
DEPTH_FATHOMS
CC ID: 896023
| Seq. Order: | 33 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 5 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Depth in fathoms where fish was caught. Units for values are fathoms. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | fathoms |
DEPTH_METERS
CC ID: 896024
| Seq. Order: | 34 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 5 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Depth in meters where fish was caught. Units for values are meters. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | meters |
NOTES_LINE_1
CC ID: 896025
| Seq. Order: | 35 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 80 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
First line of comments from fisher. |
| General Data Type: | VARCHAR2 |
NOTES_LINE_2
CC ID: 896026
| Seq. Order: | 36 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 80 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Second line of comments from fisher. |
| General Data Type: | VARCHAR2 |
NOTES_LINE_3
CC ID: 896027
| Seq. Order: | 37 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 80 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Third line of comments from fisher. |
| General Data Type: | VARCHAR2 |
JOB_NUMBER
CC ID: 896028
| Seq. Order: | 38 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D12045. |
| General Data Type: | VARCHAR2 |
FROM_FILE
CC ID: 896029
| Seq. Order: | 39 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Name of the flat ASCII file that was the source of the data. |
| General Data Type: | VARCHAR2 |
DATE_LOADED
CC ID: 896030
| Seq. Order: | 40 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Date when the record was loaded into Oracle or updated. |
| General Data Type: | DATE |
TAGGER
CC ID: 896031
| Seq. Order: | 41 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Name of individual tagging the fish. |
| General Data Type: | VARCHAR2 |
Catalog Details
| Catalog Item ID: | 58731 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:58731 |
| Metadata Record Created By: | Brian J Langseth |
| Metadata Record Created: | 2020-01-30 16:35+0000 |
| Metadata Record Last Modified By: | SysAdmin InPortAdmin |
| Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
| Metadata Record Published: | 2020-01-30 |
| Owner Org: | PIFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2020-01-30 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2021-01-30 |