SSR_FCINSTRENR1

(SQL View)
 Index Back

Instructor Class/Enrollment

Instructor Class/Student Enrollment View

SELECT DISTINCT A.STRM ,A.EMPLID ,C.INSTITUTION ,D.DESCR ,B.DESCR ,B.TERM_BEGIN_DT ,B.TERM_END_DT FROM PS_CLASS_INSTR A , PS_TERM_TBL B , PS_CLASS_TBL C , PS_INSTITUTION_TBL D WHERE A.CRSE_ID = C.CRSE_ID AND A.CRSE_OFFER_NBR = C.CRSE_OFFER_NBR AND A.STRM = C.STRM AND A.SESSION_CODE = C.SESSION_CODE AND A.CLASS_SECTION = C.CLASS_SECTION AND C.INSTITUTION = B.INSTITUTION AND C.INSTITUTION = D.INSTITUTION AND C.STRM = B.STRM AND C.ACAD_CAREER = B.ACAD_CAREER AND EXISTS ( SELECT 'X' FROM PS_STDNT_ENRL E WHERE E.ACAD_CAREER = C.ACAD_CAREER AND E.INSTITUTION = C.INSTITUTION AND E.STRM = C.STRM AND E.CLASS_NBR = C.CLASS_NBR)

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Default Value: OPR_DEF_TBL_CS.STRM

    Prompt Table: TERM_VAL_TBL

    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    4 INSTITUTION_DESCR Character(30) VARCHAR2(30) NOT NULL Institution
    5 TERM_DESCR30 Character(30) VARCHAR2(30) NOT NULL Term
    6 TERM_BEGIN_DT Date(10) DATE Term Begin Date
    7 TERM_END_DT Date(10) DATE Term Ending Date