Search Help Show/Hide Menu
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