Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Entity Information

Entity Type
Data View

Data Attribute / Type Description
ANIMAL_ID
NUMBER
NOAA_ID
VARCHAR2
GENDER
VARCHAR2
BIRTH_DATE
DATE
BIRTH_DATE_CERTAINTY
VARCHAR2
COMMON_NAME
VARCHAR2
ANIMAL_ID_NBR
VARCHAR2
ANIMAL_NAME
VARCHAR2
ANIMAL_ACTIVITY_ID
NUMBER
ORIGIN
VARCHAR2
ORIGINAL_CAPTIVITY_DATE
DATE
ACQUISITION_PURPOSE
VARCHAR2
PERMIT_NO
VARCHAR2
HOLDER_ID
NUMBER
HOLDER
VARCHAR2
CUSTODY_START_DATE
DATE
FACILITY_ID
NUMBER
FACILITY
VARCHAR2
FACILITY_START_DATE
DATE
DISPOSITION_TYPE
VARCHAR2
DISPOSITION_DATE
DATE
RELEASE_DATE
DATE
DISPOSTION_PURPOSE
VARCHAR2
CAUSE_OF_DEATH
VARCHAR2
DELETED_FLAG
VARCHAR2
SPECIES_ID
NUMBER

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