[Home] [Help] [Dependency Information]
Object Name: | EDW_TIME_HALF_YEAR_LSTG |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.EDW_TIME_HALF_YEAR_LSTG |
Subobject Name: | |
Status: | VALID |
This is the interface table for half 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_HALF_YEAR_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | HALF_YEAR_PK |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COLLECTION_STATUS | VARCHAR2 | (40) | Collection status code for the record | |
DELETION_DATE | DATE | Deletion date of the record | ||
END_DATE | DATE | The end date of this time period | ||
ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
HALF_YEAR | VARCHAR2 | (80) | Half year name | |
HALF_YEAR_PK | VARCHAR2 | (20) | The unique identifier of half year | |
INSTANCE | VARCHAR2 | (40) | Instance identifier | |
NAME | VARCHAR2 | (2000) | Half year name | |
OPERATION_CODE | VARCHAR2 | (40) | Code used by the collection program to determine whether to insert/update/delete this record | |
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). | ||
ROW_ID | VARCHAR2 | (20) | Row identifier | |
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 COLLECTION_STATUS
, DELETION_DATE
, END_DATE
, ERROR_CODE
, HALF_YEAR
, HALF_YEAR_PK
, INSTANCE
, NAME
, OPERATION_CODE
, REQUEST_ID
, ROW_ID
, START_DATE
, TIMESPAN
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, YEAR_FK
, YEAR_FK_KEY
FROM FII.EDW_TIME_HALF_YEAR_LSTG;
FII.EDW_TIME_HALF_YEAR_LSTG does not reference any database object
FII.EDW_TIME_HALF_YEAR_LSTG is referenced by following:
|
|
|