[Home] [Help] [Dependency Information]
Object Name: | EDW_PROJ_TOP_TASK_LTC |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.EDW_PROJ_TOP_TASK_LTC |
Subobject Name: | |
Status: | VALID |
This is the top task level table within the Projects dimension. This table contains the top level tasks within each project. It stores specific attribute information for the top tasks.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_PROJ_TOP_TASK_LTC_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY | TOP_TASK_PK_KEY |
EDW_PROJ_TOP_TASK_LTC_U2 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
TOP_TASK_PK
TOP_TASK_PK_KEY |
EDW_PROJ_TOP_TASK_LTC_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | PROJECT_FK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROJECT_FK_KEY | NUMBER | System generated foreign key to the project level | ||
TOP_TASK_PK_KEY | NUMBER | System generated unique identifier for the top task | ||
INSTANCE | VARCHAR2 | (40) | Instance identifier | |
LABOR_COST_MULT | VARCHAR2 | (40) | The labor cost multiplier defined for the task of a premium project | |
NAME | VARCHAR2 | (2000) | Top task name | |
PROJECT_FK | VARCHAR2 | (80) | Foreign key to the project level | |
SERVICE_TYPE_CODE | VARCHAR2 | (40) | The type of work performed on the task | |
TOP_TASK | VARCHAR2 | (80) | Top task name | |
TOP_TASK_PK | VARCHAR2 | (120) | The unique identifier for the top task | |
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. | ||
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
TASK_END_DATE | DATE | The date on which the task completes | ||
TASK_START_DATE | DATE | The date on which the task starts | ||
TASK_NUMBER | VARCHAR2 | (60) | Task Number |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_FK_KEY
, TOP_TASK_PK_KEY
, INSTANCE
, LABOR_COST_MULT
, NAME
, PROJECT_FK
, SERVICE_TYPE_CODE
, TOP_TASK
, TOP_TASK_PK
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, CREATION_DATE
, LAST_UPDATE_DATE
, TASK_END_DATE
, TASK_START_DATE
, TASK_NUMBER
FROM FII.EDW_PROJ_TOP_TASK_LTC;
FII.EDW_PROJ_TOP_TASK_LTC does not reference any database object
FII.EDW_PROJ_TOP_TASK_LTC is referenced by following:
|
|
|