30713
PELAGIC OBSERVER PROGRAM (POP). Catch/Effort data collected by observers on board U.S. commercial Pelagic Longline vessels
Data Set
Published / External
1935
Pelagic Longline Observer Program
Project
In Work
This data set contains data that are collected by trained observers aboard pelagic longline vessels in the Atlantic Ocean and Gulf of Mexico. The fishery observers are deployed to collect catch and effort data and record information on the types and numbers of fish that are discarded and interactions with marine mammals or endangered species. Vessels that have Federal permits to fish for swordfish are required to take a fishery observer onboard for the duration of a trip if the vessel is selected. The data that are submitted to the mandatory pelagic longline logbook program are used as the population from which the vessels are randomly selected. A 5 to 8 percent sample of vessels is selected to carry an observer for at least one trip during a calendar quarter.
Monitor catch and effort
Theme
fishdep
Theme
fishery-dependent
Southeast Fisheries Science Center
Miami
FL
USA
Location Of The Main Office Of The South East Fisheries Science Center
Data Set
Table (digital)
N/A
Commercial Longline Boats
hooks
5323
Table: POP_ANIMAL_LOG
POP_ANIMAL_LOG
Published / External
Completed
Animal Log for NON-experimental hauls
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Animal Log for NON-experimental hauls
1
ANIMAL_LOG_KEY
NUMBER
22
Yes
Yes
10
0
Active
Primary Key
NUMBER
2
HAUL_LOG_KEY
NUMBER
22
Yes
No
10
0
Active
Haul Log Key
NUMBER
3
CARCASS_TAG_NUMBER
VARCHAR2
5
No
No
Active
Number assigned by the sampler to the carcass of the fish.
VARCHAR2
4
ALPHA_SPECIES_CODE
VARCHAR2
3
No
No
Active
POP Spc. Code
VARCHAR2
5
LENGTH_MEASUREMENT_ONE
NUMBER
22
No
No
3
0
Active
First Length Measurement Taken
NUMBER
6
LENGTH_MEASUREMENT_TWO
NUMBER
22
No
No
3
0
Active
Second Length Measurement Taken
NUMBER
7
LENGTH_MEASUREMENT_THREE
NUMBER
22
No
No
3
0
Active
Third Length Measurement Taken
NUMBER
8
LENGTH_TYPE_ONE
VARCHAR2
3
No
No
Active
What was measured in Length Measurement One
VARCHAR2
9
LENGTH_TYPE_TWO
VARCHAR2
3
No
No
Active
What was measured in Length Measurement Two
VARCHAR2
10
LENGTH_TYPE_THREE
VARCHAR2
3
No
No
Active
What was measured in Length Measurement Three
VARCHAR2
11
LENGTH_MEASUREMENT_TAKEN_CODE
VARCHAR2
2
No
No
Active
Length Measurement Taken Code
VARCHAR2
12
DRESSED_WEIGHT
NUMBER
22
No
No
4
0
Active
Dressed weight of the fish landed. (should not be estimated)
NUMBER
13
TAG_NUMBER
VARCHAR2
12
No
No
Active
Theoretically a link could be made to the CTS system here.
VARCHAR2
14
SEX
VARCHAR2
1
No
No
Active
Can be: Undetermined, Male, Female
VARCHAR2
15
TAG_ACTION
VARCHAR2
1
No
No
Active
Coded item describing, what if anything happened with respect to the tagging of the fish.
VARCHAR2
16
BOARDING_STATUS
VARCHAR2
1
No
No
Active
Code For how the animal was boarded (Dead, Alive etc)
VARCHAR2
17
KEPT_OR_RELEASED
VARCHAR2
1
No
No
Active
Code to indicate whether animal caught was kept or released
VARCHAR2
18
KEPT_OR_RELEASED2
VARCHAR2
1
No
No
Active
Valid Values: Dead, AliveThe column only had data in it when KEPT_OR_RELEASED is RELEASED
VARCHAR2
19
ESTIMATED_WEIGHT
NUMBER
22
No
No
4
0
Active
In Pounds
NUMBER
20
COMMENTS
VARCHAR2
2000
No
No
Active
Comments
VARCHAR2
21
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Created by whom
VARCHAR2
22
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
23
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Modified by whom
VARCHAR2
24
MODIFIED_DATE
DATE
7
No
No
Active
Modified when
DATE
25
PAGE_NO
NUMBER
22
No
No
2
0
Active
Which Page Number Of The Animal Log Form record is found on. This column was added during conversion between POP and POPOL
NUMBER
26
LINE_NO
NUMBER
22
No
No
2
0
Active
Which Line Number Of The Animal Log Form record is found on. This column was added during conversion between POP and POPOL
NUMBER
27
DAMAGE_TYPE
VARCHAR2
2
No
No
Active
Code assigned to indicate observed damge on the fish
VARCHAR2
5324
Table: POP_ANIMAL_LOG_EXP
POP_ANIMAL_LOG_EXP
Published / External
Completed
Animal Log for Experimental Hauls
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Animal Log for Experimental Hauls
1
ANIMAL_LOG_KEY
NUMBER
22
Yes
Yes
10
0
Active
Primary Key
NUMBER
2
HAUL_LOG_KEY
NUMBER
22
Yes
No
10
0
Active
Haul Log Key
NUMBER
3
CARCASS_TAG_NUMBER
VARCHAR2
5
No
No
Active
Number assigned by the sampler to the carcass of the fish.
VARCHAR2
4
ALPHA_SPECIES_CODE
VARCHAR2
3
No
No
Active
POP Spc. Code
VARCHAR2
5
LENGTH_MEASUREMENT_ONE
NUMBER
22
No
No
3
0
Active
First Length Measurement Taken
NUMBER
6
LENGTH_MEASUREMENT_TWO
NUMBER
22
No
No
3
0
Active
Second Length Measurement Taken
NUMBER
7
LENGTH_MEASUREMENT_THREE
NUMBER
22
No
No
3
0
Active
Third Length Measurement Taken
NUMBER
8
LENGTH_TYPE_ONE
VARCHAR2
3
No
No
Active
What was measured in Length Measurement One
VARCHAR2
9
LENGTH_TYPE_TWO
VARCHAR2
3
No
No
Active
What was measured in Length Measurement Two
VARCHAR2
10
LENGTH_TYPE_THREE
VARCHAR2
3
No
No
Active
What was measured in Length Measurement Three
VARCHAR2
11
LENGTH_MEASUREMENT_TAKEN_CODE
VARCHAR2
2
No
No
Active
Length Measurement Taken Code
VARCHAR2
12
DRESSED_WEIGHT
NUMBER
22
No
No
4
0
Active
Dressed weight of the fish landed. (should not be estimated)
NUMBER
13
TAG_NUMBER
VARCHAR2
12
No
No
Active
Theoretically a link could be made to the CTS system here.
VARCHAR2
14
SEX
VARCHAR2
1
No
No
Active
Can be: Undetermined, Male, Female
VARCHAR2
15
TAG_ACTION
VARCHAR2
1
No
No
Active
Coded item describing, what if anything happened with respect to the tagging of the fish.
VARCHAR2
16
BOARDING_STATUS
VARCHAR2
1
No
No
Active
Code For how the animal was boarded (Dead, Alive etc)
VARCHAR2
17
KEPT_OR_RELEASED
VARCHAR2
1
No
No
Active
Code to indicate whether animal caught was kept or released
VARCHAR2
18
KEPT_OR_RELEASED2
VARCHAR2
1
No
No
Active
Valid Values: Dead, AliveThe column only had data in it when KEPT_OR_RELEASED is RELEASED
VARCHAR2
19
ESTIMATED_WEIGHT
NUMBER
22
No
No
4
0
Active
In Pounds
NUMBER
20
SECTION
NUMBER
22
No
No
2
0
Active
Section of the gear the animal was caught in
NUMBER
21
TREATMENT
VARCHAR2
1
No
No
Active
Treatment the animal received
VARCHAR2
22
TIME_BOARDED
DATE
7
No
No
Active
When the animal was boarded
DATE
23
HOOK_TIMER_ELAPSED_TIME
VARCHAR2
4
No
No
Active
Hook Timer elapsed time
VARCHAR2
24
HOW_HOOKED
VARCHAR2
1
No
No
Active
How the animal was hooked
VARCHAR2
25
ENTANGLED
VARCHAR2
1
No
No
Active
Was it entangled?
VARCHAR2
26
COMMENTS
VARCHAR2
2000
No
No
Active
Comments
VARCHAR2
27
HOOK_DEPTH
VARCHAR2
1
No
No
Active
Hook Depth
VARCHAR2
28
UNK_CODE
VARCHAR2
1
No
No
Active
Unknow Code
VARCHAR2
29
TDR
VARCHAR2
1
No
No
Active
Time Depth Recorder
VARCHAR2
30
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Created by whom
VARCHAR2
31
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
32
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Modified by whom
VARCHAR2
33
MODIFIED_DATE
DATE
7
No
No
Active
Modified when
DATE
34
PAGE_NO
NUMBER
22
No
No
2
0
Active
Which Page Number Of The Animal Log Form record is found on. This column was added during conversion between POP and POPOL
NUMBER
35
LINE_NO
NUMBER
22
No
No
2
0
Active
Which Line Number Of The Animal Log Form record is found on. This column was added during conversion between POP and POPOL
NUMBER
36
DAMAGE_TYPE
VARCHAR2
2
No
No
Active
Code assigned to indicate observed damge on the fish
VARCHAR2
5325
View: POP_ANIMAL_LOG_EXP_V
POP_ANIMAL_LOG_EXP_V
Published / External
Completed
View Of Experimental Animal Logs.
Loaded by batch 1683, 10-12-2007 05:01
Data View
Yes
POPOL
View Of Experimental Animal Logs.
1
TRIP_NUMBER
VARCHAR2
6
Yes
No
Active
TRIP_NUMBER
VARCHAR2
2
BEGIN_HAUL_DATE
DATE
7
No
No
Active
Date and Time of when haul began includes year, date, hours and minutes.
DATE
3
HAUL_NUMBER
NUMBER
22
Yes
No
2
0
Active
HAUL_NUMBER
NUMBER
4
CARCASS_TAG_NUMBER
VARCHAR2
5
No
No
Active
Number assigned by the sampler to the carcass of the fish.
VARCHAR2
5
SECTION
NUMBER
22
No
No
2
0
Active
Section of the gear the animal was caught in
NUMBER
6
TREATMENT
VARCHAR2
1
No
No
Active
Treatment the animal received
VARCHAR2
7
TIME_BOARDED
DATE
7
No
No
Active
When the animal was boarded
DATE
8
ALPHA_SPECIES_CODE
VARCHAR2
3
No
No
Active
POP Spc. Code
VARCHAR2
9
HOW_HOOKED
VARCHAR2
1
No
No
Active
How the animal was hooked
VARCHAR2
10
BOARDING_STATUS
VARCHAR2
1
No
No
Active
Code For how the animal was boarded (Dead, Alive etc)
VARCHAR2
11
KEPT_OR_RELEASED
VARCHAR2
1
No
No
Active
Code to indicate whether animal caught was kept or released
VARCHAR2
12
KEPT_OR_RELEASED2
VARCHAR2
1
No
No
Active
Valid Values: Dead, AliveThe column only had data in it when KEPT_OR_RELEASED is RELEASED
VARCHAR2
13
LENGTH_MEASUREMENT_ONE
NUMBER
22
No
No
3
0
Active
First Length Measurement Taken
NUMBER
14
LENGTH_MEASUREMENT_TWO
NUMBER
22
No
No
3
0
Active
Second Length Measurement Taken
NUMBER
15
LENGTH_MEASUREMENT_THREE
NUMBER
22
No
No
3
0
Active
Third Length Measurement Taken
NUMBER
16
LENGTH_MEASUREMENT_TAKEN_CODE
VARCHAR2
2
No
No
Active
Length Measurement Taken Code
VARCHAR2
17
DRESSED_WEIGHT
NUMBER
22
No
No
4
0
Active
Dressed weight of the fish landed. (should not be estimated)
NUMBER
18
SEX
VARCHAR2
1
No
No
Active
Can be: Undetermined, Male, Female
VARCHAR2
19
TAG_NUMBER
VARCHAR2
12
No
No
Active
Theoretically a link could be made to the CTS system here.
VARCHAR2
20
TAG_ACTION
VARCHAR2
1
No
No
Active
Coded item describing, what if anything happened with respect to the tagging of the fish.
VARCHAR2
21
HOOK_TIMER_ELAPSED_TIME
VARCHAR2
4
No
No
Active
Hook Timer elapsed time
VARCHAR2
22
ESTIMATED_WEIGHT
NUMBER
22
No
No
4
0
Active
In Pounds
NUMBER
5326
View: POP_ANIMAL_LOG_NON_EXP_V
POP_ANIMAL_LOG_NON_EXP_V
Published / External
Completed
View Of Non Experimental Animal Logs.
Loaded by batch 1683, 10-12-2007 05:01
Data View
Yes
POPOL
View Of Non Experimental Animal Logs.
1
TRIP_NUMBER
VARCHAR2
6
Yes
No
Active
TRIP_NUMBER
VARCHAR2
2
BEGIN_HAUL_DATE
DATE
7
No
No
Active
Date and Time of when haul began includes year, date, hours and minutes.
DATE
3
HAUL_NUMBER
NUMBER
22
Yes
No
2
0
Active
HAUL_NUMBER
NUMBER
4
CARCASS_TAG_NUMBER
VARCHAR2
5
No
No
Active
Number assigned by the sampler to the carcass of the fish.
VARCHAR2
5
ALPHA_SPECIES_CODE
VARCHAR2
3
No
No
Active
POP Spc. Code
VARCHAR2
6
BOARDING_STATUS
VARCHAR2
1
No
No
Active
Code For how the animal was boarded (Dead, Alive etc)
VARCHAR2
7
KEPT_OR_RELEASED
VARCHAR2
1
No
No
Active
Code to indicate whether animal caught was kept or released
VARCHAR2
8
KEPT_OR_RELEASED2
VARCHAR2
1
No
No
Active
Valid Values: Dead, AliveThe column only had data in it when KEPT_OR_RELEASED is RELEASED
VARCHAR2
9
LENGTH_MEASUREMENT_ONE
NUMBER
22
No
No
3
0
Active
First Length Measurement Taken
NUMBER
10
LENGTH_MEASUREMENT_TWO
NUMBER
22
No
No
3
0
Active
Second Length Measurement Taken
NUMBER
11
LENGTH_MEASUREMENT_THREE
NUMBER
22
No
No
3
0
Active
Third Length Measurement Taken
NUMBER
12
LENGTH_MEASUREMENT_TAKEN_CODE
VARCHAR2
2
No
No
Active
Length Measurement Taken Code
VARCHAR2
13
DRESSED_WEIGHT
NUMBER
22
No
No
4
0
Active
Dressed weight of the fish landed. (should not be estimated)
NUMBER
14
SEX
VARCHAR2
1
No
No
Active
Can be: Undetermined, Male, Female
VARCHAR2
15
TAG_NUMBER
VARCHAR2
12
No
No
Active
Theoretically a link could be made to the CTS system here.
VARCHAR2
16
TAG_ACTION
VARCHAR2
1
No
No
Active
Coded item describing, what if anything happened with respect to the tagging of the fish.
VARCHAR2
17
ESTIMATED_WEIGHT
NUMBER
22
No
No
4
0
Active
In Pounds
NUMBER
5327
View: POP_ANIMAL_LOG_V
POP_ANIMAL_LOG_V
Published / External
Completed
Combined View Of Experimental and Non Experimental Animal Logs.
Loaded by batch 1683, 10-12-2007 05:01
Data View
Yes
POPOL
Combined View Of Experimental and Non Experimental Animal Logs.
1
TRIP_NUMBER
VARCHAR2
6
No
No
Active
TRIP_NUMBER
VARCHAR2
2
BEGIN_HAUL_DATE
DATE
7
No
No
Active
Date and Time of when haul began includes year, date, hours and minutes.
DATE
3
HAUL_NUMBER
NUMBER
22
No
No
2
0
Active
HAUL_NUMBER
NUMBER
4
CARCASS_TAG_NUMBER
VARCHAR2
5
No
No
Active
Number assigned by the sampler to the carcass of the fish.
VARCHAR2
5
ALPHA_SPECIES_CODE
VARCHAR2
3
No
No
Active
POP Spc. Code
VARCHAR2
6
SECTION
NUMBER
22
No
No
38
Active
Section of the gear the animal was caught in
NUMBER
7
TREATMENT
VARCHAR2
1
No
No
Active
Treatment the animal received
VARCHAR2
8
TIME_BOARDED
DATE
7
No
No
Active
When the animal was boarded
DATE
9
HOW_HOOKED
VARCHAR2
1
No
No
Active
How the animal was hooked
VARCHAR2
10
BOARDING_STATUS
VARCHAR2
1
No
No
Active
Code For how the animal was boarded (Dead, Alive etc)
VARCHAR2
11
KEPT_OR_RELEASED
VARCHAR2
1
No
No
Active
Code to indicate whether animal caught was kept or released
VARCHAR2
12
KEPT_OR_RELEASED2
VARCHAR2
1
No
No
Active
Valid Values: Dead, AliveThe column only had data in it when KEPT_OR_RELEASED is RELEASED
VARCHAR2
13
LENGTH_MEASUREMENT_ONE
NUMBER
22
No
No
3
0
Active
First Length Measurement Taken
NUMBER
14
LENGTH_MEASUREMENT_TWO
NUMBER
22
No
No
3
0
Active
Second Length Measurement Taken
NUMBER
15
LENGTH_MEASUREMENT_THREE
NUMBER
22
No
No
3
0
Active
Third Length Measurement Taken
NUMBER
16
LENGTH_MEASUREMENT_TAKEN_CODE
VARCHAR2
2
No
No
Active
Length Measurement Taken Code
VARCHAR2
17
DRESSED_WEIGHT
NUMBER
22
No
No
4
0
Active
Dressed weight of the fish landed. (should not be estimated)
NUMBER
18
SEX
VARCHAR2
1
No
No
Active
Can be: Undetermined, Male, Female
VARCHAR2
19
TAG_NUMBER
VARCHAR2
12
No
No
Active
Theoretically a link could be made to the CTS system here.
VARCHAR2
20
TAG_ACTION
VARCHAR2
1
No
No
Active
Coded item describing, what if anything happened with respect to the tagging of the fish.
VARCHAR2
21
HOOK_TIMER_ELAPSED_TIME
VARCHAR2
4
No
No
Active
Hook Timer elapsed time
VARCHAR2
22
ESTIMATED_WEIGHT
NUMBER
22
No
No
4
0
Active
In Pounds
NUMBER
5328
Table: POP_BAITS_USED
POP_BAITS_USED
Published / External
Completed
Bait Used Section of Haul Log
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Bait Used Section of Haul Log
1
BAITS_USED_KEY
NUMBER
22
Yes
Yes
10
0
Active
Primary Key
NUMBER
2
HAUL_LOG_KEY
NUMBER
22
Yes
No
10
0
Active
Haul Log Key
NUMBER
3
BAIT_NUMBER_USED
NUMBER
22
No
No
4
0
Active
Number Of Individual Baits Used
NUMBER
4
BAIT_WEIGHT
NUMBER
22
No
No
4
0
Active
Units are in LBS
NUMBER
5
BAIT_KIND
VARCHAR2
2
Yes
No
Active
Code that indicates the kind of bait used.
VARCHAR2
6
BAIT_TYPE
VARCHAR2
1
Yes
No
Active
Code that indicates the type of bait used
VARCHAR2
7
BAIT_CONDITION
VARCHAR2
1
No
No
Active
Code for the condition of the bait used.
VARCHAR2
8
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Created by whom
VARCHAR2
9
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
10
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Modified by whom
VARCHAR2
11
MODIFIED_DATE
DATE
7
No
No
Active
Modified when
DATE
5329
Table: POP_BAIT_CONDITION
POP_BAIT_CONDITION
Published / External
Completed
Code Table for Bait Conditions
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Code Table for Bait Conditions
1
CODE
VARCHAR2
1
Yes
Yes
Active
Code
VARCHAR2
2
NAME
VARCHAR2
20
Yes
No
Active
Name
VARCHAR2
3
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Created by whom
VARCHAR2
4
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
5
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Modified by whom
VARCHAR2
6
MODIFIED_DATE
DATE
7
No
No
Active
Modified when
DATE
5330
Table: POP_BAIT_KIND
POP_BAIT_KIND
Published / External
Completed
Code Table for Bait Kind
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Code Table for Bait Kind
1
CODE
VARCHAR2
2
Yes
Yes
Active
Code
VARCHAR2
2
NAME
VARCHAR2
20
Yes
No
Active
Name
VARCHAR2
3
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Created by whom
VARCHAR2
4
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
5
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Created by whom
VARCHAR2
6
MODIFIED_DATE
DATE
7
No
No
Active
Modified when
DATE
5331
Table: POP_BAIT_TYPE
POP_BAIT_TYPE
Published / External
Completed
Code Table for Bait Type
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Code Table for Bait Type
1
CODE
VARCHAR2
1
Yes
Yes
Active
Code
VARCHAR2
2
NAME
VARCHAR2
20
Yes
No
Active
Name
VARCHAR2
3
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Created by whom
VARCHAR2
4
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
5
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Last modified by whom
VARCHAR2
6
MODIFIED_DATE
DATE
7
No
No
Active
Last modified when
DATE
5332
Table: POP_BOARDING_STATUS
POP_BOARDING_STATUS
Published / External
Completed
Code Table for Boarding Status
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Code Table for Boarding Status
1
CODE
VARCHAR2
1
Yes
Yes
Active
Code
VARCHAR2
2
NAME
VARCHAR2
20
Yes
No
Active
Name
VARCHAR2
3
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Created by whom
VARCHAR2
4
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
5
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Last modified by whom
VARCHAR2
6
MODIFIED_DATE
DATE
7
No
No
Active
Last modified by whom
DATE
5333
Table: POP_COVERAGE_AREAS
POP_COVERAGE_AREAS
Published / External
Completed
Coverage Areas Code Table
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Coverage Areas Code Table
1
CODE
VARCHAR2
3
Yes
Yes
Active
Code
VARCHAR2
2
NAME
VARCHAR2
25
Yes
No
Active
Name
VARCHAR2
5334
Table: POP_DAMAGE_TYPE
POP_DAMAGE_TYPE
Published / External
Completed
Code Table for Damage Type
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Code Table for Damage Type
1
CODE
VARCHAR2
2
Yes
Yes
Active
Code
VARCHAR2
2
NAME
VARCHAR2
100
Yes
No
Active
Name
VARCHAR2
3
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Who created the record
VARCHAR2
4
CREATED_DATE
DATE
7
Yes
No
Active
When the record was created
DATE
5
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Who last modified the record
VARCHAR2
6
MODIFIED_DATE
DATE
7
No
No
Active
When the record was last modified
DATE
5335
Table: POP_DELETE_REASON
POP_DELETE_REASON
Published / External
Completed
Table Of Codes That Indicate Whya Record Was Deleted
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Table Of Codes That Indicate Whya Record Was Deleted
1
CODE
VARCHAR2
5
No
No
Active
Code
VARCHAR2
2
NAME
VARCHAR2
30
No
No
Active
Description Of Code
VARCHAR2
3
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Created by whom
VARCHAR2
4
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
5
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Modified by whom
VARCHAR2
6
MODIFIED_DATE
DATE
7
No
No
Active
Modified when
DATE
5336
Table: POP_DROPLINES_USED
POP_DROPLINES_USED
Published / External
Completed
Drop Lines Section of the Gear Log Data.
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Drop Lines Section of the Gear Log Data.
1
DROPLINES_USED_KEY
NUMBER
22
Yes
Yes
10
0
Active
Primary key
NUMBER
2
GEAR_LOG_KEY
NUMBER
22
Yes
No
10
0
Active
Gear log key
NUMBER
3
DROPLINE_LENGTH
NUMBER
22
Yes
No
3
0
Active
In Feet
NUMBER
4
DISTANCE_BETWEEN_DROPLINES
NUMBER
22
Yes
No
5
0
Active
In Feet
NUMBER
5
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Created by whom
VARCHAR2
6
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
7
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Modified by whom
VARCHAR2
8
MODIFIED_DATE
DATE
7
No
No
Active
Modified when
DATE
5337
Table: POP_EXPERIMENTAL_TREATMENT
POP_EXPERIMENTAL_TREATMENT
Published / External
Completed
Table Of Codes That Concern Experimental Observer Trips
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Table Of Codes That Concern Experimental Observer Trips
1
CODE
VARCHAR2
3
Yes
Yes
Active
Experimental Treatment Code
VARCHAR2
2
NAME
VARCHAR2
160
Yes
No
Active
Description Of Experimental Treatment
VARCHAR2
3
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
4
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Modified by whom
VARCHAR2
5
CREATED_BY_USER_ID
VARCHAR2
20
No
No
Active
Created by whom
VARCHAR2
6
MODIFIED_DATE
DATE
7
No
No
Active
Modified when
DATE
5338
Table: POP_FISHING_AREAS
POP_FISHING_AREAS
Published / External
Completed
Used to Calculate Fishing Area by entering the code and the Latitude and Longitude Ranges To Use
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Used to Calculate Fishing Area by entering the code and the Latitude and Longitude Ranges To Use
1
FISHING_AREA_CODE
VARCHAR2
5
Yes
Yes
Active
Fishing Area Code
VARCHAR2
2
LAT_DEG_1
NUMBER
22
Yes
No
3
0
Active
Higher Value In Latitude Degrees Of Point In Fishing Area Rectangle
NUMBER
3
LAT_MIN_1
NUMBER
22
Yes
No
2
0
Active
Higher Value In Latitude Minutes Of Point In Fishing Area Rectangle
NUMBER
4
LAT_HEM_1
VARCHAR2
1
No
No
Active
Higher Value of Latitude Hemisphere Of Point In Fishing Area Rectangle
VARCHAR2
5
LONG_DEG_1
NUMBER
22
Yes
No
3
0
Active
HigherValue In Longitude Degrees Of Point In Fishing Area Rectangle
NUMBER
6
LONG_MIN_1
NUMBER
22
Yes
No
2
0
Active
Higher Value In Longitude Minutes Of Point In Fishing Area Rectangle
NUMBER
7
LONG_HEM_1
VARCHAR2
1
No
No
Active
HigherValue In Lonitude Hemisphere Of Point In Fishing Area Rectangle
VARCHAR2
8
LAT_DEG_2
NUMBER
22
Yes
No
3
0
Active
Lower Value In Latitude Degrees Of Point In Fishing Area Rectangle
NUMBER
9
LAT_MIN_2
NUMBER
22
Yes
No
2
0
Active
Lower Value In Latitude Minutes Of Point In Fishing Area Rectangle
NUMBER
10
LAT_HEM_2
VARCHAR2
1
No
No
Active
Lower Value In Latitude Hemisphere Of Point In Fishing Area Rectangle
VARCHAR2
11
LONG_DEG_2
NUMBER
22
Yes
No
3
0
Active
Lower Value In Longitude Degrees Of Point In Fishing Area Rectangle
NUMBER
12
LONG_MIN_2
NUMBER
22
Yes
No
2
0
Active
Lower Value In Longitude Minutes Of Point In Fishing Area Rectangle
NUMBER
13
LONG_HEM_2
VARCHAR2
1
No
No
Active
Lower Value In Longitude Hemisphere Of Point In Fishing Area Rectangle
VARCHAR2
14
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Who created the record
VARCHAR2
15
CREATED_DATE
DATE
7
Yes
No
Active
When the record was created
DATE
16
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Who last changed the record
VARCHAR2
17
MODIFIED_DATE
DATE
7
No
No
Active
When was the record last changed
DATE
5339
Table: POP_GANGIONS_USED
POP_GANGIONS_USED
Published / External
Completed
Contains infornation On Gangions Used. There may be multiple records per Gear Log formThere may be multiple gangion records per Gear Log Form.Key to Gear Log data is GEAR_LOG_KEY.
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Contains infornation On Gangions Used. There may be multiple records per Gear Log formThere may be multiple gangion records per Gear Log Form.Key to Gear Log data is GEAR_LOG_KEY.
1
GANGIONS_USED_KEY
NUMBER
22
Yes
Yes
10
0
Active
Primary key
NUMBER
2
GEAR_LOG_KEY
NUMBER
22
Yes
No
10
0
Active
Gear Log Key
NUMBER
3
GANGION_LENGTH
NUMBER
22
No
No
4
0
Active
In Feet
NUMBER
4
GANGION_COUNT
NUMBER
22
No
No
4
0
Active
The number of gangions used for the GANGION_LENGTH in this record
NUMBER
5
WERE_LEADERS_USED
VARCHAR2
1
No
No
Active
Were leaders used?
VARCHAR2
6
WERE_SWIVELS_USED
VARCHAR2
1
No
No
Active
Were swivels used?
VARCHAR2
7
NUMBER_SWIVELS_USED
NUMBER
22
No
No
4
0
Active
per gangion
NUMBER
8
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Created by whom
VARCHAR2
9
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
10
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Modified by whom
VARCHAR2
11
MODIFIED_DATE
DATE
7
No
No
Active
Modified when
DATE
5340
Table: POP_GANGION_COLOR
POP_GANGION_COLOR
Published / External
Completed
Code Table for Gangion Color
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Code Table for Gangion Color
1
CODE
VARCHAR2
2
Yes
Yes
Active
Code
VARCHAR2
2
NAME
VARCHAR2
20
Yes
No
Active
Name
VARCHAR2
3
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Created by whom
VARCHAR2
4
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
5
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Last modified by whom
VARCHAR2
6
MODIFIED_DATE
DATE
7
No
No
Active
Last modified when
DATE
5341
Table: POP_GEAR_CONDITION
POP_GEAR_CONDITION
Published / External
Completed
Code Table for Gear Condition
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Code Table for Gear Condition
1
CODE
VARCHAR2
2
Yes
Yes
Active
Code
VARCHAR2
2
NAME
VARCHAR2
50
Yes
No
Active
Name
VARCHAR2
3
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Created by whom
VARCHAR2
4
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
5
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Modified by whom
VARCHAR2
6
MODIFIED_DATE
DATE
7
No
No
Active
Modified when
DATE
5342
Table: POP_GEAR_LOG
POP_GEAR_LOG
Published / External
Completed
One record for each gear log in the trip
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
One record for each gear log in the trip
1
GEAR_LOG_KEY
NUMBER
22
Yes
Yes
10
0
Active
Generated primary key
NUMBER
2
STRING_NUMBER
NUMBER
22
Yes
No
1
0
Active
Consecutive number assigned to each string. Changes that result in a change of target species will necessitate a new string number.
NUMBER
3
NUMBER_HOOKS
NUMBER
22
No
No
4
0
Active
Average number of hooks set calculated over all hauls with the same gear configuration.
NUMBER
4
ANCHOR_USED
VARCHAR2
1
Yes
No
Active
Was an anchor used?
VARCHAR2
5
ANCHOR_WEIGHT
NUMBER
22
No
No
3
0
Active
Units are pounds.
NUMBER
6
MAINLINE_COLOR
VARCHAR2
2
No
No
Active
Coded color of the main line
VARCHAR2
7
MAINLINE_DIAMETER
NUMBER
22
No
No
2
1
Active
In millimeters
NUMBER
8
MAINLINE_STRENGTH
NUMBER
22
No
No
4
0
Active
In pounds
NUMBER
9
MAINLINE_MATERIAL
VARCHAR2
1
No
No
Active
Coded material that the mainline is constructed with.
VARCHAR2
10
MAINLINE_STRANDS
NUMBER
22
No
No
4
0
Active
Number of strands in the mainline
NUMBER
11
WERE_OTHER_FLOATS_USED
VARCHAR2
1
No
No
Active
Were Other Floats Used
VARCHAR2
12
NUMBER_OTHER_FLOATS
NUMBER
22
No
No
4
0
Active
Number of Other Floats used ?
NUMBER
13
NUMBER_HOOKS_BETWEEN_FLOATS
NUMBER
22
No
No
4
0
Active
Maximum number of hooks between floats
NUMBER
14
NUMBER_RADIO_BEACONS
NUMBER
22
No
No
4
0
Active
Number of radio beacons
NUMBER
15
NUMBER_RADAR_REFLECTORS
NUMBER
22
No
No
4
0
Active
Number of radar reflectors
NUMBER
16
NUMBER_SECTIONS
NUMBER
22
No
No
3
0
Active
Number of sections
NUMBER
17
DISTANCE_BETWEEN_SECTIONS
NUMBER
22
No
No
3
1
Active
Distance between sections in nautical miles.
NUMBER
18
WERE_LIGHT_STICKS_USED
VARCHAR2
1
No
No
Active
Were light sticks used
VARCHAR2
19
LIGHT_STICK_COLOR
VARCHAR2
2
No
No
Active
Light stick color. Only populated if light sticks were used.
VARCHAR2
20
GANGION_DISTANCE
NUMBER
22
No
No
4
0
Active
Distance between gangions in feet.
NUMBER
21
GANGION_DIAMETER
NUMBER
22
No
No
4
1
Active
Gangion diameter to the nearest tenth of a millimeter.
NUMBER
22
GANGION_MATERIAL
VARCHAR2
1
No
No
Active
Code of material used for gangions
VARCHAR2
23
GANGION_COLOR
VARCHAR2
2
No
No
Active
Gangion Color Code
VARCHAR2
24
LEADER_LENGTH
NUMBER
22
No
No
4
0
Active
Length of the leader to the nearest inch.
NUMBER
25
LEADER_STRENGTH
NUMBER
22
No
No
4
0
Active
Test or Dry Breaking Weight Strength of the leader in pound.
NUMBER
26
LEADER_MATERIAL
VARCHAR2
1
No
No
Active
Code of Material Used For Leaders.
VARCHAR2
27
COMMENTS
VARCHAR2
2000
No
No
Active
Comments
VARCHAR2
28
GENERATED_RECORD
VARCHAR2
1
No
No
Active
'Y' if a Gear Log record was generated
VARCHAR2
29
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Created by whom
VARCHAR2
30
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
31
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Modified by whom
VARCHAR2
32
MODIFIED_DATE
DATE
7
No
No
Active
Modified when
DATE
33
WERE_POLYBALL_FLOATS_USED
VARCHAR2
1
No
No
Active
Were polybal floats used?
VARCHAR2
34
WERE_BULLET_FLOATS_USED
VARCHAR2
1
No
No
Active
Were Bulet Floats Used
VARCHAR2
35
NUMBER_POLYBALL_FLOATS
NUMBER
22
No
No
4
0
Active
Number of polybal floats.
NUMBER
36
NUMBER_BULLET_FLOATS
NUMBER
22
No
No
4
0
Active
Number of bulet floats
NUMBER
37
GANGION_TEST
NUMBER
22
No
No
4
0
Active
Test or Dry Breaking Weight Strength of the gangion in pounds
NUMBER
38
TRIP_NUMBER
VARCHAR2
6
Yes
No
Active
Link to POP_TRIP_LOG
VARCHAR2
39
STATUS_ID
VARCHAR2
1
No
No
Active
Status Identifier
VARCHAR2
5343
View: POP_GEAR_LOG_EXP_V
POP_GEAR_LOG_EXP_V
Published / External
Completed
One record for each gear log in the trip
Loaded by batch 1683, 10-12-2007 05:01
Data View
Yes
POPOL
One record for each gear log in the trip
1
TRIP_NUMBER
VARCHAR2
6
Yes
No
Active
Link to POP_TRIP_LOG
VARCHAR2
2
LANDING_DATE
DATE
7
Yes
No
Active
Date Boat Landed
DATE
3
STRING_NUMBER
NUMBER
22
Yes
No
1
0
Active
Consecutive number assigned to each string. Changes that result in a change of target species will necessitate a new string number.
NUMBER
4
NUMBER_HOOKS
NUMBER
22
No
No
4
0
Active
Average number of hooks set calculated over all hauls with the same gear configuration.
NUMBER
5
ANCHOR_USED
VARCHAR2
1
Yes
No
Active
Was an anchor used?
VARCHAR2
6
ANCHOR_WEIGHT
NUMBER
22
No
No
3
0
Active
Units are pounds.
NUMBER
7
MAINLINE_COLOR
VARCHAR2
2
No
No
Active
Coded color of the main line
VARCHAR2
8
MAINLINE_STRANDS
NUMBER
22
No
No
4
0
Active
Number of strands in the mainline
NUMBER
9
MAINLINE_DIAMETER
NUMBER
22
No
No
2
1
Active
In millimeters
NUMBER
10
MAINLINE_STRENGTH
NUMBER
22
No
No
4
0
Active
In pounds
NUMBER
11
MAINLINE_MATERIAL
VARCHAR2
1
No
No
Active
Coded material that the mainline is constructed with.
VARCHAR2
12
WERE_POLYBALL_FLOATS_USED
VARCHAR2
1
No
No
Active
Were polybal floats used?
VARCHAR2
13
NUMBER_POLYBALL_FLOATS
NUMBER
22
No
No
4
0
Active
Number of polybal floats.
NUMBER
14
WERE_BULLET_FLOATS_USED
VARCHAR2
1
No
No
Active
Were Bulet Floats Used
VARCHAR2
15
NUMBER_BULLET_FLOATS
NUMBER
22
No
No
4
0
Active
Number of bulet floats
NUMBER
16
WERE_OTHER_FLOATS_USED
VARCHAR2
1
No
No
Active
Were Other Floats Used
VARCHAR2
17
NUMBER_OTHER_FLOATS
NUMBER
22
No
No
4
0
Active
Number of Other Floats used ?
NUMBER
18
NUMBER_HOOKS_BETWEEN_FLOATS
NUMBER
22
No
No
4
0
Active
Maximum number of hooks between floats
NUMBER
19
NUMBER_RADIO_BEACONS
NUMBER
22
No
No
4
0
Active
Number of radio beacons
NUMBER
20
NUMBER_RADAR_REFLECTORS
NUMBER
22
No
No
4
0
Active
Number of radar reflectors
NUMBER
21
NUMBER_SECTIONS
NUMBER
22
No
No
3
0
Active
Number of sections
NUMBER
22
DISTANCE_BETWEEN_SECTIONS
NUMBER
22
No
No
3
1
Active
Distance between sections in nautical miles.
NUMBER
23
WERE_LIGHT_STICKS_USED
VARCHAR2
1
No
No
Active
Were light sticks used
VARCHAR2
24
LIGHT_STICK_COLOR
VARCHAR2
2
No
No
Active
Light stick color. Only populated if light sticks were used.
VARCHAR2
25
GANGION_COLOR
VARCHAR2
2
No
No
Active
Gangion Color Code
VARCHAR2
26
GANGION_DISTANCE
NUMBER
22
No
No
4
0
Active
Distance between gangions in feet.
NUMBER
27
GANGION_DIAMETER
NUMBER
22
No
No
4
1
Active
Gangion diameter to the nearest tenth of a millimeter.
NUMBER
28
GANGION_TEST
NUMBER
22
No
No
4
0
Active
Test or Dry Breaking Weight Strength of the gangion in pounds
NUMBER
29
GANGION_MATERIAL
VARCHAR2
1
No
No
Active
Code of material used for gangions
VARCHAR2
30
GANGION_LENGTH_1
NUMBER
22
No
No
38
Active
Length in feet of first group of Gangions.
NUMBER
31
GANGION_COUNT_1
NUMBER
22
No
No
38
Active
Number Of Gangions In first group.
NUMBER
32
WERE_LEADERS_USED_1
VARCHAR2
4000
No
No
Active
Were Leadersd Used WIth First group Of Gangions
VARCHAR2
33
WERE_SWIVELS_USED_1
VARCHAR2
4000
No
No
Active
Were Swivels USed WIth First group Of Gangions.
VARCHAR2
34
NUMBER_SWIVELS_USED_1
NUMBER
22
No
No
38
Active
Number Of Swivels WIth first group of Gangions.
NUMBER
35
GANGION_LENGTH_2
NUMBER
22
No
No
38
Active
Length in feet of Second group of Gangions.
NUMBER
36
GANGION_COUNT_2
NUMBER
22
No
No
38
Active
Number Of Gangions In Second group.
NUMBER
37
WERE_LEADERS_USED_2
VARCHAR2
4000
No
No
Active
Were Leadersd Used WIth Second group Of Gangions
VARCHAR2
38
WERE_SWIVELS_USED_2
VARCHAR2
4000
No
No
Active
Were Swivels USed WIth Second group Of Gangions.
VARCHAR2
39
NUMBER_SWIVELS_USED_2
NUMBER
22
No
No
38
Active
Number Of Swivels with Second Group Of Gangions.
NUMBER
40
LEADER_LENGTH
NUMBER
22
No
No
4
0
Active
Length of the leader to the nearest inch.
NUMBER
41
LEADER_STRENGTH
NUMBER
22
No
No
4
0
Active
Test or Dry Breaking Weight Strength of the leader in pound.
NUMBER
42
LEADER_MATERIAL
VARCHAR2
1
No
No
Active
Code of Material Used For Leaders.
VARCHAR2
43
DROPLINE_LENGTH_1
NUMBER
22
No
No
38
Active
Length Of First Dropline In Feet Used On Gear Log
NUMBER
44
DISTANCE_BETWEEN_DROPLINES_1
NUMBER
22
No
No
38
Active
Distance Between Droplines in Feet For first dropline indicated for the gear log
NUMBER
45
DROPLINE_LENGTH_2
NUMBER
22
No
No
38
Active
Length Of Second Dropline In Feet Used On Gear Log
NUMBER
46
DISTANCE_BETWEEN_DROPLINES_2
NUMBER
22
No
No
38
Active
Distance Between Droplines in Feet For second dropline indicated for the gear log
NUMBER
47
DROPLINE_LENGTH_3
NUMBER
22
No
No
38
Active
Length Of Third Dropline In Feet Used On Gear Log
NUMBER
48
DISTANCE_BETWEEN_DROPLINES_3
NUMBER
22
No
No
38
Active
Distance Between Droplines in Feet For third dropline indicated for the gear log
NUMBER
49
HOOK_BRAND_1
VARCHAR2
4000
No
No
Active
Brand Name Of First Type Of Hook Used for Gear Log
VARCHAR2
50
HOOK_MODEL_1
VARCHAR2
4000
No
No
Active
Model Type Of First Type of Hook Used For Gear Log
VARCHAR2
51
HOOK_SIZE_1
VARCHAR2
4000
No
No
Active
Size of First Type of Hook Used For Gear Log
VARCHAR2
52
HOOK_TYPE_1
VARCHAR2
4000
No
No
Active
Indicates Whether It is a C hook, a J hook, or unknown hook Model Type Of First Type of Hook Used For Gear Log
VARCHAR2
53
HOOK_BRAND_2
VARCHAR2
4000
No
No
Active
Brand Name Of second Type Of Hook Used for Gear Log
VARCHAR2
54
HOOK_MODEL_2
VARCHAR2
4000
No
No
Active
Model Type Of second Type of Hook Used For Gear Log
VARCHAR2
55
HOOK_SIZE_2
VARCHAR2
4000
No
No
Active
Size of second Type of Hook Used For Gear Log
VARCHAR2
56
HOOK_TYPE_2
VARCHAR2
4000
No
No
Active
Indicates Whether It is a C hook, a J hook, or unknown hook Model Type Of second Type of Hook Used For Gear Log
VARCHAR2
57
HOOK_BRAND_3
VARCHAR2
4000
No
No
Active
Brand Name Of third Type Of Hook Used for Gear Log
VARCHAR2
58
HOOK_MODEL_3
VARCHAR2
4000
No
No
Active
Model Type Of third Type of Hook Used For Gear Log
VARCHAR2
59
HOOK_SIZE_3
VARCHAR2
4000
No
No
Active
Size of third Type of Hook Used For Gear Log
VARCHAR2
60
HOOK_TYPE_3
VARCHAR2
4000
No
No
Active
Indicates Whether It is a C hook, a J hook, or unknown hook Model Type Of third Type of Hook Used For Gear Log
VARCHAR2
61
HOOK_BRAND_4
VARCHAR2
4000
No
No
Active
Brand Name Of fourth Type Of Hook Used for Gear Log
VARCHAR2
62
HOOK_MODEL_4
VARCHAR2
4000
No
No
Active
Model Type Of fourth Type of Hook Used For Gear Log
VARCHAR2
63
HOOK_SIZE_4
VARCHAR2
4000
No
No
Active
Size of fourth Type of Hook Used For Gear Log
VARCHAR2
64
HOOK_TYPE_4
VARCHAR2
4000
No
No
Active
Indicates Whether It is a C hook, a J hook, or unknown hook Model Type Of fourth Type of Hook Used For Gear Log
VARCHAR2
65
HOOK_BRAND_5
VARCHAR2
4000
No
No
Active
Brand Name Of fifth Type Of Hook Used for Gear Log
VARCHAR2
66
HOOK_MODEL_5
VARCHAR2
4000
No
No
Active
Model Type Of fifth Type of Hook Used For Gear Log
VARCHAR2
67
HOOK_SIZE_5
VARCHAR2
4000
No
No
Active
Size of fifth Type of Hook Used For Gear Log
VARCHAR2
68
HOOK_TYPE_5
VARCHAR2
4000
No
No
Active
Indicates Whether It is a C hook, a J hook, or unknown hook Model Type Of fifth Type of Hook Used For Gear Log
VARCHAR2
69
COMMENTS
VARCHAR2
2000
No
No
Active
Comments
VARCHAR2
70
TRIP_TYPE
VARCHAR2
1
No
No
Active
Type Of Observer Trip. May be (S)elected , (N)on Selected, or (E)xperimnetal
VARCHAR2
5344
View: POP_GEAR_LOG_NON_EXP_V
POP_GEAR_LOG_NON_EXP_V
Published / External
Completed
One record for each gear log in the trip
Loaded by batch 1683, 10-12-2007 05:01
Data View
Yes
POPOL
One record for each gear log in the trip
1
TRIP_NUMBER
VARCHAR2
6
Yes
No
Active
Link to POP_TRIP_LOG
VARCHAR2
2
LANDING_DATE
DATE
7
Yes
No
Active
Date Boat Landed.
DATE
3
STRING_NUMBER
NUMBER
22
Yes
No
1
0
Active
Consecutive number assigned to each string. Changes that result in a change of target species will necessitate a new string number.
NUMBER
4
NUMBER_HOOKS
NUMBER
22
No
No
4
0
Active
Average number of hooks set calculated over all hauls with the same gear configuration.
NUMBER
5
ANCHOR_USED
VARCHAR2
1
Yes
No
Active
Was an anchor used?
VARCHAR2
6
ANCHOR_WEIGHT
NUMBER
22
No
No
3
0
Active
Units are pounds.
NUMBER
7
MAINLINE_COLOR
VARCHAR2
2
No
No
Active
Coded color of the main line
VARCHAR2
8
MAINLINE_STRANDS
NUMBER
22
No
No
4
0
Active
Number of strands in the mainline
NUMBER
9
MAINLINE_DIAMETER
NUMBER
22
No
No
2
1
Active
In millimeters
NUMBER
10
MAINLINE_STRENGTH
NUMBER
22
No
No
4
0
Active
In pounds
NUMBER
11
MAINLINE_MATERIAL
VARCHAR2
1
No
No
Active
Coded material that the mainline is constructed with.
VARCHAR2
12
WERE_POLYBALL_FLOATS_USED
VARCHAR2
1
No
No
Active
Were polybal floats used?
VARCHAR2
13
NUMBER_POLYBALL_FLOATS
NUMBER
22
No
No
4
0
Active
Number of polybal floats.
NUMBER
14
WERE_BULLET_FLOATS_USED
VARCHAR2
1
No
No
Active
Were Bulet Floats Used
VARCHAR2
15
NUMBER_BULLET_FLOATS
NUMBER
22
No
No
4
0
Active
Number of bulet floats
NUMBER
16
WERE_OTHER_FLOATS_USED
VARCHAR2
1
No
No
Active
Were Other Floats Used
VARCHAR2
17
NUMBER_OTHER_FLOATS
NUMBER
22
No
No
4
0
Active
Number of Other Floats used ?
NUMBER
18
NUMBER_HOOKS_BETWEEN_FLOATS
NUMBER
22
No
No
4
0
Active
Maximum number of hooks between floats
NUMBER
19
NUMBER_RADIO_BEACONS
NUMBER
22
No
No
4
0
Active
Number of radio beacons
NUMBER
20
NUMBER_RADAR_REFLECTORS
NUMBER
22
No
No
4
0
Active
Number of radar reflectors
NUMBER
21
NUMBER_SECTIONS
NUMBER
22
No
No
3
0
Active
Number of sections
NUMBER
22
DISTANCE_BETWEEN_SECTIONS
NUMBER
22
No
No
3
1
Active
Distance between sections in nautical miles.
NUMBER
23
WERE_LIGHT_STICKS_USED
VARCHAR2
1
No
No
Active
Were light sticks used
VARCHAR2
24
LIGHT_STICK_COLOR
VARCHAR2
2
No
No
Active
Light stick color. Only populated if light sticks were used.
VARCHAR2
25
GANGION_COLOR
VARCHAR2
2
No
No
Active
Gangion Color Code
VARCHAR2
26
GANGION_DISTANCE
NUMBER
22
No
No
4
0
Active
Distance between gangions in feet.
NUMBER
27
GANGION_DIAMETER
NUMBER
22
No
No
4
1
Active
Gangion diameter to the nearest tenth of a millimeter.
NUMBER
28
GANGION_TEST
NUMBER
22
No
No
4
0
Active
Test or Dry Breaking Weight Strength of the gangion in pounds
NUMBER
29
GANGION_MATERIAL
VARCHAR2
1
No
No
Active
Code of material used for gangions
VARCHAR2
30
GANGION_LENGTH_1
NUMBER
22
No
No
38
Active
Length in feet of first group of Gangions.
NUMBER
31
GANGION_COUNT_1
NUMBER
22
No
No
38
Active
Number Of Gangions In first group.
NUMBER
32
WERE_LEADERS_USED_1
VARCHAR2
4000
No
No
Active
Were Leadersd Used WIth First group Of Gangions
VARCHAR2
33
WERE_SWIVELS_USED_1
VARCHAR2
4000
No
No
Active
Were Swivels USed WIth First group Of Gangions.
VARCHAR2
34
NUMBER_SWIVELS_USED_1
NUMBER
22
No
No
38
Active
Number Of Swivels WIth first group of Gangions.
NUMBER
35
GANGION_LENGTH_2
NUMBER
22
No
No
38
Active
Length in feet of Second group of Gangions.
NUMBER
36
GANGION_COUNT_2
NUMBER
22
No
No
38
Active
Number Of Gangions In Second group.
NUMBER
37
WERE_LEADERS_USED_2
VARCHAR2
4000
No
No
Active
Were Leadersd Used WIth Second group Of Gangions
VARCHAR2
38
WERE_SWIVELS_USED_2
VARCHAR2
4000
No
No
Active
Were Swivels USed WIth Second group Of Gangions.
VARCHAR2
39
NUMBER_SWIVELS_USED_2
NUMBER
22
No
No
38
Active
Number Of Swivels with Second Group Of Gangions.
NUMBER
40
LEADER_LENGTH
NUMBER
22
No
No
4
0
Active
Length of the leader to the nearest inch.
NUMBER
41
LEADER_STRENGTH
NUMBER
22
No
No
4
0
Active
Test or Dry Breaking Weight Strength of the leader in pound.
NUMBER
42
LEADER_MATERIAL
VARCHAR2
1
No
No
Active
Code of Material Used For Leaders.
VARCHAR2
43
DROPLINE_LENGTH_1
NUMBER
22
No
No
38
Active
Length Of First Dropline In Feet Used On Gear Log
NUMBER
44
DISTANCE_BETWEEN_DROPLINES_1
NUMBER
22
No
No
38
Active
Distance Between Droplines in Feet For first dropline indicated for the gear log
NUMBER
45
DROPLINE_LENGTH_2
NUMBER
22
No
No
38
Active
Length Of Second Dropline In Feet Used On Gear Log
NUMBER
46
DISTANCE_BETWEEN_DROPLINES_2
NUMBER
22
No
No
38
Active
Distance Between Droplines in Feet For second dropline indicated for the gear log
NUMBER
47
DROPLINE_LENGTH_3
NUMBER
22
No
No
38
Active
Length Of Third Dropline In Feet Used On Gear Log
NUMBER
48
DISTANCE_BETWEEN_DROPLINES_3
NUMBER
22
No
No
38
Active
Distance Between Droplines in Feet For third dropline indicated for the gear log
NUMBER
49
HOOK_BRAND_1
VARCHAR2
4000
No
No
Active
Brand Name Of First Type Of Hook Used for Gear Log
VARCHAR2
50
HOOK_MODEL_1
VARCHAR2
4000
No
No
Active
Model Type Of First Type of Hook Used For Gear Log
VARCHAR2
51
HOOK_SIZE_1
VARCHAR2
4000
No
No
Active
Size of First Type of Hook Used For Gear Log
VARCHAR2
52
HOOK_TYPE_1
VARCHAR2
4000
No
No
Active
Indicates Whether It is a C hook, a J hook, or unknown hook Model Type Of First Type of Hook Used For Gear Log
VARCHAR2
53
HOOK_BRAND_2
VARCHAR2
4000
No
No
Active
Brand Name Of second Type Of Hook Used for Gear Log
VARCHAR2
54
HOOK_MODEL_2
VARCHAR2
4000
No
No
Active
Model Type Of second Type of Hook Used For Gear Log
VARCHAR2
55
HOOK_SIZE_2
VARCHAR2
4000
No
No
Active
Size of second Type of Hook Used For Gear Log
VARCHAR2
56
HOOK_TYPE_2
VARCHAR2
4000
No
No
Active
Indicates Whether It is a C hook, a J hook, or unknown hook Model Type Of second Type of Hook Used For Gear Log
VARCHAR2
57
HOOK_BRAND_3
VARCHAR2
4000
No
No
Active
Brand Name Of third Type Of Hook Used for Gear Log
VARCHAR2
58
HOOK_MODEL_3
VARCHAR2
4000
No
No
Active
Model Type Of third Type of Hook Used For Gear Log
VARCHAR2
59
HOOK_SIZE_3
VARCHAR2
4000
No
No
Active
Size of third Type of Hook Used For Gear Log
VARCHAR2
60
HOOK_TYPE_3
VARCHAR2
4000
No
No
Active
Indicates Whether It is a C hook, a J hook, or unknown hook Model Type Of third Type of Hook Used For Gear Log
VARCHAR2
61
HOOK_BRAND_4
VARCHAR2
4000
No
No
Active
Brand Name Of fourth Type Of Hook Used for Gear Log
VARCHAR2
62
HOOK_MODEL_4
VARCHAR2
4000
No
No
Active
Model Type Of fourth Type of Hook Used For Gear Log
VARCHAR2
63
HOOK_SIZE_4
VARCHAR2
4000
No
No
Active
Size of fourth Type of Hook Used For Gear Log
VARCHAR2
64
HOOK_TYPE_4
VARCHAR2
4000
No
No
Active
Indicates Whether It is a C hook, a J hook, or unknown hook Model Type Of fourth Type of Hook Used For Gear Log
VARCHAR2
65
HOOK_BRAND_5
VARCHAR2
4000
No
No
Active
Brand Name Of fifth Type Of Hook Used for Gear Log
VARCHAR2
66
HOOK_MODEL_5
VARCHAR2
4000
No
No
Active
Model Type Of fifth Type of Hook Used For Gear Log
VARCHAR2
67
HOOK_SIZE_5
VARCHAR2
4000
No
No
Active
Size of fifth Type of Hook Used For Gear Log
VARCHAR2
68
HOOK_TYPE_5
VARCHAR2
4000
No
No
Active
Indicates Whether It is a C hook, a J hook, or unknown hook Model Type Of fifth Type of Hook Used For Gear Log
VARCHAR2
69
COMMENTS
VARCHAR2
2000
No
No
Active
Comments
VARCHAR2
70
TRIP_TYPE
VARCHAR2
1
No
No
Active
Type Of Observer Trip. May be (S)elected , (N)on Selected, or (E)xperimnetal.
VARCHAR2
5345
View: POP_GEAR_LOG_V
POP_GEAR_LOG_V
Published / External
Completed
Combined View Of Experimental and Non Experimental Gear Logs.
Loaded by batch 1683, 10-12-2007 05:01
Data View
Yes
POPOL
Combined View Of Experimental and Non Experimental Gear Logs.
1
TRIP_NUMBER
VARCHAR2
6
Yes
No
Active
Link to POP_TRIP_LOG
VARCHAR2
2
LANDING_DATE
DATE
7
Yes
No
Active
Date Boat Landed.
DATE
3
STRING_NUMBER
NUMBER
22
Yes
No
1
0
Active
Consecutive number assigned to each string. Changes that result in a change of target species will necessitate a new string number.
NUMBER
4
NUMBER_HOOKS
NUMBER
22
No
No
4
0
Active
Average number of hooks set calculated over all hauls with the same gear configuration.
NUMBER
5
ANCHOR_USED
VARCHAR2
1
Yes
No
Active
Was an anchor used?
VARCHAR2
6
ANCHOR_WEIGHT
NUMBER
22
No
No
3
0
Active
Units are pounds.
NUMBER
7
MAINLINE_COLOR
VARCHAR2
2
No
No
Active
Coded color of the main line
VARCHAR2
8
MAINLINE_STRANDS
NUMBER
22
No
No
4
0
Active
Number of strands in the mainline
NUMBER
9
MAINLINE_DIAMETER
NUMBER
22
No
No
2
1
Active
In millimeters
NUMBER
10
MAINLINE_STRENGTH
NUMBER
22
No
No
4
0
Active
In pounds
NUMBER
11
MAINLINE_MATERIAL
VARCHAR2
1
No
No
Active
Coded material that the mainline is constructed with.
VARCHAR2
12
WERE_POLYBALL_FLOATS_USED
VARCHAR2
1
No
No
Active
Were polybal floats used?
VARCHAR2
13
NUMBER_POLYBALL_FLOATS
NUMBER
22
No
No
4
0
Active
Number of polybal floats.
NUMBER
14
WERE_BULLET_FLOATS_USED
VARCHAR2
1
No
No
Active
Were Bulet Floats Used
VARCHAR2
15
NUMBER_BULLET_FLOATS
NUMBER
22
No
No
4
0
Active
Number of bulet floats
NUMBER
16
WERE_OTHER_FLOATS_USED
VARCHAR2
1
No
No
Active
Were Other Floats Used
VARCHAR2
17
NUMBER_OTHER_FLOATS
NUMBER
22
No
No
4
0
Active
Number of Other Floats used ?
NUMBER
18
NUMBER_HOOKS_BETWEEN_FLOATS
NUMBER
22
No
No
4
0
Active
Maximum number of hooks between floats
NUMBER
19
NUMBER_RADIO_BEACONS
NUMBER
22
No
No
4
0
Active
Number of radio beacons
NUMBER
20
NUMBER_RADAR_REFLECTORS
NUMBER
22
No
No
4
0
Active
Number of radar reflectors
NUMBER
21
NUMBER_SECTIONS
NUMBER
22
No
No
3
0
Active
Number of sections
NUMBER
22
DISTANCE_BETWEEN_SECTIONS
NUMBER
22
No
No
3
1
Active
Distance between sections in nautical miles.
NUMBER
23
WERE_LIGHT_STICKS_USED
VARCHAR2
1
No
No
Active
Were light sticks used
VARCHAR2
24
LIGHT_STICK_COLOR
VARCHAR2
2
No
No
Active
Light stick color. Only populated if light sticks were used.
VARCHAR2
25
GANGION_COLOR
VARCHAR2
2
No
No
Active
Gangion Color Code
VARCHAR2
26
GANGION_DISTANCE
NUMBER
22
No
No
4
0
Active
Distance between gangions in feet.
NUMBER
27
GANGION_DIAMETER
NUMBER
22
No
No
4
1
Active
Gangion diameter to the nearest tenth of a millimeter.
NUMBER
28
GANGION_TEST
NUMBER
22
No
No
4
0
Active
Test or Dry Breaking Weight Strength of the gangion in pounds
NUMBER
29
GANGION_MATERIAL
VARCHAR2
1
No
No
Active
Code of material used for gangions
VARCHAR2
30
GANGION_LENGTH_1
NUMBER
22
No
No
38
Active
Length in feet of first group of Gangions.
NUMBER
31
GANGION_COUNT_1
NUMBER
22
No
No
38
Active
Number Of Gangions In first group.
NUMBER
32
WERE_LEADERS_USED_1
VARCHAR2
4000
No
No
Active
Were Leadersd Used WIth First group Of Gangions
VARCHAR2
33
WERE_SWIVELS_USED_1
VARCHAR2
4000
No
No
Active
Were Swivels USed WIth First group Of Gangions.
VARCHAR2
34
NUMBER_SWIVELS_USED_1
NUMBER
22
No
No
38
Active
Number Of Swivels WIth first group of Gangions.
NUMBER
35
GANGION_LENGTH_2
NUMBER
22
No
No
38
Active
Length in feet of Second group of Gangions.
NUMBER
36
GANGION_COUNT_2
NUMBER
22
No
No
38
Active
Number Of Gangions In Second group.
NUMBER
37
WERE_LEADERS_USED_2
VARCHAR2
4000
No
No
Active
Were Leadersd Used WIth Second group Of Gangions
VARCHAR2
38
WERE_SWIVELS_USED_2
VARCHAR2
4000
No
No
Active
Were Swivels USed WIth Second group Of Gangions.
VARCHAR2
39
NUMBER_SWIVELS_USED_2
NUMBER
22
No
No
38
Active
Number Of Swivels with Second Group Of Gangions.
NUMBER
40
LEADER_LENGTH
NUMBER
22
No
No
4
0
Active
Length of the leader to the nearest inch.
NUMBER
41
LEADER_STRENGTH
NUMBER
22
No
No
4
0
Active
Test or Dry Breaking Weight Strength of the leader in pound.
NUMBER
42
LEADER_MATERIAL
VARCHAR2
1
No
No
Active
Code of Material Used For Leaders.
VARCHAR2
43
DROPLINE_LENGTH_1
NUMBER
22
No
No
38
Active
Length Of First Dropline In Feet Used On Gear Log
NUMBER
44
DISTANCE_BETWEEN_DROPLINES_1
NUMBER
22
No
No
38
Active
Distance Between Droplines in Feet For first dropline indicated for the gear log
NUMBER
45
DROPLINE_LENGTH_2
NUMBER
22
No
No
38
Active
Length Of Second Dropline In Feet Used On Gear Log
NUMBER
46
DISTANCE_BETWEEN_DROPLINES_2
NUMBER
22
No
No
38
Active
Distance Between Droplines in Feet For second dropline indicated for the gear log
NUMBER
47
DROPLINE_LENGTH_3
NUMBER
22
No
No
38
Active
Length Of Third Dropline In Feet Used On Gear Log
NUMBER
48
DISTANCE_BETWEEN_DROPLINES_3
NUMBER
22
No
No
38
Active
Distance Between Droplines in Feet For third dropline indicated for the gear log
NUMBER
49
HOOK_BRAND_1
VARCHAR2
4000
No
No
Active
Brand Name Of First Type Of Hook Used for Gear Log
VARCHAR2
50
HOOK_MODEL_1
VARCHAR2
4000
No
No
Active
Model Type Of First Type of Hook Used For Gear Log
VARCHAR2
51
HOOK_SIZE_1
VARCHAR2
4000
No
No
Active
Size of First Type of Hook Used For Gear Log
VARCHAR2
52
HOOK_TYPE_1
VARCHAR2
4000
No
No
Active
Indicates Whether It is a C hook, a J hook, or unknown hook Model Type Of First Type of Hook Used For Gear Log
VARCHAR2
53
HOOK_BRAND_2
VARCHAR2
4000
No
No
Active
Brand Name Of second Type Of Hook Used for Gear Log
VARCHAR2
54
HOOK_MODEL_2
VARCHAR2
4000
No
No
Active
Model Type Of second Type of Hook Used For Gear Log
VARCHAR2
55
HOOK_SIZE_2
VARCHAR2
4000
No
No
Active
Size of second Type of Hook Used For Gear Log
VARCHAR2
56
HOOK_TYPE_2
VARCHAR2
4000
No
No
Active
Indicates Whether It is a C hook, a J hook, or unknown hook Model Type Of second Type of Hook Used For Gear Log
VARCHAR2
57
HOOK_BRAND_3
VARCHAR2
4000
No
No
Active
Brand Name Of third Type Of Hook Used for Gear Log
VARCHAR2
58
HOOK_MODEL_3
VARCHAR2
4000
No
No
Active
Model Type Of third Type of Hook Used For Gear Log
VARCHAR2
59
HOOK_SIZE_3
VARCHAR2
4000
No
No
Active
Size of third Type of Hook Used For Gear Log
VARCHAR2
60
HOOK_TYPE_3
VARCHAR2
4000
No
No
Active
Indicates Whether It is a C hook, a J hook, or unknown hook Model Type Of third Type of Hook Used For Gear Log
VARCHAR2
61
HOOK_BRAND_4
VARCHAR2
4000
No
No
Active
Brand Name Of fourth Type Of Hook Used for Gear Log
VARCHAR2
62
HOOK_MODEL_4
VARCHAR2
4000
No
No
Active
Model Type Of fourth Type of Hook Used For Gear Log
VARCHAR2
63
HOOK_SIZE_4
VARCHAR2
4000
No
No
Active
Size of fourth Type of Hook Used For Gear Log
VARCHAR2
64
HOOK_TYPE_4
VARCHAR2
4000
No
No
Active
Indicates Whether It is a C hook, a J hook, or unknown hook Model Type Of fourth Type of Hook Used For Gear Log
VARCHAR2
65
HOOK_BRAND_5
VARCHAR2
4000
No
No
Active
Brand Name Of fifth Type Of Hook Used for Gear Log
VARCHAR2
66
HOOK_MODEL_5
VARCHAR2
4000
No
No
Active
Model Type Of fifth Type of Hook Used For Gear Log
VARCHAR2
67
HOOK_SIZE_5
VARCHAR2
4000
No
No
Active
Size of fifth Type of Hook Used For Gear Log
VARCHAR2
68
HOOK_TYPE_5
VARCHAR2
4000
No
No
Active
Indicates Whether It is a C hook, a J hook, or unknown hook Model Type Of fifth Type of Hook Used For Gear Log
VARCHAR2
69
COMMENTS
VARCHAR2
2000
No
No
Active
Comments
VARCHAR2
5346
Table: POP_GEAR_MATERIAL
POP_GEAR_MATERIAL
Published / External
Completed
Materials used to make gear
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Materials used to make gear
1
CODE
VARCHAR2
15
Yes
Yes
Active
Code
VARCHAR2
2
NAME
VARCHAR2
20
Yes
No
Active
Name
VARCHAR2
3
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Who created the record
VARCHAR2
4
CREATED_DATE
DATE
7
Yes
No
Active
When was the record created
DATE
5
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Who last modified the record
VARCHAR2
6
MODIFIED_DATE
DATE
7
No
No
Active
When was the record last modified
DATE
5347
Table: POP_HAUL_LOG
POP_HAUL_LOG
Published / External
Completed
Haul Log Information
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Haul Log Information
1
GEAR_LOG_KEY
NUMBER
22
Yes
No
10
0
Active
Gear Log Key
NUMBER
2
HAUL_LOG_KEY
NUMBER
22
Yes
Yes
10
0
Active
Primary Key
NUMBER
3
HAUL_NUMBER
NUMBER
22
Yes
No
2
0
Active
Haul Number
NUMBER
4
GEAR_CODE
VARCHAR2
3
Yes
No
Active
NMFS Gear Code
VARCHAR2
5
WAS_HAUL_OBSERVED
VARCHAR2
1
Yes
No
Active
Was haul observed?
VARCHAR2
6
WAS_CATCH
VARCHAR2
1
Yes
No
Active
Were fish caught in the haul?
VARCHAR2
7
WAS_INCIDENTAL_TAKE
VARCHAR2
1
Yes
No
Active
Was incidental take?
VARCHAR2
8
WEATHER_DESCRIPTION
VARCHAR2
2
No
No
Active
Code For Weather Condition at time of the beginning of the haul.
VARCHAR2
9
WIND_SPEED
NUMBER
22
No
No
2
0
Active
In knots at the beginning of the haul.
NUMBER
10
WIND_DIRECTION
VARCHAR2
3
No
No
Active
In compass degrees at the beginning of the haul.
VARCHAR2
11
WAVE_HEIGHT
NUMBER
22
No
No
2
0
Active
Max. Wave Height at the beginning of the haul in feet
NUMBER
12
REVERSE_HAUL
VARCHAR2
1
No
No
Active
The last hook set is the first hook hauled.
VARCHAR2
13
GEAR_CONDITION
VARCHAR2
2
No
No
Active
Gear Condition at the completion of the haul
VARCHAR2
14
MAINLINE_LENGTH
NUMBER
22
No
No
4
1
Active
In nautical miles
NUMBER
15
SET_SPEED
NUMBER
22
No
No
3
1
Active
In Knots
NUMBER
16
BOTTOM_DEPTH_MINIMUM
NUMBER
22
No
No
4
0
Active
In fathoms.
NUMBER
17
BOTTOM_DEPTH_MAXIMUM
NUMBER
22
No
No
4
0
Active
In fathoms.
NUMBER
18
HOOK_DEPTH_MINIMUM
NUMBER
22
No
No
4
0
Active
In fathoms
NUMBER
19
HOOK_DEPTH_MAXIMUM
NUMBER
22
No
No
4
0
Active
In fathoms
NUMBER
20
TOTAL_ADDITIONAL_WEIGHT
NUMBER
22
No
No
5
0
Active
In Pounds
NUMBER
21
TARGET_SPECIES
VARCHAR2
3
Yes
No
Active
Uses Pop Species Code.
VARCHAR2
22
SOAK_DURATION
NUMBER
22
No
No
4
1
Active
In Hours
NUMBER
23
WERE_FLOATS_USED
VARCHAR2
1
No
No
Active
Were Floats Used
VARCHAR2
24
NUMBER_OF_FLOATS
NUMBER
22
No
No
4
0
Active
Number of floats used during the haul.
NUMBER
25
WERE_LIGHT_STICKS_USED
VARCHAR2
1
No
No
Active
Were Light Sticks Used
VARCHAR2
26
NUMBER_LIGHT_STICKS
NUMBER
22
No
No
4
0
Active
Populated only if were_light_sticks_used is set to yes.
NUMBER
27
WERE_RATTLERS_USED
VARCHAR2
1
No
No
Active
Were Rattlers Used
VARCHAR2
28
NUMBER_RATTLERS
NUMBER
22
No
No
4
0
Active
Populated only if were_rattlers_used is set to yes.
NUMBER
29
WERE_SURF_LITES_USED
VARCHAR2
1
No
No
Active
Were Surf Lites Used
VARCHAR2
30
NUMBER_SURF_LITES
NUMBER
22
No
No
2
0
Active
Populated only if were_surf_lites_used is set to yes.
NUMBER
31
WERE_RADIO_BEACONS_USED
VARCHAR2
1
No
No
Active
Were Radio Beacons Used
VARCHAR2
32
NUMBER_RADIO_BEACONS
NUMBER
22
No
No
2
0
Active
Populated only if were_radio_beacons_used is set to yes.
NUMBER
33
WERE_RADAR_REFLECTORS_USED
VARCHAR2
1
No
No
Active
Were radar relectors used
VARCHAR2
34
NUMBER_RADAR_REFLECTORS
NUMBER
22
No
No
4
0
Active
Populated only if number_radar_reflectors_used is set to yes.
NUMBER
35
ADDITIONAL_LINE_WEIGHTS_USED
VARCHAR2
1
No
No
Active
Were Additional Line Weights used
VARCHAR2
36
NUMBER_ADDITIONAL_LINE_WEIGHTS
NUMBER
22
No
No
3
0
Active
Populated only if addtional_line_weights_used is set to yes.
NUMBER
37
NUMBER_HOOKS_SET
NUMBER
22
No
No
4
0
Active
Number of Hooks set
NUMBER
38
NUMBER_HOOKS_LOST
NUMBER
22
No
No
4
0
Active
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.
NUMBER
39
NUMBER_HOOKS_TENDED
NUMBER
22
No
No
4
0
Active
Number of Hooks Pulled during hotlining, which is when the vessel runs the line and pulls hooks where floats are submerged.
NUMBER
40
NUMBER_HOOKS_REBAITED
NUMBER
22
No
No
4
0
Active
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.
NUMBER
41
BEGIN_SET_DATE
DATE
7
No
No
Active
Hours and minutes are included in the time.
DATE
42
END_SET_DATE
DATE
7
No
No
Active
Hours and minutes are included in the time.
DATE
43
BEGIN_HAUL_DATE
DATE
7
No
No
Active
Hours and minutes are included in the time.
DATE
44
END_HAUL_DATE
DATE
7
No
No
Active
Time includes year, date, hours and minutes.
DATE
45
BEGIN_SET_LATITUDE
NUMBER
22
No
No
2
0
Active
Begin Set Latitude Degrees
NUMBER
46
BEGIN_SET_LATITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
Begin Set Latitude Minutes
NUMBER
47
BEGIN_SET_LATITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
Begin Set Latitude Hemisphere.
VARCHAR2
48
END_SET_LATITUDE
NUMBER
22
No
No
2
0
Active
End Set Latitude Degrees
NUMBER
49
END_SET_LATITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
End Set Latitude Minutes
NUMBER
50
END_SET_LATITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
End Set Latitude Hemisphere
VARCHAR2
51
BEGIN_HAUL_LATITUDE
NUMBER
22
No
No
2
0
Active
Begin Haul Latitude Degrees
NUMBER
52
BEGIN_HAUL_LATITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
Begin Haul Latitude Minutes
NUMBER
53
BEGIN_HAUL_LATITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
Begin Haul Latitude Hemisphere
VARCHAR2
54
END_HAUL_LATITUDE
NUMBER
22
No
No
2
0
Active
End Haul Latitude Degrees
NUMBER
55
END_HAUL_LATITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
End Haul Latitude Minutes
NUMBER
56
END_HAUL_LATITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
End Haul Latitude Hemisphere
VARCHAR2
57
BEGIN_SET_LONGITUDE
NUMBER
22
No
No
3
0
Active
Begin Set Longitude Degrees
NUMBER
58
BEGIN_SET_LONGITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
Begin Set Longitude Minutes
NUMBER
59
BEGIN_SET_LONGITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
Begin Set Longitude Hemisphere
VARCHAR2
60
END_SET_LONGITUDE
NUMBER
22
No
No
3
0
Active
End Set Longitude Degrees
NUMBER
61
END_SET_LONGITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
End Set Longitude Minutes
NUMBER
62
END_SET_LONGITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
End Set Longitude Hemisphere
VARCHAR2
63
BEGIN_HAUL_LONGITUDE
NUMBER
22
No
No
3
0
Active
Begin Haul Longitude Degrees
NUMBER
64
BEGIN_HAUL_LONGITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
Begin Haul Longitude Minutes
NUMBER
65
BEGIN_HAUL_LONGITUDE_HEMISPHER
VARCHAR2
1
Yes
No
Active
Begin Haul Longitude Hemisphere
VARCHAR2
66
END_HAUL_LONGITUDE
NUMBER
22
No
No
3
0
Active
End Haul Longitude Degrees
NUMBER
67
END_HAUL_LONGITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
End Haul Longitude Minutes
NUMBER
68
END_HAUL_LONGITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
End Haul Longitude Hemisphere
VARCHAR2
69
BEGIN_SET_TEMPERATURE
NUMBER
22
No
No
3
1
Active
In Fahrenheit
NUMBER
70
END_SET_TEMPERATURE
NUMBER
22
No
No
3
1
Active
In Fahrenheit
NUMBER
71
BEGIN_HAUL_TEMPERATURE
NUMBER
22
No
No
3
1
Active
In Fahrenheit
NUMBER
72
END_HAUL_TEMPERATURE
NUMBER
22
No
No
3
1
Active
In Fahrenheit
NUMBER
73
SET_DURATION
NUMBER
22
No
No
4
1
Active
Set Duration In Hours
NUMBER
74
HAUL_LOST_TIME
NUMBER
22
No
No
4
1
Active
Time Lost During Haul. (In Hours)
NUMBER
75
HAUL_DURATION
NUMBER
22
No
No
4
1
Active
In Hours
NUMBER
76
FISHING_AREA
VARCHAR2
3
No
No
Active
Fishing Area
VARCHAR2
77
EXPERIMENTAL_TREATMENT
VARCHAR2
3
No
No
Active
Refers to certain experimental PLOP data.The value assigned here is defined by experimental parameters that can be gotten from Cheryl Brown.
VARCHAR2
78
COMMENTS
VARCHAR2
2000
No
No
Active
Observer comments about the haul
VARCHAR2
79
IS_EXPERIMENT
VARCHAR2
1
No
No
Active
Is an experimental haul?
VARCHAR2
80
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Created by whom
VARCHAR2
81
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
82
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Modified by whom
VARCHAR2
83
MODIFIED_DATE
DATE
7
No
No
Active
Modified when
DATE
5348
View: POP_HAUL_LOG_EXP_V
POP_HAUL_LOG_EXP_V
Published / External
Completed
View Of Experimental Haul Logs.
Loaded by batch 1683, 10-12-2007 05:01
Data View
Yes
POPOL
View Of Experimental Haul Logs.
1
TRIP_NUMBER
VARCHAR2
6
Yes
No
Active
TRIP_NUMBER
VARCHAR2
2
LANDING_DATE
DATE
7
Yes
No
Active
Date Of Landing Of The Vessel
DATE
3
HAUL_NUMBER
NUMBER
22
Yes
No
2
0
Active
Haul Number
NUMBER
4
GEAR_CODE
VARCHAR2
3
Yes
No
Active
NMFS Gear Code
VARCHAR2
5
WAS_HAUL_OBSERVED
VARCHAR2
1
Yes
No
Active
Was haul observed?
VARCHAR2
6
WAS_CATCH
VARCHAR2
1
Yes
No
Active
Were fish caught in the haul?
VARCHAR2
7
WAS_INCIDENTAL_TAKE
VARCHAR2
1
Yes
No
Active
Was incidental take?
VARCHAR2
8
WEATHER_DESCRIPTION
VARCHAR2
2
No
No
Active
Code For Weather Condition at time of the beginning of the haul.
VARCHAR2
9
WIND_SPEED
NUMBER
22
No
No
2
0
Active
In knots at the beginning of the haul.
NUMBER
10
WIND_DIRECTION
VARCHAR2
3
No
No
Active
In compass degrees at the beginning of the haul.
VARCHAR2
11
WAVE_HEIGHT
NUMBER
22
No
No
2
0
Active
Max. Wave Height at the beginning of the haul in feet
NUMBER
12
REVERSE_HAUL
VARCHAR2
1
No
No
Active
The last hook set is the first hook hauled.
VARCHAR2
13
GEAR_CONDITION
VARCHAR2
2
No
No
Active
Gear Condition at the completion of the haul
VARCHAR2
14
STRING_NUMBER
NUMBER
22
Yes
No
1
0
Active
STRING_NUMBER Of Parent Gear Log Record.
NUMBER
15
MAINLINE_LENGTH
NUMBER
22
No
No
4
1
Active
In nautical miles
NUMBER
16
SET_SPEED
NUMBER
22
No
No
3
1
Active
In Knots
NUMBER
17
BOTTOM_DEPTH_MINIMUM
NUMBER
22
No
No
4
0
Active
In fathoms.
NUMBER
18
BOTTOM_DEPTH_MAXIMUM
NUMBER
22
No
No
4
0
Active
In fathoms.
NUMBER
19
HOOK_DEPTH_MINIMUM
NUMBER
22
No
No
4
0
Active
In fathoms
NUMBER
20
HOOK_DEPTH_MAXIMUM
NUMBER
22
No
No
4
0
Active
In fathoms
NUMBER
21
TOTAL_ADDITIONAL_WEIGHT
NUMBER
22
No
No
5
0
Active
In Pounds
NUMBER
22
TARGET_SPECIES
VARCHAR2
3
Yes
No
Active
Uses Pop Species Code.
VARCHAR2
23
SOAK_DURATION
NUMBER
22
No
No
4
1
Active
In Hours
NUMBER
24
WERE_FLOATS_USED
VARCHAR2
1
No
No
Active
Were Floats Used
VARCHAR2
25
NUMBER_OF_FLOATS
NUMBER
22
No
No
4
0
Active
Number of floats used during the haul.
NUMBER
26
WERE_LIGHT_STICKS_USED
VARCHAR2
1
No
No
Active
Were Light Sticks Used
VARCHAR2
27
NUMBER_LIGHT_STICKS
NUMBER
22
No
No
4
0
Active
Populated only if were_light_sticks_used is set to yes.
NUMBER
28
WERE_RATTLERS_USED
VARCHAR2
1
No
No
Active
Were Rattlers Used
VARCHAR2
29
NUMBER_RATTLERS
NUMBER
22
No
No
4
0
Active
Populated only if were_rattlers_used is set to yes.
NUMBER
30
WERE_SURF_LITES_USED
VARCHAR2
1
No
No
Active
Were Surf Lites Used
VARCHAR2
31
NUMBER_SURF_LITES
NUMBER
22
No
No
2
0
Active
Populated only if were_surf_lites_used is set to yes.
NUMBER
32
WERE_RADIO_BEACONS_USED
VARCHAR2
1
No
No
Active
Were Radio Beacons Used
VARCHAR2
33
NUMBER_RADIO_BEACONS
NUMBER
22
No
No
2
0
Active
Populated only if were_radio_beacons_used is set to yes.
NUMBER
34
WERE_RADAR_REFLECTORS_USED
VARCHAR2
1
No
No
Active
Were radar relectors used
VARCHAR2
35
NUMBER_RADAR_REFLECTORS
NUMBER
22
No
No
4
0
Active
Populated only if number_radar_reflectors_used is set to yes.
NUMBER
36
ADDITIONAL_LINE_WEIGHTS_USED
VARCHAR2
1
No
No
Active
Were Additional Line Weights used
VARCHAR2
37
NUMBER_ADDITIONAL_LINE_WEIGHTS
NUMBER
22
No
No
3
0
Active
Populated only if addtional_line_weights_used is set to yes.
NUMBER
38
NUMBER_HOOKS_SET
NUMBER
22
No
No
4
0
Active
Number of Hooks set
NUMBER
39
NUMBER_HOOKS_LOST
NUMBER
22
No
No
4
0
Active
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.
NUMBER
40
NUMBER_HOOKS_TENDED
NUMBER
22
No
No
4
0
Active
Number of Hooks Pulled during hotlining, which is when the vessel runs the line and pulls hooks where floats are submerged.
NUMBER
41
NUMBER_HOOKS_REBAITED
NUMBER
22
No
No
4
0
Active
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.
NUMBER
42
BAIT_NUMBER_USED_1
NUMBER
22
No
No
38
Active
Number Of Individual Baits For First Bait indicated for the haul
NUMBER
43
BAIT_WEIGHT_1
NUMBER
22
No
No
38
Active
Baith Weight (Units Are In LBS) For First Bait Indicated for the haul
NUMBER
44
BAIT_KIND_1
VARCHAR2
4000
No
No
Active
A code which indicates the kind of bait used with first bait indicated for the haul.
VARCHAR2
45
BAIT_TYPE_1
VARCHAR2
4000
No
No
Active
A code which indicates the type of bait used/ (Whole, cut, lIve, Other etc) used with the first bait indicated for the haul
VARCHAR2
46
BAIT_CONDITION_1
VARCHAR2
4000
No
No
Active
The code for the condition of the bait used associated with the first bait indicated for the haul.
VARCHAR2
47
BAIT_NUMBER_USED_2
NUMBER
22
No
No
38
Active
Number Of Individual Baits For Second Bait indicated for the haul
NUMBER
48
BAIT_WEIGHT_2
NUMBER
22
No
No
38
Active
Baith Weight (Units Are In LBS) for Second Bait Indicated for the haul
NUMBER
49
BAIT_KIND_2
VARCHAR2
4000
No
No
Active
A code which indicates the kind of bait used with Second bait indicated for the haul.
VARCHAR2
50
BAIT_TYPE_2
VARCHAR2
4000
No
No
Active
A code which indicates the type of bait used/ (Whole, cut, lIve, Other etc) used with the second bait indicated for the haul
VARCHAR2
51
BAIT_CONDITION_2
VARCHAR2
4000
No
No
Active
The code for the condition of the bait used associated with the second bait indicated for the haul.
VARCHAR2
52
BAIT_NUMBER_USED_3
NUMBER
22
No
No
38
Active
Number Of Individual Baits For Third Bait indicated for the haul
NUMBER
53
BAIT_WEIGHT_3
NUMBER
22
No
No
38
Active
Baith Weight (Units Are In LBS) for the Third Bait Indicated for the Haul
NUMBER
54
BAIT_KIND_3
VARCHAR2
4000
No
No
Active
A code which indicates the kind of bait used with third bait indicated for the haul.
VARCHAR2
55
BAIT_TYPE_3
VARCHAR2
4000
No
No
Active
A code which indicates the type of bait used/ (Whole, cut, lIve, Other etc) used with the third bait indicated for the haul
VARCHAR2
56
BAIT_CONDITION_3
VARCHAR2
4000
No
No
Active
The code for the condition of the bait used associated with the third bait indicated for the haul.
VARCHAR2
57
BEGIN_SET_DATE
DATE
7
No
No
Active
Hours and minutes are included in the time.
DATE
58
BEGIN_SET_LATITUDE
NUMBER
22
No
No
2
0
Active
Begin Set Latitude Degrees
NUMBER
59
BEGIN_SET_LATITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
Begin Set Latitude Minutes
NUMBER
60
BEGIN_SET_LATITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
Begin Set Latitude Hemisphere.
VARCHAR2
61
BEGIN_SET_LONGITUDE
NUMBER
22
No
No
3
0
Active
Begin Set Longitude Degrees
NUMBER
62
BEGIN_SET_LONGITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
Begin Set Longitude Minutes
NUMBER
63
BEGIN_SET_LONGITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
Begin Set Longitude Hemisphere
VARCHAR2
64
BEGIN_SET_TEMPERATURE
NUMBER
22
No
No
3
1
Active
In Fahrenheit
NUMBER
65
END_SET_DATE
DATE
7
No
No
Active
Hours and minutes are included in the time.
DATE
66
END_SET_LATITUDE
NUMBER
22
No
No
2
0
Active
End Set Latitude Degrees
NUMBER
67
END_SET_LATITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
End Set Latitude Minutes
NUMBER
68
END_SET_LATITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
End Set Latitude Hemisphere
VARCHAR2
69
END_SET_LONGITUDE
NUMBER
22
No
No
3
0
Active
End Set Longitude Degrees
NUMBER
70
END_SET_LONGITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
End Set Longitude Minutes
NUMBER
71
END_SET_LONGITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
End Set Longitude Hemisphere
VARCHAR2
72
END_SET_TEMPERATURE
NUMBER
22
No
No
3
1
Active
In Fahrenheit
NUMBER
73
SET_DURATION
NUMBER
22
No
No
4
1
Active
Set Duration In Hours
NUMBER
74
BEGIN_HAUL_DATE
DATE
7
No
No
Active
Hours and minutes are included in the time.
DATE
75
BEGIN_HAUL_LATITUDE
NUMBER
22
No
No
2
0
Active
Begin Haul Latitude Degrees
NUMBER
76
BEGIN_HAUL_LATITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
Begin Haul Latitude Minutes
NUMBER
77
BEGIN_HAUL_LATITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
Begin Haul Latitude Hemisphere
VARCHAR2
78
BEGIN_HAUL_LONGITUDE
NUMBER
22
No
No
3
0
Active
Begin Haul Longitude Degrees
NUMBER
79
BEGIN_HAUL_LONGITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
Begin Haul Longitude Minutes
NUMBER
80
BEGIN_HAUL_LONGITUDE_HEMISPHER
VARCHAR2
1
Yes
No
Active
Begin Haul Longitude Hemisphere
VARCHAR2
81
BEGIN_HAUL_TEMPERATURE
NUMBER
22
No
No
3
1
Active
In Fahrenheit
NUMBER
82
END_HAUL_DATE
DATE
7
No
No
Active
Time includes year, date, hours and minutes.
DATE
83
END_HAUL_LATITUDE
NUMBER
22
No
No
2
0
Active
End Haul Latitude Degrees
NUMBER
84
END_HAUL_LATITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
End Haul Latitude Minutes
NUMBER
85
END_HAUL_LATITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
End Haul Latitude Hemisphere
VARCHAR2
86
END_HAUL_LONGITUDE
NUMBER
22
No
No
3
0
Active
End Haul Longitude Degrees
NUMBER
87
END_HAUL_LONGITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
End Haul Longitude Minutes
NUMBER
88
END_HAUL_LONGITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
End Haul Longitude Hemisphere
VARCHAR2
89
END_HAUL_TEMPERATURE
NUMBER
22
No
No
3
1
Active
In Fahrenheit
NUMBER
90
HAUL_DURATION
NUMBER
22
No
No
4
1
Active
In Hours
NUMBER
91
COMMENTS
VARCHAR2
2000
No
No
Active
Observer comments about the haul
VARCHAR2
5349
View: POP_HAUL_LOG_NON_EXP_V
POP_HAUL_LOG_NON_EXP_V
Published / External
Completed
View Of Non Experimental Haul Logs.
Loaded by batch 1683, 10-12-2007 05:01
Data View
Yes
POPOL
View Of Non Experimental Haul Logs.
1
TRIP_NUMBER
VARCHAR2
6
Yes
No
Active
TRIP_NUMBER
VARCHAR2
2
LANDING_DATE
DATE
7
Yes
No
Active
Date Of Landing Of The Vessel
DATE
3
HAUL_NUMBER
NUMBER
22
Yes
No
2
0
Active
Haul Number
NUMBER
4
GEAR_CODE
VARCHAR2
3
Yes
No
Active
NMFS Gear Code
VARCHAR2
5
WAS_HAUL_OBSERVED
VARCHAR2
1
Yes
No
Active
Was haul observed?
VARCHAR2
6
WAS_CATCH
VARCHAR2
1
Yes
No
Active
Were fish caught in the haul?
VARCHAR2
7
WAS_INCIDENTAL_TAKE
VARCHAR2
1
Yes
No
Active
Was incidental take?
VARCHAR2
8
WEATHER_DESCRIPTION
VARCHAR2
2
No
No
Active
Code For Weather Condition at time of the beginning of the haul.
VARCHAR2
9
WIND_SPEED
NUMBER
22
No
No
2
0
Active
In knots at the beginning of the haul.
NUMBER
10
WIND_DIRECTION
VARCHAR2
3
No
No
Active
In compass degrees at the beginning of the haul.
VARCHAR2
11
WAVE_HEIGHT
NUMBER
22
No
No
2
0
Active
Max. Wave Height at the beginning of the haul in feet
NUMBER
12
REVERSE_HAUL
VARCHAR2
1
No
No
Active
The last hook set is the first hook hauled.
VARCHAR2
13
GEAR_CONDITION
VARCHAR2
2
No
No
Active
Gear Condition at the completion of the haul
VARCHAR2
14
STRING_NUMBER
NUMBER
22
Yes
No
1
0
Active
STRING_NUMBER Of Parent Gear Log Record.
NUMBER
15
MAINLINE_LENGTH
NUMBER
22
No
No
4
1
Active
In nautical miles
NUMBER
16
SET_SPEED
NUMBER
22
No
No
3
1
Active
In Knots
NUMBER
17
BOTTOM_DEPTH_MINIMUM
NUMBER
22
No
No
4
0
Active
In fathoms.
NUMBER
18
BOTTOM_DEPTH_MAXIMUM
NUMBER
22
No
No
4
0
Active
In fathoms.
NUMBER
19
HOOK_DEPTH_MINIMUM
NUMBER
22
No
No
4
0
Active
In fathoms
NUMBER
20
HOOK_DEPTH_MAXIMUM
NUMBER
22
No
No
4
0
Active
In fathoms
NUMBER
21
TOTAL_ADDITIONAL_WEIGHT
NUMBER
22
No
No
5
0
Active
In Pounds
NUMBER
22
TARGET_SPECIES
VARCHAR2
3
Yes
No
Active
Uses Pop Species Code.
VARCHAR2
23
SOAK_DURATION
NUMBER
22
No
No
4
1
Active
In Hours
NUMBER
24
WERE_FLOATS_USED
VARCHAR2
1
No
No
Active
Were Floats Used
VARCHAR2
25
NUMBER_OF_FLOATS
NUMBER
22
No
No
4
0
Active
Number of floats used during the haul.
NUMBER
26
WERE_LIGHT_STICKS_USED
VARCHAR2
1
No
No
Active
Were Light Sticks Used
VARCHAR2
27
NUMBER_LIGHT_STICKS
NUMBER
22
No
No
4
0
Active
Populated only if were_light_sticks_used is set to yes.
NUMBER
28
WERE_RATTLERS_USED
VARCHAR2
1
No
No
Active
Were Rattlers Used
VARCHAR2
29
NUMBER_RATTLERS
NUMBER
22
No
No
4
0
Active
Populated only if were_rattlers_used is set to yes.
NUMBER
30
WERE_SURF_LITES_USED
VARCHAR2
1
No
No
Active
Were Surf Lites Used
VARCHAR2
31
NUMBER_SURF_LITES
NUMBER
22
No
No
2
0
Active
Populated only if were_surf_lites_used is set to yes.
NUMBER
32
WERE_RADIO_BEACONS_USED
VARCHAR2
1
No
No
Active
Were Radio Beacons Used
VARCHAR2
33
NUMBER_RADIO_BEACONS
NUMBER
22
No
No
2
0
Active
Populated only if were_radio_beacons_used is set to yes.
NUMBER
34
WERE_RADAR_REFLECTORS_USED
VARCHAR2
1
No
No
Active
Were radar relectors used
VARCHAR2
35
NUMBER_RADAR_REFLECTORS
NUMBER
22
No
No
4
0
Active
Populated only if number_radar_reflectors_used is set to yes.
NUMBER
36
ADDITIONAL_LINE_WEIGHTS_USED
VARCHAR2
1
No
No
Active
Were Additional Line Weights used
VARCHAR2
37
NUMBER_ADDITIONAL_LINE_WEIGHTS
NUMBER
22
No
No
3
0
Active
Populated only if addtional_line_weights_used is set to yes.
NUMBER
38
NUMBER_HOOKS_SET
NUMBER
22
No
No
4
0
Active
Number of Hooks set
NUMBER
39
NUMBER_HOOKS_LOST
NUMBER
22
No
No
4
0
Active
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.
NUMBER
40
NUMBER_HOOKS_TENDED
NUMBER
22
No
No
4
0
Active
Number of Hooks Pulled during hotlining, which is when the vessel runs the line and pulls hooks where floats are submerged.
NUMBER
41
NUMBER_HOOKS_REBAITED
NUMBER
22
No
No
4
0
Active
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.
NUMBER
42
BAIT_NUMBER_USED_1
NUMBER
22
No
No
38
Active
Number Of Individual Baits For First Bait indicated for the haul
NUMBER
43
BAIT_WEIGHT_1
NUMBER
22
No
No
38
Active
Baith Weight (Units Are In LBS) For First Bait Indicated for the haul
NUMBER
44
BAIT_KIND_1
VARCHAR2
4000
No
No
Active
A code which indicates the kind of bait used with first bait indicated for the haul.
VARCHAR2
45
BAIT_TYPE_1
VARCHAR2
4000
No
No
Active
A code which indicates the type of bait used/ (Whole, cut, lIve, Other etc) used with the first bait indicated for the haul
VARCHAR2
46
BAIT_CONDITION_1
VARCHAR2
4000
No
No
Active
The code for the condition of the bait used associated with the first bait indicated for the haul.
VARCHAR2
47
BAIT_NUMBER_USED_2
NUMBER
22
No
No
38
Active
Number Of Individual Baits For Second Bait indicated for the haul
NUMBER
48
BAIT_WEIGHT_2
NUMBER
22
No
No
38
Active
Baith Weight (Units Are In LBS) for Second Bait Indicated for the haul
NUMBER
49
BAIT_KIND_2
VARCHAR2
4000
No
No
Active
A code which indicates the kind of bait used with Second bait indicated for the haul.
VARCHAR2
50
BAIT_TYPE_2
VARCHAR2
4000
No
No
Active
A code which indicates the type of bait used/ (Whole, cut, lIve, Other etc) used with the second bait indicated for the haul
VARCHAR2
51
BAIT_CONDITION_2
VARCHAR2
4000
No
No
Active
The code for the condition of the bait used associated with the second bait indicated for the haul.
VARCHAR2
52
BAIT_NUMBER_USED_3
NUMBER
22
No
No
38
Active
Number Of Individual Baits For Third Bait indicated for the haul
NUMBER
53
BAIT_WEIGHT_3
NUMBER
22
No
No
38
Active
Baith Weight (Units Are In LBS) for the Third Bait Indicated for the Haul
NUMBER
54
BAIT_KIND_3
VARCHAR2
4000
No
No
Active
A code which indicates the kind of bait used with third bait indicated for the haul.
VARCHAR2
55
BAIT_TYPE_3
VARCHAR2
4000
No
No
Active
A code which indicates the type of bait used/ (Whole, cut, lIve, Other etc) used with the third bait indicated for the haul
VARCHAR2
56
BAIT_CONDITION_3
VARCHAR2
4000
No
No
Active
The code for the condition of the bait used associated with the third bait indicated for the haul.
VARCHAR2
57
BEGIN_SET_DATE
DATE
7
No
No
Active
Hours and minutes are included in the time.
DATE
58
BEGIN_SET_LATITUDE
NUMBER
22
No
No
2
0
Active
Begin Set Latitude Degrees
NUMBER
59
BEGIN_SET_LATITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
Begin Set Latitude Minutes
NUMBER
60
BEGIN_SET_LATITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
Begin Set Latitude Hemisphere.
VARCHAR2
61
BEGIN_SET_LONGITUDE
NUMBER
22
No
No
3
0
Active
Begin Set Longitude Degrees
NUMBER
62
BEGIN_SET_LONGITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
Begin Set Longitude Minutes
NUMBER
63
BEGIN_SET_LONGITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
Begin Set Longitude Hemisphere
VARCHAR2
64
BEGIN_SET_TEMPERATURE
NUMBER
22
No
No
3
1
Active
In Fahrenheit
NUMBER
65
END_SET_DATE
DATE
7
No
No
Active
Hours and minutes are included in the time.
DATE
66
END_SET_LATITUDE
NUMBER
22
No
No
2
0
Active
End Set Latitude Degrees
NUMBER
67
END_SET_LATITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
End Set Latitude Minutes
NUMBER
68
END_SET_LATITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
End Set Latitude Hemisphere
VARCHAR2
69
END_SET_LONGITUDE
NUMBER
22
No
No
3
0
Active
End Set Longitude Degrees
NUMBER
70
END_SET_LONGITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
End Set Longitude Minutes
NUMBER
71
END_SET_LONGITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
End Set Longitude Hemisphere
VARCHAR2
72
END_SET_TEMPERATURE
NUMBER
22
No
No
3
1
Active
In Fahrenheit
NUMBER
73
SET_DURATION
NUMBER
22
No
No
4
1
Active
Set Duration In Hours
NUMBER
74
BEGIN_HAUL_DATE
DATE
7
No
No
Active
Hours and minutes are included in the time.
DATE
75
BEGIN_HAUL_LATITUDE
NUMBER
22
No
No
2
0
Active
Begin Haul Latitude Degrees
NUMBER
76
BEGIN_HAUL_LATITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
Begin Haul Latitude Minutes
NUMBER
77
BEGIN_HAUL_LATITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
Begin Haul Latitude Hemisphere
VARCHAR2
78
BEGIN_HAUL_LONGITUDE
NUMBER
22
No
No
3
0
Active
Begin Haul Longitude Degrees
NUMBER
79
BEGIN_HAUL_LONGITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
Begin Haul Longitude Minutes
NUMBER
80
BEGIN_HAUL_LONGITUDE_HEMISPHER
VARCHAR2
1
Yes
No
Active
Begin Haul Longitude Hemisphere
VARCHAR2
81
BEGIN_HAUL_TEMPERATURE
NUMBER
22
No
No
3
1
Active
In Fahrenheit
NUMBER
82
END_HAUL_DATE
DATE
7
No
No
Active
Time includes year, date, hours and minutes.
DATE
83
END_HAUL_LATITUDE
NUMBER
22
No
No
2
0
Active
End Haul Latitude Degrees
NUMBER
84
END_HAUL_LATITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
End Haul Latitude Minutes
NUMBER
85
END_HAUL_LATITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
End Haul Latitude Hemisphere
VARCHAR2
86
END_HAUL_LONGITUDE
NUMBER
22
No
No
3
0
Active
End Haul Longitude Degrees
NUMBER
87
END_HAUL_LONGITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
End Haul Longitude Minutes
NUMBER
88
END_HAUL_LONGITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
End Haul Longitude Hemisphere
VARCHAR2
89
END_HAUL_TEMPERATURE
NUMBER
22
No
No
3
1
Active
In Fahrenheit
NUMBER
90
HAUL_DURATION
NUMBER
22
No
No
4
1
Active
In Hours
NUMBER
91
COMMENTS
VARCHAR2
2000
No
No
Active
Observer comments about the haul
VARCHAR2
5350
View: POP_HAUL_LOG_V
POP_HAUL_LOG_V
Published / External
Completed
Combined View Of Experimental and Non Experimental Haul Logs.
Loaded by batch 1683, 10-12-2007 05:01
Data View
Yes
POPOL
Combined View Of Experimental and Non Experimental Haul Logs.
1
TRIP_NUMBER
VARCHAR2
6
Yes
No
Active
TRIP_NUMBER
VARCHAR2
2
LANDING_DATE
DATE
7
Yes
No
Active
Date Of Landing Of The Vessel
DATE
3
HAUL_NUMBER
NUMBER
22
Yes
No
2
0
Active
Haul Number
NUMBER
4
GEAR_CODE
VARCHAR2
3
Yes
No
Active
NMFS Gear Code
VARCHAR2
5
WAS_HAUL_OBSERVED
VARCHAR2
1
Yes
No
Active
Was haul observed?
VARCHAR2
6
WAS_CATCH
VARCHAR2
1
Yes
No
Active
Were fish caught in the haul?
VARCHAR2
7
WAS_INCIDENTAL_TAKE
VARCHAR2
1
Yes
No
Active
Was incidental take?
VARCHAR2
8
WEATHER_DESCRIPTION
VARCHAR2
2
No
No
Active
Code For Weather Condition at time of the beginning of the haul.
VARCHAR2
9
WIND_SPEED
NUMBER
22
No
No
2
0
Active
In knots at the beginning of the haul.
NUMBER
10
WIND_DIRECTION
VARCHAR2
3
No
No
Active
In compass degrees at the beginning of the haul.
VARCHAR2
11
WAVE_HEIGHT
NUMBER
22
No
No
2
0
Active
Max. Wave Height at the beginning of the haul in feet
NUMBER
12
REVERSE_HAUL
VARCHAR2
1
No
No
Active
The last hook set is the first hook hauled.
VARCHAR2
13
GEAR_CONDITION
VARCHAR2
2
No
No
Active
Gear Condition at the completion of the haul
VARCHAR2
14
STRING_NUMBER
NUMBER
22
Yes
No
1
0
Active
STRING_NUMBER Of Parent Gear Log Record.
NUMBER
15
MAINLINE_LENGTH
NUMBER
22
No
No
4
1
Active
In nautical miles
NUMBER
16
SET_SPEED
NUMBER
22
No
No
3
1
Active
In Knots
NUMBER
17
BOTTOM_DEPTH_MINIMUM
NUMBER
22
No
No
4
0
Active
In fathoms.
NUMBER
18
BOTTOM_DEPTH_MAXIMUM
NUMBER
22
No
No
4
0
Active
In fathoms.
NUMBER
19
HOOK_DEPTH_MINIMUM
NUMBER
22
No
No
4
0
Active
In fathoms
NUMBER
20
HOOK_DEPTH_MAXIMUM
NUMBER
22
No
No
4
0
Active
In fathoms
NUMBER
21
TOTAL_ADDITIONAL_WEIGHT
NUMBER
22
No
No
5
0
Active
In Pounds
NUMBER
22
TARGET_SPECIES
VARCHAR2
3
Yes
No
Active
Uses Pop Species Code.
VARCHAR2
23
SOAK_DURATION
NUMBER
22
No
No
4
1
Active
In Hours
NUMBER
24
WERE_FLOATS_USED
VARCHAR2
1
No
No
Active
Were Floats Used
VARCHAR2
25
NUMBER_OF_FLOATS
NUMBER
22
No
No
4
0
Active
Number of floats used during the haul.
NUMBER
26
WERE_LIGHT_STICKS_USED
VARCHAR2
1
No
No
Active
Were Light Sticks Used
VARCHAR2
27
NUMBER_LIGHT_STICKS
NUMBER
22
No
No
4
0
Active
Populated only if were_light_sticks_used is set to yes.
NUMBER
28
WERE_RATTLERS_USED
VARCHAR2
1
No
No
Active
Were Rattlers Used
VARCHAR2
29
NUMBER_RATTLERS
NUMBER
22
No
No
4
0
Active
Populated only if were_rattlers_used is set to yes.
NUMBER
30
WERE_SURF_LITES_USED
VARCHAR2
1
No
No
Active
Were Surf Lites Used
VARCHAR2
31
NUMBER_SURF_LITES
NUMBER
22
No
No
2
0
Active
Populated only if were_surf_lites_used is set to yes.
NUMBER
32
WERE_RADIO_BEACONS_USED
VARCHAR2
1
No
No
Active
Were Radio Beacons Used
VARCHAR2
33
NUMBER_RADIO_BEACONS
NUMBER
22
No
No
2
0
Active
Populated only if were_radio_beacons_used is set to yes.
NUMBER
34
WERE_RADAR_REFLECTORS_USED
VARCHAR2
1
No
No
Active
Were radar relectors used
VARCHAR2
35
NUMBER_RADAR_REFLECTORS
NUMBER
22
No
No
4
0
Active
Populated only if number_radar_reflectors_used is set to yes.
NUMBER
36
ADDITIONAL_LINE_WEIGHTS_USED
VARCHAR2
1
No
No
Active
Were Additional Line Weights used
VARCHAR2
37
NUMBER_ADDITIONAL_LINE_WEIGHTS
NUMBER
22
No
No
3
0
Active
Populated only if addtional_line_weights_used is set to yes.
NUMBER
38
NUMBER_HOOKS_SET
NUMBER
22
No
No
4
0
Active
Number of Hooks set
NUMBER
39
NUMBER_HOOKS_LOST
NUMBER
22
No
No
4
0
Active
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.
NUMBER
40
NUMBER_HOOKS_TENDED
NUMBER
22
No
No
4
0
Active
Number of Hooks Pulled during hotlining, which is when the vessel runs the line and pulls hooks where floats are submerged.
NUMBER
41
NUMBER_HOOKS_REBAITED
NUMBER
22
No
No
4
0
Active
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.
NUMBER
42
BAIT_NUMBER_USED_1
NUMBER
22
No
No
38
Active
Number Of Individual Baits For First Bait indicated for the haul
NUMBER
43
BAIT_WEIGHT_1
NUMBER
22
No
No
38
Active
Baith Weight (Units Are In LBS) For First Bait Indicated for the haul
NUMBER
44
BAIT_KIND_1
VARCHAR2
4000
No
No
Active
A code which indicates the kind of bait used with first bait indicated for the haul.
VARCHAR2
45
BAIT_TYPE_1
VARCHAR2
4000
No
No
Active
A code which indicates the type of bait used/ (Whole, cut, lIve, Other etc) used with the first bait indicated for the haul
VARCHAR2
46
BAIT_CONDITION_1
VARCHAR2
4000
No
No
Active
The code for the condition of the bait used associated with the first bait indicated for the haul.
VARCHAR2
47
BAIT_NUMBER_USED_2
NUMBER
22
No
No
38
Active
Number Of Individual Baits For Second Bait indicated for the haul
NUMBER
48
BAIT_WEIGHT_2
NUMBER
22
No
No
38
Active
Baith Weight (Units Are In LBS) for Second Bait Indicated for the haul
NUMBER
49
BAIT_KIND_2
VARCHAR2
4000
No
No
Active
A code which indicates the kind of bait used with Second bait indicated for the haul.
VARCHAR2
50
BAIT_TYPE_2
VARCHAR2
4000
No
No
Active
A code which indicates the type of bait used/ (Whole, cut, lIve, Other etc) used with the second bait indicated for the haul
VARCHAR2
51
BAIT_CONDITION_2
VARCHAR2
4000
No
No
Active
The code for the condition of the bait used associated with the second bait indicated for the haul.
VARCHAR2
52
BAIT_NUMBER_USED_3
NUMBER
22
No
No
38
Active
Number Of Individual Baits For Third Bait indicated for the haul
NUMBER
53
BAIT_WEIGHT_3
NUMBER
22
No
No
38
Active
Baith Weight (Units Are In LBS) for the Third Bait Indicated for the Haul
NUMBER
54
BAIT_KIND_3
VARCHAR2
4000
No
No
Active
A code which indicates the kind of bait used with third bait indicated for the haul.
VARCHAR2
55
BAIT_TYPE_3
VARCHAR2
4000
No
No
Active
A code which indicates the type of bait used/ (Whole, cut, lIve, Other etc) used with the third bait indicated for the haul
VARCHAR2
56
BAIT_CONDITION_3
VARCHAR2
4000
No
No
Active
The code for the condition of the bait used associated with the third bait indicated for the haul.
VARCHAR2
57
BEGIN_SET_DATE
DATE
7
No
No
Active
Hours and minutes are included in the time.
DATE
58
BEGIN_SET_LATITUDE
NUMBER
22
No
No
2
0
Active
Begin Set Latitude Degrees
NUMBER
59
BEGIN_SET_LATITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
Begin Set Latitude Minutes
NUMBER
60
BEGIN_SET_LATITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
Begin Set Latitude Hemisphere.
VARCHAR2
61
BEGIN_SET_LONGITUDE
NUMBER
22
No
No
3
0
Active
Begin Set Longitude Degrees
NUMBER
62
BEGIN_SET_LONGITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
Begin Set Longitude Minutes
NUMBER
63
BEGIN_SET_LONGITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
Begin Set Longitude Hemisphere
VARCHAR2
64
BEGIN_SET_TEMPERATURE
NUMBER
22
No
No
3
1
Active
In Fahrenheit
NUMBER
65
END_SET_DATE
DATE
7
No
No
Active
Hours and minutes are included in the time.
DATE
66
END_SET_LATITUDE
NUMBER
22
No
No
2
0
Active
End Set Latitude Degrees
NUMBER
67
END_SET_LATITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
End Set Latitude Minutes
NUMBER
68
END_SET_LATITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
End Set Latitude Hemisphere
VARCHAR2
69
END_SET_LONGITUDE
NUMBER
22
No
No
3
0
Active
End Set Longitude Degrees
NUMBER
70
END_SET_LONGITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
End Set Longitude Minutes
NUMBER
71
END_SET_LONGITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
End Set Longitude Hemisphere
VARCHAR2
72
END_SET_TEMPERATURE
NUMBER
22
No
No
3
1
Active
In Fahrenheit
NUMBER
73
SET_DURATION
NUMBER
22
No
No
4
1
Active
Set Duration In Hours
NUMBER
74
BEGIN_HAUL_DATE
DATE
7
No
No
Active
Hours and minutes are included in the time.
DATE
75
BEGIN_HAUL_LATITUDE
NUMBER
22
No
No
2
0
Active
Begin Haul Latitude Degrees
NUMBER
76
BEGIN_HAUL_LATITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
Begin Haul Latitude Minutes
NUMBER
77
BEGIN_HAUL_LATITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
Begin Haul Latitude Hemisphere
VARCHAR2
78
BEGIN_HAUL_LONGITUDE
NUMBER
22
No
No
3
0
Active
Begin Haul Longitude Degrees
NUMBER
79
BEGIN_HAUL_LONGITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
Begin Haul Longitude Minutes
NUMBER
80
BEGIN_HAUL_LONGITUDE_HEMISPHER
VARCHAR2
1
Yes
No
Active
Begin Haul Longitude Hemisphere
VARCHAR2
81
BEGIN_HAUL_TEMPERATURE
NUMBER
22
No
No
3
1
Active
In Fahrenheit
NUMBER
82
END_HAUL_DATE
DATE
7
No
No
Active
Time includes year, date, hours and minutes.
DATE
83
END_HAUL_LATITUDE
NUMBER
22
No
No
2
0
Active
End Haul Latitude Degrees
NUMBER
84
END_HAUL_LATITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
End Haul Latitude Minutes
NUMBER
85
END_HAUL_LATITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
End Haul Latitude Hemisphere
VARCHAR2
86
END_HAUL_LONGITUDE
NUMBER
22
No
No
3
0
Active
End Haul Longitude Degrees
NUMBER
87
END_HAUL_LONGITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
End Haul Longitude Minutes
NUMBER
88
END_HAUL_LONGITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
End Haul Longitude Hemisphere
VARCHAR2
89
END_HAUL_TEMPERATURE
NUMBER
22
No
No
3
1
Active
In Fahrenheit
NUMBER
90
HAUL_DURATION
NUMBER
22
No
No
4
1
Active
In Hours
NUMBER
91
COMMENTS
VARCHAR2
2000
No
No
Active
Observer comments about the haul
VARCHAR2
5351
Table: POP_HOOKS_DEFINED
POP_HOOKS_DEFINED
Published / External
Completed
Used to lookup Hook Type Based on Brand and Model
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Used to lookup Hook Type Based on Brand and Model
1
HOOK_DEFINED_KEY
NUMBER
22
Yes
Yes
6
0
Active
Primary Key
NUMBER
2
HOOK_BRAND
VARCHAR2
10
Yes
No
Active
The Brand Of Hooks Used.
VARCHAR2
3
HOOK_TYPE
VARCHAR2
15
Yes
No
Active
TheType Of Hooks Used.
VARCHAR2
4
HOOK_MODEL
VARCHAR2
10
No
No
Active
Model Of Hook
VARCHAR2
5
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Who created the record
VARCHAR2
6
CREATED_DATE
DATE
7
Yes
No
Active
When was the record created
DATE
7
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Who last modified the record
VARCHAR2
8
MODIFIED_DATE
DATE
7
No
No
Active
When was the record last modified
DATE
5352
Table: POP_HOOKS_USED
POP_HOOKS_USED
Published / External
Completed
Hooks Section Of The Gear Log.
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Hooks Section Of The Gear Log.
1
HOOKS_USED_KEY
NUMBER
22
Yes
Yes
10
0
Active
Primary Key
NUMBER
2
GEAR_LOG_KEY
NUMBER
22
Yes
No
10
0
Active
Gear Log Key
NUMBER
3
HOOK_BRAND
VARCHAR2
10
Yes
No
Active
Hook Brand
VARCHAR2
4
HOOK_MODEL
VARCHAR2
10
No
No
Active
Hook Model
VARCHAR2
5
HOOK_SIZE
VARCHAR2
4
No
No
Active
Hook Size
VARCHAR2
6
HOOK_TYPE
VARCHAR2
15
Yes
No
Active
Hook Type
VARCHAR2
7
HOOK_OFFSET
VARCHAR2
4
No
No
Active
Hook Offset
VARCHAR2
8
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Created by whom
VARCHAR2
9
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
10
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Modified by whom
VARCHAR2
11
MODIFIED_DATE
DATE
7
No
No
Active
Modified when
DATE
5353
Table: POP_HOOK_BRANDS
POP_HOOK_BRANDS
Published / External
Completed
Code Table for Hook Brands
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Code Table for Hook Brands
1
CODE
VARCHAR2
10
Yes
Yes
Active
Code
VARCHAR2
2
NAME
VARCHAR2
20
Yes
No
Active
Name
VARCHAR2
3
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Created by whom
VARCHAR2
4
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
5
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Modified by whom
VARCHAR2
6
MODIFIED_DATE
VARCHAR2
240
No
No
Active
Modified when
VARCHAR2
5354
Table: POP_HOOK_DEPTH
POP_HOOK_DEPTH
Published / External
Completed
Code Table for Hook Depth
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Code Table for Hook Depth
1
CODE
VARCHAR2
1
Yes
Yes
Active
Code
VARCHAR2
2
NAME
VARCHAR2
20
Yes
No
Active
Name
VARCHAR2
3
CREATED_BY_USER_ID
VARCHAR2
20
No
No
Active
Who created the record
VARCHAR2
4
CREATED_DATE
DATE
7
No
No
Active
When was the record created
DATE
5
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Who last modified the record
VARCHAR2
6
MODIFIED_DATE
DATE
7
No
No
Active
When was the record last modified
DATE
5355
Table: POP_HOOK_SIZE
POP_HOOK_SIZE
Published / External
Completed
Domain for Hook Size
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Domain for Hook Size
1
CODE
VARCHAR2
4
Yes
Yes
Active
Code
VARCHAR2
2
NAME
VARCHAR2
20
Yes
No
Active
Name
VARCHAR2
3
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Who created the record
VARCHAR2
4
CREATED_DATE
DATE
7
Yes
No
Active
When was the record created
DATE
5
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Who last modified the record
VARCHAR2
6
MODIFIED_DATE
DATE
7
No
No
Active
When was the record last modified
DATE
5356
Table: POP_HOOK_TYPE
POP_HOOK_TYPE
Published / External
Completed
Code Table for Hook Type
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Code Table for Hook Type
1
CODE
VARCHAR2
15
Yes
Yes
Active
Code
VARCHAR2
2
NAME
VARCHAR2
20
Yes
No
Active
Name
VARCHAR2
3
CREATED_BY_USER_ID
VARCHAR2
20
No
No
Active
Who created the record
VARCHAR2
4
CREATED_DATE
DATE
7
No
No
Active
When was the record created
DATE
5
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Who last modified the record
VARCHAR2
6
MODIFIED_DATE
DATE
7
No
No
Active
When was the record last modified
DATE
5357
Table: POP_HOW_HOOKED
POP_HOW_HOOKED
Published / External
Completed
Code Table for How Hooked
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Code Table for How Hooked
1
CODE
VARCHAR2
1
Yes
Yes
Active
Code
VARCHAR2
2
NAME
VARCHAR2
20
Yes
No
Active
Name
VARCHAR2
3
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Who created the record
VARCHAR2
4
CREATED_DATE
DATE
7
Yes
No
Active
When was the record created
DATE
5
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Who last modified the record
VARCHAR2
6
MODIFIED_DATE
DATE
7
No
No
Active
When was the record last modified
DATE
5358
Table: POP_INT_CODE_TABLES
POP_INT_CODE_TABLES
Published / External
Completed
An auxiliary table intended to help both in the migration of the code tables, as well as in the editing of them
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
An auxiliar table intended to help both in the migration of the code tables, as well as in the editing of them
1
TABLE_NAME
VARCHAR2
30
Yes
Yes
Active
Table Name
VARCHAR2
2
TABLE_TITLE
VARCHAR2
30
Yes
No
Active
Description
VARCHAR2
3
NAME_COLUMN_LENGTH
NUMBER
22
Yes
No
3
0
Active
How long the NAME column is
NUMBER
4
CODE_COLUMN_LENGTH
NUMBER
22
No
No
3
0
Active
How long the Code Column is
NUMBER
5
RV_DOMAIN
VARCHAR2
20
No
No
Active
Link with the old CG_REF_CODES table
VARCHAR2
5359
Table: POP_LENGTH_CODE
POP_LENGTH_CODE
Published / External
Completed
Code Table for Length Code
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Code Table for Length Code
1
CODE
VARCHAR2
2
Yes
Yes
Active
Code
VARCHAR2
2
NAME
VARCHAR2
50
Yes
No
Active
Name
VARCHAR2
3
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Created by whom
VARCHAR2
4
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
5
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Modified by whom
VARCHAR2
6
MODIFIED_DATE
DATE
7
No
No
Active
Modified when
DATE
5360
Table: POP_LENGTH_TYPE
POP_LENGTH_TYPE
Published / External
Completed
Code Table for Length Type
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Code Table for Length Type
1
CODE
VARCHAR2
3
Yes
Yes
Active
Code
VARCHAR2
2
NAME
VARCHAR2
50
Yes
No
Active
Name
VARCHAR2
3
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Created by whom
VARCHAR2
4
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
5
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Modified by whom
VARCHAR2
6
MODIFIED_DATE
DATE
7
No
No
Active
Modified when
DATE
5361
Table: POP_LIGHT_STICK_COLOR
POP_LIGHT_STICK_COLOR
Published / External
Completed
Code Table for Light Stick Color
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Code Table for Light Stick Color
1
CODE
VARCHAR2
2
Yes
Yes
Active
Code
VARCHAR2
2
NAME
VARCHAR2
20
Yes
No
Active
Name
VARCHAR2
3
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Who created the record
VARCHAR2
4
CREATED_DATE
DATE
7
Yes
No
Active
When was the record created
DATE
5
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Who last modified the record
VARCHAR2
6
MODIFIED_DATE
DATE
7
No
No
Active
When was the record last modified
DATE
5362
Table: POP_NMFS_SPECIES_CODE
POP_NMFS_SPECIES_CODE
Published / External
Completed
NMFS Species Code Table
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
NMFS Species Code Table
1
SPECIES_CODE_NMFS
VARCHAR2
4
Yes
Yes
Active
Four digit NMFS species code.
VARCHAR2
2
COMMON_NAME
VARCHAR2
40
No
No
Active
Species common name.
VARCHAR2
3
SCIENTIFIC_NAME
VARCHAR2
46
No
No
Active
Species Scientific Name.
VARCHAR2
4
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Created by whom
VARCHAR2
5
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
6
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Modified by whom
VARCHAR2
7
MODIFIED_DATE
DATE
7
No
No
Active
Modified when
DATE
5363
Table: POP_OBSERVERS
POP_OBSERVERS
Published / External
Completed
Code Table for Observers
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Code Table for Observers
1
OBSERVER_INIT
VARCHAR2
4
Yes
Yes
Active
A character mnemonic for each observer
VARCHAR2
2
FIRST_NAME
VARCHAR2
15
No
No
Active
First Name
VARCHAR2
3
LAST_NAME
VARCHAR2
15
No
No
Active
Last Name
VARCHAR2
4
OBSERVER_TYPE
VARCHAR2
3
Yes
No
Active
Observer Type
VARCHAR2
5
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Created by whom
VARCHAR2
6
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
7
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Modified by whom
VARCHAR2
8
MODIFIED_DATE
DATE
7
No
No
Active
Modified when
DATE
9
TRIP_NUMBER_PREFIX
VARCHAR2
3
No
No
Active
Trip Number Prefix
VARCHAR2
5364
Table: POP_OBSERVER_TYPE
POP_OBSERVER_TYPE
Published / External
Completed
Code Table for Observer Type
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Code Table for Observer Type
1
CODE
VARCHAR2
3
Yes
Yes
Active
Code
VARCHAR2
2
NAME
VARCHAR2
20
Yes
No
Active
Name
VARCHAR2
3
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Created by whom
VARCHAR2
4
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
5
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Modified by whom
VARCHAR2
6
MODIFIED_DATE
DATE
7
No
No
Active
Modified when
DATE
5365
Table: POP_SEX
POP_SEX
Published / External
Completed
Code Table for Valid Sex Codes
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Code Table for Valid Sex Codes
1
CODE
VARCHAR2
1
Yes
Yes
Active
Code
VARCHAR2
2
NAME
VARCHAR2
20
Yes
No
Active
Name Associated WIth The Code
VARCHAR2
3
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Who created the record
VARCHAR2
4
CREATED_DATE
DATE
7
Yes
No
Active
When the record was created
DATE
5
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Who last modified the record
VARCHAR2
6
MODIFIED_DATE
DATE
7
No
No
Active
When the record was last modified
DATE
5366
Table: POP_SPECIES_CODE
POP_SPECIES_CODE
Published / External
Completed
Holds valid species codes in the Animal Log Form
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Holds valid species codes in the Animal Log Form
1
POP_SPECIES_CODE
VARCHAR2
3
Yes
Yes
Active
Pop Spc Code Assigned By Data Manager
VARCHAR2
2
NODC_SPECIES_CODE
VARCHAR2
10
No
No
Active
NODC Code equivalent (If available)
VARCHAR2
3
POP_GROUP_CODE
VARCHAR2
20
No
No
Active
Pop Grouping Code/Name assigned By POP Data Manager
VARCHAR2
4
POP_COMMON_NAME
VARCHAR2
30
Yes
No
Active
Common Name Of Animal
VARCHAR2
5
NMFS_SPECIES_CODE
VARCHAR2
4
No
No
Active
4 digit NMFS Species Code if avilable
VARCHAR2
6
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Created by whom
VARCHAR2
7
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
8
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Modified by whom
VARCHAR2
9
MODIFIED_DATE
DATE
7
No
No
Active
Modified when
DATE
10
MINIMUM_LENGTH_1
NUMBER
22
No
No
3
0
Active
Minimum Reccomended Length For Species
NUMBER
11
MAXIMUM_LENGTH_1
NUMBER
22
No
No
3
0
Active
Maximum Reccomended Length For Species
NUMBER
12
WEIGHT_LENGTH_COEFF_A
NUMBER
22
No
No
20
10
Active
First Coefficient In Weight To Length Conversion For Species
NUMBER
13
WEIGHT_LENGTH_COEFF_B
NUMBER
22
No
No
20
10
Active
Second Coefficient In Weight To Length Conversion For Species
NUMBER
14
PERCENT_ERROR_MARGIN
NUMBER
22
No
No
2
0
Active
Acceptable Percent Error For Species In Question
NUMBER
5367
Table: POP_SPECIES_GROUP
POP_SPECIES_GROUP
Published / External
Completed
Code Table for Species Group
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Code Table for Species Group
1
CODE
VARCHAR2
15
Yes
Yes
Active
Code
VARCHAR2
2
NAME
VARCHAR2
20
Yes
No
Active
Name
VARCHAR2
3
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Created by whom
VARCHAR2
4
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
5
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Last modified by whom
VARCHAR2
6
MODIFIED_DATE
DATE
7
No
No
Active
Last modified date
DATE
5368
Table: POP_TAG_ACTION
POP_TAG_ACTION
Published / External
Completed
Code Table for Tag Action
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Code Table for Tag Action
1
CODE
VARCHAR2
1
Yes
Yes
Active
Code
VARCHAR2
2
NAME
VARCHAR2
50
Yes
No
Active
Name
VARCHAR2
3
CREATED_DATE
DATE
7
Yes
No
Active
Date of creation
DATE
4
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Last modified by whom
VARCHAR2
5
CREATED_BY_USER_ID
VARCHAR2
20
No
No
Active
Created by whom
VARCHAR2
6
MODIFIED_DATE
DATE
7
No
No
Active
Date of last modification
DATE
5369
Table: POP_TREATMENT
POP_TREATMENT
Published / External
Completed
Code Table for Treatment
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Code Table for Treatment
1
CODE
VARCHAR2
2
Yes
Yes
Active
Code
VARCHAR2
2
NAME
VARCHAR2
110
Yes
No
Active
Name
VARCHAR2
3
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Created by whom
VARCHAR2
4
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
5
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Created by whom
VARCHAR2
6
MODIFIED_DATE
DATE
7
No
No
Active
Modified when
DATE
5370
Table: POP_TRIP_COVERAGE_AREAS
POP_TRIP_COVERAGE_AREAS
Published / External
Completed
Which coverage area the vessel worked on and how many sets where observed on each coverage area
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Which coverage area the vessel worked on and how many sets where observed on each coverage area
1
TRIP_NUMBER
VARCHAR2
6
Yes
Yes
Active
The code of the trip being observed
VARCHAR2
2
COVERAGE_AREA
VARCHAR2
3
Yes
Yes
Active
Coverage Area
VARCHAR2
3
NBR_SETS_OBSERVED
NUMBER
22
No
No
3
0
Active
Number of sets that were observed in that area in that trip
NUMBER
5371
Table: POP_TRIP_LOG
POP_TRIP_LOG
Published / External
Completed
One record for each trip where observers where located
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
One record for each trip where observers where located
1
TRIP_NUMBER
VARCHAR2
6
Yes
Yes
Active
Primary Key
VARCHAR2
2
POP_VESSEL_CODE
VARCHAR2
8
Yes
No
Active
POP Vessel Code, more than 90% of the time = Coast Guard Vessel Id
VARCHAR2
3
VESSEL_NAME
VARCHAR2
20
No
No
Active
Vessel Name
VARCHAR2
4
DEPARTURE_DATE
DATE
7
No
No
Active
Departure Date of the Vessel
DATE
5
LANDING_DATE
DATE
7
Yes
No
Active
Landing Date of the Vessel
DATE
6
SEA_DAYS
NUMBER
22
No
No
3
0
Active
Calculated as LANDING_DATE-DEPARTURE_DATE+1
NUMBER
7
COMMENTS
VARCHAR2
2000
No
No
Active
Comments on the trip
VARCHAR2
8
OBSERVER_TYPE
VARCHAR2
3
Yes
No
Active
Observer Type
VARCHAR2
9
OBSERVER_INIT
VARCHAR2
4
No
No
Active
Observer Init
VARCHAR2
10
TRIP_TYPE
VARCHAR2
1
No
No
Active
Trip Type
VARCHAR2
11
TRIP_SUMMARY
VARCHAR2
10
No
No
Active
Linking Column With PLL and DLS Data.
VARCHAR2
12
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Created by whom
VARCHAR2
13
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
14
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Modified by whom
VARCHAR2
15
MODIFIED_DATE
DATE
7
No
No
Active
Modified when
DATE
16
STATUS_ID
VARCHAR2
1
No
No
Active
Status Identifier
VARCHAR2
17
TOTAL_SETS
NUMBER
22
No
No
3
0
Active
How many sets there are in the trip
NUMBER
18
TOTAL_HAULS
NUMBER
22
No
No
3
0
Active
How many hauls there are in the trip
NUMBER
5372
Table: POP_TRIP_LOG_DELETE
POP_TRIP_LOG_DELETE
Published / External
Completed
One record for each trip where observers where located
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
One record for each trip where observers where located
1
TRIP_NUMBER
VARCHAR2
6
Yes
No
Active
Primary Key
VARCHAR2
2
POP_VESSEL_CODE
VARCHAR2
8
Yes
No
Active
POP Vessel Code, more than 90% of the time = Coast Guard Vessel Id
VARCHAR2
3
VESSEL_NAME
VARCHAR2
20
No
No
Active
Vessel Name
VARCHAR2
4
DEPARTURE_DATE
DATE
7
No
No
Active
Departure Date of the Vessel
DATE
5
LANDING_DATE
DATE
7
Yes
No
Active
Landing Date of the Vessel
DATE
6
SEA_DAYS
NUMBER
22
No
No
3
0
Active
Calculated as LANDING_DATE-DEPARTURE_DATE+1
NUMBER
7
OBSERVER_TYPE
VARCHAR2
3
Yes
No
Active
Observer Type
VARCHAR2
8
OBSERVER_INIT
VARCHAR2
4
No
No
Active
Observer Init
VARCHAR2
9
TRIP_TYPE
VARCHAR2
1
No
No
Active
Trip Type
VARCHAR2
10
TRIP_SUMMARY
VARCHAR2
10
No
No
Active
Linking Column With PLL and DLS Data.
VARCHAR2
11
TOTAL_SETS
NUMBER
22
No
No
3
0
Active
How many sets there are in the trip
NUMBER
12
TOTAL_HAULS
NUMBER
22
No
No
3
0
Active
How many hauls there are in the trip
NUMBER
13
COMMENTS
VARCHAR2
2000
No
No
Active
Comments on the trip
VARCHAR2
14
STATUS_ID
VARCHAR2
1
No
No
Active
Status Identifier
VARCHAR2
15
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Created by whom
VARCHAR2
16
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
17
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Modified by whom
VARCHAR2
18
MODIFIED_DATE
DATE
7
No
No
Active
Modified when
DATE
19
DELETED_BY_USER_ID
VARCHAR2
20
No
No
Active
Who deleted the record
VARCHAR2
20
DELETED_DATE
DATE
7
No
No
Active
When Record Was Deleted
DATE
21
DELETE_REASON_CODE
VARCHAR2
5
No
No
Active
Reason Code For WHy Record Was Deleted
VARCHAR2
5373
Table: POP_TRIP_TYPE
POP_TRIP_TYPE
Published / External
Completed
Hold one record for each trip type
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Hold one record for each trip type
1
CODE
VARCHAR2
1
Yes
Yes
Active
Code
VARCHAR2
2
NAME
VARCHAR2
20
Yes
No
Active
Name
VARCHAR2
3
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Created by whom
VARCHAR2
4
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
5
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Modified by whom
VARCHAR2
6
MODIFIED_DATE
DATE
7
No
No
Active
Modified when
DATE
5374
Table: POP_USER_PROFILE
POP_USER_PROFILE
Published / External
Completed
Hold user information
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Hold user information
1
USER_NAME
VARCHAR2
20
Yes
Yes
Active
Name
VARCHAR2
2
USER_PASSWORD
VARCHAR2
20
Yes
No
Active
Password
VARCHAR2
3
HAS_DELETE
VARCHAR2
1
Yes
No
Active
Can this user delete?
VARCHAR2
4
HAS_DATA_ENTRY
VARCHAR2
1
Yes
No
Active
Can this user entry data
VARCHAR2
5
HAS_DATA_MANAGER
VARCHAR2
1
Yes
No
Active
Is this user a data manager?
VARCHAR2
6
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Created by whom
VARCHAR2
7
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
8
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Last modified by whom
VARCHAR2
9
MODIFIED_DATE
DATE
7
No
No
Active
Last modified when
DATE
5375
Table: POP_VESSEL_CODES
POP_VESSEL_CODES
Published / External
Completed
Valid Vessels.
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Valid Vessels.
1
POP_VESSEL_CODE
VARCHAR2
8
Yes
Yes
Active
Vessel Code For Pop System
VARCHAR2
2
COAST_GUARD_VESSEL_ID
VARCHAR2
8
No
No
Active
Coast Guard Vessel Id
VARCHAR2
3
NEFS_VESSEL_ID
VARCHAR2
8
No
No
Active
North East Fisheries Center Vessel Id
VARCHAR2
4
STATE_VESSEL_ID
VARCHAR2
15
No
No
Active
State Regisration Number
VARCHAR2
5
VESSEL_NAME
VARCHAR2
30
No
No
Active
Vessel Name
VARCHAR2
6
NOTES
VARCHAR2
100
No
No
Active
Note On Vessel
VARCHAR2
7
CREATED_BY_USER_ID
VARCHAR2
20
No
No
Active
Created by whom
VARCHAR2
8
CREATED_DATE
DATE
7
No
No
Active
Created when
DATE
9
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Modified by whom
VARCHAR2
10
MODIFIED_DATE
DATE
7
No
No
Active
Modified when
DATE
5376
Table: POP_WEATHER
POP_WEATHER
Published / External
Completed
Code Table for Weather
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
Code Table for Weather
1
CODE
VARCHAR2
2
Yes
Yes
Active
Code
VARCHAR2
2
NAME
VARCHAR2
50
Yes
No
Active
Name
VARCHAR2
3
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Created by whom
VARCHAR2
4
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
5
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Modified by whom
VARCHAR2
6
MODIFIED_DATE
DATE
7
No
No
Active
Modified when
DATE
Data Steward
1992
Person
Beerkircher, Larry
lawrence.r.beerkircher@noaa.gov
75 Virginia Beach Drive
Miami
FL
33149
305-361-4290
Contact by email preferred.
Distributor
1992
Organization
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
https://www.fisheries.noaa.gov/about/southeast-fisheries-science-center
About SEFSC
Online Resource
8:00 a.m. - 4:30 p.m. EST
Metadata Contact
1992
Person
Beerkircher, Larry
lawrence.r.beerkircher@noaa.gov
75 Virginia Beach Drive
Miami
FL
33149
305-361-4290
Contact by email preferred.
Point of Contact
1992
Person
Beerkircher, Larry
lawrence.r.beerkircher@noaa.gov
75 Virginia Beach Drive
Miami
FL
33149
305-361-4290
Contact by email preferred.
-96
-37
51
1
Gulf Of Mexico, Caribbean Sea, And U.S. South Atlantic Ocean
Continuing
1992
-96
-37
51
1
Gulf Of Mexico, Caribbean Sea, And U.S. South Atlantic Ocean
Continuing
1992
-96
-37
51
1
Gulf Of Mexico, Caribbean Sea, And U.S. South Atlantic Ocean
Continuing
1992
Sensitive
Contact Data steward
Read and sign for NOAA Administrative Order 216 100 Read and sign System Access Application (see URLs) Contact DBA Daniel Leon at daniel.leon noaa.gov for userid password.
Waiver Needed
Please cite data. Please be cognizant of meta data
None
None
Original data examined by SME, collector debriefed, data entry system has validation constraints.
No
0
Yes
Yes
No
45
This data is currently wavered under the current NOAA guidelines for relational databases.
To Be Determined
0
The data resides on a secure database server only accessible through the NMFS network requiring separate multi-factor authentication for both network and database access.
1
Collection on board commercial fishing vessels by trained observers on paper forms. Paper forms submitted to Miami Laboratory Pelagic Observer Program for review and editing. Data entered into oracle tables via a web-based data entry application that employs validation processes.
5323
Entity
Table: POP_ANIMAL_LOG
5324
Entity
Table: POP_ANIMAL_LOG_EXP
5328
Entity
Table: POP_BAITS_USED
5329
Entity
Table: POP_BAIT_CONDITION
5330
Entity
Table: POP_BAIT_KIND
5331
Entity
Table: POP_BAIT_TYPE
5332
Entity
Table: POP_BOARDING_STATUS
5333
Entity
Table: POP_COVERAGE_AREAS
5334
Entity
Table: POP_DAMAGE_TYPE
5335
Entity
Table: POP_DELETE_REASON
5336
Entity
Table: POP_DROPLINES_USED
5337
Entity
Table: POP_EXPERIMENTAL_TREATMENT
5338
Entity
Table: POP_FISHING_AREAS
5339
Entity
Table: POP_GANGIONS_USED
5340
Entity
Table: POP_GANGION_COLOR
5341
Entity
Table: POP_GEAR_CONDITION
5342
Entity
Table: POP_GEAR_LOG
5346
Entity
Table: POP_GEAR_MATERIAL
5347
Entity
Table: POP_HAUL_LOG
5351
Entity
Table: POP_HOOKS_DEFINED
5352
Entity
Table: POP_HOOKS_USED
5353
Entity
Table: POP_HOOK_BRANDS
5354
Entity
Table: POP_HOOK_DEPTH
5355
Entity
Table: POP_HOOK_SIZE
5356
Entity
Table: POP_HOOK_TYPE
5357
Entity
Table: POP_HOW_HOOKED
5358
Entity
Table: POP_INT_CODE_TABLES
5359
Entity
Table: POP_LENGTH_CODE
5360
Entity
Table: POP_LENGTH_TYPE
5361
Entity
Table: POP_LIGHT_STICK_COLOR
5362
Entity
Table: POP_NMFS_SPECIES_CODE
5363
Entity
Table: POP_OBSERVERS
5364
Entity
Table: POP_OBSERVER_TYPE
5365
Entity
Table: POP_SEX
5366
Entity
Table: POP_SPECIES_CODE
5367
Entity
Table: POP_SPECIES_GROUP
5368
Entity
Table: POP_TAG_ACTION
5369
Entity
Table: POP_TREATMENT
5370
Entity
Table: POP_TRIP_COVERAGE_AREAS
5371
Entity
Table: POP_TRIP_LOG
5372
Entity
Table: POP_TRIP_LOG_DELETE
5373
Entity
Table: POP_TRIP_TYPE
5374
Entity
Table: POP_USER_PROFILE
5375
Entity
Table: POP_VESSEL_CODES
5376
Entity
Table: POP_WEATHER
5325
Entity
View: POP_ANIMAL_LOG_EXP_V
5326
Entity
View: POP_ANIMAL_LOG_NON_EXP_V
5327
Entity
View: POP_ANIMAL_LOG_V
5343
Entity
View: POP_GEAR_LOG_EXP_V
5344
Entity
View: POP_GEAR_LOG_NON_EXP_V
5345
Entity
View: POP_GEAR_LOG_V
5348
Entity
View: POP_HAUL_LOG_EXP_V
5349
Entity
View: POP_HAUL_LOG_NON_EXP_V
5350
Entity
View: POP_HAUL_LOG_V
gov.noaa.nmfs.inport:30713
Carlos Rivero
2016-02-11T06:54:43
Bryson Anderson
2023-01-27T17:34:02
2021-05-06
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
www.sefsc.noaa.gov
8:00 a.m. - 4:30 p.m. EST
1001
Public
No
2021-05-06
1 Year
2022-05-06