RSF_LE_SCORE_VW (SQL View)	Index Back
Lead Score CRM Sales - View of all Lead Scores

RSF_LE_SCORE_VW

(SQL View)

Lead Score

CRM Sales - View of all Lead Scores

SELECT A.RC_BS_INSTANCE , RC_BS_STATUS , A.RC_SCORE , ' ' , B.RC_SCORE FROM PS_RC_BS_INSTANCE A , PS_RC_RATE_VALUE B , PS_RC_BSCRIPT C WHERE A.SETID = C.SETID AND A.SCRIPT_ID = C.SCRIPT_ID AND A.EFFDT = C.EFFDT AND B.RC_SCORE = ( SELECT MAX(RC_SCORE) FROM PS_RC_RATE_VALUE D WHERE D.RC_RATE_ID = C.RC_RATE_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RC_BRSCR_INSTANCE Number(15,0) DECIMAL(15) NOT NULL Branh Script Instance Number

2 RC_BRSCR_STATUS Character(1) VARCHAR2(1) NOT NULL Branch Script Status. It is ether Valid or Invalid.
C=Completed
P=Processing
S=Started

3 RC_SCORE Number(6,2) DECIMAL(5,2) NOT NULL Survey Score

4 RC_RATE Character(2) VARCHAR2(2) NOT NULL Field used by CRM common object Branch Scripting
C=Cold
H=Hot
NS=Not Satisfied
SF=Satisfied
SW=Somewhat Satisfied
VS=Very Satisfied
W=Warm

5 RC_LIMIT Number(6,2) DECIMAL(5,2) NOT NULL Score Limit

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RC_BRSCR_INSTANCE	Number(15,0)	DECIMAL(15) NOT NULL	Branh Script Instance Number
2	RC_BRSCR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Branch Script Status. It is ether Valid or Invalid. C=Completed P=Processing S=Started
3	RC_SCORE	Number(6,2)	DECIMAL(5,2) NOT NULL	Survey Score
4	RC_RATE	Character(2)	VARCHAR2(2) NOT NULL	Field used by CRM common object Branch Scripting C=Cold H=Hot NS=Not Satisfied SF=Satisfied SW=Somewhat Satisfied VS=Very Satisfied W=Warm
5	RC_LIMIT	Number(6,2)	DECIMAL(5,2) NOT NULL	Score Limit