eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: CSF.CSF_TDS_INTERVALS_AU

Object Details

Object Name:	CSF_TDS_INTERVALS_AU
Object Type:	TABLE
Owner:	CSF
Subobject Name:
Status:	VALID

DEFINITION
The INTERVAL table define the Time period during which a certain Condition, Roadblock or Daylight Saving Period is valid.
EXAMPLE
MISCELLANEOUS
The Time period is defined as composite time-units (year, month, week, day, hour, minute).
The Time period includes a start time and a period of duration.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
INTERVAL_ID	NUMBER	(30)	Yes	Unique identifier for the Interval entity
S_INTERVAL_TYPE	NUMBER		Yes	Defines the start period of the Time Interval as a certain Interval Type.
S_YEAR	NUMBER			Defines the Start time of the Interval as a precise Year.
S_MONTH_OF_YEAR	NUMBER			Defines the End time of the Interval as a Month of the Year.
S_DAY_OF_YEAR	NUMBER			Defines specific day in year at which time interval starts.
S_DAY_OF_MONTH	NUMBER			Defines the Start time of the Interval as a fixed day of the Month.
S_DAY_OF_WEEK	NUMBER			Defines the Start time of the Interval as a fixed day in the Week.
S_HOUR_OF_DAY	NUMBER			Specifies the exact hour within the day at which the time interval starts.
S_MINUTE_OF_HOUR	NUMBER			Specifies the exact minute within the hour at which the time interval starts.
E_INTERVAL_TYPE	NUMBER		Yes	Defines the ending period of the Time Interval as a certain Interval Type.
E_YEAR	NUMBER			Defines the End time of the Interval as a precise Year.
E_MONTH_OF_YEAR	NUMBER			Defines the End time of the Interval as a Month of the Year.
E_WEEK_OF_YEAR	NUMBER			Defines the End time of the Interval as a Week of the Year.
E_DAY_OF_MONTH	NUMBER			Defines the End time of the Interval as a fixed day of the Month.
E_DAY_OF_WEEK	NUMBER			Defines the End time of the Interval as a fixed day in the Week.
E_HOUR_OF_DAY	NUMBER			Specifies the exact hour within the day at which the time interval ends.
E_MINUTE_OF_HOUR	NUMBER			Specifies the exact minute within the hour at which the time interval starts.
BIN_INDEX	NUMBER			used to generate the segment index in the Binary TDS file
E_WEEK_OF_MONTH	NUMBER			Defines week within month at which interval ends
S_WEEK_OF_YEAR	NUMBER			Defines the Start time of the Interval as a Week of the Year.
E_DAY_OF_YEAR	NUMBER			Defines specific day in year at which time interval ends.
S_WEEK_OF_MONTH	NUMBER			Defines week within month at which interval starts
GDF_TIME_DOMAIN_STRING	VARCHAR2	(500)		Holds the GDF time domain string defining a condition interval.
SECURITY_GROUP_ID	NUMBER			Identifier used for running in hosted mode.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INTERVAL_ID
,      S_INTERVAL_TYPE
,      S_YEAR
,      S_MONTH_OF_YEAR
,      S_DAY_OF_YEAR
,      S_DAY_OF_MONTH
,      S_DAY_OF_WEEK
,      S_HOUR_OF_DAY
,      S_MINUTE_OF_HOUR
,      E_INTERVAL_TYPE
,      E_YEAR
,      E_MONTH_OF_YEAR
,      E_WEEK_OF_YEAR
,      E_DAY_OF_MONTH
,      E_DAY_OF_WEEK
,      E_HOUR_OF_DAY
,      E_MINUTE_OF_HOUR
,      BIN_INDEX
,      E_WEEK_OF_MONTH
,      S_WEEK_OF_YEAR
,      E_DAY_OF_YEAR
,      S_WEEK_OF_MONTH
,      GDF_TIME_DOMAIN_STRING
,      SECURITY_GROUP_ID
FROM CSF.CSF_TDS_INTERVALS_AU;

Dependencies

[top of page]

CSF.CSF_TDS_INTERVALS_AU does not reference any database object

CSF.CSF_TDS_INTERVALS_AU is referenced by following:

APPS: CSF_TDS_INTERVALS_AU