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: BSC.BSC_DB_CALENDAR

Object Details

Object Name:	BSC_DB_CALENDAR
Object Type:	TABLE
Owner:	BSC
FND Design Data:	BSC.BSC_DB_CALENDAR
Subobject Name:
Status:	VALID

BSC_DB_CALENDAR stores information about calendar. Each row includes a calendar day which is identified by calendar Year, calendar month and calendar day.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BSC_DB_CALENDAR_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CALENDAR_ID CALENDAR_YEAR CALENDAR_MONTH CALENDAR_DAY YEAR SEMESTER QUARTER BIMESTER MONTH WEEK52 WEEK4 DAY365 DAY30

Columns

Name	Datatype	Length	Mandatory	Comments
CALENDAR_YEAR	NUMBER	(5)	Yes	Calendar year
CALENDAR_MONTH	NUMBER	(3)	Yes	Calendar month
CALENDAR_DAY	NUMBER	(3)	Yes	Calendar day
YEAR	NUMBER	(5)	Yes	Year
SEMESTER	NUMBER	(3)	Yes	Semester
QUARTER	NUMBER	(3)	Yes	Quarter
BIMESTER	NUMBER	(3)	Yes	Bimester
MONTH	NUMBER	(3)	Yes	Month
WEEK52	NUMBER	(3)	Yes	Week at Year to date
WEEK4	NUMBER	(3)	Yes	Week at Month to date
DAY365	NUMBER	(3)	Yes	Day at Year to date
DAY30	NUMBER	(3)	Yes	Day at Month to date
HOLYDAY_FLAG	NUMBER	(1)		Holiday Flag. 1= yes, 0 no
WORKDAY_FLAG	NUMBER	(1)		Workday Flag. 1= yes, 0 no
CALENDAR_ID	NUMBER		Yes	Calendar id
CUSTOM_1	NUMBER	(3)		Custom Periodicity
CUSTOM_2	NUMBER	(3)		Custom Periodicity 2
CUSTOM_3	NUMBER	(3)		Custom Periodicity 3
CUSTOM_4	NUMBER	(3)		Custom Periodicity 4
CUSTOM_5	NUMBER	(3)		Custom Periodicity 5
CUSTOM_6	NUMBER	(3)		Custom Periodicity 6
CUSTOM_7	NUMBER	(3)		Custom Periodicity 7
CUSTOM_8	NUMBER	(3)		Custom Periodicity 8
CUSTOM_9	NUMBER	(3)		Custom Periodicity 9
CUSTOM_10	NUMBER	(3)		Custom Periodicity 10
CUSTOM_11	NUMBER	(3)		Custom Periodicity 11
CUSTOM_12	NUMBER	(3)		Custom Periodicity 12
CUSTOM_13	NUMBER	(3)		Custom Periodicity 13
CUSTOM_14	NUMBER	(3)		Custom Periodicity 14
CUSTOM_15	NUMBER	(3)		Custom Periodicity 15
CUSTOM_16	NUMBER	(3)		Custom Periodicity 16
CUSTOM_17	NUMBER	(3)		Custom Periodicity 17
CUSTOM_18	NUMBER	(3)		Custom Periodicity 18
CUSTOM_19	NUMBER	(3)		Custom Periodicity 19
CUSTOM_20	NUMBER	(3)		Custom Periodicity 20

Query Text

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


SELECT CALENDAR_YEAR
,      CALENDAR_MONTH
,      CALENDAR_DAY
,      YEAR
,      SEMESTER
,      QUARTER
,      BIMESTER
,      MONTH
,      WEEK52
,      WEEK4
,      DAY365
,      DAY30
,      HOLYDAY_FLAG
,      WORKDAY_FLAG
,      CALENDAR_ID
,      CUSTOM_1
,      CUSTOM_2
,      CUSTOM_3
,      CUSTOM_4
,      CUSTOM_5
,      CUSTOM_6
,      CUSTOM_7
,      CUSTOM_8
,      CUSTOM_9
,      CUSTOM_10
,      CUSTOM_11
,      CUSTOM_12
,      CUSTOM_13
,      CUSTOM_14
,      CUSTOM_15
,      CUSTOM_16
,      CUSTOM_17
,      CUSTOM_18
,      CUSTOM_19
,      CUSTOM_20
FROM BSC.BSC_DB_CALENDAR;

Dependencies

[top of page]

BSC.BSC_DB_CALENDAR does not reference any database object

BSC.BSC_DB_CALENDAR is referenced by following:

APPS: BSC_DB_CALENDAR