View: ASMHAU | InPort

Title:	View: ASMHAU
Short Name:	ASMHAU
Status:	Completed
Abstract:	At Sea Monitor Generic Haul Data
Notes:	Loaded by batch 9053, 07-27-2016 19:10

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	OBDBS
Description:	At Sea Monitor Generic Haul Data

	Name	Type	Description
100	PROGRAM	VARCHAR2	First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.
100	YEAR	VARCHAR2	Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.
100	MONTH	VARCHAR2	Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.
100	TRIPID	VARCHAR2	May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable.
100	HAULNUM	VARCHAR2	Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable.
100	LINK1	VARCHAR2	15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable.
100	QTR	NUMBER	Quarter of year landed: 1 = Jan, Feb, Mar; 2 = Apr,May,Jun 3=Jul, Aug, Sep, 4= Oct, Nov, Dec. Collected for ASM where applicable.
100	LINK3	VARCHAR2	Key field linking tables at the haul level; made up of: link1 plus (4-character) haulnum. Collected for ASM where applicable.
100	NEGEAR	VARCHAR2	Northeast gear code. See OBGEAR table. Collected for ASM where applicable.
100	OBSRFLAG	VARCHAR2	Indicator of whether haul was observed for discards (all hauls are observed for catch except for offwatch (sdo, sto, cdo) hauls). 0=no; 1=yes. Collected for ASM where applicable.
100	CATEXIST	VARCHAR2	Indicator of whether gear from haul holds any catch, kept or discarded. 0=no; 1=yes.
100	INCTAKE	VARCHAR2	Indicator of whether Sea Turtle, Marine Mammal, or Sea Bird is caught by gear in haul. 0 = no 1 = yes. Collected for ASM where applicable.
100	WEATHER	VARCHAR2	HAUL: Code for weather at beginning of haul. EVENT: Code for weather at time event occurred. See support table OBWEATHER for codes. Collected for ASM where applicable.
100	WINDSP	NUMBER	Wind speed at beginning of haul, in whole knots.
100	WINDDIR	VARCHAR2	Wind direction (compass direction) from which the wind is blowing at beginning of haul.
100	WAVEHGT	NUMBER	HAUL: Wave height at beginning of haul, in whole feet. EVENT: Wave height at beginning of event, in whole feet. Not collected prior to 5/1994; set to unknown. Collected for ASM where applicable.
100	DEPTH	NUMBER	Water depth at beginning of haul, in whole fathoms.
100	GEARCOND	VARCHAR2	Condition of gear at Haul. See OBGEARCOND table. Collected for ASM where applicable.
100	TARGSPEC1	VARCHAR2	NESPP4 for any of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear. Collected for ASM where applicable.
100	TARGSPEC2	VARCHAR2	NESPP4 code for any of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear. Collected for ASM where applicable.
100	TARGSPEC3	VARCHAR2	NESPP4 code for any of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear.
100	TARGSPEC4	VARCHAR2	NESPP4 code for any one of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear.
100	TARGSPEC5	VARCHAR2	NESPP4 for any one of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear.
100	YEARSBEG	VARCHAR2	Year set began, four digits.Not collected before 5/1994; set to unknown.
100	MONTHSBEG	VARCHAR2	Two digit month set began. Not collected 1989 - 4/1994;
100	DAYSBEG	VARCHAR2	Day set began, two digits.
100	TIMESBEG	VARCHAR2	Time set began, local time using 24 hour clock (0000-2359). Not collected before 5/1994; set to unknown
100	DATESBEG	DATE	Date the set began. Not recorded prior to 5/1994; set to unknown NOTE: if time is unknown it defaults to midnight in this field
100	YEARSEND	VARCHAR2	Year set ended, four digits. Not collected before 5/1994; set to unknown.
100	MONTHSEND	VARCHAR2	Two digit month the set ended.
100	DAYSEND	VARCHAR2	Day set ended, two digits.Not recorded prior to 5/1994; set to unknown
100	TIMESEND	VARCHAR2	Time set ended, local time using 24 hour clock (0000-2359). Not collected before 5/1994; set to unknown
100	DATESEND	DATE	Date the set of the gear ended.Not recorded prior to 5/1994; set to unknown NOTE: if time is unknown it defaults to midnight in this field
100	YEARHBEG	VARCHAR2	Year haul began, four digits. Collected for ASM where applicable.
100	MONTHHBEG	VARCHAR2	Month haul began, two digits. Collected for ASM where applicable.
100	DAYHBEG	VARCHAR2	Day haul began, two digits. Collected for ASM where applicable.
100	TIMEHBEG	VARCHAR2	Time haul began, local time using 24 hour clock (0000-2359). Collected for ASM where applicable.
100	DATEHBEG	DATE	Date haul began. NOTE: if time is unknown it defaults to midnight in this field. Collected for ASM where applicable.
100	YEARHEND	VARCHAR2	Year haul ended, four digits.Not collected before 5/1994; set to unknown.
100	MONTHEND	VARCHAR2	Month haul ended, two digits. Collected for ASM where applicable.
100	DAYHEND	VARCHAR2	Day haul ended, two digits.Not recorded prior to 5/1994; set to unknown. Collected for ASM where applicable.
100	TIMEHEND	VARCHAR2	Time haul ended, local time using 24 hour clock (0000-2359). Collected for ASM where applicable.
100	DATEHEND	DATE	Date the haul ended.Not recorded prior to 5/1994; set to unknown NOTE: if time is unknown it defaults to midnight in this field. Collected for ASM where applicable.
100	YEARFBEG	VARCHAR2	Year that the gear was fully deployed and actively fishing (3/2007)
100	MONTHFBEG	VARCHAR2	Month that the gear was fully deployed and actively fishing (3/2007)
100	DAYFBEG	VARCHAR2	Day that the gear was fully deployed and actively fishing (3/2007)
100	TIMEFBEG	VARCHAR2	Time (24 hour clock) that the gear was fully deployed and actively fishing (3/2007)
100	DATEFBEG	DATE	Date that the gear is fully deployed and actively fishing(3/2007) NOTE: if time fishing begins (TIMEFBEG) is unknown it defaults to midnight.
100	YEARGONBD	VARCHAR2	YEAR when all gear was out of the water. (3/2007)
100	MONTHGONBD	VARCHAR2	Month (local time) that the gear from the haul is completely out of the water (3/2007)
100	DAYGONBD	VARCHAR2	Day (local time) that the gear form the haul is completely out of the water (3/2007)
100	TIMEGONBD	VARCHAR2	4-digit local time (24-hour clock) when all gear was out of the water. (3/2007)
100	DATEGONBD	DATE	Local date and time that the gear form the haul is completely out of the water (3/2007)
100	LATSBEG	VARCHAR2	Latitude where set began (DDMMSS). Not recorded 1989 - 5/1994 5/1994 - 12/2000: SS rounded to 30 where no lorans
100	LATSEND	VARCHAR2	Latitude (DDMMSS) where set ended. Not recorded 1989 - 5/1994 5/1994 - 12/2000: SS rounded to 30 where no lorans
100	LATHBEG	VARCHAR2	Latitude location, (DDMMSS) where haul began. Pre 2001 : SS rounded to 30 where no loran. Collected for ASM where applicable.
100	LATHEND	VARCHAR2	Latitude (DDMMSS) where haul ended. Not recorded 1989 - 5/1994 5/1994 - 12/2000: SS rounded to 30 where no lorans. Collected for ASM where applicable.
100	LONSBEG	VARCHAR2	Longitude location of where set began, (DDMMSS). Not recorded 1989 - 5/1994 5/1994 - 12/2000: SS rounded to 30 where no lorans
100	LONSEND	VARCHAR2	Longitude where set ended, (DDMMSS). Not recorded 1989 - 5/1994 5/1994 - 12/2000: SS rounded to 30 where no lorans
100	LONHBEG	VARCHAR2	Longitude location of where haul began, (DDMMSS). Pre 2001: SS rounded to 30 where no lorans. Collected for ASM where applicable.
100	LONHEND	VARCHAR2	Longitude location of where haul ended, (DDMMSS). Pre 2001: SS rounded to 30 where no lorans. Collected for ASM where applicable.
100	GIS_LATSBEG	NUMBER	GIS format (decimal degrees) for set begin latitude
100	GIS_LATSEND	NUMBER	GIS format (decimal degrees) for set end latitude
100	GIS_LATHBEG	NUMBER	GIS format (decimal degrees) for haul begin latitude. Collected for ASM where applicable.
100	GIS_LATHEND	NUMBER	GIS format (decimal degrees) for haul end latitude. Collected for ASM where applicable.
100	GIS_LONSBEG	NUMBER	GIS format (decimal degrees) for set begin longitude
100	GIS_LONSEND	NUMBER	GIS format (decimal degrees) for set end longitude
100	GIS_LONHBEG	NUMBER	GIS format (decimal degrees) for haul begin longitude. Collected for ASM where applicable.
100	GIS_LONHEND	NUMBER	GIS format (decimal degrees) for haul end longitude. Collected for ASM where applicable.
100	WTMP	NUMBER	The surface sea water Fahrenheit temperature, to the nearest tenth, when haul ended. Not entered before 5/1994
100	SOAKDUR	NUMBER	Fixed gear only. Amount of time that the gear for haul is in the water, to the nearest tenth of an hour (haul begin - set end). BEACH SEINE: estimated; Time from when the gear is secured to the beach until hauling of the warpline begins. Collected for ASM where applicable.
100	SETDUR	NUMBER	(fixed gears only) Time it takes to set out the gear; Time set end - time set begin;
100	HAULDUR	NUMBER	GILLNET, LONGLINE, POTS: Length of time (hours) from beginning to haul the gear out until all the gear is out. (Haul end - Haul begin). BEACH SEINE: Length of time (hours)from the beginning of haul of warpline until last portion of net exits the surf zone. OTTER TRAWL, SCALLOP DREDGE: Length of time (hours) from when the net hits the water until hauling equipment put in gear . PAIR TRAWL: Length of time (hours) from when the net hits the water until legs retrieved and aboard both vessels. Calculated for ASM where applicable.
100	QDSQ	VARCHAR2	Quarter Degree Square, lookup in LOC2AREAS table.
100	TENMSQ	VARCHAR2	Position in grid computed from lat/lon; relative minute position in a degree square 1-6 west to east for longitude and 1-6 north to south for latitude.
100	NEMAREA	VARCHAR2	Inshore area codes. See Loc2areas table. Not collected before 5/1994; set to statistical area.
100	AREA	VARCHAR2	Statistical area code obtained from positions at beginning of haul for fixed gear and end of the haul for mobile gear or at sighting position. See LOC2AREAS table on sole. Collected for ASM where applicable.
100	ONEFFORT	VARCHAR2	Indicator whether the observer is intentionally present to witness the haulback 1 = yes, 0 = no, 9 = unknown Collected beginning with obdbs Version 10 (01/01/2011).
100	HAUCOMMENTS	VARCHAR2	Prior to 2001 only true (1), false (0). Collected for ASM where applicable.
100	ASMTEST_STATUS	VARCHAR2	Test / Load status for At Sea Monitoring trip. PRELIM = preliminary testing, BASE = fully tested

