Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: View: CATCH_SUMMARY_V
Short Name: CATCH_SUMMARY_V
Status: Completed
Abstract:

View Of Catch Summary

Notes:

Loaded by batch 1863, 11-02-2007 09:24

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None Catch Summary Data

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: RBS
Description:

View Of Catch Summary

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
CATCH_TOURNAMENT_CODE NUMBER Tournament Code
100
CATCH_TOURNAMENT_YEAR NUMBER Tournament Year
100
SPECIES_ID VARCHAR2 Mnemonic Species Code
100
RECORD_COUNT NUMBER Number Of Records Per Species
100
NUMBER_KEPT NUMBER Number Kept of Species
100
NUMBER_LOST NUMBER Number Lost of species
100
NUMBER_TAGGED NUMBER Number Tagged
100
NUMBER_NOT_TAGGED NUMBER Number Not Tagged
100
NUMBER_DEAD NUMBER Number Dead
100
TOTAL_FISH NUMBER Total Number Of FIsh

Attribute Details

CATCH_TOURNAMENT_CODE

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

Tournament Code

General Data Type: NUMBER

CATCH_TOURNAMENT_YEAR

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

Tournament Year

General Data Type: NUMBER

SPECIES_ID

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

Mnemonic Species Code

General Data Type: VARCHAR2

RECORD_COUNT

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

Number Of Records Per Species

General Data Type: NUMBER

NUMBER_KEPT

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

Number Kept of Species

General Data Type: NUMBER

NUMBER_LOST

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

Number Lost of species

General Data Type: NUMBER

NUMBER_TAGGED

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

Number Tagged

General Data Type: NUMBER

NUMBER_NOT_TAGGED

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

Number Not Tagged

General Data Type: NUMBER

NUMBER_DEAD

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

Number Dead

General Data Type: NUMBER

TOTAL_FISH

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

Total Number Of FIsh

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 6229
GUID: gov.noaa.nmfs.inport:6229
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-11-02 09:24+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-05-05
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-05
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-05