Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Preliminary Observer Incidental Takes

Description

Preliminary Observer Incidental Takes

Entity Information

Entity Type
Data View

Data Attribute / Type Description
LINK1
VARCHAR2
15 character key field: PROGRAM(3) + YEAR(4) + MONTH(2) + TRIPID(6)
LINK6
VARCHAR2
18 character key field: LINK1 (15) + PSID (3)
YEAR
VARCHAR2
Year landed. Characters 4-7 of LINK1.
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.
HAULNUM
VARCHAR2
Ordinal number assigned to the haul or haul number associated with catch, discard event or incidental take.
PSID
VARCHAR2
Consecutive identification number assigned each animal incidentally taken on the trip.
NESPP4
VARCHAR2
Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBDBS.OBSPEC.
ANMLCOND
VARCHAR2
Condition of animal when released or sighted. See OBDBS.OBANMLCOND.
TAGNUM1
VARCHAR2
Complete alpha-numeric number(s) of first tag on animal.
TAGNUM2
VARCHAR2
Complete alpha-numeric number(s) of second tag on animal.
SAMPTAKEN
VARCHAR2
Indicator of whether a sample was taken of the incidental take. 0=No, 1=Yes.
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.
SAMPLOC
VARCHAR2
Location of sample. (Where the sample is stored).
LATHEND
VARCHAR2
Latitude location where haul ended or position information where take occurred for incidental take.
LONHEND
VARCHAR2
Longitude location where haul ended or position information where take occurred for incidental take.
PHOTO
VARCHAR2
Indicator of whether the observer took photographs or videos of the take. 0=No, 1=Yes.
INCCOMMENTS
VARCHAR2
Additional information regarding the incidental take.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

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

Rubric Score Primary Key? 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