Table: CTS_PAT_PDT
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:7060 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | Table: CTS_PAT_PDT |
|---|---|
| Short Name: | CTS_PAT_PDT |
| Status: | Completed |
| Abstract: |
Profile at Depth and Time (PDT) - a sampling of the depths that the tag experienced with minimum and maximum values for temperature at each. |
| Notes: |
Loaded by batch 2083, 02-22-2008 12:10 |
Entity Information
| Entity Type: | Data Table |
|---|---|
| Active Version?: | Yes |
| Schema Name: | CTSPAT |
| Description: |
Profile at Depth and Time (PDT) - a sampling of the depths that the tag experienced with minimum and maximum values for temperature at each. |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
ARGOS_PTT_ID | VARCHAR2 | Link to ARGOS Table | |
|
100
|
RECEPTION_DATE | DATE | Date Information Wa Received | |
|
100
|
RECEPTION_TIME | VARCHAR2 | Time Information Was Recieved | |
|
100
|
DEPTH_1 | NUMBER | Depth One Measurement | |
|
100
|
D1_MIN_TEMP | NUMBER | Depth One Minimum Temperature | |
|
100
|
D1_MAX_TEMP | NUMBER | Depth One Maximum Temperature | |
|
100
|
DEPTH_2 | NUMBER | Depth Two Measurement | |
|
100
|
D2_MIN_TEMP | NUMBER | Depth Two Minimum Temperature | |
|
100
|
D2_MAX_TEMP | NUMBER | Depth Two Maximum Temperature | |
|
100
|
DEPTH_3 | NUMBER | Depth Three Measurement | |
|
100
|
D3_MIN_TEMP | NUMBER | Depth Three Minimum Temperature | |
|
100
|
D3_MAX_TEMP | NUMBER | Depth Three Maximum Temperature | |
|
100
|
DEPTH_4 | VARCHAR2 | Depth Four Measurement | |
|
100
|
D4_MIN_TEMP | NUMBER | Depth Four Minimum Temperature | |
|
100
|
D4_MAX_TEMP | NUMBER | Depth Four Maximum Temperature | |
|
100
|
DEPTH_5 | NUMBER | Depth five measurement | |
|
100
|
D5_MIN_TEMP | NUMBER | Depth Five Minimum Temperature | |
|
100
|
D5_MAX_TEMP | NUMBER | Depth Fivet Maximum Temperature | |
|
100
|
DEPTH_6 | NUMBER | Depth Six Measurement | |
|
100
|
D6_MIN_TEMP | NUMBER | Depth Six Minimum Temperature | |
|
100
|
D6_MAX_TEMP | NUMBER | Depth Six Maximum Temperature | |
|
100
|
DEPTH_7 | NUMBER | Depth Seven Measurement | |
|
100
|
D7_MIN_TEMP | NUMBER | Depth Seven Minimum Temperature | |
|
100
|
D7_MAX_TEMP | NUMBER | Depth Seven Maximum Temperature | |
|
100
|
DEPTH_8 | NUMBER | Depth Eight Measurement | |
|
100
|
D8_MIN_TEMP | NUMBER | Depth Eight Minimum Temperature | |
|
100
|
D8_MAX_TEMP | NUMBER | Depth Eight Maximum Temperature | |
|
100
|
YEAR | NUMBER | Calender Year Measurement Was Taken | |
|
100
|
MONTH | NUMBER | Calender Month Measurement Was Taken | |
|
100
|
DAY | NUMBER | Calender Day Measurement Was Taken | |
|
100
|
HOUR | NUMBER | Time Measurement Was Taken | |
|
100
|
REPEATS | NUMBER | Number Of Times Measurement Was Repeated | |
|
100
|
ARCHIVAL_TAG_ID | VARCHAR2 | Archival Tag ID provided by the manufacturer. | |
|
100
|
|
ID | NUMBER | Sequential Key |
Attribute Details
ARGOS_PTT_ID
CC ID: 25955
| Seq. Order: | 1 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 10 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Link to ARGOS Table |
| General Data Type: | VARCHAR2 |
RECEPTION_DATE
CC ID: 25956
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Date Information Wa Received |
| General Data Type: | DATE |
RECEPTION_TIME
CC ID: 25957
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 10 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Time Information Was Recieved |
| General Data Type: | VARCHAR2 |
DEPTH_1
CC ID: 25958
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Depth One Measurement |
| General Data Type: | NUMBER |
D1_MIN_TEMP
CC ID: 25959
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 5 |
| Scale: | 1 |
| Status: | Active |
| Description: |
Depth One Minimum Temperature |
| General Data Type: | NUMBER |
D1_MAX_TEMP
CC ID: 25960
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 5 |
| Scale: | 1 |
| Status: | Active |
| Description: |
Depth One Maximum Temperature |
| General Data Type: | NUMBER |
DEPTH_2
CC ID: 25961
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Depth Two Measurement |
| General Data Type: | NUMBER |
D2_MIN_TEMP
CC ID: 25962
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 5 |
| Scale: | 1 |
| Status: | Active |
| Description: |
Depth Two Minimum Temperature |
| General Data Type: | NUMBER |
D2_MAX_TEMP
CC ID: 25963
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 5 |
| Scale: | 1 |
| Status: | Active |
| Description: |
Depth Two Maximum Temperature |
| General Data Type: | NUMBER |
DEPTH_3
CC ID: 25964
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Depth Three Measurement |
| General Data Type: | NUMBER |
D3_MIN_TEMP
CC ID: 25965
| Seq. Order: | 11 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 5 |
| Scale: | 1 |
| Status: | Active |
| Description: |
Depth Three Minimum Temperature |
| General Data Type: | NUMBER |
D3_MAX_TEMP
CC ID: 25966
| Seq. Order: | 12 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 5 |
| Scale: | 1 |
| Status: | Active |
| Description: |
Depth Three Maximum Temperature |
| General Data Type: | NUMBER |
DEPTH_4
CC ID: 25967
| Seq. Order: | 13 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 240 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Depth Four Measurement |
| General Data Type: | VARCHAR2 |
D4_MIN_TEMP
CC ID: 25968
| Seq. Order: | 14 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 5 |
| Scale: | 1 |
| Status: | Active |
| Description: |
Depth Four Minimum Temperature |
| General Data Type: | NUMBER |
D4_MAX_TEMP
CC ID: 25969
| Seq. Order: | 15 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 5 |
| Scale: | 1 |
| Status: | Active |
| Description: |
Depth Four Maximum Temperature |
| General Data Type: | NUMBER |
DEPTH_5
CC ID: 25970
| Seq. Order: | 16 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Status: | Active |
| Description: |
Depth five measurement |
| General Data Type: | NUMBER |
D5_MIN_TEMP
CC ID: 25971
| Seq. Order: | 17 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 5 |
| Scale: | 1 |
| Status: | Active |
| Description: |
Depth Five Minimum Temperature |
| General Data Type: | NUMBER |
D5_MAX_TEMP
CC ID: 25972
| Seq. Order: | 18 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 5 |
| Scale: | 1 |
| Status: | Active |
| Description: |
Depth Fivet Maximum Temperature |
| General Data Type: | NUMBER |
DEPTH_6
CC ID: 25973
| Seq. Order: | 19 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Depth Six Measurement |
| General Data Type: | NUMBER |
D6_MIN_TEMP
CC ID: 25974
| Seq. Order: | 20 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 5 |
| Scale: | 1 |
| Status: | Active |
| Description: |
Depth Six Minimum Temperature |
| General Data Type: | NUMBER |
D6_MAX_TEMP
CC ID: 25975
| Seq. Order: | 21 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 5 |
| Scale: | 1 |
| Status: | Active |
| Description: |
Depth Six Maximum Temperature |
| General Data Type: | NUMBER |
DEPTH_7
CC ID: 25976
| Seq. Order: | 22 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Depth Seven Measurement |
| General Data Type: | NUMBER |
D7_MIN_TEMP
CC ID: 25977
| Seq. Order: | 23 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 5 |
| Scale: | 1 |
| Status: | Active |
| Description: |
Depth Seven Minimum Temperature |
| General Data Type: | NUMBER |
D7_MAX_TEMP
CC ID: 25978
| Seq. Order: | 24 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 5 |
| Scale: | 1 |
| Status: | Active |
| Description: |
Depth Seven Maximum Temperature |
| General Data Type: | NUMBER |
DEPTH_8
CC ID: 25979
| Seq. Order: | 25 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Depth Eight Measurement |
| General Data Type: | NUMBER |
D8_MIN_TEMP
CC ID: 25980
| Seq. Order: | 26 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 5 |
| Scale: | 1 |
| Status: | Active |
| Description: |
Depth Eight Minimum Temperature |
| General Data Type: | NUMBER |
D8_MAX_TEMP
CC ID: 25981
| Seq. Order: | 27 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 5 |
| Scale: | 1 |
| Status: | Active |
| Description: |
Depth Eight Maximum Temperature |
| General Data Type: | NUMBER |
YEAR
CC ID: 25982
| Seq. Order: | 28 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Calender Year Measurement Was Taken |
| General Data Type: | NUMBER |
MONTH
CC ID: 25983
| Seq. Order: | 29 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 2 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Calender Month Measurement Was Taken |
| General Data Type: | NUMBER |
DAY
CC ID: 25984
| Seq. Order: | 30 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 2 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Calender Day Measurement Was Taken |
| General Data Type: | NUMBER |
HOUR
CC ID: 25985
| Seq. Order: | 31 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 2 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Time Measurement Was Taken |
| General Data Type: | NUMBER |
REPEATS
CC ID: 25986
| Seq. Order: | 32 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 3 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Number Of Times Measurement Was Repeated |
| General Data Type: | NUMBER |
ARCHIVAL_TAG_ID
CC ID: 25987
| Seq. Order: | 33 |
|---|---|
| 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: 25988
| Seq. Order: | 34 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | Yes |
| Primary Key: | Yes |
| Precision: | 38 |
| Status: | Active |
| Description: |
Sequential Key |
| General Data Type: | NUMBER |
Catalog Details
| Catalog Item ID: | 7060 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:7060 |
| 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 |