RSFD_LE_RATE_VW (SQL View)	Index Back
Lead Rating for Dashboard Dashboard lookup view with Lead Rating descriptor.

RSFD_LE_RATE_VW

(SQL View)

Lead Rating for Dashboard

Dashboard lookup view with Lead Rating descriptor.

SELECT A.SETID ,A.LEAD_RATING , A.DESCR , A.STATUS , B.XLATSHORTNAME FROM PS_RSF_LE_RATE_TBL A , PSXLATITEM B WHERE A.STATUS = B.FIELDVALUE AND B.FIELDNAME = 'STATUS' AND B.EFF_STATUS = 'A' AND %EffdtCheck(PSXLATITEM C, B, %CurrentDateIn)

# 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

4 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive

5 STATUS_CAT_SDESCR Character(10) VARCHAR2(10) NOT NULL Used for contact center dashboard to display status category short 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
4	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive
5	STATUS_CAT_SDESCR	Character(10)	VARCHAR2(10) NOT NULL	Used for contact center dashboard to display status category short description.