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_RPT_TC_AUDIT

Object Details

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

Temporary table used for holding and reporting Timecard Audit Data.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
TIME_ENTRY_DATE	DATE		Date for which time is entered for
ATTRIBUTE_INFO	VARCHAR2	(1500)	List of User Entered fields from the timecard
HOURS	NUMBER		Hours recorded for these attributes
ACTION	VARCHAR2	(30)	Kind of action - new,edit,delete etc.
ACTION_DATE	DATE		creation date
ACTION_BY	VARCHAR2	(400)	action by
COMMENTS	VARCHAR2	(2000)	comments
REASONS	VARCHAR2	(150)	Reasons
TRANSACTION_ID	NUMBER	(22)	Transaction_id for deposit
DETAIL_BB_ID	NUMBER		detail building_block_id
DETAIL_BB_OVN	NUMBER		OVN of detail bb id
TC_BB_ID	NUMBER		timecard_id
TC_BB_OVN	NUMBER		timecard_ovn
ACTION_TYPE	VARCHAR2	(30)	Action type - timecard level or detail level
RESOURCE_ID	NUMBER	(15)	Person id
TC_START_TIME	DATE		timecard start time
TC_STOP_TIME	DATE		timecard stop time
ACTION_BY_PERSON	VARCHAR2	(240)	Action_by's full_name
CLA_REASON	VARCHAR2	(310)	CLA reason
RESOURCE_NAME	VARCHAR2	(300)	Full_name of resource_id
START_STOP_TIME	VARCHAR2	(30)	time, if entered in timecard with a start_stop time instead of hours

Query Text

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


SELECT TIME_ENTRY_DATE
,      ATTRIBUTE_INFO
,      HOURS
,      ACTION
,      ACTION_DATE
,      ACTION_BY
,      COMMENTS
,      REASONS
,      TRANSACTION_ID
,      DETAIL_BB_ID
,      DETAIL_BB_OVN
,      TC_BB_ID
,      TC_BB_OVN
,      ACTION_TYPE
,      RESOURCE_ID
,      TC_START_TIME
,      TC_STOP_TIME
,      ACTION_BY_PERSON
,      CLA_REASON
,      RESOURCE_NAME
,      START_STOP_TIME
FROM HXC.HXC_RPT_TC_AUDIT;

Dependencies

[top of page]

HXC.HXC_RPT_TC_AUDIT does not reference any database object

HXC.HXC_RPT_TC_AUDIT is referenced by following:

APPS: HXC_RPT_TC_AUDIT