BPW_NTFYD_LANG

(SQL Table)
 Index Back

BPW Process Defn Notification

  • Related Language Record for BPW_PRNTFY_DEFN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BPW_PROC_TYPE Character(4) VARCHAR2(4) NOT NULL Business Process Type
    RTBL=Real Time Bottom Line
    SYS=System
    USER=User Defined

    Prompt Table: BPW_PRCTYPE_VW

    2 BPW_PROC_ID Character(30) VARCHAR2(30) NOT NULL Process Weaver ID

    Prompt Table: BPW_PROC_DEFN

    3 BPW_PROC_STATUS Character(2) VARCHAR2(2) NOT NULL Process Status for Business Process Weaver. - Any change should be reflected in BUSINESS_PROCESS_WEAVER:ENUM:ProcessStatus - "Summarized" status is by xlate value so make so to choose the proper value for new status.
    10=Skipped
    15=Cancelled
    20=Complete
    22=Compl/Warning
    25=Complete/Error
    30=Paused After
    40=Not Started
    50=Paused Before
    60=Started
    70=On Hold
    90=Error

    Default Value: BPW_NOTIFY_DEFN.BPW_PROC_STATUS

    4 BPW_CRITERIA Character(1) VARCHAR2(1) NOT NULL Criteria
    C=Custom Event
    P=Process Status

    Default Value: BPW_NOTIFY_DEFN.BPW_CRITERIA

    5 BPW_SEQ_NUM Number(10,0) DECIMAL(10) NOT NULL Sequency Number
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 BPW_EMAIL_TEXT Character(250) VARCHAR2(250) NOT NULL EMAIL TEXT