RSF_FIN_WRKR_VW (SQL View)	Index Back
Active Sales Users View of all Active Sales Users in Finance

RSF_FIN_WRKR_VW

(SQL View)

Active Sales Users

View of all Active Sales Users in Finance

SELECT P.PERSON_ID , B.BO_ID , B.BO_NAME , B.BO_NAME , B.BO_NAME_DISPLAY FROM PS_BO_NAME B , PS_RD_PERSON P , PS_BO_ROLE R WHERE P.BO_ID = B.BO_ID AND P.BO_ID = R.BO_ID AND B.PRIMARY_IND = 'Y' AND ROLE_TYPE_ID = 4 AND P.MARKET = 'FIN'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
Prompt Table: RSF_SUSER

2 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

3 NAME Character(50) VARCHAR2(50) NOT NULL Name

4 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

5 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID Prompt Table: RSF_SUSER
2	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
4	BO_NAME	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
5	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object