RT_LE_RATE_VW (SQL View)	Index Back
Lead Rating View View to get all lead ratings with status of 'Active'

RT_LE_RATE_VW

(SQL View)

Lead Rating View

View to get all lead ratings with status of 'Active'

SELECT SETID , LEAD_RATING , DESCR FROM PS_RSF_LE_RATE_TBL WHERE STATUS = 'A'

Related Language Record: RT_LE_RT_VW_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

2 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.

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
2	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.
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description