FO_SALESPRSN_VW (SQL View)	Index Back
Users that have Salesprsn Role This view shows all OPRIDs that have Sales Person Roles associated to them. This view assumes that a Role has been set up called 'Sales Person' and that all users that are sales persons have been assigned to this role. This view is used as a prompt table on the FO_PC_SALESPRSN table.

FO_SALESPRSN_VW

(SQL View)

Users that have Salesprsn Role

This view shows all OPRIDs that have Sales Person Roles associated to them. This view assumes that a Role has been set up called 'Sales Person' and that all users that are sales persons have been assigned to this role. This view is used as a prompt table on the FO_PC_SALESPRSN table.

SELECT a.roleuser FROM PSROLEUSER a WHERE rolename = 'Sales Person'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User