BPW_NTFYI_LANG

(SQL Table)
 Index Back

BPW Instance Notification

  • Related Language Record for BPW_PRNTFY_INST

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BPW_PROC_PROC_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance Number
    2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    3 BPW_PROC_TYPE Character(4) VARCHAR2(4) NOT NULL Business Process Type
    RTBL=Real Time Bottom Line
    SYS=System
    USER=User Defined
    4 BPW_PROC_ID Character(30) VARCHAR2(30) NOT NULL Process Weaver ID

    Prompt Table: BPW_PROC_DEFN

    5 BPW_PROC_RUN_CNTL Character(30) VARCHAR2(30) NOT NULL Process Run Control ID
    6 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
    7 BPW_CRITERIA Character(1) VARCHAR2(1) NOT NULL Criteria
    C=Custom Event
    P=Process Status
    8 BPW_SEQ_NUM Number(10,0) DECIMAL(10) NOT NULL Sequency Number
    9 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    10 BPW_EMAIL_TEXT Character(250) VARCHAR2(250) NOT NULL EMAIL TEXT