View: EDC_SET_COST_DATA_EXT_VW
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:6858 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
View Used That Enables The Download Of Trip Cost Data In one file/table
DescriptionView Used That Enables The Download Of Trip Cost Data In one file/table
Entity Information
Entity Type
Data View
Data Attribute / Type | Description |
---|---|
LOGBOOK_KEY
NUMBER |
Automatic sequence that links all the tables that hold information related to trips. |
BATCH_NUMBER
VARCHAR2 |
The batch number is the number of the batch where the trip was processed. |
SCHEDULE_NUMBER
VARCHAR2 |
A number stamped on each logbook form. |
VESSEL_ID
VARCHAR2 |
Vessel Identifier |
VESSEL_NAME
VARCHAR2 |
Name of the vessel that matches the vessel id. |
TELEPHONE
VARCHAR2 |
Phone number that appears on the logbook. |
DAYS_AWAY
VARCHAR2 |
Number of days from, departure to landing, the vessel was away from port. |
START_DATE
VARCHAR2 |
Start Date Of Fishing Trip |
NUMBER_OF_CREW
VARCHAR2 |
Number of personnel engaged in fishing during the trip. |
UNLOAD_DATE
VARCHAR2 |
Unload Date |
TRIP_TICKET
VARCHAR2 |
Trip Ticket Number |
ICE_MSU
VARCHAR2 |
Measurement unit for the amount of ice used.Domain: TONS, BLOCK, POUND, UNKN (Unknown) |
OWNER_SHARE_PERCENT
VARCHAR2 |
Owner Share Percent |
CAPTAIN_SHARE_PERCENT
VARCHAR2 |
Captain Share Percent |
AVG_CREW_SHARE_PERCENT
VARCHAR2 |
Average Crew Share Percent |
FUEL
VARCHAR2 |
Amount Of Fuel Used |
FUEL_UNIT_PRICE
VARCHAR2 |
Fuel Unit Price |
BAIT_WEIGHT
VARCHAR2 |
Bait Weight |
BAIT_COUNT
VARCHAR2 |
How many units of bait were used |
BAIT_COST
VARCHAR2 |
Bait Cost Per Weight |
ICE_UNIT_PRICE
VARCHAR2 |
Ice Unit Price |
ICE_COUNT
VARCHAR2 |
Quantity of Ice Used |
ICE_COST
VARCHAR2 |
Cost of ice |
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. |
BROKER_PERCENT
VARCHAR2 |
Broker Percent |
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
CHAR |
Which Table 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_SET_COST_DATA_EXT_VW |
---|---|
Short Name: | EDC_SET_COST_DATA_EXT_VW |
Status: | Completed |
Abstract: |
View Used That Enables The Download Of Trip Cost Data In one file/table |
Notes: |
Loaded by batch 2043, 12-20-2007 08:10 |
Entity Information
Entity Type: | Data View |
---|---|
Active Version?: | Yes |
Schema Name: | FLS |
Description: |
View Used That Enables The Download Of Trip Cost Data In one file/table |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
LOGBOOK_KEY | NUMBER | Automatic sequence that links all the tables that hold information related to trips. | |
100
|
BATCH_NUMBER | VARCHAR2 | The batch number is the number of the batch where the trip was processed. | |
100
|
SCHEDULE_NUMBER | VARCHAR2 | A number stamped on each logbook form. | |
100
|
VESSEL_ID | VARCHAR2 | Vessel Identifier | |
100
|
VESSEL_NAME | VARCHAR2 | Name of the vessel that matches the vessel id. | |
100
|
TELEPHONE | VARCHAR2 | Phone number that appears on the logbook. | |
100
|
DAYS_AWAY | VARCHAR2 | Number of days from, departure to landing, the vessel was away from port. | |
100
|
START_DATE | VARCHAR2 | Start Date Of Fishing Trip | |
100
|
NUMBER_OF_CREW | VARCHAR2 | Number of personnel engaged in fishing during the trip. | |
100
|
UNLOAD_DATE | VARCHAR2 | Unload Date | |
100
|
TRIP_TICKET | VARCHAR2 | Trip Ticket Number | |
100
|
ICE_MSU | VARCHAR2 | Measurement unit for the amount of ice used.Domain: TONS, BLOCK, POUND, UNKN (Unknown) | |
100
|
OWNER_SHARE_PERCENT | VARCHAR2 | Owner Share Percent | |
100
|
CAPTAIN_SHARE_PERCENT | VARCHAR2 | Captain Share Percent | |
100
|
AVG_CREW_SHARE_PERCENT | VARCHAR2 | Average Crew Share Percent | |
100
|
FUEL | VARCHAR2 | Amount Of Fuel Used | |
100
|
FUEL_UNIT_PRICE | VARCHAR2 | Fuel Unit Price | |
100
|
BAIT_WEIGHT | VARCHAR2 | Bait Weight | |
100
|
BAIT_COUNT | VARCHAR2 | How many units of bait were used | |
100
|
BAIT_COST | VARCHAR2 | Bait Cost Per Weight | |
100
|
ICE_UNIT_PRICE | VARCHAR2 | Ice Unit Price | |
100
|
ICE_COUNT | VARCHAR2 | Quantity of Ice Used | |
100
|
ICE_COST | VARCHAR2 | Cost of ice | |
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
|
BROKER_PERCENT | VARCHAR2 | Broker Percent | |
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 | CHAR | Which Table 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
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Automatic sequence that links all the tables that hold information related to trips. |
General Data Type: | NUMBER |
BATCH_NUMBER
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The batch number is the number of the batch where the trip was processed. |
General Data Type: | VARCHAR2 |
SCHEDULE_NUMBER
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
A number stamped on each logbook form. |
General Data Type: | VARCHAR2 |
VESSEL_ID
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Vessel Identifier |
General Data Type: | VARCHAR2 |
VESSEL_NAME
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Name of the vessel that matches the vessel id. |
General Data Type: | VARCHAR2 |
TELEPHONE
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 15 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Phone number that appears on the logbook. |
General Data Type: | VARCHAR2 |
DAYS_AWAY
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 40 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of days from, departure to landing, the vessel was away from port. |
General Data Type: | VARCHAR2 |
START_DATE
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
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 40 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of personnel engaged in fishing during the trip. |
General Data Type: | VARCHAR2 |
UNLOAD_DATE
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unload Date |
General Data Type: | VARCHAR2 |
TRIP_TICKET
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 |
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 |
OWNER_SHARE_PERCENT
Seq. Order: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 40 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Owner Share Percent |
General Data Type: | VARCHAR2 |
CAPTAIN_SHARE_PERCENT
Seq. Order: | 14 |
---|---|
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_PERCENT
Seq. Order: | 15 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 40 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Average Crew Share Percent |
General Data Type: | VARCHAR2 |
FUEL
Seq. Order: | 16 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 40 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Amount Of Fuel Used |
General Data Type: | VARCHAR2 |
FUEL_UNIT_PRICE
Seq. Order: | 17 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 40 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Fuel Unit Price |
General Data Type: | VARCHAR2 |
BAIT_WEIGHT
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 40 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Bait Weight |
General Data Type: | VARCHAR2 |
BAIT_COUNT
Seq. Order: | 19 |
---|---|
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
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 40 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Bait Cost Per Weight |
General Data Type: | VARCHAR2 |
ICE_UNIT_PRICE
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 40 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Ice Unit Price |
General Data Type: | VARCHAR2 |
ICE_COUNT
Seq. Order: | 22 |
---|---|
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
Seq. Order: | 23 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 40 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Cost of ice |
General Data Type: | VARCHAR2 |
LIGHT_STICK_NUMBER
Seq. Order: | 24 |
---|---|
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
Seq. Order: | 25 |
---|---|
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
Seq. Order: | 26 |
---|---|
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
Seq. Order: | 27 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 40 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Other Expenses |
General Data Type: | VARCHAR2 |
TOTAL_SHARE_COST
Seq. Order: | 28 |
---|---|
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
Seq. Order: | 29 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 40 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Total expenses for the trip. |
General Data Type: | VARCHAR2 |
BROKER_PERCENT
Seq. Order: | 30 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 40 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Broker Percent |
General Data Type: | VARCHAR2 |
PERSON_ID
Seq. Order: | 31 |
---|---|
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: | 32 |
---|---|
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: | 33 |
---|---|
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
Seq. Order: | 34 |
---|---|
Data Storage Type: | CHAR |
Max Length: | 9 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Which Table Serves As a Source For This Record |
General Data Type: | CHAR |
GEAR_CODE_NMFS
Seq. Order: | 35 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
NMFS Gear Code |
General Data Type: | VARCHAR2 |
STATE_CODE_NMFS
Seq. Order: | 36 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
NMFS State Code |
General Data Type: | VARCHAR2 |
COUNTY_CODE_NMFS
Seq. Order: | 37 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
NMFS County Code |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 6858 |
---|---|
GUID: | gov.noaa.nmfs.inport:6858 |
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 |