STDNT_CAR_I_VW3

(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 , B.DESCR FROM PS_STDNT_CAR_TERM A , PS_INSTITUTION_TBL B WHERE A.INSTITUTION = B.INSTITUTION AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_INSTITUTION_TBL B1 WHERE B.INSTITUTION = B1.INSTITUTION AND B1.EFFDT <= %CurrentDateIn)

  • Related Language Record: STDNTCARIVW3LNG

  • 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

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description