eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: HXC.HXC_TIMECARD_SUMMARY

Object Details

Object Name:	HXC_TIMECARD_SUMMARY
Object Type:	TABLE
Owner:	HXC
FND Design Data:	HXC.HXC_TIMECARD_SUMMARY
Subobject Name:
Status:	VALID

The HXC_TIMECARD_SUMMARY table denormalizes data about timecards for performance purposees. It also enables the entry level approval functionality.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HXC_TIMECARD_SUMMARY_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	TIMECARD_ID
HXC_TIMECARD_SUMMARY_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_ID START_TIME
HXC_TIMECARD_SUMMARY_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DATA_SET_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TIMECARD_ID	NUMBER		Yes	The timecard id
TIMECARD_OVN	NUMBER		Yes	The object version number of the timecard.
APPROVAL_STATUS	VARCHAR2	(30)	Yes	The timecard approval status
RESOURCE_ID	NUMBER		Yes	The resource id of this timecard.
START_TIME	DATE		Yes	The start time of the timecard
STOP_TIME	DATE		Yes	The stop time of the timecard
RECORDED_HOURS	NUMBER		Yes	The total number of hours in the timecard.
HAS_REASONS	VARCHAR2	(1)	Yes	Whether change and late audit reasons are associated with the timecard.
SUBMISSION_DATE	DATE			The submission date of the timecard.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Standard flexfield column
ATTRIBUTE1	VARCHAR2	(150)		Standard flexfield column
ATTRIBUTE2	VARCHAR2	(150)		Standard flexfield column
ATTRIBUTE3	VARCHAR2	(150)		Standard flexfield column
ATTRIBUTE4	VARCHAR2	(150)		Standard flexfield column
ATTRIBUTE5	VARCHAR2	(150)		Standard flexfield column
ATTRIBUTE6	VARCHAR2	(150)		Standard flexfield column
ATTRIBUTE7	VARCHAR2	(150)		Standard flexfield column
ATTRIBUTE8	VARCHAR2	(150)		Standard flexfield column
ATTRIBUTE9	VARCHAR2	(150)		Standard flexfield column
ATTRIBUTE10	VARCHAR2	(150)		Standard flexfield column
ATTRIBUTE11	VARCHAR2	(150)		Standard flexfield column
ATTRIBUTE12	VARCHAR2	(150)		Standard flexfield column
ATTRIBUTE13	VARCHAR2	(150)		Standard flexfield column
ATTRIBUTE14	VARCHAR2	(150)		Standard flexfield column
ATTRIBUTE15	VARCHAR2	(150)		Standard flexfield column
ATTRIBUTE16	VARCHAR2	(150)		Standard flexfield column
ATTRIBUTE17	VARCHAR2	(150)		Standard flexfield column
ATTRIBUTE18	VARCHAR2	(150)		Standard flexfield column
ATTRIBUTE19	VARCHAR2	(150)		Standard flexfield column
ATTRIBUTE20	VARCHAR2	(150)		Standard flexfield column
ATTRIBUTE21	VARCHAR2	(150)		Standard flexfield column
ATTRIBUTE22	VARCHAR2	(150)		Standard flexfield column
ATTRIBUTE23	VARCHAR2	(150)		Standard flexfield column
ATTRIBUTE24	VARCHAR2	(150)		Standard flexfield column
ATTRIBUTE25	VARCHAR2	(150)		Standard flexfield column
ATTRIBUTE26	VARCHAR2	(150)		Standard flexfield column
ATTRIBUTE27	VARCHAR2	(150)		Standard flexfield column
ATTRIBUTE28	VARCHAR2	(150)		Standard flexfield column
ATTRIBUTE29	VARCHAR2	(150)		Standard flexfield column
ATTRIBUTE30	VARCHAR2	(150)		Standard flexfield column
APPROVAL_ITEM_TYPE	VARCHAR2	(8)		Item Type for The Approval Process of the Timecard
APPROVAL_PROCESS_NAME	VARCHAR2	(30)		Workflow Process name
APPROVAL_ITEM_KEY	VARCHAR2	(240)		Approval Item Key
TK_AUDIT_ITEM_TYPE	VARCHAR2	(8)		Audit Timekeeper Item Type
TK_AUDIT_PROCESS_NAME	VARCHAR2	(30)		Timekeeper Audit Process
TK_AUDIT_ITEM_KEY	VARCHAR2	(240)		Timekeeper Audit Item Key
DATA_SET_ID	NUMBER	(15)		Data Set Id

Query Text

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


SELECT TIMECARD_ID
,      TIMECARD_OVN
,      APPROVAL_STATUS
,      RESOURCE_ID
,      START_TIME
,      STOP_TIME
,      RECORDED_HOURS
,      HAS_REASONS
,      SUBMISSION_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      APPROVAL_ITEM_TYPE
,      APPROVAL_PROCESS_NAME
,      APPROVAL_ITEM_KEY
,      TK_AUDIT_ITEM_TYPE
,      TK_AUDIT_PROCESS_NAME
,      TK_AUDIT_ITEM_KEY
,      DATA_SET_ID
FROM HXC.HXC_TIMECARD_SUMMARY;

Dependencies

[top of page]

HXC.HXC_TIMECARD_SUMMARY does not reference any database object

HXC.HXC_TIMECARD_SUMMARY is referenced by following:

APPS: HXC_TIMECARD_SUMMARY