Metadata Rubric

67%

4 / 6

OPR Meta Data Library > Permits and Conservation Division (F/PR1) > Public Display of Marine Mammals > National Inventory of Marine Mammals (NIMM) >

Table: FOXPRO_ANIMAL_ACTIVITIES

Entity (ENT) | NMFS Office Of Protected Resources (OPR)
GUID: gov.noaa.nmfs.inport:26995 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Entity Type
Data Table

Data Attribute / Type	Description
ANIMAL_ACTIVITY_ID NUMBER
AA_ANIMAL_ACTIVITY_TYPE VARCHAR2
AA_ACTIVITY_DATE DATE
ANIMAL_ID NUMBER
HOLDER_ID NUMBER
FACILITY_ID NUMBER
TRANSPORT_TRANSFER_ID NUMBER
AA_TAG_NBR VARCHAR2
AA_DEATH_CAUSE VARCHAR2
AA_DEATH_CAUSE_COMMENT VARCHAR2
AA_LAT_DEGREE NUMBER
AA_LAT_MINUTE NUMBER
AA_LAT_SECOND NUMBER
AA_LON_DEGREE NUMBER
AA_LON_MINUTE NUMBER
AA_LON_SECOND NUMBER
AA_GEO_DESC VARCHAR2
AA_UNAUTHORIZED_RELEASE_FLAG VARCHAR2
AA_INSTITUTION_START_DATE DATE
AA_CUSTODY_START_DATE DATE
AA_PURPOSE VARCHAR2
AA_PERMIT_NBR VARCHAR2
AA_ANIMAL_ID_NBR VARCHAR2
AA_ANIMAL_NAME VARCHAR2
AA_COLLECTOR_NAME VARCHAR2
AA_ACQUISITION_DESC VARCHAR2
DELETED_FLAG VARCHAR2
DATE_CREATED DATE
CREATED_BY VARCHAR2
DATE_MODIFIED DATE
MODIFIED_BY VARCHAR2
AA_ACTIVITY_ORDER_NBR NUMBER

Data Attribute / Type

Description

ANIMAL_ACTIVITY_ID
NUMBER

AA_ANIMAL_ACTIVITY_TYPE
VARCHAR2

AA_ACTIVITY_DATE
DATE

ANIMAL_ID
NUMBER

HOLDER_ID
NUMBER

FACILITY_ID
NUMBER

TRANSPORT_TRANSFER_ID
NUMBER

AA_TAG_NBR
VARCHAR2

AA_DEATH_CAUSE
VARCHAR2

AA_DEATH_CAUSE_COMMENT
VARCHAR2

AA_LAT_DEGREE
NUMBER

AA_LAT_MINUTE
NUMBER

AA_LAT_SECOND
NUMBER

AA_LON_DEGREE
NUMBER

AA_LON_MINUTE
NUMBER

AA_LON_SECOND
NUMBER

AA_GEO_DESC
VARCHAR2

AA_UNAUTHORIZED_RELEASE_FLAG
VARCHAR2

AA_INSTITUTION_START_DATE
DATE

AA_CUSTODY_START_DATE
DATE

AA_PURPOSE
VARCHAR2

AA_PERMIT_NBR
VARCHAR2

AA_ANIMAL_ID_NBR
VARCHAR2

AA_ANIMAL_NAME
VARCHAR2

AA_COLLECTOR_NAME
VARCHAR2

AA_ACQUISITION_DESC
VARCHAR2

DELETED_FLAG
VARCHAR2

DATE_CREATED
DATE

CREATED_BY
VARCHAR2

DATE_MODIFIED
DATE

MODIFIED_BY
VARCHAR2

AA_ACTIVITY_ORDER_NBR
NUMBER

No Child Items for this record.

No contact information is available for this record.

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

Title:	Table: FOXPRO_ANIMAL_ACTIVITIES
Short Name:	FOXPRO_ANIMAL_ACTIVITIES
Status:	Completed
Notes:	Loaded by batch 7077, 09-17-2015 08:15

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

Attribute Summary

	Name	Type
