Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Fisheries Sampling Branch (FSB) > Observer and At Sea Monitor Database (OBDBS) >

Table: OBGEARCOND

Entity (ENT) | Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:33340 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Observer Gear Condition Support Table

Description

Observer Gear Condition Support Table

Entity Type
Data Table

Data Attribute / Type	Description
GEARCOND VARCHAR2	Condition of gear at Haul. See OBGEARCOND table. Collected for ASM where applicable.
GEARCONDDESC VARCHAR2	Description of the gear condition coded in gearcond.
OBGEARCAT1 VARCHAR2	One of the gear categories that legitimately references the code in the record.Gear Category used by observer program: OT = Otter trawl,GG = gillnet, PT = Pots and traps , LL = Longline and other line gear, BS = beach set, SD = Scallop Dredge, PR = pair trawl,PS = purse seine, ST = Scallop Trawl, TT Twin Trawl, NK =Not known, OB=Obsolete.
OBGEARCAT2 VARCHAR2	One of the gear categories that legitimately references the code in the record.Gear Category used by observer program: OT = Otter trawl,GG = gillnet, PT = Pots and traps , LL = Longline and other line gear, BS = beach set, SD = Scallop Dredge, PR = pair trawl,PS = purse seine, ST = Scallop Trawl, TT Twin Trawl, NK =Not known, OB=Obsolete.
GEARCONDCOMMENTS VARCHAR2	Additional information on the Gear Condition.
DOE DATE	Date of Entry of the associated record.
UOE VARCHAR2	Oracle user ID of the person who entered the data.
DOC DATE	Date associated record was updated.
UOC VARCHAR2	Oracle ID of user who made the (most recent ) change on the record.
OBGEARCAT3 VARCHAR2	One of the gear categories that legitimately references the code in the record.Gear Category used by observer program: OT = Otter trawl,GG = gillnet, PT = Pots and traps , LL = Longline and other line gear, BS = beach set, SD = Scallop Dredge, PR = pair trawl,PS = purse seine, ST = Scallop Trawl, TT Twin Trawl, NK =Not known, OB=Obsolete.
OBGEARCAT4 VARCHAR2	One of the gear categories that legitimately references the code in the record.Gear Category used by observer program: OT = Otter trawl,GG = gillnet, PT = Pots and traps , LL = Longline and other line gear, BS = beach set, SD = Scallop Dredge, PR = pair trawl,PS = purse seine, ST = Scallop Trawl, TT Twin Trawl, NK =Not known, OB=Obsolete.
GEARCATSTR VARCHAR2	List of gear categories, comma delimeted list.
GEARCONDLIST VARCHAR2	Shortened description of the gear condition coded in gearcond.

Data Attribute / Type

Description

GEARCOND
VARCHAR2

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

GEARCONDDESC
VARCHAR2

Description of the gear condition coded in gearcond.

OBGEARCAT1
VARCHAR2

One of the gear categories that legitimately references the code in the record.Gear Category used by observer program: OT = Otter trawl,GG = gillnet, PT = Pots and traps , LL = Longline and other line gear, BS = beach set, SD = Scallop Dredge, PR = pair trawl,PS = purse seine, ST = Scallop Trawl, TT Twin Trawl, NK =Not known, OB=Obsolete.

OBGEARCAT2
VARCHAR2

GEARCONDCOMMENTS
VARCHAR2

Additional information on the Gear Condition.

DOE
DATE

Date of Entry of the associated record.

UOE
VARCHAR2

Oracle user ID of the person who entered the data.

DOC
DATE

Date associated record was updated.

UOC
VARCHAR2

Oracle ID of user who made the (most recent ) change on the record.

OBGEARCAT3
VARCHAR2

OBGEARCAT4
VARCHAR2

GEARCATSTR
VARCHAR2

List of gear categories, comma delimeted list.

GEARCONDLIST
VARCHAR2

Shortened description of the gear condition coded in gearcond.

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (NEFSC) for inquiries on this record.

Title:	Table: OBGEARCOND
Short Name:	OBGEARCOND
Status:	Completed
Abstract:	Observer Gear Condition Support Table
Notes:	Loaded by batch 8950, 07-06-2016 08:24

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	OBDBS
Description:	Observer Gear Condition Support Table

Attribute Summary

	Name	Type	Description
100	GEARCOND	VARCHAR2	Condition of gear at Haul. See OBGEARCOND table. Collected for ASM where applicable.
100	GEARCONDDESC	VARCHAR2	Description of the gear condition coded in gearcond.
100	OBGEARCAT1	VARCHAR2	One of the gear categories that legitimately references the code in the record.Gear Category used by observer program: OT = Otter trawl,GG = gillnet, PT = Pots and traps , LL = Longline and other line gear, BS = beach set, SD = Scallop Dredge, PR = pair trawl,PS = purse seine, ST = Scallop Trawl, TT Twin Trawl, NK =Not known, OB=Obsolete.
100	OBGEARCAT2	VARCHAR2	One of the gear categories that legitimately references the code in the record.Gear Category used by observer program: OT = Otter trawl,GG = gillnet, PT = Pots and traps , LL = Longline and other line gear, BS = beach set, SD = Scallop Dredge, PR = pair trawl,PS = purse seine, ST = Scallop Trawl, TT Twin Trawl, NK =Not known, OB=Obsolete.
100	GEARCONDCOMMENTS	VARCHAR2	Additional information on the Gear Condition.
100	DOE	DATE	Date of Entry of the associated record.
100	UOE	VARCHAR2	Oracle user ID of the person who entered the data.
100	DOC	DATE	Date associated record was updated.
100	UOC	VARCHAR2	Oracle ID of user who made the (most recent ) change on the record.
100	OBGEARCAT3	VARCHAR2	One of the gear categories that legitimately references the code in the record.Gear Category used by observer program: OT = Otter trawl,GG = gillnet, PT = Pots and traps , LL = Longline and other line gear, BS = beach set, SD = Scallop Dredge, PR = pair trawl,PS = purse seine, ST = Scallop Trawl, TT Twin Trawl, NK =Not known, OB=Obsolete.
100	OBGEARCAT4	VARCHAR2	One of the gear categories that legitimately references the code in the record.Gear Category used by observer program: OT = Otter trawl,GG = gillnet, PT = Pots and traps , LL = Longline and other line gear, BS = beach set, SD = Scallop Dredge, PR = pair trawl,PS = purse seine, ST = Scallop Trawl, TT Twin Trawl, NK =Not known, OB=Obsolete.
100	GEARCATSTR	VARCHAR2	List of gear categories, comma delimeted list.
100	GEARCONDLIST	VARCHAR2	Shortened description of the gear condition coded in gearcond.

