Metadata Rubric

98%

5.89 / 6

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

Table: NIMM_ANIMALS

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

the marine mammals that are being tracked

Description

the marine mammals that are being tracked

Entity Type
Data Table

Data Attribute / Type	Description
ANIMAL_ID NUMBER	the unique identifier of an animal
SPECIES_ID NUMBER
SPECIES_POPULATION_AREA_ID NUMBER
AN_NOAA_ID VARCHAR2	the animal's NOAA identification
AN_USGS_NBR VARCHAR2	the animal's USGS identification number
AN_FWS_NBR VARCHAR2	the animal's FWS identification number
AN_FIELD_NBR VARCHAR2	unknown
AN_PIT_TAG_NBR VARCHAR2	the animal's PIT (electronic) tag identification number
AN_GENDER VARCHAR2	the animal's gender
AN_BIRTH_DATE DATE	the date of birth of the animal
AN_BIRTH_DATE_UNCERTAINTY VARCHAR2	indication as to the certainty of the birth date
AN_USER_COMMENT VARCHAR2	comments about the animal made by general users
AN_ADMIN_COMMENT VARCHAR2	administrator comments about the animal
DELETED_FLAG VARCHAR2	indicates whether or not this record has been logically deleted
DATE_CREATED DATE	the date this record was inserted
CREATED_BY VARCHAR2	the user who inserted this record
DATE_MODIFIED DATE	the date of the most recent modification to this record
MODIFIED_BY VARCHAR2	the last user who modified this record

Data Attribute / Type

Description

ANIMAL_ID
NUMBER

the unique identifier of an animal

SPECIES_ID
NUMBER

SPECIES_POPULATION_AREA_ID
NUMBER

AN_NOAA_ID
VARCHAR2

the animal's NOAA identification

AN_USGS_NBR
VARCHAR2

the animal's USGS identification number

AN_FWS_NBR
VARCHAR2

the animal's FWS identification number

AN_FIELD_NBR
VARCHAR2

unknown

AN_PIT_TAG_NBR
VARCHAR2

the animal's PIT (electronic) tag identification number

AN_GENDER
VARCHAR2

the animal's gender

AN_BIRTH_DATE
DATE

the date of birth of the animal

AN_BIRTH_DATE_UNCERTAINTY
VARCHAR2

indication as to the certainty of the birth date

AN_USER_COMMENT
VARCHAR2

comments about the animal made by general users

AN_ADMIN_COMMENT
VARCHAR2

administrator comments about the animal

DELETED_FLAG
VARCHAR2

indicates whether or not this record has been logically deleted

DATE_CREATED
DATE

the date this record was inserted

CREATED_BY
VARCHAR2

the user who inserted this record

DATE_MODIFIED
DATE

the date of the most recent modification to this record

MODIFIED_BY
VARCHAR2

the last user who modified this record

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: NIMM_ANIMALS
Short Name:	NIMM_ANIMALS
Status:	Completed
Abstract:	the marine mammals that are being tracked
Notes:	Loaded by batch 7077, 09-17-2015 08:15

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	NIMM_APPS
Description:	the marine mammals that are being tracked

Attribute Summary

	Name	Type	Description
100	ANIMAL_ID	NUMBER	the unique identifier of an animal
67	SPECIES_ID	NUMBER
67	SPECIES_POPULATION_AREA_ID	NUMBER
100	AN_NOAA_ID	VARCHAR2	the animal's NOAA identification
100	AN_USGS_NBR	VARCHAR2	the animal's USGS identification number
100	AN_FWS_NBR	VARCHAR2	the animal's FWS identification number
100	AN_FIELD_NBR	VARCHAR2	unknown
100	AN_PIT_TAG_NBR	VARCHAR2	the animal's PIT (electronic) tag identification number
100	AN_GENDER	VARCHAR2	the animal's gender
100	AN_BIRTH_DATE	DATE	the date of birth of the animal
100	AN_BIRTH_DATE_UNCERTAINTY	VARCHAR2	indication as to the certainty of the birth date
100	AN_USER_COMMENT	VARCHAR2	comments about the animal made by general users
100	AN_ADMIN_COMMENT	VARCHAR2	administrator comments about the animal
100	DELETED_FLAG	VARCHAR2	indicates whether or not this record has been logically deleted
100	DATE_CREATED	DATE	the date this record was inserted
100	CREATED_BY	VARCHAR2	the user who inserted this record
100	DATE_MODIFIED	DATE	the date of the most recent modification to this record
100	MODIFIED_BY	VARCHAR2	the last user who modified this record

Name

Type

Description

100

ANIMAL_ID

NUMBER

the unique identifier of an animal

SPECIES_ID

NUMBER

SPECIES_POPULATION_AREA_ID

NUMBER

100

AN_NOAA_ID

VARCHAR2

the animal's NOAA identification

100

AN_USGS_NBR

