[Home] [Help] [Dependency Information]
Object Name: | EDW_TIME_PERIOD_445_LTC |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.EDW_TIME_PERIOD_445_LTC |
Subobject Name: | |
Status: | VALID |
This is the 445 period level table in the time dimension. It stores one record for every 445 period. Each year is composed of twelve 445 periods. 445 periods are defined to be either 4 weeks or 5 weeks long. The first period is composed of the first 4 weeks of a given year. The next 4 weeks composed the second period. The next 5 weeks compose the third period. The cycle of 4-4-5 weeks continues until the end of the year. Since each year contains 52 weeks, this method creates twelve periods. A typical manufacturing facility often uses 445 calenders.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_TIME_PERIOD_445_LTC_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY | PERIOD_445_PK_KEY |
EDW_TIME_PERIOD_445_LTC_U2 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
PERIOD_445_PK
PERIOD_445_PK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ALL_FK_KEY | NUMBER | System generated foreign key to the top level of the time dimension | ||
PERIOD445_NUMBER | NUMBER | Numbers the 445 periods within a year | ||
PERIOD_445_PK_KEY | NUMBER | System generated unique identifier for the 445 period | ||
TIMESPAN | NUMBER | The duration of this time period | ||
ALL_FK | VARCHAR2 | (40) | Foreign key to the top level of the time dimension | |
INSTANCE | VARCHAR2 | (40) | Instance identifier | |
NAME | VARCHAR2 | (2000) | 445 period name | |
PERIOD_445 | VARCHAR2 | (80) | 445 period name | |
PERIOD_445_PK | VARCHAR2 | (20) | The unique identifier for the 445 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 | |
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 ALL_FK_KEY
, PERIOD445_NUMBER
, PERIOD_445_PK_KEY
, TIMESPAN
, ALL_FK
, INSTANCE
, NAME
, PERIOD_445
, PERIOD_445_PK
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, CREATION_DATE
, END_DATE
, LAST_UPDATE_DATE
, START_DATE
FROM FII.EDW_TIME_PERIOD_445_LTC;
FII.EDW_TIME_PERIOD_445_LTC does not reference any database object
FII.EDW_TIME_PERIOD_445_LTC is referenced by following:
|
|
|