View: POP_HAUL_LOG_EXP_V
Southeast Fisheries Science Center
Entity
(ENT)
| ID: 5348
| Published / External
Created: 2007-10-12
|
Last Modified: 2024-06-14
Data Set (DS) | ID: 30713
ID: 5348
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | View: POP_HAUL_LOG_EXP_V |
---|---|
Short Name | POP_HAUL_LOG_EXP_V |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
View Of Experimental Haul Logs. |
* Purpose | |
Notes |
Loaded by batch 1683, 10-12-2007 05:01 |
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 | POPOL |
» Description |
View Of Experimental Haul Logs. |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | Yes | No | TRIP_NUMBER | VARCHAR2 | TRIP_NUMBER |
100 | Yes | No | LANDING_DATE | DATE | Date Of Landing Of The Vessel |
100 | Yes | No | HAUL_NUMBER | NUMBER | Haul Number |
100 | Yes | No | GEAR_CODE | VARCHAR2 | NMFS Gear Code |
100 | Yes | No | WAS_HAUL_OBSERVED | VARCHAR2 | Was haul observed? |
100 | Yes | No | WAS_CATCH | VARCHAR2 | Were fish caught in the haul? |
100 | Yes | No | WAS_INCIDENTAL_TAKE | VARCHAR2 | Was incidental take? |
100 | No | No | WEATHER_DESCRIPTION | VARCHAR2 | Code For Weather Condition at time of the beginning of the haul. |
100 | No | No | WIND_SPEED | NUMBER | In knots at the beginning of the haul. |
100 | No | No | WIND_DIRECTION | VARCHAR2 | In compass degrees at the beginning of the haul. |
100 | No | No | WAVE_HEIGHT | NUMBER | Max. Wave Height at the beginning of the haul in feet |
100 | No | No | REVERSE_HAUL | VARCHAR2 | The last hook set is the first hook hauled. |
100 | No | No | GEAR_CONDITION | VARCHAR2 | Gear Condition at the completion of the haul |
100 | Yes | No | STRING_NUMBER | NUMBER | STRING_NUMBER Of Parent Gear Log Record. |
100 | No | No | MAINLINE_LENGTH | NUMBER | In nautical miles |
100 | No | No | SET_SPEED | NUMBER | In Knots |
100 | No | No | BOTTOM_DEPTH_MINIMUM | NUMBER | In fathoms. |
100 | No | No | BOTTOM_DEPTH_MAXIMUM | NUMBER | In fathoms. |
100 | No | No | HOOK_DEPTH_MINIMUM | NUMBER | In fathoms |
100 | No | No | HOOK_DEPTH_MAXIMUM | NUMBER | In fathoms |
100 | No | No | TOTAL_ADDITIONAL_WEIGHT | NUMBER | In Pounds |
100 | Yes | No | TARGET_SPECIES | VARCHAR2 | Uses Pop Species Code. |
100 | No | No | SOAK_DURATION | NUMBER | In Hours |
100 | No | No | WERE_FLOATS_USED | VARCHAR2 | Were Floats Used |
100 | No | No | NUMBER_OF_FLOATS | NUMBER | Number of floats used during the haul. |
100 | No | No | WERE_LIGHT_STICKS_USED | VARCHAR2 | Were Light Sticks Used |
100 | No | No | NUMBER_LIGHT_STICKS | NUMBER | Populated only if were_light_sticks_used is set to yes. |
100 | No | No | WERE_RATTLERS_USED | VARCHAR2 | Were Rattlers Used |
100 | No | No | NUMBER_RATTLERS | NUMBER | Populated only if were_rattlers_used is set to yes. |
100 | No | No | WERE_SURF_LITES_USED | VARCHAR2 | Were Surf Lites Used |
100 | No | No | NUMBER_SURF_LITES | NUMBER | Populated only if were_surf_lites_used is set to yes. |
100 | No | No | WERE_RADIO_BEACONS_USED | VARCHAR2 | Were Radio Beacons Used |
100 | No | No | NUMBER_RADIO_BEACONS | NUMBER | Populated only if were_radio_beacons_used is set to yes. |
100 | No | No | WERE_RADAR_REFLECTORS_USED | VARCHAR2 | Were radar relectors used |
100 | No | No | NUMBER_RADAR_REFLECTORS | NUMBER | Populated only if number_radar_reflectors_used is set to yes. |
100 | No | No | ADDITIONAL_LINE_WEIGHTS_USED | VARCHAR2 | Were Additional Line Weights used |
100 | No | No | NUMBER_ADDITIONAL_LINE_WEIGHTS | NUMBER | Populated only if addtional_line_weights_used is set to yes. |
100 | No | No | NUMBER_HOOKS_SET | NUMBER | Number of Hooks set |
100 | No | No | NUMBER_HOOKS_LOST | NUMBER | Number of Hooks lost. This should relate to the Gear Condition [POP_GEAR_LOG.GEAR_CONDITION] but it also includes bite offs and cut offs. |
100 | No | No | NUMBER_HOOKS_TENDED | NUMBER | Number of Hooks Pulled during hotlining, which is when the vessel runs the line and pulls hooks where floats are submerged. |
100 | No | No | NUMBER_HOOKS_REBAITED | NUMBER | Number of hooks pulled, rebaited and put back into the water. This is added to set number to get the total hooks for effort analysis. |
100 | No | No | BAIT_NUMBER_USED_1 | NUMBER | Number Of Individual Baits For First Bait indicated for the haul |
100 | No | No | BAIT_WEIGHT_1 | NUMBER | Baith Weight (Units Are In LBS) For First Bait Indicated for the haul |
100 | No | No | BAIT_KIND_1 | VARCHAR2 | A code which indicates the kind of bait used with first bait indicated for the haul. |
100 | No | No | BAIT_TYPE_1 | VARCHAR2 | A code which indicates the type of bait used/ (Whole, cut, lIve, Other etc) used with the first bait indicated for the haul |
100 | No | No | BAIT_CONDITION_1 | VARCHAR2 | The code for the condition of the bait used associated with the first bait indicated for the haul. |
100 | No | No | BAIT_NUMBER_USED_2 | NUMBER | Number Of Individual Baits For Second Bait indicated for the haul |
100 | No | No | BAIT_WEIGHT_2 | NUMBER | Baith Weight (Units Are In LBS) for Second Bait Indicated for the haul |
100 | No | No | BAIT_KIND_2 | VARCHAR2 | A code which indicates the kind of bait used with Second bait indicated for the haul. |
100 | No | No | BAIT_TYPE_2 | VARCHAR2 | A code which indicates the type of bait used/ (Whole, cut, lIve, Other etc) used with the second bait indicated for the haul |
100 | No | No | BAIT_CONDITION_2 | VARCHAR2 | The code for the condition of the bait used associated with the second bait indicated for the haul. |
100 | No | No | BAIT_NUMBER_USED_3 | NUMBER | Number Of Individual Baits For Third Bait indicated for the haul |
100 | No | No | BAIT_WEIGHT_3 | NUMBER | Baith Weight (Units Are In LBS) for the Third Bait Indicated for the Haul |
100 | No | No | BAIT_KIND_3 | VARCHAR2 | A code which indicates the kind of bait used with third bait indicated for the haul. |
100 | No | No | BAIT_TYPE_3 | VARCHAR2 | A code which indicates the type of bait used/ (Whole, cut, lIve, Other etc) used with the third bait indicated for the haul |
100 | No | No | BAIT_CONDITION_3 | VARCHAR2 | The code for the condition of the bait used associated with the third bait indicated for the haul. |
100 | No | No | BEGIN_SET_DATE | DATE | Hours and minutes are included in the time. |
100 | No | No | BEGIN_SET_LATITUDE | NUMBER | Begin Set Latitude Degrees |
100 | No | No | BEGIN_SET_LATITUDE_MINUTES | NUMBER | Begin Set Latitude Minutes |
100 | Yes | No | BEGIN_SET_LATITUDE_HEMISPHERE | VARCHAR2 | Begin Set Latitude Hemisphere. |
100 | No | No | BEGIN_SET_LONGITUDE | NUMBER | Begin Set Longitude Degrees |
100 | No | No | BEGIN_SET_LONGITUDE_MINUTES | NUMBER | Begin Set Longitude Minutes |
100 | Yes | No | BEGIN_SET_LONGITUDE_HEMISPHERE | VARCHAR2 | Begin Set Longitude Hemisphere |
100 | No | No | BEGIN_SET_TEMPERATURE | NUMBER | In Fahrenheit |
100 | No | No | END_SET_DATE | DATE | Hours and minutes are included in the time. |
100 | No | No | END_SET_LATITUDE | NUMBER | End Set Latitude Degrees |
100 | No | No | END_SET_LATITUDE_MINUTES | NUMBER | End Set Latitude Minutes |
100 | Yes | No | END_SET_LATITUDE_HEMISPHERE | VARCHAR2 | End Set Latitude Hemisphere |
100 | No | No | END_SET_LONGITUDE | NUMBER | End Set Longitude Degrees |
100 | No | No | END_SET_LONGITUDE_MINUTES | NUMBER | End Set Longitude Minutes |
100 | Yes | No | END_SET_LONGITUDE_HEMISPHERE | VARCHAR2 | End Set Longitude Hemisphere |
100 | No | No | END_SET_TEMPERATURE | NUMBER | In Fahrenheit |
100 | No | No | SET_DURATION | NUMBER | Set Duration In Hours |
100 | No | No | BEGIN_HAUL_DATE | DATE | Hours and minutes are included in the time. |
100 | No | No | BEGIN_HAUL_LATITUDE | NUMBER | Begin Haul Latitude Degrees |
100 | No | No | BEGIN_HAUL_LATITUDE_MINUTES | NUMBER | Begin Haul Latitude Minutes |
100 | Yes | No | BEGIN_HAUL_LATITUDE_HEMISPHERE | VARCHAR2 | Begin Haul Latitude Hemisphere |
100 | No | No | BEGIN_HAUL_LONGITUDE | NUMBER | Begin Haul Longitude Degrees |
100 | No | No | BEGIN_HAUL_LONGITUDE_MINUTES | NUMBER | Begin Haul Longitude Minutes |
100 | Yes | No | BEGIN_HAUL_LONGITUDE_HEMISPHER | VARCHAR2 | Begin Haul Longitude Hemisphere |
100 | No | No | BEGIN_HAUL_TEMPERATURE | NUMBER | In Fahrenheit |
100 | No | No | END_HAUL_DATE | DATE | Time includes year, date, hours and minutes. |
100 | No | No | END_HAUL_LATITUDE | NUMBER | End Haul Latitude Degrees |
100 | No | No | END_HAUL_LATITUDE_MINUTES | NUMBER | End Haul Latitude Minutes |
100 | Yes | No | END_HAUL_LATITUDE_HEMISPHERE | VARCHAR2 | End Haul Latitude Hemisphere |
100 | No | No | END_HAUL_LONGITUDE | NUMBER | End Haul Longitude Degrees |
100 | No | No | END_HAUL_LONGITUDE_MINUTES | NUMBER | End Haul Longitude Minutes |
100 | Yes | No | END_HAUL_LONGITUDE_HEMISPHERE | VARCHAR2 | End Haul Longitude Hemisphere |
100 | No | No | END_HAUL_TEMPERATURE | NUMBER | In Fahrenheit |
100 | No | No | HAUL_DURATION | NUMBER | In Hours |
100 | No | No | COMMENTS | VARCHAR2 | Observer comments about the haul |
Attribute Details
Attribute Name | TRIP_NUMBER |
---|---|
Seq. Order | 1 |
Data Storage Type | VARCHAR2 |
Max Length | 6 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
TRIP_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 | LANDING_DATE |
---|---|
Seq. Order | 2 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date Of Landing Of The Vessel |
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 | HAUL_NUMBER |
---|---|
Seq. Order | 3 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 2 |
Scale | 0 |
Status | Active |
Description |
Haul Number |
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 | GEAR_CODE |
---|---|
Seq. Order | 4 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
NMFS Gear Code |
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 | WAS_HAUL_OBSERVED |
---|---|
Seq. Order | 5 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Was haul observed? |
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 | WAS_CATCH |
---|---|
Seq. Order | 6 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Were fish caught in the haul? |
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 | WAS_INCIDENTAL_TAKE |
---|---|
Seq. Order | 7 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Was incidental take? |
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 | WEATHER_DESCRIPTION |
---|---|
Seq. Order | 8 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code For Weather Condition at time of the beginning of the haul. |
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 | WIND_SPEED |
---|---|
Seq. Order | 9 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 2 |
Scale | 0 |
Status | Active |
Description |
In knots at the beginning of the haul. |
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 | WIND_DIRECTION |
---|---|
Seq. Order | 10 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
In compass degrees at the beginning of the haul. |
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 | WAVE_HEIGHT |
---|---|
Seq. Order | 11 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 2 |
Scale | 0 |
Status | Active |
Description |
Max. Wave Height at the beginning of the haul in feet |
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 | REVERSE_HAUL |
---|---|
Seq. Order | 12 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The last hook set is the first hook hauled. |
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 | GEAR_CONDITION |
---|---|
Seq. Order | 13 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Gear Condition at the completion of the haul |
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 | STRING_NUMBER |
---|---|
Seq. Order | 14 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 1 |
Scale | 0 |
Status | Active |
Description |
STRING_NUMBER Of Parent Gear Log Record. |
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 | MAINLINE_LENGTH |
---|---|
Seq. Order | 15 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 1 |
Status | Active |
Description |
In nautical miles |
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 | SET_SPEED |
---|---|
Seq. Order | 16 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | 1 |
Status | Active |
Description |
In Knots |
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 | BOTTOM_DEPTH_MINIMUM |
---|---|
Seq. Order | 17 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 0 |
Status | Active |
Description |
In fathoms. |
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 | BOTTOM_DEPTH_MAXIMUM |
---|---|
Seq. Order | 18 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 0 |
Status | Active |
Description |
In fathoms. |
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 | HOOK_DEPTH_MINIMUM |
---|---|
Seq. Order | 19 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 0 |
Status | Active |
Description |
In fathoms |
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 | HOOK_DEPTH_MAXIMUM |
---|---|
Seq. Order | 20 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 0 |
Status | Active |
Description |
In fathoms |
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 | TOTAL_ADDITIONAL_WEIGHT |
---|---|
Seq. Order | 21 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 5 |
Scale | 0 |
Status | Active |
Description |
In Pounds |
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 | TARGET_SPECIES |
---|---|
Seq. Order | 22 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Uses Pop Species Code. |
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 | SOAK_DURATION |
---|---|
Seq. Order | 23 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 1 |
Status | Active |
Description |
In Hours |
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 | WERE_FLOATS_USED |
---|---|
Seq. Order | 24 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Were Floats 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 | NUMBER_OF_FLOATS |
---|---|
Seq. Order | 25 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 0 |
Status | Active |
Description |
Number of floats used during the haul. |
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 | WERE_LIGHT_STICKS_USED |
---|---|
Seq. Order | 26 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Were 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 | NUMBER_LIGHT_STICKS |
---|---|
Seq. Order | 27 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 0 |
Status | Active |
Description |
Populated only if were_light_sticks_used is set to yes. |
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 | WERE_RATTLERS_USED |
---|---|
Seq. Order | 28 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Were Rattlers 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 | NUMBER_RATTLERS |
---|---|
Seq. Order | 29 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 0 |
Status | Active |
Description |
Populated only if were_rattlers_used is set to yes. |
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 | WERE_SURF_LITES_USED |
---|---|
Seq. Order | 30 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Were Surf Lites 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 | NUMBER_SURF_LITES |
---|---|
Seq. Order | 31 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 2 |
Scale | 0 |
Status | Active |
Description |
Populated only if were_surf_lites_used is set to yes. |
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 | WERE_RADIO_BEACONS_USED |
---|---|
Seq. Order | 32 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Were Radio Beacons 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 | NUMBER_RADIO_BEACONS |
---|---|
Seq. Order | 33 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 2 |
Scale | 0 |
Status | Active |
Description |
Populated only if were_radio_beacons_used is set to yes. |
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 | WERE_RADAR_REFLECTORS_USED |
---|---|
Seq. Order | 34 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Were radar relectors 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 | NUMBER_RADAR_REFLECTORS |
---|---|
Seq. Order | 35 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 0 |
Status | Active |
Description |
Populated only if number_radar_reflectors_used is set to yes. |
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 | ADDITIONAL_LINE_WEIGHTS_USED |
---|---|
Seq. Order | 36 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Were Additional Line Weights 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 | NUMBER_ADDITIONAL_LINE_WEIGHTS |
---|---|
Seq. Order | 37 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | 0 |
Status | Active |
Description |
Populated only if addtional_line_weights_used is set to yes. |
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 | NUMBER_HOOKS_SET |
---|---|
Seq. Order | 38 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 0 |
Status | Active |
Description |
Number of Hooks set |
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 | NUMBER_HOOKS_LOST |
---|---|
Seq. Order | 39 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 0 |
Status | Active |
Description |
Number of Hooks lost. This should relate to the Gear Condition [POP_GEAR_LOG.GEAR_CONDITION] but it also includes bite offs and cut offs. |
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 | NUMBER_HOOKS_TENDED |
---|---|
Seq. Order | 40 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 0 |
Status | Active |
Description |
Number of Hooks Pulled during hotlining, which is when the vessel runs the line and pulls hooks where floats are submerged. |
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 | NUMBER_HOOKS_REBAITED |
---|---|
Seq. Order | 41 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 0 |
Status | Active |
Description |
Number of hooks pulled, rebaited and put back into the water. This is added to set number to get the total hooks for effort analysis. |
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 | BAIT_NUMBER_USED_1 |
---|---|
Seq. Order | 42 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 38 |
Scale | |
Status | Active |
Description |
Number Of Individual Baits For First Bait indicated for the haul |
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 | BAIT_WEIGHT_1 |
---|---|
Seq. Order | 43 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 38 |
Scale | |
Status | Active |
Description |
Baith Weight (Units Are In LBS) For First Bait Indicated for the haul |
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 | BAIT_KIND_1 |
---|---|
Seq. Order | 44 |
Data Storage Type | VARCHAR2 |
Max Length | 4000 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A code which indicates the kind of bait used with first bait indicated for the haul. |
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_TYPE_1 |
---|---|
Seq. Order | 45 |
Data Storage Type | VARCHAR2 |
Max Length | 4000 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A code which indicates the type of bait used/ (Whole, cut, lIve, Other etc) used with the first bait indicated for the haul |
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_CONDITION_1 |
---|---|
Seq. Order | 46 |
Data Storage Type | VARCHAR2 |
Max Length | 4000 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The code for the condition of the bait used associated with the first bait indicated for the haul. |
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_NUMBER_USED_2 |
---|---|
Seq. Order | 47 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 38 |
Scale | |
Status | Active |
Description |
Number Of Individual Baits For Second Bait indicated for the haul |
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 | BAIT_WEIGHT_2 |
---|---|
Seq. Order | 48 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 38 |
Scale | |
Status | Active |
Description |
Baith Weight (Units Are In LBS) for Second Bait Indicated for the haul |
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 | BAIT_KIND_2 |
---|---|
Seq. Order | 49 |
Data Storage Type | VARCHAR2 |
Max Length | 4000 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A code which indicates the kind of bait used with Second bait indicated for the haul. |
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_TYPE_2 |
---|---|
Seq. Order | 50 |
Data Storage Type | VARCHAR2 |
Max Length | 4000 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A code which indicates the type of bait used/ (Whole, cut, lIve, Other etc) used with the second bait indicated for the haul |
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_CONDITION_2 |
---|---|
Seq. Order | 51 |
Data Storage Type | VARCHAR2 |
Max Length | 4000 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The code for the condition of the bait used associated with the second bait indicated for the haul. |
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_NUMBER_USED_3 |
---|---|
Seq. Order | 52 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 38 |
Scale | |
Status | Active |
Description |
Number Of Individual Baits For Third Bait indicated for the haul |
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 | BAIT_WEIGHT_3 |
---|---|
Seq. Order | 53 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 38 |
Scale | |
Status | Active |
Description |
Baith Weight (Units Are In LBS) for the Third Bait Indicated for the Haul |
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 | BAIT_KIND_3 |
---|---|
Seq. Order | 54 |
Data Storage Type | VARCHAR2 |
Max Length | 4000 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A code which indicates the kind of bait used with third bait indicated for the haul. |
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_TYPE_3 |
---|---|
Seq. Order | 55 |
Data Storage Type | VARCHAR2 |
Max Length | 4000 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A code which indicates the type of bait used/ (Whole, cut, lIve, Other etc) used with the third bait indicated for the haul |
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_CONDITION_3 |
---|---|
Seq. Order | 56 |
Data Storage Type | VARCHAR2 |
Max Length | 4000 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The code for the condition of the bait used associated with the third bait indicated for the haul. |
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 | BEGIN_SET_DATE |
---|---|
Seq. Order | 57 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Hours and minutes are included in the time. |
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 | BEGIN_SET_LATITUDE |
---|---|
Seq. Order | 58 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 2 |
Scale | 0 |
Status | Active |
Description |
Begin Set Latitude Degrees |
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 | BEGIN_SET_LATITUDE_MINUTES |
---|---|
Seq. Order | 59 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 2 |
Scale | 0 |
Status | Active |
Description |
Begin Set Latitude Minutes |
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 | BEGIN_SET_LATITUDE_HEMISPHERE |
---|---|
Seq. Order | 60 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Begin Set Latitude Hemisphere. |
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 | BEGIN_SET_LONGITUDE |
---|---|
Seq. Order | 61 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | 0 |
Status | Active |
Description |
Begin Set Longitude Degrees |
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 | BEGIN_SET_LONGITUDE_MINUTES |
---|---|
Seq. Order | 62 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 2 |
Scale | 0 |
Status | Active |
Description |
Begin Set Longitude Minutes |
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 | BEGIN_SET_LONGITUDE_HEMISPHERE |
---|---|
Seq. Order | 63 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Begin Set Longitude Hemisphere |
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 | BEGIN_SET_TEMPERATURE |
---|---|
Seq. Order | 64 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | 1 |
Status | Active |
Description |
In Fahrenheit |
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 | END_SET_DATE |
---|---|
Seq. Order | 65 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Hours and minutes are included in the time. |
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 | END_SET_LATITUDE |
---|---|
Seq. Order | 66 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 2 |
Scale | 0 |
Status | Active |
Description |
End Set Latitude Degrees |
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 | END_SET_LATITUDE_MINUTES |
---|---|
Seq. Order | 67 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 2 |
Scale | 0 |
Status | Active |
Description |
End Set Latitude Minutes |
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 | END_SET_LATITUDE_HEMISPHERE |
---|---|
Seq. Order | 68 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
End Set Latitude Hemisphere |
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 | END_SET_LONGITUDE |
---|---|
Seq. Order | 69 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | 0 |
Status | Active |
Description |
End Set Longitude Degrees |
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 | END_SET_LONGITUDE_MINUTES |
---|---|
Seq. Order | 70 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 2 |
Scale | 0 |
Status | Active |
Description |
End Set Longitude Minutes |
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 | END_SET_LONGITUDE_HEMISPHERE |
---|---|
Seq. Order | 71 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
End Set Longitude Hemisphere |
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 | END_SET_TEMPERATURE |
---|---|
Seq. Order | 72 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | 1 |
Status | Active |
Description |
In Fahrenheit |
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 | SET_DURATION |
---|---|
Seq. Order | 73 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 1 |
Status | Active |
Description |
Set Duration In Hours |
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 | BEGIN_HAUL_DATE |
---|---|
Seq. Order | 74 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Hours and minutes are included in the time. |
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 | BEGIN_HAUL_LATITUDE |
---|---|
Seq. Order | 75 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 2 |
Scale | 0 |
Status | Active |
Description |
Begin Haul Latitude Degrees |
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 | BEGIN_HAUL_LATITUDE_MINUTES |
---|---|
Seq. Order | 76 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 2 |
Scale | 0 |
Status | Active |
Description |
Begin Haul Latitude Minutes |
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 | BEGIN_HAUL_LATITUDE_HEMISPHERE |
---|---|
Seq. Order | 77 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Begin Haul Latitude Hemisphere |
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 | BEGIN_HAUL_LONGITUDE |
---|---|
Seq. Order | 78 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | 0 |
Status | Active |
Description |
Begin Haul Longitude Degrees |
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 | BEGIN_HAUL_LONGITUDE_MINUTES |
---|---|
Seq. Order | 79 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 2 |
Scale | 0 |
Status | Active |
Description |
Begin Haul Longitude Minutes |
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 | BEGIN_HAUL_LONGITUDE_HEMISPHER |
---|---|
Seq. Order | 80 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Begin Haul Longitude Hemisphere |
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 | BEGIN_HAUL_TEMPERATURE |
---|---|
Seq. Order | 81 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | 1 |
Status | Active |
Description |
In Fahrenheit |
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 | END_HAUL_DATE |
---|---|
Seq. Order | 82 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Time includes year, date, hours and minutes. |
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 | END_HAUL_LATITUDE |
---|---|
Seq. Order | 83 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 2 |
Scale | 0 |
Status | Active |
Description |
End Haul Latitude Degrees |
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 | END_HAUL_LATITUDE_MINUTES |
---|---|
Seq. Order | 84 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 2 |
Scale | 0 |
Status | Active |
Description |
End Haul Latitude Minutes |
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 | END_HAUL_LATITUDE_HEMISPHERE |
---|---|
Seq. Order | 85 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
End Haul Latitude Hemisphere |
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 | END_HAUL_LONGITUDE |
---|---|
Seq. Order | 86 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | 0 |
Status | Active |
Description |
End Haul Longitude Degrees |
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 | END_HAUL_LONGITUDE_MINUTES |
---|---|
Seq. Order | 87 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 2 |
Scale | 0 |
Status | Active |
Description |
End Haul Longitude Minutes |
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 | END_HAUL_LONGITUDE_HEMISPHERE |
---|---|
Seq. Order | 88 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
End Haul Longitude Hemisphere |
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 | END_HAUL_TEMPERATURE |
---|---|
Seq. Order | 89 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | 1 |
Status | Active |
Description |
In Fahrenheit |
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 | HAUL_DURATION |
---|---|
Seq. Order | 90 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 1 |
Status | Active |
Description |
In Hours |
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 | COMMENTS |
---|---|
Seq. Order | 91 |
Data Storage Type | VARCHAR2 |
Max Length | 2000 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Observer comments about the haul |
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 | 5348 |
---|---|
Metadata Record Created By | Lee M Weinberger |
Metadata Record Created | 2007-10-12 05:01+0000 |
Metadata Record Last Modified By | Lee M Weinberger |
» Metadata Record Last Modified | 2024-06-14 13:53+0000 |
Metadata Record Published | 2024-06-14 |
Owner Org | SEFSC |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | 2021-05-06 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2022-05-06 |
Tags |
---|