Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Social Science Research Group Projects > Trip Cost Data > SSRG Socioeconomic Panel >

View: EDC_TRIP_COST_DATA_EXT_VW

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

Summary

Abstract

Contains cost,vessel,location per set trip record all in the same record

Description

Contains cost,vessel,location per set trip record all in the same record

Entity Information

Entity Type
Data View

Data Attribute / Type Description
LOGBOOK_KEY
NUMBER 		Foreign key to the FLS_TRIPS table, thus identifying the trip which costs are being described.
BATCH_NUMBER
VARCHAR2 		Batch Number
SCHEDULE_NUMBER
VARCHAR2 		Schedule Number
VESSEL_ID
VARCHAR2 		State Registration Number or Federal Vessel Identiification Number
VESSEL_NAME
VARCHAR2 		Vessel Name
TELEPHONE
VARCHAR2 		Phone Number To Contact Vessel
DAYS_AWAY
VARCHAR2 		Number Of Days Fishing
START_DATE
VARCHAR2 		Start Date Of FIshing Trip
NUMBER_OF_CREW
VARCHAR2 		Number Of Crew On Boat
UNLOAD_DATE
VARCHAR2 		Date Catch Was Unloaded
TRIP_TICKET
VARCHAR2 		Trip Ticket Number
OWNER_ABOARD
VARCHAR2 		Was the Owner Aboard?
OWNER_SALARY_INCLUDED
VARCHAR2 		Was the owner's salary included?
OWNER_SHARE
VARCHAR2 		Owner's share of the revenue.
OWNER_SHARE_PERCENT
VARCHAR2 		Owner Share Percent
CAPTAIN_SHARE
VARCHAR2 		Captain's share of the revenue.
CAPTAIN_SHARE_PERCENT
VARCHAR2 		Captain Share Percent
AVG_CREW_SHARE
VARCHAR2 		Average share for the revenue for crew members.
AVG_CREW_SHARE_PERCENT
VARCHAR2 		Average Crew Share Percent
FUEL
VARCHAR2 		Amount of fuel used during the trip.
FUEL_UNIT_PRICE
VARCHAR2 		Fuel Unit Price
FUEL_COST
VARCHAR2 		Cost of the fuel.
BAIT_UNIT_PRICE
VARCHAR2 		Bait Unit Price
BAIT_MSU
VARCHAR2 		Measurement uint in which the bait was weighed.Domain: G - Grams OZ - Ounces LB - Pounds KG - Kilograms T - Tons
BAIT_WEIGHT
VARCHAR2 		Weight of the bait.
BAIT_COUNT
VARCHAR2 		How many units of bait were used
BAIT_COST
VARCHAR2 		Cost of bait purchased.
BAIT2_UNIT_PRICE
VARCHAR2 		Secondary /Second Bait Unit Price
BAIT2_MSU
VARCHAR2 		Measured Standard Units For Seconday/second Bait
BAIT2_WEIGHT
VARCHAR2 		Weight Of Secondary/Second Bait
BAIT2_COUNT
VARCHAR2 		How Many Units Of second/secondary bait were used
BAIT2_COST
VARCHAR2 		Secondary/Second Bait Cost
ICE_WEIGHT
VARCHAR2 		Weight of ice purchased.
ICE_UNIT_PRICE
VARCHAR2 		Ice Unit Price
ICE_COUNT
VARCHAR2 		Quantity of Ice Used
ICE_COST
VARCHAR2 		Cost of ice
ICE_MSU
VARCHAR2 		Measurement unit for the amount of ice used.Domain: TONS, BLOCK, POUND, UNKN (Unknown)
ICE_TIME_FRAME
VARCHAR2 		Time Frame For Ice To Last
LIGHT_STICK_NUMBER
VARCHAR2 		Number of light sticks used.
COST_PER_LIGHT_STICK
VARCHAR2 		Cost of each light stick.
GROCERIES_EXPENSES
VARCHAR2 		Total cost of groceries used during the trip.
OTHER_EXPENSES
VARCHAR2 		Other Expenses
TOTAL_SHARE_COST
VARCHAR2 		Total Share Cost
TOTAL_TRIP_COST
VARCHAR2 		Total expenses for the trip.
FREIGHT_COST
VARCHAR2 		Cost of freight.
DOCKING_UNLOADING_FEE
VARCHAR2 		Docking Unloading Fee.
TACKLE_GEAR_EXPENSES
VARCHAR2 		Tackle Gear Expenses
TRIP_GROCERY_EXPENSE
VARCHAR2 		Grocery Expenses Per Trip
MISC_EXPENSE
VARCHAR2 		Miscellaneous Expenses Per Trip
TOTAL_TRIP_REVENUE
VARCHAR2 		Total Trip Revenue
PERSON_ID
NUMBER 		Person ID. By Cassio on 6/2/2006 - For EDC
CHANGE_REASON_ID
NUMBER 		Key to why reason was changed. By Cassio on 6/2/2006 - For EDC
LU
DATE 		When Records was last updated By Cassio on 6/2/2006 - For EDC
TABLE_NAME
VARCHAR2 		Oracle Table which serves as a source for this record
GEAR_CODE_NMFS
VARCHAR2 		NMFS Gear Code
STATE_CODE_NMFS
VARCHAR2 		NMFS State Code
COUNTY_CODE_NMFS
VARCHAR2 		NMFS County Code

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: View: EDC_TRIP_COST_DATA_EXT_VW
Short Name: EDC_TRIP_COST_DATA_EXT_VW
Status: Completed
Abstract:

