Metadata Rubric

100%

6 / 6

SEFSC Metadata Library > Social Science Research Group Projects > Trip Cost Data > SSRG Socioeconomic Panel >

Table: EDC_ANNUAL_VESSEL

Entity (ENT) | Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:6851 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Physical Location

Entity Info

Data Attributes

Catalog Details

Abstract

Table tracking a vessels participation in Economic Data Collection

Description

Table tracking a vessels participation in Economic Data Collection

Entity Type
Data Table

Data Attribute / Type	Description
VESSEL_ID VARCHAR2	All information from sero's db sero_activev table
VESSEL_NAME VARCHAR2	Name of The Vessel
OWNER_NAME VARCHAR2	Name Of The Owner Of The Vessel
PHONE VARCHAR2	Phone Number of vessel owner
ADDRESS VARCHAR2	Street Address rof vessel owner
CITY VARCHAR2	City rof vessel owner
STATE VARCHAR2	State of vessel owner
ZIPCODE VARCHAR2	Zip Code of vessel owner
ACCESS_CODE VARCHAR2	The access code to login to the survey form (populated by an algorithm)
LAST_PARTICIPATION_YEAR NUMBER	The last year this vessel participated in a survey
SURVEY_RECEIVED_DATE DATE	Timestamp of when survey was recieved
SIGNING_PERSON_NAME VARCHAR2	Name of the person completing the form
SIGNING_PERSON_PHONE VARCHAR2	Phone number of the person completing the form

Data Attribute / Type

Description

VESSEL_ID
VARCHAR2

All information from sero's db sero_activev table

VESSEL_NAME
VARCHAR2

Name of The Vessel

OWNER_NAME
VARCHAR2

Name Of The Owner Of The Vessel

PHONE
VARCHAR2

Phone Number of vessel owner

ADDRESS
VARCHAR2

Street Address rof vessel owner

CITY
VARCHAR2

City rof vessel owner

STATE
VARCHAR2

State of vessel owner

ZIPCODE
VARCHAR2

Zip Code of vessel owner

ACCESS_CODE
VARCHAR2

The access code to login to the survey form (populated by an algorithm)

LAST_PARTICIPATION_YEAR
NUMBER

The last year this vessel participated in a survey

SURVEY_RECEIVED_DATE
DATE

Timestamp of when survey was recieved

SIGNING_PERSON_NAME
VARCHAR2

Name of the person completing the form

SIGNING_PERSON_PHONE
VARCHAR2

Phone number of the person completing the form

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

Title:	Table: EDC_ANNUAL_VESSEL
Short Name:	EDC_ANNUAL_VESSEL
Status:	Completed
Abstract:	Table tracking a vessels participation in Economic Data Collection
Notes:	Loaded by batch 2043, 12-20-2007 08:10

Organization:	Southeast Fisheries Science Center
City:	Miami
State/Province:	FL
Country:	USA

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	FLS
Description:	Table tracking a vessels participation in Economic Data Collection

Attribute Summary

	Name	Type	Description
100	VESSEL_ID	VARCHAR2	All information from sero's db sero_activev table
100	VESSEL_NAME	VARCHAR2	Name of The Vessel
100	OWNER_NAME	VARCHAR2	Name Of The Owner Of The Vessel
100	PHONE	VARCHAR2	Phone Number of vessel owner
100	ADDRESS	VARCHAR2	Street Address rof vessel owner
100	CITY	VARCHAR2	City rof vessel owner
100	STATE	VARCHAR2	State of vessel owner
100	ZIPCODE	VARCHAR2	Zip Code of vessel owner
100	ACCESS_CODE	VARCHAR2	The access code to login to the survey form (populated by an algorithm)
100	LAST_PARTICIPATION_YEAR	NUMBER	The last year this vessel participated in a survey
100	SURVEY_RECEIVED_DATE	DATE	Timestamp of when survey was recieved
100	SIGNING_PERSON_NAME	VARCHAR2	Name of the person completing the form
100	SIGNING_PERSON_PHONE	VARCHAR2	Phone number of the person completing the form

