Jump to: navigation, search

In the Column List:

  • P = Primary key
  • M = Mandatory field
  • F = Foreign key

Table G_TIMECODE


This table expands the timecode values, referenced in other tables as *_TCODE, into specific time value entities, such as month name, day of the week, day of the month, and so on. The table should be pre-populated before using it.

Column List

Legend

Column Data Type P M F Description

ID

INTEGER X The timecode value. This corresponds to *_TCODE fields, such as CREATED_TCODE, ADDED_TCODE, DELETED_TCODE, and LASTCHANGE_TCODE in other tables.

TC_MIN

INTEGER X The number of minutes corresponding to this timecode.

TC_HOUR

INTEGER X The number of hours corresponding to this timecode.

TC_DAY

INTEGER X The day of the month corresponding to this timecode.

TC_WEEKDAY

INTEGER Reserved

TC_WEEK

INTEGER Reserved

TC_MONTH

INTEGER X The month number corresponding to this timecode.

TC_YEAR

INTEGER X The year value corresponding to this timecode.

TC_DAYNAME

VARCHAR2(20) Reserved

TC_WEEKNAME

VARCHAR2(30) Reserved

TC_MONTHNAME

VARCHAR2(20) Reserved

TC_H

INTEGER The hour corresponding to this timecode.

TC_Q

INTEGER The quarter in which this timecode falls.

   

 

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on 31 October 2016, at 15:33.