GM_COMP_ROUTING

(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 A.GM_ELEMENTS = 'C' AND A.SEQ_NUM = ( SELECT MIN(B.SEQ_NUM) FROM PS_GM_WF_ROUTING B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.GM_TRANS_TYPE = B.GM_TRANS_TYPE AND A.GM_ELEMENTS = B.GM_ELEMENTS AND A.GM_ELEMENT_VALUE = B.GM_ELEMENT_VALUE GROUP BY B.BUSINESS_UNIT, B.GM_TRANS_TYPE, B.GM_ELEMENTS, B.GM_ELEMENT_VALUE)

  • 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 GM_ELEMENT_VALUE Character(18) VARCHAR2(18) NOT NULL GM_ELEMENT_VALUE
    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

    Default Value: A

    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

    Default Value: W

    11 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

    Default Value: 1