Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Output from the GTE join procedure. Data quality analysis then performed on data through the GTE GUI

Description

Output from the GTE join procedure. Data quality analysis then performed on data through the GTE GUI

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
EFFORT_NUM_CORRECTION
VARCHAR2
Documents the adjusted start and end times for an effort
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
SPEED_KNOTS
NUMBER
Speed of the vessel from a single GPS reading
COURSE_TRUE
NUMBER
Heading (degrees) from a single GPS reading
BOT_DEPTH_M
NUMBER
Depth sounder reading (meters)
RATE_OF_CHANGE
NUMBER
Calculates rate of changes in gear depth to identify the possible start or end of an effort
LEAD_RATE
NUMBER
Calculates rate of changes in gear depth to identify the possible start or end of an effort
RN
NUMBER
A SQL generated row number for the joined data
EFFORT_TYPE
VARCHAR2
Identifies possible start or end effort events based on the values in the RATE_OF_CHANGE and LEAD_RATE columns
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_AUDIT
Short Name: GTE_JOIN_AUDIT
Status: Completed
Abstract:

Output from the GTE join procedure. Data quality analysis then performed on data through the GTE GUI

Notes:

Loaded by batch 9251, 09-01-2016 15:48

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NERS
Description:

Output from the GTE join procedure. Data quality analysis then performed on data through the GTE GUI

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
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
100
EFFORT_NUM_CORRECTION VARCHAR2 Documents the adjusted start and end times for an effort
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
SPEED_KNOTS NUMBER Speed of the vessel 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
RATE_OF_CHANGE NUMBER Calculates rate of changes in gear depth to identify the possible start or end of an effort
100
LEAD_RATE NUMBER Calculates rate of changes in gear depth to identify the possible start or end of an effort
100
RN NUMBER A SQL generated row number for the joined data
100
EFFORT_TYPE VARCHAR2 Identifies possible start or end effort events based on the values in the RATE_OF_CHANGE and LEAD_RATE columns
100
TOW_EVENT_CODE VARCHAR2 Code(s) used to describe data quality issues; supporting table NERS.GTE_CODES

Attribute Details

TRIP_ID

CC ID: 348382
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: 348393
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: 348394
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
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: 348395
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Unique identifier representing an effort documented in a trip

General Data Type: VARCHAR2

EFFORT_NUM_CORRECTION

CC ID: 348396
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Documents the adjusted start and end times for an effort

General Data Type: VARCHAR2

TD_DATETIME

CC ID: 348397
Seq. Order: 6
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Date and time in Greenwich Mean Time from a single TD probe reading

General Data Type: DATE

TEMP

CC ID: 348398
Seq. Order: 7
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: 348399
Seq. Order: 8
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: 348400
Seq. Order: 9
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: 348383
Seq. Order: 10
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: 348384
Seq. Order: 11
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

SPEED_KNOTS

CC ID: 348385
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Speed of the vessel from a single GPS reading

General Data Type: NUMBER

COURSE_TRUE

CC ID: 348386
Seq. Order: 13
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: 348387
Seq. Order: 14
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

RATE_OF_CHANGE

CC ID: 348388
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Calculates rate of changes in gear depth to identify the possible start or end of an effort

General Data Type: NUMBER

LEAD_RATE

CC ID: 348389
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Calculates rate of changes in gear depth to identify the possible start or end of an effort

General Data Type: NUMBER

RN

CC ID: 348390
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

A SQL generated row number for the joined data

General Data Type: NUMBER

EFFORT_TYPE

CC ID: 348391
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Identifies possible start or end effort events based on the values in the RATE_OF_CHANGE and LEAD_RATE columns

General Data Type: VARCHAR2

TOW_EVENT_CODE

CC ID: 348392
Seq. Order: 19
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: 34628
GUID: gov.noaa.nmfs.inport:34628
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