LN_ORIGMSG_VW

(SQL View)
Index Back

Loan Orig Msg View

Loan Origination Message View

SELECT A.AID_YEAR , A.LOAN_PROGRAM , A.LN_ACTION_MSG , A.DESCR , A.DESCRSHORT ,MESSAGE_SET_NBR ,MESSAGE_NBR FROM PS_LN_ACTNMSG_TBL A WHERE A.LN_ACTION_TYPE = 'O'

  • Related Language Record: LNORIGMSGVWLNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
    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
    3 LN_ACTION_MSG Character(4) VARCHAR2(4) NOT NULL Message Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
    7 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.