Table: LOV_CONDITION
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:7517 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Condition of prohibited species at time of examination. Animal type included to allow expansion into the description of birds as well as mammals. Derived from the NORPAC Mammal_Condition table
DescriptionCondition of prohibited species at time of examination. Animal type included to allow expansion into the description of birds as well as mammals. Derived from the NORPAC Mammal_Condition table
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
CONDITION_CODE
NUMBER |
Numeric code identifying the injury |
ANIMAL_TYPE_CODE
VARCHAR2 |
Refers the the class of animal for example M - mammal H-halibut. Enforced by the Domain Animal Type. |
DESCRIPTION
VARCHAR2 |
Descriptive text of a condition resulting from an injury that may have been incurred during fishing operations. |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (AFSC) for inquiries on this record.
Item Identification
Title: | Table: LOV_CONDITION |
---|---|
Short Name: | LOV_CONDITION |
Status: | Completed |
Abstract: |
Condition of prohibited species at time of examination. Animal type included to allow expansion into the description of birds as well as mammals. Derived from the NORPAC Mammal_Condition table |
Notes: |
Loaded by batch 2204, 03-28-2008 14:09 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | TURNBULLD |
Description: |
Condition of prohibited species at time of examination. Animal type included to allow expansion into the description of birds as well as mammals. Derived from the NORPAC Mammal_Condition table |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
CONDITION_CODE | NUMBER | Numeric code identifying the injury | |
100
|
ANIMAL_TYPE_CODE | VARCHAR2 | Refers the the class of animal for example M - mammal H-halibut. Enforced by the Domain Animal Type. | |
100
|
DESCRIPTION | VARCHAR2 | Descriptive text of a condition resulting from an injury that may have been incurred during fishing operations. |
Attribute Details
CONDITION_CODE
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Numeric code identifying the injury |
General Data Type: | NUMBER |
ANIMAL_TYPE_CODE
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
Refers the the class of animal for example M - mammal H-halibut. Enforced by the Domain Animal Type. |
General Data Type: | VARCHAR2 |
Foreign Key Relations: |
TURNBULLD.LOV_ANIMAL_TYPE |
DESCRIPTION
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 40 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Descriptive text of a condition resulting from an injury that may have been incurred during fishing operations. |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 7517 |
---|---|
GUID: | gov.noaa.nmfs.inport:7517 |
Metadata Record Created By: | Doug Turnbull |
Metadata Record Created: | 2008-03-28 14:09+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2016-05-04 |
Owner Org: | AFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2016-05-04 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2017-05-04 |