Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Data Management Systems (DMS) > Vessel Electronic Reporting System (VERS) >

Table: FVTR_TRIP_STATUS_CODES

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

Summary

Abstract

Table lists the options used to codify the status of electronically reported trip data after loading and processing

Description

Table lists the options used to codify the status of electronically reported trip data after loading and processing

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TRIP_STATUS
VARCHAR2 		Trip status code
TRIP_STATUS_DESCR
VARCHAR2 		Trip status code description
STATUS_RANK
NUMBER 		Hierarchical ranking of TRIP_STATUS codes used to identify the current status of a specific trip

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

Table lists the options used to codify the status of electronically reported trip data after loading and processing
Notes:

Loaded by batch 9190, 08-11-2016 16:37

Entity Information

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

Table lists the options used to codify the status of electronically reported trip data after loading and processing

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key TRIP_STATUS VARCHAR2 Trip status code
100
 TRIP_STATUS_DESCR VARCHAR2 Trip status code description
100
 STATUS_RANK NUMBER Hierarchical ranking of TRIP_STATUS codes used to identify the current status of a specific trip

Attribute Details

TRIP_STATUS

CC ID: 344230
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: Yes
Status: Active
Description:

Trip status code
General Data Type: VARCHAR2

TRIP_STATUS_DESCR

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

Trip status code description
General Data Type: VARCHAR2

STATUS_RANK

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

Hierarchical ranking of TRIP_STATUS codes used to identify the current status of a specific trip
General Data Type: NUMBER

Catalog Details

Catalog Item ID: 34271
GUID: gov.noaa.nmfs.inport:34271
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-08-11 16:37+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-08-23
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-08-23
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-08-23