View: CTS_ANGLERS_V
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:7028 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
View Of Anglers with decodes
DescriptionView Of Anglers with decodes
Entity Information
Entity Type
Data View
Data Attribute / Type | Description |
---|---|
ANGLER_ID
NUMBER |
Unique numeric code assigned to an individual angler. Must be greater than zero. |
AGENCY_ID
VARCHAR2 |
Code for the agency assigning angler codes. |
AGENCY_NAME
VARCHAR2 |
Agency Name Corresponding To Agency ID |
FNAME
VARCHAR2 |
The angler's first name. |
M_INITIAL
VARCHAR2 |
The angler's middle initial. |
LNAME
VARCHAR2 |
The angler's last name. |
TITLE
VARCHAR2 |
The title or salutation for greeting this angler when letters are sent. |
SUFFIX
VARCHAR2 |
The suffix such as Jr. or Sr. for an angler. |
ADDRESS_1
VARCHAR2 |
The first line of the angler's address. |
ADDRESS_2
VARCHAR2 |
The second line of the angler's address. |
CITY
VARCHAR2 |
City where angler receives mail. |
STATE_ID
VARCHAR2 |
U.S. state where angler receives mail. Not allowed for a foreign address. |
STATE_NAME
VARCHAR2 |
State Name COrresponding to State Code |
COUNTRY_ID
VARCHAR2 |
Country where angler receives mail. |
COUNTRY_NAME
VARCHAR2 |
Country Name Corresponding to Country Code |
ZIPCODE
VARCHAR2 |
The angler's zip code. |
HOME_NUMBER
VARCHAR2 |
The angler's home phone number. |
WORK_NUMBER
VARCHAR2 |
The angler's work phone number. |
MOBILE_NUMBER
VARCHAR2 |
The angler's mobilephone number. |
FAX_NUMBER
VARCHAR2 |
The angler's facsimile phone number. |
EMAIL
VARCHAR2 |
The angler's email address |
NOTES
NUMBER |
The number for a note on the angler. |
NOTE_DESCRIPTION
VARCHAR2 |
Description Of Note Code |
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: CTS_ANGLERS_V |
---|---|
Short Name: | CTS_ANGLERS_V |
Status: | Completed |
Abstract: |
View Of Anglers with decodes |
Notes: |
Loaded by batch 2083, 02-22-2008 12:10 |
Entity Information
Entity Type: | Data View |
---|---|
Active Version?: | Yes |
Schema Name: | CTSPAT |
Description: |
View Of Anglers with decodes |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
ANGLER_ID | NUMBER | Unique numeric code assigned to an individual angler. Must be greater than zero. | |
100
|
AGENCY_ID | VARCHAR2 | Code for the agency assigning angler codes. | |
100
|
AGENCY_NAME | VARCHAR2 | Agency Name Corresponding To Agency ID | |
100
|
FNAME | VARCHAR2 | The angler's first name. | |
100
|
M_INITIAL | VARCHAR2 | The angler's middle initial. | |
100
|
LNAME | VARCHAR2 | The angler's last name. | |
100
|
TITLE | VARCHAR2 | The title or salutation for greeting this angler when letters are sent. | |
100
|
SUFFIX | VARCHAR2 | The suffix such as Jr. or Sr. for an angler. | |
100
|
ADDRESS_1 | VARCHAR2 | The first line of the angler's address. | |
100
|
ADDRESS_2 | VARCHAR2 | The second line of the angler's address. | |
100
|
CITY | VARCHAR2 | City where angler receives mail. | |
100
|
STATE_ID | VARCHAR2 | U.S. state where angler receives mail. Not allowed for a foreign address. | |
100
|
STATE_NAME | VARCHAR2 | State Name COrresponding to State Code | |
100
|
COUNTRY_ID | VARCHAR2 | Country where angler receives mail. | |
100
|
COUNTRY_NAME | VARCHAR2 | Country Name Corresponding to Country Code | |
100
|
ZIPCODE | VARCHAR2 | The angler's zip code. | |
100
|
HOME_NUMBER | VARCHAR2 | The angler's home phone number. | |
100
|
WORK_NUMBER | VARCHAR2 | The angler's work phone number. | |
100
|
MOBILE_NUMBER | VARCHAR2 | The angler's mobilephone number. | |
100
|
FAX_NUMBER | VARCHAR2 | The angler's facsimile phone number. | |
100
|
VARCHAR2 | The angler's email address | ||
100
|
NOTES | NUMBER | The number for a note on the angler. | |
100
|
NOTE_DESCRIPTION | VARCHAR2 | Description Of Note Code |
Attribute Details
ANGLER_ID
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
Unique numeric code assigned to an individual angler. Must be greater than zero. |
General Data Type: | NUMBER |
AGENCY_ID
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Code for the agency assigning angler codes. |
General Data Type: | VARCHAR2 |
AGENCY_NAME
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Agency Name Corresponding To Agency ID |
General Data Type: | VARCHAR2 |
FNAME
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The angler's first name. |
General Data Type: | VARCHAR2 |
M_INITIAL
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The angler's middle initial. |
General Data Type: | VARCHAR2 |
LNAME
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
The angler's last name. |
General Data Type: | VARCHAR2 |
TITLE
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The title or salutation for greeting this angler when letters are sent. |
General Data Type: | VARCHAR2 |
SUFFIX
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The suffix such as Jr. or Sr. for an angler. |
General Data Type: | VARCHAR2 |
ADDRESS_1
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The first line of the angler's address. |
General Data Type: | VARCHAR2 |
ADDRESS_2
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The second line of the angler's address. |
General Data Type: | VARCHAR2 |
CITY
Seq. Order: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
City where angler receives mail. |
General Data Type: | VARCHAR2 |
STATE_ID
Seq. Order: | 12 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
U.S. state where angler receives mail. Not allowed for a foreign address. |
General Data Type: | VARCHAR2 |
STATE_NAME
Seq. Order: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
State Name COrresponding to State Code |
General Data Type: | VARCHAR2 |
COUNTRY_ID
Seq. Order: | 14 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Country where angler receives mail. |
General Data Type: | VARCHAR2 |
COUNTRY_NAME
Seq. Order: | 15 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Country Name Corresponding to Country Code |
General Data Type: | VARCHAR2 |
ZIPCODE
Seq. Order: | 16 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The angler's zip code. |
General Data Type: | VARCHAR2 |
HOME_NUMBER
Seq. Order: | 17 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The angler's home phone number. |
General Data Type: | VARCHAR2 |
WORK_NUMBER
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The angler's work phone number. |
General Data Type: | VARCHAR2 |
MOBILE_NUMBER
Seq. Order: | 19 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The angler's mobilephone number. |
General Data Type: | VARCHAR2 |
FAX_NUMBER
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The angler's facsimile phone number. |
General Data Type: | VARCHAR2 |
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The angler's email address |
General Data Type: | VARCHAR2 |
NOTES
Seq. Order: | 22 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
The number for a note on the angler. |
General Data Type: | NUMBER |
NOTE_DESCRIPTION
Seq. Order: | 23 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Description Of Note Code |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 7028 |
---|---|
GUID: | gov.noaa.nmfs.inport:7028 |
Metadata Record Created By: | Lee M Weinberger |
Metadata Record Created: | 2008-02-22 12:10+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 |