Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Fisheries Sampling Branch (FSB) > Observer and At Sea Monitor Database (OBDBS) >

View: OBIAL

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:33295  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Observer Individual Animal Logs from standard observer trips

Description

Observer Individual Animal Logs from standard observer trips

Entity Information

Entity Type
Data View

Data Attribute / Type Description
PROGRAM
VARCHAR2 		First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.
YEAR
VARCHAR2 		Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.
MONTH
VARCHAR2 		Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.
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.
HAULNUM
VARCHAR2 		Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable.
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.
LINK4
VARCHAR2 		Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable.
LINK3
VARCHAR2 		Key field linking tables at the haul level; made up of: link1 plus (4-character) haulnum. Collected for ASM where applicable.
SEQNUM
VARCHAR2 		Sequential numbers (by haul) assigned to each animal or debris item recorded on IAL log. Collected for ASM where applicable.
GEARNUM
VARCHAR2 		Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.
NESPP4
VARCHAR2 		Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBSPEC Table. Collected for ASM where applicable.
STATBEG
VARCHAR2 		Status of each animal caught as it comes up. 0 = unknown 1 = alive 2 = dead 3 = dead, damaged 4 = dead, head only.
FISHDISP
VARCHAR2 		Three digit code for disposition of each species (catdisp plus discreason). See OBFISHDISP table. IAL: discard reason not recorded previous to 5/1994; last two digits of fishdisp set to 00 (unknown discard reason); Collected for ASM where applicable.
CATDISP
VARCHAR2 		Code to indicate catch disposition. 0 = discarded, 1 = kept, 9 = unknown. Collected for ASM where applicable.
PROCCODE
VARCHAR2 		Processing code. See table OBPROCESSING.
STATEND
VARCHAR2 		Final status of each animal caught. 0 = unknown 1 = alive 2 = dead 3 = dead, damaged 4 = dead, head only. Collected for ASM where applicable.
ANMLWGT
NUMBER 		Dressed or round weight of animal/debris in pounds. Actual weights may be recorded to the nearest 10th of a pound. Collected for ASM where applicable.
DRFLAG
VARCHAR2 		Indicator of whether the species in the record was dressed =1 or round =2, unknown= 0; SPP: prior to 5/1994 data recorded but not entered; set to unknown. Collected for ASM where applicable.
WGTTYPE
VARCHAR2 		One digit code denoting type of weight of species. 1=actual; 2=estimated; 0=unknown. SPP: prior to 5/1994 data recorded but not entered; set to unknown. Collected for ASM where applicable.
TAGNUM1
VARCHAR2 		Complete alpha-numeric number(s) of first tag on animal. Collected for ASM where applicable.
TAGCODE1
VARCHAR2 		One digit code indicates origin of the first tag on the animal.0 = unknown 1 = tag applied by observer 2 = no tag 3 = tag already present, left on 4 = tag already present, removed 5 = carcass tagged (fish only). Collected for ASM where applicable.
TAGNUM2
VARCHAR2 		Complete alpha-numeric number(s) of second tag on animal. Collected for ASM where applicable.
TAGCODE2
VARCHAR2 		One digit code indicates origin of the second tag on the animal.0 = unknown 1 = tag applied by observer 2 = no tag 3 = tag already present, left on 4 = tag already present, removed 5 = carcass tagged (fish only). Collected for ASM where applicable.
STDLEN1
NUMBER 		Length in whole centimeters according to standards for species (see sampling manual for details). Swordfish and billfish: LJFL; Tuna, shark sturgeon other: FL; ray, terrapin TL. Collected for ASM where applicable.
STDLEN2
NUMBER 		Length in whole centimeters according to standards for species (see sampling manual for details) swordfish : ck; billfish , tuna: pfl shark : tl ray dw, terrapin nl sturgeon , other: none. Not recorded before 5/1994; set to unknown.
ESTLEN
NUMBER 		Estimated total length of animal, in whole centimeters.
SEX
VARCHAR2 		One digit code for sex of each animal whether it is brought on board or not. 0=unknown; 1=male; 2=female.
SAMPTAKN
VARCHAR2 		Indicator of whether biological sample was collected. 1 = yes, 0 = no. Not recorded previous to 2001; set to unknown = 9;
PHOTO
VARCHAR2 		Indicator of whether photograph(s) were taken of animal. 1 = yes 0 = no, 0= unknown. Collected for ASM where applicable.
ESTMETH
VARCHAR2 		Method used to estimate the catch weight of each species (including debris). See OBESTMETH table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
DSTAG
VARCHAR2 		Indicator for data storage tag. 1 = yes, 0 = no, 9 = unknown. Collected beginning with obdbs Version 10 (01/01/2011).
IALCOMMENTS
VARCHAR2 		Comments on individual animal record. Prior to 2001 only true (1), false (0). Collected for ASM where applicable.

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: OBIAL
Short Name: OBIAL
Status: Completed
Abstract:

