PERSON_IDPIPELINE_SEGMENTPrompt Table: RSF_SEGMENT
Default Value: RSF_SUSER.CURRENCY_CD
Prompt Table: CURRENCY_CD_TBL
M=Manager Quota
R=Rollup Quota
RSFD_PLQS_VW(SQL View) |
Index Back |
|---|---|
Pipeline Segment QuotasA pipeline view supporting Pipeline Segment Quotas by Rep. |
| SELECT Q.PERSON_ID , Q.PIPELINE_SEGMENT , Q.CURRENCY_CD , Q.SEGMENT_COUNT , Q.SEGMENT_AMOUNT , SU.SEG_QUOTA_TYPE FROM PS_RSF_QS Q , PS_RSF_SEGMENT SEG , PS_RSF_SUSER SU WHERE Q.PIPELINE_SEGMENT = SEG.PIPELINE_SEGMENT AND Q.PERSON_ID = SU.PERSON_ID AND (Q.SEGMENT_AMOUNT > 0 OR Q.SEGMENT_COUNT > 0) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 2 | PIPELINE_SEGMENT |
Character(15) | VARCHAR2(15) NOT NULL |
Segment corresponds to sales stage.
Prompt Table: RSF_SEGMENT |
| 3 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
This field stores the Currency Code value.
Default Value: RSF_SUSER.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL |
| 4 | SEGMENT_COUNT | Signed Number(10,0) | DECIMAL(9) NOT NULL | Opportunity Count |
| 5 | SEGMENT_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Segment Amount |
| 6 | SEG_QUOTA_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Segment Quota Type
M=Manager Quota R=Rollup Quota |