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
Item Identification
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 Information
Entity Type: | Data View |
---|---|
Active Version?: | Yes |
Schema Name: | FLS |
Description: |
Contains cost,information per set record |
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 |
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 |
Catalog Details
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 |