Table: SAMPLE_PERMIT_OWNER
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:5288 | Updated: August 9, 2022 | Published / External
Item Identification
| 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 Information
| Entity Type: | Data Table |
|---|---|
| Active Version?: | Yes |
| Schema Name: | EC_SRV_GS |
| Description: |
A lookup table of permit owner names and their vessels. |
Data Attributes
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 |
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 Details
| 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 |