RSF_SU_ACC_VW

(SQL View)
 Index Back

Sales User SalesAccess Options


SELECT SU.PERSON_ID , MAX(AP.ACCESS_LE_REASSIGN) , MAX(AP.ACCESS_DD_CUST) , MAX(AP.ACCESS_DD_LAST) , MAX(AP.ACCESS_DD_FIRST) , MAX(AP.ACCESS_DD_PHONE) , MAX(AP.ACCESS_DD_ADDR_LIN) , MAX(AP.ACCESS_DD_CITY) , MAX(AP.ACCESS_DD_STATE) , MAX(AP.ACCESS_DD_ZIP) , MAX(AP.ACCESS_DD_EMAIL) , MAX(AP.ACCESS_DD_OVERRIDE) , MAX(AP.ACCESS_OP_REASSIGN) , MAX(AP.ACCESS_OP_REVENUE) , MAX(AP.ACCESS_OP_SHADOW) , MAX(AP.ACCESS_FC_EDITALL) , MAX(AP.ACCESS_FC_EDITOWN) , MAX(AP.ACCESS_FC_AUTOALL) , MAX(AP.ACCESS_FC_AUTOOWN) , MAX(AP.ACCESS_FC_ADJUST) , MAX(AP.ACCESS_FC_UNSUBMIT) , MAX(AP.ACCESS_TR_REASSIGN) , MAX(AP.ACCESS_TR_REORG) , MAX(AP.ACCESS_CL_ASMGR) FROM PS_RSF_SUSER_ACC SUA , PS_RSF_ACC_PROFILE AP , PS_RSF_SUSER SU WHERE SUA.PERSON_ID = SU.PERSON_ID AND SUA.ACCESS_PROFILE_ID = AP.ACCESS_PROFILE_ID GROUP BY SU.PERSON_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
2 ACCESS_LE_REASSIGN Character(1) VARCHAR2(1) NOT NULL this is field added for dashboard project by Sales DB team
3 ACCESS_DD_CUST Character(1) VARCHAR2(1) NOT NULL Customer Name
4 ACCESS_DD_LAST Character(1) VARCHAR2(1) NOT NULL Last Name Optional
5 ACCESS_DD_FIRST Character(1) VARCHAR2(1) NOT NULL First Name Optional
6 ACCESS_DD_PHONE Character(1) VARCHAR2(1) NOT NULL Phone Optional
7 ACCESS_DD_ADDR_LIN Character(1) VARCHAR2(1) NOT NULL Address Line 1 Optional
8 ACCESS_DD_CITY Character(1) VARCHAR2(1) NOT NULL City Optional
9 ACCESS_DD_STATE Character(1) VARCHAR2(1) NOT NULL State Optional
10 ACCESS_DD_ZIP Character(1) VARCHAR2(1) NOT NULL Zip Code Optional
11 ACCESS_DD_EMAIL Character(1) VARCHAR2(1) NOT NULL Email
12 ACCESS_DD_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Allow Override of Dup Checking
13 ACCESS_OP_REASSIGN Character(1) VARCHAR2(1) NOT NULL this is field added for sales dashboard by sales dashboard team
14 ACCESS_OP_REVENUE Character(1) VARCHAR2(1) NOT NULL View & Edit Revenue Allocation
15 ACCESS_OP_SHADOW Character(1) VARCHAR2(1) NOT NULL View & Edit Shadow Allocation
16 ACCESS_FC_EDITALL Character(1) VARCHAR2(1) NOT NULL Edit Staff Forecast Data
17 ACCESS_FC_EDITOWN Character(1) VARCHAR2(1) NOT NULL Edit Own Forecast Data
18 ACCESS_FC_AUTOALL Character(1) VARCHAR2(1) NOT NULL Auto Forecast All Staff
19 ACCESS_FC_AUTOOWN Character(1) VARCHAR2(1) NOT NULL Auto Forecast Own Staff
20 ACCESS_FC_ADJUST Character(1) VARCHAR2(1) NOT NULL Adjust Forecasts

Y/N Table Edit

21 ACCESS_FC_UNSUBMIT Character(1) VARCHAR2(1) NOT NULL View Unsubmitted Forecasts

Y/N Table Edit

22 ACCESS_TR_REASSIGN Character(1) VARCHAR2(1) NOT NULL Submit Reassignment
23 ACCESS_TR_REORG Character(1) VARCHAR2(1) NOT NULL Submit Reorganization
24 ACCESS_CL_ASMGR Character(1) VARCHAR2(1) NOT NULL View Calendar as Manager

Y/N Table Edit