RSFD_FC_QRP_VW3(SQL View) |
Index Back |
|---|---|
Compare Forecast vs. quotaThis record is used for Sales Dashboard to compare forecast vs. Quota for a sales rep. Has quota No Forecast |
| SELECT Q.PERSON_ID , TF.TIMEFRAME_PERIOD , 0 , SUM(Q.QUOTA_AMOUNT) FROM PS_RSF_QRP Q , PS_RSF_TF_PERIOD TF WHERE Q.TIMEFRAME_ID = TF.TIMEFRAME_ID AND Q.PERIOD_ID = TF.PERIOD_ID AND NOT EXISTS( SELECT 'X' FROM PS_RSF_FCAST_DTL F WHERE Q.PERSON_ID = F.PERSON_ID AND F.FORECAST_CATEGORY = 'R' AND F.TIMEFRAME_PERIOD = TF.TIMEFRAME_PERIOD ) GROUP BY Q.PERSON_ID, TF.TIMEFRAME_PERIOD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 2 | TIMEFRAME_PERIOD | Character(32) | VARCHAR2(32) NOT NULL | Time Frame |
| 3 | FROM_REVENUE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | From Revenue For Forecast Comparison Ace Report |
| 4 | QUOTA_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Quota Amount |