AWD_MSG_COPY

(SQL View)
 Index Back

Award Messages/Comments

This table allows users the ability to define text messages assoiated with an award (Item Type) to be sent to a student on their Financial Aid Notiication Letter.

select setid ,aid_year ,award_msg_cd ,descrlong from PS_AWD_MESSAGE_TBL

  • Related Language Record: AWD_MSG_CPY_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_CS.SETID

    Prompt Table: SP_SETID_NONVW

    2 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: FED_AID_YR_TBL

    3 AWARD_MSG_CD Character(4) VARCHAR2(4) NOT NULL Award Message
    4 DESCRLONG Long Character CLOB Long Description