RSFD_PLQSM_R_VW (SQL View)	Index Back
Segment Quota Rollup View of pipeline sales user quotas summed by manager.

RSFD_PLQSM_R_VW

(SQL View)

Segment Quota Rollup

View of pipeline sales user quotas summed by manager.

SELECT M.PERSON_ID_MANAGER , Q.PIPELINE_SEGMENT , INST.PT_CDB_DEF_CUR_CD , %Round(SUM(%DecMult(INST_MULT , Q.SEGMENT_AMOUNT)),0) , SUM(Q.SEGMENT_COUNT) FROM PS_RSF_SUSER SU , PS_RSF_ACC_MGR_VW M , PS_RSF_QS Q , PS_RBD_CURRT CUR , PSCDBINSTALL INST WHERE M.PERSON_ID = Q.PERSON_ID AND SU.PERSON_ID = M.PERSON_ID_MANAGER AND SU.SEG_QUOTA_TYPE = 'R' AND Q.CURRENCY_CD = CUR.CURRENCY_CD GROUP BY M.PERSON_ID_MANAGER, Q.PIPELINE_SEGMENT, INST.PT_CDB_DEF_CUR_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PERSON_ID_MANAGER Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

2 PIPELINE_SEGMENT Character(15) VARCHAR2(15) NOT NULL Segment corresponds to sales stage.

3 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

4 SEGMENT_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Segment Amount

5 OPPORTUNITY_COUNT Signed Number(10,0) DECIMAL(9) NOT NULL Opportunity Count

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PERSON_ID_MANAGER	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
2	PIPELINE_SEGMENT	Character(15)	VARCHAR2(15) NOT NULL	Segment corresponds to sales stage.
3	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value.
4	SEGMENT_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Segment Amount
5	OPPORTUNITY_COUNT	Signed Number(10,0)	DECIMAL(9) NOT NULL	Opportunity Count