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_SAMPLING_PROJECTS

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

Summary

Abstract

Prioritzes species for biosample collection projects

Description

Prioritzes species for biosample collection projects

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
PROJECT_TYP
VARCHAR2 		Identifies sampling project type; wholeSpec or advancedBio
PROJECT_TITLE
VARCHAR2 		Specifies a species/region combination for sampling
SPECIES_ITIS
VARCHAR2 		Integrated Taxonomic Information System Code; support table NERS.FVTR_SPECIES
REGION
VARCHAR2 		Area abbreviations
PRIORITY
NUMBER 		Priority of sampling
SAMPLING_QTY
NUMBER 		Number of individuals requested per sampling unit
SAMPLING_UNIT
VARCHAR2 		Frequency of sample collection

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

Prioritzes species for biosample collection projects
Notes:

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

Entity Information

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

Prioritzes species for biosample collection projects

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 PROJECT_TYP VARCHAR2 Identifies sampling project type; wholeSpec or advancedBio
100
 PROJECT_TITLE VARCHAR2 Specifies a species/region combination for sampling
100
 SPECIES_ITIS VARCHAR2 Integrated Taxonomic Information System Code; support table NERS.FVTR_SPECIES
100
 REGION VARCHAR2 Area abbreviations
100
 PRIORITY NUMBER Priority of sampling
100
 SAMPLING_QTY NUMBER Number of individuals requested per sampling unit
100
 SAMPLING_UNIT VARCHAR2 Frequency of sample collection

Attribute Details

PROJECT_TYP

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

Identifies sampling project type; wholeSpec or advancedBio
General Data Type: VARCHAR2

PROJECT_TITLE

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

Specifies a species/region combination for sampling
General Data Type: VARCHAR2

SPECIES_ITIS

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

Integrated Taxonomic Information System Code; support table NERS.FVTR_SPECIES
General Data Type: VARCHAR2

REGION

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

Area abbreviations
General Data Type: VARCHAR2

PRIORITY

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

Priority of sampling
General Data Type: NUMBER

SAMPLING_QTY

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

Number of individuals requested per sampling unit
General Data Type: NUMBER

SAMPLING_UNIT

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

Frequency of sample collection
General Data Type: VARCHAR2

Catalog Details

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