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: CHECKTRANMISSIONS
Short Name: CHECKTRANMISSIONS
Status: Completed
Abstract:

View Of information about depl;oyed archival tags

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 information about depl;oyed archival tags

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
ARGOS_PTT_ID VARCHAR2 Link to ARGOS Table
100
ARCHIVAL_TAG_ID VARCHAR2 Archival Tagnumber
100
FIRST_TRANSMISSION VARCHAR2 First Transmission Date
100
LAST_TRANSMISSION VARCHAR2 Last transmission Dare
100
TRANSMISSIONS NUMBER Numner Of transmissions
100
DAYS_TRANSMITTING NUMBER Number of days transmitting
100
DEPLOYMENT_DATE VARCHAR2 Date Deployed
100
POP_OFF_DATE VARCHAR2 Date tagged poped off
100
DEPLOYMENT_LATITUDE VARCHAR2 Deployment Latitude
100
DEPLOYMENT_LONGITUDE VARCHAR2 Deployment Longitude
100
PAT_NAME VARCHAR2 Name Of Archival tag series

Attribute Details

ARGOS_PTT_ID

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

Link to ARGOS Table

General Data Type: VARCHAR2

ARCHIVAL_TAG_ID

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

Archival Tagnumber

General Data Type: VARCHAR2

FIRST_TRANSMISSION

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

First Transmission Date

General Data Type: VARCHAR2

LAST_TRANSMISSION

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

Last transmission Dare

General Data Type: VARCHAR2

TRANSMISSIONS

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

Numner Of transmissions

General Data Type: NUMBER

DAYS_TRANSMITTING

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

Number of days transmitting

General Data Type: NUMBER

DEPLOYMENT_DATE

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

Date Deployed

General Data Type: VARCHAR2

POP_OFF_DATE

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

Date tagged poped off

General Data Type: VARCHAR2

DEPLOYMENT_LATITUDE

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

Deployment Latitude

General Data Type: VARCHAR2

DEPLOYMENT_LONGITUDE

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

Deployment Longitude

General Data Type: VARCHAR2

PAT_NAME

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

Name Of Archival tag series

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 7022
GUID: gov.noaa.nmfs.inport:7022
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-02-22 12:10+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