LM_ANN_RCPN_HST

(SQL Table)
 Index Back

Announcement Recipient Keys

This record is used to hold the associated key value for recipient groups chosen on 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_RCPNT_GRP_TYPE Character(2) VARCHAR2(2) NOT NULL Recipient Group Type
    1=Learner Group
    2=Job Code
    3=Department
    4=Customer
    5=Learning Environment
    6=Class
    7=Program
    8=System-Wide
    8 LM_RCPNT_GRP Number(15,0) DECIMAL(15) NOT NULL Recipient Group

    Prompt Table: %EDITTABLE

    9 LM_RCPNT_GRP_DESC Character(50) VARCHAR2(50) NOT NULL Recipient Group Description

    Prompt Table: %EDITTABLE