STDNT_FA_TRM_V2

(SQL View)
 Index Back

Student Fin Aid Term View 2

This table contains student information from STDNT_FA_TERM. The primary use of this table is to provide a consolidated view of student term data for review in the Packaging Status pages. It selects max effective data and sequence, without regard to effective status.

SELECT A.EMPLID , A.INSTITUTION , A.AID_YEAR , A.STRM , A.EFFDT , A.EFF_STATUS , A.ACAD_CAREER , A.ACAD_PROG_PRIMARY , A.ACAD_PLAN , A.ACAD_SUB_PLAN , A.FORM_OF_STUDY , A.WEEKS_OF_INSTRUCT , A.FA_STANDING , A.NSLDS_LOAN_YEAR , A.ACAD_LEVEL_BOT , A.FA_LOAD , A.ACADEMIC_LOAD , A.ACAD_LOAD_APPR , A.ADMIT_TERM , A.EXP_GRAD_TERM , A.EXP_GRAD_DATE , A.WITHDRAW_CODE , A.WITHDRAW_DATE , A.WITHDRAW_REASON , A.LS_GPA , A.CUM_GPA , A.UNT_TAKEN_FA , A.UNT_PASSD_FA , A.TOT_TAKEN_FA , A.TOT_PASSD_FA , A.TOT_TERM_UNT_FA , A.REMOTE_UNT_FA , A.CUM_RESIDENT_TERMS , A.CUR_RESIDENT_TERMS , A.TRF_RESIDENT_TERMS , A.EXT_ORG_ID , A.STUDY_AGREEMENT , A.COUNTRY , A.START_DATE , A.END_DATE , A.SFA_ENRL_INTENSITY FROM PS_STDNT_FA_TERM A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_STDNT_FA_TERM B WHERE B.EMPLID = A.EMPLID AND B.INSTITUTION = A.INSTITUTION AND B.AID_YEAR = A.AID_YEAR AND B.STRM = A.STRM AND B.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(B1.EFFSEQ) FROM PS_STDNT_FA_TERM B1 WHERE B1.EMPLID = A.EMPLID AND B1.INSTITUTION = A.INSTITUTION AND B1.AID_YEAR = A.AID_YEAR AND B1.STRM = A.STRM AND B1.EFFDT = A.EFFDT)

  • 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

    Prompt Table: INSTITUTION_TBL

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

    Prompt Table: STUDENT_AID

    4 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_VAL_TBL

    5 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    7 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
    8 ACAD_PROG_PRIMARY Character(5) VARCHAR2(5) NOT NULL Primary Academic Program
    9 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
    10 ACAD_SUB_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Sub-Plan
    11 FORM_OF_STUDY Character(4) VARCHAR2(4) NOT NULL Form of Study
    ABRD=Study Abroad
    CAND=Advanced to Candidacy
    DTCH=Detached Study
    ENRL=Class Enrollment
    12 WEEKS_OF_INSTRUCT Number(2,0) SMALLINT NOT NULL Weeks of Instruction
    13 FA_STANDING Character(4) VARCHAR2(4) NOT NULL FA Standing
    14 NSLDS_LOAN_YEAR Character(1) VARCHAR2(1) NOT NULL NSLDS Loan Year
    0=1st Year - Never Attended
    1=1st Year - Previously Attended
    2=2nd Year
    3=3rd Year
    4=4th Year
    5=5th Year+
    A=1st Year Graduate
    B=2nd Year Graduate
    C=3rd Year Graduate
    D=4th or more Graduate
    G=Graduate/Professional
    15 ACADEMIC_LEVEL Character(3) VARCHAR2(3) NOT NULL Academic Level
    00=Not Set
    01=First Year
    02=Second Year
    03=Third Year
    04=Fourth Year
    05=Fifth Year
    06=Sixth Year
    10=Freshman
    20=Sophomore
    30=Junior
    40=Senior
    50=Post-Bacc Undergraduate
    GR=Graduate
    GRA=Graduate AUS
    HON=Honours
    IE=Industrial Experience
    MAS=Masters
    P1=Professional Year 1
    P2=Professional Year 2
    P3=Professional Year 3
    P4=Professional Year 4
    PHD=PhD
    16 FA_LOAD Character(1) VARCHAR2(1) NOT NULL Financial Aid Load
    F=Enrolled Full-Time
    H=Enrolled Half-Time
    L=Less than Half-Time
    N=No Unit Load
    T=Three Quarter Time
    17 ACADEMIC_LOAD Character(1) VARCHAR2(1) NOT NULL Academic Load
    F=Enrolled Full-Time
    H=Enrolled Half-Time
    L=Less than Half-Time
    N=No Unit Load
    P=Enrolled Part-Time
    T=Three Quarter Time
    18 ACAD_LOAD_APPR Character(1) VARCHAR2(1) NOT NULL Approved Academic Load
    B=Vocational Coaching (NLD)
    D=Dual (NLD)
    E=Part-time Vocational Tr (NLD)
    F=Full-Time
    O=Vocational Training (NLD)
    P=Part-Time
    19 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL Admit Term
    20 EXP_GRAD_TERM Character(4) VARCHAR2(4) NOT NULL Expected Graduation Term
    21 EXP_GRAD_DATE Date(10) DATE Expected Grad Date
    22 WITHDRAW_CODE Character(3) VARCHAR2(3) NOT NULL Withdrawal \ Cancel
    CAN=Cancelled
    NWD=
    WDR=Withdrew
    23 WITHDRAW_DATE Date(10) DATE Withdrawal \ Cancel Date
    24 WITHDRAW_REASON Character(4) VARCHAR2(4) NOT NULL Withdrawal \ Cancel Reason
    MEDI=Medical
    NPAY=Non-Payment of Fees
    RETR=Retroactive
    25 LS_GPA Number(9,3) DECIMAL(8,3) NOT NULL GPA
    26 CUM_GPA Number(9,3) DECIMAL(8,3) NOT NULL Cumulative GPA
    27 UNT_TAKEN_FA Number(9,3) DECIMAL(8,3) NOT NULL Fin Aid Progress Units Taken
    28 UNT_PASSD_FA Number(9,3) DECIMAL(8,3) NOT NULL Fin Aid Progress Units Passed
    29 TOT_TAKEN_FA Number(9,3) DECIMAL(8,3) NOT NULL Total Fin Aid Units Taken
    30 TOT_PASSD_FA Number(9,3) DECIMAL(8,3) NOT NULL Total Fin Aid Units Passed
    31 TOT_TERM_UNT_FA Number(9,3) DECIMAL(8,3) NOT NULL Total Term Units
    32 REMOTE_UNT_FA Number(9,3) DECIMAL(8,3) NOT NULL Remote Units
    33 CUM_RESIDENT_TERMS Number(7,3) DECIMAL(6,3) NOT NULL Cumulative In Residence Terms
    34 CUR_RESIDENT_TERMS Number(7,3) DECIMAL(6,3) NOT NULL Current In Residence Terms
    35 TRF_RESIDENT_TERMS Number(7,3) DECIMAL(6,3) NOT NULL Transfer In Residence Terms
    36 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    37 STUDY_AGREEMENT Character(10) VARCHAR2(10) NOT NULL Study Agreement
    38 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    39 START_DATE Date(10) DATE Start Date for Gen Standing PO
    40 END_DATE Date(10) DATE End Date
    41 SFA_ENRL_INTENSITY Number(4,2) DECIMAL(3,2) NOT NULL Enrollment Intensity Percent