RSFD_SUSER_VW(SQL View) |
Index Back |
|---|---|
All Sales Users ViewView on the base sale user table complemented by name. |
| SELECT S.PERSON_ID , S.STATUS , S.SALES_USER_TYPE , S.BUSINESS_UNIT , S.BO_ID_COMPANY , S.CURRENCY_CD , S.SEG_QUOTA_TYPE , S.REV_QUOTA_TYPE FROM PS_RSF_SUSER S |
| # | 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_VW |
| 2 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive Default Value: A |
| 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
Default Value: OPR_DEF_TBL_RB.BUSINESS_UNIT Prompt Table: SP_BU_RSF_NONVW |
| 5 | BO_ID_COMPANY | Signed Number(32,0) | DECIMAL(31) NOT NULL |
Business Object ID
Prompt Table: RSF_SUSER_C_VW |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | This field stores the Currency Code value. |
| 7 | SEG_QUOTA_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Segment Quota Type
M=Manager Quota R=Rollup Quota Default Value: R |
| 8 | REV_QUOTA_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Revenue Quota Type
M=Manager Quota R=Rollup Quota Default Value: R |