GM_PROP_COMM_VW

(SQL View)
 Index Back

View for GM_PROP_COMMENT table


SELECT A.BUSINESS_UNIT , A.PROPOSAL_ID , A.VERSION_ID , A.GM_COMMENT_TYPE , A.GM_OPPOR_INFO_TYPE , A.DESCRLONG FROM PS_GM_PROP_COMMENT 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 AND B.CURRENT_VERSION = 'Y' AND B.PROPOSAL_FLG = 'S'

  • Related Language Record: GM_PROP_COM_LNG

    • # 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 GM_COMMENT_TYPE Character(3) VARCHAR2(3) NOT NULL Comment Type
    APC=Allocation Percentages
    COI=Conflict of Interest
    CON=Concurrent Submissions
    CST=Cost Sharing
    EXP=Express Proposal
    FLW=Flow Through
    IC=Institution Change
    IP=Intellectual Property
    MJ=Major Goals
    OTH=Other
    PI=PI Change
    PRE=Pre-Award Spending
    PRV=Previous Award
    REL=Related Proposals
    SOL=Solicitation
    UOB=Unobligated Balance
    5 GM_OPPOR_INFO_TYPE Character(3) VARCHAR2(3) NOT NULL Comment Type
    ASM=Assumptions
    GOL=Goals
    OBJ=Objectives
    OBS=Obstacles
    PRP=Purpose
    RSK=Risk
    6 DESCRLONG Long Character CLOB Long Description