Search Help Show/Hide Menu
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