SP_BU_BK3_NONVW (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_NONVW

(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 business_unit , book FROM PS_BU_BOOK_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name