RSFW_SUSER_A_VW(SQL View) |
Index Back |
|---|---|
Active Sales UsersCRM Sales - Active Sales Users View. |
| SELECT S.PERSON_ID , B.BO_ID , S.SALES_USER_TYPE , S.BUSINESS_UNIT , B.FIRST_NAME , B.LAST_NAME , FIRST_NAME_SRCH , LAST_NAME_SRCH FROM PS_RSF_SUSER S , PS_BO_NAME B , PS_RD_PERSON P WHERE S.STATUS = 'A' AND S.PERSON_ID = P.PERSON_ID AND P.BO_ID = B.BO_ID AND B.PRIMARY_IND = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Person ID
Prompt Table: RSF_SUSER |
| 2 | BO_ID_PERSON | Number(31,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 3 | SALES_USER_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Sales User Type
ADMN=Sales Administrator EXEC=Executive Sales Manager FLDR=Field Sales Rep INSR=Inside Sales Rep PREP=Partner Contact PRES=Pre-Sales Consultant SMGR=Sales Manager TECH=Sales Tech Support TELR=Telesales Rep |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_RSF_NONVW |
| 5 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 6 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 7 | FIRST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 8 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |