SFASTDTRMBDGTVW

(SQL View)
 Index Back

Student Term Budget

Use STDNT_TERM_BDGT and STDNT_BUDGET_IT to assign a financial aid budget to a student for a specific term. STDNT_TERM_BDGT identifies the specific type of budget for the term, and STDNT_BUDGET_IT contains all of the items or budget components that make up the budget. For example, Dependent students who are undergraduate, majoring in liberal arts, and living on campus would have a specific cost of attendance or budget. The items or components of that budget could be tuition, books, living expenses, and transportation. Each of these items would have a cost associated with them and in total make up the cost of attendance for the term.

SELECT A.EMPLID ,A.INSTITUTION ,A.AID_YEAR ,A.ACAD_CAREER ,A.STRM ,A.BUDGET_GROUP_CODE ,A.DESCRSHORT ,A.OPRID ,A.TERM_TYPE ,A.ACAD_PROG_PRIMARY ,A.ACAD_PLAN ,A.ACAD_SUB_PLAN ,A.ACADEMIC_LOAD ,A.ACAD_LOAD_APPR ,A.ACAD_LEVEL_PROJ ,A.ACAD_LEVEL_BOT ,A.FA_LOAD ,A.FORM_OF_STUDY ,A.RESIDENCY ,A.FIN_AID_FED_RES ,A.FIN_AID_ST_RES ,A.FIN_AID_FED_EXCPT ,A.FIN_AID_ST_EXCPT ,A.STATE_RESIDENCE ,A.APP_STATE_RESIDENC ,A.HOUSING_TYPE ,A.FED_TERM_COA ,A.INST_TERM_COA ,A.PELL_TERM_COA ,A.MARITAL_STAT ,A.NUMBER_IN_FAMILY ,A.DEPNDNCY_STAT ,A.NSLDS_LOAN_YEAR ,A.PRORATE_BUDGET ,A.POSTAL ,A.FA_UNIT_ANTIC ,A.FA_UNIT_COMPLETED ,A.FA_UNIT_IN_PROG ,A.FA_UNIT_CURRENT ,A.ACAD_PLAN_TYPE ,A.FA_TERM_EFFDT ,A.FA_TERM_EFFSEQ ,A.FA_LOAD_CURRENT FROM PS_STDNT_TERM_BDGT A WHERE A.EFFDT = ( SELECT MAX(A2.EFFDT) FROM PS_STDNT_TERM_BDGT A2 WHERE A2.EMPLID = A.EMPLID AND A2.INSTITUTION = A.INSTITUTION AND A2.AID_YEAR = A.AID_YEAR AND A2.ACAD_CAREER = A.ACAD_CAREER AND A2.STRM = A.STRM AND A2.EFFDT <= %CurrentDateIn ) AND A.EFFSEQ = ( SELECT MAX(A3.EFFSEQ) FROM PS_STDNT_TERM_BDGT A3 WHERE A3.EMPLID = A.EMPLID AND A3.INSTITUTION = A.INSTITUTION AND A3.AID_YEAR = A.AID_YEAR AND A3.ACAD_CAREER = A.ACAD_CAREER AND A3.STRM = A.STRM AND A3.EFFDT = ( SELECT MAX(A4.EFFDT) FROM PS_STDNT_TERM_BDGT A4 WHERE A4.EMPLID = A3.EMPLID AND A4.INSTITUTION = A3.INSTITUTION AND A4.AID_YEAR = A3.AID_YEAR AND A4.ACAD_CAREER = A3.ACAD_CAREER AND A4.STRM = A3.STRM AND A4.EFFDT <= %CurrentDateIn ) )

  • Related Language Record: SFSTDTRMBGTVWLN

  • Parent record: STDNT_CR_TERM

    • # 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 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

    Prompt Table: STDNT_CR_TRM_VW

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

    Prompt Table: STDNT_CR_TERM

    6 BUDGET_GROUP_CODE Character(6) VARCHAR2(6) NOT NULL Budget Group Code

    Prompt Table: BUDGET_GRP_VW

    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: BUDGET_GRP_TBL.DESCR

    8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    9 TERM_TYPE Character(1) VARCHAR2(1) NOT NULL Term Unit Type
    C=Clock Hours
    E=Continuing Education Units
    Q=Quarter Hours
    S=Semester Hours
    T=Trimester Hours
    U=Units
    10 ACAD_PROG_PRIMARY Character(5) VARCHAR2(5) NOT NULL Primary Academic Program
    11 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
    12 ACAD_SUB_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Sub-Plan
    13 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
    14 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
    15 ACAD_LEVEL_PROJ Character(3) VARCHAR2(3) NOT NULL Academic Level - Projected
    16 ACAD_LEVEL_BOT Character(3) VARCHAR2(3) NOT NULL Academic Level - Term Start
    17 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
    18 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
    19 RESIDENCY Character(5) VARCHAR2(5) NOT NULL Residency
    20 FIN_AID_FED_RES Character(5) VARCHAR2(5) NOT NULL Fin Aid Federal Residency
    21 FIN_AID_ST_RES Character(5) VARCHAR2(5) NOT NULL Fin Aid State Residency
    22 FIN_AID_FED_EXCPT Character(5) VARCHAR2(5) NOT NULL Fin Aid Fed Residency Excpt
    23 FIN_AID_ST_EXCPT Character(5) VARCHAR2(5) NOT NULL Fin Aid St Residency Excpt
    24 STATE_RESIDENCE Character(6) VARCHAR2(6) NOT NULL State of Residence
    25 APP_STATE_RESIDENC Character(2) VARCHAR2(2) NOT NULL Application State Residence
    26 HOUSING_TYPE Character(1) VARCHAR2(1) NOT NULL Projected Housing Type
    1=On Campus Housing
    2=With Parent
    2=Off Campus Housing
    3=Off Campus
    3=Parent's Home
    4=Relative's Home

    Default Value: 1

    27 FED_TERM_COA Number(9,2) DECIMAL(8,2) NOT NULL Fed Term COA
    28 INST_TERM_COA Number(9,2) DECIMAL(8,2) NOT NULL Inst Term COA
    29 PELL_TERM_COA Number(9,2) DECIMAL(8,2) NOT NULL Pell Term COA
    30 MARITAL_STAT Character(1) VARCHAR2(1) NOT NULL Marital Status
    1=Single
    2=Married
    3=Separated
    4=Divorced
    5=Widowed
    31 NUMBER_IN_FAMILY Character(2) VARCHAR2(2) NOT NULL Nbr Family Members
    32 DEPNDNCY_STAT Character(1) VARCHAR2(1) NOT NULL Dependency Status
    1=Independent
    2=Dependent
    3=Indepenedent/Pro Judgmnt
    D=Dependent
    I=Independent
    X=Dependent Reject
    Y=Independent Reject
    Z=Provisional Independent
    33 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
    34 PRORATE_BUDGET Character(1) VARCHAR2(1) NOT NULL Prorate Budget
    35 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    36 FA_UNIT_ANTIC Number(9,3) DECIMAL(8,3) NOT NULL Anticipated Units
    37 FA_UNIT_COMPLETED Number(9,3) DECIMAL(8,3) NOT NULL Completed Units
    38 FA_UNIT_IN_PROG Number(9,3) DECIMAL(8,3) NOT NULL In Progress Units
    39 FA_UNIT_CURRENT Number(9,3) DECIMAL(8,3) NOT NULL Current Units
    40 ACAD_PLAN_TYPE Character(3) VARCHAR2(3) NOT NULL Academic Plan Type
    CON=Concentration
    COS=Course of Study
    HON=Honors
    MAJ=Major
    MIN=Minor
    PRP=Preparation
    RTC=ROTC
    SP=Specialization
    41 FA_TERM_EFFDT Date(10) DATE Effective Date
    42 FA_TERM_EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    43 FA_LOAD_CURRENT Character(1) VARCHAR2(1) NOT NULL Current Load