Slide Menu
Jump to Section...
Account Creation Issues: We have received reports of issues with creating new user accounts and linking accounts to CAM, and are currently investigating the root cause. In the meantime: - If you're experiencing errors creating new users, please use the "Quick Add" feature instead (click the "Quick Add" button on the Manage Users page). - If you're experiencing errors linking CAM accoun...
View All
Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Sustainable Fisheries > Highly Migratory Species Branch > Cooperative Tagging System > Cooperative Tagging Center (CTC) >

View: CTS_ANIMALS_V

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:7032  |  Updated: August 9, 2022  |  Published / External 

Item Identification

Title: View: CTS_ANIMALS_V
Short Name: CTS_ANIMALS_V
Status: Completed
Abstract:

View Of animal with species and sex decoded
Notes:

Loaded by batch 2083, 02-22-2008 12:10

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: CTSPAT
Description:

View Of animal with species and sex decoded

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 ANIMAL_ID NUMBER Sequential Key / Link To CTS_INTERACTION Record
100
 SPECIES_ID VARCHAR2 Species Code
100
 SPECIES_NAME VARCHAR2 Common Name
100
 SEX VARCHAR2 Code To Indicate Sex Of Animal
100
 SEX_DESCRIPTION VARCHAR2 Decode Of Code To Indicate Sez Of Animal

Attribute Details

ANIMAL_ID

CC ID: 25640
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Sequential Key / Link To CTS_INTERACTION Record
General Data Type: NUMBER

SPECIES_ID

CC ID: 25639
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 3
Required: Yes
Primary Key: No
Status: Active
Description:

Species Code
General Data Type: VARCHAR2

SPECIES_NAME

CC ID: 25643
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 21
Required: No
Primary Key: No
Status: Active
Description:

Common Name
General Data Type: VARCHAR2

SEX

CC ID: 25641
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code To Indicate Sex Of Animal
General Data Type: VARCHAR2

SEX_DESCRIPTION

CC ID: 25642
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 10
Required: Yes
Primary Key: No
Status: Active
Description:

Decode Of Code To Indicate Sez Of Animal
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 7032
GUID: gov.noaa.nmfs.inport:7032
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-02-22 12:10+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-05-05
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-05
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-05