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) >

View: NIMM_ANIMAL_DETAILS_V

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

Item Identification

Title: View: NIMM_ANIMAL_DETAILS_V
Short Name: NIMM_ANIMAL_DETAILS_V
Status: Completed
Notes:

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

Entity Information

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

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
 ANIMAL_ID NUMBER
67
 NOAA_ID VARCHAR2
67
 GENDER VARCHAR2
67
 BIRTH_DATE DATE
67
 BIRTH_DATE_CERTAINTY VARCHAR2
67
 COMMON_NAME VARCHAR2
67
 ANIMAL_ID_NBR VARCHAR2
67
 ANIMAL_NAME VARCHAR2
67
 ANIMAL_ACTIVITY_ID NUMBER
67
 ORIGIN VARCHAR2
67
 ORIGINAL_CAPTIVITY_DATE DATE
67
 ACQUISITION_PURPOSE VARCHAR2
67
 PERMIT_NO VARCHAR2
67
 HOLDER_ID NUMBER
67
 HOLDER VARCHAR2
67
 CUSTODY_START_DATE DATE
67
 FACILITY_ID NUMBER
67
 FACILITY VARCHAR2
67
 FACILITY_START_DATE DATE
67
 DISPOSITION_TYPE VARCHAR2
67
 DISPOSITION_DATE DATE
67
 RELEASE_DATE DATE
67
 DISPOSTION_PURPOSE VARCHAR2
67
 CAUSE_OF_DEATH VARCHAR2
67
 DELETED_FLAG VARCHAR2
67
 SPECIES_ID NUMBER

Attribute Details

ANIMAL_ID

CC ID: 219251
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

NOAA_ID

CC ID: 219262
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 60
Required: Yes
Primary Key: No
Status: Active
General Data Type: VARCHAR2

GENDER

CC ID: 219270
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
General Data Type: VARCHAR2

BIRTH_DATE

CC ID: 219271
Seq. Order: 4
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
General Data Type: DATE

BIRTH_DATE_CERTAINTY

CC ID: 219272
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 8
Required: Yes
Primary Key: No
Status: Active
General Data Type: VARCHAR2

COMMON_NAME

CC ID: 219273
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

ANIMAL_ID_NBR

CC ID: 219274
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 225
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

ANIMAL_NAME

CC ID: 219275
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 225
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

ANIMAL_ACTIVITY_ID

CC ID: 219276
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Scale: 0
Status: Active
General Data Type: NUMBER

ORIGIN

CC ID: 219252
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 9
Required: Yes
Primary Key: No
Status: Active
General Data Type: VARCHAR2

ORIGINAL_CAPTIVITY_DATE

CC ID: 219253
Seq. Order: 11
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
General Data Type: DATE

ACQUISITION_PURPOSE

CC ID: 219254
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

PERMIT_NO

CC ID: 219255
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

HOLDER_ID

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

HOLDER

CC ID: 219257
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

CUSTODY_START_DATE

CC ID: 219258
Seq. Order: 16
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
General Data Type: DATE

FACILITY_ID

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

FACILITY

CC ID: 219260
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

FACILITY_START_DATE

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

DISPOSITION_TYPE

CC ID: 219263
Seq. Order: 20
Data Storage Type: VARCHAR2
Max Length: 9
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

DISPOSITION_DATE

CC ID: 219264
Seq. Order: 21
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
General Data Type: DATE

RELEASE_DATE

CC ID: 219265
Seq. Order: 22
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
General Data Type: DATE

DISPOSTION_PURPOSE

CC ID: 219266
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

CAUSE_OF_DEATH

CC ID: 219267
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 65
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

DELETED_FLAG

CC ID: 219268
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
General Data Type: VARCHAR2

SPECIES_ID

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

Catalog Details

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