GM_PCL_WF_RL_LN

(SQL Table)
 Index Back

Protocol Workflow Rule Defn

  • Related Language Record for GM_PCL_WF_RULE

    • # 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 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

    Default Value: 1

    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 COMMENTS_254 Character(254) VARCHAR2(254) NOT NULL EDI Comments
    8 NOTES Long Character CLOB Notification Text