RSFD_FC_QRP_VW2(SQL View) |
Index Back |
|---|---|
Compare Forecast vs. quotaThis record is used for Sales Dashboard to compare forecast vs. Quota for a sales rep. No quota Has Forecast |
| SELECT F.PERSON_ID , F.TIMEFRAME_PERIOD , SUM(F.FROM_REVENUE) , 0 FROM PS_RSF_FCAST_DTL F WHERE F.FORECAST_CATEGORY = 'R' AND NOT EXISTS( SELECT 'X' FROM PS_RSF_QRP Q WHERE Q.PERSON_ID = F.PERSON_ID AND F.TIMEFRAME_PERIOD = Q.TIMEFRAME_ID %Concat '-' %Concat Q.PERIOD_ID ) GROUP BY F.PERSON_ID , F.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 |