BPW_PRNTFY_INST

(SQL Table)
 Index Back

BPW Instance Notification

  • Related Language Record: BPW_NTFYI_LANG

    • # 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 BPW_PARTY_TYPE Character(1) VARCHAR2(1) NOT NULL Recipient Type
    R=Role
    S=SQL
    U=User
    10 BPW_PARTICIPANTS Character(30) VARCHAR2(30) NOT NULL Recipients
    11 BPW_NOTIFY_LEVEL Character(1) VARCHAR2(1) NOT NULL Level
    P=Process
    S=Steps
    12 BPW_NOTIFY_ALLS Character(1) VARCHAR2(1) NOT NULL All Steps

    Y/N Table Edit

    13 BPW_STEP_LIST Long Character CLOB Step Notify List
    14 BPW_EMAIL_TEXT Character(250) VARCHAR2(250) NOT NULL EMAIL TEXT
    15 BPW_CREATED_OPRID Character(30) VARCHAR2(30) NOT NULL Created By User
    16 BPW_CREATED_DTTM DateTime(26) TIMESTAMP Created Date/Time
    17 BPW_UPDATED_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By User
    18 BPW_UPDATED_DTTM DateTime(26) TIMESTAMP Updated Date/Time