Table: ANNUAL_ECONOMIC_SURVEY
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:5283 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | Table: ANNUAL_ECONOMIC_SURVEY |
---|---|
Short Name: | ANNUAL_ECONOMIC_SURVEY |
Status: | Completed |
Abstract: |
The main data table with financial details on the permit holders total annual fishing expenses |
Notes: |
Loaded by batch 1643, 10-10-2007 10:43 |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
UNCONTROLLED | |
None | annual costs |
None | annual profits |
None | annual revenue |
None | cultural data |
None | economic data |
None | permits |
None | shrimp |
Temporal Keywords
Thesaurus | Keyword |
---|---|
UNCONTROLLED | |
None | 2005-PRESENT |
Spatial Keywords
Thesaurus | Keyword |
---|---|
UNCONTROLLED | |
None | ALABAMA |
None | FLORIDA |
None | Gulf Of Mexico |
None | LOUISIANA |
None | MISSISSIPPI |
None | TEXAS |
Stratum Keywords
Thesaurus | Keyword |
---|---|
UNCONTROLLED | |
None | equipment expense |
None | fuel cost |
None | fuel expense |
None | hurricane repair expense |
None | ice expense |
None | insurance expense |
None | permit |
None | vessel |
Physical Location
Organization: | Southeast Fisheries Science Center |
---|---|
City: | Miami |
State/Province: | FL |
Country: | USA |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | EC_SRV_GS |
Description: |
The main data table with financial details on the permit holders total annual fishing expenses |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
YEAR | NUMBER | The fishing year for the reported expenses. | |
100
|
ID | NUMBER | An artificial key to identify an individual record. | |
100
|
PERMIT_OWNER_NAME | VARCHAR2 | The name of the permit owner. | |
100
|
PERMIT_NUMBER | VARCHAR2 | The permit number includes the prefix SPGM- | |
100
|
VESSEL_NAME | VARCHAR2 | The name of the vessel. | |
100
|
VESSEL_ID | VARCHAR2 | The code used to identify the vessel. | |
100
|
PAID_TO_CREW | NUMBER | Total amount paid to crew for the year. | |
100
|
OWNER_IS_CAPTAIN | NUMBER | 1 = The owner is also the captain of this vessel, otherwise 0. | |
100
|
OWNER_IS_PAID_CAPTAIN_SHARE | NUMBER | 1 = the owner paid a captain's share? | |
100
|
CAPTAIN_SHARE | NUMBER | The total annual captain's payment when the captain is paid a captain's share. | |
100
|
COMBINED_CREW_EXPENSE | NUMBER | The combined expense for captain and crew for the year when the owner is not the captain. | |
100
|
FUEL_EXPENSE | NUMBER | Total amount paid for fuel (including amounts paid by crew and captain) for the year | |
100
|
AVG_PRICE_FUEL_PER_GAL | NUMBER | Average price of fuel for the year | |
100
|
GALLONS_OF_FUEL_PURCHASED | NUMBER | Total amount of fuel purchased for the year | |
100
|
ICE_EXPENSE | NUMBER | Total amount paid for purchased ice (including amounts paid by crew and captain) for the year | |
100
|
OTHER_TRIP_EXPENSES | NUMBER | Total annual amount paid for all other trip related supplies or expenses (excluding salaries, fuel and ice; including amounts paid by crew and captain) | |
100
|
EQUIPMENT_EXPENSES | NUMBER | Total annual amount paid for any vessel, engine, gear or other equipment (including electronics ) maintenance, repair, replacement, upgrade or new purchase | |
100
|
HAD_NO_MAJOR_EXPENSES | NUMBER | 1 = Fisher had no major, infrequent or irregular expenses | |
100
|
HAD_HAUL_OUT_OR_DRY_DOCK | NUMBER | Fisher had haul out or dry dock expense during the year. | |
100
|
HAD_NEW_PURCHASE_OR_UPGRADE | NUMBER | Fisher had a new purchase or upgrade expense during the year. | |
100
|
HAD_HURRICANE_REPAIR | NUMBER | Fisher had hurricane repairs during the year. | |
100
|
HAD_OTHER_REPAIR | NUMBER | Fisher had other repair or replacement expenses during the year | |
100
|
HAD_OTHER_MAJOR_EXPENSE | NUMBER | Fisher had other major, infrequent or irregular expenses during the year. | |
100
|
OVERHEAD_FOR_VESSEL | NUMBER | Annual overhead applicable to this vessel (including loan payments and vessel insurance; excluding depreciation, income taxes) | |
100
|
TOTAL_ANNUAL_EXPENSE | NUMBER | The sum of the other itemized annual expenses. | |
100
|
HAS_INSURANCE | NUMBER | 1 = Fisher had some insurance on the vessel during the year | |
100
|
HAS_INSURANCE_ON_HULL | NUMBER | 1 = Fisher had some insurance on the hull during the year | |
100
|
HAS_P_AND_I_INSURANCE | NUMBER | 1 = Fisher has P and I insurance. Protection and indemnity insurance covering the vessel owners against their liability for damage to cargo in their care and custody; death or injury to passengers, crew, cargo loaders, and others; damage caused to piers, docks, underwater cables, and bridges; and, more recently, damage caused by pollution. | |
100
|
HAS_OTHER_VESSEL_INSURANCE | NUMBER | 1 = Fisher has other vessel insurance | |
100
|
TOTAL_VESSEL_COVERAGE | NUMBER | Total amount vessel is insured for | |
100
|
MARKET_VALUE_OF_VESSEL | NUMBER | Market value of vessel (anytime in the year): | |
100
|
REPLACEMENT_VALUE_OF_VESSEL | NUMBER | Cost to replace the vessel | |
100
|
ORIGINAL_PURCHASE_PRICE | NUMBER | The original purchase price of the vessel | |
100
|
HAD_LOAN_DURING_YEAR | NUMBER | 1 = Had a loan anytime during the year | |
100
|
PRINCIPAL_REMAINING | NUMBER | The principal remaining at the end of the year | |
100
|
TOTAL_LOAN_PAYMENTS | NUMBER | Total loan payments during the year | |
100
|
INTEREST_PAID | NUMBER | Total interest paid during the year | |
100
|
PRINCIPAL_PAID | NUMBER | Total principal paid during the year | |
100
|
DEPRECIATION_VESSEL_MACHINERY | NUMBER | Depreciation of vessel and machinery as claimed for tax purposes for the year | |
100
|
FISHING_DAYS_LOST | NUMBER | Total days of fishing lost by this vessel due to a lack of crew | |
100
|
GROSS_REVENUE_NON_SHRIMP | NUMBER | Total gross revenue generated by this vessel in commercial fisheries other than shrimp during the year | |
100
|
GOVERNMENT_PAYMENTS | NUMBER | Government payments received due to imports and low shrimp prices (tariff money; trade assistance adjustment payments, etc) and disaster relief (hurricanes) for the year | |
100
|
USE_ANOTHER_LANGUAGE | NUMBER | 1 = Use another language beside English for the survey; 0 = Use English | |
100
|
USE_SPANISH_LANGUAGE | NUMBER | 1 = Fisher requested a survey in Spanish | |
100
|
USE_VIETNAMESE_LANGUAGE | NUMBER | 1 = Fisher requested a survey in Vietnamese | |
100
|
PRINTED_NAME_OF_SIGNER | VARCHAR2 | The printed name of the person submitting the survey | |
100
|
PHONE_NUMBER_OF_SIGNER | VARCHAR2 | The primary contact phone number | |
100
|
HAS_PERMIT_OWNER_COMMENTS | NUMBER | 1 = Permit owner has provided comments | |
100
|
DATA_ENTRY_COMMENTS | VARCHAR2 | Comments by the data entry person | |
100
|
QUALITY_OF_ENTRY | NUMBER | Data entry person's judgement of data quality: 1 = Good, 2 = Fair, 3 = Poor | |
100
|
WAS_EDITED | NUMBER | 1 = Data manager edited the record in a non-trivial way | |
100
|
WAS_SHRIMPING | NUMBER | 1 = Fisher reported shrimping during the year | |
100
|
IS_COMPLETE | NUMBER | 1 if all required information was provided, otherwise 0 | |
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 | |
100
|
PERMIT_OWNER_COMMENTS | VARCHAR2 | The analyst's summary of the fisher's comments | |
100
|
ALTERNATE_PHONE_NUMBER | VARCHAR2 | A second phone number fo the fisher |
Attribute Details
YEAR
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The fishing year for the reported expenses. |
General Data Type: | NUMBER |
ID
Seq. Order: | 2 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 38 |
Status: | Active |
Description: |
An artificial key to identify an individual record. |
General Data Type: | NUMBER |
PERMIT_OWNER_NAME
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 80 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
The name of the permit owner. |
General Data Type: | VARCHAR2 |
PERMIT_NUMBER
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The permit number includes the prefix SPGM- |
General Data Type: | VARCHAR2 |
VESSEL_NAME
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The name of the vessel. |
General Data Type: | VARCHAR2 |
VESSEL_ID
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The code used to identify the vessel. |
General Data Type: | VARCHAR2 |
PAID_TO_CREW
Seq. Order: | 7 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Total amount paid to crew for the year. |
General Data Type: | NUMBER |
OWNER_IS_CAPTAIN
Seq. Order: | 8 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
1 = The owner is also the captain of this vessel, otherwise 0. |
General Data Type: | NUMBER |
OWNER_IS_PAID_CAPTAIN_SHARE
Seq. Order: | 9 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
1 = the owner paid a captain's share? |
General Data Type: | NUMBER |
CAPTAIN_SHARE
Seq. Order: | 10 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The total annual captain's payment when the captain is paid a captain's share. |
General Data Type: | NUMBER |
COMBINED_CREW_EXPENSE
Seq. Order: | 11 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The combined expense for captain and crew for the year when the owner is not the captain. |
General Data Type: | NUMBER |
FUEL_EXPENSE
Seq. Order: | 12 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Total amount paid for fuel (including amounts paid by crew and captain) for the year |
General Data Type: | NUMBER |
AVG_PRICE_FUEL_PER_GAL
Seq. Order: | 13 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Average price of fuel for the year |
General Data Type: | NUMBER |
GALLONS_OF_FUEL_PURCHASED
Seq. Order: | 14 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Total amount of fuel purchased for the year |
General Data Type: | NUMBER |
ICE_EXPENSE
Seq. Order: | 15 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Total amount paid for purchased ice (including amounts paid by crew and captain) for the year |
General Data Type: | NUMBER |
OTHER_TRIP_EXPENSES
Seq. Order: | 16 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Total annual amount paid for all other trip related supplies or expenses (excluding salaries, fuel and ice; including amounts paid by crew and captain) |
General Data Type: | NUMBER |
EQUIPMENT_EXPENSES
Seq. Order: | 17 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Total annual amount paid for any vessel, engine, gear or other equipment (including electronics ) maintenance, repair, replacement, upgrade or new purchase |
General Data Type: | NUMBER |
HAD_NO_MAJOR_EXPENSES
Seq. Order: | 18 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
1 = Fisher had no major, infrequent or irregular expenses |
General Data Type: | NUMBER |
HAD_HAUL_OUT_OR_DRY_DOCK
Seq. Order: | 19 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
Fisher had haul out or dry dock expense during the year. |
General Data Type: | NUMBER |
HAD_NEW_PURCHASE_OR_UPGRADE
Seq. Order: | 20 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
Fisher had a new purchase or upgrade expense during the year. |
General Data Type: | NUMBER |
HAD_HURRICANE_REPAIR
Seq. Order: | 21 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
Fisher had hurricane repairs during the year. |
General Data Type: | NUMBER |
HAD_OTHER_REPAIR
Seq. Order: | 22 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
Fisher had other repair or replacement expenses during the year |
General Data Type: | NUMBER |
HAD_OTHER_MAJOR_EXPENSE
Seq. Order: | 23 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
Fisher had other major, infrequent or irregular expenses during the year. |
General Data Type: | NUMBER |
OVERHEAD_FOR_VESSEL
Seq. Order: | 24 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Annual overhead applicable to this vessel (including loan payments and vessel insurance; excluding depreciation, income taxes) |
General Data Type: | NUMBER |
TOTAL_ANNUAL_EXPENSE
Seq. Order: | 25 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The sum of the other itemized annual expenses. |
General Data Type: | NUMBER |
HAS_INSURANCE
Seq. Order: | 26 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
1 = Fisher had some insurance on the vessel during the year |
General Data Type: | NUMBER |
HAS_INSURANCE_ON_HULL
Seq. Order: | 27 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
1 = Fisher had some insurance on the hull during the year |
General Data Type: | NUMBER |
HAS_P_AND_I_INSURANCE
Seq. Order: | 28 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
1 = Fisher has P and I insurance. Protection and indemnity insurance covering the vessel owners against their liability for damage to cargo in their care and custody; death or injury to passengers, crew, cargo loaders, and others; damage caused to piers, docks, underwater cables, and bridges; and, more recently, damage caused by pollution. |
General Data Type: | NUMBER |
HAS_OTHER_VESSEL_INSURANCE
Seq. Order: | 29 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
1 = Fisher has other vessel insurance |
General Data Type: | NUMBER |
TOTAL_VESSEL_COVERAGE
Seq. Order: | 30 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Total amount vessel is insured for |
General Data Type: | NUMBER |
MARKET_VALUE_OF_VESSEL
Seq. Order: | 31 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Market value of vessel (anytime in the year): |
General Data Type: | NUMBER |
REPLACEMENT_VALUE_OF_VESSEL
Seq. Order: | 32 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Cost to replace the vessel |
General Data Type: | NUMBER |
ORIGINAL_PURCHASE_PRICE
Seq. Order: | 33 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The original purchase price of the vessel |
General Data Type: | NUMBER |
HAD_LOAN_DURING_YEAR
Seq. Order: | 34 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
1 = Had a loan anytime during the year |
General Data Type: | NUMBER |
PRINCIPAL_REMAINING
Seq. Order: | 35 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The principal remaining at the end of the year |
General Data Type: | NUMBER |
TOTAL_LOAN_PAYMENTS
Seq. Order: | 36 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Total loan payments during the year |
General Data Type: | NUMBER |
INTEREST_PAID
Seq. Order: | 37 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Total interest paid during the year |
General Data Type: | NUMBER |
PRINCIPAL_PAID
Seq. Order: | 38 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Total principal paid during the year |
General Data Type: | NUMBER |
DEPRECIATION_VESSEL_MACHINERY
Seq. Order: | 39 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Depreciation of vessel and machinery as claimed for tax purposes for the year |
General Data Type: | NUMBER |
FISHING_DAYS_LOST
Seq. Order: | 40 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Total days of fishing lost by this vessel due to a lack of crew |
General Data Type: | NUMBER |
GROSS_REVENUE_NON_SHRIMP
Seq. Order: | 41 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Total gross revenue generated by this vessel in commercial fisheries other than shrimp during the year |
General Data Type: | NUMBER |
GOVERNMENT_PAYMENTS
Seq. Order: | 42 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Government payments received due to imports and low shrimp prices (tariff money; trade assistance adjustment payments, etc) and disaster relief (hurricanes) for the year |
General Data Type: | NUMBER |
USE_ANOTHER_LANGUAGE
Seq. Order: | 43 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
1 = Use another language beside English for the survey; 0 = Use English |
General Data Type: | NUMBER |
USE_SPANISH_LANGUAGE
Seq. Order: | 44 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
1 = Fisher requested a survey in Spanish |
General Data Type: | NUMBER |
USE_VIETNAMESE_LANGUAGE
Seq. Order: | 45 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
1 = Fisher requested a survey in Vietnamese |
General Data Type: | NUMBER |
PRINTED_NAME_OF_SIGNER
Seq. Order: | 46 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 80 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The printed name of the person submitting the survey |
General Data Type: | VARCHAR2 |
PHONE_NUMBER_OF_SIGNER
Seq. Order: | 47 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The primary contact phone number |
General Data Type: | VARCHAR2 |
HAS_PERMIT_OWNER_COMMENTS
Seq. Order: | 48 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
1 = Permit owner has provided comments |
General Data Type: | NUMBER |
DATA_ENTRY_COMMENTS
Seq. Order: | 49 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2000 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Comments by the data entry person |
General Data Type: | VARCHAR2 |
QUALITY_OF_ENTRY
Seq. Order: | 50 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
Data entry person's judgement of data quality: 1 = Good, 2 = Fair, 3 = Poor |
General Data Type: | NUMBER |
WAS_EDITED
Seq. Order: | 51 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
1 = Data manager edited the record in a non-trivial way |
General Data Type: | NUMBER |
WAS_SHRIMPING
Seq. Order: | 52 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
1 = Fisher reported shrimping during the year |
General Data Type: | NUMBER |
IS_COMPLETE
Seq. Order: | 53 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
1 if all required information was provided, otherwise 0 |
General Data Type: | NUMBER |
CREATED_BY_USER_ID
Seq. Order: | 54 |
---|---|
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
Seq. Order: | 55 |
---|---|
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
Seq. Order: | 56 |
---|---|
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
Seq. Order: | 57 |
---|---|
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 |
PERMIT_OWNER_COMMENTS
Seq. Order: | 58 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2000 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The analyst's summary of the fisher's comments |
General Data Type: | VARCHAR2 |
ALTERNATE_PHONE_NUMBER
Seq. Order: | 59 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
A second phone number fo the fisher |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 5283 |
---|---|
GUID: | gov.noaa.nmfs.inport:5283 |
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 |