Table: GTE_EDITING_LIST
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34571 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Communicates effort editing issues among users of the SF GTE application
DescriptionCommunicates 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
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
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
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
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
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
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
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
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
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 |