Table: FLS_COSTS
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:6867 | Updated: August 9, 2022 | Published / External
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
CC ID: 24774
| 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
CC ID: 24775
| 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
CC ID: 24776
| 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
CC ID: 24777
| 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
CC ID: 24778
| 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
CC ID: 24779
| 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
CC ID: 24780
| 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
CC ID: 24781
| 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
CC ID: 24782
| 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
CC ID: 24783
| 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
CC ID: 24784
| 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
CC ID: 24785
| 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
CC ID: 24786
| 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
CC ID: 24787
| 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
CC ID: 24788
| 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
CC ID: 24789
| 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
CC ID: 24790
| 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
CC ID: 24791
| 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
CC ID: 24792
| 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
CC ID: 24793
| 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
CC ID: 24794
| 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
CC ID: 24795
| 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
CC ID: 24796
| 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
CC ID: 24797
| 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
CC ID: 24798
| 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
CC ID: 24799
| 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
CC ID: 24800
| 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
CC ID: 24801
| 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
CC ID: 24802
| 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
CC ID: 24803
| 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
CC ID: 24804
| 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
CC ID: 24805
| 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
CC ID: 24806
| 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
CC ID: 24807
| 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
CC ID: 24808
| 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
CC ID: 24809
| 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
CC ID: 24810
| 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
CC ID: 24811
| 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
CC ID: 24812
| 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
CC ID: 24813
| 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
CC ID: 24814
| 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
CC ID: 24815
| 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
CC ID: 24816
| 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
CC ID: 24817
| 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
CC ID: 24818
| 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
CC ID: 24819
| 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
CC ID: 24820
| 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
CC ID: 24821
| 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
CC ID: 24822
| 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
CC ID: 24823
| 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
CC ID: 24824
| 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
CC ID: 24825
| 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
CC ID: 24826
| 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
CC ID: 24827
| 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 |