Name

Type

Description

100

VESSEL_ID

VARCHAR2

All information from sero's db sero_activev table

100

VESSEL_NAME

VARCHAR2

Name of The Vessel

100

OWNER_NAME

VARCHAR2

Name Of The Owner Of The Vessel

100

PHONE

VARCHAR2

Phone Number of vessel owner

100

ADDRESS

VARCHAR2

Street Address rof vessel owner

100

CITY

VARCHAR2

City rof vessel owner

100

STATE

VARCHAR2

State of vessel owner

100

ZIPCODE

VARCHAR2

Zip Code of vessel owner

100

ACCESS_CODE

VARCHAR2

The access code to login to the survey form (populated by an algorithm)

100

LAST_PARTICIPATION_YEAR

NUMBER

The last year this vessel participated in a survey

100

SURVEY_RECEIVED_DATE

DATE

Timestamp of when survey was recieved

100

SIGNING_PERSON_NAME

VARCHAR2

Name of the person completing the form

100

SIGNING_PERSON_PHONE

VARCHAR2

Phone number of the person completing the form

Attribute Details

VESSEL_ID

CC ID: 24511

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	All information from sero's db sero_activev table
General Data Type:	VARCHAR2

VESSEL_NAME

CC ID: 24512

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	Name of The Vessel
General Data Type:	VARCHAR2

OWNER_NAME

CC ID: 24513

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	45
Required:	No
Primary Key:	No
Status:	Active
Description:	Name Of The Owner Of The Vessel
General Data Type:	VARCHAR2

PHONE

CC ID: 24514

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	12
Required:	No
Primary Key:	No
Status:	Active
Description:	Phone Number of vessel owner
General Data Type:	VARCHAR2

ADDRESS

CC ID: 24515

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	Street Address rof vessel owner
General Data Type:	VARCHAR2

CITY

CC ID: 24516

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	City rof vessel owner
General Data Type:	VARCHAR2

STATE

CC ID: 24517

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	State of vessel owner
General Data Type:	VARCHAR2

ZIPCODE

CC ID: 24518

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	Zip Code of vessel owner
General Data Type:	VARCHAR2

ACCESS_CODE

CC ID: 24519

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	The access code to login to the survey form (populated by an algorithm)
General Data Type:	VARCHAR2

LAST_PARTICIPATION_YEAR

CC ID: 24520

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	The last year this vessel participated in a survey
General Data Type:	NUMBER

SURVEY_RECEIVED_DATE

CC ID: 24521

Seq. Order:	11
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Timestamp of when survey was recieved
General Data Type:	DATE

SIGNING_PERSON_NAME

CC ID: 24522

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	60
Required:	No
Primary Key:	No
Status:	Active
Description:	Name of the person completing the form
General Data Type:	VARCHAR2

SIGNING_PERSON_PHONE

CC ID: 24523

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	15
Required:	No
Primary Key:	No
Status:	Active
Description:	Phone number of the person completing the form
General Data Type:	VARCHAR2

Catalog Item ID:	6851
GUID:	gov.noaa.nmfs.inport:6851
Metadata Record Created By:	Lee M Weinberger
Metadata Record Created:	2007-12-20 08:10+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:10+0000
Metadata Record Published:	2021-05-07
Owner Org:	SEFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2021-05-07
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2022-05-07

Table: EDC_ANNUAL_VESSEL

Summary

Entity Information

Child Items

Contact Information

Item Identification

Physical Location

Entity Information

Data Attributes

Attribute Summary

Attribute Details

VESSEL_ID

VESSEL_NAME

OWNER_NAME

PHONE

ADDRESS

CITY

STATE

ZIPCODE

ACCESS_CODE

LAST_PARTICIPATION_YEAR

SURVEY_RECEIVED_DATE

SIGNING_PERSON_NAME

SIGNING_PERSON_PHONE

Catalog Details