Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

View Used That Enables The Download Of Trip Cost Data In one file/table

Description

View 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

Rubric Score Primary Key? 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