Table: GMRI_COD_TRIP
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34411 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Information about each trip.
DescriptionInformation about each trip.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
TRIP_ID
NUMBER |
Unique ID |
VESSEL_ID
NUMBER |
Vessel used for trip – from COD_VESSEL LUT |
ORGANIZATION_ID
NUMBER |
Organization associated with trip – from COD_ORGANIZATION LUT |
GEAR_ID
NUMBER |
Type of gear used – from COD_GEAR LUT |
TAGGING_AREA_ID
NUMBER |
Location of trip – from COD_TAGGING_AREA LUT |
DEPTH_UNIT_ID
NUMBER |
Depth measuring units – from COD_UNIT LUT |
TEMP_UNIT_ID
NUMBER |
Temperature measuring units – from COD_UNIT LUT |
LOCATION_UNIT_ID
NUMBER |
Location coordinates type – from COD_UNIT LUT |
LOCATION_FORMAT_UNIT_ID
NUMBER |
When the coordinate type is lat/lon, this indicates whether values are written as degrees-minutes-seconds, or degrees-decimal minutes – from COD_UNIT LUT |
TRIP_NUMBER
NUMBER |
User assigned |
CAPTAIN
VARCHAR2 |
Names of vessel captain and crew (redacted) |
START_DATE
DATE |
Date trip began |
END_DATE
DATE |
Date trip ended |
LORAN_CHAIN
NUMBER |
LORAN chain number |
PENDING
NUMBER |
0= Trip information approved 1= Trip information pending admin approval |
REQUESTED_APPROVAL
NUMBER |
0= Not submitted for approval 1= Approval request submitted (this value stays even after approval, even if the trip is later unapproved) |
COUNT_TAGGED
NUMBER |
Number of fish tagged per trip |
COUNT_NONTAGGED
NUMBER |
Number of fish assigned a non-tag ID per trip (e.g. poor condition, undersized fish) |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (NEFSC) for inquiries on this record.
Item Identification
Title: | Table: GMRI_COD_TRIP |
---|---|
Short Name: | GMRI_COD_TRIP |
Status: | Completed |
Abstract: |
Information about each trip. |
Notes: |
Loaded by batch 9211, 08-23-2016 14:45 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | CO_OP_RESEARCH |
Description: |
Information about each trip. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
TRIP_ID | NUMBER | Unique ID | |
100
|
VESSEL_ID | NUMBER | Vessel used for trip – from COD_VESSEL LUT | |
100
|
ORGANIZATION_ID | NUMBER | Organization associated with trip – from COD_ORGANIZATION LUT | |
100
|
GEAR_ID | NUMBER | Type of gear used – from COD_GEAR LUT | |
100
|
TAGGING_AREA_ID | NUMBER | Location of trip – from COD_TAGGING_AREA LUT | |
100
|
DEPTH_UNIT_ID | NUMBER | Depth measuring units – from COD_UNIT LUT | |
100
|
TEMP_UNIT_ID | NUMBER | Temperature measuring units – from COD_UNIT LUT | |
100
|
LOCATION_UNIT_ID | NUMBER | Location coordinates type – from COD_UNIT LUT | |
100
|
LOCATION_FORMAT_UNIT_ID | NUMBER | When the coordinate type is lat/lon, this indicates whether values are written as degrees-minutes-seconds, or degrees-decimal minutes – from COD_UNIT LUT | |
100
|
TRIP_NUMBER | NUMBER | User assigned | |
100
|
CAPTAIN | VARCHAR2 | Names of vessel captain and crew (redacted) | |
100
|
START_DATE | DATE | Date trip began | |
100
|
END_DATE | DATE | Date trip ended | |
100
|
LORAN_CHAIN | NUMBER | LORAN chain number | |
100
|
PENDING | NUMBER | 0= Trip information approved 1= Trip information pending admin approval | |
100
|
REQUESTED_APPROVAL | NUMBER | 0= Not submitted for approval 1= Approval request submitted (this value stays even after approval, even if the trip is later unapproved) | |
100
|
COUNT_TAGGED | NUMBER | Number of fish tagged per trip | |
100
|
COUNT_NONTAGGED | NUMBER | Number of fish assigned a non-tag ID per trip (e.g. poor condition, undersized fish) |
Attribute Details
TRIP_ID
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 11 |
Scale: | 0 |
Status: | Active |
Description: |
Unique ID |
General Data Type: | NUMBER |
VESSEL_ID
Seq. Order: | 2 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 11 |
Scale: | 0 |
Status: | Active |
Description: |
Vessel used for trip – from COD_VESSEL LUT |
General Data Type: | NUMBER |
ORGANIZATION_ID
Seq. Order: | 3 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 11 |
Scale: | 0 |
Status: | Active |
Description: |
Organization associated with trip – from COD_ORGANIZATION LUT |
General Data Type: | NUMBER |
GEAR_ID
Seq. Order: | 4 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 11 |
Scale: | 0 |
Status: | Active |
Description: |
Type of gear used – from COD_GEAR LUT |
General Data Type: | NUMBER |
TAGGING_AREA_ID
Seq. Order: | 5 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 11 |
Scale: | 0 |
Status: | Active |
Description: |
Location of trip – from COD_TAGGING_AREA LUT |
General Data Type: | NUMBER |
DEPTH_UNIT_ID
Seq. Order: | 6 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 11 |
Scale: | 0 |
Status: | Active |
Description: |
Depth measuring units – from COD_UNIT LUT |
General Data Type: | NUMBER |
TEMP_UNIT_ID
Seq. Order: | 7 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 11 |
Scale: | 0 |
Status: | Active |
Description: |
Temperature measuring units – from COD_UNIT LUT |
General Data Type: | NUMBER |
LOCATION_UNIT_ID
Seq. Order: | 8 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 11 |
Scale: | 0 |
Status: | Active |
Description: |
Location coordinates type – from COD_UNIT LUT |
General Data Type: | NUMBER |
LOCATION_FORMAT_UNIT_ID
Seq. Order: | 9 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 11 |
Scale: | 0 |
Status: | Active |
Description: |
When the coordinate type is lat/lon, this indicates whether values are written as degrees-minutes-seconds, or degrees-decimal minutes – from COD_UNIT LUT |
General Data Type: | NUMBER |
TRIP_NUMBER
Seq. Order: | 10 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 11 |
Scale: | 0 |
Status: | Active |
Description: |
User assigned |
General Data Type: | NUMBER |
CAPTAIN
Seq. Order: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1020 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Names of vessel captain and crew (redacted) |
General Data Type: | VARCHAR2 |
START_DATE
Seq. Order: | 12 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Date trip began |
General Data Type: | DATE |
END_DATE
Seq. Order: | 13 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Date trip ended |
General Data Type: | DATE |
LORAN_CHAIN
Seq. Order: | 14 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 11 |
Scale: | 0 |
Status: | Active |
Description: |
LORAN chain number |
General Data Type: | NUMBER |
PENDING
Seq. Order: | 15 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
0= Trip information approved 1= Trip information pending admin approval |
General Data Type: | NUMBER |
REQUESTED_APPROVAL
Seq. Order: | 16 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
0= Not submitted for approval 1= Approval request submitted (this value stays even after approval, even if the trip is later unapproved) |
General Data Type: | NUMBER |
COUNT_TAGGED
Seq. Order: | 17 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 11 |
Scale: | 0 |
Status: | Active |
Description: |
Number of fish tagged per trip |
General Data Type: | NUMBER |
COUNT_NONTAGGED
Seq. Order: | 18 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 11 |
Scale: | 0 |
Status: | Active |
Description: |
Number of fish assigned a non-tag ID per trip (e.g. poor condition, undersized fish) |
General Data Type: | NUMBER |
Catalog Details
Catalog Item ID: | 34411 |
---|---|
GUID: | gov.noaa.nmfs.inport:34411 |
Metadata Record Created By: | Patricia L Jones |
Metadata Record Created: | 2016-08-23 14:45+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2017-02-24 |
Owner Org: | NEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2017-02-24 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2018-02-24 |