Name

Type

Description

100

PROGRAM

VARCHAR2

First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.

100

YEAR

VARCHAR2

Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.

100

MONTH

VARCHAR2

Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.

100

TRIPID

VARCHAR2

May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable.

100

HAULNUM

VARCHAR2

Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable.

100

LINK1

VARCHAR2

15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable.

100

QTR

NUMBER

Quarter of year landed: 1 = Jan, Feb, Mar; 2 = Apr,May,Jun 3=Jul, Aug, Sep, 4= Oct, Nov, Dec. Collected for ASM where applicable.

100

LINK3

VARCHAR2

Key field linking tables at the haul level; made up of: link1 plus (4-character) haulnum. Collected for ASM where applicable.

100

NEGEAR

VARCHAR2

Northeast gear code. See OBGEAR table. Collected for ASM where applicable.

100

OBSRFLAG

VARCHAR2

Indicator of whether haul was observed for discards (all hauls are observed for catch except for offwatch (sdo, sto, cdo) hauls). 0=no; 1=yes. Collected for ASM where applicable.

100

CATEXIST

VARCHAR2

Indicator of whether gear from haul holds any catch, kept or discarded. 0=no; 1=yes.

100

INCTAKE

VARCHAR2

Indicator of whether Sea Turtle, Marine Mammal, or Sea Bird is caught by gear in haul. 0 = no 1 = yes. Collected for ASM where applicable.

