Table: ANNUAL_REGISTRATIONS
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:6223 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | Table: ANNUAL_REGISTRATIONS |
|---|---|
| Short Name: | ANNUAL_REGISTRATIONS |
| Status: | Completed |
| Abstract: |
List of All Fishing Tournaments |
| Notes: |
Loaded by batch 1863, 11-02-2007 09:24 |
Keywords
Theme Keywords
| Thesaurus | Keyword |
|---|---|
| UNCONTROLLED | |
| None | Fishing Tournaments |
Entity Information
| Entity Type: | Data Table |
|---|---|
| Active Version?: | Yes |
| Schema Name: | RBS |
| Description: |
List of All Fishing Tournaments |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
TOURNAMENT_NAME | VARCHAR2 | Name Of Tournament | |
|
100
|
TOURNAMENT_CODE | NUMBER | Tournament Foreign Key to Tournaments Table | |
|
100
|
START_DATE | DATE | Start Date Of Tournament | |
|
100
|
END_DATE | DATE | End Date Of Tournament | |
|
100
|
DIRECTOR_NAME | VARCHAR2 | Name Of The Director Of The Tournament | |
|
100
|
ADDRESS | VARCHAR2 | First Line Of address For Tournament Contact | |
|
100
|
ADDRESS2 | VARCHAR2 | Second Line Of address For Tournament Contact | |
|
100
|
CITY | VARCHAR2 | City Part Of Contact Person Address | |
|
100
|
STATE | VARCHAR2 | State Part of Contact Address | |
|
100
|
ZIP | VARCHAR2 | Zip Code Part of Contact Address | |
|
100
|
COUNTRY | VARCHAR2 | Country Where Tournament Wa Held | |
|
100
|
PHONE | VARCHAR2 | Phone Number For Calling Contact Of Tournament | |
|
100
|
FAX | VARCHAR2 | Fax Number For Calling Contact Of Tournament | |
|
100
|
MOBILE | VARCHAR2 | Mobile Number For Calling Contact Of Tournament | |
|
100
|
VARCHAR2 | email address of the tournament contact | ||
|
100
|
WEB_URL | VARCHAR2 | Tournament Website | |
|
100
|
SUMMARY_REPORT | VARCHAR2 | Is there a tournament Summary Report | |
|
100
|
TOURNAMENT_TYPE | VARCHAR2 | Type of Tournament | |
|
100
|
REGISTRATION_DATE | DATE | Date of Registration | |
|
100
|
COMMENTS | VARCHAR2 | Any Other Comments About this record | |
|
100
|
|
ID | NUMBER | Sequential Key |
|
100
|
HOOK_RESTRICTIONS | VARCHAR2 | Were There any Hook Restrictions For This Tournament | |
|
100
|
BAIT_RESTRICTIONS | VARCHAR2 | Were There any Bait Restrictions For This Tournament | |
|
100
|
CPUE_CATEGORY_ID | NUMBER | Column used primarily for computations of CPUE series. Indentify the pure tournaments. Ex. tournaments that target only billfish. |
Attribute Details
TOURNAMENT_NAME
CC ID: 20490
| Seq. Order: | 1 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 100 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Name Of Tournament |
| General Data Type: | VARCHAR2 |
TOURNAMENT_CODE
CC ID: 20491
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 38 |
| Status: | Active |
| Description: |
Tournament Foreign Key to Tournaments Table |
| General Data Type: | NUMBER |
START_DATE
CC ID: 20492
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Start Date Of Tournament |
| General Data Type: | DATE |
END_DATE
CC ID: 20493
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
End Date Of Tournament |
| General Data Type: | DATE |
DIRECTOR_NAME
CC ID: 20494
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Name Of The Director Of The Tournament |
| General Data Type: | VARCHAR2 |
ADDRESS
CC ID: 20495
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 100 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
First Line Of address For Tournament Contact |
| General Data Type: | VARCHAR2 |
ADDRESS2
CC ID: 20496
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 100 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Second Line Of address For Tournament Contact |
| General Data Type: | VARCHAR2 |
CITY
CC ID: 20497
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
City Part Of Contact Person Address |
| General Data Type: | VARCHAR2 |
STATE
CC ID: 20498
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 100 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
State Part of Contact Address |
| General Data Type: | VARCHAR2 |
ZIP
CC ID: 20499
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Zip Code Part of Contact Address |
| General Data Type: | VARCHAR2 |
COUNTRY
CC ID: 20500
| Seq. Order: | 11 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 100 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Country Where Tournament Wa Held |
| General Data Type: | VARCHAR2 |
PHONE
CC ID: 20501
| Seq. Order: | 12 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Phone Number For Calling Contact Of Tournament |
| General Data Type: | VARCHAR2 |
FAX
CC ID: 20502
| Seq. Order: | 13 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Fax Number For Calling Contact Of Tournament |
| General Data Type: | VARCHAR2 |
MOBILE
CC ID: 20503
| Seq. Order: | 14 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Mobile Number For Calling Contact Of Tournament |
| General Data Type: | VARCHAR2 |
CC ID: 20504
| Seq. Order: | 15 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
email address of the tournament contact |
| General Data Type: | VARCHAR2 |
WEB_URL
CC ID: 20505
| Seq. Order: | 16 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 100 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Tournament Website |
| General Data Type: | VARCHAR2 |
SUMMARY_REPORT
CC ID: 20506
| Seq. Order: | 17 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 5 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Is there a tournament Summary Report |
| General Data Type: | VARCHAR2 |
TOURNAMENT_TYPE
CC ID: 20507
| Seq. Order: | 18 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Type of Tournament |
| General Data Type: | VARCHAR2 |
REGISTRATION_DATE
CC ID: 20508
| Seq. Order: | 19 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Date of Registration |
| General Data Type: | DATE |
COMMENTS
CC ID: 20509
| Seq. Order: | 20 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 500 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Any Other Comments About this record |
| General Data Type: | VARCHAR2 |
ID
CC ID: 20510
| Seq. Order: | 21 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | Yes |
| Primary Key: | Yes |
| Precision: | 38 |
| Status: | Active |
| Description: |
Sequential Key |
| General Data Type: | NUMBER |
HOOK_RESTRICTIONS
CC ID: 20511
| Seq. Order: | 22 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Were There any Hook Restrictions For This Tournament |
| General Data Type: | VARCHAR2 |
BAIT_RESTRICTIONS
CC ID: 20512
| Seq. Order: | 23 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Were There any Bait Restrictions For This Tournament |
| General Data Type: | VARCHAR2 |
CPUE_CATEGORY_ID
CC ID: 20513
| Seq. Order: | 24 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Status: | Active |
| Description: |
Column used primarily for computations of CPUE series. Indentify the pure tournaments. Ex. tournaments that target only billfish. |
| General Data Type: | NUMBER |
Catalog Details
| Catalog Item ID: | 6223 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:6223 |
| 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 |