Table: ATL_MAMMAL_INTERACTION_H
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:9730 | 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 offload, haul, or the trip level.
DescriptionThis entity records marine mammal interactions that could occur at the haul level or the trip level.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
SEQ_NUMBER
NUMBER |
Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, increment by 1 and do not cycle. |
CHANGED_BY
VARCHAR2 |
Oracle user who made a change to the transaction table record. |
DATE_CHANGED
DATE |
Timestamp of change to transaction record. |
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 mammal 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_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. |
CONDITION_CODE
NUMBER |
FK from the LOV_Condition_Table. Numeric code identifying the injury |
INTERACTION_DATE
DATE |
Date the mammal interaction was observed. If an interaction record is related to an offload or a haul this date is inferred as the haul date or offload end date. If the interaction is related to a trip the interaction date is mandatory. |
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 occurred. |
LATITUDE_MINUTES
NUMBER |
Latitude at which the interaction with a mammal occurred. |
LATITUDE_SECONDS
NUMBER |
Latitude at which the interaction with a mammal occurred. |
LONGITUDE_DEGREES
NUMBER |
Longitude at which the interaction with a mammal occurred. |
LONGITUDE_MINUTES
NUMBER |
Longitude at which the interaction with a mammal occurred. |
LONGITUDE_SECONDS
NUMBER |
Longitude at which the interaction with a mammal occurred. |
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: ATL_MAMMAL_INTERACTION_H |
---|---|
Short Name: | ATL_MAMMAL_INTERACTION_H |
Status: | Completed |
Abstract: |
This entity records marine mammal interactions that coud occur at the offload, haul, or the trip level. |
Purpose: |
Histories of all changes to data are maintained by trigger code on the parent table; allowing change control by user and datetime for all updates and delete events. |
Notes: |
Loaded by batch 2390, 06-30-2009 16:11 |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
UNCONTROLLED | |
None | AFSC |
None | ATL |
None | ATLAS |
None | BYCATCH |
None | FMA |
None | GROUNDFISH |
None | MARINE MAMMAL |
None | NORPAC |
None | OBSERVER |
None | SAMPLING |
Spatial Keywords
Thesaurus | Keyword |
---|---|
UNCONTROLLED | |
None | AI |
None | ALEUTIAN ISLANDS |
None | BERING SEA |
None | BS |
None | BSAI |
None | GOA |
None | GULF OF ALASKA |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | NORPAC |
Description: |
This entity records marine mammal interactions that could occur at the haul level or the trip level. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
SEQ_NUMBER | NUMBER | Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, increment by 1 and do not cycle. | |
100
|
CHANGED_BY | VARCHAR2 | Oracle user who made a change to the transaction table record. | |
100
|
DATE_CHANGED | DATE | Timestamp of change to transaction record. | |
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 mammal 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_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
|
CONDITION_CODE | NUMBER | FK from the LOV_Condition_Table. Numeric code identifying the injury | |
100
|
INTERACTION_DATE | DATE | Date the mammal interaction was observed. If an interaction record is related to an offload or a haul this date is inferred as the haul date or offload end date. If the interaction is related to a trip the interaction date is mandatory. | |
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 occurred. | |
100
|
LATITUDE_MINUTES | NUMBER | Latitude at which the interaction with a mammal occurred. | |
100
|
LATITUDE_SECONDS | NUMBER | Latitude at which the interaction with a mammal occurred. | |
100
|
LONGITUDE_DEGREES | NUMBER | Longitude at which the interaction with a mammal occurred. | |
100
|
LONGITUDE_MINUTES | NUMBER | Longitude at which the interaction with a mammal occurred. | |
100
|
LONGITUDE_SECONDS | NUMBER | Longitude at which the interaction with a mammal occurred. | |
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
SEQ_NUMBER
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, increment by 1 and do not cycle. |
General Data Type: | NUMBER |
CHANGED_BY
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Oracle user who made a change to the transaction table record. |
General Data Type: | VARCHAR2 |
DATE_CHANGED
Seq. Order: | 3 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Timestamp of change to transaction record. |
General Data Type: | DATE |
CRUISE
Seq. Order: | 4 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
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: | 5 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence within Mammal Parent record |
General Data Type: | NUMBER |
MAMMAL_SEQ
Seq. Order: | 6 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence generated unique identifier for a mammal record |
General Data Type: | NUMBER |
SPECIES_CODE
Seq. Order: | 7 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
Scale: | 0 |
Status: | Active |
Description: |
Unique identifier for a mammal species imported from Norpac |
General Data Type: | NUMBER |
DETERRENCE_ANIMAL_TYPE
Seq. Order: | 8 |
---|---|
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: | 9 |
---|---|
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: | 10 |
---|---|
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: | 11 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
Scale: | 0 |
Status: | Active |
Description: |
Numeric code uniquely identifying a mammal interaction. The value is suppllied at data load from Norpac |
General Data Type: | NUMBER |
CONDITION_ANIMAL_TYPE
Seq. Order: | 12 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
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 |
CONDITION_CODE
Seq. Order: | 13 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
Scale: | 0 |
Status: | Active |
Description: |
FK from the LOV_Condition_Table. Numeric code identifying the injury |
General Data Type: | NUMBER |
INTERACTION_DATE
Seq. Order: | 14 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date the mammal interaction was observed. If an interaction record is related to an offload or a haul this date is inferred as the haul date or offload end date. If the interaction is related to a trip the interaction date is mandatory. |
General Data Type: | DATE |
OBSERVATION_FLAG
Seq. Order: | 15 |
---|---|
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: | 16 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
Scale: | 0 |
Status: | Active |
Description: |
Number of animals involved with this interaction |
General Data Type: | NUMBER |
LATITUDE_DEGREES
Seq. Order: | 17 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
Scale: | 0 |
Status: | Active |
Description: |
Latitude at which the interaction with a mammal occurred. |
General Data Type: | NUMBER |
LATITUDE_MINUTES
Seq. Order: | 18 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
Scale: | 0 |
Status: | Active |
Description: |
Latitude at which the interaction with a mammal occurred. |
General Data Type: | NUMBER |
LATITUDE_SECONDS
Seq. Order: | 19 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
Scale: | 0 |
Status: | Active |
Description: |
Latitude at which the interaction with a mammal occurred. |
General Data Type: | NUMBER |
LONGITUDE_DEGREES
Seq. Order: | 20 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
Scale: | 0 |
Status: | Active |
Description: |
Longitude at which the interaction with a mammal occurred. |
General Data Type: | NUMBER |
LONGITUDE_MINUTES
Seq. Order: | 21 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
Scale: | 0 |
Status: | Active |
Description: |
Longitude at which the interaction with a mammal occurred. |
General Data Type: | NUMBER |
LONGITUDE_SECONDS
Seq. Order: | 22 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
Scale: | 0 |
Status: | Active |
Description: |
Longitude at which the interaction with a mammal occurred. |
General Data Type: | NUMBER |
LONGITUDE_EW
Seq. Order: | 23 |
---|---|
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: | 24 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4000 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Observer entered comments regarding this interaction. |
General Data Type: | VARCHAR2 |
PERMIT
Seq. Order: | 25 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
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: | 9730 |
---|---|
GUID: | gov.noaa.nmfs.inport:9730 |
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 |