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_EFFORTS

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

Summary

Abstract

Summary statistics for each complete effort contained in NERS.GTE_JOIN

Description

Summary statistics for each complete effort contained in NERS.GTE_JOIN

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TRIP_ID
NUMBER 		Unique trip identifier generated in FLDRS software
EFFORT_NUM
VARCHAR2 		Unique identifier representing an effort documented in a trip
TOTAL_NUM_RECORDS
NUMBER 		Total number of records for an effort
PERCENT_RECORDS_MATCH
NUMBER 		Percentage of the total number of records where there is a valid TD-GPS match
START_HAUL_DATE_GMT
DATE 		Date and time in Greenwich Mean Time of the start of the effort based data corrected in GTE processing
END_HAUL_DATE_GMT
DATE 		Date and time in Greenwich Mean Time of the end of the effort based data corrected in GTE processing
CALC_DUR_HR
NUMBER 		Duration of the effort in hours
CALC_DIST_NM
NUMBER 		Total distance towed in nautical miles
MIN_TEMP_C
NUMBER 		Min temperature in Celsius
MEAN_TEMP_C
NUMBER 		Mean temperature in Celsius
MAX_TEMP_C
NUMBER 		Max temperature in Celsius
TEMP_VARIANCE
NUMBER 		Temperature variance value
TEMP_DEVIATION
NUMBER 		Standard deviation of temperature
MIN_DPTH_M
NUMBER 		Min depth in meters
MEAN_DPTH_M
NUMBER 		Mean depth in meters
MAX_DPTH_M
NUMBER 		Max depth in meters
DPTH_VARIANCE
NUMBER 		Depth variance value
DPTH_DEVIATION
NUMBER 		Standard deviation of depth
MIN_SPD_NMPH
NUMBER 		Min vessel speed in nautical miles per hour
MEAN_SPD_NMPH
NUMBER 		Mean vessel speed in nautical miles per hour
MAX_SPD_NMPH
NUMBER 		Max vessel speed in nautical miles per hour
SPD_VARIANCE
NUMBER 		Speed variance value
SPD_DEVIATION
NUMBER 		Standard deviation of speed
GTE_CODE
VARCHAR2 		GTE codes for the effort; supporting table NERS.GTE_CODES
GEAR_CODE
VARCHAR2 		ACCSP Gear type code; supporting table FVTR.FVTR_GEAR_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_EFFORTS
Short Name: GTE_EFFORTS
Status: Completed
Abstract:

Summary statistics for each complete effort contained in NERS.GTE_JOIN
Notes:

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

Entity Information

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

Summary statistics for each complete effort contained in NERS.GTE_JOIN

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key TRIP_ID NUMBER Unique trip identifier generated in FLDRS software
100
 Primary Key EFFORT_NUM VARCHAR2 Unique identifier representing an effort documented in a trip
100
 TOTAL_NUM_RECORDS NUMBER Total number of records for an effort
100
 PERCENT_RECORDS_MATCH NUMBER Percentage of the total number of records where there is a valid TD-GPS match
100
 START_HAUL_DATE_GMT DATE Date and time in Greenwich Mean Time of the start of the effort based data corrected in GTE processing
100
 END_HAUL_DATE_GMT DATE Date and time in Greenwich Mean Time of the end of the effort based data corrected in GTE processing
100
 CALC_DUR_HR NUMBER Duration of the effort in hours
100
 CALC_DIST_NM NUMBER Total distance towed in nautical miles
100
 MIN_TEMP_C NUMBER Min temperature in Celsius
100
 MEAN_TEMP_C NUMBER Mean temperature in Celsius
100
 MAX_TEMP_C NUMBER Max temperature in Celsius
100
 TEMP_VARIANCE NUMBER Temperature variance value
100
 TEMP_DEVIATION NUMBER Standard deviation of temperature
100
 MIN_DPTH_M NUMBER Min depth in meters
100
 MEAN_DPTH_M NUMBER Mean depth in meters
100
 MAX_DPTH_M NUMBER Max depth in meters
100
 DPTH_VARIANCE NUMBER Depth variance value
100
 DPTH_DEVIATION NUMBER Standard deviation of depth
