Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Northeast Cooperative Research Program (NCRP) > Northeast Electronic Reporting System (NERS) >

Table: GTE_JOIN_AUDIT

Entity (ENT) | Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:34574 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

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 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

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

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (NEFSC) for inquiries on this record.

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 9249, 09-01-2016 13:11

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

Attribute Summary

	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

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

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: 347849

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: 347860

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: 347861

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: 347862

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: 347863

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: 347864

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: 347865

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: 347866

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: 347867

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: 347850

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: 347851

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: 347852

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: 347853

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: 347854

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: 347855

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: 347856

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: 347857

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: 347858

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: 347859

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

Table: GTE_JOIN_AUDIT

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

TRIP_ID

VP_NUM

PROBE_LOG_ID

EFFORT_NUM

EFFORT_NUM_CORRECTION

TD_DATETIME

TEMP

GEAR_DEPTH

GPS_DATETIME

LATITUDE

LONGITUDE

SPEED_KNOTS

COURSE_TRUE

BOT_DEPTH_M

RATE_OF_CHANGE

LEAD_RATE

RN

EFFORT_TYPE

TOW_EVENT_CODE

Catalog Details