RB_MAILBOX_DEFN

(SQL Table)
 Index Back

MailBox Master Table

This tables stores all the attributes of a MailBox

  • Related Language Record: RB_MAILBOX_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MAILBOX_ID Character(30) VARCHAR2(30) NOT NULL Mail Box Id is an Id associated with Mail Boxes
    2 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    3 MAILBOX_TYPE Character(1) VARCHAR2(1) NOT NULL Identify the type of the Mailbox
    C=Higher Education
    E=External
    H=Internal HR
    I=Internal
    P=Partner

    Default Value: E

    4 MAIL_SERVER_NAME Character(250) VARCHAR2(250) NOT NULL Mail Server Name

    Prompt Table: RB_MAILSRV_DEFN

    5 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    6 EMAIL_ACCOUNT Character(120) VARCHAR2(120) NOT NULL Email Address associated with a Mail Box Id
    7 PASSWORD Character(254) VARCHAR2(254) NOT NULL Password
    8 REPLY_BY_MAIL_ADDR Character(254) VARCHAR2(254) NOT NULL Reply By Email Address is the default ddress used in message replies sent from the ERMS Framework
    9 MAILBOX_POLL_FREQ Number(3,0) SMALLINT NOT NULL Polling Frequency
    10 POLLING_TIME_UNIT Character(1) VARCHAR2(1) NOT NULL Unit of time to use in getting Polling Frequency times for Mailbox
    D=Day(s)
    H=Hour(s)
    M=Minute(s)
    11 AUTO_ACKNOWLEDGEMT Character(1) VARCHAR2(1) NOT NULL Enables/Disables Auto-Acknowledgement Feature
    D=Determine from Rule
    N=Never Auto-Acknowledge
    O=Only while not Auto-Responding
    Y=Always Auto-Acknowledge

    Default Value: Y

    12 AUTO_ACK_PKG_ID Number(10,0) DECIMAL(10) NOT NULL Package Id for Auto Acknowledgement
    13 DEFAULT_WORKLIST Character(30) VARCHAR2(30) NOT NULL Default Worklist Name associated with a MailBox

    Prompt Table: RB_WF_WL_GRP

    14 DEFAULT_PERS_ID Character(15) VARCHAR2(15) NOT NULL Def Pers Id
    15 DEFAULT_PERS_NAME Character(50) VARCHAR2(50) NOT NULL Default Worklist Of

    Prompt Table: RB_PERS_NAME_V2

    16 EXCP_PERS_ID Character(15) VARCHAR2(15) NOT NULL Def Pers Id
    17 EXCP_PERS_NAME Character(50) VARCHAR2(50) NOT NULL Exception Worklist Of

    Prompt Table: RB_PERS_NAME_V3

    18 EXCEPTION_WORKLIST Character(30) VARCHAR2(30) NOT NULL Exception Worklist Name associated with a MailBox

    Prompt Table: RB_WF_WL_GRP

    19 MBOX_OWNER_PERS_ID Character(15) VARCHAR2(15) NOT NULL Def Pers Id
    20 MBOX_OWN_PERS_NAME Character(50) VARCHAR2(50) NOT NULL Mailbox Owner

    Prompt Table: RB_PERS_NAME_V7

    21 MAILBOX_OWNER Character(30) VARCHAR2(30) NOT NULL Identifies the Owner of Mailbox who need to be notified in the event of an Escalation

    Prompt Table: RB_OPR_PERSON_V

    22 INTERNAL_TIMEOUT Number(3,0) SMALLINT NOT NULL Warning Notification
    23 SLA_TIME_UNIT Character(1) VARCHAR2(1) NOT NULL Unit of time to use in SLA units for Mailbox
    D=Day(s)
    H=Hour(s)
    M=Minute(s)
    24 EXTERNAL_TIMEOUT Number(3,0) SMALLINT NOT NULL Final Notification
    25 SLA_TIME_UNIT1 Character(1) VARCHAR2(1) NOT NULL Unit of time to use in SLA units for Mailbox
    D=Day(s)
    H=Hour(s)
    M=Minute(s)
    26 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID

    Prompt Table: RBC_APPCLASS_VW

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

    Prompt Table: RBC_APPRTPATH_V

    28 ROUTING_RULE_TYPE Character(1) VARCHAR2(1) NOT NULL This field is used by Unstrucutred processing which decides on the rule to be used at runtime
    A=Average Query Group Score
    H=Highest Query Group Score
    29 AUTOMATIC_ROUTING Character(1) VARCHAR2(1) NOT NULL This enables Automatic Routing logic which goes thru the ERMS framework, Content Analysis. If turned Off then is routed to Default worklist

    Y/N Table Edit

    Default Value: Y

    30 CONFINE_ROUTING Character(1) VARCHAR2(1) NOT NULL Flag to indicate whether to confine Routing to the selected worklists on Mailbox or not

    Y/N Table Edit

    Default Value: N

    31 CREATE_NEW_CUST Character(1) VARCHAR2(1) NOT NULL Create new customer based on Email Address
    0=Create new user based on Email
    1=Use Anonymous User

    Default Value: 1

    32 DEF_ACTIVITY_ROWS Character(1) VARCHAR2(1) NOT NULL Default rows for Recent Activity

    Default Value: 5

    33 SHOW_CREATE_BTN Character(1) VARCHAR2(1) NOT NULL Enable Quick Create for Activities in Special Address Routing Setup Page

    Y/N Table Edit

    Default Value: N

    34 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_FS_NONVW

    35 RB_LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    ARA=Arabic
    CFR=Canadian French
    CZE=Czech
    DAN=Danish
    DUT=Dutch
    ENG=English
    ESP=Spanish
    FIN=Finnish
    FRA=French
    GER=German
    GRK=Greek
    HEB=Hebrew
    HUN=Hungarian
    ITA=Italian
    JPN=Japanese
    KOR=Korean
    MAY=Bahasa Malay
    NOR=Norwegian
    POL=Polish
    POR=Portuguese
    RUS=Russian
    SVE=Swedish
    THA=Thai
    TUR=Turkish
    ZHS=Simplified Chinese
    ZHT=Traditional Chinese
    36 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    37 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    38 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    39 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    40 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.
    41 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time