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_ACTIVITY_TYPES

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

Summary

Abstract

Table lists the codes used to explain trips where no fishing efforts were conducted; VERS_TRIP.TRIP_ACTIVITY_TYPE=0 for trips where at least one fishing effort occurred

Description

Table lists the codes used to explain trips where no fishing efforts were conducted; VERS_TRIP.TRIP_ACTIVITY_TYPE=0 for trips where at least one fishing effort occurred

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TRIP_ACTIVITY_TYPE
NUMBER 		Trip activity type code
TRIP_ACTIVITY_DESCR
VARCHAR2 		Trip activity type code description
DEFAULT_TYPE
NUMBER 		Default TRIP_ACTIVITY_TYPE, 1=yes, 0=no
BEGIN_DATE
DATE 		Date when the TRIP_ACTIVITY_TYPE code became available for use
END_DATE
DATE 		Date when the TRIP_ACTIVITY_TYPE code was discontinued

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

Table lists the codes used to explain trips where no fishing efforts were conducted; VERS_TRIP.TRIP_ACTIVITY_TYPE=0 for trips where at least one fishing effort occurred
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 codes used to explain trips where no fishing efforts were conducted; VERS_TRIP.TRIP_ACTIVITY_TYPE=0 for trips where at least one fishing effort occurred

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key TRIP_ACTIVITY_TYPE NUMBER Trip activity type code
100
 TRIP_ACTIVITY_DESCR VARCHAR2 Trip activity type code description
100
 DEFAULT_TYPE NUMBER Default TRIP_ACTIVITY_TYPE, 1=yes, 0=no
100
 BEGIN_DATE DATE Date when the TRIP_ACTIVITY_TYPE code became available for use
100
 END_DATE DATE Date when the TRIP_ACTIVITY_TYPE code was discontinued

Attribute Details

TRIP_ACTIVITY_TYPE

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

Trip activity type code
General Data Type: NUMBER

TRIP_ACTIVITY_DESCR

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

Trip activity type code description
General Data Type: VARCHAR2

DEFAULT_TYPE

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

Default TRIP_ACTIVITY_TYPE, 1=yes, 0=no
General Data Type: NUMBER

BEGIN_DATE

CC ID: 344221
Seq. Order: 4
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date when the TRIP_ACTIVITY_TYPE code became available for use
General Data Type: DATE

END_DATE

CC ID: 344222
Seq. Order: 5
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date when the TRIP_ACTIVITY_TYPE code was discontinued
General Data Type: DATE

Catalog Details

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