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_REPORT_APPROVALS

Object Details

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

Contains effort report approval details for the workflow processes started by a create effort report approval process

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PSP_EFF_REPORT_APPROVALS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	EFFORT_REPORT_APPROVAL_ID
PSP_EFF_REPORT_APPROVALS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WF_ITEM_KEY
PSP_EFF_REPORT_APPROVALS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EFFORT_REPORT_DETAIL_ID

Columns

Name	Datatype	Length	Mandatory	Comments
EFFORT_REPORT_APPROVAL_ID	NUMBER	(15)	Yes	Effort report approval identifier
EFFORT_REPORT_DETAIL_ID	NUMBER	(15)		Foerign key for PSP_EFF_REPORT_DETAILS
WF_ROLE_NAME	VARCHAR2	(320)		Approver's wf user name
WF_ORIG_SYSTEM_ID	NUMBER			Person id associated with the wf role name
WF_ORIG_SYSTEM	VARCHAR2	(30)		PER
APPROVER_ORDER_NUM	NUMBER			Approver Order Number
APPROVAL_STATUS	VARCHAR2	(1)		Effort Report Approval Status
RESPONSE_DATE	DATE			Responded date
ACTUAL_COST_SHARE	NUMBER			Actual Cost Share
OVERWRITTEN_EFFORT_PERCENT	NUMBER			Approver overwritten effort percent
WF_ITEM_KEY	VARCHAR2	(240)		Workflow Approval Process Item Key
COMMENTS	VARCHAR2	(240)		Approver comment
PERA_INFORMATION_CATEGORY	VARCHAR2	(30)		DFF Structure definition column
PERA_INFORMATION1	VARCHAR2	(150)		EIT Attributes for Hospital Health care and other requirements
PERA_INFORMATION2	VARCHAR2	(150)		EIT Attributes for Hospital Health care and other requirements
PERA_INFORMATION3	VARCHAR2	(150)		Attribute
PERA_INFORMATION4	VARCHAR2	(150)		Attribute
PERA_INFORMATION5	VARCHAR2	(150)		Attribute
PERA_INFORMATION6	VARCHAR2	(150)		Attribute
PERA_INFORMATION7	VARCHAR2	(150)		Attribute
PERA_INFORMATION8	VARCHAR2	(150)		Attribute
PERA_INFORMATION9	VARCHAR2	(150)		Attribute
PERA_INFORMATION10	VARCHAR2	(150)		Attribute
PERA_INFORMATION11	VARCHAR2	(150)		Attribute
PERA_INFORMATION12	VARCHAR2	(150)		Attribute
PERA_INFORMATION13	VARCHAR2	(150)		Attribute
PERA_INFORMATION14	VARCHAR2	(150)		Attribute
PERA_INFORMATION15	VARCHAR2	(150)		Attribute
PERA_INFORMATION16	VARCHAR2	(150)		Attribute
PERA_INFORMATION17	VARCHAR2	(150)		Attribute
PERA_INFORMATION18	VARCHAR2	(150)		Attribute
PERA_INFORMATION19	VARCHAR2	(150)		Attribute
PERA_INFORMATION20	VARCHAR2	(150)		Attribute
LAST_UPDATE_DATE	DATE			Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
CREATED_BY	NUMBER	(15)		Standard Who Column
CREATION_DATE	DATE			Standard Who Column
WF_ROLE_DISPLAY_NAME	VARCHAR2	(360)		User Name
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object version number
NOTIFICATION_ID	NUMBER			Notification Identifier
EFF_INFORMATION_CATEGORY	VARCHAR2	(30)		DFF Structure definition column
EFF_INFORMATION1	VARCHAR2	(150)		DFF Segment
EFF_INFORMATION2	VARCHAR2	(150)		DFF Segment
EFF_INFORMATION3	VARCHAR2	(150)		DFF Segment
EFF_INFORMATION4	VARCHAR2	(150)		DFF Segment
EFF_INFORMATION5	VARCHAR2	(150)		DFF Segment
EFF_INFORMATION6	VARCHAR2	(150)		DFF Segment
EFF_INFORMATION7	VARCHAR2	(150)		DFF Segment
EFF_INFORMATION8	VARCHAR2	(150)		DFF Segment
EFF_INFORMATION9	VARCHAR2	(150)		DFF Segment
EFF_INFORMATION10	VARCHAR2	(150)		DFF Segment
EFF_INFORMATION11	VARCHAR2	(150)		DFF Segment
EFF_INFORMATION12	VARCHAR2	(150)		DFF Segment
EFF_INFORMATION13	VARCHAR2	(150)		DFF Segment
EFF_INFORMATION14	VARCHAR2	(150)		DFF Segment
EFF_INFORMATION15	VARCHAR2	(150)		DFF Segment

Query Text

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


SELECT EFFORT_REPORT_APPROVAL_ID
,      EFFORT_REPORT_DETAIL_ID
,      WF_ROLE_NAME
,      WF_ORIG_SYSTEM_ID
,      WF_ORIG_SYSTEM
,      APPROVER_ORDER_NUM
,      APPROVAL_STATUS
,      RESPONSE_DATE
,      ACTUAL_COST_SHARE
,      OVERWRITTEN_EFFORT_PERCENT
,      WF_ITEM_KEY
,      COMMENTS
,      PERA_INFORMATION_CATEGORY
,      PERA_INFORMATION1
,      PERA_INFORMATION2
,      PERA_INFORMATION3
,      PERA_INFORMATION4
,      PERA_INFORMATION5
,      PERA_INFORMATION6
,      PERA_INFORMATION7
,      PERA_INFORMATION8
,      PERA_INFORMATION9
,      PERA_INFORMATION10
,      PERA_INFORMATION11
,      PERA_INFORMATION12
,      PERA_INFORMATION13
,      PERA_INFORMATION14
,      PERA_INFORMATION15
,      PERA_INFORMATION16
,      PERA_INFORMATION17
,      PERA_INFORMATION18
,      PERA_INFORMATION19
,      PERA_INFORMATION20
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      WF_ROLE_DISPLAY_NAME
,      OBJECT_VERSION_NUMBER
,      NOTIFICATION_ID
,      EFF_INFORMATION_CATEGORY
,      EFF_INFORMATION1
,      EFF_INFORMATION2
,      EFF_INFORMATION3
,      EFF_INFORMATION4
,      EFF_INFORMATION5
,      EFF_INFORMATION6
,      EFF_INFORMATION7
,      EFF_INFORMATION8
,      EFF_INFORMATION9
,      EFF_INFORMATION10
,      EFF_INFORMATION11
,      EFF_INFORMATION12
,      EFF_INFORMATION13
,      EFF_INFORMATION14
,      EFF_INFORMATION15
FROM PSP.PSP_EFF_REPORT_APPROVALS;

Dependencies

[top of page]

PSP.PSP_EFF_REPORT_APPROVALS does not reference any database object

PSP.PSP_EFF_REPORT_APPROVALS is referenced by following:

APPS: PSP_EFF_REPORT_APPROVALS; PSP_EFF_REPORT_APPROVALS_WHO