RB_EMAIL_FILTER

(SQL Table)
 Index Back

Stores all Custom Filters

This is the table all Custom Mail Filters are stored and will be used by Mail Reader to do the Filteration

  • Related Language Record: RB_EMAIL_FLT_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MAIL_FILTER_ID Character(30) VARCHAR2(30) NOT NULL Id filed of Mail filter Table
    2 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
    A=Active
    I=Inactive

    Default Value: A

    3 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID

    Prompt Table: RBC_APPCLASS_VW

    4 APPCLASS_PATH Character(254) VARCHAR2(254) NOT NULL Application Class Full Path

    Prompt Table: RBC_APPRTPATH_V

    5 LOG_EMAIL_EXP_LOGS Character(1) VARCHAR2(1) NOT NULL Field is a Flag that is used for logging teh E-mail if it is identified by the filters

    Y/N Table Edit

    Default Value: N

    6 DESCRLONG Long Character CLOB Long Description
    7 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    8 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    9 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    10 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    11 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    12 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time