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 |