Table: NIMM_ANIMALS
Entity (ENT) | NMFS Office Of Protected Resources (OPR)GUID: gov.noaa.nmfs.inport:26997 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
the marine mammals that are being tracked
Descriptionthe marine mammals that are being tracked
Entity Information
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 |
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: | 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
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 |
Attribute Details
ANIMAL_ID
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |