View: ASMINC
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33271 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | View: ASMINC |
|---|---|
| Short Name: | ASMINC |
| Status: | Completed |
| Abstract: |
At Sea Monitor Incidental Takes |
| Notes: |
Loaded by batch 8948, 07-06-2016 08:22 |
Entity Information
| Entity Type: | Data View |
|---|---|
| Active Version?: | Yes |
| Schema Name: | OBDBS |
| Description: |
At Sea Monitor Incidental Takes |
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
|
LINK3 | VARCHAR2 | Key field linking tables at the haul level; made up of: link1 plus (4-character) haulnum. 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
|
LINK6 | VARCHAR2 | Key field linking marine mammal and turtle biological sample tables (OBBMM, OBBTU) to the incidental take (OBINC) Collected for ASM where applicable.; link6 is made up of: link1 + PSID. | |
|
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
|
HAULNUM | VARCHAR2 | Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable. | |
|
100
|
PSID | VARCHAR2 | Consecutive identification number assigned each animal incidentally taken on board. Collected for ASM where applicable. | |
|
100
|
GEARNUM | VARCHAR2 | Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable. | |
|
100
|
NETNUM | VARCHAR2 | Net number along string in which animal was taken. If taken in scallop gear: P(port) S(starboard) U(unknown), A(aft). Not recorded prior to 5/1994; set to unknown. | |
|
100
|
TIMEBRUP | VARCHAR2 | Local time using 24 hour clock when animal was brought onboard or alongside vessel. | |
|
100
|
ACTMMDCOND | VARCHAR2 | Condition of active deterrent device following an incidental take: 0 = unknown, 1 = No pingers used on gear, 2 = audible, 3 = inaudible, tested and working, 4 = inaudible tested and not working, 5 = inaudible, not tested, 6 = absent (lost), 9 = other, described in COMMENTS. Not collected prior to 2001; all set to unknown. | |
|
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
|
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
|
TAGNUM3 | VARCHAR2 | Complete alpha-numeric number(s) of third tag on animal. | |
|
100
|
TAGCODE3 | VARCHAR2 | One digit code indicates origin of the third 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) | |
|
100
|
TAGNUM4 | VARCHAR2 | Complete alpha-numeric number(s) of fourth tag on animal. | |
|
100
|
TAGCODE4 | VARCHAR2 | One digit code indicates origin of the fourth tag on 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). | |
|
100
|
ENTANGLE | VARCHAR2 | Initial entanglement situation of the animal. See table OBENTANGLE. Not recorded prior to 5/1994; set to unknown; Collected for ASM where applicable. | |
|
100
|
ANMLCOND | VARCHAR2 | Condition of animal when released or sighted. See OBANMLCOND table. Collected for ASM where applicable. | |
|
100
|
ANMLONBD | VARCHAR2 | Indicator of whether animal was brought on board vessel. 0 = no, 1 = yes, 9 = unknown. | |
|
100
|
PHOTO | VARCHAR2 | Indicator of whether photograph(s) were taken of animal. 1 = yes 0 = no, 0= unknown. Collected for ASM where applicable. | |
|
100
|
SAMPLED | VARCHAR2 | Indicator of whether animal is recorded on Marine Mammal or Sea Turtle Biological Sample log. Renamed from SAMPLOG with OBDBS Version 10 changes. | |
|
100
|
ESTLEN | NUMBER | Estimated total length of animal, in whole centimeters. | |
|
100
|
INCCOMMENTS | VARCHAR2 | Comments on incidental take record. Prior to 2001 only true (1), false (0). Collected for ASM where applicable. | |
|
100
|
ASMTEST_STATUS | VARCHAR2 | Test / Load status for At Sea Monitoring trip. PRELIM = preliminary testing, BASE = fully tested |
Attribute Details
PROGRAM
| 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
| 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
| 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
| 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 |
LINK3
| Seq. Order: | 5 |
|---|---|
| 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 |
LINK4
| Seq. Order: | 6 |
|---|---|
| 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 |
LINK6
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 18 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Key field linking marine mammal and turtle biological sample tables (OBBMM, OBBTU) to the incidental take (OBINC) Collected for ASM where applicable.; link6 is made up of: link1 + PSID. |
| General Data Type: | VARCHAR2 |
LINK1
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| 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. Collected for ASM where applicable. |
| General Data Type: | VARCHAR2 |
HAULNUM
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | Yes |
| 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 |
PSID
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Consecutive identification number assigned each animal incidentally taken on board. Collected for ASM where applicable. |
| General Data Type: | VARCHAR2 |
GEARNUM
| Seq. Order: | 11 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable. |
| General Data Type: | VARCHAR2 |
NETNUM
| Seq. Order: | 12 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Net number along string in which animal was taken. If taken in scallop gear: P(port) S(starboard) U(unknown), A(aft). Not recorded prior to 5/1994; set to unknown. |
| General Data Type: | VARCHAR2 |
TIMEBRUP
| Seq. Order: | 13 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Local time using 24 hour clock when animal was brought onboard or alongside vessel. |
| General Data Type: | VARCHAR2 |
ACTMMDCOND
| Seq. Order: | 14 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Condition of active deterrent device following an incidental take: 0 = unknown, 1 = No pingers used on gear, 2 = audible, 3 = inaudible, tested and working, 4 = inaudible tested and not working, 5 = inaudible, not tested, 6 = absent (lost), 9 = other, described in COMMENTS. Not collected prior to 2001; all set to unknown. |
| General Data Type: | VARCHAR2 |
NESPP4
| Seq. Order: | 15 |
|---|---|
| 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 OBSPEC Table. Collected for ASM where applicable. |
| General Data Type: | VARCHAR2 |
TAGNUM1
| Seq. Order: | 16 |
|---|---|
| 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
| Seq. Order: | 17 |
|---|---|
| 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
| Seq. Order: | 18 |
|---|---|
| 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
| Seq. Order: | 19 |
|---|---|
| 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 |
TAGNUM3
| Seq. Order: | 20 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Complete alpha-numeric number(s) of third tag on animal. |
| General Data Type: | VARCHAR2 |
TAGCODE3
| 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 third 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) |
| General Data Type: | VARCHAR2 |
TAGNUM4
| Seq. Order: | 22 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Complete alpha-numeric number(s) of fourth tag on animal. |
| General Data Type: | VARCHAR2 |
TAGCODE4
| 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 fourth tag on 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). |
| General Data Type: | VARCHAR2 |
ENTANGLE
| Seq. Order: | 24 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Initial entanglement situation of the animal. See table OBENTANGLE. Not recorded prior to 5/1994; set to unknown; Collected for ASM where applicable. |
| General Data Type: | VARCHAR2 |
ANMLCOND
| Seq. Order: | 25 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Condition of animal when released or sighted. See OBANMLCOND table. Collected for ASM where applicable. |
| General Data Type: | VARCHAR2 |
ANMLONBD
| Seq. Order: | 26 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicator of whether animal was brought on board vessel. 0 = no, 1 = yes, 9 = unknown. |
| General Data Type: | VARCHAR2 |
PHOTO
| Seq. Order: | 27 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | Yes |
| 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 |
SAMPLED
| Seq. Order: | 28 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicator of whether animal is recorded on Marine Mammal or Sea Turtle Biological Sample log. Renamed from SAMPLOG with OBDBS Version 10 changes. |
| General Data Type: | VARCHAR2 |
ESTLEN
| Seq. Order: | 29 |
|---|---|
| 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 |
INCCOMMENTS
| Seq. Order: | 30 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1000 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Comments on incidental take record. Prior to 2001 only true (1), false (0). Collected for ASM where applicable. |
| General Data Type: | VARCHAR2 |
ASMTEST_STATUS
| Seq. Order: | 31 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Test / Load status for At Sea Monitoring trip. PRELIM = preliminary testing, BASE = fully tested |
| General Data Type: | VARCHAR2 |
Catalog Details
| Catalog Item ID: | 33271 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:33271 |
| Metadata Record Created By: | Patricia L Jones |
| Metadata Record Created: | 2016-07-06 08:22+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 |