RF_SUSER_VW(SQL View) |
Index Back |
|---|---|
Active Sales Users |
| SELECT S.PERSON_ID , B.BO_NAME_DISPLAY , B.BO_NAME_AC , B.LAST_NAME , B.FIRST_NAME , S.STATUS , S.SALES_USER_TYPE , S.BUSINESS_UNIT , S.BO_ID_COMPANY , S.TEAM_ID , S.CURRENCY_CD , S.TREE_NAME , S.SHADOW_PCT , S.SHADOW_AMT 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_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
| 3 | NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Name (Alternate Character) |
| 4 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 5 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 6 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive Default Value: A |
| 7 | 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 |
| 8 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_RSF_NONVW |
| 9 | BO_ID_COMPANY | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 10 | TEAM_ID | Character(15) | VARCHAR2(15) NOT NULL | Sales Team ID |
| 11 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | This field stores the Currency Code value. |
| 12 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 13 | SHADOW_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Shadow Amount Percent |
| 14 | SHADOW_AMT | Number(27,3) | DECIMAL(26,3) NOT NULL | An amount for a 'shadow' forecast. |