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

Summary

Abstract

Trip information for scanned image

Description

Trip information for scanned image

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
DOCUMENTID
NUMBER(11)
Document identifier
TRIPID
VARCHAR2(7)
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.
MONTH
VARCHAR2(2)
Month landed, the 8 - 9 characters in all link fields.
DAY
VARCHAR2(2)
Day landed.
LINK1
VARCHAR2(15)
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.
DOCTYPE
VARCHAR2(40)
Observer Log for Scanned
BARCODE
VARCHAR2(9)
Bar Code indetifier for scanned document.
DOE
DATE
Date of Entry.
UOE
VARCHAR2(10)
User of Entry.
DOC
DATE
Date of Last Change.
UOC
VARCHAR2(10)
User of Last Change.
PROGRAM
VARCHAR2(3)
First three digits of links. Code that identifies program, see OBPROGRAM table.
YEAR
VARCHAR2(4)
Year Landed; characters 4 - 7 of link1 - link6.
GEARNUM
VARCHAR2(30)
Sequential number assigned to gear number, unique by trip.
HAULNUM
VARCHAR2(4)
Ordinal number of haul within the trip.
NEGEAR
VARCHAR2(3)
Northeast gear code. See OBDBS OBGEAR table.
TRIPEXT
VARCHAR2(1)
Level of sampling of discards in the gillnet fishery, or whether or not trip aborted. See OBDBS OBTRIPEXT table.
PRIMGEAR
VARCHAR2(3)
Principal gear used on trip.
PAGENO
NUMBER(2)
Page Number.
PAGETOT
NUMBER(2)
Page Total.
PSID
VARCHAR2(3)
Not Used
TAGNUM1
VARCHAR2(12)
Not Used
IMG_DATE
DATE
Not Used
RESCANREQ
VARCHAR2(1)
Not Used
OLD_IMAGES
VARCHAR2(250)
Not Used
LOG_NOT_ENTERED
VARCHAR2(1)
Not Used

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: OBIMAGES
Short Name: OBIMAGES
Abstract:

Trip information for scanned image

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

Trip information for scanned image

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key DOCUMENTID NUMBER(11) Document identifier
100
TRIPID VARCHAR2(7) 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.
100
MONTH VARCHAR2(2) Month landed, the 8 - 9 characters in all link fields.
100
DAY VARCHAR2(2) Day landed.
100
LINK1 VARCHAR2(15) 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.
100
DOCTYPE VARCHAR2(40) Observer Log for Scanned
100
BARCODE VARCHAR2(9) Bar Code indetifier for scanned document.
100
DOE DATE Date of Entry.
100
UOE VARCHAR2(10) User of Entry.
100
DOC DATE Date of Last Change.
100
UOC VARCHAR2(10) User of Last Change.
100
PROGRAM VARCHAR2(3) First three digits of links. Code that identifies program, see OBPROGRAM table.
100
YEAR VARCHAR2(4) Year Landed; characters 4 - 7 of link1 - link6.
100
GEARNUM VARCHAR2(30) Sequential number assigned to gear number, unique by trip.
100
HAULNUM VARCHAR2(4) Ordinal number of haul within the trip.
100
NEGEAR VARCHAR2(3) Northeast gear code. See OBDBS OBGEAR table.
100
TRIPEXT VARCHAR2(1) Level of sampling of discards in the gillnet fishery, or whether or not trip aborted. See OBDBS OBTRIPEXT table.
100
PRIMGEAR VARCHAR2(3) Principal gear used on trip.
100
PAGENO NUMBER(2) Page Number.
100
PAGETOT NUMBER(2) Page Total.
100
PSID VARCHAR2(3) Not Used
100
TAGNUM1 VARCHAR2(12) Not Used
100
IMG_DATE DATE Not Used
100
RESCANREQ VARCHAR2(1) Not Used
100
OLD_IMAGES VARCHAR2(250) Not Used
100
LOG_NOT_ENTERED VARCHAR2(1) Not Used

Attribute Details

DOCUMENTID

CC ID: 331877
Seq. Order: 1
Data Storage Type: NUMBER(11)
Max Length: 11
Required: No
Primary Key: Yes
Status: Active
Description:

Document identifier

General Data Type: NUMBER(11)

TRIPID

CC ID: 331878
Seq. Order: 2
Data Storage Type: VARCHAR2(7)
Max Length: 7
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.

General Data Type: VARCHAR2(7)

MONTH

CC ID: 331879
Seq. Order: 3
Data Storage Type: VARCHAR2(2)
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Month landed, the 8 - 9 characters in all link fields.

General Data Type: VARCHAR2(2)

DAY

CC ID: 331880
Seq. Order: 4
Data Storage Type: VARCHAR2(2)
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Day landed.

General Data Type: VARCHAR2(2)

LINK1

CC ID: 331881
Seq. Order: 5
Data Storage Type: VARCHAR2(15)
Max Length: 15
Required: Yes
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.

