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_TCD_TMP_RPT

Object Details

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

Reference table for Timecard Dashboard

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
RESOURCE_ID	NUMBER	(15)	Resource ID
REC_PERIOD_ID	NUMBER	(15)	Recurring Period ID selected on Timecard Dashboard
PERIOD_START_DATE	DATE		Start Date of Timecard Period selected on Timecard Dashboard
PERIOD_END_DATE	DATE		End Date of Timecard Period selected on Timecard Dashboard
SUPERVISOR_ID	NUMBER	(15)	Supervisor in Hierarchy selected on Timecard Dashboard
LOCATION_ID	NUMBER	(15)	Location ID selected on Timecard Dashboard
ORGANIZATION_ID	NUMBER	(15)	Organization ID selected on Timecard Dashboard
SEL_SUPERVISOR_ID	NUMBER	(15)	Supervisor ID for the selected summary link on Timecard Dashboard
SEL_TC_STATUS	VARCHAR2	(20)	Timecard Status for the selected summary link on Timecard Dashboard
RPT_STATUS	VARCHAR2	(20)	Status of Timecard Dashboard Report
PERSON_TYPE	VARCHAR2	(30)	Person Type on Timecard Dashboard Report
PERSON_NAME	VARCHAR2	(240)	Person Name on Timecard Dashboard Report
PERSON_NUMBER	NUMBER	(15)	Person Number on Timecard Dashboard Report
APPROVAL_STATUS	VARCHAR2	(20)	Timecard Status on Timecard Dashboard Report
SUPERVISOR	VARCHAR2	(240)	Supervisor on Timecard Dashboard Report
ORGANIZATION	VARCHAR2	(240)	Organization on Timecard Dashboard Report
LOCATION	VARCHAR2	(240)	Location on Timecard Dashboard Report
PAYROLL	VARCHAR2	(240)	Payroll on Timecard Dashboard Report
APPLICATION	VARCHAR2	(240)	Recipient Application
TC_START_DATE	DATE		Timecard Start Date on Timecard Dashboard Report
TC_END_DATE	DATE		Timecard End Date on Timecard Dashboard Report
LAST_MODIFIED_BY	VARCHAR2	(100)	Last Modified User
LAST_MODIFIED_DATE	DATE		Last Modified Date

Query Text

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


SELECT RESOURCE_ID
,      REC_PERIOD_ID
,      PERIOD_START_DATE
,      PERIOD_END_DATE
,      SUPERVISOR_ID
,      LOCATION_ID
,      ORGANIZATION_ID
,      SEL_SUPERVISOR_ID
,      SEL_TC_STATUS
,      RPT_STATUS
,      PERSON_TYPE
,      PERSON_NAME
,      PERSON_NUMBER
,      APPROVAL_STATUS
,      SUPERVISOR
,      ORGANIZATION
,      LOCATION
,      PAYROLL
,      APPLICATION
,      TC_START_DATE
,      TC_END_DATE
,      LAST_MODIFIED_BY
,      LAST_MODIFIED_DATE
FROM HXC.HXC_TCD_TMP_RPT;

Dependencies

[top of page]

HXC.HXC_TCD_TMP_RPT does not reference any database object

HXC.HXC_TCD_TMP_RPT is referenced by following:

APPS: HXC_TCD_TMP_RPT