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_LOAD_HISTORY

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

Summary

Abstract

Tracks a trip/effort through the data editing process, providing data quality information at each step

Description

Tracks a trip/effort through the data editing process, providing data quality information at each step

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
POPULATE_TABLE_CODE
VARCHAR2 		Code identifying results from GTE join procedure; supporting table NERS.GTE_CODES
POPULATE_TABLE_DATE
DATE 		Date the GTE join procedure was run
POPULATE_TABLE_USER
VARCHAR2 		Staff member that ran the GTE join procedure; supporting table NERS.SF_USERS
EFFORT_CORR_CODE
VARCHAR2 		Code(s) used to describe data quality issues; supporting table NERS.GTE_CODES
EFFORT_CORR_DATE
DATE 		Date of latest change to record.
EFFORT_CORR_USER
VARCHAR2 		Staff member that performed the editing; supporting table NERS.SF_USERS
USE_CODE
VARCHAR2 		Code used to describe the appropriate analytical usage based on the quality of the data; supporting table NERS.GTE_CODES
DATA_MOVED
VARCHAR2 		A yes (Y) or no (N) field stating whether or not editing was completed and data moved to the final NERS.GTE_JOIN table
MOVE_DATE
DATE 		Date the finalized data was moved
MOVE_USER
VARCHAR2 		Staff member that moved the data; supporting table NERS.SF_USERS
COMMENTS
VARCHAR2 		Additional information
EFFORT_SUMMARY
VARCHAR2 		States whether or not summary statistics were generated for the effort in NERS.GTE_EFFORTS; Yes (Y) or no (N)
SUMMARY_DATE
DATE 		Date the effort summary procedure was performed
SUMMARY_USER
VARCHAR2 		Staff member that ran the effort summary procedure; supporting table NERS.SF_USERS

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_LOAD_HISTORY
Short Name: GTE_LOAD_HISTORY
Status: Completed
Abstract:

Tracks a trip/effort through the data editing process, providing data quality information at each step
Notes:

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

Entity Information

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

Tracks a trip/effort through the data editing process, providing data quality information at each step

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
 POPULATE_TABLE_CODE VARCHAR2 Code identifying results from GTE join procedure; supporting table NERS.GTE_CODES
100
 POPULATE_TABLE_DATE DATE Date the GTE join procedure was run
100
 POPULATE_TABLE_USER VARCHAR2 Staff member that ran the GTE join procedure; supporting table NERS.SF_USERS
100
 EFFORT_CORR_CODE VARCHAR2 Code(s) used to describe data quality issues; supporting table NERS.GTE_CODES
100
 EFFORT_CORR_DATE DATE Date of latest change to record.
100
 EFFORT_CORR_USER VARCHAR2 Staff member that performed the editing; supporting table NERS.SF_USERS
100
 USE_CODE VARCHAR2 Code used to describe the appropriate analytical usage based on the quality of the data; supporting table NERS.GTE_CODES
100
 DATA_MOVED VARCHAR2 A yes (Y) or no (N) field stating whether or not editing was completed and data moved to the final NERS.GTE_JOIN table
100
 MOVE_DATE DATE Date the finalized data was moved
100
 MOVE_USER VARCHAR2 Staff member that moved the data; supporting table NERS.SF_USERS
100
 COMMENTS VARCHAR2 Additional information
100
 EFFORT_SUMMARY VARCHAR2 States whether or not summary statistics were generated for the effort in NERS.GTE_EFFORTS; Yes (Y) or no (N)
100
 SUMMARY_DATE DATE Date the effort summary procedure was performed
100
 SUMMARY_USER VARCHAR2 Staff member that ran the effort summary procedure; supporting table NERS.SF_USERS

Attribute Details

TRIP_ID

CC ID: 348403
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 14
Scale: 0
Status: Active
Description:

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

EFFORT_NUM

CC ID: 348411
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

POPULATE_TABLE_CODE

CC ID: 348401
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 15
Required: Yes
Primary Key: No
Status: Active
Description:

Code identifying results from GTE join procedure; supporting table NERS.GTE_CODES
General Data Type: VARCHAR2
Foreign Key Relations:

NERS.GTE_CODES

POPULATE_TABLE_DATE

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

Date the GTE join procedure was run
General Data Type: DATE

POPULATE_TABLE_USER

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

Staff member that ran the GTE join procedure; supporting table NERS.SF_USERS
General Data Type: VARCHAR2

EFFORT_CORR_CODE

CC ID: 348414
Seq. Order: 6
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

EFFORT_CORR_DATE

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

Date of latest change to record.
General Data Type: DATE

EFFORT_CORR_USER

CC ID: 348416
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Staff member that performed the editing; supporting table NERS.SF_USERS
General Data Type: VARCHAR2

USE_CODE

CC ID: 348402
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Code used to describe the appropriate analytical usage based on the quality of the data; supporting table NERS.GTE_CODES
General Data Type: VARCHAR2
Foreign Key Relations:

NERS.GTE_CODES

DATA_MOVED

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

A yes (Y) or no (N) field stating whether or not editing was completed and data moved to the final NERS.GTE_JOIN table
General Data Type: VARCHAR2

MOVE_DATE

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

Date the finalized data was moved
General Data Type: DATE

MOVE_USER

CC ID: 348406
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Staff member that moved the data; supporting table NERS.SF_USERS
General Data Type: VARCHAR2

COMMENTS

CC ID: 348407
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Additional information
General Data Type: VARCHAR2

EFFORT_SUMMARY

CC ID: 348408
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

States whether or not summary statistics were generated for the effort in NERS.GTE_EFFORTS; Yes (Y) or no (N)
General Data Type: VARCHAR2

SUMMARY_DATE

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

Date the effort summary procedure was performed
General Data Type: DATE

SUMMARY_USER

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

Staff member that ran the effort summary procedure; supporting table NERS.SF_USERS
General Data Type: VARCHAR2

Catalog Details

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