67	ANIMAL_ACTIVITY_ID	NUMBER
67	AA_ANIMAL_ACTIVITY_TYPE	VARCHAR2
67	AA_ACTIVITY_DATE	DATE
67	ANIMAL_ID	NUMBER
67	HOLDER_ID	NUMBER
67	FACILITY_ID	NUMBER
67	TRANSPORT_TRANSFER_ID	NUMBER
67	AA_TAG_NBR	VARCHAR2
67	AA_DEATH_CAUSE	VARCHAR2
67	AA_DEATH_CAUSE_COMMENT	VARCHAR2
67	AA_LAT_DEGREE	NUMBER
67	AA_LAT_MINUTE	NUMBER
67	AA_LAT_SECOND	NUMBER
67	AA_LON_DEGREE	NUMBER
67	AA_LON_MINUTE	NUMBER
67	AA_LON_SECOND	NUMBER
67	AA_GEO_DESC	VARCHAR2
67	AA_UNAUTHORIZED_RELEASE_FLAG	VARCHAR2
67	AA_INSTITUTION_START_DATE	DATE
67	AA_CUSTODY_START_DATE	DATE
67	AA_PURPOSE	VARCHAR2
67	AA_PERMIT_NBR	VARCHAR2
67	AA_ANIMAL_ID_NBR	VARCHAR2
67	AA_ANIMAL_NAME	VARCHAR2
67	AA_COLLECTOR_NAME	VARCHAR2
67	AA_ACQUISITION_DESC	VARCHAR2
67	DELETED_FLAG	VARCHAR2
67	DATE_CREATED	DATE
67	CREATED_BY	VARCHAR2
67	DATE_MODIFIED	DATE
67	MODIFIED_BY	VARCHAR2
67	AA_ACTIVITY_ORDER_NBR	NUMBER

Name

Type

Description

ANIMAL_ACTIVITY_ID

NUMBER

AA_ANIMAL_ACTIVITY_TYPE

VARCHAR2

AA_ACTIVITY_DATE

DATE

ANIMAL_ID

NUMBER

HOLDER_ID

NUMBER

FACILITY_ID

NUMBER

TRANSPORT_TRANSFER_ID

NUMBER

AA_TAG_NBR

VARCHAR2

AA_DEATH_CAUSE

VARCHAR2

AA_DEATH_CAUSE_COMMENT

VARCHAR2

AA_LAT_DEGREE

NUMBER

AA_LAT_MINUTE

NUMBER

AA_LAT_SECOND

NUMBER

AA_LON_DEGREE

NUMBER

AA_LON_MINUTE

NUMBER

AA_LON_SECOND

NUMBER

AA_GEO_DESC

VARCHAR2

AA_UNAUTHORIZED_RELEASE_FLAG

VARCHAR2

AA_INSTITUTION_START_DATE

DATE

AA_CUSTODY_START_DATE

DATE

AA_PURPOSE

VARCHAR2

AA_PERMIT_NBR

VARCHAR2

AA_ANIMAL_ID_NBR

VARCHAR2

AA_ANIMAL_NAME

VARCHAR2

AA_COLLECTOR_NAME

VARCHAR2

AA_ACQUISITION_DESC

VARCHAR2

DELETED_FLAG

VARCHAR2

DATE_CREATED

DATE

CREATED_BY

VARCHAR2

DATE_MODIFIED

DATE

MODIFIED_BY

VARCHAR2

AA_ACTIVITY_ORDER_NBR

NUMBER

Attribute Details

ANIMAL_ACTIVITY_ID

CC ID: 219152

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
General Data Type:	NUMBER

AA_ANIMAL_ACTIVITY_TYPE

CC ID: 219163

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	9
Required:	Yes
Primary Key:	No
Status:	Active
General Data Type:	VARCHAR2

AA_ACTIVITY_DATE

CC ID: 219174

Seq. Order:	3
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
General Data Type:	DATE

ANIMAL_ID

CC ID: 219178

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

HOLDER_ID

CC ID: 219179

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

FACILITY_ID

CC ID: 219180

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

TRANSPORT_TRANSFER_ID

CC ID: 219181

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

AA_TAG_NBR

CC ID: 219182

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	250
Required:	No
Primary Key:	No
Status:	Active
General Data Type:	VARCHAR2

AA_DEATH_CAUSE

CC ID: 219183

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	65
Required:	No
Primary Key:	No
Status:	Active
General Data Type:	VARCHAR2

AA_DEATH_CAUSE_COMMENT

CC ID: 219153

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	200
Required:	No
Primary Key:	No
Status:	Active
General Data Type:	VARCHAR2

AA_LAT_DEGREE

CC ID: 219154

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

AA_LAT_MINUTE

CC ID: 219155

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

AA_LAT_SECOND

CC ID: 219156

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

AA_LON_DEGREE

CC ID: 219157

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

AA_LON_MINUTE

CC ID: 219158

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

AA_LON_SECOND

CC ID: 219159

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

AA_GEO_DESC

CC ID: 219160

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	1000
Required:	No
Primary Key:	No
Status:	Active
General Data Type:	VARCHAR2

AA_UNAUTHORIZED_RELEASE_FLAG

CC ID: 219161

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
General Data Type:	VARCHAR2

AA_INSTITUTION_START_DATE

CC ID: 219162

Seq. Order:	19
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
General Data Type:	DATE

AA_CUSTODY_START_DATE

CC ID: 219164

Seq. Order:	20
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
General Data Type:	DATE

AA_PURPOSE

CC ID: 219165

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
General Data Type:	VARCHAR2

AA_PERMIT_NBR

CC ID: 219166

Seq. Order:	22
Data Storage Type:	VARCHAR2
Max Length:	255
Required:	No
Primary Key:	No
Status:	Active
General Data Type:	VARCHAR2

AA_ANIMAL_ID_NBR

CC ID: 219167

Seq. Order:	23
Data Storage Type:	VARCHAR2
Max Length:	225
Required:	No
Primary Key:	No
Status:	Active
General Data Type:	VARCHAR2

AA_ANIMAL_NAME

CC ID: 219168

Seq. Order:	24
Data Storage Type:	VARCHAR2
Max Length:	225
Required:	No
Primary Key:	No
Status:	Active
General Data Type:	VARCHAR2

AA_COLLECTOR_NAME

CC ID: 219169

Seq. Order:	25
Data Storage Type:	VARCHAR2
Max Length:	100
Required:	No
Primary Key:	No
Status:	Active
General Data Type:	VARCHAR2

AA_ACQUISITION_DESC

CC ID: 219170

Seq. Order:	26
Data Storage Type:	VARCHAR2
Max Length:	1000
Required:	No
Primary Key:	No
Status:	Active
General Data Type:	VARCHAR2

DELETED_FLAG

CC ID: 219171

Seq. Order:	27
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
General Data Type:	VARCHAR2

DATE_CREATED

CC ID: 219172

Seq. Order:	28
Data Storage Type:	DATE
Max Length:	7
Required:	Yes
Primary Key:	No
Status:	Active
General Data Type:	DATE

CREATED_BY

CC ID: 219173

Seq. Order:	29
Data Storage Type:	VARCHAR2
Max Length:	200
Required:	Yes
Primary Key:	No
Status:	Active
General Data Type:	VARCHAR2

DATE_MODIFIED

CC ID: 219175

Seq. Order:	30
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
General Data Type:	DATE

MODIFIED_BY

CC ID: 219176

Seq. Order:	31
Data Storage Type:	VARCHAR2
Max Length:	200
Required:	No
Primary Key:	No
Status:	Active
General Data Type:	VARCHAR2

AA_ACTIVITY_ORDER_NBR

CC ID: 219177

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

Catalog Item ID:	26995
GUID:	gov.noaa.nmfs.inport:26995
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

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

ANIMAL_ACTIVITY_ID

AA_ANIMAL_ACTIVITY_TYPE

AA_ACTIVITY_DATE

ANIMAL_ID

HOLDER_ID

FACILITY_ID

TRANSPORT_TRANSFER_ID

AA_TAG_NBR

AA_DEATH_CAUSE

AA_DEATH_CAUSE_COMMENT

AA_LAT_DEGREE

AA_LAT_MINUTE

AA_LAT_SECOND

AA_LON_DEGREE

AA_LON_MINUTE

AA_LON_SECOND

AA_GEO_DESC

AA_UNAUTHORIZED_RELEASE_FLAG

AA_INSTITUTION_START_DATE

AA_CUSTODY_START_DATE

AA_PURPOSE

AA_PERMIT_NBR

AA_ANIMAL_ID_NBR

AA_ANIMAL_NAME

AA_COLLECTOR_NAME

AA_ACQUISITION_DESC

DELETED_FLAG

DATE_CREATED

CREATED_BY

DATE_MODIFIED

MODIFIED_BY

AA_ACTIVITY_ORDER_NBR

Catalog Details