Table: ATLW_MAMMAL_INTERACTION
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:9625 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
This entity records marine mammal interactions that coud occur at the haul, offload or the trip level.
DescriptionThis entity records marine mammal interactions that coud occur at the haul level or the trip level.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
RECORD_SET_STATUS_SEQ
NUMBER |
Sequence generated unique identifier of a record set header |
CRUISE
NUMBER |
Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. |
INTERACTION_SEQ
NUMBER |
Sequence within Mammal Parent record |
MAMMAL_SEQ
NUMBER |
Sequence generated unique identifier for a mammal record |
SPECIES_CODE
NUMBER |
Unique identifier for a species imported from Norpac |
DETERRENCE_ANIMAL_TYPE
VARCHAR2 |
Optional FK from LOV_Deterrence. Class of animal mammal (M), bird (B) for which the deterrence (if it exists) was utilized |
DETERRENCE_CODE
VARCHAR2 |
Optional FK from LOV_Deterrence combined with deterrence_animal type. Deterrence codes are from NORPAC bird or mammal deterance tables. |
DETERRENCE_SUCCESS_FLAG
VARCHAR2 |
Identifies whether or not the deterence measures applied were successful |
MAMMAL_INTERACT_CODE
NUMBER |
Numeric code uniquely identifying a mammal interaction. The value is suppllied at data load from Norpac |
CONDITION_CODE
NUMBER |
FK from the LOV_Condition_Table. Numeric code identifying the injury |
CONDITION_ANIMAL_TYPE
VARCHAR2 |
FK from the LOV_Condition_Table. Refers the the class of animal for example M - mammal H-halibut. Enforced by the Domain Animal Type. |
INTERACTION_DATE
DATE |
Date the mammal interaction was observed. |
OBSERVATION_FLAG
VARCHAR2 |
Did the observer physically witness the interaction. |
NUMBER_OF_ANIMALS
NUMBER |
Number of animals involved with this interaction |
LATITUDE_DEGREES
NUMBER |
Latitude at which the interaction with a mammal occured. |
LATITUDE_MINUTES
NUMBER |
Latitude at which the interaction with a mammal occured. |
LATITUDE_SECONDS
NUMBER |
Latitude at which the interaction with a mammal occured. |
LONGITUDE_DEGREES
NUMBER |
Longitude at which the interaction with a mammal occured. |
LONGITUDE_MINUTES
NUMBER |
Longitude at which the interaction with a mammal occured. |
LONGITUDE_SECONDS
NUMBER |
Longitude at which the interaction with a mammal occured. |
LONGITUDE_EW
VARCHAR2 |
Identifies the logitude as E(ast) or W(est) |
COMMENTS
VARCHAR2 |
Observer entered comments regarding this interaction. |
PERMIT
VARCHAR2 |
Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (AFSC) for inquiries on this record.
Item Identification
Title: | Table: ATLW_MAMMAL_INTERACTION |
---|---|
Short Name: | ATLW_MAMMAL_INTERACTION |
Status: | Completed |
Abstract: |
This entity records marine mammal interactions that coud occur at the haul, offload or the trip level. |
Purpose: |
Working Tables accept the raw data from field transmissions or data entry. They are unconstrained, Relational integrity data validation is performed when data are loaded into NORPAC transaction tables. Error checking is performed by batch processes on production data. |
Notes: |
Loaded by batch 2390, 06-30-2009 16:11 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | NORPAC |
Description: |
This entity records marine mammal interactions that coud occur at the haul level or the trip level. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
RECORD_SET_STATUS_SEQ | NUMBER | Sequence generated unique identifier of a record set header | |
100
|
CRUISE | NUMBER | Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. | |
100
|
INTERACTION_SEQ | NUMBER | Sequence within Mammal Parent record | |
100
|
MAMMAL_SEQ | NUMBER | Sequence generated unique identifier for a mammal record | |
100
|
SPECIES_CODE | NUMBER | Unique identifier for a species imported from Norpac | |
100
|
DETERRENCE_ANIMAL_TYPE | VARCHAR2 | Optional FK from LOV_Deterrence. Class of animal mammal (M), bird (B) for which the deterrence (if it exists) was utilized | |
100
|
DETERRENCE_CODE | VARCHAR2 | Optional FK from LOV_Deterrence combined with deterrence_animal type. Deterrence codes are from NORPAC bird or mammal deterance tables. | |
100
|
DETERRENCE_SUCCESS_FLAG | VARCHAR2 | Identifies whether or not the deterence measures applied were successful | |
100
|
MAMMAL_INTERACT_CODE | NUMBER | Numeric code uniquely identifying a mammal interaction. The value is suppllied at data load from Norpac | |
100
|
CONDITION_CODE | NUMBER | FK from the LOV_Condition_Table. Numeric code identifying the injury | |
100
|
CONDITION_ANIMAL_TYPE | VARCHAR2 | FK from the LOV_Condition_Table. Refers the the class of animal for example M - mammal H-halibut. Enforced by the Domain Animal Type. | |
100
|
INTERACTION_DATE | DATE | Date the mammal interaction was observed. | |
100
|
OBSERVATION_FLAG | VARCHAR2 | Did the observer physically witness the interaction. | |
100
|
NUMBER_OF_ANIMALS | NUMBER | Number of animals involved with this interaction | |
100
|
LATITUDE_DEGREES | NUMBER | Latitude at which the interaction with a mammal occured. | |
100
|
LATITUDE_MINUTES | NUMBER | Latitude at which the interaction with a mammal occured. | |
100
|
LATITUDE_SECONDS | NUMBER | Latitude at which the interaction with a mammal occured. | |
100
|
LONGITUDE_DEGREES | NUMBER | Longitude at which the interaction with a mammal occured. | |
100
|
LONGITUDE_MINUTES | NUMBER | Longitude at which the interaction with a mammal occured. | |
100
|
LONGITUDE_SECONDS | NUMBER | Longitude at which the interaction with a mammal occured. | |
100
|
LONGITUDE_EW | VARCHAR2 | Identifies the logitude as E(ast) or W(est) | |
100
|
COMMENTS | VARCHAR2 | Observer entered comments regarding this interaction. | |
100
|
PERMIT | VARCHAR2 | Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau |
Attribute Details
RECORD_SET_STATUS_SEQ
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence generated unique identifier of a record set header |
General Data Type: | NUMBER |
CRUISE
Seq. Order: | 2 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 8 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. |
General Data Type: | NUMBER |
INTERACTION_SEQ
Seq. Order: | 3 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence within Mammal Parent record |
General Data Type: | NUMBER |
MAMMAL_SEQ
Seq. Order: | 4 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence generated unique identifier for a mammal record |
General Data Type: | NUMBER |
SPECIES_CODE
Seq. Order: | 5 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Unique identifier for a species imported from Norpac |
General Data Type: | NUMBER |
DETERRENCE_ANIMAL_TYPE
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Optional FK from LOV_Deterrence. Class of animal mammal (M), bird (B) for which the deterrence (if it exists) was utilized |
General Data Type: | VARCHAR2 |
DETERRENCE_CODE
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Optional FK from LOV_Deterrence combined with deterrence_animal type. Deterrence codes are from NORPAC bird or mammal deterance tables. |
General Data Type: | VARCHAR2 |
DETERRENCE_SUCCESS_FLAG
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Identifies whether or not the deterence measures applied were successful |
General Data Type: | VARCHAR2 |
MAMMAL_INTERACT_CODE
Seq. Order: | 9 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Numeric code uniquely identifying a mammal interaction. The value is suppllied at data load from Norpac |
General Data Type: | NUMBER |
CONDITION_CODE
Seq. Order: | 10 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
FK from the LOV_Condition_Table. Numeric code identifying the injury |
General Data Type: | NUMBER |
CONDITION_ANIMAL_TYPE
Seq. Order: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
FK from the LOV_Condition_Table. Refers the the class of animal for example M - mammal H-halibut. Enforced by the Domain Animal Type. |
General Data Type: | VARCHAR2 |
INTERACTION_DATE
Seq. Order: | 12 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date the mammal interaction was observed. |
General Data Type: | DATE |
OBSERVATION_FLAG
Seq. Order: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Did the observer physically witness the interaction. |
General Data Type: | VARCHAR2 |
NUMBER_OF_ANIMALS
Seq. Order: | 14 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Number of animals involved with this interaction |
General Data Type: | NUMBER |
LATITUDE_DEGREES
Seq. Order: | 15 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Latitude at which the interaction with a mammal occured. |
General Data Type: | NUMBER |
LATITUDE_MINUTES
Seq. Order: | 16 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Latitude at which the interaction with a mammal occured. |
General Data Type: | NUMBER |
LATITUDE_SECONDS
Seq. Order: | 17 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Latitude at which the interaction with a mammal occured. |
General Data Type: | NUMBER |
LONGITUDE_DEGREES
Seq. Order: | 18 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Longitude at which the interaction with a mammal occured. |
General Data Type: | NUMBER |
LONGITUDE_MINUTES
Seq. Order: | 19 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Longitude at which the interaction with a mammal occured. |
General Data Type: | NUMBER |
LONGITUDE_SECONDS
Seq. Order: | 20 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Longitude at which the interaction with a mammal occured. |
General Data Type: | NUMBER |
LONGITUDE_EW
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Identifies the logitude as E(ast) or W(est) |
General Data Type: | VARCHAR2 |
COMMENTS
Seq. Order: | 22 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2500 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Observer entered comments regarding this interaction. |
General Data Type: | VARCHAR2 |
PERMIT
Seq. Order: | 23 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 9625 |
---|---|
GUID: | gov.noaa.nmfs.inport:9625 |
Metadata Record Created By: | Doug Turnbull |
Metadata Record Created: | 2009-06-30 16:11+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2018-09-26 |
Owner Org: | AFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2018-09-26 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2019-09-26 |