General Data Type: VARCHAR2(15)

DOCTYPE

CC ID: 331882
Seq. Order: 6
Data Storage Type: VARCHAR2(40)
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Observer Log for Scanned

General Data Type: VARCHAR2(40)

BARCODE

CC ID: 331883
Seq. Order: 7
Data Storage Type: VARCHAR2(9)
Max Length: 9
Required: No
Primary Key: No
Status: Active
Description:

Bar Code indetifier for scanned document.

General Data Type: VARCHAR2(9)

DOE

CC ID: 331884
Seq. Order: 8
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Date of Entry.

General Data Type: DATE

UOE

CC ID: 331885
Seq. Order: 9
Data Storage Type: VARCHAR2(10)
Max Length: 10
Required: Yes
Primary Key: No
Status: Active
Description:

User of Entry.

General Data Type: VARCHAR2(10)

DOC

CC ID: 331886
Seq. Order: 10
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Date of Last Change.

General Data Type: DATE

UOC

CC ID: 331887
Seq. Order: 11
Data Storage Type: VARCHAR2(10)
Max Length: 10
Required: Yes
Primary Key: No
Status: Active
Description:

User of Last Change.

General Data Type: VARCHAR2(10)

PROGRAM

CC ID: 331888
Seq. Order: 12
Data Storage Type: VARCHAR2(3)
Max Length: 3
Required: Yes
Primary Key: No
Status: Active
Description:

First three digits of links. Code that identifies program, see OBPROGRAM table.

General Data Type: VARCHAR2(3)

YEAR

CC ID: 331889
Seq. Order: 13
Data Storage Type: VARCHAR2(4)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Year Landed; characters 4 - 7 of link1 - link6.

General Data Type: VARCHAR2(4)

GEARNUM

CC ID: 331890
Seq. Order: 14
Data Storage Type: VARCHAR2(30)
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
Description:

Sequential number assigned to gear number, unique by trip.

General Data Type: VARCHAR2(30)

HAULNUM

CC ID: 331891
Seq. Order: 15
Data Storage Type: VARCHAR2(4)
Max Length: 4
Required: Yes
Primary Key: No
Status: Active
Description:

Ordinal number of haul within the trip.

General Data Type: VARCHAR2(4)

NEGEAR

CC ID: 331892
Seq. Order: 16
Data Storage Type: VARCHAR2(3)
Max Length: 3
Required: Yes
Primary Key: No
Status: Active
Description:

Northeast gear code. See OBDBS OBGEAR table.

General Data Type: VARCHAR2(3)

TRIPEXT

CC ID: 331893
Seq. Order: 17
Data Storage Type: VARCHAR2(1)
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Level of sampling of discards in the gillnet fishery, or whether or not trip aborted. See OBDBS OBTRIPEXT table.

General Data Type: VARCHAR2(1)

PRIMGEAR

CC ID: 331894
Seq. Order: 18
Data Storage Type: VARCHAR2(3)
Max Length: 3
Required: Yes
Primary Key: No
Status: Active
Description:

Principal gear used on trip.

General Data Type: VARCHAR2(3)

PAGENO

CC ID: 331895
Seq. Order: 19
Data Storage Type: NUMBER(2)
Max Length: 2
Required: Yes
Primary Key: No
Status: Active
Description:

Page Number.

General Data Type: NUMBER(2)

PAGETOT

CC ID: 331896
Seq. Order: 20
Data Storage Type: NUMBER(2)
Max Length: 2
Required: Yes
Primary Key: No
Status: Active
Description:

Page Total.

General Data Type: NUMBER(2)

PSID

CC ID: 331897
Seq. Order: 21
Data Storage Type: VARCHAR2(3)
Max Length: 3
Required: Yes
Primary Key: No
Status: Active
Description:

Not Used

General Data Type: VARCHAR2(3)

TAGNUM1

CC ID: 331898
Seq. Order: 22
Data Storage Type: VARCHAR2(12)
Max Length: 12
Required: Yes
Primary Key: No
Status: Active
Description:

Not Used

General Data Type: VARCHAR2(12)

IMG_DATE

CC ID: 331899
Seq. Order: 23
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Not Used

General Data Type: DATE

RESCANREQ

CC ID: 331900
Seq. Order: 24
Data Storage Type: VARCHAR2(1)
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Not Used

General Data Type: VARCHAR2(1)

OLD_IMAGES

CC ID: 331901
Seq. Order: 25
Data Storage Type: VARCHAR2(250)
Max Length: 250
Required: Yes
Primary Key: No
Status: Active
Description:

Not Used

General Data Type: VARCHAR2(250)

LOG_NOT_ENTERED

CC ID: 331902
Seq. Order: 26
Data Storage Type: VARCHAR2(1)
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Not Used

General Data Type: VARCHAR2(1)

Catalog Details

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