RSFD_SMGR_VW

(SQL View)
 Index Back

Manager to staff Dashboard

Dashboard view of the manager's reporting relationships for sales

SELECT DISTINCT A.PERSON_ID_MANAGER , A.PERSON_ID , B.OPRID , SMGR.SEG_QUOTA_TYPE , SMGR.REV_QUOTA_TYPE FROM PS_RSF_ACC_SUSER A , PSOPRALIAS B , PS_RSF_SUSER SMGR WHERE A.PERSON_ID_MANAGER = B.PERSON_ID AND B.OPRALIASTYPE = 'PER' AND A.PERSON_ID_MANAGER > ' ' AND A.PERSON_ID > ' ' AND SMGR.PERSON_ID = A.PERSON_ID_MANAGER

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PERSON_ID_MANAGER Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
2 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
4 SEG_QUOTA_TYPE Character(1) VARCHAR2(1) NOT NULL Segment Quota Type
M=Manager Quota
R=Rollup Quota
5 REV_QUOTA_TYPE Character(1) VARCHAR2(1) NOT NULL Revenue Quota Type
M=Manager Quota
R=Rollup Quota