RSFD_SMGR_UPD (SQL Table)	Index Back
Sales Manager Access Update This table stores the changes which have happened when the sales manager access program is run to flatten out the territory tree. Each of the row has row action indicating whether the row is same or new or deleted.

RSFD_SMGR_UPD

(SQL Table)

Sales Manager Access Update

This table stores the changes which have happened when the sales manager access program is run to flatten out the territory tree. Each of the row has row action indicating whether the row is same or new or deleted.

# 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 ROW_ACTION Character(1) VARCHAR2(1) NOT NULL Action to take for that row
D=Delete
E=Existing
I=Insert

#	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	ROW_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Action to take for that row D=Delete E=Existing I=Insert