View: CTS_PAT_TAG_DAYS_V
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:7069 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | View: CTS_PAT_TAG_DAYS_V |
---|---|
Short Name: | CTS_PAT_TAG_DAYS_V |
Status: | Completed |
Abstract: |
View Of PAT information With Decodes |
Notes: |
Loaded by batch 2083, 02-22-2008 12:10 |
Entity Information
Entity Type: | Data View |
---|---|
Active Version?: | Yes |
Schema Name: | CTSPAT |
Description: |
View Of PAT information With Decodes |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
ID | NUMBER | Sequential Key | |
100
|
ARCHIVAL_TAG_ID | VARCHAR2 | Archival Tag ID provided by the manufacturer. | |
100
|
PAT_NAME | VARCHAR2 | Manufacturer Of Archival Tag | |
100
|
INVESTIGATOR_ID | NUMBER | Key to Principal Investigator Table | |
100
|
RELEASE_DATE | DATE | Date Archival Tag was applied | |
100
|
PROGRAMMED_POP_OFF_DATE | DATE | Date That Tag was Programmed To Popoff | |
100
|
ACTUAL_POP_OFF_DATE | DATE | Actual Date Tag Popped Off | |
100
|
FIRST_TRANSMISSION_DATE | DATE | Date Of First Transmission Of Archival Tag | |
100
|
DAYS_AT_LARGE | NUMBER | Number Of Days Tag was sending data | |
100
|
DAYS_ON_ANIMAL | NUMBER | Number of days tag was 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 | 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
|
NAME | VARCHAR2 | Name Of Primary Investigator |
Attribute Details
ID
CC ID: 26203
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 |
ARCHIVAL_TAG_ID
CC ID: 26204
Seq. Order: | 2 |
---|---|
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 |
PAT_NAME
CC ID: 26193
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Manufacturer Of Archival Tag |
General Data Type: | VARCHAR2 |
INVESTIGATOR_ID
CC ID: 26199
Seq. Order: | 4 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Key to Principal Investigator Table |
General Data Type: | NUMBER |
RELEASE_DATE
CC ID: 26198
Seq. Order: | 5 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date Archival Tag was applied |
General Data Type: | DATE |
PROGRAMMED_POP_OFF_DATE
CC ID: 26206
Seq. Order: | 6 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date That Tag was Programmed To Popoff |
General Data Type: | DATE |
ACTUAL_POP_OFF_DATE
CC ID: 26192
Seq. Order: | 7 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Actual Date Tag Popped Off |
General Data Type: | DATE |
FIRST_TRANSMISSION_DATE
CC ID: 26187
Seq. Order: | 8 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date Of First Transmission Of Archival Tag |
General Data Type: | DATE |
DAYS_AT_LARGE
CC ID: 26190
Seq. Order: | 9 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Number Of Days Tag was sending data |
General Data Type: | NUMBER |
DAYS_ON_ANIMAL
CC ID: 26189
Seq. Order: | 10 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Number of days tag was on animal |
General Data Type: | NUMBER |
FULL_DEPLOY_100
CC ID: 26188
Seq. Order: | 11 |
---|---|
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: 26197
Seq. Order: | 12 |
---|---|
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: 26196
Seq. Order: | 13 |
---|---|
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: 26200
Seq. Order: | 14 |
---|---|
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: 26195
Seq. Order: | 15 |
---|---|
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: 26194
Seq. Order: | 16 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Reporting Frequency In Hours |
General Data Type: | NUMBER |
LOCATION_MEMORY_KB
CC ID: 26201
Seq. Order: | 17 |
---|---|
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: 26191
Seq. Order: | 18 |
---|---|
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: 26205
Seq. Order: | 19 |
---|---|
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 |
NAME
CC ID: 26202
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 100 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Name Of Primary Investigator |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 7069 |
---|---|
GUID: | gov.noaa.nmfs.inport:7069 |
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 |