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: TableBSC.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BSC_DB_CALENDAR_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCALENDAR_ID
ColumnCALENDAR_YEAR
ColumnCALENDAR_MONTH
ColumnCALENDAR_DAY
ColumnYEAR
ColumnSEMESTER
ColumnQUARTER
ColumnBIMESTER
ColumnMONTH
ColumnWEEK52
ColumnWEEK4
ColumnDAY365
ColumnDAY30
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:

SchemaAPPS
SynonymBSC_DB_CALENDAR