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

TABLE: CSD.CSD_TIME_CLOCK_ENTRIES

Object Details
Object Name: CSD_TIME_CLOCK_ENTRIES
Object Type: TABLE
Owner: CSD
FND Design Data: TableCSD.CSD_TIME_CLOCK_ENTRIES
Subobject Name:
Status: VALID


Stores Clock-in and Clock-out information for time clock


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CSD_TIME_CLOCK_ENTRIES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTIME_CLOCK_ENTRY_ID
Columns
Name Datatype Length Mandatory Comments
TIME_CLOCK_ENTRY_ID NUMBER
Yes Entity Identifier/Primary Key
OBJECT_VERSION_NUMBER NUMBER
Yes Standard Column
CREATED_BY NUMBER
Yes Standard Column
CREATION_DATE DATE
Yes Standard Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Column
LAST_UPDATE_DATE DATE
Yes Standard Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Column
REPAIR_LINE_ID NUMBER (15) Yes Repair Order Id
WIP_ENTITY_ID NUMBER

Repair Job Id
OPERATION_SEQ_NUM NUMBER

Repair Job Operation Sequence
RESOURCE_ID NUMBER

Resource Id
EMPLOYEE_ID NUMBER (15)
Employee Id
CLOCK_IN_TIME DATE
Yes Time at clock-in
CLOCK_OUT_TIME DATE

Time at clock-out
Query Text

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


SELECT TIME_CLOCK_ENTRY_ID
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REPAIR_LINE_ID
,      WIP_ENTITY_ID
,      OPERATION_SEQ_NUM
,      RESOURCE_ID
,      EMPLOYEE_ID
,      CLOCK_IN_TIME
,      CLOCK_OUT_TIME
FROM CSD.CSD_TIME_CLOCK_ENTRIES;

Dependencies

[top of page]

CSD.CSD_TIME_CLOCK_ENTRIES does not reference any database object

CSD.CSD_TIME_CLOCK_ENTRIES is referenced by following:

SchemaCSD
ViewCSD_TIME_CLOCK_ENTRIES#