Contains cost,vessel,location per set trip record all in the same record
Notes:

Loaded by batch 2043, 12-20-2007 08:10

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: FLS
Description:

Contains cost,vessel,location per set trip record all in the same record

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 LOGBOOK_KEY NUMBER Foreign key to the FLS_TRIPS table, thus identifying the trip which costs are being described.
100
 BATCH_NUMBER VARCHAR2 Batch Number
100
 SCHEDULE_NUMBER VARCHAR2 Schedule Number
100
 VESSEL_ID VARCHAR2 State Registration Number or Federal Vessel Identiification Number
100
 VESSEL_NAME VARCHAR2 Vessel Name
100
 TELEPHONE VARCHAR2 Phone Number To Contact Vessel
100
 DAYS_AWAY VARCHAR2 Number Of Days Fishing
100
 START_DATE VARCHAR2 Start Date Of FIshing Trip
100
 NUMBER_OF_CREW VARCHAR2 Number Of Crew On Boat
100
 UNLOAD_DATE VARCHAR2 Date Catch Was Unloaded
100
 TRIP_TICKET VARCHAR2 Trip Ticket Number
100
 OWNER_ABOARD VARCHAR2 Was the Owner Aboard?
100
 OWNER_SALARY_INCLUDED VARCHAR2 Was the owner's salary included?
100
 OWNER_SHARE VARCHAR2 Owner's share of the revenue.
100
 OWNER_SHARE_PERCENT VARCHAR2 Owner Share Percent
100
 CAPTAIN_SHARE VARCHAR2 Captain's share of the revenue.
100
 CAPTAIN_SHARE_PERCENT VARCHAR2 Captain Share Percent
100
 AVG_CREW_SHARE VARCHAR2 Average share for the revenue for crew members.
100
 AVG_CREW_SHARE_PERCENT VARCHAR2 Average Crew Share Percent
100
 FUEL VARCHAR2 Amount of fuel used during the trip.
100
 FUEL_UNIT_PRICE VARCHAR2 Fuel Unit Price
100
 FUEL_COST VARCHAR2 Cost of the fuel.
100
 BAIT_UNIT_PRICE VARCHAR2 Bait Unit Price
100
 BAIT_MSU VARCHAR2 Measurement uint in which the bait was weighed.Domain: G - Grams OZ - Ounces LB - Pounds KG - Kilograms T - Tons
100
 BAIT_WEIGHT VARCHAR2 Weight of the bait.
100
 BAIT_COUNT VARCHAR2 How many units of bait were used
100
 BAIT_COST VARCHAR2 Cost of bait purchased.
100
 BAIT2_UNIT_PRICE VARCHAR2 Secondary /Second Bait Unit Price
100
 BAIT2_MSU VARCHAR2 Measured Standard Units For Seconday/second Bait
100
 BAIT2_WEIGHT VARCHAR2 Weight Of Secondary/Second Bait
100
 BAIT2_COUNT VARCHAR2 How Many Units Of second/secondary bait were used
100
 BAIT2_COST VARCHAR2 Secondary/Second Bait Cost
100
 ICE_WEIGHT VARCHAR2 Weight of ice purchased.
100
 ICE_UNIT_PRICE VARCHAR2 Ice Unit Price
100
 ICE_COUNT VARCHAR2 Quantity of Ice Used
100
 ICE_COST VARCHAR2 Cost of ice
100
 ICE_MSU VARCHAR2 Measurement unit for the amount of ice used.Domain: TONS, BLOCK, POUND, UNKN (Unknown)
100
 ICE_TIME_FRAME VARCHAR2 Time Frame For Ice To Last
100
 LIGHT_STICK_NUMBER VARCHAR2 Number of light sticks used.
100
 COST_PER_LIGHT_STICK VARCHAR2 Cost of each light stick.
100
 GROCERIES_EXPENSES VARCHAR2 Total cost of groceries used during the trip.
