Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Sustainable Fisheries > Highly Migratory Species Branch > Cooperative Tagging System > Cooperative Tagging Center (CTC) >

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 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

View Of PAT information With Decodes

Description

View Of PAT information With Decodes

Entity Information

Entity Type
Data View

Data Attribute / Type Description
ID
NUMBER 		Sequential Key
ARCHIVAL_TAG_ID
VARCHAR2 		Archival Tag ID provided by the manufacturer.
PAT_NAME
VARCHAR2 		Manufacturer Of Archival Tag
INVESTIGATOR_ID
NUMBER 		Key to Principal Investigator Table
RELEASE_DATE
DATE 		Date Archival Tag was applied
PROGRAMMED_POP_OFF_DATE
DATE 		Date That Tag was Programmed To Popoff
ACTUAL_POP_OFF_DATE
DATE 		Actual Date Tag Popped Off
FIRST_TRANSMISSION_DATE
DATE 		Date Of First Transmission Of Archival Tag
DAYS_AT_LARGE
NUMBER 		Number Of Days Tag was sending data
DAYS_ON_ANIMAL
NUMBER 		Number of days tag was 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 		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
NAME
VARCHAR2 		Name Of Primary Investigator

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_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