RSF_SUSER_P_VW

(SQL View)
 Index Back

Sales User view

View of Sales Users by Business Unit

SELECT A.BUSINESS_UNIT , %Substring(B.BO_NAME_DISPLAY,1,50) , B.NAME_AC , A.SALES_USER_TYPE FROM PS_RSF_SUSER A , PS_RD_PERSON P , PS_BO_NAME B WHERE A.PERSON_ID = P.PERSON_ID AND A.STATUS = 'A' AND P.BO_ID = B.BO_ID AND B.PRIMARY_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 SALES_USER_NAME Character(50) VARCHAR2(50) NOT NULL Sales User Name field
3 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name (Alternate Character)
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