RSF_SUSER_C_VW(SQL View) |
Index Back |
|---|---|
Active Sales Users |
| SELECT S.PERSON_ID , B.BO_NAME , S.STATUS , S.SALES_USER_TYPE , S.BUSINESS_UNIT , S.BO_ID_COMPANY , C.BO_NAME , 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 , PS_BO C WHERE S.STATUS = 'A' AND S.PERSON_ID = P.PERSON_ID AND P.BO_ID = B.BO_ID AND S.BO_ID_COMPANY = C.BO_ID |
| # | 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 | SALES_USER_NAME | Character(50) | VARCHAR2(50) NOT NULL | Sales User Name field |
| 3 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive Default Value: A |
| 4 | 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 |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_RSF_NONVW |
| 6 | BO_ID_COMPANY | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 7 | COMPANY_NAME | Character(70) | VARCHAR2(70) NOT NULL | Company Name |
| 8 | TEAM_ID | Character(15) | VARCHAR2(15) NOT NULL | Sales Team ID |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | This field stores the Currency Code value. |
| 10 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 11 | SHADOW_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Shadow Amount Percent |
| 12 | SHADOW_AMT | Number(27,3) | DECIMAL(26,3) NOT NULL | An amount for a 'shadow' forecast. |