Table: GTE_JOIN
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34627 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Data from sucessfully joined and edited efforts
DescriptionData from sucessfully joined and edited efforts
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
TRIP_ID
NUMBER |
Unique trip identifier generated in FLDRS software |
VP_NUM
NUMBER |
Federal vessel permit number |
PROBE_LOG_ID
NUMBER |
Deployment identification number for TD logger used; supporting table NERS.SF_EQUIP_LOG |
EFFORT_NUM
VARCHAR2 |
Unique identifier representing an effort documented in a trip based data corrected in GTE processing |
TD_DATETIME
DATE |
Date and time in Greenwich Mean Time from a single TD probe reading |
TEMP
NUMBER |
Temperature (Celisus) from a single TD probe reading |
GEAR_DEPTH
NUMBER |
Gear depth (meters) from a single TD probe reading |
GPS_DATETIME
DATE |
Date and time in Greenwich Mean Time from a single GPS reading |
LATITUDE
NUMBER |
Latitude value from a single GPS reading |
LONGITUDE
NUMBER |
Longitude value from a single GPS reading |
COURSE_TRUE
NUMBER |
Heading (degrees) from a single GPS reading |
BOT_DEPTH_M
NUMBER |
Depth sounder reading (meters) |
TOW_EVENT_CODE
VARCHAR2 |
Code(s) used to describe data quality issues; supporting table NERS.GTE_CODES |
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: GTE_JOIN |
---|---|
Short Name: | GTE_JOIN |
Status: | Completed |
Abstract: |
Data from sucessfully joined and edited efforts |
Notes: |
Loaded by batch 9251, 09-01-2016 15:48 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | NERS |
Description: |
Data from sucessfully joined and edited efforts |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
TRIP_ID | NUMBER | Unique trip identifier generated in FLDRS software | |
100
|
VP_NUM | NUMBER | Federal vessel permit number | |
100
|
PROBE_LOG_ID | NUMBER | Deployment identification number for TD logger used; supporting table NERS.SF_EQUIP_LOG | |
100
|
EFFORT_NUM | VARCHAR2 | Unique identifier representing an effort documented in a trip based data corrected in GTE processing | |
100
|
TD_DATETIME | DATE | Date and time in Greenwich Mean Time from a single TD probe reading | |
100
|
TEMP | NUMBER | Temperature (Celisus) from a single TD probe reading | |
100
|
GEAR_DEPTH | NUMBER | Gear depth (meters) from a single TD probe reading | |
100
|
GPS_DATETIME | DATE | Date and time in Greenwich Mean Time from a single GPS reading | |
100
|
LATITUDE | NUMBER | Latitude value from a single GPS reading | |
100
|
LONGITUDE | NUMBER | Longitude value from a single GPS reading | |
100
|
COURSE_TRUE | NUMBER | Heading (degrees) from a single GPS reading | |
100
|
BOT_DEPTH_M | NUMBER | Depth sounder reading (meters) | |
100
|
TOW_EVENT_CODE | VARCHAR2 | Code(s) used to describe data quality issues; supporting table NERS.GTE_CODES |
Attribute Details
TRIP_ID
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 14 |
Scale: | 0 |
Status: | Active |
Description: |
Unique trip identifier generated in FLDRS software |
General Data Type: | NUMBER |
VP_NUM
Seq. Order: | 2 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Federal vessel permit number |
General Data Type: | NUMBER |
PROBE_LOG_ID
Seq. Order: | 3 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 38 |
Status: | Active |
Description: |
Deployment identification number for TD logger used; supporting table NERS.SF_EQUIP_LOG |
General Data Type: | NUMBER |
EFFORT_NUM
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Unique identifier representing an effort documented in a trip based data corrected in GTE processing |
General Data Type: | VARCHAR2 |
TD_DATETIME
Seq. Order: | 5 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
Date and time in Greenwich Mean Time from a single TD probe reading |
General Data Type: | DATE |
TEMP
Seq. Order: | 6 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Temperature (Celisus) from a single TD probe reading |
General Data Type: | NUMBER |
GEAR_DEPTH
Seq. Order: | 7 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Gear depth (meters) from a single TD probe reading |
General Data Type: | NUMBER |
GPS_DATETIME
Seq. Order: | 8 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date and time in Greenwich Mean Time from a single GPS reading |
General Data Type: | DATE |
LATITUDE
Seq. Order: | 9 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 12 |
Scale: | 6 |
Status: | Active |
Description: |
Latitude value from a single GPS reading |
General Data Type: | NUMBER |
LONGITUDE
Seq. Order: | 10 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 12 |
Scale: | 6 |
Status: | Active |
Description: |
Longitude value from a single GPS reading |
General Data Type: | NUMBER |
COURSE_TRUE
Seq. Order: | 11 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 2 |
Status: | Active |
Description: |
Heading (degrees) from a single GPS reading |
General Data Type: | NUMBER |
BOT_DEPTH_M
Seq. Order: | 12 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 1 |
Status: | Active |
Description: |
Depth sounder reading (meters) |
General Data Type: | NUMBER |
TOW_EVENT_CODE
Seq. Order: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code(s) used to describe data quality issues; supporting table NERS.GTE_CODES |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 34627 |
---|---|
GUID: | gov.noaa.nmfs.inport:34627 |
Metadata Record Created By: | Patricia L Jones |
Metadata Record Created: | 2016-09-01 15:48+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2016-09-01 |
Owner Org: | NEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2016-09-01 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2017-09-01 |