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

TABLE: FII.EDW_TIME_M

Object Details
Object Name: EDW_TIME_M
Object Type: TABLE
Owner: FII
FND Design Data: TableFII.EDW_TIME_M
Subobject Name:
Status: VALID


This is the de-normalized star table for the time dimension. It contains records for the lowest level of the time dimension and their parentage up to the top level, across all hierarchies.


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EDW_TIME_M_U1 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnCDAY_CAL_DAY_PK
ColumnCDAY_CAL_DAY_PK_KEY
EDW_TIME_M_U2 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnCDAY_CAL_DAY_PK_KEY
EDW_TIME_M_N1 BITMAP NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnECPR_NAME
EDW_TIME_M_N10 BITMAP NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnECYR_NAME
EDW_TIME_M_N11 BITMAP NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnECQR_NAME
EDW_TIME_M_N12 BITMAP NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCPER_PERIOD_NAME
EDW_TIME_M_N13 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnCDAY_CALENDAR_DATE
EDW_TIME_M_N14 BITMAP NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMNTH_MONTH_PK_KEY
EDW_TIME_M_N15 BITMAP NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnECQR_CAL_QTR_PK_KEY
EDW_TIME_M_N2 BITMAP NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnHYR_NAME
EDW_TIME_M_N3 BITMAP NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnQTR_NAME
EDW_TIME_M_N4 BITMAP NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCQTR_NAME
EDW_TIME_M_N5 BITMAP NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCYR_NAME
EDW_TIME_M_N6 BITMAP NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCNAM_CAL_NAME
EDW_TIME_M_N7 BITMAP NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMNTH_NAME
EDW_TIME_M_N8 BITMAP NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnYEAR_NAME
EDW_TIME_M_N9 BITMAP NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnP445_NAME
Columns
Name Datatype Length Mandatory Comments
CDAY_CAL_DAY_PK_KEY NUMBER
Yes System generated unique identifier for enterprise calendar period
CDAY_TIMESPAN NUMBER

Set to 1
CPER_CAL_PERIOD_PK_KEY NUMBER

System generated unique identifier for financial calendar period
CPER_TIMESPAN NUMBER

The duration of the calendar period in days
PPER_PA_PERIOD_PK_KEY NUMBER

System generated unique identifier for the PA period
PPER_TIMESPAN NUMBER

The duration of the PA period in days
CQTR_CAL_QTR_PK_KEY NUMBER

System generated unique identifier for financial calendar quarter
CQTR_TIMESPAN NUMBER

The duration of the calendar quarter in days
CYR_CAL_YEAR_PK_KEY NUMBER

System generated unique identifier for financial calendar year
CYR_TIMESPAN NUMBER

The duration of the calendar year in days
CNAM_CAL_NAME_PK_KEY NUMBER

System generated unique identifier for the financial calendar
CNAM_TIMESPAN NUMBER

The duration of the fiscal calendar in days
ALL_ALL_PK_KEY NUMBER

System generated unique identifier for the top of time dimension
DAY_DAY_OF_YEAR NUMBER

Indicates the day of the year. Example, this column stores the number one for January 1st .
DAY_DAY_PK_KEY NUMBER

System generated unique identifier for day
DAY_TIMESPAN NUMBER

Set to 1
WEEK_TIMESPAN NUMBER

The duration of the week in days
WEEK_WEEK_NUMBER NUMBER

The number of the week within a year
WEEK_WEEK_PK_KEY NUMBER

System generated unique identifier for week
MNTH_MONTH_PK_KEY NUMBER

System generated unique identifier for month
MNTH_TIMESPAN NUMBER

The duration of the month in days
HMNT_HALF_MONTH_PK_KEY NUMBER

System generated unique identifier for half month
HMNT_TIMESPAN NUMBER

The duration of the half month in days
YEAR_TIMESPAN NUMBER

The duration of the year in days
YEAR_YEAR_PK_KEY NUMBER

System generated unique identifier for year
P445_PERIOD445_NUMBER NUMBER

Numbers the 445 periods within a year
P445_PERIOD_445_PK_KEY NUMBER

