LN_ITEM_TBL

(SQL Table)
 Index Back

Loan Item Type Table

Record used to select the Item Types (Loan Awards) that are associated with this Loan Type. Establishes the link between the Award record and the Origination record.

  • Parent record: LN_TYPE_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

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

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: AID_YEAR_TBL

    3 LOAN_TYPE Character(4) VARCHAR2(4) NOT NULL Loan Type Cd
    4 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: LN_SETID_VW.SETID

    Prompt Table: LN_SETID_VW

    5 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

    Default Value: ITEM_TYPE_LN_VW.ITEM_TYPE

    Prompt Table: ITEM_TYPE_LN_VW

    6 LN_ITEM_NUM Number(1,0) SMALLINT NOT NULL Loan Item Nbr Seq
    7 TABLE_ID Character(1) VARCHAR2(1) NOT NULL Child Table Key

    Default Value: L