RSF_LE_STATUSVW

(SQL View)
Index Back

Lead View For Availability.

Used in Lead Assignment by Round Robin - Availability.

SELECT LEAD_ID , PERSON_ID FROM PS_RSF_LEAD WHERE LEAD_STATUS IN('NE' ,'OP' ,'AC' ,'RE' ,'IM' ,'WO' ,'CO' ,'RJ' ,'DE' ,'TB')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LEAD_ID Character(15) VARCHAR2(15) NOT NULL Used by Sales Force Automation, this field uniquely identifies a Sales Lead.
2 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID