Slide Menu
Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
Search Help Show/Hide Menu

Item Identification

Title: View: OPCATCH
Short Name: OPCATCH
Status: Completed
Abstract:

Preliminary Observer Catch Data

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 Catch Data

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
LINK3 VARCHAR2 19 character key field: PROGRAM(3) + YEAR(4) + MONTH(2) + TRIPID(6) + HAULNUM(4)
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
NESPP4 VARCHAR2 Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBDBS.OBSPEC.
100
HAILWT NUMBER The dressed or round, actual or estimated weight for each caught species.
100
FISHDISP VARCHAR2 Three digit code for disposition of each species. See OBDBS.OBFISHDISP.
100
ROUND CHAR Indicator of whether the species in the record was dressed=1, round=2, unknown=0.

Attribute Details

LINK1

CC ID: 331365
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

LINK3

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

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

General Data Type: VARCHAR2

YEAR

CC ID: 331367
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: 331368
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: 331369
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 4
Required: Yes
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

NESPP4

CC ID: 331370
Seq. Order: 6
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

HAILWT

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

The dressed or round, actual or estimated weight for each caught species.

General Data Type: NUMBER

FISHDISP

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

Three digit code for disposition of each species. See OBDBS.OBFISHDISP.

General Data Type: VARCHAR2

ROUND

CC ID: 331373
Seq. Order: 9
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indicator of whether the species in the record was dressed=1, round=2, unknown=0.

General Data Type: CHAR

Catalog Details

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