[Home] [Help] [Dependency Information]
Object Name: | HXC_RDB_PRE_TIMECARDS |
---|---|
Object Type: | TABLE |
Owner: | HXC |
FND Design Data: | HXC.HXC_RDB_PRE_TIMECARDS |
Subobject Name: | |
Status: | VALID |
Used for Retrieval Dashboard Pre Retrieval Timecards
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HXC_RDB_PRE_TIMECARDS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | RET_USER_ID |
HXC_RDB_PRE_TIMECARDS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
RET_USER_ID
APPROVAL_STATUS |
HXC_RDB_PRE_TIMECARDS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
RET_USER_ID
APPROVAL_STATUS LAST_UPDATED_BY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESOURCE_ID | NUMBER | (15) | Yes | person id of resource |
APPROVAL_STATUS | VARCHAR2 | (30) | Yes | Approval Status of timecard |
TIMECARD_ID | NUMBER | Yes | Time building block id of timecard | |
START_TIME | DATE | Yes | start date of the timecard | |
STOP_TIME | DATE | Yes | End date of the timecard | |
LAST_UPDATED_BY | NUMBER | User Id who last updated timecard | ||
RET_USER_ID | NUMBER | User id is foreign key to FND_USER.USER_ID | ||
LU_BB_ID | NUMBER | Building block Id | ||
LU_OVN | NUMBER | Object Version Number | ||
SUPERVISOR_ID | NUMBER | per_all_people_f.PERSON_ID of supervisor | ||
EMP_NAME | VARCHAR2 | (400) | Employee Name | |
EMP_NO | VARCHAR2 | (400) | Employee Number | |
LAST_UPDATE_DATE | DATE | Last Update Date |
Cut, paste (and edit) the following text to query this object:
SELECT RESOURCE_ID
, APPROVAL_STATUS
, TIMECARD_ID
, START_TIME
, STOP_TIME
, LAST_UPDATED_BY
, RET_USER_ID
, LU_BB_ID
, LU_OVN
, SUPERVISOR_ID
, EMP_NAME
, EMP_NO
, LAST_UPDATE_DATE
FROM HXC.HXC_RDB_PRE_TIMECARDS;
HXC.HXC_RDB_PRE_TIMECARDS does not reference any database object
HXC.HXC_RDB_PRE_TIMECARDS is referenced by following:
|
|
|