Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

PAT TAG Performance View

Description

PAT TAG Performance View

Entity Information

Entity Type
Data View

Data Attribute / Type Description
ID
NUMBER
Sequential Key
NAME
VARCHAR2
Name Of Primary Investigator
ARCHIVAL_TAG_ID
VARCHAR2
Archival Tag Number
PAT_NAME
VARCHAR2
Archival Tag Name
INVESTIGATOR_ID
NUMBER
Key To Primary Investigator Table
RELEASE_DATE
DATE
Date Tag was applied to animal
PROGRAMMED_POP_OFF_DATE
DATE
Date Tag is programmed to fall off of animal
ACTUAL_POP_OFF_DATE
DATE
Actual Date Tag popped Off of animal
FIRST_TRANSMISSION_DATE
DATE
First Tranmission date Of archival tag
DAYS_AT_LARGE
NUMBER
Number Of Days Archival Tag is transmitting data
DAYS_ON_ANIMAL
NUMBER
Number Of Days Archival Tag is on animal
FULL_DEPLOY_100
NUMBER
Full Deployment %
ACTUAL_DEPLOY_100
NUMBER
Actual Deployment %
LOCATION_PRIORITY
VARCHAR2
Location Priority
HISTOGRAM_PRIORITY
VARCHAR2
Histogram Priority
PDT_PRIORITY
VARCHAR2
PDT Priority
REPORTING_FREQ_HOURS
NUMBER
Archival Tag Reporting Frequency In Hours
LOCATION_MEMORY_KB
NUMBER
Location Memory IN KB
HISTOGRAM_MEMORY_KB
NUMBER
Histogram Memory in KB
PDT_MEMORY_KB
NUMBER
PDT Memory In KB
DEPTH_HISTOGRAM_COUNT
NUMBER
Depth Histogram Count
TEMP_HISTOGRAM_COUNT
NUMBER
Temporary Histogram Count
PDT_HISTOGRAM_COUNT
NUMBER
PDT Histogram Count
LOCATIONS_COUNT
NUMBER
Number Of Locations
MESSAGES
NUMBER
Number Of Messages
MAX_TRANSMISSIONS
NUMBER
Maimum Number Of Transmissions
MAX_BATTERY
NUMBER
Maximum Battery Voltage
MIN_BATTERY
NUMBER
Minimum Battert Voltage

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

Item Identification

Title: View: CTS_PAT_TAG_PERFORMANCE_V
Short Name: CTS_PAT_TAG_PERFORMANCE_V
Status: Completed
Abstract:

PAT TAG Performance View

Notes:

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

Entity Information

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

PAT TAG Performance View

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
ID NUMBER Sequential Key
100
NAME VARCHAR2 Name Of Primary Investigator
100
ARCHIVAL_TAG_ID VARCHAR2 Archival Tag Number
100
PAT_NAME VARCHAR2 Archival Tag Name
100
INVESTIGATOR_ID NUMBER Key To Primary Investigator Table
100
RELEASE_DATE DATE Date Tag was applied to animal
100
PROGRAMMED_POP_OFF_DATE DATE Date Tag is programmed to fall off of animal
100
ACTUAL_POP_OFF_DATE DATE Actual Date Tag popped Off of animal
100
FIRST_TRANSMISSION_DATE DATE First Tranmission date Of archival tag
100
DAYS_AT_LARGE NUMBER Number Of Days Archival Tag is transmitting data
100
DAYS_ON_ANIMAL NUMBER Number Of Days Archival Tag is on animal
100
FULL_DEPLOY_100 NUMBER Full Deployment %
100
ACTUAL_DEPLOY_100 NUMBER Actual Deployment %
100
LOCATION_PRIORITY VARCHAR2 Location Priority
100
HISTOGRAM_PRIORITY VARCHAR2 Histogram Priority
100
PDT_PRIORITY VARCHAR2 PDT Priority
100
REPORTING_FREQ_HOURS NUMBER Archival Tag Reporting Frequency In Hours
100
LOCATION_MEMORY_KB NUMBER Location Memory IN KB
100
HISTOGRAM_MEMORY_KB NUMBER Histogram Memory in KB
100
PDT_MEMORY_KB NUMBER PDT Memory In KB
100
DEPTH_HISTOGRAM_COUNT NUMBER Depth Histogram Count
100
TEMP_HISTOGRAM_COUNT NUMBER Temporary Histogram Count
100
PDT_HISTOGRAM_COUNT NUMBER PDT Histogram Count
100
LOCATIONS_COUNT NUMBER Number Of Locations
100
MESSAGES NUMBER Number Of Messages
100
MAX_TRANSMISSIONS NUMBER Maimum Number Of Transmissions
100
MAX_BATTERY NUMBER Maximum Battery Voltage
100
MIN_BATTERY NUMBER Minimum Battert Voltage

