Metadata Rubric

100%

6 / 6

SEFSC Metadata Library > Social Science Research Group Projects > Economic Data Collections for Gulf of Mexico &... > Economic Data Collection for Gulf of Mexico Sou... >

Table: SAMPLE_PERMIT_OWNER

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

A lookup table of permit owner names and their vessels.

Description

A lookup table of permit owner names and their vessels.

Entity Type
Data Table

Data Attribute / Type	Description
STATE VARCHAR2	2 letter abbreviation for the state issuing the permit.
PERMIT_NUMBER_SUFFIX VARCHAR2	The numeric part of the suffix. Prefix for all is SPGM-
VESSEL_ID VARCHAR2	Vessel identification number
GSHRLBS VARCHAR2	Total pounds of Gulf Shrimp harvested by vessel.
GSHRREV VARCHAR2	Dollar value of Gulf Shrimp harvested by vessel.
SPANISH VARCHAR2	1 = Desire survey forms in Spanish language.
VIETNAMESE VARCHAR2	1 = Desire survey forms in Vietnamese language.
VESSEL_NAME VARCHAR2	The name of the vessel
PERMIT_NUMBER VARCHAR2	The permit number authorizing vessel to catch and sell shrimp.
PRIMARY_MAILING_RECIPIENT VARCHAR2	The name of the primary permit holder. It can be an individual or a company.
STREET_ADDRESS VARCHAR2	The street address of the primary mailing recipient.
CITY VARCHAR2	The city where the primary mailing recipient receives mail.
MAILING_STATE VARCHAR2	The state where the primary mailing recipient receives mail.
ZIP_CODE VARCHAR2	The zip code of the primary mailing recipient.
PHONE_NUMBER VARCHAR2	The phone number of the primary mailing recipient.
BUSINESS_RELATIONSHIP VARCHAR2	When multiple people share a permit, their position is listed here, Examples are PRESIDENT, SECRETARY, TREASURER, etc.
BUSINESS_ASSOCIATE_LNAME VARCHAR2	Business associates last name.
BUSINESS_ASSOCIATE_FNAME VARCHAR2	Business associates first name.
BUSINESS_ASSOCIATE_PHONE VARCHAR2	Business associates phone number.
HOMEPORT_CITY VARCHAR2	The home port city of the permit holder.
HOMEPORT_STATE VARCHAR2	The home port state of the permit holder.
ACTIVE_YEAR NUMBER	The survey year this entry will be used for.
CREATED_BY_USER_ID VARCHAR2	An application controlled field showing the userid of the person inserting a record
CREATED_DATE DATE	An application controlled field showing the date and time the record was inserted into the Oracle table
MODIFIED_BY_USER_ID VARCHAR2	The userid of the last person to edit the data
MODIFIED_DATE DATE	The date of the last update to the record

Data Attribute / Type

Description

STATE
VARCHAR2

2 letter abbreviation for the state issuing the permit.

PERMIT_NUMBER_SUFFIX
VARCHAR2

The numeric part of the suffix. Prefix for all is SPGM-

VESSEL_ID
VARCHAR2

Vessel identification number

GSHRLBS
VARCHAR2

Total pounds of Gulf Shrimp harvested by vessel.

GSHRREV
VARCHAR2

Dollar value of Gulf Shrimp harvested by vessel.

SPANISH
VARCHAR2

1 = Desire survey forms in Spanish language.

VIETNAMESE
VARCHAR2

1 = Desire survey forms in Vietnamese language.

VESSEL_NAME
VARCHAR2

The name of the vessel

PERMIT_NUMBER
VARCHAR2

The permit number authorizing vessel to catch and sell shrimp.

PRIMARY_MAILING_RECIPIENT
VARCHAR2

The name of the primary permit holder. It can be an individual or a company.

STREET_ADDRESS
VARCHAR2

The street address of the primary mailing recipient.

CITY
VARCHAR2

The city where the primary mailing recipient receives mail.

MAILING_STATE
VARCHAR2

The state where the primary mailing recipient receives mail.

