RSF_QRP_PD_VW

(SQL View)
 Index Back

Period Summary

A view of all Period Summaries for all forecasts

SELECT P.PERSON_ID , T1.TIMEFRAME_ID , T1.PERIOD_ID , P.FORECAST_CATEGORY , T1.BEGIN_DT , T1.END_DT , T.CURRENCY_CD , SUM(P.QUOTA_AMOUNT) FROM PS_RSF_PIPE_TF_VW T1 , PS_RSF_QRP P , PS_RSF_QRT T WHERE P.TIMEFRAME_ID = T1.TIMEFRAME_ID AND P.PERIOD_ID = T1.PERIOD_ID AND P.TIMEFRAME_ID = T.TIMEFRAME_ID AND P.PERSON_ID = T.PERSON_ID AND P.FORECAST_CATEGORY = T.FORECAST_CATEGORY GROUP BY P.PERSON_ID, T1.TIMEFRAME_ID, T1.PERIOD_ID, P.FORECAST_CATEGORY, T1.BEGIN_DT, T1.END_DT, T.CURRENCY_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

Prompt Table: RSF_SUSER

2 TIMEFRAME_ID Character(15) VARCHAR2(15) NOT NULL Time Frame

Prompt Table: RSF_TF_DEFN

3 PERIOD_ID Character(15) VARCHAR2(15) NOT NULL Period

Prompt Table: RSF_TF_PERIOD

4 FORECAST_CATEGORY Character(1) VARCHAR2(1) NOT NULL Forecast Category
R=Revenue Forecast
S=Shadow Forecast
5 BEGIN_DT Date(10) DATE Begin Date
6 END_DT Date(10) DATE This field stores the end date values.
7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.
8 TOTAL_QUOTA_AMOUNT Signed Number(30,3) DECIMAL(28,3) NOT NULL Total Quota Amount