RSF_TEAM_MBR_VW(SQL View) |
Index Back |
|---|---|
Sales Team MemberJoin of Sales Team Members and Person to get Name |
| SELECT A.TEAM_ID , A.PERSON_ID , A.SALES_USER_TYPE , B.NAME , A.ROLE_CD , A.SHADOW_PCT , A.SHADOW_AMT FROM PS_RSF_TEAM_MBRS A , PS_RSF_SUSER_A_VW B WHERE A.PERSON_ID = B.PERSON_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  TEAM_ID |
Character(15) | VARCHAR2(15) NOT NULL | Sales Team ID |
| 2 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Person ID
Prompt Table: RSF_SUSER_A_VW |
| 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 | SALES_USER_NAME | Character(50) | VARCHAR2(50) NOT NULL | Sales User Name field |
| 5 | ROLE_CD | Character(4) | VARCHAR2(4) NOT NULL |
Sales User Role Code
0001=Manager 0002=Administrator 0003=Consultant 0004=Legal 0005=Other 0006=Liaison 0007=Partner 0007=Partner 0008=Sales Rep 0009=Team Leader 0010=Technical Sales 0011=Technical 0012=Training |
| 6 | SHADOW_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Shadow Amount Percent |
| 7 | SHADOW_AMT | Number(27,3) | DECIMAL(26,3) NOT NULL | An amount for a 'shadow' forecast. |