RSF_OPR_ACC_VW

(SQL View)
 Index Back

Operator Access Options View


SELECT O.OPRID , O.PERSON_ID , SU.BUSINESS_UNIT , SU.CURRENCY_CD , SU.BO_ID_COMPANY , SU.TEAM_ID , SU.TREE_NAME , 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 PSOPRALIAS O , PS_RSF_SUSER_ACC SUA , PS_RSF_ACC_PROFILE AP , PS_RSF_SUSER SU WHERE O.OPRALIASTYPE = 'PER' AND O.PERSON_ID = SUA.PERSON_ID AND O.PERSON_ID = SU.PERSON_ID AND SUA.ACCESS_PROFILE_ID = AP.ACCESS_PROFILE_ID GROUP BY O.OPRID ,O.PERSON_ID ,SU.BUSINESS_UNIT ,SU.CURRENCY_CD , SU.BO_ID_COMPANY , SU.TEAM_ID, SU.TREE_NAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.
5 BO_ID_COMPANY Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
6 TEAM_ID Character(15) VARCHAR2(15) NOT NULL Sales Team ID
7 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
8 ACCESS_LE_REASSIGN Character(1) VARCHAR2(1) NOT NULL this is field added for dashboard project by Sales DB team

Y/N Table Edit

9 ACCESS_DD_CUST Character(1) VARCHAR2(1) NOT NULL Customer Name

Y/N Table Edit

10 ACCESS_DD_LAST Character(1) VARCHAR2(1) NOT NULL Last Name Optional

Y/N Table Edit

11 ACCESS_DD_FIRST Character(1) VARCHAR2(1) NOT NULL First Name Optional

Y/N Table Edit

12 ACCESS_DD_PHONE Character(1) VARCHAR2(1) NOT NULL Phone Optional

Y/N Table Edit

13 ACCESS_DD_ADDR_LIN Character(1) VARCHAR2(1) NOT NULL Address Line 1 Optional

Y/N Table Edit

14 ACCESS_DD_CITY Character(1) VARCHAR2(1) NOT NULL City Optional

Y/N Table Edit

15 ACCESS_DD_STATE Character(1) VARCHAR2(1) NOT NULL State Optional

Y/N Table Edit

16 ACCESS_DD_ZIP Character(1) VARCHAR2(1) NOT NULL Zip Code Optional

Y/N Table Edit

17 ACCESS_DD_EMAIL Character(1) VARCHAR2(1) NOT NULL Email

Y/N Table Edit

18 ACCESS_DD_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Allow Override of Dup Checking

Y/N Table Edit

19 ACCESS_OP_REASSIGN Character(1) VARCHAR2(1) NOT NULL this is field added for sales dashboard by sales dashboard team

Y/N Table Edit

20 ACCESS_OP_REVENUE Character(1) VARCHAR2(1) NOT NULL View & Edit Revenue Allocation

Y/N Table Edit

21 ACCESS_OP_SHADOW Character(1) VARCHAR2(1) NOT NULL View & Edit Shadow Allocation

Y/N Table Edit

22 ACCESS_FC_EDITALL Character(1) VARCHAR2(1) NOT NULL Edit Staff Forecast Data

Y/N Table Edit

23 ACCESS_FC_EDITOWN Character(1) VARCHAR2(1) NOT NULL Edit Own Forecast Data

Y/N Table Edit

24 ACCESS_FC_AUTOALL Character(1) VARCHAR2(1) NOT NULL Auto Forecast All Staff

Y/N Table Edit

25 ACCESS_FC_AUTOOWN Character(1) VARCHAR2(1) NOT NULL Auto Forecast Own Staff

Y/N Table Edit

26 ACCESS_FC_ADJUST Character(1) VARCHAR2(1) NOT NULL Adjust Forecasts

Y/N Table Edit

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

Y/N Table Edit

28 ACCESS_TR_REASSIGN Character(1) VARCHAR2(1) NOT NULL Submit Reassignment

Y/N Table Edit

29 ACCESS_TR_REORG Character(1) VARCHAR2(1) NOT NULL Submit Reorganization

Y/N Table Edit

30 ACCESS_CL_ASMGR Character(1) VARCHAR2(1) NOT NULL View Calendar as Manager

Y/N Table Edit