RSF_QS_A_VW (SQL View)	Index Back
Opp Count - Active Segments

RSF_QS_A_VW

(SQL View)

Opp Count - Active Segments

SELECT A.PERSON_ID , A.PIPELINE_SEGMENT , A.SEGMENT_COUNT , A.CURRENCY_CD , A.SEGMENT_AMOUNT FROM PS_RSF_QS A , PS_RSF_SEGMENT B WHERE B.PIPELINE_SEGMENT = A.PIPELINE_SEGMENT AND B.STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
Prompt Table: RSF_SUSER

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

3 SEGMENT_COUNT Signed Number(10,0) DECIMAL(9) NOT NULL Opportunity Count

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID Prompt Table: RSF_SUSER
2	PIPELINE_SEGMENT	Character(15)	VARCHAR2(15) NOT NULL	Segment corresponds to sales stage.
3	SEGMENT_COUNT	Signed Number(10,0)	DECIMAL(9) NOT NULL	Opportunity Count
4	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value.
5	SEGMENT_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Segment Amount