PGM_PROGM (SQL View)	Index Back
Prompt view for programs This is a prompt view that will return projects which are programs (a.k.a. summary projects).

PGM_PROGM

(SQL View)

Prompt view for programs

This is a prompt view that will return projects which are programs (a.k.a. summary projects).

SELECT BUSINESS_UNIT ,PROJECT_ID , DESCR FROM %Table(PROJECT) WHERE SUMMARY_PRJ = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL 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	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description