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

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: 347803
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: 347804
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: 347805
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: 347806
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: 347807
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: 347808
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: 347809
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: 347810
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: 34571
GUID: gov.noaa.nmfs.inport:34571
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