STDNT_CAR_TE_VW

(SQL View)
 Index Back

Student Career Term Table View

This Student Career Term view is used to update the Financial Aid and Tuition recalculation flags if Academic Program data is changed. This view is also used to determine if it is appropriate to default Term and Institution to the operator specified values.

select emplid, acad_career, institution, strm, fa_stats_calc_req, tuit_calc_req, elig_to_enroll, withdraw_code, stdnt_car_nbr, acad_prog_primary, acad_load_appr, academic_load, fa_load, acad_level_proj, acad_level_bot, acad_level_eot, nslds_loan_year, ovrd_acad_lvl_proj, ovrd_acad_lvl_all, ovrd_max_units, max_total_unit, max_nogpa_unit, max_audit_unit, max_wait_unit, min_total_unit, unt_taken_prgrss, unt_trnsfr, trf_passed_gpa, trf_passed_nogpa, unt_test_credit, unt_other, tot_inprog_gpa, tot_inprog_nogpa, tot_cumulative, form_of_study, fa_eligibility, cur_resident_terms, pro_rata_eligible, fully_enrl_dt, enrl_on_trans_dt, stats_on_trans_dt, fully_graded_dt, tc_units_adjust from PS_STDNT_CAR_TERM

  • Parent record: STDNT_CAREER

    • # 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 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
    3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

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

    Prompt Table: TERM_TBL

    5 FA_STATS_CALC_REQ Character(1) VARCHAR2(1) NOT NULL FA Stats Calculation Required
    6 TUIT_CALC_REQ Character(1) VARCHAR2(1) NOT NULL Tuition Calc Required
    7 ELIG_TO_ENROLL Character(1) VARCHAR2(1) NOT NULL Eligible to Enroll
    8 WITHDRAW_CODE Character(3) VARCHAR2(3) NOT NULL Withdrawal \ Cancel
    CAN=Cancelled
    NWD=
    WDR=Withdrew
    9 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
    10 ACAD_PROG_PRIMARY Character(5) VARCHAR2(5) NOT NULL Primary Academic Program
    11 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
    12 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
    13 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
    14 ACAD_LEVEL_PROJ Character(3) VARCHAR2(3) NOT NULL Academic Level - Projected
    15 ACAD_LEVEL_BOT Character(3) VARCHAR2(3) NOT NULL Academic Level - Term Start
    16 ACAD_LEVEL_EOT Character(3) VARCHAR2(3) NOT NULL Academic Level - Term End
    17 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
    18 OVRD_ACAD_LVL_PROJ Character(1) VARCHAR2(1) NOT NULL Override Projected Level
    19 OVRD_ACAD_LVL_ALL Character(1) VARCHAR2(1) NOT NULL Override All Academic Levels
    20 OVRD_MAX_UNITS Character(1) VARCHAR2(1) NOT NULL Override Maximum Units
    21 MAX_TOTAL_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Max Total Units
    22 MAX_NOGPA_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Max No GPA Units
    23 MAX_AUDIT_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Max Audit Units
    24 MAX_WAIT_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Max Wait List Units
    25 MIN_TOTAL_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Min Total Units
    26 UNT_TAKEN_PRGRSS Number(9,3) DECIMAL(8,3) NOT NULL Units Taken for Progress
    27 UNT_TRNSFR Number(9,3) DECIMAL(8,3) NOT NULL Units Transferred
    28 TRF_PASSED_GPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer Passed for GPA
    29 TRF_PASSED_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer Passed Not for GPA
    30 UNT_TEST_CREDIT Number(9,3) DECIMAL(8,3) NOT NULL Units from Test Credit
    31 UNT_OTHER Number(9,3) DECIMAL(8,3) NOT NULL Units from Other Credit
    32 TOT_INPROG_GPA Number(9,3) DECIMAL(8,3) NOT NULL Total In Progress - GPA
    33 TOT_INPROG_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Total In Progress -Not for GPA
    34 TOT_CUMULATIVE Number(9,3) DECIMAL(8,3) NOT NULL Total Cumulative Units
    35 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
    36 FA_ELIGIBILITY Character(1) VARCHAR2(1) NOT NULL Program Eligibility Flag
    37 CUR_RESIDENT_TERMS Number(7,3) DECIMAL(6,3) NOT NULL Current In Residence Terms
    38 PRO_RATA_ELIGIBLE Character(1) VARCHAR2(1) NOT NULL Pro-Rata Eligible
    39 FULLY_ENRL_DT Date(10) DATE Fully Enrolled Date
    40 ENRL_ON_TRANS_DT Date(10) DATE Show Enrollment on Transcript
    41 STATS_ON_TRANS_DT Date(10) DATE Show Statistics on Transcript
    42 FULLY_GRADED_DT Date(10) DATE Fully Graded Date
    43 TC_UNITS_ADJUST Number(9,3) DECIMAL(8,3) NOT NULL Transfer Credits Units Adjustment