GM_PCOMP_STKHR

(SQL Table)
 Index Back

Component Stakeholders

Component Stakeholders

  • Related Language Record: GM_PCMP_STK_LNG

  • Parent record: GM_PROP_COMP

    • # 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
    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 GM_STK_HIRCHY Number(3,0) SMALLINT NOT NULL Stakeholder Hierarchy
    9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: GM_PERSONAL1_VW

    10 GM_WF_ELIGIBLE Character(1) VARCHAR2(1) NOT NULL Workflow Eligible

    Y/N Table Edit

    Default Value: N

    11 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description 20