STDNT_BDGT_ABVW

(SQL View)
 Index Back

Student Budget Asgn View

This view selects student who are being assigned a budget via the batch process.

SELECT EMPLID , INSTITUTION , AID_YEAR , STRM , PROCESSING_MODE , TERM_TYPE , ACAD_PROG_PRIMARY , ACAD_CAREER , ACAD_PLAN , ACAD_SUB_PLAN , ACADEMIC_LOAD , ACAD_LOAD_APPR , ACAD_LEVEL_PROJ , ACAD_LEVEL_BOT , FA_LOAD , FORM_OF_STUDY , RESIDENCY , FIN_AID_FED_RES , FIN_AID_ST_RES , FIN_AID_FED_EXCPT , FIN_AID_ST_EXCPT , STATE_RESIDENCE , APP_STATE_RESIDENC , POSTAL , HOUSING_TYPE , MARITAL_STAT , NUMBER_IN_FAMILY , DEPNDNCY_STAT , NSLDS_LOAN_YEAR , BUDGET_GROUP_CODE , PRORATE_BUDGET , BUDGET_STATUS , CAMPUS , CAMPUS_FA , UNT_TAKEN_FA , UNT_TAKEN_FA_CL , INTERESTED_IN_PLUS , INTERESTED_IN_SL , ENROLL_CURNT_SUM , ENROLL_FALL , ENROLL_NEXT_SUM , ENROLL_SPRING , ENROLL_WINTER , SRVC_IND_DTTM , SRVC_IND_CD , REFUND_PCT , REFUND_SCHEME , REFUND_SETID , REFUND_CLASS , ADVISOR_ROLE , ADVISOR_ID , COMMITTEE_ID , WEEKS_OF_INSTRUCT , START_DATE , END_DATE , STUDY_AGREEMENT , EXT_ORG_ID , COUNTRY , ACAD_GROUP_ADVIS , ADMIT_TERM , STDNT_GROUP , SPORT1 , SPORT2 , SPORT3 , SPORT4 , ATHL_PARTIC_CD1 , ATHL_PARTIC_CD2 , ATHL_PARTIC_CD3 , ATHL_PARTIC_CD4 , CUR_PARTICIPANT1 , CUR_PARTICIPANT2 , CUR_PARTICIPANT3 , CUR_PARTICIPANT4 , FA_NUMBER_OF_WEEKS , COURSE_LD_PCT , FA_UNIT_ANTIC , FA_UNIT_COMPLETED , FA_UNIT_IN_PROG , FA_UNIT_CURRENT , FA_LOAD_CURRENT , ACAD_PLAN_TYPE , FA_TERM_EFFDT , FA_TERM_EFFSEQ FROM PS_STDNT_BDGT_ASGN WHERE PROCESSING_MODE = 'B'

  • 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: STUDENT_AID

    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: AID_YEAR_TBL

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

    Prompt Table: TERM_VAL_TBL

    5 PROCESSING_MODE Character(1) VARCHAR2(1) NOT NULL This field is used to store the mode of processing, batch or online, for Student Budgets.
    B=Batch Mode
    O=Online Mode
    6 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
    7 ACAD_PROG_PRIMARY Character(5) VARCHAR2(5) NOT NULL Primary Academic Program

    Prompt Table: ACAD_PRGFA_CRVW

    8 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
    9 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan

    Prompt Table: ACAD_PLAN_TBL

    10 ACAD_SUB_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Sub-Plan

    Prompt Table: ACAD_SUBPLN_TBL

    11 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
    12 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
    13 ACAD_LEVEL_PROJ Character(3) VARCHAR2(3) NOT NULL Academic Level - Projected

    Prompt Table: ACAD_LEVEL_TBL

    14 ACAD_LEVEL_BOT Character(3) VARCHAR2(3) NOT NULL Academic Level - Term Start

    Prompt Table: ACAD_LEVEL_TBL

    15 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
    16 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
    17 RESIDENCY Character(5) VARCHAR2(5) NOT NULL Residency

    Prompt Table: RESIDENCY_TBL

    18 FIN_AID_FED_RES Character(5) VARCHAR2(5) NOT NULL Fin Aid Federal Residency

    Prompt Table: RESIDENCY_TBL

    19 FIN_AID_ST_RES Character(5) VARCHAR2(5) NOT NULL Fin Aid State Residency

    Prompt Table: RESIDENCY_TBL

    20 FIN_AID_FED_EXCPT Character(5) VARCHAR2(5) NOT NULL Fin Aid Fed Residency Excpt

    Prompt Table: RESID_EXCPT_TBL

    21 FIN_AID_ST_EXCPT Character(5) VARCHAR2(5) NOT NULL Fin Aid St Residency Excpt

    Prompt Table: RESID_EXCPT_TBL

    22 STATE_RESIDENCE Character(6) VARCHAR2(6) NOT NULL State of Residence

    Prompt Table: HCR_ST_NM_VW_I

    23 APP_STATE_RESIDENC Character(2) VARCHAR2(2) NOT NULL Application State Residence

    Prompt Table: HCR_ST_NM_VW_I

    24 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    25 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
    26 MARITAL_STAT Character(1) VARCHAR2(1) NOT NULL Marital Status
    1=Single
    2=Married
    3=Separated
    4=Divorced
    5=Widowed
    27 NUMBER_IN_FAMILY Character(2) VARCHAR2(2) NOT NULL Nbr Family Members
    28 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
    29 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
    30 BUDGET_GROUP_CODE Character(6) VARCHAR2(6) NOT NULL Budget Group Code

    Prompt Table: BUDGET_GRP_TBL

    31 PRORATE_BUDGET Character(1) VARCHAR2(1) NOT NULL Prorate Budget
    32 BUDGET_STATUS Character(1) VARCHAR2(1) NOT NULL Process Status
    S=Selected
    33 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus

    Prompt Table: CAMPUS_TBL

    34 CAMPUS_FA Character(5) VARCHAR2(5) NOT NULL FA Campus

    Prompt Table: CAMPUS_TBL

    35 UNT_TAKEN_FA Number(9,3) DECIMAL(8,3) NOT NULL Fin Aid Progress Units Taken
    36 UNT_TAKEN_FA_CL Number(9,3) DECIMAL(8,3) NOT NULL Units Taken FA Calculated
    37 INTERESTED_IN_PLUS Character(1) VARCHAR2(1) NOT NULL Interested In PLUS
    1=Yes
    2=No
    38 INTERESTED_IN_SL Character(1) VARCHAR2(1) NOT NULL Interested In Student Loans
    1=Yes
    2=No
    39 ENROLL_CURNT_SUM Character(1) VARCHAR2(1) NOT NULL Enroll Plan for Current Sumr
    1=Full Time
    2=3/4 Time
    3=1/2 Time
    4=LT 1/2 Time
    5=Not Attending
    40 ENROLL_FALL Character(1) VARCHAR2(1) NOT NULL Enroll Plan for Fall
    1=Full Time
    2=3/4 Time
    3=1/2 Time
    4=LT 1/2 Time
    5=Not Attending
    41 ENROLL_NEXT_SUM Character(1) VARCHAR2(1) NOT NULL Enroll Plan for Next Sumr
    1=Full Time
    2=3/4 Time
    3=1/2 Time
    4=LT 1/2 Time
    5=Not Attending
    42 ENROLL_SPRING Character(1) VARCHAR2(1) NOT NULL Enroll Plan for Spring
    1=Full Time
    2=3/4 Time
    3=1/2 Time
    4=LT 1/2 Time
    5=Not Attending
    43 ENROLL_WINTER Character(1) VARCHAR2(1) NOT NULL Enroll Plan for Winter
    1=Full Time
    2=3/4 Time
    3=1/2 Time
    4=LT 1/2 Time
    5=Not Attending
    44 SRVC_IND_DTTM DateTime(26) TIMESTAMP Service Indicator Date-Time field
    45 SRVC_IND_CD Character(3) VARCHAR2(3) NOT NULL Service Indicator Cd

    Prompt Table: SRVC_IND_CD_TBL

    46 REFUND_PCT Number(6,2) DECIMAL(5,2) NOT NULL Refund Percentage
    47 REFUND_SCHEME Character(8) VARCHAR2(8) NOT NULL Refund Scheme

    Prompt Table: ADJ_RFND_SCM_VW

    48 REFUND_SETID Character(5) VARCHAR2(5) NOT NULL Refund SetID

    Prompt Table: SETID_TBL

    49 REFUND_CLASS Character(1) VARCHAR2(1) NOT NULL Refund Classification
    A=Accreditting Agency
    F=Federal
    I=Institutional
    O=Override
    P=Pro-Rata
    S=State
    T=Fee Table
    50 ADVISOR_ROLE Character(4) VARCHAR2(4) NOT NULL Advisor Role
    ADVR=Advisor
    QEC=Qualifying Exam Committee
    THES=Thesis Committee
    51 ADVISOR_ID Character(11) VARCHAR2(11) NOT NULL This field is used to identify advisors assigned to a student.

    Prompt Table: INSTR_ADVSR_VW

    52 COMMITTEE_ID Character(6) VARCHAR2(6) NOT NULL Committee

    Prompt Table: COMMITTEE_TBL

    53 WEEKS_OF_INSTRUCT Number(2,0) SMALLINT NOT NULL Weeks of Instruction
    54 START_DATE Date(10) DATE Start Date for Gen Standing PO
    55 END_DATE Date(10) DATE End Date
    56 STUDY_AGREEMENT Character(10) VARCHAR2(10) NOT NULL Study Agreement

    Prompt Table: STUDY_AGRM_TBL

    57 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Prompt Table: EXT_ORG_TBL

    58 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    59 ACAD_GROUP_ADVIS Character(5) VARCHAR2(5) NOT NULL Academic Group of Advisor

    Prompt Table: ACAD_GROUP_TBL

    60 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL Admit Term

    Prompt Table: TERM_VAL_TBL

    61 STDNT_GROUP Character(4) VARCHAR2(4) NOT NULL Student Group

    Prompt Table: STDNT_GROUP_TBL

    62 SPORT1 Character(3) VARCHAR2(3) NOT NULL Sport 1
    BA=Baseball
    BB=Basketball
    CC=Cross Country
    CR=Crew
    FB=Football
    GO=Golf
    GY=Gymnastics
    IT=Indoor Track
    NO=None
    OT=Outdoor Track
    SB=Softball
    SO=Soccer
    SW=Swimming
    TH=Tennis
    TR=Track
    UN=Unknown
    VB=Volleyball
    WP=Water Polo
    WR=Wrestling
    63 SPORT2 Character(3) VARCHAR2(3) NOT NULL Sport 2
    BA=Baseball
    BB=Basketball
    CC=Cross Country
    CR=Crew
    FB=Football
    GO=Golf
    GY=Gymnastics
    IT=Indoor Track
    NO=None
    OT=Outdoor Track
    SB=Softball
    SO=Soccer
    SW=Swimming
    TN=Tennis
    TR=Track
    UN=Unknown
    VB=Vollyball
    WP=Water Polo
    WR=Wrestling
    64 SPORT3 Character(3) VARCHAR2(3) NOT NULL Sport 3
    BA=Baseball
    BB=Basketball
    CC=Cross Country
    CR=Crew
    FB=Football
    GO=Golf
    GY=Gymnastics
    IT=Indoor Track
    NO=None
    OT=Outdoor Track
    SB=Softball
    SO=Soccer
    SW=Swimming
    TN=Tennis
    TR=Track
    UN=Unknown
    VB=Vollyball
    WP=Water Polo
    WR=Wrestling
    65 SPORT4 Character(3) VARCHAR2(3) NOT NULL Sport4
    BA=Baseball
    BB=Basketball
    CC=Cross Country
    CR=Crew
    FB=Football
    GO=Golf
    GY=Gymnastics
    IT=Indoor Track
    NO=None
    OT=Outdoor Track
    SB=Softball
    SO=Soccer
    SW=Swimming
    TN=Tennis
    TR=Track
    UN=Unknown
    VB=Vollyball
    WP=Water Polo
    WR=Wrestling
    66 ATHL_PARTIC_CD1 Character(5) VARCHAR2(5) NOT NULL Ath Partic Cd 1

    Prompt Table: ATHL_PART_TBL

    67 ATHL_PARTIC_CD2 Character(5) VARCHAR2(5) NOT NULL Ath Partic CD 2

    Prompt Table: ATHL_PART_TBL

    68 ATHL_PARTIC_CD3 Character(5) VARCHAR2(5) NOT NULL Ath Partic CD 3

    Prompt Table: ATHL_PART_TBL

    69 ATHL_PARTIC_CD4 Character(5) VARCHAR2(5) NOT NULL Athl Partic 4

    Prompt Table: ATHL_PART_TBL

    70 CUR_PARTICIPANT1 Character(1) VARCHAR2(1) NOT NULL Cur partic 1

    Prompt Table: HCR_XL_PSYSNO_I

    71 CUR_PARTICIPANT2 Character(1) VARCHAR2(1) NOT NULL Cur Partic 2

    Prompt Table: HCR_XL_PSYSNO_I

    72 CUR_PARTICIPANT3 Character(1) VARCHAR2(1) NOT NULL Cur Partic 3

    Prompt Table: HCR_XL_PSYSNO_I

    73 CUR_PARTICIPANT4 Character(1) VARCHAR2(1) NOT NULL Cur Partic 4

    Prompt Table: HCR_XL_PSYSNO_I

    74 FA_NUMBER_OF_WEEKS Number(3,0) SMALLINT NOT NULL FA Number of Weeks
    75 COURSE_LD_PCT Number(6,2) DECIMAL(5,2) NOT NULL Course Load Pct
    76 FA_UNIT_ANTIC Number(9,3) DECIMAL(8,3) NOT NULL Anticipated Units
    77 FA_UNIT_COMPLETED Number(9,3) DECIMAL(8,3) NOT NULL Completed Units
    78 FA_UNIT_IN_PROG Number(9,3) DECIMAL(8,3) NOT NULL In Progress Units
    79 FA_UNIT_CURRENT Number(9,3) DECIMAL(8,3) NOT NULL Current Units
    80 FA_LOAD_CURRENT Character(1) VARCHAR2(1) NOT NULL Current Load
    81 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
    82 FA_TERM_EFFDT Date(10) DATE Effective Date
    83 FA_TERM_EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence