GM_PROP_COMP

(SQL Table)
 Index Back

Proposal Component Grid

  • Related Language Record: GM_PROP_CMP_LNG

  • Parent record: GM_PROPOSAL

    • # 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 SUB_PROP_NBR Character(15) VARCHAR2(15) NOT NULL SUB_PROP_NBR
    5 STATUS_CMPNT_GR Character(3) VARCHAR2(3) NOT NULL Status
    APR=Approved
    ASG=Assigned
    DRF=Draft
    FSH=Finished
    IPG=In Progress
    NOA=Not Approved
    SNB=Send Back

    Default Value: DRF

    6 STATUS_DT Date(10) DATE NOT NULL Status Date

    Default Value: %date

    7 COMPONENT_ID_GR Character(18) VARCHAR2(18) NOT NULL Component ID

    Prompt Table: GM_COMPNT_TBL

    8 REQUIRED_FLG Character(1) VARCHAR2(1) NOT NULL Required Flag

    Y/N Table Edit

    9 GM_SYS_GEN Character(1) VARCHAR2(1) NOT NULL System Generate

    Y/N Table Edit

    Default Value: N

    10 COMMENTS Long Character CLOB Comment