100

WEATHER

VARCHAR2

HAUL: Code for weather at beginning of haul. EVENT: Code for weather at time event occurred. See support table OBWEATHER for codes. Collected for ASM where applicable.

100

WINDSP

NUMBER

Wind speed at beginning of haul, in whole knots.

100

WINDDIR

VARCHAR2

Wind direction (compass direction) from which the wind is blowing at beginning of haul.

100

WAVEHGT

NUMBER

HAUL: Wave height at beginning of haul, in whole feet. EVENT: Wave height at beginning of event, in whole feet. Not collected prior to 5/1994; set to unknown. Collected for ASM where applicable.

100

DEPTH

NUMBER

Water depth at beginning of haul, in whole fathoms.

100

GEARCOND

VARCHAR2

Condition of gear at Haul. See OBGEARCOND table. Collected for ASM where applicable.

100

TARGSPEC1

VARCHAR2

NESPP4 for any of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear. Collected for ASM where applicable.

100

TARGSPEC2

VARCHAR2

NESPP4 code for any of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear. Collected for ASM where applicable.

100

TARGSPEC3

VARCHAR2

NESPP4 code for any of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear.

100

TARGSPEC4

VARCHAR2

NESPP4 code for any one of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear.

100

TARGSPEC5

VARCHAR2

NESPP4 for any one of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear.

100

YEARSBEG

VARCHAR2

Year set began, four digits.Not collected before 5/1994; set to unknown.

100

MONTHSBEG

VARCHAR2

Two digit month set began. Not collected 1989 - 4/1994;

100

DAYSBEG

VARCHAR2

Day set began, two digits.

100

TIMESBEG

VARCHAR2

Time set began, local time using 24 hour clock (0000-2359). Not collected before 5/1994; set to unknown

100

DATESBEG

DATE

Date the set began. Not recorded prior to 5/1994; set to unknown NOTE: if time is unknown it defaults to midnight in this field

100

YEARSEND

VARCHAR2

Year set ended, four digits. Not collected before 5/1994; set to unknown.

100

MONTHSEND

VARCHAR2

Two digit month the set ended.

100

DAYSEND

VARCHAR2

Day set ended, two digits.Not recorded prior to 5/1994; set to unknown

100

TIMESEND

VARCHAR2

Time set ended, local time using 24 hour clock (0000-2359). Not collected before 5/1994; set to unknown

100

DATESEND

DATE

