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

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

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

	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.

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