SFA_STDNT_TRMVW

(SQL View)
 Index Back

Student Fin Aid Term Table

This table contains student information by Institution and Term. The primary use of this table is to provide a consolidated view of student term data for Financial Aid processing purposes. This record is created from Stdnt_Car_Term, if student is continuing; otherwise it is created from Adm_Appl_Prog.

SELECT DISTINCT A.EMPLID ,A.INSTITUTION ,A.STRM ,A.SFA_SPEC_PROG_FLG ,A.SFA_SULA_LOAD ,C.SFA_COD_CRED_LVL ,B.CIP_CODE ,B.SSR_PROG_LEN_TYPE ,B.SSR_PROG_LENGTH ,CASE WHEN D.FA_DFLT_RULE_SET IS NULL THEN ' ' ELSE D.FA_DFLT_RULE_SET END ,E.SFA_PAYPR_STRT_DT ,CASE WHEN F.BASE_WEEKS_ACAD IS NULL THEN 0 ELSE F.BASE_WEEKS_ACAD END ,E.SFA_PAYPR_END_DT FROM PS_STDNT_FA_TERM A LEFT OUTER JOIN PS_STDNT_PELL_RULE F ON F.INSTITUTION = A.INSTITUTION AND F.EMPLID = A.EMPLID AND F.AID_YEAR = A.AID_YEAR AND F.TABLE_ID = '1' AND F.STATUS='A' LEFT OUTER JOIN PS_AID_YEAR_PROG D ON D.INSTITUTION = A.INSTITUTION AND D.AID_YEAR = A.AID_YEAR AND D.ACAD_CAREER = A.ACAD_CAREER AND D.ACAD_PROG = A.ACAD_PROG_PRIMARY , PS_SFA_ACADPLAN_VW B , PS_SFA_CRDLVL_XREF C , PS_AID_YR_CAR_TERM E WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_STDNT_FA_TERM A1 WHERE A1.EMPLID = A.EMPLID AND A1.INSTITUTION = A.INSTITUTION AND A1.STRM = A.STRM AND A1.EFFDT <= %CurrentDateIn ) AND A.EFFSEQ = ( SELECT MAX(A2.EFFSEQ) FROM PS_STDNT_FA_TERM A2 WHERE A2.EMPLID = A.EMPLID AND A2.INSTITUTION = A.INSTITUTION AND A2.STRM = A.STRM AND A2.EFFDT = A.EFFDT) AND A.EFF_STATUS='A' AND A.INSTITUTION = B.INSTITUTION AND A.ACAD_CAREER = B.ACAD_CAREER AND A.ACAD_PLAN = B.ACAD_PLAN AND A.INSTITUTION = C.INSTITUTION AND A.AID_YEAR = C.AID_YEAR AND A.ACAD_CAREER = C.ACAD_CAREER AND A.ACAD_PROG_PRIMARY = C.ACAD_PROG AND A.ACAD_PLAN = C.ACAD_PLAN AND A.INSTITUTION = E.INSTITUTION AND A.AID_YEAR = E.AID_YEAR AND A.ACAD_CAREER = E.ACAD_CAREER AND A.STRM = E.STRM AND A.AID_YEAR >='2015'

  • Parent record: FA_FATERM_PARNT

    • # 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 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_VAL_TBL

    4 SFA_SPEC_PROG_FLG Character(1) VARCHAR2(1) NOT NULL SULA Special Programs Flag
    A=Selective Admission Assoc Deg
    B=2-year Bachelor's Degree
    N=Not Applicable
    P=Prep Crsewk Grad Prof Pgm
    T=Non-Cred Teacher Cert Pgm
    U=Prep Crsewk Ugrad Program
    5 SFA_SULA_LOAD Character(1) VARCHAR2(1) NOT NULL SULA Load field
    F=Full-time
    H=Half-time
    L=Less than Half-time
    Q=Three-Quarter time
    6 SFA_COD_CRED_LVL Character(2) VARCHAR2(2) NOT NULL This field is Credential Level field for COD reporting.
    01=Undergraduate diploma/cert
    02=Associate's degree
    03=Bachelor's degree
    04=Post Baccalaureate certificate
    05=Master's degree
    06=Doctoral degree
    07=First Professional degree
    08=Graduate/Professional cert
    99=Non-credential programs
    7 CIP_CODE Character(13) VARCHAR2(13) NOT NULL CIP code

    Prompt Table: CIP_CODE_TBL

    8 SSR_PROG_LEN_TYPE Character(1) VARCHAR2(1) NOT NULL Program Length Type
    M=Months
    W=Weeks
    Y=Years
    9 SSR_PROG_LENGTH Number(7,3) DECIMAL(6,3) NOT NULL Program Length Value
    10 FA_DFLT_RULE_SET Character(4) VARCHAR2(4) NOT NULL Aid Processing Rule Set
    11 SFA_PAYPR_STRT_DT Date(10) DATE Validated Payment Period Start
    12 BASE_WEEKS_ACAD Number(4,1) DECIMAL(3,1) NOT NULL Academic Base Weeks
    13 SFA_PAYPR_END_DT Date(10) DATE Payment Period end Date