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_REPORT_TEMPLATES

Object Details

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

PSP_REPORT_TEMPLATES , stores details of Effort report template created using the Effort report template creation page.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PSP_REPORT_TEMPLATES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	TEMPLATE_NAME REPORT_TYPE BUSINESS_GROUP_ID SET_OF_BOOKS_ID
PSP_REPORT_TEMPLATE_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TEMPLATE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TEMPLATE_ID	NUMBER	(15)	Yes	Effort Report Template Identifier
TEMPLATE_NAME	VARCHAR2	(240)	Yes	Stores the template name
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Business Group Id
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of books id
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object version number
REPORT_TYPE	VARCHAR2	(30)	Yes	Report Type
PERIOD_FREQUENCY_ID	NUMBER		Yes	Foreign key for PSP_REPORT_PERIOD_FREQUENCY_B
REPORT_TEMPLATE_CODE	VARCHAR2	(80)	Yes	Report Template Code
DISPLAY_ALL_EMP_DISTRIB_FLAG	VARCHAR2	(1)		Flag to display all distributions for employees
MANUAL_ENTRY_OVERRIDE_FLAG	VARCHAR2	(1)		Manual entry override flag
APPROVAL_TYPE	VARCHAR2	(30)	Yes	Report approval type (EMP-Employee, PRE-Preapproved, SUP-Supervisor)
CUSTOM_APPROVAL_CODE	VARCHAR2	(30)		Customg Approval code
SUP_LEVELS	NUMBER			Supervisor levels for supervisor approval types
PREVIEW_EFFORT_REPORT_FLAG	VARCHAR2	(1)	Yes	Preview effort report flag for initiator being able to preview the report before submitting for approval process
NOTIFICATION_REMINDER_IN_DAYS	NUMBER			Timeout notification reminder in days
SPRCD_TOLERANCE_AMT	NUMBER			Supercede tolerance amount
SPRCD_TOLERANCE_PERCENT	NUMBER			Supercede tolerance percent
DESCRIPTION	VARCHAR2	(1000)		Description
LEGISLATION_CODE	VARCHAR2	(30)		Legislation code
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
HUNDRED_PCENT_EFF_AT_PER_ASG	VARCHAR2	(1)	Yes	Hundred % effort at person/assignment level
SELECTION_MATCH_LEVEL	VARCHAR2	(3)	Yes	Selection Match level

Query Text

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


SELECT TEMPLATE_ID
,      TEMPLATE_NAME
,      BUSINESS_GROUP_ID
,      SET_OF_BOOKS_ID
,      OBJECT_VERSION_NUMBER
,      REPORT_TYPE
,      PERIOD_FREQUENCY_ID
,      REPORT_TEMPLATE_CODE
,      DISPLAY_ALL_EMP_DISTRIB_FLAG
,      MANUAL_ENTRY_OVERRIDE_FLAG
,      APPROVAL_TYPE
,      CUSTOM_APPROVAL_CODE
,      SUP_LEVELS
,      PREVIEW_EFFORT_REPORT_FLAG
,      NOTIFICATION_REMINDER_IN_DAYS
,      SPRCD_TOLERANCE_AMT
,      SPRCD_TOLERANCE_PERCENT
,      DESCRIPTION
,      LEGISLATION_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      HUNDRED_PCENT_EFF_AT_PER_ASG
,      SELECTION_MATCH_LEVEL
FROM PSP.PSP_REPORT_TEMPLATES;

Dependencies

[top of page]

PSP.PSP_REPORT_TEMPLATES does not reference any database object

PSP.PSP_REPORT_TEMPLATES is referenced by following:

APPS: PSP_REPORT_TEMPLATES; PSP_REPORT_TEMPLATES_WHO