RCN_STATUS_TBL

(SQL Table)
 Index Back

Recon status table

Reconciliation status table

  • Related Language Record: RCN_STATUS_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RCN_STATUS Character(4) VARCHAR2(4) NOT NULL Reconciliation Status field
    2 RCN_STATUS_TYPE Character(1) VARCHAR2(1) NOT NULL Reconciliation Status Type field. Yes if this status is reconcile and No if this status is not a reconciled status.

    Y/N Table Edit

    Default Value: N

    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 ENABLE_WF_SW Character(1) VARCHAR2(1) NOT NULL Allows a user to enable workflow worklist processing for automated reconciliation purposes. Th
    F=Nofitication Framework
    N=No Workflow
    Y=Workflow

    Y/N Table Edit

    Default Value: N

    6 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
    7 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).
    8 EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow
    9 WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name