PL_DATATYPE1=Quota
2=Actual
3=Leak
PIPELINE_SEGMENTRSF_PLQS_OCM_VW(SQL View) |
Index Back |
|---|---|
Segment Qta Opp Count-ManagerView underlying pipeline calculations for sales user quotas. |
| SELECT '1' , Q.PIPELINE_SEGMENT , M.PERSON_ID_MANAGER , Q.PERSON_ID , SUM(Q.SEGMENT_COUNT ) FROM PS_RSF_SUSER SU , PS_RSF_ACC_MGR_VW M , PS_RSF_QS Q WHERE M.PERSON_ID = M.PERSON_ID_MANAGER AND M.PERSON_ID = Q.PERSON_ID AND SU.PERSON_ID = Q.PERSON_ID AND SU.SEG_QUOTA_TYPE = 'M' GROUP BY M.PERSON_ID_MANAGER, Q.PERSON_ID, Q.PIPELINE_SEGMENT |
| # | 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 | PIPELINE_SEGMENT |
Character(15) | VARCHAR2(15) NOT NULL | Segment corresponds to sales stage. |
| 3 | PERSON_ID_MANAGER | Character(15) | VARCHAR2(15) NOT NULL | Contact Identifier for Treasury Contacts |
| 4 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 5 | OPPORTUNITY_COUNT | Signed Number(10,0) | DECIMAL(9) NOT NULL | Opportunity Count |