LN_ACTNTYPE_TBL

(SQL Table)
 Index Back

Loan Action Type Table

Table for categorizing Loan Action Codes and Messages (Loan Status & Message/Error Codes) used in the processing of FFELP (CommonLine), Direct Loans, Alternative Loans. Used to provide unique key for non-unique action codes/messages.

  • Parent record: FED_AID_YR_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 LN_ACTION_TYPE Character(1) VARCHAR2(1) NOT NULL Loan Action Type
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: LN_ACTNTYPE_TBL.DESCR