LN_AGGR_RPT_VW

(SQL View)
 Index Back

Ln Aggr Vw-Loan Doc Print SQR

Loan Aggregate View for Loan Document Printing

SELECT A.EMPLID , A.AGGREGATE_AREA , A.AID_YEAR , A.AGGREGATE_LEVEL , A.AGGREGATE_TOTAL , B.CPS_SCHOOL_CODE , B.AGGREGATE_STATUS , B.EXPECTED_AWARD , B.ACTUAL_AWARD , B.SCHEDULED_AWARD , C.DESCR , C.FIN_AID_TYPE , C.LOAN_PROGRAM , C.LOAN_INTEREST_ATTR , C.AGGREGATE_PROGRAM , F.DESCRSHORT FROM PS_STDNT_AGGR_AY A , PS_STDNT_AGGR_SCHL B , PS_AGGR_LIMIT_TBL C , PS_AGGR_LVL_XREF F WHERE A.EMPLID = B.EMPLID AND A.AID_YEAR = B.AID_YEAR AND A.AID_YEAR = C.AID_YEAR AND A.AGGREGATE_LEVEL = B.AGGREGATE_LEVEL AND A.AGGREGATE_AREA = B.AGGREGATE_AREA AND A.AGGREGATE_AREA = C.AGGREGATE_AREA AND A.AGGREGATE_LEVEL = F.AGGREGATE_LEVEL AND C.FIN_AID_TYPE = 'L' AND C.EFFDT = ( SELECT MAX (C1.EFFDT) FROM PS_AGGR_LIMIT_TBL C1 WHERE C1.AGGREGATE_AREA = C.AGGREGATE_AREA AND C1.EFFDT <= %CurrentDateIn) AND C.EFF_STATUS = 'A'

  • Related Language Record: LNAGGRRPTVWLNG

  • Parent record: STDNT_AGGR_LIFE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    2 AGGREGATE_AREA Character(10) VARCHAR2(10) NOT NULL Aggregate Area

    Prompt Table: STDNT_AGGR_LIFE

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

    Prompt Table: FED_AID_YR_TBL

    4 AGGREGATE_LEVEL Character(2) VARCHAR2(2) NOT NULL Aggregate Level

    Prompt Table: AGGR_LVL_VW

    5 AGGR_AMOUNT Number(12,2) DECIMAL(11,2) NOT NULL Aggregate Amount
    6 CPS_SCHOOL_CODE Character(6) VARCHAR2(6) NOT NULL CPS School Code. Also known as Title IV School Code
    7 AGGREGATE_STATUS Character(1) VARCHAR2(1) NOT NULL Aggregate Status
    I=Imported
    R=Internal to System
    8 EXPECTED_AWARD Number(12,2) DECIMAL(11,2) NOT NULL Expected Award
    9 ACTUAL_AWARD Number(12,2) DECIMAL(11,2) NOT NULL Actual Award
    10 SCHEDULED_AWARD Number(12,2) DECIMAL(11,2) NOT NULL Scheduled Award
    11 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    12 FIN_AID_TYPE Character(4) VARCHAR2(4) NOT NULL Fin Aid Type
    A=Athletic
    B=Bursary
    F=Fellowship
    G=Grant
    L=Loan
    S=Scholarship
    V=Waiver
    W=Work/Study
    13 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
    14 LOAN_INTEREST_ATTR Character(1) VARCHAR2(1) NOT NULL Loan Interest Attribute
    S=Subsidized
    U=Unsubsidized
    15 AGGREGATE_PROGRAM Character(4) VARCHAR2(4) NOT NULL Aggregate Program
    DLHL=DIRECT - HEAL
    DSTF=DIRECT - STAFFORD
    FLHL=FFELP - HEAL
    FSTF=FFELP - STAFFORD
    16 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description