Search Help Show/Hide Menu
Metadata Rubric
98%
5.88 / 6
View Report
OPR Meta Data Library > Permits and Conservation Division (F/PR1) > Public Display of Marine Mammals > National Inventory of Marine Mammals (NIMM) >

Table: NIMM_ANIMAL_ACTIVITIES

Entity (ENT)  |  NMFS Office Of Protected Resources (OPR)
GUID: gov.noaa.nmfs.inport:26998  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

tracks the history of an animal's various activities involving institutions/facilities, holders, and other

Description

tracks the history of an animal's various activities involving institutions/facilities, holders, and other

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ANIMAL_ACTIVITY_ID
NUMBER 		the unique identifier of animal activity at an institution
AA_ANIMAL_ACTIVITY_TYPE
VARCHAR2 		the type of activity recorded
AA_ACTIVITY_DATE
DATE 		the date and time of the activity
ANIMAL_ID
NUMBER
HOLDER_ID
NUMBER
FACILITY_ID
NUMBER
TRANSPORT_TRANSFER_ID
NUMBER
AA_TAG_NBR
VARCHAR2 		the tag number associated with the animal's disposition
AA_DEATH_CAUSE
VARCHAR2 		the cause of death of the animal
AA_DEATH_CAUSE_COMMENT
VARCHAR2 		comments regarding the death
AA_LAT_DEGREE
NUMBER 		the degrees latitude of the release or capture
AA_LAT_MINUTE
NUMBER 		the minutes latitude of the release or capture
AA_LAT_SECOND
NUMBER 		the seconds latitude of the release or capture
AA_LON_DEGREE
NUMBER 		the degrees longitude of the release or capture
AA_LON_MINUTE
NUMBER 		the minutes longitude of the release or capture
AA_LON_SECOND
NUMBER 		the seconds longitude of the release or capture
AA_GEO_DESC
VARCHAR2 		a description of the geographic location of the release or capture
AA_UNAUTHORIZED_RELEASE_FLAG
VARCHAR2 		indicates whether or not the release was authorized, ie, an escape
AA_INSTITUTION_START_DATE
DATE 		the date on which the animal began its stay at the identified institution
AA_CUSTODY_START_DATE
DATE 		the date on which holdership of the animal began
AA_PURPOSE
VARCHAR2 		the purpose of this animal
AA_PERMIT_NBR
VARCHAR2 		the permit number associated with this animal
AA_ANIMAL_ID_NBR
VARCHAR2 		the institution's internal identifier for this animal
AA_ANIMAL_NAME
VARCHAR2 		the common or popular name for this animal, usually institution-specific
AA_COLLECTOR_NAME
VARCHAR2 		the name of the collector involved in the capture
AA_ACQUISITION_DESC
VARCHAR2 		a description of the animal's acquisition, if not otherwise categorized
DELETED_FLAG
VARCHAR2 		indicates whether or not this record has been logically deleted
DATE_CREATED
DATE 		the date this record was inserted
CREATED_BY
VARCHAR2 		the user who inserted this record
DATE_MODIFIED
DATE 		the date of the most recent modification to this record
MODIFIED_BY
VARCHAR2 		the last user who modified this record
AA_ACTIVITY_ORDER_NBR
NUMBER 		the display order number of this activity, needed because not all activities will have dates

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (OPR) for inquiries on this record.

Item Identification

Title: Table: NIMM_ANIMAL_ACTIVITIES
Short Name: NIMM_ANIMAL_ACTIVITIES
Status: Completed
Abstract:

tracks the history of an animal's various activities involving institutions/facilities, holders, and other
Notes:

Loaded by batch 7077, 09-17-2015 08:15

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NIMM_APPS
Description:

tracks the history of an animal's various activities involving institutions/facilities, holders, and other

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key ANIMAL_ACTIVITY_ID NUMBER the unique identifier of animal activity at an institution
100
 AA_ANIMAL_ACTIVITY_TYPE VARCHAR2 the type of activity recorded
100
 AA_ACTIVITY_DATE DATE the date and time of the activity