System generated unique identifier for the 445 period
P445_TIMESPAN NUMBER

The duration of the 445 period in days
ECNM_CAL_NAME_PK_KEY NUMBER

System generated unique identifier for the enterprise calendar
ECYR_CAL_YEAR_PK_KEY NUMBER

System generated unique identifier for enterprise calendar year
ECQR_CAL_QTR_PK_KEY NUMBER

System generated unique identifier for enterprise calendar quarter
ECPR_CAL_PERIOD_PK_KEY NUMBER

System generated unique identifier for enterprise calendar period
ECNM_TIMESPAN NUMBER

The duration of enterprise calendar in days
ECYR_TIMESPAN NUMBER

The duration of enterprise calendar year in days
ECQR_TIMESPAN NUMBER

The duration of enterprise calendar quarter in days
ECPR_TIMESPAN NUMBER

The duration of enterprise calendar period in days
CDAY_CAL_DAY VARCHAR2 (40)
Calendar date formated for display
CDAY_CAL_DAY_PK VARCHAR2 (120)
The unique identifier for calendar day
CDAY_HOLIDAY_FLAG VARCHAR2 (1)
Indicates if the date is a holiday in this calendar
CDAY_INSTANCE VARCHAR2 (40)
Instance identifier
CDAY_NAME VARCHAR2 (100)
Calendar date formatted for display
CDAY_WORK_DAY_FLAG VARCHAR2 (1)
Indicates if the date is a workday in this calendar
CPER_CAL_PERIOD_PK VARCHAR2 (120)
The unique identifier for financial calendar period
CPER_INSTANCE VARCHAR2 (40)
Instance identifier
CPER_NAME VARCHAR2 (100)
Financial calendar name
CPER_PERIOD_NAME VARCHAR2 (40)
Financial calendar name
PPER_INSTANCE VARCHAR2 (40)
Instance identifier
PPER_NAME VARCHAR2 (100)
PA period name
PPER_PA_PERIOD VARCHAR2 (40)
PA period name
PPER_PA_PERIOD_PK VARCHAR2 (120)
The unique identifier for the PA period
CQTR_CAL_QTR VARCHAR2 (40)
Financial quarter name
CQTR_CAL_QTR_PK VARCHAR2 (120)
The unique identifier for the financial calendar quarter
CQTR_INSTANCE VARCHAR2 (40)
Instance identifier
CQTR_NAME VARCHAR2 (100)
Financial quarter name
CYR_CAL_YEAR VARCHAR2 (40)
Financial year name
CYR_CAL_YEAR_PK VARCHAR2 (120)
The unique identifier for the financial calendar year
CYR_INSTANCE VARCHAR2 (40)
Instance identifier
CYR_NAME VARCHAR2 (100)
Financial year name
CNAM_CALENDAR_TYPE VARCHAR2 (40)
Calendar type
CNAM_CAL_NAME VARCHAR2 (40)
Calendar name
CNAM_CAL_NAME_PK VARCHAR2 (120)
The unique identifier for the calendar
CNAM_INSTANCE VARCHAR2 (40)
Instance identifier
CNAM_NAME VARCHAR2 (100)
Calendar name
ALL_ALL_PK VARCHAR2 (40)
The unique identifier for the top level of the time dimension
ALL_NAME VARCHAR2 (80)
The displayed name for all level
DAY_DAY VARCHAR2 (40)
The date
DAY_DAY_OF_WEEK VARCHAR2 (40)
Indicates the day of the week. Stores values such as Monday, Tuesday, ... etc
DAY_DAY_PK VARCHAR2 (20)
The unique identifier for the day
DAY_INSTANCE VARCHAR2 (40)
Instance identifier
DAY_NAME VARCHAR2 (100)
The date
DAY_WEEKEND_FLAG VARCHAR2 (1)
Indicates if this day is Saturday or Sunday
WEEK_INSTANCE VARCHAR2 (40)
Instance identifier
WEEK_NAME VARCHAR2 (100)
Week name
WEEK_WEEK VARCHAR2 (40)
Week name
WEEK_WEEK_PK VARCHAR2 (20)
The unique identifier for week
MNTH_INSTANCE VARCHAR2 (40)
Instance identifier
MNTH_MONTH VARCHAR2 (40)
Month name
MNTH_MONTH_PK VARCHAR2 (20)
The unique identifier for month
MNTH_NAME VARCHAR2 (100)
Month name
HMNT_HALF_MONTH VARCHAR2 (40)
Half month name
HMNT_HALF_MONTH_NAME VARCHAR2 (40)
Half month name
HMNT_HALF_MONTH_PK VARCHAR2 (20)
The unique identifier for half month
HMNT_INSTANCE VARCHAR2 (40)
Instance identifier
HMNT_NAME VARCHAR2 (100)
Half month name
YEAR_INSTANCE VARCHAR2 (40)
Instance identifier
YEAR_NAME VARCHAR2 (100)
Year
YEAR_YEAR VARCHAR2 (40)
Year
YEAR_YEAR_PK VARCHAR2 (20)
The unique identifier for year
P445_INSTANCE VARCHAR2 (40)
Instance identifier
P445_NAME VARCHAR2 (100)
445 period name
P445_PERIOD_445 VARCHAR2 (40)
445 period name
P445_PERIOD_445_PK VARCHAR2 (20)
The unique identifier for the 445 period
ECNM_CALENDAR_NAME VARCHAR2 (40)
Enterprise calendar name
ECNM_CALENDAR_TYPE VARCHAR2 (40)
Enterprise calendar type
ECNM_CAL_NAME VARCHAR2 (80)
Enterprise calendar name
ECNM_CAL_NAME_PK VARCHAR2 (120)
The unique identifier for the enterprise calendar
ECNM_DESCRIPTION VARCHAR2 (240)
Enterprise calendar description
ECNM_INSTANCE VARCHAR2 (40)
Instance identifier
ECNM_NAME VARCHAR2 (2000)
Enterprise calendar name
ECYR_CAL_YEAR VARCHAR2 (40)
Enterprise calendar year name
ECYR_CAL_YEAR_PK VARCHAR2 (120)
The unique identifier for enterprise calendar year
ECYR_INSTANCE VARCHAR2 (40)
Instance identifier
ECYR_NAME VARCHAR2 (100)
Enterprise calendar year name
ECQR_CAL_QTR VARCHAR2 (40)
Enterprise calendar quarter name
ECQR_CAL_QTR_PK VARCHAR2 (120)
The unique identifier for enterprise calendar quarter
ECQR_INSTANCE VARCHAR2 (40)
Instance identifier
ECQR_NAME VARCHAR2 (100)
Enterprise calendar quarter name
ECPR_CAL_PERIOD VARCHAR2 (40)
Enterprise calendar period name
ECPR_CAL_PERIOD_PK VARCHAR2 (120)
The unique identifier for enterprise calendar period
ECPR_INSTANCE VARCHAR2 (40)
Instance identifier
ECPR_NAME VARCHAR2 (100)
Enterprise calendar period name
CDAY_CALENDAR_DATE DATE

