Search Help Show/Hide Menu
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 9249, 09-01-2016 13:11

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: 347836
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: 347841
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: 347842
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: 347843
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: 347844
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: 347845
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: 347846
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: 347847
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: 347848
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: 347837
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: 347838
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: 347839
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: 347840
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: 34573
GUID: gov.noaa.nmfs.inport:34573
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-09-01 13:11+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