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

Summary

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ANIMAL_ID
NUMBER
SPECIES_ID
NUMBER
SPECIES_POPULATION_AREA_ID
NUMBER
AN_NOAA_ID
VARCHAR2
AN_USGS_NBR
VARCHAR2
AN_FWS_NBR
VARCHAR2
AN_FIELD_NBR
VARCHAR2
AN_PIT_TAG_NBR
VARCHAR2
AN_GENDER
VARCHAR2
AN_BIRTH_DATE
DATE
AN_BIRTH_DATE_UNCERTAINTY
VARCHAR2
AN_USER_COMMENT
VARCHAR2
AN_ADMIN_COMMENT
VARCHAR2
DELETED_FLAG
VARCHAR2
DATE_CREATED
DATE
CREATED_BY
VARCHAR2
DATE_MODIFIED
DATE
MODIFIED_BY
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: Table: FOXPRO_ANIMALS
Short Name: FOXPRO_ANIMALS
Status: Completed
Notes:

Loaded by batch 7077, 09-17-2015 08:15

Entity Information

Entity Type: Data Table
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_USGS_NBR VARCHAR2
67
AN_FWS_NBR VARCHAR2
67
AN_FIELD_NBR VARCHAR2
67
AN_PIT_TAG_NBR VARCHAR2
67
AN_GENDER VARCHAR2
67
AN_BIRTH_DATE DATE
67
AN_BIRTH_DATE_UNCERTAINTY VARCHAR2
67
AN_USER_COMMENT VARCHAR2
67
AN_ADMIN_COMMENT VARCHAR2
67
DELETED_FLAG VARCHAR2
67
DATE_CREATED DATE
67
CREATED_BY VARCHAR2
67
DATE_MODIFIED DATE
67
MODIFIED_BY VARCHAR2

Attribute Details

ANIMAL_ID

CC ID: 219134
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: 219144
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: 219145
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: 219146
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 60
Required: Yes
Primary Key: No
Status: Active
General Data Type: VARCHAR2

AN_USGS_NBR

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

AN_FWS_NBR

CC ID: 219148
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 225
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

AN_FIELD_NBR

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

AN_PIT_TAG_NBR

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

AN_GENDER

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

AN_BIRTH_DATE

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

AN_BIRTH_DATE_UNCERTAINTY

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

AN_USER_COMMENT

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

AN_ADMIN_COMMENT

CC ID: 219138
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 1000
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

DELETED_FLAG

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

DATE_CREATED

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

CREATED_BY

CC ID: 219141
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 200
Required: Yes
Primary Key: No
Status: Active
General Data Type: VARCHAR2

DATE_MODIFIED

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

MODIFIED_BY

CC ID: 219143
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 200
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

Catalog Details

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