RSFD_FC_QRP_VW(SQL View) |
Index Back |
|---|---|
Compare Forecast vs. quotaThis record is used for Sales Dashboard to compare forecast vs. Quota for a sales rep. |
| SELECT F.PERSON_ID , F.TIMEFRAME_PERIOD , SUM(F.FROM_REVENUE) , SUM(Q.QUOTA_AMOUNT) FROM PS_RSF_FCAST_DTL F , PS_RSF_QRP Q WHERE F.TIMEFRAME_PERIOD = TIMEFRAME_ID %Concat '-' %Concat PERIOD_ID AND Q.PERSON_ID = F.PERSON_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 |