Captag Table
Alaska Fisheries Science Center
Entity
(ENT)
| ID: 24814
| Published / External
Created: 2015-05-01
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 17266
ID: 24814
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Captag Table |
---|---|
Short Name | Captag Table |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
Table containing tag information |
* Purpose | |
Notes |
Loaded by FGDC Metadata Uploader, batch 5986, 05-01-2015 19:15 |
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 | |
---|---|
Active Version? | |
Alias | |
Schema Name | |
» Description |
Table containing tag information |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | Study | Unknown | Project # (107 in 2004) |
100 | No | No | Fish number | Unknown | Identification number for fish; serves as a reference number for all samples, capture information, movement data, etc. |
100 | No | No | Category | VARCHAR2 | Final status of fish based on tracking data, fishery recoveries, and spawning ground surveys |
100 | No | No | Area | Unknown | Discrete regional areas within basin |
100 | No | No | CDate | Unknown | Capture date: day-month-year military time (e.g. 03-Jul-02 23:34) |
100 | No | No | Revised CDate | Unknown | Conversion of CDate for Marshall fish tagged in 2002 to standardize their passage by Russian Mission with fish tagged at the Russian Mission site; based on conversion rate of 1.875 days (45 hours) for fish to travel the 150 km from Marshall to Russian Mission. |
100 | No | No | T_Freq | Unknown | Transmitter frequency (e.g. 150.863= 863, 151.420=1420) |
100 | No | No | T_Code | Unknown | Transmitter code ranging from 00 to 99 |
100 | No | No | E_Tag | Unknown | Fish tagged with external tag (Y or N) |
100 | No | No | E_Tag Type | Unknown | External tag type: 1=stag |
100 | No | No | E_Tagnum | Unknown | External tag ID number |
100 | No | No | CHour | Unknown | Capture hour (military time) |
100 | No | No | CWeek | Unknown | Week of capture (Week 24 = 6/6-12 |
100 | No | No | CSite | VARCHAR2 | Final status of fish based on tracking data, fishery recoveries, and spawning ground surveys |
100 | No | No | CMeth | VARCHAR2 | Capture method |
100 | No | No | SPP | VARCHAR2 | Species |
100 | No | No | Gender | VARCHAR2 | Male, female, or undetermined |
100 | No | No | Length | Unknown | Mid-eye to fork of tail to nearest 5mm |
100 | No | No | Color | VARCHAR2 | Fish coloration |
100 | No | No | Lice | VARCHAR2 | Presence of sea lice |
100 | No | No | Tagger | VARCHAR2 | Code given to each tagger |
100 | No | No | Comments | VARCHAR2 | General observations during tagging related to the fish |
100 | No | No | Cap_Lat | Unknown | Latitude of capture location in decimal degrees (example: 61.90461) |
100 | No | No | Cap_Lon | Unknown | Longitude of capture location in decimal degrees (example: -161.04881) |
Attribute Details
Attribute Name | Study |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Project # (107 in 2004) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | None |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Fish number |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Identification number for fish; serves as a reference number for all samples, capture information, movement data, etc. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | None |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Category |
---|---|
Seq. Order | |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Final status of fish based on tracking data, fishery recoveries, and spawning ground surveys |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1, 2, 3, 4, 11, 13, 21, 23 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Area |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Discrete regional areas within basin |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | None |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CDate |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Capture date: day-month-year military time (e.g. 03-Jul-02 23:34) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | None |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Revised CDate |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Conversion of CDate for Marshall fish tagged in 2002 to standardize their passage by Russian Mission with fish tagged at the Russian Mission site; based on conversion rate of 1.875 days (45 hours) for fish to travel the 150 km from Marshall to Russian Mission. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | None |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | T_Freq |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Transmitter frequency (e.g. 150.863= 863, 151.420=1420) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | None |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | T_Code |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Transmitter code ranging from 00 to 99 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | None |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | E_Tag |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Fish tagged with external tag (Y or N) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | None |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | E_Tag Type |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
External tag type: 1=stag |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | None |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | E_Tagnum |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
External tag ID number |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | None |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CHour |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Capture hour (military time) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | None |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CWeek |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Week of capture (Week 24 = 6/6-12 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | None |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CSite |
---|---|
Seq. Order | |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Final status of fish based on tracking data, fishery recoveries, and spawning ground surveys |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1, 2, 4, 6, 10, 11, 20 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CMeth |
---|---|
Seq. Order | |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Capture method |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1, 2, 3 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SPP |
---|---|
Seq. Order | |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Species |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1, 4, 10, 11 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Gender |
---|---|
Seq. Order | |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Male, female, or undetermined |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | M, F, U |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Length |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Mid-eye to fork of tail to nearest 5mm |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | None |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Color |
---|---|
Seq. Order | |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Fish coloration |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1, 2, 3 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Lice |
---|---|
Seq. Order | |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Presence of sea lice |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Y, N |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Tagger |
---|---|
Seq. Order | |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code given to each tagger |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1, 2, 7, 9, 10, 11, 12, 14 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Comments |
---|---|
Seq. Order | |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
General observations during tagging related to the fish |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0, 1, 2, 3, 4, 5, 6, 7, 8, 9 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Cap_Lat |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Latitude of capture location in decimal degrees (example: 61.90461) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | None |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Cap_Lon |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Longitude of capture location in decimal degrees (example: -161.04881) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | None |
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
* » 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 | 24814 |
---|---|
Metadata Record Created By | Emily A Fergusson |
Metadata Record Created | 2015-05-01 19:15+0000 |
Metadata Record Last Modified By | SysAdmin InPortAdmin |
» Metadata Record Last Modified | 2022-08-09 17:11+0000 |
Metadata Record Published | 2016-05-18 |
Owner Org | AFSC |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | 2016-05-18 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2017-05-18 |
Tags |
---|