GM_PROJ_AWD_VW (SQL View)	Index Back
Grants Award View This is a view used as a drop down list box for grants related awards (PC_CONTRACT select GRANTS_FLG ='Y'). This is used for the Grants Project Header panel.

GM_PROJ_AWD_VW

(SQL View)

Grants Award View

This is a view used as a drop down list box for grants related awards (PC_CONTRACT select GRANTS_FLG ='Y'). This is used for the Grants Project Header panel.

SELECT A.BUSINESS_UNIT , %Substring(A.CONTRACT_NUM,1,15) , %Substring(B.TITLE56,1,30) FROM PS_CA_CONTR_HDR A , PS_GM_AWARD B WHERE A.CONTRACT_NUM = B.CONTRACT_NUM

# 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
Set Control Field: BUSINESS_UNIT

2 AWARD_NUM_GM Character(15) VARCHAR2(15) NOT NULL This is a copy of CONTRACT_NUM_PC.

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 Prompt Table: SP_BU_PC_NONVW Set Control Field: BUSINESS_UNIT
2	AWARD_NUM_GM	Character(15)	VARCHAR2(15) NOT NULL	This is a copy of CONTRACT_NUM_PC.
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description