RSFD_SMGR_ADD_V

(SQL View)
 Index Back

Sales Dashboard Manager Access

This view is used to update Sales Manager access for the Dashboard.

SELECT A.PRCSINSTANCE , A.PERSON_ID_MANAGER , A.PERSON_ID , B.OPRID , SMGR.SEG_QUOTA_TYPE , SMGR.REV_QUOTA_TYPE , A.ROW_ACTION FROM PS_RSFD_SMGR_UPD A , PSOPRALIAS B , PS_RSF_SUSER SMGR WHERE A.PERSON_ID_MANAGER = B.PERSON_ID AND B.OPRALIASTYPE = 'PER' AND A.PERSON_ID_MANAGER = SMGR.PERSON_ID AND A.ROW_ACTION = 'I'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 PERSON_ID_MANAGER Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
3 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
5 SEG_QUOTA_TYPE Character(1) VARCHAR2(1) NOT NULL Segment Quota Type
M=Manager Quota
R=Rollup Quota
6 REV_QUOTA_TYPE Character(1) VARCHAR2(1) NOT NULL Revenue Quota Type
M=Manager Quota
R=Rollup Quota
7 ROW_ACTION Character(1) VARCHAR2(1) NOT NULL Action to take for that row
D=Delete
E=Existing
I=Insert