Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Northeast Cooperative Research Program (NCRP) > Northeast Electronic Reporting System (NERS) >

Table: SF_BIOSAMP_TRIP_TYPES

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

Summary

Abstract

Types of trip samples are collected on

Description

Types of trip samples are collected on

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TRIP_TYPE_CODE
NUMBER 		Unique trip type identifier
TRIP_TYPE
VARCHAR2 		Trip type name
TRIP_TYPE_DESCR
VARCHAR2 		Type of trip sample collected on
TRIP_TYPE_SHORT
VARCHAR2 		Trip type short description

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

Types of trip samples are collected on
Notes:

Loaded by batch 9249, 09-01-2016 13:11

Entity Information

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

Types of trip samples are collected on

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key TRIP_TYPE_CODE NUMBER Unique trip type identifier
100
 TRIP_TYPE VARCHAR2 Trip type name
100
 TRIP_TYPE_DESCR VARCHAR2 Type of trip sample collected on
100
 TRIP_TYPE_SHORT VARCHAR2 Trip type short description

Attribute Details

TRIP_TYPE_CODE

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

Unique trip type identifier
General Data Type: NUMBER

TRIP_TYPE

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

Trip type name
General Data Type: VARCHAR2

TRIP_TYPE_DESCR

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

Type of trip sample collected on
General Data Type: VARCHAR2

TRIP_TYPE_SHORT

CC ID: 348022
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 10
Required: Yes
Primary Key: No
Status: Active
Description:

Trip type short description
General Data Type: VARCHAR2

Catalog Details

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