Date the set of the gear ended.Not recorded prior to 5/1994; set to unknown NOTE: if time is unknown it defaults to midnight in this field

100

YEARHBEG

VARCHAR2

Year haul began, four digits. Collected for ASM where applicable.

100

MONTHHBEG

VARCHAR2

Month haul began, two digits. Collected for ASM where applicable.

100

DAYHBEG

VARCHAR2

Day haul began, two digits. Collected for ASM where applicable.

100

TIMEHBEG

VARCHAR2

Time haul began, local time using 24 hour clock (0000-2359). Collected for ASM where applicable.

100

DATEHBEG

DATE

Date haul began. NOTE: if time is unknown it defaults to midnight in this field. Collected for ASM where applicable.

100

YEARHEND

VARCHAR2

Year haul ended, four digits.Not collected before 5/1994; set to unknown.

100

MONTHEND

VARCHAR2

Month haul ended, two digits. Collected for ASM where applicable.

100

DAYHEND

VARCHAR2

Day haul ended, two digits.Not recorded prior to 5/1994; set to unknown. Collected for ASM where applicable.

100

TIMEHEND

VARCHAR2

Time haul ended, local time using 24 hour clock (0000-2359). Collected for ASM where applicable.

100

DATEHEND

DATE

Date the haul ended.Not recorded prior to 5/1994; set to unknown NOTE: if time is unknown it defaults to midnight in this field. Collected for ASM where applicable.

100

YEARFBEG

VARCHAR2

Year that the gear was fully deployed and actively fishing (3/2007)

100

MONTHFBEG

VARCHAR2

Month that the gear was fully deployed and actively fishing (3/2007)

100

DAYFBEG

VARCHAR2

Day that the gear was fully deployed and actively fishing (3/2007)

100

TIMEFBEG

VARCHAR2

Time (24 hour clock) that the gear was fully deployed and actively fishing (3/2007)

100

DATEFBEG

DATE

Date that the gear is fully deployed and actively fishing(3/2007) NOTE: if time fishing begins (TIMEFBEG) is unknown it defaults to midnight.

100

YEARGONBD

VARCHAR2

YEAR when all gear was out of the water. (3/2007)

100

MONTHGONBD

VARCHAR2

Month (local time) that the gear from the haul is completely out of the water (3/2007)

100

DAYGONBD

VARCHAR2

Day (local time) that the gear form the haul is completely out of the water (3/2007)

100

TIMEGONBD

VARCHAR2

4-digit local time (24-hour clock) when all gear was out of the water. (3/2007)

100

DATEGONBD

DATE

Local date and time that the gear form the haul is completely out of the water (3/2007)

100

LATSBEG

VARCHAR2

Latitude where set began (DDMMSS). Not recorded 1989 - 5/1994 5/1994 - 12/2000: SS rounded to 30 where no lorans

100

LATSEND

VARCHAR2

Latitude (DDMMSS) where set ended. Not recorded 1989 - 5/1994 5/1994 - 12/2000: SS rounded to 30 where no lorans

100

LATHBEG

VARCHAR2

Latitude location, (DDMMSS) where haul began. Pre 2001 : SS rounded to 30 where no loran. Collected for ASM where applicable.

100

LATHEND

VARCHAR2

Latitude (DDMMSS) where haul ended. Not recorded 1989 - 5/1994 5/1994 - 12/2000: SS rounded to 30 where no lorans. Collected for ASM where applicable.

100

LONSBEG

VARCHAR2

Longitude location of where set began, (DDMMSS). Not recorded 1989 - 5/1994 5/1994 - 12/2000: SS rounded to 30 where no lorans

100

LONSEND

VARCHAR2

Longitude where set ended, (DDMMSS). Not recorded 1989 - 5/1994 5/1994 - 12/2000: SS rounded to 30 where no lorans

100

LONHBEG

VARCHAR2

Longitude location of where haul began, (DDMMSS). Pre 2001: SS rounded to 30 where no lorans. Collected for ASM where applicable.

100

LONHEND

VARCHAR2

Longitude location of where haul ended, (DDMMSS). Pre 2001: SS rounded to 30 where no lorans. Collected for ASM where applicable.

100

GIS_LATSBEG

NUMBER

GIS format (decimal degrees) for set begin latitude

100

GIS_LATSEND

NUMBER

GIS format (decimal degrees) for set end latitude

100

GIS_LATHBEG

NUMBER

GIS format (decimal degrees) for haul begin latitude. Collected for ASM where applicable.

100

GIS_LATHEND

NUMBER

GIS format (decimal degrees) for haul end latitude. Collected for ASM where applicable.

100

GIS_LONSBEG

NUMBER

GIS format (decimal degrees) for set begin longitude

100

GIS_LONSEND

NUMBER

GIS format (decimal degrees) for set end longitude

100

GIS_LONHBEG

NUMBER

GIS format (decimal degrees) for haul begin longitude. Collected for ASM where applicable.

100

GIS_LONHEND

NUMBER

GIS format (decimal degrees) for haul end longitude. Collected for ASM where applicable.

100

WTMP

NUMBER