Observer Individual Animal Logs 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 Individual Animal Logs from standard observer trips

Data Attributes

Attribute Summary

Rubric Score Primary Key? 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
 LINK4 VARCHAR2 Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. 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
 SEQNUM VARCHAR2 Sequential numbers (by haul) assigned to each animal or debris item recorded on IAL log. Collected for ASM where applicable.
100
 GEARNUM VARCHAR2 Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.
100
 NESPP4 VARCHAR2 Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBSPEC Table. Collected for ASM where applicable.
100
 STATBEG VARCHAR2 Status of each animal caught as it comes up. 0 = unknown 1 = alive 2 = dead 3 = dead, damaged 4 = dead, head only.
100
 FISHDISP VARCHAR2 Three digit code for disposition of each species (catdisp plus discreason). See OBFISHDISP table. IAL: discard reason not recorded previous to 5/1994; last two digits of fishdisp set to 00 (unknown discard reason); Collected for ASM where applicable.
100
 CATDISP VARCHAR2 Code to indicate catch disposition. 0 = discarded, 1 = kept, 9 = unknown. Collected for ASM where applicable.
100
 PROCCODE VARCHAR2 Processing code. See table OBPROCESSING.
100
 STATEND VARCHAR2 Final status of each animal caught. 0 = unknown 1 = alive 2 = dead 3 = dead, damaged 4 = dead, head only. Collected for ASM where applicable.
100
 ANMLWGT NUMBER Dressed or round weight of animal/debris in pounds. Actual weights may be recorded to the nearest 10th of a pound. Collected for ASM where applicable.
100
 DRFLAG VARCHAR2 Indicator of whether the species in the record was dressed =1 or round =2, unknown= 0; SPP: prior to 5/1994 data recorded but not entered; set to unknown. Collected for ASM where applicable.
100
 WGTTYPE VARCHAR2 One digit code denoting type of weight of species. 1=actual; 2=estimated; 0=unknown. SPP: prior to 5/1994 data recorded but not entered; set to unknown. Collected for ASM where applicable.
100
 TAGNUM1 VARCHAR2 Complete alpha-numeric number(s) of first tag on animal. Collected for ASM where applicable.
100
 TAGCODE1 VARCHAR2 One digit code indicates origin of the first tag on the animal.0 = unknown 1 = tag applied by observer 2 = no tag 3 = tag already present, left on 4 = tag already present, removed 5 = carcass tagged (fish only). Collected for ASM where applicable.
100
 TAGNUM2 VARCHAR2 Complete alpha-numeric number(s) of second tag on animal. Collected for ASM where applicable.
100
 TAGCODE2 VARCHAR2 One digit code indicates origin of the second tag on the animal.0 = unknown 1 = tag applied by observer 2 = no tag 3 = tag already present, left on 4 = tag already present, removed 5 = carcass tagged (fish only). Collected for ASM where applicable.
100
 STDLEN1 NUMBER Length in whole centimeters according to standards for species (see sampling manual for details). Swordfish and billfish: LJFL; Tuna, shark sturgeon other: FL; ray, terrapin TL. Collected for ASM where applicable.
100
 STDLEN2 NUMBER Length in whole centimeters according to standards for species (see sampling manual for details) swordfish : ck; billfish , tuna: pfl shark : tl ray dw, terrapin nl sturgeon , other: none. Not recorded before 5/1994; set to unknown.
100
 ESTLEN NUMBER Estimated total length of animal, in whole centimeters.
100
 SEX VARCHAR2 One digit code for sex of each animal whether it is brought on board or not. 0=unknown; 1=male; 2=female.
100
 SAMPTAKN VARCHAR2 Indicator of whether biological sample was collected. 1 = yes, 0 = no. Not recorded previous to 2001; set to unknown = 9;
100
 PHOTO VARCHAR2 Indicator of whether photograph(s) were taken of animal. 1 = yes 0 = no, 0= unknown. Collected for ASM where applicable.
100
 ESTMETH VARCHAR2 Method used to estimate the catch weight of each species (including debris). See OBESTMETH table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
100
 DSTAG VARCHAR2 Indicator for data storage tag. 1 = yes, 0 = no, 9 = unknown. Collected beginning with obdbs Version 10 (01/01/2011).
100
 IALCOMMENTS VARCHAR2 Comments on individual animal record. Prior to 2001 only true (1), false (0). Collected for ASM where applicable.

Attribute Details

PROGRAM

CC ID: 329756
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: 329767
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: 329778
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: 329782
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: 329783
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: 329784
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

LINK4

CC ID: 329785
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 17
Required: No
Primary Key: No
Status: Active
Description:

Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable.
General Data Type: VARCHAR2

LINK3

CC ID: 329786
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 19
Required: No
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

SEQNUM

CC ID: 329787
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Sequential numbers (by haul) assigned to each animal or debris item recorded on IAL log. Collected for ASM where applicable.
General Data Type: VARCHAR2

GEARNUM

CC ID: 329757
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.
General Data Type: VARCHAR2

