STDNT_CAR_I_VW4

(SQL View)
 Index Back

Student Career Inst View

This table contains student information by Academic Career, Institution and Term. To have an entry in this table, the student must have at least one entry in the Academic Program table.

SELECT DISTINCT A.EMPLID , A.INSTITUTION , A.ACAD_CAREER , B.DESCR FROM PS_STDNT_CAR_TERM A , PS_ACAD_CAR_TBL B WHERE A.INSTITUTION = B.INSTITUTION AND A.ACAD_CAREER = B.ACAD_CAREER AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_ACAD_CAR_TBL B1 WHERE B1.INSTITUTION = B.INSTITUTION AND B1.ACAD_CAREER = B.ACAD_CAREER AND B1.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS <> 'I'

  • Related Language Record: STDNT_CARVW4_LN

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