The surface sea water Fahrenheit temperature, to the nearest tenth, when haul ended. Not entered before 5/1994

100

SOAKDUR

NUMBER

Fixed gear only. Amount of time that the gear for haul is in the water, to the nearest tenth of an hour (haul begin - set end). BEACH SEINE: estimated; Time from when the gear is secured to the beach until hauling of the warpline begins. Collected for ASM where applicable.

100

SETDUR

NUMBER

(fixed gears only) Time it takes to set out the gear; Time set end - time set begin;

100

HAULDUR

NUMBER

GILLNET, LONGLINE, POTS: Length of time (hours) from beginning to haul the gear out until all the gear is out. (Haul end - Haul begin). BEACH SEINE: Length of time (hours)from the beginning of haul of warpline until last portion of net exits the surf zone. OTTER TRAWL, SCALLOP DREDGE: Length of time (hours) from when the net hits the water until hauling equipment put in gear . PAIR TRAWL: Length of time (hours) from when the net hits the water until legs retrieved and aboard both vessels. Calculated for ASM where applicable.

100

QDSQ

VARCHAR2

Quarter Degree Square, lookup in LOC2AREAS table.

100

TENMSQ

VARCHAR2

Position in grid computed from lat/lon; relative minute position in a degree square 1-6 west to east for longitude and 1-6 north to south for latitude.

100

NEMAREA

VARCHAR2

Inshore area codes. See Loc2areas table. Not collected before 5/1994; set to statistical area.

100

AREA

VARCHAR2

Statistical area code obtained from positions at beginning of haul for fixed gear and end of the haul for mobile gear or at sighting position. See LOC2AREAS table on sole. Collected for ASM where applicable.

100

ONEFFORT

VARCHAR2

Indicator whether the observer is intentionally present to witness the haulback 1 = yes, 0 = no, 9 = unknown Collected beginning with obdbs Version 10 (01/01/2011).

100

HAUCOMMENTS

VARCHAR2

Prior to 2001 only true (1), false (0). Collected for ASM where applicable.

100

ASMTEST_STATUS

VARCHAR2

Test / Load status for At Sea Monitoring trip. PRELIM = preliminary testing, BASE = fully tested

PROGRAM

CC ID: 333853

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.
General Data Type:	VARCHAR2

YEAR

CC ID: 333864

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.
General Data Type:	VARCHAR2

MONTH

CC ID: 333875

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.
General Data Type:	VARCHAR2

TRIPID

CC ID: 333886

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable.
General Data Type:	VARCHAR2

HAULNUM

CC ID: 333897

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable.
General Data Type:	VARCHAR2

LINK1

CC ID: 333908

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	15
Required:	No
Primary Key:	No
Status:	Active
Description:	15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable.
General Data Type:	VARCHAR2

QTR

CC ID: 333919

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Quarter of year landed: 1 = Jan, Feb, Mar; 2 = Apr,May,Jun 3=Jul, Aug, Sep, 4= Oct, Nov, Dec. Collected for ASM where applicable.
General Data Type:	NUMBER

LINK3

CC ID: 333930

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	19
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Key field linking tables at the haul level; made up of: link1 plus (4-character) haulnum. Collected for ASM where applicable.
General Data Type:	VARCHAR2

NEGEAR

CC ID: 333932

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Northeast gear code. See OBGEAR table. Collected for ASM where applicable.
General Data Type:	VARCHAR2

OBSRFLAG

CC ID: 333854

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Indicator of whether haul was observed for discards (all hauls are observed for catch except for offwatch (sdo, sto, cdo) hauls). 0=no; 1=yes. Collected for ASM where applicable.
General Data Type:	VARCHAR2

CATEXIST

CC ID: 333855

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of whether gear from haul holds any catch, kept or discarded. 0=no; 1=yes.
General Data Type:	VARCHAR2

INCTAKE

CC ID: 333856

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Indicator of whether Sea Turtle, Marine Mammal, or Sea Bird is caught by gear in haul. 0 = no 1 = yes. Collected for ASM where applicable.
General Data Type:	VARCHAR2

WEATHER

CC ID: 333857

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	Yes
Primary Key:	No
Status:	Active
Description:	HAUL: Code for weather at beginning of haul. EVENT: Code for weather at time event occurred. See support table OBWEATHER for codes. Collected for ASM where applicable.
General Data Type:	VARCHAR2

WINDSP

CC ID: 333858

Seq. Order:	14
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Wind speed at beginning of haul, in whole knots.
General Data Type:	NUMBER

WINDDIR

CC ID: 333859

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Wind direction (compass direction) from which the wind is blowing at beginning of haul.
General Data Type:	VARCHAR2

WAVEHGT

CC ID: 333860

Seq. Order:	16
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	HAUL: Wave height at beginning of haul, in whole feet. EVENT: Wave height at beginning of event, in whole feet. Not collected prior to 5/1994; set to unknown. Collected for ASM where applicable.
General Data Type:	NUMBER

DEPTH

CC ID: 333861

Seq. Order:	17
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Water depth at beginning of haul, in whole fathoms.
General Data Type:	NUMBER

