RSFD_SMGR_DEL_V

(SQL View)
 Index Back

Delete Sales Manager relations

This view is all the sales managers and reporting sales representatives that have been changed and therefore need to be deleted from the dashboard.

SELECT A.PRCSINSTANCE , A.PERSON_ID_MANAGER , A.PERSON_ID , ' ' , ' ' , ' ' , A.ROW_ACTION FROM PS_RSFD_SMGR_UPD A WHERE A.ROW_ACTION = 'D'

# 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