VARCHAR2

the animal's USGS identification number

100

AN_FWS_NBR

VARCHAR2

the animal's FWS identification number

100

AN_FIELD_NBR

VARCHAR2

unknown

100

AN_PIT_TAG_NBR

VARCHAR2

the animal's PIT (electronic) tag identification number

100

AN_GENDER

VARCHAR2

the animal's gender

100

AN_BIRTH_DATE

DATE

the date of birth of the animal

100

AN_BIRTH_DATE_UNCERTAINTY

VARCHAR2

indication as to the certainty of the birth date

100

AN_USER_COMMENT

VARCHAR2

comments about the animal made by general users

100

AN_ADMIN_COMMENT

VARCHAR2

administrator comments about the animal

100

DELETED_FLAG

VARCHAR2

indicates whether or not this record has been logically deleted

100

DATE_CREATED

DATE

the date this record was inserted

100

CREATED_BY

VARCHAR2

the user who inserted this record

100

DATE_MODIFIED

DATE

the date of the most recent modification to this record

100

MODIFIED_BY

VARCHAR2

the last user who modified this record

Attribute Details

ANIMAL_ID

CC ID: 219203

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
Precision:	10
Scale:	0
Status:	Active
Description:	the unique identifier of an animal
General Data Type:	NUMBER

SPECIES_ID

CC ID: 219201

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
Foreign Key Relations:	NIMM_APPS.NIMM_SPECIES

SPECIES_POPULATION_AREA_ID

CC ID: 219202

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
Foreign Key Relations:	NIMM_APPS.NIMM_SPECIES_POPULAT

AN_NOAA_ID

CC ID: 219213

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	60
Required:	Yes
Primary Key:	No
Status:	Active
Description:	the animal's NOAA identification
General Data Type:	VARCHAR2

AN_USGS_NBR

CC ID: 219214

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	225
Required:	No
Primary Key:	No
Status:	Active
Description:	the animal's USGS identification number
General Data Type:	VARCHAR2

AN_FWS_NBR

CC ID: 219215

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	225
Required:	No
Primary Key:	No
Status:	Active
Description:	the animal's FWS identification number
General Data Type:	VARCHAR2

AN_FIELD_NBR

CC ID: 219216

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

AN_PIT_TAG_NBR

CC ID: 219217

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	225
Required:	No
Primary Key:	No
Status:	Active
Description:	the animal's PIT (electronic) tag identification number
General Data Type:	VARCHAR2

AN_GENDER

CC ID: 219218

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	7
Required:	Yes
Primary Key:	No
Status:	Active
Description:	the animal's gender
General Data Type:	VARCHAR2

AN_BIRTH_DATE

CC ID: 219204

Seq. Order:	10
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	the date of birth of the animal
General Data Type:	DATE

AN_BIRTH_DATE_UNCERTAINTY

CC ID: 219205

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	Yes
Primary Key:	No
Status:	Active
Description:	indication as to the certainty of the birth date
General Data Type:	VARCHAR2

AN_USER_COMMENT

CC ID: 219206

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	1000
Required:	No
Primary Key:	No
Status:	Active
Description:	comments about the animal made by general users
General Data Type:	VARCHAR2

AN_ADMIN_COMMENT

CC ID: 219207

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	1000
Required:	No
Primary Key:	No
Status:	Active
Description:	administrator comments about the animal
General Data Type:	VARCHAR2

DELETED_FLAG

CC ID: 219208

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	indicates whether or not this record has been logically deleted
General Data Type:	VARCHAR2

DATE_CREATED

CC ID: 219209

Seq. Order:	15
Data Storage Type:	DATE
Max Length:	7
Required:	Yes
Primary Key:	No
Status:	Active
Description:	the date this record was inserted
General Data Type:	DATE

CREATED_BY

CC ID: 219210

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	200
Required:	Yes
Primary Key:	No
Status:	Active
Description:	the user who inserted this record
General Data Type:	VARCHAR2

DATE_MODIFIED

CC ID: 219211

Seq. Order:	17
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	the date of the most recent modification to this record
General Data Type:	DATE

MODIFIED_BY

CC ID: 219212

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	200
Required:	No
Primary Key:	No
Status:	Active
Description:	the last user who modified this record
General Data Type:	VARCHAR2

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

Table: NIMM_ANIMALS

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

ANIMAL_ID

SPECIES_ID

SPECIES_POPULATION_AREA_ID

AN_NOAA_ID

AN_USGS_NBR

AN_FWS_NBR

AN_FIELD_NBR

AN_PIT_TAG_NBR

AN_GENDER

AN_BIRTH_DATE

AN_BIRTH_DATE_UNCERTAINTY

AN_USER_COMMENT

AN_ADMIN_COMMENT

DELETED_FLAG

DATE_CREATED

CREATED_BY

DATE_MODIFIED

MODIFIED_BY

Catalog Details