Table: ATLW_BIRD_SPECIES_TAG

Alaska Fisheries Science Center
Entity (ENT) | ID: 9610 | Published / External
Created: 2009-06-30   |   Last Modified: 2022-08-09

Parent: AFSC/FMA/North Pacific Groundfish and Halibut Observer Program, Post 2008 Fishery Statistics.
Data Set (DS) | ID: 7284

ID: 9610
Entity (ENT)

* Discovery
• First Pass
» Metadata Rubric

Item Identification

* » Title Table: ATLW_BIRD_SPECIES_TAG
Short Name ATLW_BIRD_SPECIES_TAG
* Status Completed
Creation Date  
Revision Date  
• Publication Date  
* » Abstract

This entity represents the tag or leg band(s) observed on an individual animal. It requires that a specimen record be created even if the band(s) are only noted and described.
* Purpose

Working Tables accept the raw data from field transmissions or data entry. They are unconstrained, Relational integrity data validation is performed when data are loaded into NORPAC transaction tables. Error checking is performed by batch processes on production data.
Notes

Loaded by batch 2390, 06-30-2009 16:11
Other Citation Details
• Supplemental Information
DOI (Digital Object Identifier)  
DOI Registration Authority  
DOI Issue Date  

Keywords

Theme Keywords

Thesaurus Keyword
   
   
   

Temporal Keywords

Thesaurus Keyword
   
   
   

* Spatial Keywords

Thesaurus Keyword
   
   
   

Stratum Keywords

Thesaurus Keyword
   
   
   

Instrument Keywords

Thesaurus Keyword
   
   
   

Platform Keywords

Thesaurus Keyword
   
   
   

Physical Location

• » Organization  
• » City  
• » State/Province  
• Country  
• » Location Description

Entity Information

Entity Type Data Table
Active Version? Y
Alias  
Schema Name NORPAC
» Description

This entity represents the tag or leg band(s) observed on an individual animal. It requires that a specimen record be created even if the band(s) are only noted and described.
Change Summary

Data Attributes

Attribute Summary

Score Req'd? PKey? » Name Data Storage Type Description
100 Yes Yes RECORD_SET_STATUS_SEQ NUMBER Sequence generated unique identifier of a record set header
100 Yes Yes CRUISE NUMBER Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
100 Yes Yes PERMIT VARCHAR2 Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
100 Yes Yes TAG_SEQ NUMBER sequence generated unique identifier for this tag record.
100 Yes No TYPE_CODE VARCHAR2 Unique code identifying the type of recovered tag.
100 Yes No LOCATION_CODE VARCHAR2 Unique Code for the found location of a bird tag. For example rtleg;
100 Yes No COLOR_CODE VARCHAR2 Color Code
100 Yes No SPECIMEN_SEQ NUMBER Sequence generated unique identifier of a bird specimen.
100 No No TAG_CODE VARCHAR2 Code (Domain) identifying presence, absence, applicability of banding.
100 No No TAG_NUMBER VARCHAR2 If a tag is present and if read this field records the USFWS number or other number.

Attribute Details

Attribute Name RECORD_SET_STATUS_SEQ
Seq. Order 1
Data Storage Type NUMBER
Max Length 22
Min Length  
Required Yes
Primary Key Yes
Precision 9
Scale 0
Status Active
Description

Sequence generated unique identifier of a record set header
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CRUISE
Seq. Order 2
Data Storage Type NUMBER
Max Length 22
Min Length  
Required Yes
Primary Key Yes
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PERMIT
Seq. Order 3
Data Storage Type VARCHAR2
Max Length 6
Min Length  
Required Yes
Primary Key Yes
Precision  
Scale  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TAG_SEQ
Seq. Order 4
Data Storage Type NUMBER
Max Length 22
Min Length  
Required Yes
Primary Key Yes
Precision 8
Scale 0
Status Active
Description

sequence generated unique identifier for this tag record.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TYPE_CODE
Seq. Order 5
Data Storage Type VARCHAR2
Max Length 3
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

Unique code identifying the type of recovered tag.
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name LOCATION_CODE
Seq. Order 6
Data Storage Type VARCHAR2
Max Length 10
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

Unique Code for the found location of a bird tag. For example rtleg;
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name COLOR_CODE
Seq. Order 7
Data Storage Type VARCHAR2
Max Length 5
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

Color Code
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SPECIMEN_SEQ
Seq. Order 8
Data Storage Type NUMBER
Max Length 22
Min Length  
Required Yes
Primary Key No
Precision 9
Scale 0
Status Active
Description

Sequence generated unique identifier of a bird specimen.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TAG_CODE
Seq. Order 9
Data Storage Type VARCHAR2
Max Length 3
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Code (Domain) identifying presence, absence, applicability of banding.
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TAG_NUMBER
Seq. Order 10
Data Storage Type VARCHAR2
Max Length 20
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

If a tag is present and if read this field records the USFWS number or other number.
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Support Roles

» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions

Extents

Currentness Reference  

Extent Group 1

Extent Description

Extent Group 1 / Geographic Area

* » W° Bound
* » E° Bound
* » N° Bound
* » S° Bound
* » Description

Extent Group 1 / Vertical Extent

EPSG Code
Vertical Minimum
Vertical Maximum

Extent Group 1 / Time Frame

* » Time Frame Type
* » Start
End
Alternate Start as of Info
Alternate End as of Info
Description

Access Information

* » Security Class  
* Security Classification System  
 
Security Handling Description  
 
• Data Access Policy  
 
» Data Access Procedure  
 
• » Data Access Constraints  
 
• Data Use Constraints  
 
Metadata Access Constraints  
 
Metadata Use Constraints  
 

Distribution Information

Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status
Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status
Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status

Activity Log

Activity Time
Activity Type
Responsible Party
Description
Activity Time
Activity Type
Responsible Party
Description
Activity Time
Activity Type
Responsible Party
Description

Issues

Issue Date
Author
Issue
Issue Date
Author
Issue
Issue Date
Author
Issue

FAQs

Date
Author
Question
Answer

Child Items

Rubric scores updated every 15m

Score Type Title
     
     
     

Related Items

Item Type Relationship Type Title
     
     
     

Catalog Details

Catalog Item ID 9610
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 Workflow State Published / External
Metadata Last Review Date 2018-09-26
Metadata Review Frequency 1 Year
Metadata Next Review Date 2019-09-26
Tags