RSFD_TF_VW (SQL View)	Index Back
URL support for summary prompt Dashboard will begin with summary page. The expectation for this page is that the PIA url to it will carry the correct 'starting point' for the page's initial prompt. For sales, the url will carry the current and next timeframe.

RSFD_TF_VW

(SQL View)

URL support for summary prompt

Dashboard will begin with summary page. The expectation for this page is that the PIA url to it will carry the correct 'starting point' for the page's initial prompt. For sales, the url will carry the current and next timeframe.

SELECT MIN(A.TIMEFRAME_PERIOD) , MIN(B.TIMEFRAME_PERIOD) FROM PS_RSFD_TFP_QTR_VW A , PS_RSFD_TFP_QTR_VW B WHERE %CurrentDateIn BETWEEN A.BEGIN_DT AND A.END_DT AND %DateAdd(%CurrentDateIn, 91) BETWEEN B.BEGIN_DT AND B.END_DT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RSFD_TF_CUR_QTR Character(32) VARCHAR2(32) NOT NULL Timeframe period used in dashboard for estimated close date range

2 RSFD_TF_NEXT_QTR Character(32) VARCHAR2(32) NOT NULL Timeframe period used in dashboard for estimated close date range

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RSFD_TF_CUR_QTR	Character(32)	VARCHAR2(32) NOT NULL	Timeframe period used in dashboard for estimated close date range
2	RSFD_TF_NEXT_QTR	Character(32)	VARCHAR2(32) NOT NULL	Timeframe period used in dashboard for estimated close date range