GM_PROJECT_ADD (SQL View)	Index Back
Add record for Project This view, which selects nothing, serves as an Add record for the GM Project Setup panel group. It generally has the same search key attributes and search event PeopleCode as the PROJECT record, except that PROJECT_ID is NOT prompted by PROJECT. This avoids the misleading prompt button on PROJECT_ID, which otherwise produces a list of existing (and therefore inappropriate) projects.

GM_PROJECT_ADD

(SQL View)

Add record for Project

This view, which selects nothing, serves as an Add record for the GM Project Setup panel group. It generally has the same search key attributes and search event PeopleCode as the PROJECT record, except that PROJECT_ID is NOT prompted by PROJECT. This avoids the misleading prompt button on PROJECT_ID, which otherwise produces a list of existing (and therefore inappropriate) projects.

select 'BU', 'PROJECT_ID', 'SETID' from PS_INSTALLATION where 1 = 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_PC_NONVW

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

3 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SETID_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_PC_NONVW
2	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SETID_TBL