RSFD_DMGR_UPD_V (SQL View)	Index Back
Sales Rep Direct Mgr Update This view is used within sales dashboard to update the sales rep's direct manager whenever the territory flatter is run.

RSFD_DMGR_UPD_V

(SQL View)

Sales Rep Direct Mgr Update

This view is used within sales dashboard to update the sales rep's direct manager whenever the territory flatter is run.

SELECT DISTINCT A.PRCSINSTANCE , A.PERSON_ID , B.PERSON_ID_MANAGER FROM PS_RSFD_SMGR_UPD A , PS_RSFD_DMGR_VW B WHERE A.PERSON_ID = B.PERSON_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

3 PERSON_ID_MANAGER Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PRCSINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
3	PERSON_ID_MANAGER	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts