Slide Menu
Jump to Section...
Search Help Show/Hide Menu
Metadata Rubric
67%
4 / 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: FOXPRO_ANIMAL_ACTIVITIES

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

Item Identification

Title: Table: FOXPRO_ANIMAL_ACTIVITIES
Short Name: FOXPRO_ANIMAL_ACTIVITIES
Status: Completed
Notes:

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

Entity Information

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

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
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

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 Details

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