Table: CTS_PAT_STATUS
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:7063 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | Table: CTS_PAT_STATUS |
|---|---|
| Short Name: | CTS_PAT_STATUS |
| Status: | Completed |
| Abstract: |
The status of the tag at the time of transmission. |
| Notes: |
Loaded by batch 2083, 02-22-2008 12:10 |
Entity Information
| Entity Type: | Data Table |
|---|---|
| Active Version?: | Yes |
| Schema Name: | CTSPAT |
| Description: |
The status of the tag at the time of transmission. |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
ARGOS_PTT_ID | VARCHAR2 | The unique PTT id of the transmitter used by the Argos Satellite Transmission Service provider. | |
|
100
|
RECEPTION_DATE | DATE | The data the satellite received the data from the transmitter. | |
|
100
|
RECEPTION_TIME | VARCHAR2 | The time the satellite received the data from the transmitter. | |
|
100
|
TRANSMISSIONS | NUMBER | The number of transmissions received. | |
|
100
|
TRANSMISSION_TIME | VARCHAR2 | The amount of time it took to receive the transmissions. | |
|
100
|
DEEP_DIVE_COUNT | NUMBER | The number of deep dives registered by the tag. | |
|
100
|
BATTERY_VOLTAGE | NUMBER | Current battery voltage at time of transmission. Gives an indication of how many transmissions the tag could send. | |
|
100
|
PREMATURE_RELEASE_DEPTH | NUMBER | The depth at which a premature release occured (if any). | |
|
100
|
PR_DETECTION_YEAR | NUMBER | The year when the premature release occurred. | |
|
100
|
PR_DETECTION_MONTH | NUMBER | The month when the premature release occurred. | |
|
100
|
PR_DETECTION_DAY | NUMBER | The day when the premature release occurred. | |
|
100
|
PR_DETECTION_HOUR | NUMBER | The hour when the premature release occurred. | |
|
100
|
PR_DETECTION_MINUTE | NUMBER | The minute when the premature release occurred. | |
|
100
|
LAST_DEEP_DIVE_M | NUMBER | The depth of the last deepest dive in meters. | |
|
100
|
LAST_DEEP_DIVE_YEAR | NUMBER | The year when the deepest dive occurred. | |
|
100
|
LAST_DEEP_DIVE_MONTH | NUMBER | The month when the deepest dive occurred. | |
|
100
|
LAST_DEEP_DIVE_DAY | NUMBER | The day when the deepest dive occurred. | |
|
100
|
LAST_DEEP_DIVE_HOUR | NUMBER | The hour when the deepest dive occurred. | |
|
100
|
LAST_DEEP_DIVE_MINUTE | NUMBER | The minute when the deepest dive occurred. | |
|
100
|
ARCHIVAL_TAG_ID | VARCHAR2 | Archival Tag ID provided by the manufacturer. | |
|
100
|
|
ID | NUMBER | Sequence to give each record a unique identifier. |
Attribute Details
ARGOS_PTT_ID
CC ID: 26038
| Seq. Order: | 1 |
|---|---|
| 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 |
RECEPTION_DATE
CC ID: 26039
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
The data the satellite received the data from the transmitter. |
| General Data Type: | DATE |
RECEPTION_TIME
CC ID: 26040
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 10 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
The time the satellite received the data from the transmitter. |
| General Data Type: | VARCHAR2 |
TRANSMISSIONS
CC ID: 26041
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 10 |
| Scale: | 0 |
| Status: | Active |
| Description: |
The number of transmissions received. |
| General Data Type: | NUMBER |
TRANSMISSION_TIME
CC ID: 26042
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The amount of time it took to receive the transmissions. |
| General Data Type: | VARCHAR2 |
DEEP_DIVE_COUNT
CC ID: 26043
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
The number of deep dives registered by the tag. |
| General Data Type: | NUMBER |
BATTERY_VOLTAGE
CC ID: 26044
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 5 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Current battery voltage at time of transmission. Gives an indication of how many transmissions the tag could send. |
| General Data Type: | NUMBER |
PREMATURE_RELEASE_DEPTH
CC ID: 26045
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 5 |
| Scale: | 0 |
| Status: | Active |
| Description: |
The depth at which a premature release occured (if any). |
| General Data Type: | NUMBER |
PR_DETECTION_YEAR
CC ID: 26046
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
The year when the premature release occurred. |
| General Data Type: | NUMBER |
PR_DETECTION_MONTH
CC ID: 26047
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 2 |
| Scale: | 0 |
| Status: | Active |
| Description: |
The month when the premature release occurred. |
| General Data Type: | NUMBER |
PR_DETECTION_DAY
CC ID: 26048
| Seq. Order: | 11 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 2 |
| Scale: | 0 |
| Status: | Active |
| Description: |
The day when the premature release occurred. |
| General Data Type: | NUMBER |
PR_DETECTION_HOUR
CC ID: 26049
| Seq. Order: | 12 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 2 |
| Scale: | 0 |
| Status: | Active |
| Description: |
The hour when the premature release occurred. |
| General Data Type: | NUMBER |
PR_DETECTION_MINUTE
CC ID: 26050
| Seq. Order: | 13 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 2 |
| Scale: | 0 |
| Status: | Active |
| Description: |
The minute when the premature release occurred. |
| General Data Type: | NUMBER |
LAST_DEEP_DIVE_M
CC ID: 26051
| Seq. Order: | 14 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 2 |
| Status: | Active |
| Description: |
The depth of the last deepest dive in meters. |
| General Data Type: | NUMBER |
LAST_DEEP_DIVE_YEAR
CC ID: 26052
| Seq. Order: | 15 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
The year when the deepest dive occurred. |
| General Data Type: | NUMBER |
LAST_DEEP_DIVE_MONTH
CC ID: 26053
| Seq. Order: | 16 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 2 |
| Scale: | 0 |
| Status: | Active |
| Description: |
The month when the deepest dive occurred. |
| General Data Type: | NUMBER |
LAST_DEEP_DIVE_DAY
CC ID: 26054
| Seq. Order: | 17 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 2 |
| Scale: | 0 |
| Status: | Active |
| Description: |
The day when the deepest dive occurred. |
| General Data Type: | NUMBER |
LAST_DEEP_DIVE_HOUR
CC ID: 26055
| Seq. Order: | 18 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 2 |
| Scale: | 0 |
| Status: | Active |
| Description: |
The hour when the deepest dive occurred. |
| General Data Type: | NUMBER |
LAST_DEEP_DIVE_MINUTE
CC ID: 26056
| Seq. Order: | 19 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 2 |
| Scale: | 0 |
| Status: | Active |
| Description: |
The minute when the deepest dive occurred. |
| General Data Type: | NUMBER |
ARCHIVAL_TAG_ID
CC ID: 26057
| Seq. Order: | 20 |
|---|---|
| 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 |
ID
CC ID: 26058
| Seq. Order: | 21 |
|---|---|
| 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: | 7063 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:7063 |
| 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 |