OBIMAGES
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33427 | Updated: August 9, 2022 | Published / External
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
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
|
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 |