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
SPECIES_ID
NUMBER
SPECIES_POPULATION_AREA_ID
NUMBER
AN_NOAA_ID
VARCHAR2
AN_GENDER
VARCHAR2
AN_BIRTH_DATE
DATE
AN_BIRTH_DATE_UNCERTAINTY
VARCHAR2
ANIMAL_ACTIVITY_ID
NUMBER
AA_ANIMAL_ACTIVITY_TYPE
VARCHAR2
AA_ACTIVITY_DATE
VARCHAR2
TO_HOLDER_ID
NUMBER
HOLDER_NAME
VARCHAR2
TO_FACILITY_ID
NUMBER
FACILITY_NAME
VARCHAR2

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: CURRENT_ANIMAL_STATUS_V
Short Name: CURRENT_ANIMAL_STATUS_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
SPECIES_ID NUMBER
67
SPECIES_POPULATION_AREA_ID NUMBER
67
AN_NOAA_ID VARCHAR2
67
AN_GENDER VARCHAR2
67
AN_BIRTH_DATE DATE
67
AN_BIRTH_DATE_UNCERTAINTY VARCHAR2
67
ANIMAL_ACTIVITY_ID NUMBER
67
AA_ANIMAL_ACTIVITY_TYPE VARCHAR2
67
AA_ACTIVITY_DATE VARCHAR2
67
TO_HOLDER_ID NUMBER
67
HOLDER_NAME VARCHAR2
67
TO_FACILITY_ID NUMBER
67
FACILITY_NAME VARCHAR2

Attribute Details

ANIMAL_ID

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

SPECIES_ID

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

SPECIES_POPULATION_AREA_ID

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

AN_NOAA_ID

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

AN_GENDER

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

AN_BIRTH_DATE

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

AN_BIRTH_DATE_UNCERTAINTY

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

ANIMAL_ACTIVITY_ID

CC ID: 219108
Seq. Order: 8
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: 219109
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 9
Required: Yes
Primary Key: No
Status: Active
General Data Type: VARCHAR2

AA_ACTIVITY_DATE

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

TO_HOLDER_ID

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

HOLDER_NAME

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

TO_FACILITY_ID

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

FACILITY_NAME

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

Catalog Details

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