100
 OTHER_EXPENSES VARCHAR2 Other Expenses
100
 TOTAL_SHARE_COST VARCHAR2 Total Share Cost
100
 TOTAL_TRIP_COST VARCHAR2 Total expenses for the trip.
100
 FREIGHT_COST VARCHAR2 Cost of freight.
100
 DOCKING_UNLOADING_FEE VARCHAR2 Docking Unloading Fee.
100
 TACKLE_GEAR_EXPENSES VARCHAR2 Tackle Gear Expenses
100
 TRIP_GROCERY_EXPENSE VARCHAR2 Grocery Expenses Per Trip
100
 MISC_EXPENSE VARCHAR2 Miscellaneous Expenses Per Trip
100
 TOTAL_TRIP_REVENUE VARCHAR2 Total Trip Revenue
100
 PERSON_ID NUMBER Person ID. By Cassio on 6/2/2006 - For EDC
100
 CHANGE_REASON_ID NUMBER Key to why reason was changed. By Cassio on 6/2/2006 - For EDC
100
 LU DATE When Records was last updated By Cassio on 6/2/2006 - For EDC
100
 TABLE_NAME VARCHAR2 Oracle Table which serves as a source for this record
100
 GEAR_CODE_NMFS VARCHAR2 NMFS Gear Code
100
 STATE_CODE_NMFS VARCHAR2 NMFS State Code
100
 COUNTY_CODE_NMFS VARCHAR2 NMFS County Code

Attribute Details

LOGBOOK_KEY

CC ID: 24651
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Foreign key to the FLS_TRIPS table, thus identifying the trip which costs are being described.
General Data Type: NUMBER

BATCH_NUMBER

CC ID: 24679
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Batch Number
General Data Type: VARCHAR2

SCHEDULE_NUMBER

CC ID: 24654
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Schedule Number
General Data Type: VARCHAR2

VESSEL_ID

CC ID: 24669
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

State Registration Number or Federal Vessel Identiification Number
General Data Type: VARCHAR2

VESSEL_NAME

CC ID: 24658
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Vessel Name
General Data Type: VARCHAR2

TELEPHONE

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

Phone Number To Contact Vessel
General Data Type: VARCHAR2

DAYS_AWAY

CC ID: 24681
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Number Of Days Fishing
General Data Type: VARCHAR2

START_DATE

CC ID: 24661
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Start Date Of FIshing Trip
General Data Type: VARCHAR2

NUMBER_OF_CREW

CC ID: 24672
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Number Of Crew On Boat
General Data Type: VARCHAR2

UNLOAD_DATE

CC ID: 24648
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Date Catch Was Unloaded
General Data Type: VARCHAR2

TRIP_TICKET

CC ID: 24666
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

Trip Ticket Number
General Data Type: VARCHAR2

OWNER_ABOARD

CC ID: 24676
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Was the Owner Aboard?
General Data Type: VARCHAR2

OWNER_SALARY_INCLUDED

CC ID: 24638
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Was the owner's salary included?
General Data Type: VARCHAR2

OWNER_SHARE

CC ID: 24682
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Owner's share of the revenue.
General Data Type: VARCHAR2

OWNER_SHARE_PERCENT

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

Owner Share Percent
General Data Type: VARCHAR2

CAPTAIN_SHARE

CC ID: 24675
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Captain's share of the revenue.
General Data Type: VARCHAR2

CAPTAIN_SHARE_PERCENT

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

Captain Share Percent
General Data Type: VARCHAR2

AVG_CREW_SHARE

CC ID: 24663
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Average share for the revenue for crew members.
General Data Type: VARCHAR2

AVG_CREW_SHARE_PERCENT

CC ID: 24642
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Average Crew Share Percent
General Data Type: VARCHAR2

FUEL

CC ID: 24664
Seq. Order: 20
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Amount of fuel used during the trip.
General Data Type: VARCHAR2

FUEL_UNIT_PRICE

CC ID: 24657
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Fuel Unit Price
General Data Type: VARCHAR2

FUEL_COST

CC ID: 24673
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Cost of the fuel.
General Data Type: VARCHAR2

BAIT_UNIT_PRICE

CC ID: 24653
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Bait Unit Price
General Data Type: VARCHAR2

BAIT_MSU

CC ID: 24637
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Measurement uint in which the bait was weighed.Domain: G - Grams OZ - Ounces LB - Pounds KG - Kilograms T - Tons
General Data Type: VARCHAR2

BAIT_WEIGHT

CC ID: 24674
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Weight of the bait.
General Data Type: VARCHAR2

BAIT_COUNT

CC ID: 24647
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

How many units of bait were used
General Data Type: VARCHAR2

BAIT_COST

