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: PSP.PSP_EFF_REPORTS

Object Details

Object Name:	PSP_EFF_REPORTS
Object Type:	TABLE
Owner:	PSP
FND Design Data:	PSP.PSP_EFF_REPORTS
Subobject Name:
Status:	VALID

Contains effort report process request information

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PSP_EFF_REPORTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	EFFORT_REPORT_ID
SYS_IL0000410030C00015$$	LOB	UNIQUE	APPS_TS_TX_DATA
PSP_EFF_REPORTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID PERSON_ID
PSP_EFF_REPORTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID START_DATE END_DATE CURRENCY_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
EFFORT_REPORT_ID	NUMBER	(15)	Yes	Person Effort Report Identifier
PERSON_ID	NUMBER	(9)	Yes	Person Identifier
FULL_NAME	VARCHAR2	(240)		Employee Full Name
START_DATE	DATE		Yes	Effort report period start date
END_DATE	DATE		Yes	Effort report period end date
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object version number
STATUS_CODE	VARCHAR2	(1)	Yes	Effort report status (N-New, A-Approved, S-Superceded, R-Rejected)
TEMPLATE_ID	NUMBER	(15)	Yes	Foreign key to PSP_REPORT_TEMPLATES_H
REQUEST_ID	NUMBER	(15)		PSP Create effort report process request identifier
CURRENCY_CODE	VARCHAR2	(3)	Yes	Currency Code
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Business Group Identifier
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of books identifier
SUPERCEDING_SUMMARY_LINE_ID	NUMBER	(15)		Effort report superceding summary line identifier
SUPERCEDING_REQUEST_ID	NUMBER	(15)		Effort report superceding request id
PERSON_XML	CLOB	(4000)		Person Level Effort Report XML data
MAILSTOP	VARCHAR2	(45)		Stores Employee Mailstop Value
EMPLOYEE_NUMBER	VARCHAR2	(30)		Stores Employee Number Value
EMP_PRIMARY_ORG_NAME	VARCHAR2	(240)		Stores Employee Primary Organization Name
EMP_PRIMARY_ORG_ID	VARCHAR2	(15)		Stores Employee Primary Organization Id
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
SUPERCEDING_PROGRAM_NAME	VARCHAR2	(240)		Superceding Program Name

Query Text

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


SELECT EFFORT_REPORT_ID
,      PERSON_ID
,      FULL_NAME
,      START_DATE
,      END_DATE
,      OBJECT_VERSION_NUMBER
,      STATUS_CODE
,      TEMPLATE_ID
,      REQUEST_ID
,      CURRENCY_CODE
,      BUSINESS_GROUP_ID
,      SET_OF_BOOKS_ID
,      SUPERCEDING_SUMMARY_LINE_ID
,      SUPERCEDING_REQUEST_ID
,      PERSON_XML
,      MAILSTOP
,      EMPLOYEE_NUMBER
,      EMP_PRIMARY_ORG_NAME
,      EMP_PRIMARY_ORG_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      SUPERCEDING_PROGRAM_NAME
FROM PSP.PSP_EFF_REPORTS;

Dependencies

[top of page]

PSP.PSP_EFF_REPORTS does not reference any database object

PSP.PSP_EFF_REPORTS is referenced by following:

APPS: PSP_EFF_REPORTS; PSP_EFF_REPORTS_WHO