PL_DATATYPE1=Quota
2=Actual
3=Leak
PIPELINE_SEGMENTRSF_PLQS_OAR_VW(SQL View) |
Index Back |
|---|---|
Segment Qta Opp Amount-RollupView underlying pipeline calculations for sales user quotas. |
| SELECT '1' , Q.PIPELINE_SEGMENT , M.PERSON_ID_MANAGER , Q.PERSON_ID , Q.CURRENCY_CD , SUM(Q.SEGMENT_AMOUNT) FROM PS_RSF_SUSER SU , PS_RSF_ACC_MGR_VW M , PS_RSF_QS Q WHERE M.PERSON_ID = Q.PERSON_ID AND SU.PERSON_ID = Q.PERSON_ID AND SU.SEG_QUOTA_TYPE = 'R' GROUP BY M.PERSON_ID_MANAGER, Q.PERSON_ID, Q.PIPELINE_SEGMENT, Q.CURRENCY_CD |
| # | 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 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | This field stores the Currency Code value. |
| 6 | REVENUE_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Revenue Amount |