GM_PROP_COMMENT

(SQL Table)
 Index Back

Proposal Comments

Used to store all the comments for Proposal. Use GM_COMMENT_TYPE as a key so that we will only have one DESCRLONG for the record.

  • 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

    Prompt Table: SP_BU_PC_NONVW

    2 PROPOSAL_ID Character(25) VARCHAR2(25) NOT NULL Proposal ID

    Prompt Table: GM_PROP_ID_VW

    3 VERSION_ID Character(7) VARCHAR2(7) NOT NULL Version ID

    Prompt Table: GM_PROPOSAL

    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

    Prompt Table: GM_ADD_INFO

    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