Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Sustainable Fisheries > Highly Migratory Species Branch > Cooperative Tagging System > Cooperative Tagging Center (CTC) >

Table: TBF_PERSONS

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

Summary

Abstract

Person Table From The Bill Fish Foundation

Description

Person 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

Rubric Score Primary Key? Name Type Description
100
 AGENCY_ID VARCHAR2 Code identifying the agency the person is affiliated.
100
 Primary Key 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
 EMAIL VARCHAR2 Email Address

Attribute Details

AGENCY_ID

CC ID: 26941
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

CC ID: 26942
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

CC ID: 26943
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

CC ID: 26944
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

CC ID: 26945
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

CC ID: 26946
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

CC ID: 26947
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

CC ID: 26948
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

CC ID: 26949
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

CC ID: 26950
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

CC ID: 26951
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

CC ID: 26952
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

CC ID: 26953
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

CC ID: 26954
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

CC ID: 26955
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

CC ID: 26956
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

CC ID: 26957
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Facsimile Number
General Data Type: VARCHAR2

EMAIL

CC ID: 26958
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