[Home] [Help] [Dependency Information]
Object Name: | EDW_TIME_EP_CAL_YEAR_LSTG |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.EDW_TIME_EP_CAL_YEAR_LSTG |
Subobject Name: | |
Status: | VALID |
This is the interface table for enterprise calendar year level table. Data from multiple transactional systems is staged here for verification and cleansing, before loading it into the dimension level table.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_TIME_EP_CAL_YEAR_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | CAL_YEAR_PK |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CALENDAR_YEAR | NUMBER | Unique year name within the enterprise calendar | ||
CAL_NAME_FK_KEY | NUMBER | Foreign key to the enterprise calender level | ||
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
TIMESPAN | NUMBER | The duration of this time period | ||
CAL_NAME_FK | VARCHAR2 | (120) | Foreign key to the enterprise calender level | |
CAL_YEAR | VARCHAR2 | (80) | Display name of the year within the enterprise calendar | |
CAL_YEAR_PK | VARCHAR2 | (120) | The unique identifier for the year level within the enterprise calendar | |
COLLECTION_STATUS | VARCHAR2 | (30) | Collection status code for the record | |
ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
INSTANCE | VARCHAR2 | (40) | Instance identifier | |
NAME | VARCHAR2 | (2000) | Display name of the year within the enterprise calendar | |
OPERATION_CODE | VARCHAR2 | (30) | Code used by the collection program to determine whether to insert/update/delete this record | |
ROW_ID | ROWID | (10) | Row identifier | |
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 | |
DELETION_DATE | DATE | Deletion date of the record | ||
END_DATE | DATE | The end date of this time period | ||
START_DATE | DATE | The start date of this time period |
Cut, paste (and edit) the following text to query this object:
SELECT CALENDAR_YEAR
, CAL_NAME_FK_KEY
, REQUEST_ID
, TIMESPAN
, CAL_NAME_FK
, CAL_YEAR
, CAL_YEAR_PK
, COLLECTION_STATUS
, ERROR_CODE
, INSTANCE
, NAME
, OPERATION_CODE
, ROW_ID
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, DELETION_DATE
, END_DATE
, START_DATE
FROM FII.EDW_TIME_EP_CAL_YEAR_LSTG;
FII.EDW_TIME_EP_CAL_YEAR_LSTG does not reference any database object
FII.EDW_TIME_EP_CAL_YEAR_LSTG is referenced by following:
|
|
|