GM_CP_ROUT_RULE

(SQL View)
 Index Back

Component WF Routing


SELECT A.BUSINESS_UNIT , A.GM_TRANS_TYPE , A.GM_ELEMENTS , A.GM_ELEMENT_VALUE , A.PROF_ROLE_TYPE , A.GM_REQ_APPER , A.GM_PERFORM_ACT , A.GM_WF_POOL , A.GM_REASSIGN , A.GM_WF_IN_PROG , A.SEQ_NUM FROM %Table(GM_WF_ROUTING) A WHERE GM_TRANS_TYPE = 'PG' AND GM_ELEMENTS = 'C'

  • Parent record: GM_CMP_WF_REQ

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_CA.BUSINESS_UNIT

    Prompt Table: SP_BU_CA_NONVW

    2 GM_TRANS_TYPE Character(2) VARCHAR2(2) NOT NULL Transaction Type
    PB=Protocol Batch Notification
    PG=Proposal Component Approval
    PM=Milestone Notfication
    PN=Protocol Notification
    PP=Proposal Notification
    PT=Protocol Approval
    3 GM_ELEMENTS Character(1) VARCHAR2(1) NOT NULL Element
    A=Protocol Approval
    B=Protocol Batch Notification
    C=Proposal Components
    M=Award Milestone
    N=Protocol Notification
    S=Proposal Status
    4 COMPONENT_ID_GR Character(18) VARCHAR2(18) NOT NULL Component ID
    5 PROF_ROLE_TYPE Character(4) VARCHAR2(4) NOT NULL Role Type

    Prompt Table: %EDITTABLE14

    6 GM_REQ_APPER Character(1) VARCHAR2(1) NOT NULL GM_REQ_APPER

    Y/N Table Edit

    7 GM_PERFORM_ACT Character(1) VARCHAR2(1) NOT NULL GM_PERFORM_ACT
    A=Approve
    N=Notify
    R=Review
    8 GM_WF_POOL Character(1) VARCHAR2(1) NOT NULL Pool List

    Y/N Table Edit

    9 GM_REASSIGN Character(1) VARCHAR2(1) NOT NULL GM_REASSIGN

    Y/N Table Edit

    10 GM_WF_IN_PROG Character(1) VARCHAR2(1) NOT NULL Action When In Progress
    B=Worklist/Email
    E=Email Notification Only
    W=Worklist Only
    11 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence