Metadata Rubric

100%

6 / 6

SEFSC Metadata Library > Social Science Research Group Projects > Trip Cost Data > SSRG Socioeconomic Panel >

View: EDC_SET_COST_DATA_VW

Entity (ENT) | Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:6859 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Contains cost,information per set record

Description

Contains cost,information per set record

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

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

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

Title:	View: EDC_SET_COST_DATA_VW
Short Name:	EDC_SET_COST_DATA_VW
Status:	Completed
Abstract:	Contains cost,information per set record
Notes:	Loaded by batch 2043, 12-20-2007 08:10

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	FLS
Description:	Contains cost,information per set record

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

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

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

Attribute Details

LOGBOOK_KEY

CC ID: 24603

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: 24602

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: 24620

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: 24594

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: 24606

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: 24625

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: 24612

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: 24615

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: 24597

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: 24609

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: 24593

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: 24601

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: 24607

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: 24611

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: 24600

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: 24618

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: 24595

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: 24596

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: 24621

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: 24592

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: 24614

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: 24610

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: 24616

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: 24599

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: 24624

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: 24605

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: 24619

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: 24617

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: 24608

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: 24623

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: 24613

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: 24604

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: 24622

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: 24598

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

Catalog Item ID:	6859
GUID:	gov.noaa.nmfs.inport:6859
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

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

LOGBOOK_KEY

BATCH_NUMBER

SCHEDULE_NUMBER

VESSEL_ID

VESSEL_NAME

TELEPHONE

DAYS_AWAY

START_DATE

NUMBER_OF_CREW

UNLOAD_DATE

TRIP_TICKET

ICE_MSU

OWNER_SHARE_PERCENT

CAPTAIN_SHARE_PERCENT

AVG_CREW_SHARE_PERCENT

FUEL

FUEL_UNIT_PRICE

BAIT_WEIGHT

BAIT_COUNT

BAIT_COST

ICE_UNIT_PRICE

ICE_COUNT

ICE_COST

LIGHT_STICK_NUMBER

COST_PER_LIGHT_STICK

GROCERIES_EXPENSES

OTHER_EXPENSES

TOTAL_SHARE_COST

TOTAL_TRIP_COST

BROKER_PERCENT

PERSON_ID

CHANGE_REASON_ID

LU

TABLE_NAME

Catalog Details