[Home] [Help] [Dependency Information]
Object Name: | EDW_PROJ_TOP_TASK_LSTG |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.EDW_PROJ_TOP_TASK_LSTG |
Subobject Name: | |
Status: | VALID |
This is the staging table for top task level table. Before task information is loaded into the warehouse, data is temporarily held in the staging table for verification and cleansing.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_PROJ_TOP_TASK_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | TOP_TASK_PK |
EDW_PROJ_TOP_TASK_LSTG_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | COLLECTION_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROJECT_FK_KEY | NUMBER | System generated foreign key to the project 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). | ||
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 | |
LABOR_COST_MULT | VARCHAR2 | (40) | The labor cost multiplier defined for the task of a premium project | |
NAME | VARCHAR2 | (2000) | Top task name | |
OPERATION_CODE | VARCHAR2 | (30) | Code used by the collection program to determine whether to insert/update/delete this record | |
PROJECT_FK | VARCHAR2 | (80) | Foreign key to the project level | |
ROW_ID | ROWID | (10) | Row identifier | |
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 | |
DELETION_DATE | DATE | Deletion date of the record | ||
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
, REQUEST_ID
, COLLECTION_STATUS
, ERROR_CODE
, INSTANCE
, LABOR_COST_MULT
, NAME
, OPERATION_CODE
, PROJECT_FK
, ROW_ID
, SERVICE_TYPE_CODE
, TOP_TASK
, TOP_TASK_PK
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, DELETION_DATE
, TASK_END_DATE
, TASK_START_DATE
, TASK_NUMBER
FROM FII.EDW_PROJ_TOP_TASK_LSTG;
FII.EDW_PROJ_TOP_TASK_LSTG does not reference any database object
FII.EDW_PROJ_TOP_TASK_LSTG is referenced by following:
|
|
|