RSF_TR_LE_TEAMV

(SQL View)
 Index Back

Lead Sales Team View

Used in territory reorg to show current Sales reps working on a particular lead.

SELECT A.LEAD_ID ,A.PERSON_ID ,B.NAME ,A.TREE_NAME ,A.TERRITORY_ID ,A.PRIMARY_FLG FROM PS_RSF_LE_SLSREP A , PS_RSF_SUSER_VW B WHERE A.PERSON_ID = B.PERSON_ID

# 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

Prompt Table: RSF_SUSER_A_VW

3 SALES_USER_NAME Character(50) VARCHAR2(50) NOT NULL Sales User Name field

Prompt Table: RSF_SUSER_A_VW

4 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

Prompt Table: RSF_TEAMTREE_VW

5 TERRITORY_ID Character(20) VARCHAR2(20) NOT NULL Territory ID

Prompt Table: RSF_TER_NODE_VW

6 PRIMARY_FLG Character(1) VARCHAR2(1) NOT NULL This is a flag which takes yes or no values and indicates whether the row is primary.
N=No
Y=Yes