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
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
CC ID: 24555
| 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
CC ID: 24589
| 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
CC ID: 24563
| 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
CC ID: 24573
| 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
CC ID: 24588
| 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
CC ID: 24566
| 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
CC ID: 24587
| 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
CC ID: 24562
| 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: 24564
| 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
CC ID: 24569
| 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
CC ID: 24572
| 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
CC ID: 24580
| 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
CC ID: 24568
| 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
CC ID: 24560
| 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
CC ID: 24578
| 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
CC ID: 24586
| 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
CC ID: 24559
| 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
CC ID: 24575
| 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
CC ID: 24591
| 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
CC ID: 24557
| 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
CC ID: 24590
| 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
CC ID: 24585
| 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
CC ID: 24574
| 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
CC ID: 24576
| 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
CC ID: 24584
| 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
CC ID: 24581
| 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
CC ID: 24556
| 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
CC ID: 24582
| 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
CC ID: 24565
| 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
CC ID: 24571
| 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
CC ID: 24579
| 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
CC ID: 24558
| 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
CC ID: 24570
| 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
CC ID: 24583
| 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
CC ID: 24561
| 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
CC ID: 24577
| 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
CC ID: 24567
| 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 |