Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Other: LANDING_MV
Short Name: LANDING_MV
Status: Completed
Abstract:

Materialized View Of Landings Table With Decode Of Codes

Notes:

Loaded by batch 2243, 12-05-2008 10:11

Entity Information

Entity Type: Other
Active Version?: Yes
Schema Name: TIPONLINE
Description:

Materialized View Of Landings Table With Decode Of Codes

Data Attributes

Note: Metadata requirements do not apply to attributes for non-tabular entities.

Attribute Summary

Rubric Score Primary Key? Name Type Description
N/A
LAND_INTERVIEW_ID NUMBER Foreign Key to Interview Table
N/A
LAND_ID NUMBER Key to Landings Table
N/A
LAND_GEAR_CODE VARCHAR2 Key to agency specific gear table on the landings record
N/A
LAND_GEAR_NAME VARCHAR2 Gear Name associated with agency specific gear code on the lnadings record
N/A
LAND_AREA NUMBER Key to agency specific area table telling the primary area where fishing occurred on the landings record
N/A
LAND_AREA_NAME VARCHAR2 Area Name associated with agency specific area table telling the primary area where fishing occurred on the landings record
N/A
LAND_SCIENTIFIC_NAME VARCHAR2 Scientific Name On Landings Record
N/A
LAND_SPECIES_CODE VARCHAR2 Species Code On Landings Record
N/A
LAND_AGENCY_SPC_NAME VARCHAR2 Agency Specific Name On Landings Record
N/A
LAND_SPECIES_SIZE VARCHAR2 Key to size (MIXED/UNSIZED, JUMBO, etc) on Landings Record
N/A
LAND_GRADE VARCHAR2 Grade on the Landings Record
N/A
LAND_SAMPLE_COUNT NUMBER Number Of Sample Records Associated ed with landings record
N/A
LAND_WEIGHT NUMBER Total weight on the Landings Record
N/A
LAND_WEIGHT_UNIT_CODE VARCHAR2 Weight unit code on the Landings Record
N/A
LAND_WEIGHT_UNIT VARCHAR2 Decode of Weight unit code on the Landings Record
N/A
LAND_WEIGHT_KG NUMBER Total weight in kilograms on the Landings Record
N/A
LAND_CONDITION VARCHAR2 Condition Of fish landed on the Landings Record
N/A
LAND_MARKET_CNT_MIN NUMBER Minimun number of individuals per unit for this category on the landings record
N/A
LAND_MARKET_CNT_MAX NUMBER Maximun number of individuals per unit for this category on the landings record
N/A
LAND_REGION VARCHAR2 Region (GULF, ATLANTIC, etc) on the Landings Record
N/A
LAND_REPLICATE NUMBER Part of key ON landings record to relate the data back to the historical data.
N/A
LANDING_COMMENT VARCHAR2 Comment on this landing record

Attribute Details

LAND_INTERVIEW_ID

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

Foreign Key to Interview Table

General Data Type: NUMBER

LAND_ID

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

Key to Landings Table

General Data Type: NUMBER

LAND_GEAR_CODE

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

Key to agency specific gear table on the landings record

General Data Type: VARCHAR2

LAND_GEAR_NAME

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

Gear Name associated with agency specific gear code on the lnadings record

General Data Type: VARCHAR2

LAND_AREA

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

Key to agency specific area table telling the primary area where fishing occurred on the landings record

General Data Type: NUMBER

LAND_AREA_NAME

CC ID: 33292
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Area Name associated with agency specific area table telling the primary area where fishing occurred on the landings record

General Data Type: VARCHAR2

LAND_SCIENTIFIC_NAME

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

Scientific Name On Landings Record

General Data Type: VARCHAR2

LAND_SPECIES_CODE

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

Species Code On Landings Record

General Data Type: VARCHAR2

LAND_AGENCY_SPC_NAME

CC ID: 33295
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Agency Specific Name On Landings Record

General Data Type: VARCHAR2

LAND_SPECIES_SIZE

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

Key to size (MIXED/UNSIZED, JUMBO, etc) on Landings Record

General Data Type: VARCHAR2

LAND_GRADE

CC ID: 33297
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Grade on the Landings Record

General Data Type: VARCHAR2

LAND_SAMPLE_COUNT

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

Number Of Sample Records Associated ed with landings record

General Data Type: NUMBER

LAND_WEIGHT

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

Total weight on the Landings Record

General Data Type: NUMBER

LAND_WEIGHT_UNIT_CODE

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

Weight unit code on the Landings Record

General Data Type: VARCHAR2

LAND_WEIGHT_UNIT

CC ID: 33301
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Decode of Weight unit code on the Landings Record

General Data Type: VARCHAR2

LAND_WEIGHT_KG

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

Total weight in kilograms on the Landings Record

General Data Type: NUMBER

LAND_CONDITION

CC ID: 33303
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Condition Of fish landed on the Landings Record

General Data Type: VARCHAR2

LAND_MARKET_CNT_MIN

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

Minimun number of individuals per unit for this category on the landings record

General Data Type: NUMBER

LAND_MARKET_CNT_MAX

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

Maximun number of individuals per unit for this category on the landings record

General Data Type: NUMBER

LAND_REGION

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

Region (GULF, ATLANTIC, etc) on the Landings Record

General Data Type: VARCHAR2

LAND_REPLICATE

CC ID: 33307
Seq. Order: 21
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Part of key ON landings record to relate the data back to the historical data.

General Data Type: NUMBER

LANDING_COMMENT

CC ID: 33308
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Comment on this landing record

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 8506
GUID: gov.noaa.nmfs.inport:8506
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-12-05 10:11+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-11-04 13:14+0000
Metadata Record Published: 2021-11-04
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-11-05