Attribute Details

ID

CC ID: 26211
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Sequential Key

General Data Type: NUMBER

NAME

CC ID: 26217
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

Name Of Primary Investigator

General Data Type: VARCHAR2

ARCHIVAL_TAG_ID

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

Archival Tag Number

General Data Type: VARCHAR2

PAT_NAME

CC ID: 26234
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Archival Tag Name

General Data Type: VARCHAR2

INVESTIGATOR_ID

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

Key To Primary Investigator Table

General Data Type: NUMBER

RELEASE_DATE

CC ID: 26214
Seq. Order: 6
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date Tag was applied to animal

General Data Type: DATE

PROGRAMMED_POP_OFF_DATE

CC ID: 26219
Seq. Order: 7
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date Tag is programmed to fall off of animal

General Data Type: DATE

ACTUAL_POP_OFF_DATE

CC ID: 26223
Seq. Order: 8
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Actual Date Tag popped Off of animal

General Data Type: DATE

FIRST_TRANSMISSION_DATE

CC ID: 26221
Seq. Order: 9
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

First Tranmission date Of archival tag

General Data Type: DATE

DAYS_AT_LARGE

CC ID: 26230
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Number Of Days Archival Tag is transmitting data

General Data Type: NUMBER

DAYS_ON_ANIMAL

CC ID: 26228
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Number Of Days Archival Tag is on animal

General Data Type: NUMBER

FULL_DEPLOY_100

CC ID: 26229
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Full Deployment %

General Data Type: NUMBER

ACTUAL_DEPLOY_100

CC ID: 26213
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Actual Deployment %

General Data Type: NUMBER

LOCATION_PRIORITY

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

Location Priority

General Data Type: VARCHAR2

HISTOGRAM_PRIORITY

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

Histogram Priority

General Data Type: VARCHAR2

PDT_PRIORITY

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

PDT Priority

General Data Type: VARCHAR2

REPORTING_FREQ_HOURS

CC ID: 26210
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Archival Tag Reporting Frequency In Hours

General Data Type: NUMBER

LOCATION_MEMORY_KB

CC ID: 26218
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Location Memory IN KB

General Data Type: NUMBER

HISTOGRAM_MEMORY_KB

CC ID: 26226
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Histogram Memory in KB

General Data Type: NUMBER

PDT_MEMORY_KB

CC ID: 26233
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

PDT Memory In KB

General Data Type: NUMBER

DEPTH_HISTOGRAM_COUNT

CC ID: 26209
Seq. Order: 21
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Depth Histogram Count

General Data Type: NUMBER

TEMP_HISTOGRAM_COUNT

CC ID: 26220
Seq. Order: 22
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Temporary Histogram Count

General Data Type: NUMBER

PDT_HISTOGRAM_COUNT

CC ID: 26208
Seq. Order: 23
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

PDT Histogram Count

General Data Type: NUMBER

LOCATIONS_COUNT

CC ID: 26232
Seq. Order: 24
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Number Of Locations

General Data Type: NUMBER

MESSAGES

CC ID: 26207
Seq. Order: 25
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Number Of Messages

General Data Type: NUMBER

MAX_TRANSMISSIONS

CC ID: 26224
Seq. Order: 26
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Maimum Number Of Transmissions

General Data Type: NUMBER

MAX_BATTERY

CC ID: 26225
Seq. Order: 27
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Maximum Battery Voltage

General Data Type: NUMBER

MIN_BATTERY

CC ID: 26216
Seq. Order: 28
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Minimum Battert Voltage

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 7070
GUID: gov.noaa.nmfs.inport:7070
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