STDNTTERMBDGLNG

(SQL Table)
 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.

  • Related Language Record for STDNT_TERM_BDGT

  • 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 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    7 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    8 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    9 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: BUDGET_GRP_TBL.DESCR