ANTC_AID_PLANVW

(SQL View)
 Index Back

Antic Aid Summary Detail

The Anticipated Financial Aid table stores the amount of financial aid per award that is anticipated for a given disbursement period within a term. Once the aid has been disbursed (posted to the student account) the anticipated amount is decreased by the disbursed amount. Rows are added to the table each time activity that impacts the disbursemment amount takes place.

select DISTINCT a.EMPLID ,a.INSTITUTION ,a.AID_YEAR ,a.ITEM_TYPE ,a.ACAD_CAREER ,a.DISBURSEMENT_PLAN from PS_ANTICIPATED_AID a

  • Parent record: STUDENT_AID

    • # 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 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

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

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: AID_YEAR_TBL

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

    Prompt Table: ITEM_TYPE_FA

    5 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine
    6 DISBURSEMENT_PLAN Character(2) VARCHAR2(2) NOT NULL Disbursement Plan