GEARCOND

CC ID: 333862

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Condition of gear at Haul. See OBGEARCOND table. Collected for ASM where applicable.
General Data Type:	VARCHAR2

TARGSPEC1

CC ID: 333863

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	Yes
Primary Key:	No
Status:	Active
Description:	NESPP4 for any of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear. Collected for ASM where applicable.
General Data Type:	VARCHAR2

TARGSPEC2

CC ID: 333865

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	NESPP4 code for any of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear. Collected for ASM where applicable.
General Data Type:	VARCHAR2

TARGSPEC3

CC ID: 333866

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	NESPP4 code for any of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear.
General Data Type:	VARCHAR2

TARGSPEC4

CC ID: 333867

Seq. Order:	22
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	NESPP4 code for any one of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear.
General Data Type:	VARCHAR2

TARGSPEC5

CC ID: 333868

Seq. Order:	23
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	NESPP4 for any one of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear.
General Data Type:	VARCHAR2

YEARSBEG

CC ID: 333869

Seq. Order:	24
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Year set began, four digits.Not collected before 5/1994; set to unknown.
General Data Type:	VARCHAR2

MONTHSBEG

CC ID: 333870

Seq. Order:	25
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Two digit month set began. Not collected 1989 - 4/1994;
General Data Type:	VARCHAR2

DAYSBEG

CC ID: 333871

Seq. Order:	26
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Day set began, two digits.
General Data Type:	VARCHAR2

TIMESBEG

CC ID: 333872

Seq. Order:	27
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Time set began, local time using 24 hour clock (0000-2359). Not collected before 5/1994; set to unknown
General Data Type:	VARCHAR2

DATESBEG

CC ID: 333873

Seq. Order:	28
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date the set began. Not recorded prior to 5/1994; set to unknown NOTE: if time is unknown it defaults to midnight in this field
General Data Type:	DATE

YEARSEND

CC ID: 333874

Seq. Order:	29
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Year set ended, four digits. Not collected before 5/1994; set to unknown.
General Data Type:	VARCHAR2

MONTHSEND

CC ID: 333876

Seq. Order:	30
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Two digit month the set ended.
General Data Type:	VARCHAR2

DAYSEND

CC ID: 333877

Seq. Order:	31
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Day set ended, two digits.Not recorded prior to 5/1994; set to unknown
General Data Type:	VARCHAR2

TIMESEND

CC ID: 333878

Seq. Order:	32
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Time set ended, local time using 24 hour clock (0000-2359). Not collected before 5/1994; set to unknown
General Data Type:	VARCHAR2

DATESEND

CC ID: 333879

Seq. Order:	33
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date the set of the gear ended.Not recorded prior to 5/1994; set to unknown NOTE: if time is unknown it defaults to midnight in this field
General Data Type:	DATE

YEARHBEG

CC ID: 333880

Seq. Order:	34
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Year haul began, four digits. Collected for ASM where applicable.
General Data Type:	VARCHAR2

MONTHHBEG

CC ID: 333881

Seq. Order:	35
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Month haul began, two digits. Collected for ASM where applicable.
General Data Type:	VARCHAR2

DAYHBEG

CC ID: 333882

Seq. Order:	36
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Day haul began, two digits. Collected for ASM where applicable.
General Data Type:	VARCHAR2

TIMEHBEG

CC ID: 333883

Seq. Order:	37
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Time haul began, local time using 24 hour clock (0000-2359). Collected for ASM where applicable.
General Data Type:	VARCHAR2

DATEHBEG

CC ID: 333884

Seq. Order:	38
Data Storage Type:	DATE
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active
Description:	Date haul began. NOTE: if time is unknown it defaults to midnight in this field. Collected for ASM where applicable.
General Data Type:	DATE

YEARHEND

CC ID: 333885

Seq. Order:	39
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Year haul ended, four digits.Not collected before 5/1994; set to unknown.
General Data Type:	VARCHAR2

MONTHEND

CC ID: 333887

Seq. Order:	40
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Month haul ended, two digits. Collected for ASM where applicable.
General Data Type:	VARCHAR2

DAYHEND

CC ID: 333888

Seq. Order:	41
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Day haul ended, two digits.Not recorded prior to 5/1994; set to unknown. Collected for ASM where applicable.
General Data Type:	VARCHAR2

TIMEHEND

CC ID: 333889

Seq. Order:	42
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Time haul ended, local time using 24 hour clock (0000-2359). Collected for ASM where applicable.
General Data Type:	VARCHAR2

DATEHEND

CC ID: 333890

Seq. Order:	43
Data Storage Type:	DATE
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active
Description:	Date the haul ended.Not recorded prior to 5/1994; set to unknown NOTE: if time is unknown it defaults to midnight in this field. Collected for ASM where applicable.
General Data Type:	DATE

YEARFBEG

CC ID: 333891

Seq. Order:	44
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Year that the gear was fully deployed and actively fishing (3/2007)
General Data Type:	VARCHAR2

MONTHFBEG

CC ID: 333892

