Table: FLS_COSTS
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:6867 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Data Table containing Cost information by logbook record
DescriptionData Table containing Cost information by logbook record
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
LOGBOOK_KEY
NUMBER |
Foreign key to the FLS_TRIPS table, thus identifying the trip which costs are being described. |
OWNER_SHARE
NUMBER |
Owner's share of the revenue. |
CAPTAIN_SHARE
NUMBER |
Captain's share of the revenue. |
AVG_CREW_SHARE
NUMBER |
Average share for the revenue for crew members. |
FUEL
NUMBER |
Amount of fuel used during the trip. |
FUEL_MSU
VARCHAR2 |
Units used to represent the amount of fuel. |
FUEL_COST
NUMBER |
Cost of the fuel. |
BAIT_WEIGHT
NUMBER |
Weight of the bait. |
BAIT_MSU
VARCHAR2 |
Measurement uint in which the bait was weighed.Domain: G - Grams OZ - Ounces LB - Pounds KG - Kilograms T - Tons |
BAIT_COST
NUMBER |
Cost of bait purchased. |
ICE_WEIGHT
NUMBER |
Weight of ice purchased. |
ICE_MSU
VARCHAR2 |
Measurement unit for the amount of ice used.Domain: TONS, BLOCK, POUND, UNKN (Unknown) |
ICE_COST
NUMBER |
Cost of ice |
LIGHT_STICK_NUMBER
NUMBER |
Number of light sticks used. |
COST_PER_LIGHT_STICK
NUMBER |
Cost of each light stick. |
FREIGHT_COST
NUMBER |
Cost of freight. |
DOCKING_UNLOADING_FEE
NUMBER |
Docking Unloading Fee. |
TACKLE_GEAR_EXPENSES
NUMBER |
Tackle Gear Expenses |
GROCERIES_EXPENSES
NUMBER |
Total cost of groceries used during the trip. |
OTHER_EXPENSES
NUMBER |
Other Expenses |
TOTAL_TRIP_COST
NUMBER |
Total expenses for the trip. |
OWNER_ABOARD
VARCHAR2 |
Was the Owner Aboard? |
OWNER_SALARY_INCLUDED
VARCHAR2 |
Was the owner's salary included? |
OWNER_SHARE_PERCENT
NUMBER |
Owner Share Percent |
CAPTAIN_SHARE_PERCENT
NUMBER |
Captain Share Percent |
AVG_CREW_SHARE_PERCENT
NUMBER |
Average Crew Share Percent |
FUEL_UNIT_PRICE
NUMBER |
Fuel Unit Price |
BAIT_UNIT_PRICE
NUMBER |
Bait Unit Price |
BAIT_COUNT
NUMBER |
How many units of bait were used |
BAIT2_WEIGHT
NUMBER |
Weight Of Secondary/Second Bait |
BAIT2_UNIT_PRICE
NUMBER |
Secondary /Second Bait Unit Price |
BAIT2_COST
NUMBER |
Secondary/Second Bait Cost |
BAIT2_COUNT
NUMBER |
How Many Units Of second/secondary bait were used |
BAIT2_MSU
NUMBER |
Measured Standard Units For Seconday/second Bait |
ICE_UNIT_PRICE
NUMBER |
Ice Unit Price |
ICE_UNIT_PRICE_BLOCK
NUMBER |
Ice Unit Price Per Block |
ICE_COUNT
NUMBER |
Quantity of Ice Used |
ICE_TIME_FRAME
NUMBER |
Time Frame For Ice To Last |
TOTAL_SHARE_COST
NUMBER |
Total Share Cost |
CAPTAIN_LICENSE_STATE
VARCHAR2 |
State where the captain has his license |
CAPTAIN_LICENSE
NUMBER |
Captain License |
BROKER_EXPENSE
NUMBER |
Broker expenses |
BROKER_TRANS_TYPE
VARCHAR2 |
Broker Transaction Type |
BROKER_PERCENT
NUMBER |
Broker Percent |
ICE_MAKER
VARCHAR2 |
Was an ice maker used? |
USED_A_BROKER
VARCHAR2 |
Was a broker used? |
USED_CREW_SHARE_COMP
VARCHAR2 |
Was a set percentage of catch used to calculate crews share of proceeds |
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 |
TRIP_GROCERY_EXPENSE
NUMBER |
Grocery Expenses Per Trip |
MISC_EXPENSE
NUMBER |
Miscellaneous Expenses Per Trip |
TOTAL_TRIP_REVENUE
NUMBER |
Total Trip Revenue |
TOTAL_TRIP_SALES
NUMBER |
TotalTrip Sales |
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: | Table: FLS_COSTS |
---|---|
Short Name: | FLS_COSTS |
Status: | Completed |
Abstract: |
Data Table containing Cost information by logbook record |
Notes: |
Loaded by batch 2043, 12-20-2007 08:10 |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
UNCONTROLLED | |
None | Economic data |
None | Fixed Costs |
None | Grouper |
None | Mackerel |
None | operating costs |
None | Snapper |
None | variable costs |
Spatial Keywords
Thesaurus | Keyword |
---|---|
UNCONTROLLED | |
None | Florida |
None | Georgia |
None | North Carolina |
None | South Carolina |
Stratum Keywords
Thesaurus | Keyword |
---|---|
UNCONTROLLED | |
None | equipment expense |
None | fuel cost |
None | fuel expense |
None | ice expense |
None | nsurance 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: | FLS |
Description: |
Data Table containing Cost information by logbook record |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
LOGBOOK_KEY | NUMBER | Foreign key to the FLS_TRIPS table, thus identifying the trip which costs are being described. | |
100
|
OWNER_SHARE | NUMBER | Owner's share of the revenue. | |
100
|
CAPTAIN_SHARE | NUMBER | Captain's share of the revenue. | |
100
|
AVG_CREW_SHARE | NUMBER | Average share for the revenue for crew members. | |
100
|
FUEL | NUMBER | Amount of fuel used during the trip. | |
100
|
FUEL_MSU | VARCHAR2 | Units used to represent the amount of fuel. | |
100
|
FUEL_COST | NUMBER | Cost of the fuel. | |
100
|
BAIT_WEIGHT | NUMBER | Weight of the bait. | |
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_COST | NUMBER | Cost of bait purchased. | |
100
|
ICE_WEIGHT | NUMBER | Weight of ice purchased. | |
100
|
ICE_MSU | VARCHAR2 | Measurement unit for the amount of ice used.Domain: TONS, BLOCK, POUND, UNKN (Unknown) | |
100
|
ICE_COST | NUMBER | Cost of ice | |
100
|
LIGHT_STICK_NUMBER | NUMBER | Number of light sticks used. | |
100
|
COST_PER_LIGHT_STICK | NUMBER | Cost of each light stick. | |
100
|
FREIGHT_COST | NUMBER | Cost of freight. | |
100
|
DOCKING_UNLOADING_FEE | NUMBER | Docking Unloading Fee. | |
100
|
TACKLE_GEAR_EXPENSES | NUMBER | Tackle Gear Expenses | |
100
|
GROCERIES_EXPENSES | NUMBER | Total cost of groceries used during the trip. | |
100
|
OTHER_EXPENSES | NUMBER | Other Expenses | |
100
|
TOTAL_TRIP_COST | NUMBER | Total expenses for the trip. | |
100
|
OWNER_ABOARD | VARCHAR2 | Was the Owner Aboard? | |
100
|
OWNER_SALARY_INCLUDED | VARCHAR2 | Was the owner's salary included? | |
100
|
OWNER_SHARE_PERCENT | NUMBER | Owner Share Percent | |
100
|
CAPTAIN_SHARE_PERCENT | NUMBER | Captain Share Percent | |
100
|
AVG_CREW_SHARE_PERCENT | NUMBER | Average Crew Share Percent | |
100
|
FUEL_UNIT_PRICE | NUMBER | Fuel Unit Price | |
100
|
BAIT_UNIT_PRICE | NUMBER | Bait Unit Price | |
100
|
BAIT_COUNT | NUMBER | How many units of bait were used | |
100
|
BAIT2_WEIGHT | NUMBER | Weight Of Secondary/Second Bait | |
100
|
BAIT2_UNIT_PRICE | NUMBER | Secondary /Second Bait Unit Price | |
100
|
BAIT2_COST | NUMBER | Secondary/Second Bait Cost | |
100
|
BAIT2_COUNT | NUMBER | How Many Units Of second/secondary bait were used | |
100
|
BAIT2_MSU | NUMBER | Measured Standard Units For Seconday/second Bait | |
100
|
ICE_UNIT_PRICE | NUMBER | Ice Unit Price | |
100
|
ICE_UNIT_PRICE_BLOCK | NUMBER | Ice Unit Price Per Block | |
100
|
ICE_COUNT | NUMBER | Quantity of Ice Used | |
100
|
ICE_TIME_FRAME | NUMBER | Time Frame For Ice To Last | |
100
|
TOTAL_SHARE_COST | NUMBER | Total Share Cost | |
100
|
CAPTAIN_LICENSE_STATE | VARCHAR2 | State where the captain has his license | |
100
|
CAPTAIN_LICENSE | NUMBER | Captain License | |
100
|
BROKER_EXPENSE | NUMBER | Broker expenses | |
100
|
BROKER_TRANS_TYPE | VARCHAR2 | Broker Transaction Type | |
100
|
BROKER_PERCENT | NUMBER | Broker Percent | |
100
|
ICE_MAKER | VARCHAR2 | Was an ice maker used? | |
100
|
USED_A_BROKER | VARCHAR2 | Was a broker used? | |
100
|
USED_CREW_SHARE_COMP | VARCHAR2 | Was a set percentage of catch used to calculate crews share of proceeds | |
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
|
TRIP_GROCERY_EXPENSE | NUMBER | Grocery Expenses Per Trip | |
100
|
MISC_EXPENSE | NUMBER | Miscellaneous Expenses Per Trip | |
100
|
TOTAL_TRIP_REVENUE | NUMBER | Total Trip Revenue | |
100
|
TOTAL_TRIP_SALES | NUMBER | TotalTrip Sales |
Attribute Details
LOGBOOK_KEY
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
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 |
OWNER_SHARE
Seq. Order: | 2 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 2 |
Status: | Active |
Description: |
Owner's share of the revenue. |
General Data Type: | NUMBER |
CAPTAIN_SHARE
Seq. Order: | 3 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 2 |
Status: | Active |
Description: |
Captain's share of the revenue. |
General Data Type: | NUMBER |
AVG_CREW_SHARE
Seq. Order: | 4 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 2 |
Status: | Active |
Description: |
Average share for the revenue for crew members. |
General Data Type: | NUMBER |
FUEL
Seq. Order: | 5 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Amount of fuel used during the trip. |
General Data Type: | NUMBER |
FUEL_MSU
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Units used to represent the amount of fuel. |
General Data Type: | VARCHAR2 |
FUEL_COST
Seq. Order: | 7 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 2 |
Status: | Active |
Description: |
Cost of the fuel. |
General Data Type: | NUMBER |
BAIT_WEIGHT
Seq. Order: | 8 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Weight of the bait. |
General Data Type: | NUMBER |
BAIT_MSU
Seq. Order: | 9 |
---|---|
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_COST
Seq. Order: | 10 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 2 |
Status: | Active |
Description: |
Cost of bait purchased. |
General Data Type: | NUMBER |
ICE_WEIGHT
Seq. Order: | 11 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Weight of ice purchased. |
General Data Type: | NUMBER |
ICE_MSU
Seq. Order: | 12 |
---|---|
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_COST
Seq. Order: | 13 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 2 |
Status: | Active |
Description: |
Cost of ice |
General Data Type: | NUMBER |
LIGHT_STICK_NUMBER
Seq. Order: | 14 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Number of light sticks used. |
General Data Type: | NUMBER |
COST_PER_LIGHT_STICK
Seq. Order: | 15 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 2 |
Status: | Active |
Description: |
Cost of each light stick. |
General Data Type: | NUMBER |
FREIGHT_COST
Seq. Order: | 16 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 2 |
Status: | Active |
Description: |
Cost of freight. |
General Data Type: | NUMBER |
DOCKING_UNLOADING_FEE
Seq. Order: | 17 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 2 |
Status: | Active |
Description: |
Docking Unloading Fee. |
General Data Type: | NUMBER |
TACKLE_GEAR_EXPENSES
Seq. Order: | 18 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 2 |
Status: | Active |
Description: |
Tackle Gear Expenses |
General Data Type: | NUMBER |
GROCERIES_EXPENSES
Seq. Order: | 19 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 2 |
Status: | Active |
Description: |
Total cost of groceries used during the trip. |
General Data Type: | NUMBER |
OTHER_EXPENSES
Seq. Order: | 20 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 2 |
Status: | Active |
Description: |
Other Expenses |
General Data Type: | NUMBER |
TOTAL_TRIP_COST
Seq. Order: | 21 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 2 |
Status: | Active |
Description: |
Total expenses for the trip. |
General Data Type: | NUMBER |
OWNER_ABOARD
Seq. Order: | 22 |
---|---|
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
Seq. Order: | 23 |
---|---|
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_PERCENT
Seq. Order: | 24 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 2 |
Status: | Active |
Description: |
Owner Share Percent |
General Data Type: | NUMBER |
CAPTAIN_SHARE_PERCENT
Seq. Order: | 25 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 2 |
Status: | Active |
Description: |
Captain Share Percent |
General Data Type: | NUMBER |
AVG_CREW_SHARE_PERCENT
Seq. Order: | 26 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 2 |
Status: | Active |
Description: |
Average Crew Share Percent |
General Data Type: | NUMBER |
FUEL_UNIT_PRICE
Seq. Order: | 27 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 2 |
Status: | Active |
Description: |
Fuel Unit Price |
General Data Type: | NUMBER |
BAIT_UNIT_PRICE
Seq. Order: | 28 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 2 |
Status: | Active |
Description: |
Bait Unit Price |
General Data Type: | NUMBER |
BAIT_COUNT
Seq. Order: | 29 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
How many units of bait were used |
General Data Type: | NUMBER |
BAIT2_WEIGHT
Seq. Order: | 30 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Weight Of Secondary/Second Bait |
General Data Type: | NUMBER |
BAIT2_UNIT_PRICE
Seq. Order: | 31 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 2 |
Status: | Active |
Description: |
Secondary /Second Bait Unit Price |
General Data Type: | NUMBER |
BAIT2_COST
Seq. Order: | 32 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 2 |
Status: | Active |
Description: |
Secondary/Second Bait Cost |
General Data Type: | NUMBER |
BAIT2_COUNT
Seq. Order: | 33 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
How Many Units Of second/secondary bait were used |
General Data Type: | NUMBER |
BAIT2_MSU
Seq. Order: | 34 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 2 |
Status: | Active |
Description: |
Measured Standard Units For Seconday/second Bait |
General Data Type: | NUMBER |
ICE_UNIT_PRICE
Seq. Order: | 35 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 2 |
Status: | Active |
Description: |
Ice Unit Price |
General Data Type: | NUMBER |
ICE_UNIT_PRICE_BLOCK
Seq. Order: | 36 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 2 |
Status: | Active |
Description: |
Ice Unit Price Per Block |
General Data Type: | NUMBER |
ICE_COUNT
Seq. Order: | 37 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Quantity of Ice Used |
General Data Type: | NUMBER |
ICE_TIME_FRAME
Seq. Order: | 38 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Time Frame For Ice To Last |
General Data Type: | NUMBER |
TOTAL_SHARE_COST
Seq. Order: | 39 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 2 |
Status: | Active |
Description: |
Total Share Cost |
General Data Type: | NUMBER |
CAPTAIN_LICENSE_STATE
Seq. Order: | 40 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
State where the captain has his license |
General Data Type: | VARCHAR2 |
CAPTAIN_LICENSE
Seq. Order: | 41 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 12 |
Scale: | 0 |
Status: | Active |
Description: |
Captain License |
General Data Type: | NUMBER |
BROKER_EXPENSE
Seq. Order: | 42 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 2 |
Status: | Active |
Description: |
Broker expenses |
General Data Type: | NUMBER |
BROKER_TRANS_TYPE
Seq. Order: | 43 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Broker Transaction Type |
General Data Type: | VARCHAR2 |
BROKER_PERCENT
Seq. Order: | 44 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Broker Percent |
General Data Type: | NUMBER |
ICE_MAKER
Seq. Order: | 45 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Was an ice maker used? |
General Data Type: | VARCHAR2 |
USED_A_BROKER
Seq. Order: | 46 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Was a broker used? |
General Data Type: | VARCHAR2 |
USED_CREW_SHARE_COMP
Seq. Order: | 47 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Was a set percentage of catch used to calculate crews share of proceeds |
General Data Type: | VARCHAR2 |
PERSON_ID
Seq. Order: | 48 |
---|---|
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
Seq. Order: | 49 |
---|---|
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
Seq. Order: | 50 |
---|---|
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 |
TRIP_GROCERY_EXPENSE
Seq. Order: | 51 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Grocery Expenses Per Trip |
General Data Type: | NUMBER |
MISC_EXPENSE
Seq. Order: | 52 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Miscellaneous Expenses Per Trip |
General Data Type: | NUMBER |
TOTAL_TRIP_REVENUE
Seq. Order: | 53 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
Total Trip Revenue |
General Data Type: | NUMBER |
TOTAL_TRIP_SALES
Seq. Order: | 54 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 2 |
Status: | Active |
Description: |
TotalTrip Sales |
General Data Type: | NUMBER |
Catalog Details
Catalog Item ID: | 6867 |
---|---|
GUID: | gov.noaa.nmfs.inport:6867 |
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 |