Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Sustainable Fisheries > Highly Migratory Species Branch > Recreational Billfish Survey > Recreational Billfish Survey (RBS) >

Table: REWARD_SPECIES

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:6250  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Keywords
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Lists Rewards That are avilable by Tournament , Year, and Species

Description

Lists Reqrds That are avilable by Tournament , Year, and Species

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TOURNAMENT_CODE
NUMBER 		Foreign Key to Tournament Table
TOURNAMENT_YEAR
NUMBER 		Year Of Tournament
SPECIES_ID
VARCHAR2 		Mnemonic Species Code
REWARD_AMOUNT
NUMBER 		Amount Of Reward
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: Table: REWARD_SPECIES
Short Name: REWARD_SPECIES
Status: Completed
Abstract:

Lists Rewards That are avilable by Tournament , Year, and Species
Notes:

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

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None Rewards

Entity Information

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

Lists Reqrds That are avilable by Tournament , Year, and Species

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 TOURNAMENT_CODE NUMBER Foreign Key to Tournament Table
100
 TOURNAMENT_YEAR NUMBER Year Of Tournament
100
 SPECIES_ID VARCHAR2 Mnemonic Species Code
100
 REWARD_AMOUNT NUMBER Amount Of Reward
100
 Primary Key ID NUMBER Sequential Key

Attribute Details

TOURNAMENT_CODE

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

Foreign Key to Tournament Table
General Data Type: NUMBER

TOURNAMENT_YEAR

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

Year Of Tournament
General Data Type: NUMBER

SPECIES_ID

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

Mnemonic Species Code
General Data Type: VARCHAR2

REWARD_AMOUNT

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

Amount Of Reward
General Data Type: NUMBER

ID

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

Sequential Key
General Data Type: NUMBER

Catalog Details

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