NMFS W. Pacific Daily Longline Fishing Log - Hawaii - LOGDETAIL
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:50942 | Updated: February 20, 2025 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Hawaii Longline Logbook Data
Description.
Entity Information
Entity Type
Data Table
| Data Attribute / Type | Description |
|---|---|
|
SEQUENCE_NUM
VARCHAR2 |
A consecutive number that is assigned to each record of a block of data. |
|
HDR_LANDYR
VARCHAR2 |
The landing year for this record (used in conjunction with hdr_tripnum and hdr_serialnum) to link this detail catch record with the proper header record in opdt.loghdr. A value is required. |
|
HDR_TRIPNUM
VARCHAR2 |
The trip number for this record (used in conjunction with hdr_landyr and hdr_serialnum) to link this detail catch record with the proper header record in opdt.loghdr. A value is required. |
|
HDR_SERIALNUM
VARCHAR2 |
The serial number for this record (used in conjunction with hdr_landyr and hdr_tripnum) to link this detail catch record with the proper header record in opdt.loghdr. A value is required. |
|
PROG#
VARCHAR2 |
The program number for the logbook program (1) as listed in the table opdt.programs. |
|
ENGLISH_NAME
VARCHAR2 |
The English name of the species as listed in the table opdt.organism_cross_references. |
|
SPECIES
VARCHAR2 |
Species code or protected species code (See reference table DSC.DSC_SPECIES_CROSSREF_NODC). A value is required. |
|
NUMFINNED
NUMBER |
Number of sharks that were Finned while fishing. |
|
NUMKEPT
NUMBER |
Number of a particular species that were Kept while fishing. |
|
NUMRELEASED
NUMBER |
Number of a particular species that were Released while fishing. |
|
NUMUNINJURED
NUMBER |
Number of protected species released alive and uninjured. |
|
NUMINJURED
NUMBER |
Number of protected species released injured. |
|
NUMDEAD
NUMBER |
Number of protected species released dead. |
|
NUMSIGHTED
NUMBER |
Number of protected species sighted in area of gear. |
|
ORIG_DATASET
VARCHAR2 |
The original dataset under which this record was entered. |
|
ORIG_VERSION
VARCHAR2 |
The original version of the dataset under which this record was entered. |
|
BATCHNUM
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., D14001. |
|
CATCH_CORR
VARCHAR2 |
Code signifying when in the editing process a correction was made to this species record. |
|
PSI_CORR
VARCHAR2 |
Code signifying when in the editing process a correction was made to this protected species record. |
|
NUMALIVE
NUMBER |
Legacy field - containing number released alive, replaced by more specific fields (see NUMUNINJURED). |
|
HDR_SERIALNUM2
VARCHAR2 |
It is the page number that is stamped on the logbook form or the number assigned by the electronic logbook program. |
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.
Item Identification
| Title: | NMFS W. Pacific Daily Longline Fishing Log - Hawaii - LOGDETAIL |
|---|---|
| Short Name: | OPDT_LOGDETAIL |
| Status: | Completed |
| Abstract: |
Hawaii Longline Logbook Data |
Entity Information
| Entity Type: | Data Table |
|---|---|
| Active Version?: | Yes |
| Description: |
. |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
SEQUENCE_NUM | VARCHAR2 | A consecutive number that is assigned to each record of a block of data. | |
|
100
|
HDR_LANDYR | VARCHAR2 | The landing year for this record (used in conjunction with hdr_tripnum and hdr_serialnum) to link this detail catch record with the proper header record in opdt.loghdr. A value is required. | |
|
100
|
HDR_TRIPNUM | VARCHAR2 | The trip number for this record (used in conjunction with hdr_landyr and hdr_serialnum) to link this detail catch record with the proper header record in opdt.loghdr. A value is required. | |
|
100
|
HDR_SERIALNUM | VARCHAR2 | The serial number for this record (used in conjunction with hdr_landyr and hdr_tripnum) to link this detail catch record with the proper header record in opdt.loghdr. A value is required. | |
|
100
|
PROG# | VARCHAR2 | The program number for the logbook program (1) as listed in the table opdt.programs. | |
|
100
|
ENGLISH_NAME | VARCHAR2 | The English name of the species as listed in the table opdt.organism_cross_references. | |
|
100
|
SPECIES | VARCHAR2 | Species code or protected species code (See reference table DSC.DSC_SPECIES_CROSSREF_NODC). A value is required. | |
|
100
|
NUMFINNED | NUMBER | Number of sharks that were Finned while fishing. | |
|
100
|
NUMKEPT | NUMBER | Number of a particular species that were Kept while fishing. | |
|
100
|
NUMRELEASED | NUMBER | Number of a particular species that were Released while fishing. | |
|
100
|
NUMUNINJURED | NUMBER | Number of protected species released alive and uninjured. | |
|
100
|
NUMINJURED | NUMBER | Number of protected species released injured. | |
|
100
|
NUMDEAD | NUMBER | Number of protected species released dead. | |
|
100
|
NUMSIGHTED | NUMBER | Number of protected species sighted in area of gear. | |
|
100
|
ORIG_DATASET | VARCHAR2 | The original dataset under which this record was entered. | |
|
100
|
ORIG_VERSION | VARCHAR2 | The original version of the dataset under which this record was entered. | |
|
100
|
BATCHNUM | 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., D14001. | |
|
100
|
CATCH_CORR | VARCHAR2 | Code signifying when in the editing process a correction was made to this species record. | |
|
100
|
PSI_CORR | VARCHAR2 | Code signifying when in the editing process a correction was made to this protected species record. | |
|
100
|
NUMALIVE | NUMBER | Legacy field - containing number released alive, replaced by more specific fields (see NUMUNINJURED). | |
|
100
|
HDR_SERIALNUM2 | VARCHAR2 | It is the page number that is stamped on the logbook form or the number assigned by the electronic logbook program. |
Attribute Details
SEQUENCE_NUM
| Seq. Order: | 1 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
A consecutive number that is assigned to each record of a block of data. |
| General Data Type: | VARCHAR2 |
HDR_LANDYR
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
The landing year for this record (used in conjunction with hdr_tripnum and hdr_serialnum) to link this detail catch record with the proper header record in opdt.loghdr. A value is required. |
| General Data Type: | VARCHAR2 |
HDR_TRIPNUM
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
The trip number for this record (used in conjunction with hdr_landyr and hdr_serialnum) to link this detail catch record with the proper header record in opdt.loghdr. A value is required. |
| General Data Type: | VARCHAR2 |
HDR_SERIALNUM
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 18 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
The serial number for this record (used in conjunction with hdr_landyr and hdr_tripnum) to link this detail catch record with the proper header record in opdt.loghdr. A value is required. |
| General Data Type: | VARCHAR2 |
PROG#
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The program number for the logbook program (1) as listed in the table opdt.programs. |
| General Data Type: | VARCHAR2 |
ENGLISH_NAME
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 70 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The English name of the species as listed in the table opdt.organism_cross_references. |
| General Data Type: | VARCHAR2 |
SPECIES
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Species code or protected species code (See reference table DSC.DSC_SPECIES_CROSSREF_NODC). A value is required. |
| General Data Type: | VARCHAR2 |
NUMFINNED
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of sharks that were Finned while fishing. |
| General Data Type: | NUMBER |
NUMKEPT
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of a particular species that were Kept while fishing. |
| General Data Type: | NUMBER |
NUMRELEASED
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of a particular species that were Released while fishing. |
| General Data Type: | NUMBER |
NUMUNINJURED
| Seq. Order: | 11 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of protected species released alive and uninjured. |
| General Data Type: | NUMBER |
NUMINJURED
| Seq. Order: | 12 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of protected species released injured. |
| General Data Type: | NUMBER |
NUMDEAD
| Seq. Order: | 13 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of protected species released dead. |
| General Data Type: | NUMBER |
NUMSIGHTED
| Seq. Order: | 14 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of protected species sighted in area of gear. |
| General Data Type: | NUMBER |
ORIG_DATASET
| Seq. Order: | 15 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 5 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The original dataset under which this record was entered. |
| General Data Type: | VARCHAR2 |
ORIG_VERSION
| Seq. Order: | 16 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The original version of the dataset under which this record was entered. |
| General Data Type: | VARCHAR2 |
BATCHNUM
| Seq. Order: | 17 |
|---|---|
| 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., D14001. |
| General Data Type: | VARCHAR2 |
CATCH_CORR
| Seq. Order: | 18 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code signifying when in the editing process a correction was made to this species record. |
| General Data Type: | VARCHAR2 |
PSI_CORR
| Seq. Order: | 19 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code signifying when in the editing process a correction was made to this protected species record. |
| General Data Type: | VARCHAR2 |
NUMALIVE
| Seq. Order: | 20 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Legacy field - containing number released alive, replaced by more specific fields (see NUMUNINJURED). |
| General Data Type: | NUMBER |
HDR_SERIALNUM2
| Seq. Order: | 21 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 18 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
It is the page number that is stamped on the logbook form or the number assigned by the electronic logbook program. |
| General Data Type: | VARCHAR2 |
Catalog Details
| Catalog Item ID: | 50942 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:50942 |
| Metadata Record Created By: | Brent M Miyamoto |
| Metadata Record Created: | 2017-12-29 16:19+0000 |
| Metadata Record Last Modified By: | Bradley M Gough |
| Metadata Record Last Modified: | 2025-02-20 00:44+0000 |
| Metadata Record Published: | 2025-02-20 |
| Owner Org: | PIFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Review Frequency: | 1 Year |