Table: TD_DEPLOYMENT_FILES
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34597 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
TD data loading event log
DescriptionTD 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
Name | Type | Description | ||
---|---|---|---|---|
100
|
SEL_LOG_ID | NUMBER | Unique log event identifier; supporting table NERS.SF_Equip_log | |
100
|
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
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
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
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
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
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
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
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
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
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 |