GM_AWARD_VW

(SQL View)
 Index Back

View of Award

Used as prompt box in GM_PROP_PREV_AW. Key name for BUSINESS_UNIT is slightly changed because of the requirements for the secondary panel.

SELECT a.business_unit , a.contract_num , a.emplid , a.name , a.proposal_id , a.title56 , a.descr254 FROM ps_gm_award a , PS_GM_PROPOSAL b WHERE a.business_unit = b.business_unit AND a.proposal_id = b.proposal_id AND a.version_id = b.version_id

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_AWD Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_PC_NONVW

2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSONAL_DATA

4 NAME Character(50) VARCHAR2(50) NOT NULL Name
5 PROPOSAL_ID Character(25) VARCHAR2(25) NOT NULL Proposal ID

Default Value: GM_PROPOSAL.PROPOSAL_ID

Prompt Table: GM_PROP_ID_VW

6 TITLE56 Character(56) VARCHAR2(56) NOT NULL TITLE56

Default Value: GM_PROPOSAL.TITLE56

7 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254