Calendar date
CDAY_END_DATE DATE

Calendar day end date
CPER_END_DATE DATE

Calendar period end date
CPER_START_DATE DATE

Calendar period start date
PPER_END_DATE DATE

PA period end date
PPER_START_DATE DATE

PA period start date
CQTR_END_DATE DATE

Calendar year end date
CQTR_START_DATE DATE

Calendar quarter start date
CYR_END_DATE DATE

Calendar year end date
CYR_START_DATE DATE

Calendar year start date
CNAM_END_DATE DATE

Calendar end date
DAY_END_DATE DATE

Day end date
DAY_JULIAN_DAY NUMBER

Indicate the date in Julian format.
DAY_START_DATE DATE

Day start date
WEEK_END_DATE DATE

Week end date
WEEK_START_DATE DATE

week start date
MNTH_END_DATE DATE

Month end date
MNTH_START_DATE DATE

Month start date
HMNT_END_DATE DATE

Half month end date
HMNT_START_DATE DATE

Half month start date
YEAR_END_DATE DATE

Year end date
YEAR_START_DATE DATE

Year start date
P445_END_DATE DATE

445 period end date
P445_START_DATE DATE

445 period start date
ECNM_END_DATE DATE

Enterprise calendar end date
ECYR_END_DATE DATE

