Search Help Show/Hide Menu
Metadata Rubric
97%
5.83 / 6
View Report
SEFSC Metadata Library > Fisheries Statistics Division > FISHERIES MONITORING > Commercial Catch and Effort > Commercial Landings Project > Commercial Fisheries Landings for U.S. Caribbea... > U.S. Virgin Islands Commercial Landings Statist... >

Table: USVI_PRICE_LOOKUP

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

Summary

Abstract

This table assigns prices to USVI data where price is missing based on a weighted average price from the data set for like species

Description

This table assigns prices to USVI data where price is missing based on a weighted average price from the data set for like species

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ISLAND
VARCHAR2 		St. Croix, St, John, St. Thomas, St. Thomas/St. John
YEARLAND
VARCHAR2
MONTHLAND
VARCHAR2 		Month catch were landed.
NMFS_CODE
VARCHAR2 		NMFS species code
COMMON_NAME
VARCHAR2 		NMFS Common name for species landed
WEIGHTED_AVG
NUMBER 		weighted average price of sum(value)/sum(pounds)

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

Item Identification

Title: Table: USVI_PRICE_LOOKUP
Short Name: USVI_PRICE_LOOKUP
Status: Completed
Abstract:

This table assigns prices to USVI data where price is missing based on a weighted average price from the data set for like species
Notes:

Loaded by batch 7906, 12-22-2015 14:11

Entity Information

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

This table assigns prices to USVI data where price is missing based on a weighted average price from the data set for like species

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 ISLAND VARCHAR2 St. Croix, St, John, St. Thomas, St. Thomas/St. John
67
 YEARLAND VARCHAR2
100
 MONTHLAND VARCHAR2 Month catch were landed.
100
 NMFS_CODE VARCHAR2 NMFS species code
100
 COMMON_NAME VARCHAR2 NMFS Common name for species landed
100
 WEIGHTED_AVG NUMBER weighted average price of sum(value)/sum(pounds)

Attribute Details

ISLAND

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

St. Croix, St, John, St. Thomas, St. Thomas/St. John
General Data Type: VARCHAR2

YEARLAND

CC ID: 267334
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

MONTHLAND

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

Month catch were landed.
General Data Type: VARCHAR2

NMFS_CODE

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

NMFS species code
General Data Type: VARCHAR2

COMMON_NAME

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

NMFS Common name for species landed
General Data Type: VARCHAR2

WEIGHTED_AVG

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

weighted average price of sum(value)/sum(pounds)
General Data Type: NUMBER

Catalog Details

Catalog Item ID: 29958
GUID: gov.noaa.nmfs.inport:29958
Metadata Record Created By: Joshua Bennett
Metadata Record Created: 2015-12-22 14:11+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-06
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-06