SP_BU_BK3_CLSVW (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_CLSVW

(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.oprclass , b.business_unit , b.book FROM PS_SEC_BUBOOK_CLS 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 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class

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	OPRCLASS	Character(30)	VARCHAR2(30) NOT NULL	Operator Class
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name