Search Help Show/Hide Menu
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