View: EDC_TRIP_COST_DATA_VW
Southeast Fisheries Science Center
Entity
(ENT)
| ID: 6862
| Published / External
Created: 2007-12-20
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 6802
ID: 6862
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | View: EDC_TRIP_COST_DATA_VW |
---|---|
Short Name | EDC_TRIP_COST_DATA_VW |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
Contains cost,vessel,location per set trip record all in the same record |
* Purpose | |
Notes |
Loaded by batch 2043, 12-20-2007 08:10 |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | Data View |
---|---|
Active Version? | Y |
Alias | |
Schema Name | FLS |
» Description |
Contains cost,vessel,location per set trip record all in the same record |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | LOGBOOK_KEY | NUMBER | Foreign key to the FLS_TRIPS table, thus identifying the trip which costs are being described. |
100 | No | No | BATCH_NUMBER | VARCHAR2 | Batch Number |
100 | No | No | SCHEDULE_NUMBER | VARCHAR2 | Schedule Number |
100 | No | No | VESSEL_ID | VARCHAR2 | State Registration Number or Federal Vessel Identiification Number |
100 | No | No | VESSEL_NAME | VARCHAR2 | Vessel Name |
100 | No | No | TELEPHONE | VARCHAR2 | Phone Number To Contact Vessel |
100 | No | No | DAYS_AWAY | VARCHAR2 | Number Of Days Fishing |
100 | No | No | START_DATE | VARCHAR2 | Start Date Of FIshing Trip |
100 | No | No | NUMBER_OF_CREW | VARCHAR2 | Number Of Crew On Boat |
100 | No | No | UNLOAD_DATE | VARCHAR2 | Date Catch Was Unloaded |
100 | No | No | TRIP_TICKET | VARCHAR2 | Trip Ticket Number |
100 | No | No | OWNER_ABOARD | VARCHAR2 | Was the Owner Aboard? |
100 | No | No | OWNER_SALARY_INCLUDED | VARCHAR2 | Was the owner's salary included? |
100 | No | No | OWNER_SHARE | VARCHAR2 | Owner's share of the revenue. |
100 | No | No | OWNER_SHARE_PERCENT | VARCHAR2 | Owner Share Percent |
100 | No | No | CAPTAIN_SHARE | VARCHAR2 | Captain's share of the revenue. |
100 | No | No | CAPTAIN_SHARE_PERCENT | VARCHAR2 | Captain Share Percent |
100 | No | No | AVG_CREW_SHARE | VARCHAR2 | Average share for the revenue for crew members. |
100 | No | No | AVG_CREW_SHARE_PERCENT | VARCHAR2 | Average Crew Share Percent |
100 | No | No | FUEL | VARCHAR2 | Amount of fuel used during the trip. |
100 | No | No | FUEL_UNIT_PRICE | VARCHAR2 | Fuel Unit Price |
100 | No | No | FUEL_COST | VARCHAR2 | Cost of the fuel. |
100 | No | No | BAIT_UNIT_PRICE | VARCHAR2 | Bait Unit Price |
100 | No | No | BAIT_MSU | VARCHAR2 | Measurement uint in which the bait was weighed.Domain: G - Grams OZ - Ounces LB - Pounds KG - Kilograms T - Tons |
100 | No | No | BAIT_WEIGHT | VARCHAR2 | Weight of the bait. |
100 | No | No | BAIT_COUNT | VARCHAR2 | How many units of bait were used |
100 | No | No | BAIT_COST | VARCHAR2 | Cost of bait purchased. |
100 | No | No | BAIT2_UNIT_PRICE | VARCHAR2 | Secondary /Second Bait Unit Price |
100 | No | No | BAIT2_MSU | VARCHAR2 | Measured Standard Units For Seconday/second Bait |
100 | No | No | BAIT2_WEIGHT | VARCHAR2 | Weight Of Secondary/Second Bait |
100 | No | No | BAIT2_COUNT | VARCHAR2 | How Many Units Of second/secondary bait were used |
100 | No | No | BAIT2_COST | VARCHAR2 | Secondary/Second Bait Cost |
100 | No | No | ICE_WEIGHT | VARCHAR2 | Weight of ice purchased. |
100 | No | No | ICE_UNIT_PRICE | VARCHAR2 | Ice Unit Price |
100 | No | No | ICE_COUNT | VARCHAR2 | Quantity of Ice Used |
100 | No | No | ICE_COST | VARCHAR2 | Cost of ice |
100 | No | No | ICE_MSU | VARCHAR2 | Measurement unit for the amount of ice used.Domain: TONS, BLOCK, POUND, UNKN (Unknown) |
100 | No | No | ICE_TIME_FRAME | VARCHAR2 | Time Frame For Ice To Last |
100 | No | No | LIGHT_STICK_NUMBER | VARCHAR2 | Number of light sticks used. |
100 | No | No | COST_PER_LIGHT_STICK | VARCHAR2 | Cost of each light stick. |
100 | No | No | GROCERIES_EXPENSES | VARCHAR2 | Total cost of groceries used during the trip. |
100 | No | No | OTHER_EXPENSES | VARCHAR2 | Other Expenses |
100 | No | No | TOTAL_SHARE_COST | VARCHAR2 | Total Share Cost |
100 | No | No | TOTAL_TRIP_COST | VARCHAR2 | Total expenses for the trip. |
100 | No | No | FREIGHT_COST | VARCHAR2 | Cost of freight. |
100 | No | No | DOCKING_UNLOADING_FEE | VARCHAR2 | Docking Unloading Fee. |
100 | No | No | TACKLE_GEAR_EXPENSES | VARCHAR2 | Tackle Gear Expenses |
100 | No | No | TRIP_GROCERY_EXPENSE | VARCHAR2 | Grocery Expenses Per Trip |
100 | No | No | MISC_EXPENSE | VARCHAR2 | Miscellaneous Expenses Per Trip |
100 | No | No | TOTAL_TRIP_REVENUE | VARCHAR2 | Total Trip Revenue |
100 | No | No | PERSON_ID | NUMBER | Person ID. By Cassio on 6/2/2006 - For EDC |
100 | No | No | CHANGE_REASON_ID | NUMBER | Key to why reason was changed. By Cassio on 6/2/2006 - For EDC |
100 | No | No | LU | DATE | When Records was last updated By Cassio on 6/2/2006 - For EDC |
100 | No | No | TABLE_NAME | VARCHAR2 | Oracle Table which serves as a source for this record |
Attribute Details
Attribute Name | LOGBOOK_KEY |
---|---|
Seq. Order | 1 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Foreign key to the FLS_TRIPS table, thus identifying the trip which costs are being described. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BATCH_NUMBER |
---|---|
Seq. Order | 2 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Batch Number |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SCHEDULE_NUMBER |
---|---|
Seq. Order | 3 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Schedule Number |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | VESSEL_ID |
---|---|
Seq. Order | 4 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
State Registration Number or Federal Vessel Identiification Number |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | VESSEL_NAME |
---|---|
Seq. Order | 5 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Vessel Name |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TELEPHONE |
---|---|
Seq. Order | 6 |
Data Storage Type | VARCHAR2 |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Phone Number To Contact Vessel |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DAYS_AWAY |
---|---|
Seq. Order | 7 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number Of Days Fishing |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | START_DATE |
---|---|
Seq. Order | 8 |
Data Storage Type | VARCHAR2 |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Start Date Of FIshing Trip |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NUMBER_OF_CREW |
---|---|
Seq. Order | 9 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number Of Crew On Boat |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | UNLOAD_DATE |
---|---|
Seq. Order | 10 |
Data Storage Type | VARCHAR2 |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date Catch Was Unloaded |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TRIP_TICKET |
---|---|
Seq. Order | 11 |
Data Storage Type | VARCHAR2 |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Trip Ticket Number |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OWNER_ABOARD |
---|---|
Seq. Order | 12 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Was the Owner Aboard? |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OWNER_SALARY_INCLUDED |
---|---|
Seq. Order | 13 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Was the owner's salary included? |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OWNER_SHARE |
---|---|
Seq. Order | 14 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Owner's share of the revenue. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OWNER_SHARE_PERCENT |
---|---|
Seq. Order | 15 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Owner Share Percent |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CAPTAIN_SHARE |
---|---|
Seq. Order | 16 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Captain's share of the revenue. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CAPTAIN_SHARE_PERCENT |
---|---|
Seq. Order | 17 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Captain Share Percent |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | AVG_CREW_SHARE |
---|---|
Seq. Order | 18 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Average share for the revenue for crew members. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | AVG_CREW_SHARE_PERCENT |
---|---|
Seq. Order | 19 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Average Crew Share Percent |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FUEL |
---|---|
Seq. Order | 20 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Amount of fuel used during the trip. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FUEL_UNIT_PRICE |
---|---|
Seq. Order | 21 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Fuel Unit Price |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FUEL_COST |
---|---|
Seq. Order | 22 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Cost of the fuel. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BAIT_UNIT_PRICE |
---|---|
Seq. Order | 23 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Bait Unit Price |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BAIT_MSU |
---|---|
Seq. Order | 24 |
Data Storage Type | VARCHAR2 |
Max Length | 5 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Measurement uint in which the bait was weighed.Domain: G - Grams OZ - Ounces LB - Pounds KG - Kilograms T - Tons |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BAIT_WEIGHT |
---|---|
Seq. Order | 25 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Weight of the bait. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BAIT_COUNT |
---|---|
Seq. Order | 26 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
How many units of bait were used |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BAIT_COST |
---|---|
Seq. Order | 27 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Cost of bait purchased. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BAIT2_UNIT_PRICE |
---|---|
Seq. Order | 28 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Secondary /Second Bait Unit Price |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BAIT2_MSU |
---|---|
Seq. Order | 29 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Measured Standard Units For Seconday/second Bait |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BAIT2_WEIGHT |
---|---|
Seq. Order | 30 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Weight Of Secondary/Second Bait |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BAIT2_COUNT |
---|---|
Seq. Order | 31 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
How Many Units Of second/secondary bait were used |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BAIT2_COST |
---|---|
Seq. Order | 32 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Secondary/Second Bait Cost |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ICE_WEIGHT |
---|---|
Seq. Order | 33 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Weight of ice purchased. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ICE_UNIT_PRICE |
---|---|
Seq. Order | 34 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Ice Unit Price |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ICE_COUNT |
---|---|
Seq. Order | 35 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Quantity of Ice Used |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ICE_COST |
---|---|
Seq. Order | 36 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Cost of ice |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ICE_MSU |
---|---|
Seq. Order | 37 |
Data Storage Type | VARCHAR2 |
Max Length | 5 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Measurement unit for the amount of ice used.Domain: TONS, BLOCK, POUND, UNKN (Unknown) |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ICE_TIME_FRAME |
---|---|
Seq. Order | 38 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Time Frame For Ice To Last |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LIGHT_STICK_NUMBER |
---|---|
Seq. Order | 39 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of light sticks used. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | COST_PER_LIGHT_STICK |
---|---|
Seq. Order | 40 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Cost of each light stick. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GROCERIES_EXPENSES |
---|---|
Seq. Order | 41 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Total cost of groceries used during the trip. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OTHER_EXPENSES |
---|---|
Seq. Order | 42 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Other Expenses |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TOTAL_SHARE_COST |
---|---|
Seq. Order | 43 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Total Share Cost |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TOTAL_TRIP_COST |
---|---|
Seq. Order | 44 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Total expenses for the trip. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FREIGHT_COST |
---|---|
Seq. Order | 45 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Cost of freight. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DOCKING_UNLOADING_FEE |
---|---|
Seq. Order | 46 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Docking Unloading Fee. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TACKLE_GEAR_EXPENSES |
---|---|
Seq. Order | 47 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Tackle Gear Expenses |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TRIP_GROCERY_EXPENSE |
---|---|
Seq. Order | 48 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Grocery Expenses Per Trip |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MISC_EXPENSE |
---|---|
Seq. Order | 49 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Miscellaneous Expenses Per Trip |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TOTAL_TRIP_REVENUE |
---|---|
Seq. Order | 50 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Total Trip Revenue |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PERSON_ID |
---|---|
Seq. Order | 51 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 38 |
Scale | |
Status | Active |
Description |
Person ID. By Cassio on 6/2/2006 - For EDC |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CHANGE_REASON_ID |
---|---|
Seq. Order | 52 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 38 |
Scale | |
Status | Active |
Description |
Key to why reason was changed. By Cassio on 6/2/2006 - For EDC |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LU |
---|---|
Seq. Order | 53 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
When Records was last updated By Cassio on 6/2/2006 - For EDC |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TABLE_NAME |
---|---|
Seq. Order | 54 |
Data Storage Type | VARCHAR2 |
Max Length | 21 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Oracle Table which serves as a source for this record |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 6862 |
---|---|
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 Workflow State | Published / External |
Metadata Last Review Date | 2021-05-07 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2022-05-07 |
Tags |
---|