67
 ANIMAL_ID NUMBER
67
 HOLDER_ID NUMBER
67
 FACILITY_ID NUMBER
67
 TRANSPORT_TRANSFER_ID NUMBER
100
 AA_TAG_NBR VARCHAR2 the tag number associated with the animal's disposition
100
 AA_DEATH_CAUSE VARCHAR2 the cause of death of the animal
100
 AA_DEATH_CAUSE_COMMENT VARCHAR2 comments regarding the death
100
 AA_LAT_DEGREE NUMBER the degrees latitude of the release or capture
100
 AA_LAT_MINUTE NUMBER the minutes latitude of the release or capture
100
 AA_LAT_SECOND NUMBER the seconds latitude of the release or capture
100
 AA_LON_DEGREE NUMBER the degrees longitude of the release or capture
100
 AA_LON_MINUTE NUMBER the minutes longitude of the release or capture
100
 AA_LON_SECOND NUMBER the seconds longitude of the release or capture
100
 AA_GEO_DESC VARCHAR2 a description of the geographic location of the release or capture
100
 AA_UNAUTHORIZED_RELEASE_FLAG VARCHAR2 indicates whether or not the release was authorized, ie, an escape
100
 AA_INSTITUTION_START_DATE DATE the date on which the animal began its stay at the identified institution
100
 AA_CUSTODY_START_DATE DATE the date on which holdership of the animal began
100
 AA_PURPOSE VARCHAR2 the purpose of this animal
100
 AA_PERMIT_NBR VARCHAR2 the permit number associated with this animal
100
 AA_ANIMAL_ID_NBR VARCHAR2 the institution's internal identifier for this animal
100
 AA_ANIMAL_NAME VARCHAR2 the common or popular name for this animal, usually institution-specific
100
 AA_COLLECTOR_NAME VARCHAR2 the name of the collector involved in the capture
100
 AA_ACQUISITION_DESC VARCHAR2 a description of the animal's acquisition, if not otherwise categorized
100
 DELETED_FLAG VARCHAR2 indicates whether or not this record has been logically deleted
100
 DATE_CREATED DATE the date this record was inserted
100
 CREATED_BY VARCHAR2 the user who inserted this record
100
 DATE_MODIFIED DATE the date of the most recent modification to this record
100
 MODIFIED_BY VARCHAR2 the last user who modified this record
100
 AA_ACTIVITY_ORDER_NBR NUMBER the display order number of this activity, needed because not all activities will have dates

Attribute Details

ANIMAL_ACTIVITY_ID

CC ID: 219223
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 10
Scale: 0
Status: Active
Description:

the unique identifier of animal activity at an institution
General Data Type: NUMBER

AA_ANIMAL_ACTIVITY_TYPE

CC ID: 219234
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 9
Required: Yes
Primary Key: No
Status: Active
Description:

the type of activity recorded
General Data Type: VARCHAR2

AA_ACTIVITY_DATE

CC ID: 219245
Seq. Order: 3
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

the date and time of the activity
General Data Type: DATE

ANIMAL_ID

CC ID: 219219
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 10
Scale: 0
Status: Active
General Data Type: NUMBER
Foreign Key Relations:

NIMM_APPS.NIMM_ANIMALS

HOLDER_ID

CC ID: 219220
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
General Data Type: NUMBER
Foreign Key Relations:

NIMM_APPS.NIMM_INSTITUTIONS

FACILITY_ID

CC ID: 219221
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
General Data Type: NUMBER
Foreign Key Relations:

NIMM_APPS.NIMM_INSTITUTIONS

TRANSPORT_TRANSFER_ID

CC ID: 219222
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
General Data Type: NUMBER
Foreign Key Relations:

NIMM_APPS.NIMM_TRANSPORT_TRANS

AA_TAG_NBR

CC ID: 219249
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 250
Required: No
Primary Key: No
Status: Active
Description:

the tag number associated with the animal's disposition
General Data Type: VARCHAR2

AA_DEATH_CAUSE

CC ID: 219250
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 65
Required: No
Primary Key: No
Status: Active
Description:

