View: OBCRU
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33561 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | View: OBCRU |
---|---|
Short Name: | OBCRU |
Status: | Completed |
Abstract: |
Observer Crustacean Sample Logs |
Notes: |
Loaded by batch 9053, 07-27-2016 19:10 |
Entity Information
Entity Type: | Data View |
---|---|
Active Version?: | Yes |
Schema Name: | OBDBS |
Description: |
Observer Crustacean Sample Logs |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
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
|
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
|
SEQNUM | VARCHAR2 | Sequential numbers (by haul) assigned to each animal or debris item recorded on IAL log. Collected for ASM where applicable. | |
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
|
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
|
NCRUSTCN | NUMBER | Total number of crustacean caught in haul. | |
100
|
CNTTYPE | VARCHAR2 | Indicator of whether number recorded was actual or estimated. 1 = actual 2 = estimated. | |
100
|
DISEASEPCT | NUMBER | Percentage of animals, of species sampled, that show signs of shell disease. unknown = null Not collected prior to 2001 set to null = unknown | |
100
|
CRLEN | NUMBER | Length for lobsters, width for crab, in whole millimeters. | |
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
|
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
|
EGG | VARCHAR2 | Indicator of whether eggs are visible underneath back part of abdomen of animal sampled. See OBEGGS table. | |
100
|
VNOTCH | VARCHAR2 | Indicator of whether vnotch exists on lobster being sampled.0 = unknown 1 = no 2 = yes, old 3 = yes, new | |
100
|
MOLT | VARCHAR2 | Condition of shell of lobster being sampled.0=unknown 1=soft 2=paper 3=hard 4=splitter | |
100
|
NCLAWS | NUMBER | Number of claws on lobster sampled. | |
100
|
CRUCOMMENTS | VARCHAR2 | Comments on crustacean record. Prior to 2001 only true (1), false (0) |
Attribute Details
LINK3
Seq. Order: | 1 |
---|---|
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 |
LINK1
Seq. Order: | 2 |
---|---|
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 |
SEQNUM
Seq. Order: | 3 |
---|---|
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 |
PROGRAM
Seq. Order: | 4 |
---|---|
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
Seq. Order: | 5 |
---|---|
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
Seq. Order: | 6 |
---|---|
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
Seq. Order: | 7 |
---|---|
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 |
NESPP4
Seq. Order: | 8 |
---|---|
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 |
NCRUSTCN
Seq. Order: | 9 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Total number of crustacean caught in haul. |
General Data Type: | NUMBER |
CNTTYPE
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Indicator of whether number recorded was actual or estimated. 1 = actual 2 = estimated. |
General Data Type: | VARCHAR2 |
DISEASEPCT
Seq. Order: | 11 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Percentage of animals, of species sampled, that show signs of shell disease. unknown = null Not collected prior to 2001 set to null = unknown |
General Data Type: | NUMBER |
CRLEN
Seq. Order: | 12 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Length for lobsters, width for crab, in whole millimeters. |
General Data Type: | NUMBER |
FISHDISP
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 |
SEX
Seq. Order: | 14 |
---|---|
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 |
EGG
Seq. Order: | 15 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Indicator of whether eggs are visible underneath back part of abdomen of animal sampled. See OBEGGS table. |
General Data Type: | VARCHAR2 |
VNOTCH
Seq. Order: | 16 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Indicator of whether vnotch exists on lobster being sampled.0 = unknown 1 = no 2 = yes, old 3 = yes, new |
General Data Type: | VARCHAR2 |
MOLT
Seq. Order: | 17 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Condition of shell of lobster being sampled.0=unknown 1=soft 2=paper 3=hard 4=splitter |
General Data Type: | VARCHAR2 |
NCLAWS
Seq. Order: | 18 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
Number of claws on lobster sampled. |
General Data Type: | NUMBER |
CRUCOMMENTS
Seq. Order: | 19 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 250 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Comments on crustacean record. Prior to 2001 only true (1), false (0) |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 33561 |
---|---|
GUID: | gov.noaa.nmfs.inport:33561 |
Metadata Record Created By: | Patricia L Jones |
Metadata Record Created: | 2016-07-27 19:10+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 |