RSF_QRP_NS_VW

(SQL View)
 Index Back

Monetary Quota-New Shadow

A view of all Quota Amounts for New Shadow

SELECT A.PERSON_ID , B.TIMEFRAME_ID , B.PERIOD_ID , 'S' , 0 FROM PS_RSF_SUSER A , PS_RSF_PIPE_TF_VW B , PS_RSF_TF_DEFN C WHERE B.STATUS = 'A' AND C.TIMEFRAME_ID = B.TIMEFRAME_ID AND C.PERIOD_TYPE = B.PERIOD_TYPE AND NOT EXISTS ( SELECT 'X' FROM PS_RSF_QRP D WHERE D.PERSON_ID = A.PERSON_ID AND D.TIMEFRAME_ID = B.TIMEFRAME_ID AND D.PERIOD_ID = B.PERIOD_ID AND D.FORECAST_CATEGORY = 'S')

# 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 QUOTA_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Quota Amount