Metadata Rubric

100%

6 / 6

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

View: OBTRQ

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

Item Identification

Title:	View: OBTRQ
Short Name:	OBTRQ
Status:	Completed
Abstract:	Observer Trip-Equipment Data from standard observer trips
Notes:	Loaded by batch 8949, 07-06-2016 08:23

Entity Information

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	OBDBS
Description:	Observer Trip-Equipment Data from standard observer trips

Data Attributes

Attribute Summary

	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	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	EQUIPCOD	VARCHAR2	Code for type of equipment. See OBEQUIP table.
100	EQUIPCNT	NUMBER	Number of units for equipment of equipcod category item on vessel.
100	TRQCOMMENTS	VARCHAR2	Additional information regarding trip equipment. Prior to 2001 only true or false.

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

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

EQUIPCOD

VARCHAR2

Code for type of equipment. See OBEQUIP table.

100

EQUIPCNT

NUMBER

Number of units for equipment of equipcod category item on vessel.

100

TRQCOMMENTS

VARCHAR2

Additional information regarding trip equipment. Prior to 2001 only true or false.

Attribute Details

PROGRAM

CC ID: 330776

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: 330777

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: 330778

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: 330779

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

LINK1

CC ID: 330780

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	15
Required:	Yes
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

EQUIPCOD

CC ID: 330781

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Code for type of equipment. See OBEQUIP table.
General Data Type:	VARCHAR2

EQUIPCNT

CC ID: 330782

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Number of units for equipment of equipcod category item on vessel.
General Data Type:	NUMBER

TRQCOMMENTS

CC ID: 330783

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	250
Required:	No
Primary Key:	No
Status:	Active
Description:	Additional information regarding trip equipment. Prior to 2001 only true or false.
General Data Type:	VARCHAR2

Catalog Details

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