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

Summary

Abstract

the possible population areas for species

Description

the possible population areas for species

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
SPECIES_POPULATION_AREA_ID
NUMBER
the unique identifier for this speciies population area record
SPECIES_ID
NUMBER
POPULATION_AREA_ID
NUMBER
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_SPECIES_POPULATION_AREAS
Short Name: NIMM_SPECIES_POPULATION_AREAS
Status: Completed
Abstract:

the possible population areas for species

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 possible population areas for species

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key SPECIES_POPULATION_AREA_ID NUMBER the unique identifier for this speciies population area record
67
SPECIES_ID NUMBER
67
POPULATION_AREA_ID NUMBER
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

SPECIES_POPULATION_AREA_ID

CC ID: 219376
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 for this speciies population area record

General Data Type: NUMBER

SPECIES_ID

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

POPULATION_AREA_ID

CC ID: 219374
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_POPULATION_AREA

DELETED_FLAG

CC ID: 219377
Seq. Order: 4
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: 219378
Seq. Order: 5
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: 219379
Seq. Order: 6
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: 219380
Seq. Order: 7
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: 219381
Seq. Order: 8
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: 27007
GUID: gov.noaa.nmfs.inport:27007
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