Name

Type

Description

100

GEARCOND

VARCHAR2

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

100

GEARCONDDESC

VARCHAR2

Description of the gear condition coded in gearcond.

100

OBGEARCAT1

VARCHAR2

100

OBGEARCAT2

VARCHAR2

100

GEARCONDCOMMENTS

VARCHAR2

Additional information on the Gear Condition.

100

DOE

DATE

Date of Entry of the associated record.

100

UOE

VARCHAR2

Oracle user ID of the person who entered the data.

100

DOC

DATE

Date associated record was updated.

100

UOC

VARCHAR2

Oracle ID of user who made the (most recent ) change on the record.

100

OBGEARCAT3

VARCHAR2

100

OBGEARCAT4

VARCHAR2

100

GEARCATSTR

VARCHAR2

List of gear categories, comma delimeted list.

100

GEARCONDLIST

VARCHAR2

Shortened description of the gear condition coded in gearcond.

Attribute Details

GEARCOND

CC ID: 331076

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

GEARCONDDESC

CC ID: 331081

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	200
Required:	No
Primary Key:	No
Status:	Active
Description:	Description of the gear condition coded in gearcond.
General Data Type:	VARCHAR2

OBGEARCAT1

CC ID: 331082

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	One of the gear categories that legitimately references the code in the record.Gear Category used by observer program: OT = Otter trawl,GG = gillnet, PT = Pots and traps , LL = Longline and other line gear, BS = beach set, SD = Scallop Dredge, PR = pair trawl,PS = purse seine, ST = Scallop Trawl, TT Twin Trawl, NK =Not known, OB=Obsolete.
General Data Type:	VARCHAR2

OBGEARCAT2

CC ID: 331083

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	One of the gear categories that legitimately references the code in the record.Gear Category used by observer program: OT = Otter trawl,GG = gillnet, PT = Pots and traps , LL = Longline and other line gear, BS = beach set, SD = Scallop Dredge, PR = pair trawl,PS = purse seine, ST = Scallop Trawl, TT Twin Trawl, NK =Not known, OB=Obsolete.
General Data Type:	VARCHAR2

GEARCONDCOMMENTS

CC ID: 331084

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	250
Required:	No
Primary Key:	No
Status:	Active
Description:	Additional information on the Gear Condition.
General Data Type:	VARCHAR2

DOE

CC ID: 331085

Seq. Order:	6
Data Storage Type:	DATE
Max Length:	7
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Date of Entry of the associated record.
General Data Type:	DATE

UOE

CC ID: 331086

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Oracle user ID of the person who entered the data.
General Data Type:	VARCHAR2

DOC

CC ID: 331087

Seq. Order:	8
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date associated record was updated.
General Data Type:	DATE

UOC

CC ID: 331088

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active
Description:	Oracle ID of user who made the (most recent ) change on the record.
General Data Type:	VARCHAR2

OBGEARCAT3

CC ID: 331077

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	One of the gear categories that legitimately references the code in the record.Gear Category used by observer program: OT = Otter trawl,GG = gillnet, PT = Pots and traps , LL = Longline and other line gear, BS = beach set, SD = Scallop Dredge, PR = pair trawl,PS = purse seine, ST = Scallop Trawl, TT Twin Trawl, NK =Not known, OB=Obsolete.
General Data Type:	VARCHAR2

OBGEARCAT4

CC ID: 331078

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	One of the gear categories that legitimately references the code in the record.Gear Category used by observer program: OT = Otter trawl,GG = gillnet, PT = Pots and traps , LL = Longline and other line gear, BS = beach set, SD = Scallop Dredge, PR = pair trawl,PS = purse seine, ST = Scallop Trawl, TT Twin Trawl, NK =Not known, OB=Obsolete.
General Data Type:	VARCHAR2

GEARCATSTR

CC ID: 331079

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	List of gear categories, comma delimeted list.
General Data Type:	VARCHAR2

GEARCONDLIST

CC ID: 331080

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	25
Required:	No
Primary Key:	No
Status:	Active
Description:	Shortened description of the gear condition coded in gearcond.
General Data Type:	VARCHAR2

Catalog Item ID:	33340
GUID:	gov.noaa.nmfs.inport:33340
Metadata Record Created By:	Patricia L Jones
Metadata Record Created:	2016-07-06 08:24+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

Table: OBGEARCOND

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

GEARCOND

GEARCONDDESC

OBGEARCAT1

OBGEARCAT2

GEARCONDCOMMENTS

DOE

UOE

DOC

UOC

OBGEARCAT3

OBGEARCAT4

GEARCATSTR

GEARCONDLIST

Catalog Details