LN_ACTNMSG_TBL

(SQL Table)
 Index Back

Loan Action Message Table

Table for maintaining Loan Action Messages (Loan Message/Error Codes) used in the processing of FFELP, Direct Loans, Alternative Loans. Contains standard CommonLine, Direct Loan, and user-defined action messages.

  • Related Language Record: LN_ACTNMSG_LANG

  • Parent record: LN_ACTNTYPE_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: AID_YEAR_TBL

    2 LOAN_PROGRAM Character(1) VARCHAR2(1) NOT NULL Loan Program
    A=Alternative
    D=Direct Lending
    F=FFELP
    H=Health Professions
    P=Perkins
    S=State
    U=University

    Default Value: D

    3 LN_ACTION_TYPE Character(1) VARCHAR2(1) NOT NULL Loan Action Type

    Prompt Table: LN_ACTNTYPE_TBL

    4 LN_ACTION_MSG Character(4) VARCHAR2(4) NOT NULL Message Code
    5 LN_ACTION_CTGRY Character(1) VARCHAR2(1) NOT NULL Loan Action Category
    A=Accept - Allow Processing
    R=Reject - Hold Processing
    S=Status - Information Only
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: LN_ACTNMSG_TBL.DESCR

    8 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
    9 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.