View: TOURNAMENT_DETAILED_SUMMARY_V
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:6260 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | View: TOURNAMENT_DETAILED_SUMMARY_V |
---|---|
Short Name: | TOURNAMENT_DETAILED_SUMMARY_V |
Status: | Completed |
Abstract: |
View providing Detailed Tournament Summary |
Notes: |
Loaded by batch 1863, 11-02-2007 09:24 |
Entity Information
Entity Type: | Data View |
---|---|
Active Version?: | Yes |
Schema Name: | RBS |
Description: |
View providing Detailed Tournament Summary |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
ICCAT | VARCHAR2 | ICCAT Area Code | |
100
|
STATE | VARCHAR2 | State Where tournament took place | |
100
|
SOURCE | VARCHAR2 | Source Of Survey | |
100
|
CODE | NUMBER | Tournament Code | |
100
|
YEAR | NUMBER | Year When tournament took place | |
100
|
MONTH | VARCHAR2 | Month when tournament took place | |
100
|
START_DATE | DATE | Date Fishing Started | |
100
|
END_DATE | DATE | Date Fishing Ended | |
100
|
SPECIES | VARCHAR2 | Mnemonic Species Code | |
100
|
CATCH | NUMBER | Number Caught | |
100
|
KEPT | NUMBER | Number Kept | |
100
|
DEAD | NUMBER | Number Dead | |
100
|
RELEASED | NUMBER | Number Released | |
100
|
WEIGHT_COUNT | NUMBER | Number with Weight Information | |
100
|
WEIGHT_SUM | NUMBER | Summary of Weighs When Weight Information is provided | |
100
|
MISSING | NUMBER | Records Missing Information |
Attribute Details
ICCAT
CC ID: 20852
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
ICCAT Area Code |
General Data Type: | VARCHAR2 |
STATE
CC ID: 20856
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
State Where tournament took place |
General Data Type: | VARCHAR2 |
SOURCE
CC ID: 20861
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Source Of Survey |
General Data Type: | VARCHAR2 |
CODE
CC ID: 20855
Seq. Order: | 4 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Tournament Code |
General Data Type: | NUMBER |
YEAR
CC ID: 20865
Seq. Order: | 5 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Year When tournament took place |
General Data Type: | NUMBER |
MONTH
CC ID: 20859
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Month when tournament took place |
General Data Type: | VARCHAR2 |
START_DATE
CC ID: 20864
Seq. Order: | 7 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date Fishing Started |
General Data Type: | DATE |
END_DATE
CC ID: 20857
Seq. Order: | 8 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date Fishing Ended |
General Data Type: | DATE |
SPECIES
CC ID: 20854
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Mnemonic Species Code |
General Data Type: | VARCHAR2 |
CATCH
CC ID: 20853
Seq. Order: | 10 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Number Caught |
General Data Type: | NUMBER |
KEPT
CC ID: 20862
Seq. Order: | 11 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Number Kept |
General Data Type: | NUMBER |
DEAD
CC ID: 20858
Seq. Order: | 12 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Number Dead |
General Data Type: | NUMBER |
RELEASED
CC ID: 20867
Seq. Order: | 13 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Number Released |
General Data Type: | NUMBER |
WEIGHT_COUNT
CC ID: 20866
Seq. Order: | 14 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Number with Weight Information |
General Data Type: | NUMBER |
WEIGHT_SUM
CC ID: 20860
Seq. Order: | 15 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Summary of Weighs When Weight Information is provided |
General Data Type: | NUMBER |
MISSING
CC ID: 20863
Seq. Order: | 16 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Records Missing Information |
General Data Type: | NUMBER |
Catalog Details
Catalog Item ID: | 6260 |
---|---|
GUID: | gov.noaa.nmfs.inport:6260 |
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 |