View: CTS_PAT_TAG_PERFORMANCE_V
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:7070 | Updated: August 9, 2022 | Published / External
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
|
|
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 |