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

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: 347811
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: 347822
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: 347829
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: 347830
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: 347831
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: 347832
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: 347833
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: 347834
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: 347835
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: 347812
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: 347813
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: 347814
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: 347815
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: 347816
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: 347817
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: 347818
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: 347819
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: 347820
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: 347821
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: 347823
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: 347824
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: 347825
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: 347826
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: 347827
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: 347828
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: 34572
GUID: gov.noaa.nmfs.inport:34572
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