GM_CONT_VW

(SQL View)
Index Back

Grants Award Continuation View


SELECT W.BUSINESS_UNIT , W.CONTRACT_NUM , W.PROPOSAL_ID , W.VERSION_ID FROM PS_GM_AWARD W

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

Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT

2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
3 PROPOSAL_ID Character(25) VARCHAR2(25) NOT NULL Proposal ID
4 VERSION_ID Character(7) VARCHAR2(7) NOT NULL Version ID