Seq. Order:	45
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Month that the gear was fully deployed and actively fishing (3/2007)
General Data Type:	VARCHAR2

DAYFBEG

CC ID: 333893

Seq. Order:	46
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Day that the gear was fully deployed and actively fishing (3/2007)
General Data Type:	VARCHAR2

TIMEFBEG

CC ID: 333894

Seq. Order:	47
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Time (24 hour clock) that the gear was fully deployed and actively fishing (3/2007)
General Data Type:	VARCHAR2

DATEFBEG

CC ID: 333895

Seq. Order:	48
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date that the gear is fully deployed and actively fishing(3/2007) NOTE: if time fishing begins (TIMEFBEG) is unknown it defaults to midnight.
General Data Type:	DATE

YEARGONBD

CC ID: 333896

Seq. Order:	49
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	YEAR when all gear was out of the water. (3/2007)
General Data Type:	VARCHAR2

MONTHGONBD

CC ID: 333898

Seq. Order:	50
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Month (local time) that the gear from the haul is completely out of the water (3/2007)
General Data Type:	VARCHAR2

DAYGONBD

CC ID: 333899

Seq. Order:	51
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Day (local time) that the gear form the haul is completely out of the water (3/2007)
General Data Type:	VARCHAR2

TIMEGONBD

CC ID: 333900

Seq. Order:	52
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	4-digit local time (24-hour clock) when all gear was out of the water. (3/2007)
General Data Type:	VARCHAR2

DATEGONBD

CC ID: 333901

Seq. Order:	53
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Local date and time that the gear form the haul is completely out of the water (3/2007)
General Data Type:	DATE

LATSBEG

CC ID: 333902

Seq. Order:	54
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Latitude where set began (DDMMSS). Not recorded 1989 - 5/1994 5/1994 - 12/2000: SS rounded to 30 where no lorans
General Data Type:	VARCHAR2

LATSEND

CC ID: 333903

Seq. Order:	55
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Latitude (DDMMSS) where set ended. Not recorded 1989 - 5/1994 5/1994 - 12/2000: SS rounded to 30 where no lorans
General Data Type:	VARCHAR2

LATHBEG

CC ID: 333904

Seq. Order:	56
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Latitude location, (DDMMSS) where haul began. Pre 2001 : SS rounded to 30 where no loran. Collected for ASM where applicable.
General Data Type:	VARCHAR2

LATHEND

CC ID: 333905

Seq. Order:	57
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Latitude (DDMMSS) where haul ended. Not recorded 1989 - 5/1994 5/1994 - 12/2000: SS rounded to 30 where no lorans. Collected for ASM where applicable.
General Data Type:	VARCHAR2

LONSBEG

CC ID: 333906

Seq. Order:	58
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Longitude location of where set began, (DDMMSS). Not recorded 1989 - 5/1994 5/1994 - 12/2000: SS rounded to 30 where no lorans
General Data Type:	VARCHAR2

LONSEND

CC ID: 333907

Seq. Order:	59
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Longitude where set ended, (DDMMSS). Not recorded 1989 - 5/1994 5/1994 - 12/2000: SS rounded to 30 where no lorans
General Data Type:	VARCHAR2

LONHBEG

CC ID: 333909

Seq. Order:	60
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Longitude location of where haul began, (DDMMSS). Pre 2001: SS rounded to 30 where no lorans. Collected for ASM where applicable.
General Data Type:	VARCHAR2

LONHEND

CC ID: 333910

Seq. Order:	61
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Longitude location of where haul ended, (DDMMSS). Pre 2001: SS rounded to 30 where no lorans. Collected for ASM where applicable.
General Data Type:	VARCHAR2

GIS_LATSBEG

CC ID: 333911

Seq. Order:	62
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	8
Scale:	6
Status:	Active
Description:	GIS format (decimal degrees) for set begin latitude
General Data Type:	NUMBER

GIS_LATSEND

CC ID: 333912

Seq. Order:	63
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	8
Scale:	6
Status:	Active
Description:	GIS format (decimal degrees) for set end latitude
General Data Type:	NUMBER

GIS_LATHBEG

CC ID: 333913

Seq. Order:	64
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	8
Scale:	6
Status:	Active
Description:	GIS format (decimal degrees) for haul begin latitude. Collected for ASM where applicable.
General Data Type:	NUMBER

GIS_LATHEND

CC ID: 333914

Seq. Order:	65
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	8
Scale:	6
Status:	Active
Description:	GIS format (decimal degrees) for haul end latitude. Collected for ASM where applicable.
General Data Type:	NUMBER

GIS_LONSBEG

CC ID: 333915

Seq. Order:	66
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	GIS format (decimal degrees) for set begin longitude
General Data Type:	NUMBER

GIS_LONSEND

CC ID: 333916

Seq. Order:	67
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	GIS format (decimal degrees) for set end longitude
General Data Type:	NUMBER

GIS_LONHBEG

CC ID: 333917

Seq. Order:	68
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	GIS format (decimal degrees) for haul begin longitude. Collected for ASM where applicable.
General Data Type:	NUMBER

GIS_LONHEND

