Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Data Management Systems (DMS) > Vessel Electronic Reporting System (VERS) >

Table: LOCAL_GMT_CONV

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

Summary

Abstract

Table used to convert Greenwich Mean Time to Local Time (EST or DST)

Description

Table used to convert Greenwich Mean Time to Local Time (EST or DST)

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
BEGIN_DATE_GMT
DATE 		Start datetime in the UTC equivalent for the timezone listed
END_DATE_GMT
DATE 		End datetime in the UTC equivalent for the timezone listed
TIMEZONE
VARCHAR2 		Time zone for the date ranges listed
BEGIN_DATE_LOCAL
DATE 		Start datetime in Local time for the timezone listed
END_DATE_LOCAL
DATE 		End datetime in Local time for the timezone listed

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

Table used to convert Greenwich Mean Time to Local Time (EST or DST)
Notes:

Loaded by batch 9190, 08-11-2016 16:37

Entity Information

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

Table used to convert Greenwich Mean Time to Local Time (EST or DST)

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key BEGIN_DATE_GMT DATE Start datetime in the UTC equivalent for the timezone listed
100
 END_DATE_GMT DATE End datetime in the UTC equivalent for the timezone listed
100
 TIMEZONE VARCHAR2 Time zone for the date ranges listed
100
 BEGIN_DATE_LOCAL DATE Start datetime in Local time for the timezone listed
100
 END_DATE_LOCAL DATE End datetime in Local time for the timezone listed

Attribute Details

BEGIN_DATE_GMT

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

Start datetime in the UTC equivalent for the timezone listed
General Data Type: DATE

END_DATE_GMT

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

End datetime in the UTC equivalent for the timezone listed
General Data Type: DATE

TIMEZONE

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

Time zone for the date ranges listed
General Data Type: VARCHAR2

BEGIN_DATE_LOCAL

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

Start datetime in Local time for the timezone listed
General Data Type: DATE

END_DATE_LOCAL

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

End datetime in Local time for the timezone listed
General Data Type: DATE

Catalog Details

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