Slide Menu
Search Help Show/Hide Menu

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: Lee M Weinberger
Metadata Record Last Modified: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-05-07