Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Northeast Cooperative Research Program (NCRP) > Northeast Cooperative Research Study Fleet (SF)... >

Table: GTE_JOIN

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:34627  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Data from sucessfully joined and edited efforts

Description

Data 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

Rubric Score Primary Key? Name Type Description
100
 TRIP_ID NUMBER Unique trip identifier generated in FLDRS software
100
 VP_NUM NUMBER Federal vessel permit number
100
 Primary Key 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
 Primary Key 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

CC ID: 348369
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

CC ID: 348374
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

CC ID: 348375
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

CC ID: 348376
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

CC ID: 348377
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

CC ID: 348378
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

CC ID: 348379
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

CC ID: 348380
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

CC ID: 348381
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

CC ID: 348370
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

CC ID: 348371
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

CC ID: 348372
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

CC ID: 348373
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