Enterprise calendar year end date
ECYR_START_DATE DATE

Enterprise calendar year start date
ECQR_END_DATE DATE

Enterprise calendar quarter end date
ECQR_START_DATE DATE

Enterprise calendar quarter start date
ECPR_END_DATE DATE

Enterprise calendar period end date
ECPR_START_DATE DATE

Enterprise calendar period start date
HYR_END_DATE DATE

Half year end date
HYR_HALF_YEAR VARCHAR2 (40)
Half year name
HYR_HALF_YEAR_PK VARCHAR2 (20)
The unique identifier for half year
HYR_HALF_YEAR_PK_KEY NUMBER

System generated unique identifier for half year
HYR_INSTANCE VARCHAR2 (40)
Instance identifier
HYR_NAME VARCHAR2 (100)
Half year name
HYR_START_DATE DATE

Half year start date
HYR_TIMESPAN NUMBER

The duration of this half year in days
QTR_END_DATE DATE

Quarter end date
QTR_INSTANCE VARCHAR2 (40)
Instance identifier
QTR_NAME VARCHAR2 (100)
Quarter name
QTR_QTR VARCHAR2 (40)
Quarter name
QTR_QTR_PK VARCHAR2 (20)
The unique identifier for quarter
QTR_QTR_PK_KEY NUMBER

System generated unique identifier for quarter
QTR_START_DATE DATE

Quarter start date
QTR_TIMESPAN NUMBER

The duration of this quarter in days
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CDAY_EFFECTIVE_PERIOD_NUM NUMBER (15)
General Ledger effective period number
CDAY_PERIOD_SET_NAME VARCHAR2 (15)
General Ledger calendar name
CDAY_PERIOD_TYPE VARCHAR2 (15)
General Ledger period type
Query Text

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


