Metadata Rubric

100%

6 / 6

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

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

	Name	Type	Description
100	TRIP_ID	NUMBER	Unique trip identifier generated in FLDRS software
100	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

Name

Type

Description

100

TRIP_ID

NUMBER

Unique trip identifier generated in FLDRS software

100

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