RSF_USER_BU_VW

(SQL View)
 Index Back

Sales User for Business Unit

Sales User for a business Unit

SELECT A.BUSINESS_UNIT , A.PERSON_ID , B.NAME , B.BO_NAME , B.BO_NAME_DISPLAY , 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 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
3 NAME Character(50) VARCHAR2(50) NOT NULL Name
4 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
5 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
6 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name (Alternate Character)
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