SP_PROJ3_NONVW (SQL View)	Index Back
Project Add Mode for PC View Used to display a prompt box that displays only projects that match the business_unit_pc found in the buffer.

SP_PROJ3_NONVW

(SQL View)

Project Add Mode for PC View

Used to display a prompt box that displays only projects that match the business_unit_pc found in the buffer.

SELECT BUSINESS_UNIT , PROJECT_ID , DESCR FROM PS_PROJECT_FS

Related Language Record: PROJID_ADPC_LVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
2	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description