Table: TBF_PERSONS
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:7121 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Person Table From The Bill Fish Foundation
DescriptionPerson Table From The Bill Fish Foundation
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
AGENCY_ID
VARCHAR2 |
Code identifying the agency the person is affiliated. |
ID
NUMBER |
Unique identifer for each person. |
TITLE
VARCHAR2 |
The persons official title ('CAPT.', 'Mr.', 'Mrs.') |
FIRSTNAME
VARCHAR2 |
First Name |
LASTNAME
VARCHAR2 |
Last Name |
M_INITIAL
VARCHAR2 |
Midle Iniitial |
SUFFIX
VARCHAR2 |
Name Suffix (like Jr) |
ADDRESS1
VARCHAR2 |
First Line Of Address |
ADDRESS2
VARCHAR2 |
Second Line Of Address |
CITY
VARCHAR2 |
City of mailing address |
STATE
VARCHAR2 |
Stae Of mailling address |
ZIP
VARCHAR2 |
Zipcode Of Mailing Address |
COUNTRY
VARCHAR2 |
Country Of Mailing Address |
HOME_NUMBER
VARCHAR2 |
Home Phone Number |
WORK_NUMBER
VARCHAR2 |
Work Phone Number |
MOBILE_NUMBER
VARCHAR2 |
Mobile/Celluar Number |
FAX_NUMBER
VARCHAR2 |
Facsimile Number |
EMAIL
VARCHAR2 |
Email Address |
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: TBF_PERSONS |
---|---|
Short Name: | TBF_PERSONS |
Status: | Completed |
Abstract: |
Person Table From The Bill Fish Foundation |
Notes: |
Loaded by batch 2083, 02-22-2008 12:10 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | CTSPAT |
Description: |
Person Table From The Bill Fish Foundation |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
AGENCY_ID | VARCHAR2 | Code identifying the agency the person is affiliated. | |
100
|
![]() |
ID | NUMBER | Unique identifer for each person. |
100
|
TITLE | VARCHAR2 | The persons official title ('CAPT.', 'Mr.', 'Mrs.') | |
100
|
FIRSTNAME | VARCHAR2 | First Name | |
100
|
LASTNAME | VARCHAR2 | Last Name | |
100
|
M_INITIAL | VARCHAR2 | Midle Iniitial | |
100
|
SUFFIX | VARCHAR2 | Name Suffix (like Jr) | |
100
|
ADDRESS1 | VARCHAR2 | First Line Of Address | |
100
|
ADDRESS2 | VARCHAR2 | Second Line Of Address | |
100
|
CITY | VARCHAR2 | City of mailing address | |
100
|
STATE | VARCHAR2 | Stae Of mailling address | |
100
|
ZIP | VARCHAR2 | Zipcode Of Mailing Address | |
100
|
COUNTRY | VARCHAR2 | Country Of Mailing Address | |
100
|
HOME_NUMBER | VARCHAR2 | Home Phone Number | |
100
|
WORK_NUMBER | VARCHAR2 | Work Phone Number | |
100
|
MOBILE_NUMBER | VARCHAR2 | Mobile/Celluar Number | |
100
|
FAX_NUMBER | VARCHAR2 | Facsimile Number | |
100
|
VARCHAR2 | Email Address |
Attribute Details
AGENCY_ID
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Code identifying the agency the person is affiliated. |
General Data Type: | VARCHAR2 |
ID
Seq. Order: | 2 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 38 |
Status: | Active |
Description: |
Unique identifer for each person. |
General Data Type: | NUMBER |
TITLE
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The persons official title ('CAPT.', 'Mr.', 'Mrs.') |
General Data Type: | VARCHAR2 |
FIRSTNAME
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
First Name |
General Data Type: | VARCHAR2 |
LASTNAME
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Last Name |
General Data Type: | VARCHAR2 |
M_INITIAL
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Midle Iniitial |
General Data Type: | VARCHAR2 |
SUFFIX
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Name Suffix (like Jr) |
General Data Type: | VARCHAR2 |
ADDRESS1
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 100 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
First Line Of Address |
General Data Type: | VARCHAR2 |
ADDRESS2
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 100 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Second Line Of Address |
General Data Type: | VARCHAR2 |
CITY
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
City of mailing address |
General Data Type: | VARCHAR2 |
STATE
Seq. Order: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Stae Of mailling address |
General Data Type: | VARCHAR2 |
ZIP
Seq. Order: | 12 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Zipcode Of Mailing Address |
General Data Type: | VARCHAR2 |
COUNTRY
Seq. Order: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Country Of Mailing Address |
General Data Type: | VARCHAR2 |
HOME_NUMBER
Seq. Order: | 14 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Home Phone Number |
General Data Type: | VARCHAR2 |
WORK_NUMBER
Seq. Order: | 15 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Work Phone Number |
General Data Type: | VARCHAR2 |
MOBILE_NUMBER
Seq. Order: | 16 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 100 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Mobile/Celluar Number |
General Data Type: | VARCHAR2 |
FAX_NUMBER
Seq. Order: | 17 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 15 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Facsimile Number |
General Data Type: | VARCHAR2 |
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Email Address |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 7121 |
---|---|
GUID: | gov.noaa.nmfs.inport:7121 |
Metadata Record Created By: | Lee M Weinberger |
Metadata Record Created: | 2008-02-22 12:11+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 |