CC ID: 24649
Seq. Order: 27
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Cost of bait purchased.
General Data Type: VARCHAR2

BAIT2_UNIT_PRICE

CC ID: 24631
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Secondary /Second Bait Unit Price
General Data Type: VARCHAR2

BAIT2_MSU

CC ID: 24668
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Measured Standard Units For Seconday/second Bait
General Data Type: VARCHAR2

BAIT2_WEIGHT

CC ID: 24644
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Weight Of Secondary/Second Bait
General Data Type: VARCHAR2

BAIT2_COUNT

CC ID: 24678
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

How Many Units Of second/secondary bait were used
General Data Type: VARCHAR2

BAIT2_COST

CC ID: 24660
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Secondary/Second Bait Cost
General Data Type: VARCHAR2

ICE_WEIGHT

CC ID: 24641
Seq. Order: 33
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Weight of ice purchased.
General Data Type: VARCHAR2

ICE_UNIT_PRICE

CC ID: 24632
Seq. Order: 34
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Ice Unit Price
General Data Type: VARCHAR2

ICE_COUNT

CC ID: 24635
Seq. Order: 35
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Quantity of Ice Used
General Data Type: VARCHAR2

ICE_COST

CC ID: 24634
Seq. Order: 36
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Cost of ice
General Data Type: VARCHAR2

ICE_MSU

CC ID: 24686
Seq. Order: 37
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Measurement unit for the amount of ice used.Domain: TONS, BLOCK, POUND, UNKN (Unknown)
General Data Type: VARCHAR2

ICE_TIME_FRAME

CC ID: 24662
Seq. Order: 38
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Time Frame For Ice To Last
General Data Type: VARCHAR2

LIGHT_STICK_NUMBER

CC ID: 24665
Seq. Order: 39
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Number of light sticks used.
General Data Type: VARCHAR2

COST_PER_LIGHT_STICK

CC ID: 24646
Seq. Order: 40
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Cost of each light stick.
General Data Type: VARCHAR2

GROCERIES_EXPENSES

CC ID: 24680
Seq. Order: 41
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Total cost of groceries used during the trip.
General Data Type: VARCHAR2

OTHER_EXPENSES

CC ID: 24655
Seq. Order: 42
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Other Expenses
General Data Type: VARCHAR2

TOTAL_SHARE_COST

CC ID: 24643
Seq. Order: 43
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Total Share Cost
General Data Type: VARCHAR2

TOTAL_TRIP_COST

CC ID: 24633
Seq. Order: 44
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Total expenses for the trip.
General Data Type: VARCHAR2

FREIGHT_COST

CC ID: 24645
Seq. Order: 45
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Cost of freight.
General Data Type: VARCHAR2

DOCKING_UNLOADING_FEE

CC ID: 24667
Seq. Order: 46
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Docking Unloading Fee.
General Data Type: VARCHAR2

TACKLE_GEAR_EXPENSES

CC ID: 24685
Seq. Order: 47
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Tackle Gear Expenses
General Data Type: VARCHAR2

TRIP_GROCERY_EXPENSE

CC ID: 24650
Seq. Order: 48
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Grocery Expenses Per Trip
General Data Type: VARCHAR2

MISC_EXPENSE

CC ID: 24659
Seq. Order: 49
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Miscellaneous Expenses Per Trip
General Data Type: VARCHAR2

TOTAL_TRIP_REVENUE

CC ID: 24683
Seq. Order: 50
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Total Trip Revenue
General Data Type: VARCHAR2

PERSON_ID

CC ID: 24671
Seq. Order: 51
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Person ID. By Cassio on 6/2/2006 - For EDC
General Data Type: NUMBER

CHANGE_REASON_ID

CC ID: 24656
Seq. Order: 52
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Key to why reason was changed. By Cassio on 6/2/2006 - For EDC
General Data Type: NUMBER

LU

CC ID: 24677
Seq. Order: 53
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

When Records was last updated By Cassio on 6/2/2006 - For EDC
General Data Type: DATE

TABLE_NAME

CC ID: 24684
Seq. Order: 54
Data Storage Type: VARCHAR2
Max Length: 21
Required: No
Primary Key: No
Status: Active
Description:

Oracle Table which serves as a source for this record
General Data Type: VARCHAR2

GEAR_CODE_NMFS

CC ID: 24670
Seq. Order: 55
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

NMFS Gear Code
General Data Type: VARCHAR2

STATE_CODE_NMFS

CC ID: 24640
Seq. Order: 56
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

NMFS State Code
General Data Type: VARCHAR2

COUNTY_CODE_NMFS

CC ID: 24630
Seq. Order: 57
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

NMFS County Code
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 6861
GUID: gov.noaa.nmfs.inport:6861
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