Slide Menu
InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.2.3. Downtime Schedule Tuesday, November 29, 2022 12:00pm - 1:30pm Eastern / 10:00am - 11:30pm Pacific / 7:00am - 8:30pm Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: https://www.fisheries.noaa.gov/inportserve/waf What's...
View All
Search Help Show/Hide Menu

Item Identification

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 Information

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

the marine mammals that are being tracked

Data Attributes

Attribute Summary

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

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 Details

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