RUN_CNTL_EM_PRC

(SQL Table)
Index Back

Run Control for eS Workflow

Record to list each of the Workflow Processes the user wishes to execute with this Run Control.

  • Parent record: RUN_CNTL_EM_WF
  • # 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 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
    4 EM_WF_PROCESS Character(1) VARCHAR2(1) NOT NULL Notification Process
    0=Invoice Verification
    1=Voucher Creation
    2=Match Exceptions
    3=Voucher Approval Creation
    4=Disputed Invoice Lines
    5=Cash Collections
    6=Payment Approval
    7=Payment Creation
    5 PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL Process Flag
    A=Purge All
    S=Only purge items with at least

    Y/N Table Edit

    Default Value: N