Table: ATL_BIRD_EVENT_OUTCOME_H
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:9641 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
This entity represents the outcome of a bird interaction or a bird event, species interaction or of an indivdual animal (specimen)
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
SEQ_NUMBER
NUMBER |
|
EVENT_OUTCOME_SEQ
NUMBER |
interaction behavior seq. |
CRUISE
NUMBER |
Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. |
PERMIT
VARCHAR2 |
Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau |
OUTCOME_CODE
VARCHAR2 |
Unique code identifying the condition of the bird after this interaction |
BIRD_EVENT_SEQ
NUMBER |
Sequence generated unique identifier of a bird interaction event. |
INTERACTION_SPECIES_SEQ
NUMBER |
Sequence generated unique identifier for an species interaction record |
SPECIMEN_SEQ
NUMBER |
Sequence generated unique identifier of a bird specimen. |
CHANGED_BY
VARCHAR2 |
Oracle user who made a change to the transaction table record. |
DATE_CHANGED
DATE |
Timestamp of change to transaction record. |
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: ATL_BIRD_EVENT_OUTCOME_H |
---|---|
Short Name: | ATL_BIRD_EVENT_OUTCOME_H |
Status: | Completed |
Abstract: |
This entity represents the outcome of a bird interaction or a bird event, species interaction or of an indivdual animal (specimen) |
Purpose: |
Histories of all changes to data are maintained by trigger code on the parent table; allowing change control by user and datetime for all updates and delete events. |
Notes: |
Loaded by batch 2390, 06-30-2009 16:11 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | NORPAC |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
67
|
![]() |
SEQ_NUMBER | NUMBER | |
100
|
EVENT_OUTCOME_SEQ | NUMBER | interaction behavior seq. | |
100
|
CRUISE | NUMBER | Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. | |
100
|
PERMIT | VARCHAR2 | Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau | |
100
|
OUTCOME_CODE | VARCHAR2 | Unique code identifying the condition of the bird after this interaction | |
100
|
BIRD_EVENT_SEQ | NUMBER | Sequence generated unique identifier of a bird interaction event. | |
100
|
INTERACTION_SPECIES_SEQ | NUMBER | Sequence generated unique identifier for an species interaction record | |
100
|
SPECIMEN_SEQ | NUMBER | Sequence generated unique identifier of a bird specimen. | |
100
|
CHANGED_BY | VARCHAR2 | Oracle user who made a change to the transaction table record. | |
100
|
DATE_CHANGED | DATE | Timestamp of change to transaction record. |
Attribute Details
SEQ_NUMBER
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
General Data Type: | NUMBER |
EVENT_OUTCOME_SEQ
Seq. Order: | 2 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
interaction behavior seq. |
General Data Type: | NUMBER |
CRUISE
Seq. Order: | 3 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 8 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. |
General Data Type: | NUMBER |
PERMIT
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau |
General Data Type: | VARCHAR2 |
OUTCOME_CODE
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique code identifying the condition of the bird after this interaction |
General Data Type: | VARCHAR2 |
BIRD_EVENT_SEQ
Seq. Order: | 6 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence generated unique identifier of a bird interaction event. |
General Data Type: | NUMBER |
INTERACTION_SPECIES_SEQ
Seq. Order: | 7 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence generated unique identifier for an species interaction record |
General Data Type: | NUMBER |
SPECIMEN_SEQ
Seq. Order: | 8 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence generated unique identifier of a bird specimen. |
General Data Type: | NUMBER |
CHANGED_BY
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Oracle user who made a change to the transaction table record. |
General Data Type: | VARCHAR2 |
DATE_CHANGED
Seq. Order: | 10 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Timestamp of change to transaction record. |
General Data Type: | DATE |
Catalog Details
Catalog Item ID: | 9641 |
---|---|
GUID: | gov.noaa.nmfs.inport:9641 |
Metadata Record Created By: | Doug Turnbull |
Metadata Record Created: | 2009-06-30 16:11+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2018-09-26 |
Owner Org: | AFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2018-09-26 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2019-09-26 |