Slide Menu
Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
Search Help Show/Hide Menu

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

Rubric Score Primary Key? 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