DBA Data[Home] [Help] [Dependency Information]


TABLE: HXC.HXC_RDB_POST_PARTIAL_TIMECARDS

Object Details
Object Name: HXC_RDB_POST_PARTIAL_TIMECARDS
Object Type: TABLE
Owner: HXC
FND Design Data: TableHXC.HXC_RDB_POST_PARTIAL_TIMECARDS
Subobject Name:
Status: VALID


Used for Retrieval Dashboard Post Tab


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HXC_RDB_POST_PARTIAL_TCS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRET_USER_ID
ColumnBATCH_ID
Columns
Name Datatype Length Mandatory Comments
START_TIME DATE

Start date of the timecard
STOP_TIME DATE

End date of the timecard
TIMECARDS NUMBER (15)
Number of partial timecards
RET_USER_ID NUMBER (15)
User id is foreign key to FND_USER.USER_ID
BATCH_ID VARCHAR2 (400)
Batch id is id of the batch processed
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT START_TIME
,      STOP_TIME
,      TIMECARDS
,      RET_USER_ID
,      BATCH_ID
FROM HXC.HXC_RDB_POST_PARTIAL_TIMECARDS;

Dependencies

[top of page]

HXC.HXC_RDB_POST_PARTIAL_TIMECARDS does not reference any database object

HXC.HXC_RDB_POST_PARTIAL_TIMECARDS is referenced by following:

SchemaHXC
ViewHXC_RDB_POST_PARTIAL_TIMECARD#