[Home] [Help] [Dependency Information]
Object Name: | EDW_TIME_HALF_YEAR_LTC |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.EDW_TIME_HALF_YEAR_LTC |
Subobject Name: | |
Status: | VALID |
This is the half year level table in the time dimension. This table stores one record for every half year in the standard daily calender. Each year is composed of two half years. The first half is define to start from January 1st to Jun 30th; the second half is defined to start from July 1st to December 31th.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_TIME_HALF_YEAR_LTC_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY | HALF_YEAR_PK_KEY |
EDW_TIME_HALF_YEAR_LTC_U2 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
HALF_YEAR_PK
HALF_YEAR_PK_KEY |
EDW_TIME_HALF_YEAR_LTC_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | YEAR_FK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
END_DATE | DATE | The end date of this time period | ||
HALF_YEAR | VARCHAR2 | (80) | Half year name | |
HALF_YEAR_PK | VARCHAR2 | (20) | The unique identifier of half year | |
HALF_YEAR_PK_KEY | NUMBER | System generated unique identifier of half year | ||
INSTANCE | VARCHAR2 | (40) | Instance identifier | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
NAME | VARCHAR2 | (2000) | Half year name | |
START_DATE | DATE | The start date of this time period | ||
TIMESPAN | NUMBER | The duration of this time period | ||
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 | |
YEAR_FK | VARCHAR2 | (20) | Foreign key to the year level | |
YEAR_FK_KEY | NUMBER | System generated foreign key to the year level |
Cut, paste (and edit) the following text to query this object:
SELECT CREATION_DATE
, END_DATE
, HALF_YEAR
, HALF_YEAR_PK
, HALF_YEAR_PK_KEY
, INSTANCE
, LAST_UPDATE_DATE
, NAME
, START_DATE
, TIMESPAN
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, YEAR_FK
, YEAR_FK_KEY
FROM FII.EDW_TIME_HALF_YEAR_LTC;
FII.EDW_TIME_HALF_YEAR_LTC does not reference any database object
FII.EDW_TIME_HALF_YEAR_LTC is referenced by following:
|
|
|