Table: CTS_PAT_TAG
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:7067 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | Table: CTS_PAT_TAG |
---|---|
Short Name: | CTS_PAT_TAG |
Status: | Completed |
Abstract: |
Information about the tag, its hardware configuration, and programming parameters. |
Notes: |
Loaded by batch 2083, 02-22-2008 12:10 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | CTSPAT |
Description: |
Information about the tag, its hardware configuration, and programming parameters. |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
ANIMAL_ID | NUMBER | The unique identifier for the animal that the tag was attached. Foreign key to the CTS_ANIMALS table. | |
100
|
ARGOS_PTT_ID | VARCHAR2 | The unique PTT id of the transmitter used by the Argos Satellite Transmission Service provider. | |
100
|
ARCHIVAL_TAG_ID | VARCHAR2 | Archival Tag ID provided by the manufacturer. | |
100
|
INVESTIGATOR_ID | NUMBER | The unique identifier of the investigator that is reponsible for the deployment of the tag. This is a foreign key to the CTS_PAT_INVESTIGATORS table. | |
100
|
BIN_PROFILE_ID | NUMBER | The id of the bin profile used by this tag. Foreign key to the CTS_PAT_TAG_BIN table. | |
100
|
TAG_RESOLUTION_ID | NUMBER | The resolution parameters associated with the tag. Foreign key to the CTS_PAT_TAG_RESOLUTION table. | |
100
|
PROGRAM_DATE | DATE | The date the tag was programmed by the user. | |
100
|
RELEASE_DATE | DATE | The date the tag was released on an animal. | |
100
|
RELEASE_LATITUDE | NUMBER | The latitude of the location where the animal and the tag were released. | |
100
|
RELEASE_LONGITUDE | NUMBER | The longitude of the location where the animal and the tag were released. | |
100
|
POPOFF_LATITUDE | NUMBER | The latitude of the location where the tag popped off and began transmitting. | |
100
|
POPOFF_LONGITUDE | NUMBER | The longitude of the location where the tag popped off and began transmitting. | |
100
|
ACTUAL_POP_OFF_DATE | DATE | The actual date when the tag popped off. This may be the date the tag started transmitting or some days before depending on the premature release parameters. | |
100
|
PROGRAMMED_POP_OFF_DATE | DATE | When the tag was programmed to pop off and begin transmitting. | |
100
|
REPORTING_FREQ_HOURS | NUMBER | The reporting frequency in hours. This parameter determines how often the tag will summarize the data. The data will be collected and a summary report will be generated for the specified period . | |
100
|
DEPTH_OPERATIONAL_MIN_MTR | NUMBER | The minimum operational depth of the tag. | |
100
|
DEPTH_OPERATIONAL_MAX_MTR | NUMBER | The maximum operational depth of the tag. | |
100
|
DEPTH_OPERATIONAL_RES_MTR | NUMBER | The resolution of the depth sensor. | |
100
|
LIGHT_OPERATIONAL_MIN_LLU | NUMBER | The minimum operational light level. | |
100
|
LIGHT_OPERATIONAL_MAX_LLU | NUMBER | The maximum operational light level. | |
100
|
TEMP_OPERATIONAL_MIN_C | NUMBER | The minimum operational temperature. | |
100
|
TEMP_OPERATIONAL_MAX_C | NUMBER | The maximum operational temperature. | |
100
|
LIGHT_OPERATIONAL_RES_LLU | NUMBER | The resolution of the light sensor. | |
100
|
TEMP_OPERATIONAL_RES_C | NUMBER | The resolution of the temperature sensor. | |
100
|
DEPTH_SAMPLE_FREQ_MINUTES | NUMBER | How often the depth will be sampled. | |
100
|
TEMP_SAMPLE_FREQ_MINUTES | NUMBER | How often the temperature will be sampled. | |
100
|
LIGHT_SAMPLE_FREQ_MINUTES | NUMBER | How often the light level will be sampled. | |
100
|
RTC_TEMP_SAMPLE_FREQ_MINUTES | NUMBER | How often the RTC Temperature will be sampled. | |
100
|
BATTERY_SAMPLE_FREQ_MINUTES | NUMBER | How often the battery level will be sampled. | |
100
|
DEPTH_TEMP_SAMPLE_FREQ_MINUTES | NUMBER | How often the minimum and maximum temperature at depth will be sampled. | |
100
|
HISTOGRAM_MEMORY_KB | NUMBER | The amount of system memory dedicated to storing histograms. | |
100
|
HISTOGRAM_PRIORITY | VARCHAR2 | The priority of transmitting the histogram data. | |
100
|
PDT_MEMORY_KB | NUMBER | The amount of system memory dedicated to storing PDT data. | |
100
|
PDT_PRIORITY | VARCHAR2 | The priority of transmitting the PDT data. | |
100
|
LOCATION_MEMORY_KB | NUMBER | The amount of system memory dedicated to storing location information. | |
100
|
LOCATION_PRIORITY | VARCHAR2 | The priority of transmitting the location data. | |
100
|
ARCHIVAL_MEMORY_KB | NUMBER | The amount of system memory dedicated to storing the high-frequency archival data. | |
100
|
STATUS_INTERVAL | NUMBER | How often the transmitter will send status messages to the satellite. | |
100
|
PREMATURE_RELEASE | VARCHAR2 | Is the Premature Release feature enabled. | |
100
|
PREMATURE_RELEASE_TIME_HRS | NUMBER | The amount of time used to determine if the premature release criteria has been met. | |
100
|
NUMBER_OF_OUTLIERS | NUMBER | The number of outliers allowed during the evaluation of the premature release criteria. | |
100
|
DETECTION_DEPTH | NUMBER | The depth to begin implementing the premature release criteria. | |
100
|
FIRST_TRANSMISSION_DATE | DATE | The date the first transmission was received by the satellite. | |
100
|
DEPLOYER | VARCHAR2 | The person who deployed the tag. | |
100
|
HOOK_LOCATION | VARCHAR2 | The location of the hook on the animal. | |
100
|
HOOK_TYPE | VARCHAR2 | The type of hook used to catch the animal. | |
100
|
FISHING_METHOD | VARCHAR2 | The fishing method used to capture the animal. | |
100
|
BLEEDING | VARCHAR2 | Whether the animal was bleeding during tagging. | |
100
|
BAIT_TYPE | VARCHAR2 | The bait used to capture the animal. | |
100
|
SNOOTER | VARCHAR2 | Did the deployer use a Snooter to capture and restrain the animal. | |
100
|
RESUSCITATION | VARCHAR2 | Was the animal resuscitated prior to release. | |
100
|
RELEASE_CONDITION | VARCHAR2 | The condition of the animal when it was released. | |
100
|
COMMENTS | VARCHAR2 | Any comments pertaining to the capture, tagging, and release of the animal. | |
100
|
RESUSCITATION_TIME | NUMBER | The amount of time the animal was resuscitated. | |
100
|
BLEEDING_TIME | NUMBER | The amount of time the animal was bleeding. | |
100
|
PAT_NAME | VARCHAR2 | The name given to the Pop-off Archival Tag. | |
100
|
RELEAST_TIME_HOUR | NUMBER | The hour the animal and the tag were released. | |
100
|
RELEASE_TIME_MINUTE | NUMBER | The minute the animal and the tag were released. | |
100
|
DETECTION_RES | NUMBER | The resolution used for the premature release detection. | |
100
|
TRIP_ID | VARCHAR2 | The unique identifier for the trip. | |
100
|
HOOK_REMOVED | VARCHAR2 | Was the hook removed from the animal prior to release. | |
100
|
ATTACHED_LINE_LENGTH | FLOAT | The length of line attached to the animal if the hook was not removed. | |
100
|
REC_MESSAGES | NUMBER | The number of messages received by the tag. Used as an indicator of tag performance. | |
100
|
CONV_TAG_AGENCY | VARCHAR2 | Conventional Tag Agency | |
100
|
CONV_TAG_ID | VARCHAR2 | Conventional Tag ID | |
100
|
DEPLOY_GEOM | SDO_GEOMETRY | The Oracle SDO_Geometry representing the point location of the deployment. | |
100
|
POPOFF_GEOM | SDO_GEOMETRY | The Oracle SDO_Geometry representing the point location of the pop-off/first transmission. | |
100
|
OTRACK_GEOM | SDO_GEOMETRY | The Oracle SDO_Geometry representing the polyline of the original track derived from the light-based geolocations. | |
100
|
PTRACK_GEOM | SDO_GEOMETRY | The Oracle SDO_Geometry representing the polyline of the probability track generated by the Kalman Filter algorithm. | |
100
|
STRACK_GEOM | SDO_GEOMETRY | The Oracle SDO_Geometry representing the polyline of the smoothed track generated by the Kalman Filter algorithm. | |
100
|
VERSION | NUMBER | The version of the pop-off archival tag. | |
100
|
MANUFACTURE_DATE | DATE | The date the tag was manufactured. | |
100
|
![]() |
ID | NUMBER | Sequence to give each record a unique identifier. |
Attribute Details
ANIMAL_ID
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
The unique identifier for the animal that the tag was attached. Foreign key to the CTS_ANIMALS table. |
General Data Type: | NUMBER |
ARGOS_PTT_ID
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
The unique PTT id of the transmitter used by the Argos Satellite Transmission Service provider. |
General Data Type: | VARCHAR2 |
ARCHIVAL_TAG_ID
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Archival Tag ID provided by the manufacturer. |
General Data Type: | VARCHAR2 |
INVESTIGATOR_ID
Seq. Order: | 4 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
The unique identifier of the investigator that is reponsible for the deployment of the tag. This is a foreign key to the CTS_PAT_INVESTIGATORS table. |
General Data Type: | NUMBER |
BIN_PROFILE_ID
Seq. Order: | 5 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
The id of the bin profile used by this tag. Foreign key to the CTS_PAT_TAG_BIN table. |
General Data Type: | NUMBER |
TAG_RESOLUTION_ID
Seq. Order: | 6 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The resolution parameters associated with the tag. Foreign key to the CTS_PAT_TAG_RESOLUTION table. |
General Data Type: | NUMBER |
PROGRAM_DATE
Seq. Order: | 7 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The date the tag was programmed by the user. |
General Data Type: | DATE |
RELEASE_DATE
Seq. Order: | 8 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The date the tag was released on an animal. |
General Data Type: | DATE |
RELEASE_LATITUDE
Seq. Order: | 9 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The latitude of the location where the animal and the tag were released. |
General Data Type: | NUMBER |
RELEASE_LONGITUDE
Seq. Order: | 10 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The longitude of the location where the animal and the tag were released. |
General Data Type: | NUMBER |
POPOFF_LATITUDE
Seq. Order: | 11 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The latitude of the location where the tag popped off and began transmitting. |
General Data Type: | NUMBER |
POPOFF_LONGITUDE
Seq. Order: | 12 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The longitude of the location where the tag popped off and began transmitting. |
General Data Type: | NUMBER |
ACTUAL_POP_OFF_DATE
Seq. Order: | 13 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The actual date when the tag popped off. This may be the date the tag started transmitting or some days before depending on the premature release parameters. |
General Data Type: | DATE |
PROGRAMMED_POP_OFF_DATE
Seq. Order: | 14 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
When the tag was programmed to pop off and begin transmitting. |
General Data Type: | DATE |
REPORTING_FREQ_HOURS
Seq. Order: | 15 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The reporting frequency in hours. This parameter determines how often the tag will summarize the data. The data will be collected and a summary report will be generated for the specified period . |
General Data Type: | NUMBER |
DEPTH_OPERATIONAL_MIN_MTR
Seq. Order: | 16 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The minimum operational depth of the tag. |
General Data Type: | NUMBER |
DEPTH_OPERATIONAL_MAX_MTR
Seq. Order: | 17 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The maximum operational depth of the tag. |
General Data Type: | NUMBER |
DEPTH_OPERATIONAL_RES_MTR
Seq. Order: | 18 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The resolution of the depth sensor. |
General Data Type: | NUMBER |
LIGHT_OPERATIONAL_MIN_LLU
Seq. Order: | 19 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The minimum operational light level. |
General Data Type: | NUMBER |
LIGHT_OPERATIONAL_MAX_LLU
Seq. Order: | 20 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The maximum operational light level. |
General Data Type: | NUMBER |
TEMP_OPERATIONAL_MIN_C
Seq. Order: | 21 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The minimum operational temperature. |
General Data Type: | NUMBER |
TEMP_OPERATIONAL_MAX_C
Seq. Order: | 22 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The maximum operational temperature. |
General Data Type: | NUMBER |
LIGHT_OPERATIONAL_RES_LLU
Seq. Order: | 23 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The resolution of the light sensor. |
General Data Type: | NUMBER |
TEMP_OPERATIONAL_RES_C
Seq. Order: | 24 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The resolution of the temperature sensor. |
General Data Type: | NUMBER |
DEPTH_SAMPLE_FREQ_MINUTES
Seq. Order: | 25 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
How often the depth will be sampled. |
General Data Type: | NUMBER |
TEMP_SAMPLE_FREQ_MINUTES
Seq. Order: | 26 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
How often the temperature will be sampled. |
General Data Type: | NUMBER |
LIGHT_SAMPLE_FREQ_MINUTES
Seq. Order: | 27 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
How often the light level will be sampled. |
General Data Type: | NUMBER |
RTC_TEMP_SAMPLE_FREQ_MINUTES
Seq. Order: | 28 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
How often the RTC Temperature will be sampled. |
General Data Type: | NUMBER |
BATTERY_SAMPLE_FREQ_MINUTES
Seq. Order: | 29 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
How often the battery level will be sampled. |
General Data Type: | NUMBER |
DEPTH_TEMP_SAMPLE_FREQ_MINUTES
Seq. Order: | 30 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
How often the minimum and maximum temperature at depth will be sampled. |
General Data Type: | NUMBER |
HISTOGRAM_MEMORY_KB
Seq. Order: | 31 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The amount of system memory dedicated to storing histograms. |
General Data Type: | NUMBER |
HISTOGRAM_PRIORITY
Seq. Order: | 32 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The priority of transmitting the histogram data. |
General Data Type: | VARCHAR2 |
PDT_MEMORY_KB
Seq. Order: | 33 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The amount of system memory dedicated to storing PDT data. |
General Data Type: | NUMBER |
PDT_PRIORITY
Seq. Order: | 34 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The priority of transmitting the PDT data. |
General Data Type: | VARCHAR2 |
LOCATION_MEMORY_KB
Seq. Order: | 35 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The amount of system memory dedicated to storing location information. |
General Data Type: | NUMBER |
LOCATION_PRIORITY
Seq. Order: | 36 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The priority of transmitting the location data. |
General Data Type: | VARCHAR2 |
ARCHIVAL_MEMORY_KB
Seq. Order: | 37 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The amount of system memory dedicated to storing the high-frequency archival data. |
General Data Type: | NUMBER |
STATUS_INTERVAL
Seq. Order: | 38 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
How often the transmitter will send status messages to the satellite. |
General Data Type: | NUMBER |
PREMATURE_RELEASE
Seq. Order: | 39 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Is the Premature Release feature enabled. |
General Data Type: | VARCHAR2 |
PREMATURE_RELEASE_TIME_HRS
Seq. Order: | 40 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The amount of time used to determine if the premature release criteria has been met. |
General Data Type: | NUMBER |
NUMBER_OF_OUTLIERS
Seq. Order: | 41 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The number of outliers allowed during the evaluation of the premature release criteria. |
General Data Type: | NUMBER |
DETECTION_DEPTH
Seq. Order: | 42 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The depth to begin implementing the premature release criteria. |
General Data Type: | NUMBER |
FIRST_TRANSMISSION_DATE
Seq. Order: | 43 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The date the first transmission was received by the satellite. |
General Data Type: | DATE |
DEPLOYER
Seq. Order: | 44 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The person who deployed the tag. |
General Data Type: | VARCHAR2 |
HOOK_LOCATION
Seq. Order: | 45 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The location of the hook on the animal. |
General Data Type: | VARCHAR2 |
HOOK_TYPE
Seq. Order: | 46 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The type of hook used to catch the animal. |
General Data Type: | VARCHAR2 |
FISHING_METHOD
Seq. Order: | 47 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The fishing method used to capture the animal. |
General Data Type: | VARCHAR2 |
BLEEDING
Seq. Order: | 48 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Whether the animal was bleeding during tagging. |
General Data Type: | VARCHAR2 |
BAIT_TYPE
Seq. Order: | 49 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The bait used to capture the animal. |
General Data Type: | VARCHAR2 |
SNOOTER
Seq. Order: | 50 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Did the deployer use a Snooter to capture and restrain the animal. |
General Data Type: | VARCHAR2 |
RESUSCITATION
Seq. Order: | 51 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Was the animal resuscitated prior to release. |
General Data Type: | VARCHAR2 |
RELEASE_CONDITION
Seq. Order: | 52 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The condition of the animal when it was released. |
General Data Type: | VARCHAR2 |
COMMENTS
Seq. Order: | 53 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 500 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Any comments pertaining to the capture, tagging, and release of the animal. |
General Data Type: | VARCHAR2 |
RESUSCITATION_TIME
Seq. Order: | 54 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The amount of time the animal was resuscitated. |
General Data Type: | NUMBER |
BLEEDING_TIME
Seq. Order: | 55 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The amount of time the animal was bleeding. |
General Data Type: | NUMBER |
PAT_NAME
Seq. Order: | 56 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The name given to the Pop-off Archival Tag. |
General Data Type: | VARCHAR2 |
RELEAST_TIME_HOUR
Seq. Order: | 57 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The hour the animal and the tag were released. |
General Data Type: | NUMBER |
RELEASE_TIME_MINUTE
Seq. Order: | 58 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The minute the animal and the tag were released. |
General Data Type: | NUMBER |
DETECTION_RES
Seq. Order: | 59 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
The resolution used for the premature release detection. |
General Data Type: | NUMBER |
TRIP_ID
Seq. Order: | 60 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The unique identifier for the trip. |
General Data Type: | VARCHAR2 |
HOOK_REMOVED
Seq. Order: | 61 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Was the hook removed from the animal prior to release. |
General Data Type: | VARCHAR2 |
ATTACHED_LINE_LENGTH
Seq. Order: | 62 |
---|---|
Data Storage Type: | FLOAT |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 126 |
Status: | Active |
Description: |
The length of line attached to the animal if the hook was not removed. |
General Data Type: | FLOAT |
REC_MESSAGES
Seq. Order: | 63 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The number of messages received by the tag. Used as an indicator of tag performance. |
General Data Type: | NUMBER |
CONV_TAG_AGENCY
Seq. Order: | 64 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Conventional Tag Agency |
General Data Type: | VARCHAR2 |
CONV_TAG_ID
Seq. Order: | 65 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Conventional Tag ID |
General Data Type: | VARCHAR2 |
DEPLOY_GEOM
Seq. Order: | 66 |
---|---|
Data Storage Type: | SDO_GEOMETRY |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The Oracle SDO_Geometry representing the point location of the deployment. |
General Data Type: | SDO_GEOMETRY |
POPOFF_GEOM
Seq. Order: | 67 |
---|---|
Data Storage Type: | SDO_GEOMETRY |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The Oracle SDO_Geometry representing the point location of the pop-off/first transmission. |
General Data Type: | SDO_GEOMETRY |
OTRACK_GEOM
Seq. Order: | 68 |
---|---|
Data Storage Type: | SDO_GEOMETRY |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The Oracle SDO_Geometry representing the polyline of the original track derived from the light-based geolocations. |
General Data Type: | SDO_GEOMETRY |
PTRACK_GEOM
Seq. Order: | 69 |
---|---|
Data Storage Type: | SDO_GEOMETRY |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The Oracle SDO_Geometry representing the polyline of the probability track generated by the Kalman Filter algorithm. |
General Data Type: | SDO_GEOMETRY |
STRACK_GEOM
Seq. Order: | 70 |
---|---|
Data Storage Type: | SDO_GEOMETRY |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The Oracle SDO_Geometry representing the polyline of the smoothed track generated by the Kalman Filter algorithm. |
General Data Type: | SDO_GEOMETRY |
VERSION
Seq. Order: | 71 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The version of the pop-off archival tag. |
General Data Type: | NUMBER |
MANUFACTURE_DATE
Seq. Order: | 72 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
The date the tag was manufactured. |
General Data Type: | DATE |
ID
Seq. Order: | 73 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 38 |
Status: | Active |
Description: |
Sequence to give each record a unique identifier. |
General Data Type: | NUMBER |
Catalog Details
Catalog Item ID: | 7067 |
---|---|
GUID: | gov.noaa.nmfs.inport:7067 |
Metadata Record Created By: | Lee M Weinberger |
Metadata Record Created: | 2008-02-22 12:11+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2021-05-05 |
Owner Org: | SEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2021-05-05 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2022-05-05 |