the cause of death of the animal
General Data Type: VARCHAR2

AA_DEATH_CAUSE_COMMENT

CC ID: 219224
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 200
Required: No
Primary Key: No
Status: Active
Description:

comments regarding the death
General Data Type: VARCHAR2

AA_LAT_DEGREE

CC ID: 219225
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

the degrees latitude of the release or capture
General Data Type: NUMBER

AA_LAT_MINUTE

CC ID: 219226
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Scale: 0
Status: Active
Description:

the minutes latitude of the release or capture
General Data Type: NUMBER

AA_LAT_SECOND

CC ID: 219227
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

the seconds latitude of the release or capture
General Data Type: NUMBER

AA_LON_DEGREE

CC ID: 219228
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Scale: 0
Status: Active
Description:

the degrees longitude of the release or capture
General Data Type: NUMBER

AA_LON_MINUTE

CC ID: 219229
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

the minutes longitude of the release or capture
General Data Type: NUMBER

AA_LON_SECOND

CC ID: 219230
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Scale: 0
Status: Active
Description:

the seconds longitude of the release or capture
General Data Type: NUMBER

AA_GEO_DESC

CC ID: 219231
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 1000
Required: No
Primary Key: No
Status: Active
Description:

a description of the geographic location of the release or capture
General Data Type: VARCHAR2

AA_UNAUTHORIZED_RELEASE_FLAG

CC ID: 219232
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

indicates whether or not the release was authorized, ie, an escape
General Data Type: VARCHAR2

AA_INSTITUTION_START_DATE

CC ID: 219233
Seq. Order: 19
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

the date on which the animal began its stay at the identified institution
General Data Type: DATE

AA_CUSTODY_START_DATE

CC ID: 219235
Seq. Order: 20
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

the date on which holdership of the animal began
General Data Type: DATE

AA_PURPOSE

CC ID: 219236
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

the purpose of this animal
General Data Type: VARCHAR2

AA_PERMIT_NBR

CC ID: 219237
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

the permit number associated with this animal
General Data Type: VARCHAR2

AA_ANIMAL_ID_NBR

CC ID: 219238
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 225
Required: No
Primary Key: No
Status: Active
Description:

the institution's internal identifier for this animal
General Data Type: VARCHAR2

AA_ANIMAL_NAME

CC ID: 219239
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 225
Required: No
Primary Key: No
Status: Active
Description:

the common or popular name for this animal, usually institution-specific
General Data Type: VARCHAR2

AA_COLLECTOR_NAME

CC ID: 219240
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

the name of the collector involved in the capture
General Data Type: VARCHAR2

AA_ACQUISITION_DESC

CC ID: 219241
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 1000
Required: No
Primary Key: No
Status: Active
Description:

a description of the animal's acquisition, if not otherwise categorized
General Data Type: VARCHAR2

DELETED_FLAG

CC ID: 219242
Seq. Order: 27
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

indicates whether or not this record has been logically deleted
General Data Type: VARCHAR2

DATE_CREATED

CC ID: 219243
Seq. Order: 28
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

the date this record was inserted
General Data Type: DATE

CREATED_BY

CC ID: 219244
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 200
Required: Yes
Primary Key: No
Status: Active
Description:

the user who inserted this record
General Data Type: VARCHAR2

DATE_MODIFIED

CC ID: 219246
Seq. Order: 30
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

the date of the most recent modification to this record
General Data Type: DATE

MODIFIED_BY

CC ID: 219247
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 200
Required: No
Primary Key: No
Status: Active
Description:

the last user who modified this record
General Data Type: VARCHAR2

AA_ACTIVITY_ORDER_NBR

CC ID: 219248
Seq. Order: 32
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

the display order number of this activity, needed because not all activities will have dates
General Data Type: NUMBER

Catalog Details

Catalog Item ID: 26998
GUID: gov.noaa.nmfs.inport:26998
Metadata Record Created By: Nathan Wilson
Metadata Record Created: 2015-09-17 08:15+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-05-16
Owner Org: OPR
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-05-16
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-05-16