NESPP4

CC ID: 329758
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBSPEC Table. Collected for ASM where applicable.
General Data Type: VARCHAR2

STATBEG

CC ID: 329759
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Status of each animal caught as it comes up. 0 = unknown 1 = alive 2 = dead 3 = dead, damaged 4 = dead, head only.
General Data Type: VARCHAR2

FISHDISP

CC ID: 329760
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Three digit code for disposition of each species (catdisp plus discreason). See OBFISHDISP table. IAL: discard reason not recorded previous to 5/1994; last two digits of fishdisp set to 00 (unknown discard reason); Collected for ASM where applicable.
General Data Type: VARCHAR2

CATDISP

CC ID: 329761
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code to indicate catch disposition. 0 = discarded, 1 = kept, 9 = unknown. Collected for ASM where applicable.
General Data Type: VARCHAR2

PROCCODE

CC ID: 329762
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Processing code. See table OBPROCESSING.
General Data Type: VARCHAR2

STATEND

CC ID: 329763
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Final status of each animal caught. 0 = unknown 1 = alive 2 = dead 3 = dead, damaged 4 = dead, head only. Collected for ASM where applicable.
General Data Type: VARCHAR2

ANMLWGT

CC ID: 329764
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 7
Scale: 1
Status: Active
Description:

Dressed or round weight of animal/debris in pounds. Actual weights may be recorded to the nearest 10th of a pound. Collected for ASM where applicable.
General Data Type: NUMBER

DRFLAG

CC ID: 329765
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indicator of whether the species in the record was dressed =1 or round =2, unknown= 0; SPP: prior to 5/1994 data recorded but not entered; set to unknown. Collected for ASM where applicable.
General Data Type: VARCHAR2

WGTTYPE

CC ID: 329766
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

One digit code denoting type of weight of species. 1=actual; 2=estimated; 0=unknown. SPP: prior to 5/1994 data recorded but not entered; set to unknown. Collected for ASM where applicable.
General Data Type: VARCHAR2

TAGNUM1

CC ID: 329768
Seq. Order: 20
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. Collected for ASM where applicable.
General Data Type: VARCHAR2

TAGCODE1

CC ID: 329769
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

One digit code indicates origin of the first tag on the animal.0 = unknown 1 = tag applied by observer 2 = no tag 3 = tag already present, left on 4 = tag already present, removed 5 = carcass tagged (fish only). Collected for ASM where applicable.
General Data Type: VARCHAR2

TAGNUM2

CC ID: 329770
Seq. Order: 22
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. Collected for ASM where applicable.
General Data Type: VARCHAR2

TAGCODE2

CC ID: 329771
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

One digit code indicates origin of the second tag on the animal.0 = unknown 1 = tag applied by observer 2 = no tag 3 = tag already present, left on 4 = tag already present, removed 5 = carcass tagged (fish only). Collected for ASM where applicable.
General Data Type: VARCHAR2

STDLEN1

CC ID: 329772
Seq. Order: 24
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Length in whole centimeters according to standards for species (see sampling manual for details). Swordfish and billfish: LJFL; Tuna, shark sturgeon other: FL; ray, terrapin TL. Collected for ASM where applicable.
General Data Type: NUMBER

STDLEN2

CC ID: 329773
Seq. Order: 25
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Length in whole centimeters according to standards for species (see sampling manual for details) swordfish : ck; billfish , tuna: pfl shark : tl ray dw, terrapin nl sturgeon , other: none. Not recorded before 5/1994; set to unknown.
General Data Type: NUMBER

ESTLEN

CC ID: 329774
Seq. Order: 26
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Estimated total length of animal, in whole centimeters.
General Data Type: NUMBER

SEX

CC ID: 329775
Seq. Order: 27
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

One digit code for sex of each animal whether it is brought on board or not. 0=unknown; 1=male; 2=female.
General Data Type: VARCHAR2

SAMPTAKN

CC ID: 329776
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indicator of whether biological sample was collected. 1 = yes, 0 = no. Not recorded previous to 2001; set to unknown = 9;
General Data Type: VARCHAR2

PHOTO

CC ID: 329777
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indicator of whether photograph(s) were taken of animal. 1 = yes 0 = no, 0= unknown. Collected for ASM where applicable.
General Data Type: VARCHAR2

ESTMETH

CC ID: 329779
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Method used to estimate the catch weight of each species (including debris). See OBESTMETH table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
General Data Type: VARCHAR2

DSTAG

CC ID: 329780
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indicator for data storage tag. 1 = yes, 0 = no, 9 = unknown. Collected beginning with obdbs Version 10 (01/01/2011).
General Data Type: VARCHAR2

IALCOMMENTS

CC ID: 329781
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 250
Required: No
Primary Key: No
Status: Active
Description:

Comments on individual animal record. Prior to 2001 only true (1), false (0). Collected for ASM where applicable.
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 33295
GUID: gov.noaa.nmfs.inport:33295
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