ZIP_CODE
VARCHAR2

The zip code of the primary mailing recipient.

PHONE_NUMBER
VARCHAR2

The phone number of the primary mailing recipient.

BUSINESS_RELATIONSHIP
VARCHAR2

When multiple people share a permit, their position is listed here, Examples are PRESIDENT, SECRETARY, TREASURER, etc.

BUSINESS_ASSOCIATE_LNAME
VARCHAR2

Business associates last name.

BUSINESS_ASSOCIATE_FNAME
VARCHAR2

Business associates first name.

BUSINESS_ASSOCIATE_PHONE
VARCHAR2

Business associates phone number.

HOMEPORT_CITY
VARCHAR2

The home port city of the permit holder.

HOMEPORT_STATE
VARCHAR2

The home port state of the permit holder.

ACTIVE_YEAR
NUMBER

The survey year this entry will be used for.

CREATED_BY_USER_ID
VARCHAR2

An application controlled field showing the userid of the person inserting a record

CREATED_DATE
DATE

An application controlled field showing the date and time the record was inserted into the Oracle table

MODIFIED_BY_USER_ID
VARCHAR2

The userid of the last person to edit the data

MODIFIED_DATE
DATE

The date of the last update to the record

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: SAMPLE_PERMIT_OWNER
Short Name:	SAMPLE_PERMIT_OWNER
Status:	Completed
Abstract:	A lookup table of permit owner names and their vessels.
Notes:	Loaded by batch 1643, 10-10-2007 10:43

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	EC_SRV_GS
Description:	A lookup table of permit owner names and their vessels.

Attribute Summary

	Name	Type	Description
100	STATE	VARCHAR2	2 letter abbreviation for the state issuing the permit.
100	PERMIT_NUMBER_SUFFIX	VARCHAR2	The numeric part of the suffix. Prefix for all is SPGM-
100	VESSEL_ID	VARCHAR2	Vessel identification number
100	GSHRLBS	VARCHAR2	Total pounds of Gulf Shrimp harvested by vessel.
100	GSHRREV	VARCHAR2	Dollar value of Gulf Shrimp harvested by vessel.
100	SPANISH	VARCHAR2	1 = Desire survey forms in Spanish language.
100	VIETNAMESE	VARCHAR2	1 = Desire survey forms in Vietnamese language.
100	VESSEL_NAME	VARCHAR2	The name of the vessel
100	PERMIT_NUMBER	VARCHAR2	The permit number authorizing vessel to catch and sell shrimp.
100	PRIMARY_MAILING_RECIPIENT	VARCHAR2	The name of the primary permit holder. It can be an individual or a company.
100	STREET_ADDRESS	VARCHAR2	The street address of the primary mailing recipient.
100	CITY	VARCHAR2	The city where the primary mailing recipient receives mail.
100	MAILING_STATE	VARCHAR2	The state where the primary mailing recipient receives mail.
100	ZIP_CODE	VARCHAR2	The zip code of the primary mailing recipient.
100	PHONE_NUMBER	VARCHAR2	The phone number of the primary mailing recipient.
100	BUSINESS_RELATIONSHIP	VARCHAR2	When multiple people share a permit, their position is listed here, Examples are PRESIDENT, SECRETARY, TREASURER, etc.
100	BUSINESS_ASSOCIATE_LNAME	VARCHAR2	Business associates last name.
100	BUSINESS_ASSOCIATE_FNAME	VARCHAR2	Business associates first name.
100	BUSINESS_ASSOCIATE_PHONE	VARCHAR2	Business associates phone number.
100	HOMEPORT_CITY	VARCHAR2	The home port city of the permit holder.
100	HOMEPORT_STATE	VARCHAR2	The home port state of the permit holder.
100	ACTIVE_YEAR	NUMBER	The survey year this entry will be used for.
100	CREATED_BY_USER_ID	VARCHAR2	An application controlled field showing the userid of the person inserting a record
100	CREATED_DATE	DATE	An application controlled field showing the date and time the record was inserted into the Oracle table
100	MODIFIED_BY_USER_ID	VARCHAR2	The userid of the last person to edit the data
100	MODIFIED_DATE	DATE	The date of the last update to the record

