BPW_NTFYR_LANG

(SQL Table)
 Index Back

BPW RunControl Notification

  • Related Language Record for BPW_PRNTFY_RUN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 BPW_PROC_TYPE Character(4) VARCHAR2(4) NOT NULL Business Process Type
    RTBL=Real Time Bottom Line
    SYS=System
    USER=User Defined
    3 BPW_PROC_ID Character(30) VARCHAR2(30) NOT NULL Process Weaver ID
    4 BPW_PROC_RUN_CNTL Character(30) VARCHAR2(30) NOT NULL Process Run Control ID
    5 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_RUN.BPW_PROC_STATUS

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

    Default Value: BPW_NOTIFY_RUN.BPW_CRITERIA

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