Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Fishery Monitoring Operations Branch (FMOB) > Observer Preliminary Database (OBPRELIM) >

View: OPINC

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

Item Identification

Title:	View: OPINC
Short Name:	OPINC
Status:	Completed
Abstract:	Preliminary Observer Incidental Takes
Notes:	Loaded by batch 8952, 07-06-2016 15:07

Entity Information

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	OBPRELIM
Description:	Preliminary Observer Incidental Takes

Data Attributes

Attribute Summary

	Name	Type	Description
100	LINK1	VARCHAR2	15 character key field: PROGRAM(3) + YEAR(4) + MONTH(2) + TRIPID(6)
100	LINK6	VARCHAR2	18 character key field: LINK1 (15) + PSID (3)
100	YEAR	VARCHAR2	Year landed. Characters 4-7 of LINK1.
100	TRIPID	VARCHAR2	6-character trip identification. First 3 characters are the observer ID number (OBSID) and the characters following are the ordinal number of trips the observer has taken for the current year.
100	HAULNUM	VARCHAR2	Ordinal number assigned to the haul or haul number associated with catch, discard event or incidental take.
100	PSID	VARCHAR2	Consecutive identification number assigned each animal incidentally taken on the trip.
100	NESPP4	VARCHAR2	Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBDBS.OBSPEC.
100	ANMLCOND	VARCHAR2	Condition of animal when released or sighted. See OBDBS.OBANMLCOND.
100	TAGNUM1	VARCHAR2	Complete alpha-numeric number(s) of first tag on animal.
100	TAGNUM2	VARCHAR2	Complete alpha-numeric number(s) of second tag on animal.
100	SAMPTAKEN	VARCHAR2	Indicator of whether a sample was taken of the incidental take. 0=No, 1=Yes.
100	SAMPTYPE	VARCHAR2	Type of sample taken from the incidental take. 01=Whole; 02=Finclip/Flipper/Skin; 03=Jaw; 04=Stomach; 05=Blubber; 06=Muscle; 07=Reproductive Tract; 08=Head/Skull; 09=Biopsy/Skin; 10=Feather(s); 98=Combination; 99=Other.
100	SAMPLOC	VARCHAR2	Location of sample. (Where the sample is stored).
100	LATHEND	VARCHAR2	Latitude location where haul ended or position information where take occurred for incidental take.
100	LONHEND	VARCHAR2	Longitude location where haul ended or position information where take occurred for incidental take.
100	PHOTO	VARCHAR2	Indicator of whether the observer took photographs or videos of the take. 0=No, 1=Yes.
100	INCCOMMENTS	VARCHAR2	Additional information regarding the incidental take.

Name

Type

Description

100

LINK1

VARCHAR2

15 character key field: PROGRAM(3) + YEAR(4) + MONTH(2) + TRIPID(6)

100

LINK6

VARCHAR2

18 character key field: LINK1 (15) + PSID (3)

100

YEAR

VARCHAR2

Year landed. Characters 4-7 of LINK1.

100

TRIPID

VARCHAR2

6-character trip identification. First 3 characters are the observer ID number (OBSID) and the characters following are the ordinal number of trips the observer has taken for the current year.

100

HAULNUM

VARCHAR2

Ordinal number assigned to the haul or haul number associated with catch, discard event or incidental take.

100

PSID

VARCHAR2

Consecutive identification number assigned each animal incidentally taken on the trip.

100

NESPP4

VARCHAR2

Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBDBS.OBSPEC.

100

ANMLCOND

VARCHAR2

Condition of animal when released or sighted. See OBDBS.OBANMLCOND.

100

TAGNUM1

VARCHAR2

Complete alpha-numeric number(s) of first tag on animal.

100

TAGNUM2

VARCHAR2

Complete alpha-numeric number(s) of second tag on animal.

100

SAMPTAKEN

VARCHAR2

Indicator of whether a sample was taken of the incidental take. 0=No, 1=Yes.

100

SAMPTYPE

VARCHAR2

