tblRecovery
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:29648 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | tblRecovery |
---|---|
Short Name: | tblRecovery |
Status: | Completed |
Abstract: |
NA |
Notes: |
Loaded by FGDC Metadata Uploader, batch 7823, 12-08-2015 17:41 |
Entity Information
Description: |
NA |
---|
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
RcvKey | NUMBER | A Primary Key, Unique number for tag recovery | |
100
|
RlsKey | NUMBER | A foreign key link to tblPCTaggingRlease | |
100
|
RcvDT | NUMBER | Date and time when fish is recovered | |
100
|
RcvYr | NUMBER | Recovery year, >=2002 | |
100
|
RcvMn | NUMBER | Recovery Month, 1-12 | |
100
|
RcvDay | NUMBER | Recovery day, 1-31 | |
100
|
DQKey | NUMBER | Date data quality. | |
100
|
RDLV | Unknown | Recovery Date and Location Verified? | |
100
|
RcvSN | NUMBER | South-North (North =1 and South = -1) | |
100
|
RcvEW | NUMBER | East West (East = 1 and West = -1) | |
100
|
RcvLat | NUMBER | Latitude (decimal degrees) | |
100
|
RcvLatE | NUMBER | Latitude (decimal degrees) including estimated latitude | |
100
|
rcvLatAg | NUMBER | Latitude (decimal degrees) including estimated latitude rounded to nearest 0.25 degrees {INT(rcvLatE/2)*2+0.25} | |
100
|
RcvLong | NUMBER | Longitude (decimal degrees) | |
100
|
RcvLongE | NUMBER | Longitude (decimal degrees) including estimated longitude | |
100
|
rcvLongAg | NUMBER | Longitude (decimal degrees) including estimated longitude rounded to nearest 0.25 degrees {INT(-rcvLongE/2)*(-2)-0.25} | |
100
|
RcvLatD | NUMBER | Latitude (degrees or decimal degrees) | |
100
|
RcvLatM | NUMBER | Latitude (minutes or decimal minutes) | |
100
|
RcvLatS | NUMBER | Latitude (seconds or decimal seconds) | |
100
|
RcvLongD | NUMBER | Longitude (degrees or decimal degrees) | |
100
|
RcvLongM | NUMBER | Longitude (minutes or decimal minutes) | |
100
|
RcvLongS | NUMBER | Longitude (seconds or decimal seconds) | |
100
|
RcvSA | NUMBER | Statistical area where fish is recovered | |
100
|
RcvFedSAOld | NUMBER | Federal (NMFS) Statistical Area Where fish was recovered. | |
100
|
RcvADFGSAOld | NUMBER | ADFG Statistical Area Where fish was recovered. | |
100
|
RcvFedSA | NUMBER | NA | |
100
|
RcvADFGSA | NUMBER | NA | |
100
|
RlsFedSA | NUMBER | Federal Statistic Area | |
100
|
RlsADFGSA | NUMBER | ADFG Statistic Area | |
100
|
rlsLatAg | NUMBER | NA | |
100
|
rlsLongAg | NUMBER | NA | |
100
|
RcvWater | Unknown | Recovery location whether in (S)tate water (inside 3 nm from shoreline) or (F)ederal water (3 nm out). | |
100
|
rcvRegion | Unknown | Recovery area: AI = Aleutian Islands, BS = Bering Sea, GA = Gulf of Alaska. | |
100
|
RcvDepth | NUMBER | Recovery depth in fathams | |
100
|
rcvMDT | NUMBER | Minimum direct distance between release site and recovery site, estimated from ZLine arcMap. | |
100
|
rcvDAL | NUMBER | Days at Liberty, i.e. number days between tag release and recovery. | |
100
|
RcvLen | NUMBER | Length of fish at recovery in cm (fork length, total length, etc.) | |
100
|
RcvWt | NUMBER | Weight of fish at recovery in kg | |
100
|
SexCode | NUMBER | Sex Code: 1 = Male, 2 = Female, and 3 = Unknown | |
100
|
MSKey | NUMBER | Maturity stage code | |
100
|
RCKey | NUMBER | Condition code of fish at recovery. Replaces RcvCond field | |
100
|
RWKey | NUMBER | Description of wounds at recovery. Replaces RcvWound field. | |
100
|
PQC | NUMBER | Position data quality Code: 1-DDDMMSS;2-DDDMM;3-Estimated;4-Statistical Area;5-no info | |
100
|
RcvGT | NUMBER | Recovery gear type | |
100
|
Otolith | Unknown | Wether Otolith samples taken | |
100
|
OVNo | NUMBER | Otolith vial number | |
100
|
DSKey | NUMBER | Data source key. Replaces DSC field after checking with Sandie. | |
100
|
OLN | Unknown | Observor's last name | |
100
|
OFN | Unknown | Observor's first name | |
100
|
VPN | Unknown | Vessel or plant name of recovery vessel or plant | |
100
|
VPC | Unknown | Vessel or plant code of recovery vessel or plant | |
100
|
VPPermitNo | Unknown | Vessel or plant permit number | |
100
|
RcvCrsNo | NUMBER | Cruise number when tagged fish recovered | |
100
|
RcvHaul | NUMBER | Haul number when tagged fish recovered | |
100
|
RwdLN | Unknown | Reward recipient's Last Name | |
100
|
RwdFN | Unknown | Reward recipient's first Name | |
100
|
RwdCompany | Unknown | Comapny where Reward recipient works | |
100
|
RwdStreet | Unknown | Reward recipient''s Street address | |
100
|
RwdCity | Unknown | City where reward recipient resides | |
100
|
RwdState | Unknown | State or Province where reward recipient resides | |
100
|
RwdZip | Unknown | Reward recipient's home zip code | |
100
|
RwdCountry | Unknown | Reward recipient's country of residence | |
100
|
RwdPhone | Unknown | Reward recipient's phone number | |
100
|
RwdEMA | Unknown | Reward recipient's e-mail address | |
100
|
RwdType | NUMBER | Reward type: 1 = hat; 2 = vest, 3 = Others | |
100
|
RwdDte | NUMBER | Date reward was prepared and sent | |
100
|
RwdRDT | NUMBER | Date reward return to sender because the post service is unable to deliver the package. | |
100
|
RcvLMD | NUMBER | Last date the record was mordified or the time when the record was entered. | |
100
|
RcvLMP | Unknown | Last person mordified the record. | |
100
|
Comm | Unknown | Comments |
Attribute Details
RcvKey
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
A Primary Key, Unique number for tag recovery |
Allowed Values: | 1 - 3085 |
RlsKey
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
A foreign key link to tblPCTaggingRlease |
Allowed Values: | -99 - 7124 |
RcvDT
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date and time when fish is recovered |
Allowed Values: | 200204170000 - 201003160000 |
RcvYr
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Recovery year, >=2002 |
Allowed Values: | 2002 - 2007 |
RcvMn
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Recovery Month, 1-12 |
Allowed Values: | 1 - 12 |
RcvDay
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Recovery day, 1-31 |
Allowed Values: | 1 - 31 |
DQKey
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date data quality. |
Allowed Values: | 0 - 4 |
RDLV
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Recovery Date and Location Verified? |
Allowed Values: | unknown |
RcvSN
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
South-North (North =1 and South = -1) |
Allowed Values: | 1 - 1 |
RcvEW
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
East West (East = 1 and West = -1) |
Allowed Values: | -1 - 1 |
RcvLat
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude (decimal degrees) |
Allowed Values: | 51.6666666865349 - 62.7838889167178 |
RcvLatE
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude (decimal degrees) including estimated latitude |
Allowed Values: | 51.6666666865349 - 62.7838889167178 |
rcvLatAg
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude (decimal degrees) including estimated latitude rounded to nearest 0.25 degrees {INT(rcvLatE/2)*2+0.25} |
Allowed Values: | 51.75 - 62.75 |
RcvLong
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude (decimal degrees) |
Allowed Values: | -178.771666646004 - 179.968611083343 |
RcvLongE
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude (decimal degrees) including estimated longitude |
Allowed Values: | -180.031388916657 - -154.166666671634 |
rcvLongAg
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude (decimal degrees) including estimated longitude rounded to nearest 0.25 degrees {INT(-rcvLongE/2)*(-2)-0.25} |
Allowed Values: | -180.25 - -154.25 |
RcvLatD
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude (degrees or decimal degrees) |
Allowed Values: | 51 - 62 |
RcvLatM
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude (minutes or decimal minutes) |
Allowed Values: | 0 - 98 |
RcvLatS
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude (seconds or decimal seconds) |
Allowed Values: | 0 - 59.9000015258789 |
RcvLongD
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude (degrees or decimal degrees) |
Allowed Values: | 63 - 179 |
RcvLongM
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude (minutes or decimal minutes) |
Allowed Values: | 0 - 60 |
RcvLongS
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude (seconds or decimal seconds) |
Allowed Values: | 0 - 509 |
RcvSA
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Statistical area where fish is recovered |
Allowed Values: | 509 - 665506 |
RcvFedSAOld
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Federal (NMFS) Statistical Area Where fish was recovered. |
Allowed Values: | 509 - 630 |
RcvADFGSAOld
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
ADFG Statistical Area Where fish was recovered. |
Allowed Values: | 585601 - 786030 |
RcvFedSA
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
NA |
Allowed Values: | 509 - 999 |
RcvADFGSA
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
NA |
Allowed Values: | 545602 - 806230 |
RlsFedSA
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Federal Statistic Area |
Allowed Values: | 509 - 610 |
RlsADFGSA
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
ADFG Statistic Area |
Allowed Values: | 635504 - 665335 |
rlsLatAg
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
NA |
Allowed Values: | 54.25 - 55.75 |
rlsLongAg
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
NA |
Allowed Values: | -166.75 - -163.25 |
RcvWater
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Recovery location whether in (S)tate water (inside 3 nm from shoreline) or (F)ederal water (3 nm out). |
Allowed Values: | unknown |
rcvRegion
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Recovery area: AI = Aleutian Islands, BS = Bering Sea, GA = Gulf of Alaska. |
Allowed Values: | unknown |
RcvDepth
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Recovery depth in fathams |
Allowed Values: | 6.80000019073486 - 293 |
rcvMDT
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Minimum direct distance between release site and recovery site, estimated from ZLine arcMap. |
Allowed Values: | 0 - 13569604.449 |
rcvDAL
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Days at Liberty, i.e. number days between tag release and recovery. |
Allowed Values: | -6 - 1767 |
RcvLen
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Length of fish at recovery in cm (fork length, total length, etc.) |
Allowed Values: | 30 - 132 |
RcvWt
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Weight of fish at recovery in kg |
Allowed Values: | 0.829999983310699 - 3076 |
SexCode
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Sex Code: 1 = Male, 2 = Female, and 3 = Unknown |
Allowed Values: | 1 - 3 |
MSKey
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Maturity stage code |
Allowed Values: | -1 - 4 |
RCKey
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Condition code of fish at recovery. Replaces RcvCond field |
Allowed Values: | 0 - 3 |
RWKey
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Description of wounds at recovery. Replaces RcvWound field. |
Allowed Values: | 0 - 4 |
PQC
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Position data quality Code: 1-DDDMMSS;2-DDDMM;3-Estimated;4-Statistical Area;5-no info |
Allowed Values: | 1 - 6 |
RcvGT
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Recovery gear type |
Allowed Values: | -1 - 40 |
Otolith
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Wether Otolith samples taken |
Allowed Values: | unknown |
OVNo
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Otolith vial number |
Allowed Values: | 109 - 561143 |
DSKey
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Data source key. Replaces DSC field after checking with Sandie. |
Allowed Values: | 1 - 10 |
OLN
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Observor's last name |
Allowed Values: | unknown |
OFN
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Observor's first name |
Allowed Values: | unknown |
VPN
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Vessel or plant name of recovery vessel or plant |
Allowed Values: | unknown |
VPC
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Vessel or plant code of recovery vessel or plant |
Allowed Values: | unknown |
VPPermitNo
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Vessel or plant permit number |
Allowed Values: | unknown |
RcvCrsNo
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Cruise number when tagged fish recovered |
Allowed Values: | 4 - 200401 |
RcvHaul
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Haul number when tagged fish recovered |
Allowed Values: | 1 - 1331 |
RwdLN
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Reward recipient's Last Name |
Allowed Values: | unknown |
RwdFN
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Reward recipient's first Name |
Allowed Values: | unknown |
RwdCompany
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Comapny where Reward recipient works |
Allowed Values: | unknown |
RwdStreet
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Reward recipient''s Street address |
Allowed Values: | unknown |
RwdCity
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
City where reward recipient resides |
Allowed Values: | unknown |
RwdState
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
State or Province where reward recipient resides |
Allowed Values: | unknown |
RwdZip
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Reward recipient's home zip code |
Allowed Values: | unknown |
RwdCountry
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Reward recipient's country of residence |
Allowed Values: | unknown |
RwdPhone
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Reward recipient's phone number |
Allowed Values: | unknown |
RwdEMA
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Reward recipient's e-mail address |
Allowed Values: | unknown |
RwdType
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Reward type: 1 = hat; 2 = vest, 3 = Others |
Allowed Values: | 1 - 3 |
RwdDte
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date reward was prepared and sent |
Allowed Values: | 189912300000 - 200803130000 |
RwdRDT
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date reward return to sender because the post service is unable to deliver the package. |
Allowed Values: | 200411140000 - 200411300000 |
RcvLMD
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Last date the record was mordified or the time when the record was entered. |
Allowed Values: | 200411191011 - 201106061625 |
RcvLMP
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Last person mordified the record. |
Allowed Values: | unknown |
Comm
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Comments |
Allowed Values: | unknown |
Catalog Details
Catalog Item ID: | 29648 |
---|---|
GUID: | gov.noaa.nmfs.inport:29648 |
Metadata Record Created By: | Angie Greig |
Metadata Record Created: | 2015-12-08 17:41+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2016-05-05 |
Owner Org: | AFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2016-05-05 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2017-05-05 |