LM_NOTIFLNK_HST

(SQL Table)
Index Back

Link Detail for Notifications

Detail link information for the Ad Hoc Notify and Announce component.

  • Parent record: LM_NOTIF
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
    2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
    3 LM_NOTIF_TRANS_ID Number(10,0) DECIMAL(10) NOT NULL Notification ID
    4 LM_DATE_POSTED Date(10) DATE Date Announcment posted and/or email notifications sent.
    5 LM_DELIVERY_METHOD Character(1) VARCHAR2(1) NOT NULL The delivery methods available for ad-hoc notifications and announcements.
    A=Announcement
    B=Both Email and Announcement
    E=Email Notification
    6 LM_MSG_ABBREVIATED Character(100) VARCHAR2(100) NOT NULL Message
    7 LM_LINK_TYPE Character(1) VARCHAR2(1) NOT NULL Link Type
    A=Class
    C=Course
    L=Location
    P=Program
    S=Search Text
    8 LM_NOTIF_LINK_KEY Number(15,0) DECIMAL(15) NOT NULL Link Key
    9 LM_NOTIF_LINK_DESC Character(50) VARCHAR2(50) NOT NULL Link Key

    Prompt Table: %EDITTABLE

    10 LM_LINK_URL Long Character(2000) VARCHAR2(2000) URL