Name

Type

Description

100

STATE

VARCHAR2

2 letter abbreviation for the state issuing the permit.

100

PERMIT_NUMBER_SUFFIX

VARCHAR2

The numeric part of the suffix. Prefix for all is SPGM-

100

VESSEL_ID

VARCHAR2

Vessel identification number

100

GSHRLBS

VARCHAR2

Total pounds of Gulf Shrimp harvested by vessel.

100

GSHRREV

VARCHAR2

Dollar value of Gulf Shrimp harvested by vessel.

100

SPANISH

VARCHAR2

1 = Desire survey forms in Spanish language.

100

VIETNAMESE

VARCHAR2

1 = Desire survey forms in Vietnamese language.

100

VESSEL_NAME

VARCHAR2

The name of the vessel

100

PERMIT_NUMBER

VARCHAR2

The permit number authorizing vessel to catch and sell shrimp.

100

PRIMARY_MAILING_RECIPIENT

VARCHAR2

The name of the primary permit holder. It can be an individual or a company.

100

STREET_ADDRESS

VARCHAR2

The street address of the primary mailing recipient.

100

CITY

VARCHAR2

The city where the primary mailing recipient receives mail.

100

MAILING_STATE

VARCHAR2

The state where the primary mailing recipient receives mail.

100

ZIP_CODE

VARCHAR2

The zip code of the primary mailing recipient.

100

PHONE_NUMBER

VARCHAR2

The phone number of the primary mailing recipient.

100

BUSINESS_RELATIONSHIP

VARCHAR2

When multiple people share a permit, their position is listed here, Examples are PRESIDENT, SECRETARY, TREASURER, etc.

100

BUSINESS_ASSOCIATE_LNAME

VARCHAR2

Business associates last name.

100

BUSINESS_ASSOCIATE_FNAME

VARCHAR2

Business associates first name.

100

BUSINESS_ASSOCIATE_PHONE

VARCHAR2

Business associates phone number.

100

HOMEPORT_CITY

VARCHAR2

The home port city of the permit holder.

100

HOMEPORT_STATE

VARCHAR2

The home port state of the permit holder.

100

ACTIVE_YEAR

NUMBER

The survey year this entry will be used for.

100

CREATED_BY_USER_ID

VARCHAR2

An application controlled field showing the userid of the person inserting a record

100

CREATED_DATE

DATE

An application controlled field showing the date and time the record was inserted into the Oracle table

100

MODIFIED_BY_USER_ID

VARCHAR2

The userid of the last person to edit the data

100

MODIFIED_DATE

DATE

The date of the last update to the record

Attribute Details

STATE

CC ID: 15397

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	2 letter abbreviation for the state issuing the permit.
General Data Type:	VARCHAR2

PERMIT_NUMBER_SUFFIX

CC ID: 15396

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	The numeric part of the suffix. Prefix for all is SPGM-
General Data Type:	VARCHAR2

VESSEL_ID

CC ID: 15395

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Vessel identification number
General Data Type:	VARCHAR2

GSHRLBS

CC ID: 15394

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	Total pounds of Gulf Shrimp harvested by vessel.
General Data Type:	VARCHAR2

GSHRREV

CC ID: 15393

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	Dollar value of Gulf Shrimp harvested by vessel.
General Data Type:	VARCHAR2

SPANISH

CC ID: 15392

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	1 = Desire survey forms in Spanish language.
General Data Type:	VARCHAR2

VIETNAMESE

CC ID: 15391

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	1 = Desire survey forms in Vietnamese language.
General Data Type:	VARCHAR2

VESSEL_NAME

CC ID: 15390

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	40
Required:	No
Primary Key:	No
Status:	Active
Description:	The name of the vessel
General Data Type:	VARCHAR2

PERMIT_NUMBER

