RSF_TR_LEAD_VW (SQL View)	Index Back
Territory - Leads Selects Leads assigned to Sales Reps.

RSF_TR_LEAD_VW

(SQL View)

Territory - Leads

Selects Leads assigned to Sales Reps.

SELECT B.TREE_NAME , B.TERRITORY_ID , B.PERSON_ID , A.LEAD_ID , A.DESCR50 , B.PRIMARY_FLG , A.NAME1 , A.LEAD_RATING , B.TREE_NAME , B.TERRITORY_ID , A.EST_REVENUE , A.LEAD_STATUS , A.ROW_ADDED_DTTM , A.ROW_LASTMANT_DTTM FROM PS_RSF_LEAD A , PS_RSF_LE_SLSREP B WHERE B.LEAD_ID = A.LEAD_ID AND A.RC_PROSPECT_SW = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FROM_TREE Character(18) VARCHAR2(18) NOT NULL Current Tree Name

2 FROM_TERRITORY Character(20) VARCHAR2(20) NOT NULL Current Territory

3 FROM_SALES_REP Character(15) VARCHAR2(15) NOT NULL Current Sales Representative

4 LEAD_ID Character(15) VARCHAR2(15) NOT NULL Used by Sales Force Automation, this field uniquely identifies a Sales Lead.

5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

6 PRIMARY_FLG Character(1) VARCHAR2(1) NOT NULL This is a flag which takes yes or no values and indicates whether the row is primary.
N=No
Y=Yes

7 NAME1 Character(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.

8 LEAD_RATING Character(2) VARCHAR2(2) NOT NULL Used by Sales Force Automation to indicate the value (rating) of a lead, i.e. whether it's a Hot Lead or a Cold Lead.

9 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

10 TERRITORY_ID Character(20) VARCHAR2(20) NOT NULL Territory ID

11 EST_REVENUE Signed Number(28,3) DECIMAL(26,3) NOT NULL The expected revenue (amount) associated with an Opportunity. This is particularly used for forecasting.

12 LEAD_STATUS Character(2) VARCHAR2(2) NOT NULL Used by Sales Force Automation to keep the status of a Sales Lead.
AC=Accepted
CD=Closed - Duplicate
CL=Closed - Won
CO=Converted to Opportunity
DE=Deferred
IM=Imported
LO=Closed - Lost
NE=New
OP=Open
RE=Referred
RJ=Rejected
TB=Turnback
WO=Working

13 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

14 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FROM_TREE	Character(18)	VARCHAR2(18) NOT NULL	Current Tree Name
2	FROM_TERRITORY	Character(20)	VARCHAR2(20) NOT NULL	Current Territory
3	FROM_SALES_REP	Character(15)	VARCHAR2(15) NOT NULL	Current Sales Representative
4	LEAD_ID	Character(15)	VARCHAR2(15) NOT NULL	Used by Sales Force Automation, this field uniquely identifies a Sales Lead.
5	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
6	PRIMARY_FLG	Character(1)	VARCHAR2(1) NOT NULL	This is a flag which takes yes or no values and indicates whether the row is primary. N=No Y=Yes
7	NAME1	Character(50)	VARCHAR2(50) NOT NULL	Generic 50 character name field for storing names.
8	LEAD_RATING	Character(2)	VARCHAR2(2) NOT NULL	Used by Sales Force Automation to indicate the value (rating) of a lead, i.e. whether it's a Hot Lead or a Cold Lead.
9	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
10	TERRITORY_ID	Character(20)	VARCHAR2(20) NOT NULL	Territory ID
11	EST_REVENUE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The expected revenue (amount) associated with an Opportunity. This is particularly used for forecasting.
12	LEAD_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Used by Sales Force Automation to keep the status of a Sales Lead. AC=Accepted CD=Closed - Duplicate CL=Closed - Won CO=Converted to Opportunity DE=Deferred IM=Imported LO=Closed - Lost NE=New OP=Open RE=Referred RJ=Rejected TB=Turnback WO=Working
13	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
14	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.