EX_PROJ_BUS_VW (SQL View)	Index Back
Distinct Proj Business Units This view is distinct business from the PROJ_ACTIVITY table. It's used in the view definition for EX_PROJ_BU_VW.

EX_PROJ_BUS_VW

(SQL View)

Distinct Proj Business Units

This view is distinct business from the PROJ_ACTIVITY table. It's used in the view definition for EX_PROJ_BU_VW.

SELECT DISTINCT BUSINESS_UNIT FROM PS_PROJ_ACTIVITY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: PROJECT.BUSINESS_UNIT
Prompt Table: SP_BU_PC_NONVW