CC ID: 15389

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	9
Required:	No
Primary Key:	No
Status:	Active
Description:	The permit number authorizing vessel to catch and sell shrimp.
General Data Type:	VARCHAR2

PRIMARY_MAILING_RECIPIENT

CC ID: 15388

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	The name of the primary permit holder. It can be an individual or a company.
General Data Type:	VARCHAR2

STREET_ADDRESS

CC ID: 15387

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	40
Required:	No
Primary Key:	No
Status:	Active
Description:	The street address of the primary mailing recipient.
General Data Type:	VARCHAR2

CITY

CC ID: 15386

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	The city where the primary mailing recipient receives mail.
General Data Type:	VARCHAR2

MAILING_STATE

CC ID: 15385

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	The state where the primary mailing recipient receives mail.
General Data Type:	VARCHAR2

ZIP_CODE

CC ID: 15384

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	9
Required:	No
Primary Key:	No
Status:	Active
Description:	The zip code of the primary mailing recipient.
General Data Type:	VARCHAR2

PHONE_NUMBER

CC ID: 15383

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	The phone number of the primary mailing recipient.
General Data Type:	VARCHAR2

BUSINESS_RELATIONSHIP

CC ID: 15382

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	When multiple people share a permit, their position is listed here, Examples are PRESIDENT, SECRETARY, TREASURER, etc.
General Data Type:	VARCHAR2

BUSINESS_ASSOCIATE_LNAME

CC ID: 15381

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	40
Required:	No
Primary Key:	No
Status:	Active
Description:	Business associates last name.
General Data Type:	VARCHAR2

BUSINESS_ASSOCIATE_FNAME

CC ID: 15380

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	25
Required:	No
Primary Key:	No
Status:	Active
Description:	Business associates first name.
General Data Type:	VARCHAR2

BUSINESS_ASSOCIATE_PHONE

CC ID: 15379

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Business associates phone number.
General Data Type:	VARCHAR2

HOMEPORT_CITY

CC ID: 15378

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	The home port city of the permit holder.
General Data Type:	VARCHAR2

HOMEPORT_STATE

CC ID: 15377

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	The home port state of the permit holder.
General Data Type:	VARCHAR2

ACTIVE_YEAR

CC ID: 15376

Seq. Order:	22
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	The survey year this entry will be used for.
General Data Type:	NUMBER

CREATED_BY_USER_ID

CC ID: 15375

Seq. Order:	23
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	An application controlled field showing the userid of the person inserting a record
General Data Type:	VARCHAR2

CREATED_DATE

CC ID: 15374

Seq. Order:	24
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	An application controlled field showing the date and time the record was inserted into the Oracle table
General Data Type:	DATE

MODIFIED_BY_USER_ID

CC ID: 15373

Seq. Order:	25
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	The userid of the last person to edit the data
General Data Type:	VARCHAR2

MODIFIED_DATE

CC ID: 15372

Seq. Order:	26
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	The date of the last update to the record
General Data Type:	DATE

Catalog Item ID:	5288
GUID:	gov.noaa.nmfs.inport:5288
Metadata Record Created By:	Lee M Weinberger
Metadata Record Created:	2007-10-10 10:43+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+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: SAMPLE_PERMIT_OWNER

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

STATE

PERMIT_NUMBER_SUFFIX

VESSEL_ID

GSHRLBS

GSHRREV

SPANISH

VIETNAMESE

VESSEL_NAME

PERMIT_NUMBER

PRIMARY_MAILING_RECIPIENT

STREET_ADDRESS

CITY

MAILING_STATE

ZIP_CODE

PHONE_NUMBER

BUSINESS_RELATIONSHIP

BUSINESS_ASSOCIATE_LNAME

BUSINESS_ASSOCIATE_FNAME

BUSINESS_ASSOCIATE_PHONE

HOMEPORT_CITY

HOMEPORT_STATE

ACTIVE_YEAR

CREATED_BY_USER_ID

CREATED_DATE

MODIFIED_BY_USER_ID

MODIFIED_DATE

Catalog Details