GM_AWARD_PRJ_VW

(SQL View)
Index Back

Distinct Projects for a Contra

Distinct Projects for a Contract View

SELECT DISTINCT CONTRACT_NUM , PROJECT_ID FROM PS_CA_DETAIL_PROJ

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

Prompt Table: CA_CNTR_SRCH_VW

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

Default Value: PROJECT.PROJECT_ID

Prompt Table: PROJECT