LN_ACTNCD_TBL

(SQL Table)
 Index Back

Loan Action Code Table

Table for maintaining Loan Action Codes (Loan Status) used in the processing of FFELP, Direct Loans, Alternative Loans. Contains standard CommonLine, Direct Loan, and user-defined action codes.

  • Related Language Record: LN_ACTNCD_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: FED_AID_YR_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_CD Character(4) VARCHAR2(4) NOT NULL Loan Action Cd
    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_ACTNCD_TBL.DESCR