SEL_STDNOR2_VW

(SQL View)
 Index Back

Student Data Vw2 No Residency

This view is used to select by term the career, program, plan and residency status that a student is enrolled in.

select k.emplid ,k.institution ,k.strm ,k.billing_career ,k.acad_career ,' ' ,l.acad_prog ,a.acad_plan ,k.acad_level_proj ,k.acad_load_appr ,' ' ,l.campus from ps_stdnt_car_term k , ps_term_tbl c , ps_acad_prog l , PS_ACAD_PLAN a where c.institution = k.institution and c.acad_career = k.billing_career and c.strm = k.strm and l.emplid = k.emplid and l.acad_career = k.acad_career and l.stdnt_car_nbr = k.stdnt_car_nbr and l.effdt = (select max(g.effdt) from ps_acad_prog g where g.emplid = l.emplid and g.acad_career = l.acad_career and g.stdnt_car_nbr = l.stdnt_car_nbr and g.effdt <= c.term_begin_dt) and l.effseq = (select max(h.effseq) from ps_acad_prog h where h.emplid = l.emplid and h.acad_career = l.acad_career and h.stdnt_car_nbr = l.stdnt_car_nbr and h.effdt = l.effdt) and a.emplid = l.emplid and a.acad_career = l.acad_career and a.Stdnt_Car_Nbr = l.Stdnt_Car_Nbr and a.Effdt = l.Effdt and a.Effseq = l.Effseq

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    3 STRM Character(4) VARCHAR2(4) NOT NULL Term
    4 BILLING_CAREER Character(4) VARCHAR2(4) NOT NULL Billing Career
    5 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: ACAD_CAR_TBL

    6 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group
    7 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

    Prompt Table: ACAD_PROG_TBL

    8 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan

    Prompt Table: ACAD_PLAN_TBL

    9 ACAD_LEVEL_PROJ Character(3) VARCHAR2(3) NOT NULL Academic Level - Projected
    10 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
    11 TUITION_RES Character(5) VARCHAR2(5) NOT NULL Tuition Residency
    12 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus