MarkVision Professional 10.2
June 1, 2004
MarkVision Professional 10.2
Page 45
since 0:00:00, Jan 1,
1900, GMT.
DEVICE_ID
VARCHAR2(255)
MVP 7.1
String identifier
MarkVision uses to
identify this device.
JOB_ID
NUMBER(5)
MVP 7.1
Job id assigned by
device.
VERSION
NUMBER(5)
MVP 7.1
Version of the data
format used in this
table.
YEAR
NUMBER(4)
MVP 7.1
Year in which this job
was detected by
MarkVision.
MONTH
NUMBER(2)
MVP 7.1
Month in which this
job was detected by
MarkVision.
DAY
NUMBER(2)
MVP 7.1
Day of the month on
which this job was
detected by
MarkVision.
DAY_OF_WEEK
NUMBER(1)
MVP 7.1
Day of week on
which this job was
detected by
MarkVision.
HOURS
NUMBER(2)
MVP 7.1
Hour of the day in
which this job was
detected by
MarkVision.
MINUTES
NUMBER(2)
MVP 7.1
Minute of the hour in
which this job was
detected by
MarkVision.
SECONDS
NUMBER(2)
MVP 7.1
Seconds of the
minute in which this
job was detected by
MarkVision.
GMT_OFFSET_IN_SECONDS
NUMBER(5)
MVP 7.1
Offset from GMT of
the current time
zone, in seconds.
This is an integer
from -43200 to
43200.
IS_USING_DST
VARCHAR2(1)
MVP 7.1
Does the current time
zone use Daylight
Savings Time?
Possible values = "Y"
for true, "N" for false.
DST_OFFSET_IN_SECONDS
NUMBER(4)
MVP 7.1
Offset from Standard
Time of the current
time zone, in
seconds.