Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: CTS_PAT_TAT
Short Name: CTS_PAT_TAT
Status: Completed
Abstract:

Time At Temperature (TAT) - the amount of time the tag spent in a pre-defined temperature bin.

Notes:

Loaded by batch 2083, 02-22-2008 12:10

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: CTSPAT
Description:

Time At Temperature (TAT) - the amount of time the tag spent in a pre-defined temperature bin.

Data Attributes

Attribute Summary

Rubric Score Primary Key? 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 date the data was received by the satellite.
100
RECEPTION_TIME VARCHAR2 The time the data was received by the satellite.
100
BIN_1 FLOAT The percentage of time the tag spent in the first temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.
100
BIN_2 FLOAT The percentage of time the tag spent in the second temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.
100
BIN_3 FLOAT The percentage of time the tag spent in the third temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.
100
BIN_4 FLOAT The percentage of time the tag spent in the fourth temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.
100
BIN_5 FLOAT The percentage of time the tag spent in the fifth temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.
100
BIN_6 FLOAT The percentage of time the tag spent in the sixth temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.
100
BIN_7 FLOAT The percentage of time the tag spent in the seventh temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.
100
BIN_8 FLOAT The percentage of time the tag spent in the eighth temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.
100
BIN_9 FLOAT The percentage of time the tag spent in the ninth temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.
100
BIN_10 FLOAT The percentage of time the tag spent in the tenth temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.
100
BIN_11 FLOAT The percentage of time the tag spent in the eleventh temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.
100
BIN_12 FLOAT The percentage of time the tag spent in the twelveth temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.
100
YEAR NUMBER The year the data was collected.
100
MONTH NUMBER The month the data was collected.
100
DAY NUMBER The day the data was collected.
100
HOUR NUMBER The hour the data was collected.
100
REPEATS NUMBER The number of times the data from this day was transmitted.
100
ARCHIVAL_TAG_ID VARCHAR2 Archival Tag ID provided by the manufacturer.
100
Primary Key ID NUMBER Sequence to give each record a unique identifier.

Attribute Details

ARGOS_PTT_ID

CC ID: 26240
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: 26241
Seq. Order: 2
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

The date the data was received by the satellite.

General Data Type: DATE

RECEPTION_TIME

CC ID: 26242
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 10
Required: Yes
Primary Key: No
Status: Active
Description:

The time the data was received by the satellite.

General Data Type: VARCHAR2

BIN_1

CC ID: 26243
Seq. Order: 4
Data Storage Type: FLOAT
Max Length: 22
Required: No
Primary Key: No
Precision: 9
Status: Active
Description:

The percentage of time the tag spent in the first temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.

General Data Type: FLOAT

BIN_2

CC ID: 26244
Seq. Order: 5
Data Storage Type: FLOAT
Max Length: 22
Required: No
Primary Key: No
Precision: 9
Status: Active
Description:

The percentage of time the tag spent in the second temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.

General Data Type: FLOAT

BIN_3

CC ID: 26245
Seq. Order: 6
Data Storage Type: FLOAT
Max Length: 22
Required: No
Primary Key: No
Precision: 9
Status: Active
Description:

The percentage of time the tag spent in the third temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.

General Data Type: FLOAT

BIN_4

CC ID: 26246
Seq. Order: 7
Data Storage Type: FLOAT
Max Length: 22
Required: No
Primary Key: No
Precision: 9
Status: Active
Description:

The percentage of time the tag spent in the fourth temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.

General Data Type: FLOAT

BIN_5

CC ID: 26247
Seq. Order: 8
Data Storage Type: FLOAT
Max Length: 22
Required: No
Primary Key: No
Precision: 9
Status: Active
Description:

The percentage of time the tag spent in the fifth temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.

General Data Type: FLOAT

BIN_6

CC ID: 26248
Seq. Order: 9
Data Storage Type: FLOAT
Max Length: 22
Required: No
Primary Key: No
Precision: 9
Status: Active
Description:

The percentage of time the tag spent in the sixth temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.

General Data Type: FLOAT

BIN_7

CC ID: 26249
Seq. Order: 10
Data Storage Type: FLOAT
Max Length: 22
Required: No
Primary Key: No
Precision: 9
Status: Active
Description:

The percentage of time the tag spent in the seventh temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.

General Data Type: FLOAT

BIN_8

CC ID: 26250
Seq. Order: 11
Data Storage Type: FLOAT
Max Length: 22
Required: No
Primary Key: No
Precision: 9
Status: Active
Description:

The percentage of time the tag spent in the eighth temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.

General Data Type: FLOAT

BIN_9

CC ID: 26251
Seq. Order: 12
Data Storage Type: FLOAT
Max Length: 22
Required: No
Primary Key: No
Precision: 9
Status: Active
Description:

The percentage of time the tag spent in the ninth temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.

General Data Type: FLOAT

BIN_10

CC ID: 26252
Seq. Order: 13
Data Storage Type: FLOAT
Max Length: 22
Required: No
Primary Key: No
Precision: 9
Status: Active
Description:

The percentage of time the tag spent in the tenth temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.

General Data Type: FLOAT

BIN_11

CC ID: 26253
Seq. Order: 14
Data Storage Type: FLOAT
Max Length: 22
Required: No
Primary Key: No
Precision: 9
Status: Active
Description:

The percentage of time the tag spent in the eleventh temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.

General Data Type: FLOAT

BIN_12

CC ID: 26254
Seq. Order: 15
Data Storage Type: FLOAT
Max Length: 22
Required: No
Primary Key: No
Precision: 9
Status: Active
Description:

The percentage of time the tag spent in the twelveth temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.

General Data Type: FLOAT

YEAR

CC ID: 26255
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

The year the data was collected.

General Data Type: NUMBER

MONTH

CC ID: 26256
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

The month the data was collected.

General Data Type: NUMBER

DAY

CC ID: 26257
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

The day the data was collected.

General Data Type: NUMBER

HOUR

CC ID: 26258
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

The hour the data was collected.

General Data Type: NUMBER

REPEATS

CC ID: 26259
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

The number of times the data from this day was transmitted.

General Data Type: NUMBER

ARCHIVAL_TAG_ID

CC ID: 26260
Seq. Order: 21
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: 26261
Seq. Order: 22
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: 7072
GUID: gov.noaa.nmfs.inport:7072
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