Search Help Show/Hide Menu
Summary
Item Identification
Keywords
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

View Summarizing Raw Tournament Catches

Description

View Summarizing Raw Tournament Catches

Entity Information

Entity Type
Data View

Data Attribute / Type Description
TOURNAMENT_CODE
NUMBER
Tournament Code
TOURNAMENT_YEAR
NUMBER
Tournament Year
REPORT_RECEIVED_DATE
DATE
Date Tournament Report Recieved
SPECIES_ID
VARCHAR2
Mnemonic Species Code
NUMBER_KEPT
NUMBER
Number Kept of Species
NUMBER_LOST
NUMBER
Number Lost of species
NUMBER_TAGGED
NUMBER
Number Tagged
NUMBER_NOT_TAGGED
NUMBER
Number Not Tagged
NUMBER_DEAD
NUMBER
Number Dead
TOTAL_FISH
NUMBER
Total Number Of FIsh
ID
NUMBER
Sequential Key

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: View: RAW_TOURNAMENT_CATCH_SUMMARY_V
Short Name: RAW_TOURNAMENT_CATCH_SUMMARY_V
Status: Completed
Abstract:

View Summarizing Raw Tournament Catches

Notes:

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

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None Catch Data
None Summary Data
None Tournament

Entity Information

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

View Summarizing Raw Tournament Catches

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
TOURNAMENT_CODE NUMBER Tournament Code
100
TOURNAMENT_YEAR NUMBER Tournament Year
100
REPORT_RECEIVED_DATE DATE Date Tournament Report Recieved
100
SPECIES_ID VARCHAR2 Mnemonic Species Code
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
100
ID NUMBER Sequential Key

Attribute Details

TOURNAMENT_CODE

CC ID: 20657
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

TOURNAMENT_YEAR

CC ID: 20650
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

REPORT_RECEIVED_DATE

CC ID: 20659
Seq. Order: 3
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Date Tournament Report Recieved

General Data Type: DATE

SPECIES_ID

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

Mnemonic Species Code

General Data Type: VARCHAR2

NUMBER_KEPT

CC ID: 20654
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: 20655
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: 20656
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: 20649
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: 20658
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: 20652
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

ID

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

Sequential Key

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 6244
GUID: gov.noaa.nmfs.inport:6244
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