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_EDITING_LIST

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

Summary

Abstract

Communicates effort editing issues among users of the SF GTE application

Description

Communicates effort editing issues among users of the SF GTE application

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
EFFORT_STATUS
VARCHAR2 		Event codes used to track effort status in edtiing process
DATA_ISSUE
VARCHAR2 		Data quality issue(s) that exist for a specific effort
DATA_ACTION
VARCHAR2 		Action needed/taken to resolve the issue
RESOLVED
NUMBER 		Denotes whether or not the documented issue has been resolved; Yes=1 No=0
USER_ISSUE
VARCHAR2 		The ID of the user who documented the issue; supporting table NERS.SF_USERS
USER_ACTION
VARCHAR2 		The ID of the USER who recognized/resolved issue; 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_EDITING_LIST
Short Name: GTE_EDITING_LIST
Status: Completed
Abstract:

Communicates effort editing issues among users of the SF GTE application
Notes:

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

Entity Information

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

Communicates effort editing issues among users of the SF GTE application

Data Attributes

Attribute Summary

Rubric Score Primary Key? 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
 EFFORT_STATUS VARCHAR2 Event codes used to track effort status in edtiing process
100
 DATA_ISSUE VARCHAR2 Data quality issue(s) that exist for a specific effort
100
 DATA_ACTION VARCHAR2 Action needed/taken to resolve the issue
100
 RESOLVED NUMBER Denotes whether or not the documented issue has been resolved; Yes=1 No=0
100
 USER_ISSUE VARCHAR2 The ID of the user who documented the issue; supporting table NERS.SF_USERS
100
 USER_ACTION VARCHAR2 The ID of the USER who recognized/resolved issue; supporting table NERS.SF_USERS

Attribute Details

TRIP_ID

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

EFFORT_NUM

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

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

EFFORT_STATUS

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

Event codes used to track effort status in edtiing process
General Data Type: VARCHAR2

DATA_ISSUE

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

Data quality issue(s) that exist for a specific effort
General Data Type: VARCHAR2

DATA_ACTION

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

Action needed/taken to resolve the issue
General Data Type: VARCHAR2

RESOLVED

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

Denotes whether or not the documented issue has been resolved; Yes=1 No=0
General Data Type: NUMBER

USER_ISSUE

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

The ID of the user who documented the issue; supporting table NERS.SF_USERS
General Data Type: VARCHAR2

USER_ACTION

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

The ID of the USER who recognized/resolved issue; supporting table NERS.SF_USERS
General Data Type: VARCHAR2

Catalog Details

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