SELECT CDAY_CAL_DAY_PK_KEY
,      CDAY_TIMESPAN
,      CPER_CAL_PERIOD_PK_KEY
,      CPER_TIMESPAN
,      PPER_PA_PERIOD_PK_KEY
,      PPER_TIMESPAN
,      CQTR_CAL_QTR_PK_KEY
,      CQTR_TIMESPAN
,      CYR_CAL_YEAR_PK_KEY
,      CYR_TIMESPAN
,      CNAM_CAL_NAME_PK_KEY
,      CNAM_TIMESPAN
,      ALL_ALL_PK_KEY
,      DAY_DAY_OF_YEAR
,      DAY_DAY_PK_KEY
,      DAY_TIMESPAN
,      WEEK_TIMESPAN
,      WEEK_WEEK_NUMBER
,      WEEK_WEEK_PK_KEY
,      MNTH_MONTH_PK_KEY
,      MNTH_TIMESPAN
,      HMNT_HALF_MONTH_PK_KEY
,      HMNT_TIMESPAN
,      YEAR_TIMESPAN
,      YEAR_YEAR_PK_KEY
,      P445_PERIOD445_NUMBER
,      P445_PERIOD_445_PK_KEY
,      P445_TIMESPAN
,      ECNM_CAL_NAME_PK_KEY
,      ECYR_CAL_YEAR_PK_KEY
,      ECQR_CAL_QTR_PK_KEY
,      ECPR_CAL_PERIOD_PK_KEY
,      ECNM_TIMESPAN
,      ECYR_TIMESPAN
,      ECQR_TIMESPAN
,      ECPR_TIMESPAN
,      CDAY_CAL_DAY
,      CDAY_CAL_DAY_PK
,      CDAY_HOLIDAY_FLAG
,      CDAY_INSTANCE
,      CDAY_NAME
,      CDAY_WORK_DAY_FLAG
,      CPER_CAL_PERIOD_PK
,      CPER_INSTANCE
,      CPER_NAME
,      CPER_PERIOD_NAME
,      PPER_INSTANCE
,      PPER_NAME
,      PPER_PA_PERIOD
,      PPER_PA_PERIOD_PK
,      CQTR_CAL_QTR
,      CQTR_CAL_QTR_PK
,      CQTR_INSTANCE
,      CQTR_NAME
,      CYR_CAL_YEAR
,      CYR_CAL_YEAR_PK
,      CYR_INSTANCE
,      CYR_NAME
,      CNAM_CALENDAR_TYPE
,      CNAM_CAL_NAME
,      CNAM_CAL_NAME_PK
,      CNAM_INSTANCE
,      CNAM_NAME
,      ALL_ALL_PK
,      ALL_NAME
,      DAY_DAY
,      DAY_DAY_OF_WEEK
,      DAY_DAY_PK
,      DAY_INSTANCE
,      DAY_NAME
,      DAY_WEEKEND_FLAG
,      WEEK_INSTANCE
,      WEEK_NAME
,      WEEK_WEEK
,      WEEK_WEEK_PK
,      MNTH_INSTANCE
,      MNTH_MONTH
,      MNTH_MONTH_PK
,      MNTH_NAME
,      HMNT_HALF_MONTH
,      HMNT_HALF_MONTH_NAME
,      HMNT_HALF_MONTH_PK
,      HMNT_INSTANCE
,      HMNT_NAME
,      YEAR_INSTANCE
,      YEAR_NAME
,      YEAR_YEAR
,      YEAR_YEAR_PK
,      P445_INSTANCE
,      P445_NAME
,      P445_PERIOD_445
,      P445_PERIOD_445_PK
,      ECNM_CALENDAR_NAME
,      ECNM_CALENDAR_TYPE
,      ECNM_CAL_NAME
,      ECNM_CAL_NAME_PK
,      ECNM_DESCRIPTION
,      ECNM_INSTANCE
,      ECNM_NAME
,      ECYR_CAL_YEAR
,      ECYR_CAL_YEAR_PK
,      ECYR_INSTANCE
,      ECYR_NAME
,      ECQR_CAL_QTR
,      ECQR_CAL_QTR_PK
,      ECQR_INSTANCE
,      ECQR_NAME
,      ECPR_CAL_PERIOD
,      ECPR_CAL_PERIOD_PK
,      ECPR_INSTANCE
,      ECPR_NAME
,      CDAY_CALENDAR_DATE
,      CDAY_END_DATE
,      CPER_END_DATE
,      CPER_START_DATE
,      PPER_END_DATE
,      PPER_START_DATE
,      CQTR_END_DATE
,      CQTR_START_DATE
,      CYR_END_DATE
,      CYR_START_DATE
,      CNAM_END_DATE
,      DAY_END_DATE
,      DAY_JULIAN_DAY
,      DAY_START_DATE
,      WEEK_END_DATE
,      WEEK_START_DATE
,      MNTH_END_DATE
,      MNTH_START_DATE
,      HMNT_END_DATE
,      HMNT_START_DATE
,      YEAR_END_DATE
,      YEAR_START_DATE
,      P445_END_DATE
,      P445_START_DATE
,      ECNM_END_DATE
,      ECYR_END_DATE
,      ECYR_START_DATE
,      ECQR_END_DATE
,      ECQR_START_DATE
,      ECPR_END_DATE
,      ECPR_START_DATE
,      HYR_END_DATE
,      HYR_HALF_YEAR
,      HYR_HALF_YEAR_PK
,      HYR_HALF_YEAR_PK_KEY
,      HYR_INSTANCE
,      HYR_NAME
,      HYR_START_DATE
,      HYR_TIMESPAN
,      QTR_END_DATE
,      QTR_INSTANCE
,      QTR_NAME
,      QTR_QTR
,      QTR_QTR_PK
,      QTR_QTR_PK_KEY
,      QTR_START_DATE
,      QTR_TIMESPAN
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CDAY_EFFECTIVE_PERIOD_NUM
,      CDAY_PERIOD_SET_NAME
,      CDAY_PERIOD_TYPE
FROM FII.EDW_TIME_M;

Dependencies

[top of page]

FII.EDW_TIME_M does not reference any database object

FII.EDW_TIME_M is referenced by following:

SchemaAPPS
SynonymEDW_TIME_M