GM_PROP_COM_LNG

(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 for GM_PROP_COMMENT GM_PROP_COMM_VW

    • # 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
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCRLONG Long Character CLOB Long Description