GM_EC_PROP_RESR

(SQL View)
Index Back

Grants EDI Other Supp Overlap


SELECT A.BUSINESS_UNIT, A.PROPOSAL_ID, A.VERSION_ID, A.SUB_PROP_NBR, A.GRANTS_RES_TYPE, A.DESCRLONG FROM PS_GM_PROP_J_RES A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PROPOSAL_ID Character(25) VARCHAR2(25) NOT NULL Proposal ID
3 VERSION_ID Character(7) VARCHAR2(7) NOT NULL Version ID
4 SUB_PROP_NBR Character(15) VARCHAR2(15) NOT NULL SUB_PROP_NBR
5 GRANTS_RES_TYPE Character(5) VARCHAR2(5) NOT NULL Resource Type
6 DESCRLONG Long Character CLOB Long Description