SP_BU_BK3_OPRVW (SQL View)	Index Back
Sec Vw - Books by Bus Unit This is currently only used in a the Retire by Category Query. The Business Unit and Book are made as not required. This will allow the prompt in the pivot to list the available books for all business units.

SP_BU_BK3_OPRVW

(SQL View)

Sec Vw - Books by Bus Unit

This is currently only used in a the Retire by Category Query. The Business Unit and Book are made as not required. This will allow the prompt in the pivot to list the available books for all business units.

SELECT a.oprid , b.business_unit , b.book FROM PS_SEC_BUBOOK_OPR a , ps_bu_book_tbl b WHERE a.business_unit = b.business_unit AND a.book = b.book

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name