RSF_PLQR_R2_VW

(SQL View)
 Index Back

Monetary Quota - Rollup Lvl 2

View underlying pipeline calculations for sales user quotas.

SELECT '1' , M.PERSON_ID_MANAGER , Q.PERSON_ID , Q.TIMEFRAME_ID , R1.PERIOD_ROLLUP_ID , SU.REV_QUOTA_TYPE , Q.FORECAST_CATEGORY , R2.PERIOD_ROLLUP_ID , R2.ROLLUP_SEQNUM , R2.BEGIN_DT , R2.END_DT , Q.SETID , Q.PRODUCT_GROUP , Q.PRODUCT_ID , Q.REVENUE_TYPE , Q.INDUSTRY_ID , Q.REGION_ID , Q.BUSINESS_UNIT , Q.TREE_NAME , Q.TERRITORY_ID , T.CURRENCY_CD , Q.QUOTA_AMOUNT , Q.QUOTA_AMOUNT FROM PS_RSF_ACC_MGR_VW M , PS_RSF_QRT T , PS_RSF_QRP Q , PS_RSF_PIPE_TF_VW P , PS_RSF_TF_ROLL_VW R1 , PS_RSF_TF_ROLL_VW R2 , PS_RSF_SUSER SU WHERE M.PERSON_ID = SU.PERSON_ID AND M.PERSON_ID = Q.PERSON_ID AND T.TIMEFRAME_ID = Q.TIMEFRAME_ID AND T.FORECAST_CATEGORY = Q.FORECAST_CATEGORY AND T.PERSON_ID = Q.PERSON_ID AND P.TIMEFRAME_ID = Q.TIMEFRAME_ID AND P.PERIOD_ID = Q.PERIOD_ID AND P.TIMEFRAME_ID = R1.TIMEFRAME_ID AND P.PERIOD_ID = R1.PERIOD_ID AND R2.TIMEFRAME_ID = R1.TIMEFRAME_ID AND R2.PERIOD_ID = R1.PERIOD_ROLLUP_ID AND R2.ROLLUP_SEQNUM = 2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PL_DATATYPE Character(1) VARCHAR2(1) NOT NULL Pipeline Data Type
1=Quota
2=Actual
3=Leak
2 PERSON_ID_MANAGER Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
3 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

Prompt Table: RSF_SUSER

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

Prompt Table: RSF_TF_DEFN

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

Prompt Table: RSF_TF_PERIOD

6 REV_QUOTA_TYPE Character(1) VARCHAR2(1) NOT NULL Revenue Quota Type
M=Manager Quota
R=Rollup Quota
7 FORECAST_CATEGORY Character(1) VARCHAR2(1) NOT NULL Forecast Category
R=Revenue Forecast
S=Shadow Forecast
8 PERIOD_ROLLUP_ID Character(15) VARCHAR2(15) NOT NULL Quota Rollup Period
9 ROLLUP_SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
10 BEGIN_DT Date(10) DATE Begin Date
11 END_DT Date(10) DATE This field stores the end date values.
12 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
13 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL PRoduct Group
14 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
15 REVENUE_TYPE Character(15) VARCHAR2(15) NOT NULL This field is used to store revenue type related to a product sales and used within forecasting.
16 INDUSTRY_ID Character(30) VARCHAR2(30) NOT NULL Industry ID.
17 REGION_ID Character(15) VARCHAR2(15) NOT NULL This field stores the region id value.
18 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
19 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
20 TERRITORY_ID Character(20) VARCHAR2(20) NOT NULL Territory ID
21 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.
22 REVENUE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Revenue Amount
23 SHADOW_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Shadow Amount