[Home] [Help] [Dependency Information]
Object Name: | EDW_TIME_HALF_MONTH_LTC |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.EDW_TIME_HALF_MONTH_LTC |
Subobject Name: | |
Status: | VALID |
This is the half month level table in the time dimension. This table stores one record for every half month in the standard daily calender. Each month is composed of two half months. The first half is define to be the 1st to 14th of each month; the second half is defined to be the 15th to the end of each month.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_TIME_HALF_MONTH_LTC_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY | HALF_MONTH_PK_KEY |
EDW_TIME_HALF_MONTH_LTC_U2 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
HALF_MONTH_PK
HALF_MONTH_PK_KEY |
EDW_TIME_HALF_MONTH_LTC_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | MONTH_FK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HALF_MONTH_PK_KEY | NUMBER | System generated unique identifier for the half month | ||
MONTH_FK_KEY | NUMBER | System generated foreign key to the month level | ||
TIMESPAN | NUMBER | The duration of this time period | ||
HALF_MONTH | VARCHAR2 | (80) | Half month name | |
HALF_MONTH_NAME | VARCHAR2 | (40) | Half month name | |
HALF_MONTH_PK | VARCHAR2 | (20) | The unique identifier for the half month | |
INSTANCE | VARCHAR2 | (40) | Instance identifier | |
MONTH_FK | VARCHAR2 | (20) | Foreign key to the month level | |
NAME | VARCHAR2 | (2000) | Half month name | |
USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
END_DATE | DATE | The end date of this time period | ||
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
START_DATE | DATE | The start date of this time period |
Cut, paste (and edit) the following text to query this object:
SELECT HALF_MONTH_PK_KEY
, MONTH_FK_KEY
, TIMESPAN
, HALF_MONTH
, HALF_MONTH_NAME
, HALF_MONTH_PK
, INSTANCE
, MONTH_FK
, NAME
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, CREATION_DATE
, END_DATE
, LAST_UPDATE_DATE
, START_DATE
FROM FII.EDW_TIME_HALF_MONTH_LTC;
FII.EDW_TIME_HALF_MONTH_LTC does not reference any database object
FII.EDW_TIME_HALF_MONTH_LTC is referenced by following:
|
|
|