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: HR.HR_360_PER_REPORTEE

Object Details

Object Name:	HR_360_PER_REPORTEE
Object Type:	TABLE
Owner:	HR
Subobject Name:
Status:	VALID

HR_360_PER_REPORTEE is the table that holds the Reportee information delivered in the 360 Response message in HR HelpDesk.The 360 Response XML message is generated with this information in the XML Gateway.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
SUPERVISOR_ID	VARCHAR2	(30)	Supervisor Id.
REPORTEE_NAME	VARCHAR2	(240)	Reportee Name.
REPORTEE_EMP_NUMBER	VARCHAR2	(30)	Reportee Employee Number.
REPORTEE_ASG_STATUS	VARCHAR2	(80)	Reportee Assignment Status.
EFFECTIVE_STATUS_DATE	DATE		Effective Status Date.
EVENT_KEY	VARCHAR2	(240)	Event Key.

Query Text

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


SELECT SUPERVISOR_ID
,      REPORTEE_NAME
,      REPORTEE_EMP_NUMBER
,      REPORTEE_ASG_STATUS
,      EFFECTIVE_STATUS_DATE
,      EVENT_KEY
FROM HR.HR_360_PER_REPORTEE;

Dependencies

[top of page]

HR.HR_360_PER_REPORTEE does not reference any database object

HR.HR_360_PER_REPORTEE is referenced by following:

APPS: HR_360_PER_REPORTEE