TR_EVENT_CD_TBL

(SQL Table)
 Index Back

Event codes used in system.

Stores the event codes used in the system.

  • Related Language Record: TR_EVENT_CD_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EVENT_CODE Character(15) VARCHAR2(15) NOT NULL Event code that corresponds to a specific type of event. Can be used for finer filtering of events.
    2 DESCR150_MIXED Character(150) VARCHAR2(150) NOT NULL Description
    3 EVENT_MODE Character(1) VARCHAR2(1) NOT NULL Defines whether to process event synchronously or asynchronously.
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    4 EVENT_ACTION_TYPE Character(1) VARCHAR2(1) NOT NULL Event Action Type used to detemine what type of process to execute.
    P=Person
    R=Role
    5 EVENT_ACTION Character(127) VARCHAR2(127) NOT NULL Treasury fully qualified path varaible for AE and App Classes
    6 EVENT_NOTIFY Character(1) VARCHAR2(1) NOT NULL Determines whether the event should create a notification or not.
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    7 EVENT_NOTIFY_TYPE Character(1) VARCHAR2(1) NOT NULL Determines whether to send the notification to individuals or roles.
    P=Person
    R=Role
    8 EVENT_NOTIFY_TEMPL Character(127) VARCHAR2(127) NOT NULL Identifies which E-Mail template to use for notification.

    Prompt Table: WL_TEMPLATE_GEN

    9 EVENT_NOTIFY_TO Character(127) VARCHAR2(127) NOT NULL Stores who the recipients of the notification are.