View: CTS_ANIMALS_V
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:7032 | Updated: August 9, 2022 | Published / External
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details
Data Attributes
Attribute Summary
|
|
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 |