100
 MIN_SPD_NMPH NUMBER Min vessel speed in nautical miles per hour
100
 MEAN_SPD_NMPH NUMBER Mean vessel speed in nautical miles per hour
100
 MAX_SPD_NMPH NUMBER Max vessel speed in nautical miles per hour
100
 SPD_VARIANCE NUMBER Speed variance value
100
 SPD_DEVIATION NUMBER Standard deviation of speed
100
 GTE_CODE VARCHAR2 GTE codes for the effort; supporting table NERS.GTE_CODES
100
 GEAR_CODE VARCHAR2 ACCSP Gear type code; supporting table FVTR.FVTR_GEAR_CODES

Attribute Details

TRIP_ID

CC ID: 348344
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 38
Status: Active
Description:

Unique trip identifier generated in FLDRS software
General Data Type: NUMBER

EFFORT_NUM

CC ID: 348355
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 4
Required: Yes
Primary Key: Yes
Status: Active
Description:

Unique identifier representing an effort documented in a trip
General Data Type: VARCHAR2

TOTAL_NUM_RECORDS

CC ID: 348362
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Total number of records for an effort
General Data Type: NUMBER

PERCENT_RECORDS_MATCH

CC ID: 348363
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Percentage of the total number of records where there is a valid TD-GPS match
General Data Type: NUMBER

START_HAUL_DATE_GMT

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

Date and time in Greenwich Mean Time of the start of the effort based data corrected in GTE processing
General Data Type: DATE

END_HAUL_DATE_GMT

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

Date and time in Greenwich Mean Time of the end of the effort based data corrected in GTE processing
General Data Type: DATE

CALC_DUR_HR

CC ID: 348366
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 2
Status: Active
Description:

Duration of the effort in hours
General Data Type: NUMBER

CALC_DIST_NM

CC ID: 348367
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 2
Status: Active
Description:

Total distance towed in nautical miles
General Data Type: NUMBER

MIN_TEMP_C

CC ID: 348368
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 2
Status: Active
Description:

Min temperature in Celsius
General Data Type: NUMBER

MEAN_TEMP_C

CC ID: 348345
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 2
Status: Active
Description:

Mean temperature in Celsius
General Data Type: NUMBER

MAX_TEMP_C

CC ID: 348346
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 2
Status: Active
Description:

Max temperature in Celsius
General Data Type: NUMBER

TEMP_VARIANCE

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

Temperature variance value
General Data Type: NUMBER

TEMP_DEVIATION

CC ID: 348348
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 2
Status: Active
Description:

Standard deviation of temperature
General Data Type: NUMBER

MIN_DPTH_M

CC ID: 348349
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 2
Status: Active
Description:

Min depth in meters
General Data Type: NUMBER

MEAN_DPTH_M

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

Mean depth in meters
General Data Type: NUMBER

MAX_DPTH_M

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

Max depth in meters
General Data Type: NUMBER

DPTH_VARIANCE

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

Depth variance value
General Data Type: NUMBER

DPTH_DEVIATION

CC ID: 348353
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 2
Status: Active
Description:

Standard deviation of depth
General Data Type: NUMBER

MIN_SPD_NMPH

CC ID: 348354
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 2
Status: Active
Description:

Min vessel speed in nautical miles per hour
General Data Type: NUMBER

MEAN_SPD_NMPH

CC ID: 348356
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 2
Status: Active
Description:

Mean vessel speed in nautical miles per hour
General Data Type: NUMBER

MAX_SPD_NMPH

CC ID: 348357
Seq. Order: 21
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 2
Status: Active
Description:

Max vessel speed in nautical miles per hour
General Data Type: NUMBER

SPD_VARIANCE

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

Speed variance value
General Data Type: NUMBER

SPD_DEVIATION

CC ID: 348359
Seq. Order: 23
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 2
Status: Active
Description:

Standard deviation of speed
General Data Type: NUMBER

GTE_CODE

CC ID: 348360
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

GTE codes for the effort; supporting table NERS.GTE_CODES
General Data Type: VARCHAR2

GEAR_CODE

CC ID: 348361
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

ACCSP Gear type code; supporting table FVTR.FVTR_GEAR_CODES
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 34626
GUID: gov.noaa.nmfs.inport:34626
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