SSR_INSTRCRS2VW

(SQL View)
 Index Back

Instructor Course View

This view lists the courses an instructor is approved to teach. It joins INSTR_CRSE with SCC_CUR_NM_VW2 and is used for prompting in self service enrollment.

SELECT a.INSTITUTION , a.ACAD_ORG , a.CAMPUS , a.SUBJECT ,t.acad_career ,t.strm , a.EMPLID , a.EFFDT , a.INSTR_CRSE_NBR , b.NAME , b.LAST_NAME_SRCH , b.FIRST_NAME_SRCH FROM PS_INSTR_CRSE a , PS_SCC_CUR_NM_VW2 b ,PS_INSTR_ADVISOR v ,ps_term_tbl t WHERE a.EMPLID = b.EMPLID AND a.EMPLID=v.EMPLID AND a.INSTITUTION=v.INSTITUTION AND a.EFFDT=v.EFFDT AND %EffdtCheck(INSTR_ADVISOR v1, v, t.term_Begin_dt) AND v.EFF_STATUS='A' AND v.INSTR_TYPE<>'ADV' AND v.INSTR_AVAILABLE='A' AND a.institution = t.institution

  • Parent record: INSTR_ADVISOR

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

    Prompt Table: INSTITUTION_TBL

    2 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization

    Prompt Table: ACAD_ORG_TBL_VW

    3 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus

    Prompt Table: CAMPUS_TBL

    4 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area

    Prompt Table: SUBJECT_TBL

    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
    6 STRM Character(4) VARCHAR2(4) NOT NULL Term
    7 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    8 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    9 INSTR_CRSE_NBR Number(3,0) SMALLINT NOT NULL Instructor Course Sequence Nbr
    10 NAME Character(50) VARCHAR2(50) NOT NULL Name
    11 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    12 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name