Table: ATLW_MAMMAL_INTERACTION
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:9625 | Updated: August 9, 2022 | Published / External
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 |