Type of sample taken from the incidental take. 01=Whole; 02=Finclip/Flipper/Skin; 03=Jaw; 04=Stomach; 05=Blubber; 06=Muscle; 07=Reproductive Tract; 08=Head/Skull; 09=Biopsy/Skin; 10=Feather(s); 98=Combination; 99=Other.

100

SAMPLOC

VARCHAR2

Location of sample. (Where the sample is stored).

100

LATHEND

VARCHAR2

Latitude location where haul ended or position information where take occurred for incidental take.

100

LONHEND

VARCHAR2

Longitude location where haul ended or position information where take occurred for incidental take.

100

PHOTO

VARCHAR2

Indicator of whether the observer took photographs or videos of the take. 0=No, 1=Yes.

100

INCCOMMENTS

VARCHAR2

Additional information regarding the incidental take.

Attribute Details

LINK1

CC ID: 331392

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	15
Required:	No
Primary Key:	No
Status:	Active
Description:	15 character key field: PROGRAM(3) + YEAR(4) + MONTH(2) + TRIPID(6)
General Data Type:	VARCHAR2

LINK6

CC ID: 331401

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	18
Required:	No
Primary Key:	No
Status:	Active
Description:	18 character key field: LINK1 (15) + PSID (3)
General Data Type:	VARCHAR2

YEAR

CC ID: 331402

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Year landed. Characters 4-7 of LINK1.
General Data Type:	VARCHAR2

TRIPID

CC ID: 331403

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	Yes
Primary Key:	No
Status:	Active
Description:	6-character trip identification. First 3 characters are the observer ID number (OBSID) and the characters following are the ordinal number of trips the observer has taken for the current year.
General Data Type:	VARCHAR2

HAULNUM

CC ID: 331404

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Ordinal number assigned to the haul or haul number associated with catch, discard event or incidental take.
General Data Type:	VARCHAR2

PSID

CC ID: 331405

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Consecutive identification number assigned each animal incidentally taken on the trip.
General Data Type:	VARCHAR2

NESPP4

CC ID: 331406

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBDBS.OBSPEC.
General Data Type:	VARCHAR2

ANMLCOND

CC ID: 331407

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Condition of animal when released or sighted. See OBDBS.OBANMLCOND.
General Data Type:	VARCHAR2

TAGNUM1

CC ID: 331408

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	12
Required:	No
Primary Key:	No
Status:	Active
Description:	Complete alpha-numeric number(s) of first tag on animal.
General Data Type:	VARCHAR2

TAGNUM2

CC ID: 331393

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	12
Required:	No
Primary Key:	No
Status:	Active
Description:	Complete alpha-numeric number(s) of second tag on animal.
General Data Type:	VARCHAR2

SAMPTAKEN

CC ID: 331394

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Indicator of whether a sample was taken of the incidental take. 0=No, 1=Yes.
General Data Type:	VARCHAR2

SAMPTYPE

CC ID: 331395

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Type of sample taken from the incidental take. 01=Whole; 02=Finclip/Flipper/Skin; 03=Jaw; 04=Stomach; 05=Blubber; 06=Muscle; 07=Reproductive Tract; 08=Head/Skull; 09=Biopsy/Skin; 10=Feather(s); 98=Combination; 99=Other.
General Data Type:	VARCHAR2

SAMPLOC

CC ID: 331396

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Location of sample. (Where the sample is stored).
General Data Type:	VARCHAR2

LATHEND

CC ID: 331397

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Latitude location where haul ended or position information where take occurred for incidental take.
General Data Type:	VARCHAR2

LONHEND

CC ID: 331398

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Longitude location where haul ended or position information where take occurred for incidental take.
General Data Type:	VARCHAR2

PHOTO

CC ID: 331399

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Indicator of whether the observer took photographs or videos of the take. 0=No, 1=Yes.
General Data Type:	VARCHAR2

INCCOMMENTS

CC ID: 331400

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	1000
Required:	No
Primary Key:	No
Status:	Active
Description:	Additional information regarding the incidental take.
General Data Type:	VARCHAR2

Catalog Details

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