CC ID: 333918

Seq. Order:	69
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	GIS format (decimal degrees) for haul end longitude. Collected for ASM where applicable.
General Data Type:	NUMBER

WTMP

CC ID: 333920

Seq. Order:	70
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	1
Status:	Active
Description:	The surface sea water Fahrenheit temperature, to the nearest tenth, when haul ended. Not entered before 5/1994
General Data Type:	NUMBER

SOAKDUR

CC ID: 333921

Seq. Order:	71
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	1
Status:	Active
Description:	Fixed gear only. Amount of time that the gear for haul is in the water, to the nearest tenth of an hour (haul begin - set end). BEACH SEINE: estimated; Time from when the gear is secured to the beach until hauling of the warpline begins. Collected for ASM where applicable.
General Data Type:	NUMBER

SETDUR

CC ID: 333922

Seq. Order:	72
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	1
Status:	Active
Description:	(fixed gears only) Time it takes to set out the gear; Time set end - time set begin;
General Data Type:	NUMBER

HAULDUR

CC ID: 333923

Seq. Order:	73
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	1
Status:	Active
Description:	GILLNET, LONGLINE, POTS: Length of time (hours) from beginning to haul the gear out until all the gear is out. (Haul end - Haul begin). BEACH SEINE: Length of time (hours)from the beginning of haul of warpline until last portion of net exits the surf zone. OTTER TRAWL, SCALLOP DREDGE: Length of time (hours) from when the net hits the water until hauling equipment put in gear . PAIR TRAWL: Length of time (hours) from when the net hits the water until legs retrieved and aboard both vessels. Calculated for ASM where applicable.
General Data Type:	NUMBER

QDSQ

CC ID: 333924

Seq. Order:	74
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Status:	Active
Description:	Quarter Degree Square, lookup in LOC2AREAS table.
General Data Type:	VARCHAR2

TENMSQ

CC ID: 333925

Seq. Order:	75
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Position in grid computed from lat/lon; relative minute position in a degree square 1-6 west to east for longitude and 1-6 north to south for latitude.
General Data Type:	VARCHAR2

NEMAREA

CC ID: 333926

Seq. Order:	76
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Inshore area codes. See Loc2areas table. Not collected before 5/1994; set to statistical area.
General Data Type:	VARCHAR2

AREA

CC ID: 333927

Seq. Order:	77
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Statistical area code obtained from positions at beginning of haul for fixed gear and end of the haul for mobile gear or at sighting position. See LOC2AREAS table on sole. Collected for ASM where applicable.
General Data Type:	VARCHAR2

ONEFFORT

CC ID: 333928

Seq. Order:	78
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator whether the observer is intentionally present to witness the haulback 1 = yes, 0 = no, 9 = unknown Collected beginning with obdbs Version 10 (01/01/2011).
General Data Type:	VARCHAR2

HAUCOMMENTS

CC ID: 333929

Seq. Order:	79
Data Storage Type:	VARCHAR2
Max Length:	250
Required:	No
Primary Key:	No
Status:	Active
Description:	Prior to 2001 only true (1), false (0). Collected for ASM where applicable.
General Data Type:	VARCHAR2

ASMTEST_STATUS

CC ID: 333931

Seq. Order:	80
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Test / Load status for At Sea Monitoring trip. PRELIM = preliminary testing, BASE = fully tested
General Data Type:	VARCHAR2

Catalog Item ID:	33551
GUID:	gov.noaa.nmfs.inport:33551
Metadata Record Created By:	Patricia L Jones
Metadata Record Created:	2016-07-27 19:10+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2016-07-28
Owner Org:	NEFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2016-07-28
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2017-07-28

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

PROGRAM

YEAR

MONTH

TRIPID

HAULNUM

LINK1

QTR

LINK3

NEGEAR

OBSRFLAG

CATEXIST

INCTAKE

WEATHER

WINDSP

WINDDIR

WAVEHGT

DEPTH

GEARCOND

TARGSPEC1

TARGSPEC2

TARGSPEC3

TARGSPEC4

TARGSPEC5

YEARSBEG

MONTHSBEG

DAYSBEG

TIMESBEG

DATESBEG

YEARSEND

MONTHSEND

DAYSEND

TIMESEND

DATESEND

YEARHBEG

MONTHHBEG

DAYHBEG

TIMEHBEG

DATEHBEG

YEARHEND

MONTHEND

DAYHEND

TIMEHEND

DATEHEND

YEARFBEG

MONTHFBEG

DAYFBEG

TIMEFBEG

DATEFBEG

YEARGONBD

MONTHGONBD

DAYGONBD

TIMEGONBD

DATEGONBD

LATSBEG

LATSEND

LATHBEG

LATHEND

LONSBEG

LONSEND

LONHBEG

LONHEND

GIS_LATSBEG

GIS_LATSEND

GIS_LATHBEG

GIS_LATHEND

GIS_LONSBEG

GIS_LONSEND

GIS_LONHBEG

GIS_LONHEND

WTMP

SOAKDUR

SETDUR

HAULDUR

QDSQ

TENMSQ