Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Northeast Cooperative Research Program (NCRP) > Northeast Electronic Reporting System (NERS) >

Table: TD_DEPLOYMENT_FILES

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:34597  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

TD data loading event log

Description

TD data loading event log

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
SEL_LOG_ID
NUMBER 		Unique log event identifier; supporting table NERS.SF_Equip_log
FILE_SEQ
NUMBER 		Sequencial file load identifier per TD sel_log_id
FILE_NAME
VARCHAR2 		File name of archived data
COLLECTION_DATE
DATE 		Date TD data was collected from vessel
LOADED_TO_DB
NUMBER 		TD data load status; loaded=1, not loaded=0
SAMP_FREQ_MMSS
VARCHAR2 		Sample frequency in minures and seconds (MM:SS)
RAW_TIME_OFFSET
NUMBER 		Number of hours raw data is offset from Greenwich Mean Time (GMT)
CLOCK_DRIFT
VARCHAR2 		Amount of time probe internal time has drifted from official time
COMMENTS
VARCHAR2 		Additional information

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (NEFSC) for inquiries on this record.

Item Identification

Title: Table: TD_DEPLOYMENT_FILES
Short Name: TD_DEPLOYMENT_FILES
Status: Completed
Abstract:

TD data loading event log
Notes:

Loaded by batch 9249, 09-01-2016 13:11

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NERS
Description:

TD data loading event log

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key SEL_LOG_ID NUMBER Unique log event identifier; supporting table NERS.SF_Equip_log
100
 Primary Key FILE_SEQ NUMBER Sequencial file load identifier per TD sel_log_id
100
 FILE_NAME VARCHAR2 File name of archived data
100
 COLLECTION_DATE DATE Date TD data was collected from vessel
100
 LOADED_TO_DB NUMBER TD data load status; loaded=1, not loaded=0
100
 SAMP_FREQ_MMSS VARCHAR2 Sample frequency in minures and seconds (MM:SS)
100
 RAW_TIME_OFFSET NUMBER Number of hours raw data is offset from Greenwich Mean Time (GMT)
100
 CLOCK_DRIFT VARCHAR2 Amount of time probe internal time has drifted from official time
100
 COMMENTS VARCHAR2 Additional information

Attribute Details

SEL_LOG_ID

CC ID: 348033
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 38
Status: Active
Description:

Unique log event identifier; supporting table NERS.SF_Equip_log
General Data Type: NUMBER

FILE_SEQ

CC ID: 348034
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 38
Status: Active
Description:

Sequencial file load identifier per TD sel_log_id
General Data Type: NUMBER

FILE_NAME

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

File name of archived data
General Data Type: VARCHAR2

COLLECTION_DATE

CC ID: 348036
Seq. Order: 4
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Date TD data was collected from vessel
General Data Type: DATE

LOADED_TO_DB

CC ID: 348037
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

TD data load status; loaded=1, not loaded=0
General Data Type: NUMBER

SAMP_FREQ_MMSS

CC ID: 348038
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 20
Required: Yes
Primary Key: No
Status: Active
Description:

Sample frequency in minures and seconds (MM:SS)
General Data Type: VARCHAR2

RAW_TIME_OFFSET

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

Number of hours raw data is offset from Greenwich Mean Time (GMT)
General Data Type: NUMBER

CLOCK_DRIFT

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

Amount of time probe internal time has drifted from official time
General Data Type: VARCHAR2

COMMENTS

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

Additional information
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 34597
GUID: gov.noaa.nmfs.inport:34597
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-09-01 13:11+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-09-01
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-09-01
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-09-01