Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Status of the trip in the editing process. It also provides a means to document any comments that pertain to the entire trip

Description

Status of the trip in the editing process. It also provides a means to document any comments that pertain to the entire trip

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TRIP_ID
NUMBER
Unique trip identifier generated in FLDRS software
LOAD_STATUS
NUMBER
Current status of the trip in the editing process; supporting table NERS.GTE_CODES
COMMENTS
VARCHAR2
Trip level comments

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_TRIPS
Short Name: GTE_TRIPS
Status: Completed
Abstract:

Status of the trip in the editing process. It also provides a means to document any comments that pertain to the entire trip

Notes:

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

Entity Information

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

Status of the trip in the editing process. It also provides a means to document any comments that pertain to the entire trip

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
LOAD_STATUS NUMBER Current status of the trip in the editing process; supporting table NERS.GTE_CODES
100
COMMENTS VARCHAR2 Trip level comments

Attribute Details

TRIP_ID

CC ID: 348417
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 38
Status: Active
Description:

Unique trip identifier generated in FLDRS software

General Data Type: NUMBER

LOAD_STATUS

CC ID: 348418
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Current status of the trip in the editing process; supporting table NERS.GTE_CODES

General Data Type: NUMBER

COMMENTS

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

Trip level comments

General Data Type: VARCHAR2

Catalog Details

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