Slide Menu
Search Help Show/Hide Menu

Item Identification

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

This table links the weather code in the NORPAC.FOREIGN_HAUL table with a description of the code.

Notes:

Loaded by batch 2364, 06-29-2009 18:15

Entity Information

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

This table links the weather code in the NORPAC.FOREIGN_HAUL table with a description of the code.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key WEATHER NUMBER A one-digit numeric weather code (0 - 9).
100
WEATHER_DEFINITION VARCHAR2 A description associated with the weather code.

Attribute Details

WEATHER

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

A one-digit numeric weather code (0 - 9).

General Data Type: NUMBER

WEATHER_DEFINITION

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

A description associated with the weather code.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 9595
GUID: gov.noaa.nmfs.inport:9595
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2009-06-29 18:15+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-18
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-18
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-18